Hi, more details required what is the version of database creating manually means, using scripts or dbca check the dbca tool logfile for more clues you might as well try by first creating the service name using the netca Thanks Anand ----- Original Message ----- From: NEELI-SC, Mamta To: ora-apps-dba@xxxxxxxxxxxxx Sent: Wednesday, April 15, 2009 7:49 AM Subject: RE: Reg:create-oracle-9i-database-in-windows-manually Hi Harish, Thanks for your updates. I have checked these already.. L Everything is fine. Thanks Mamta ------------------------------------------------------------------------------ From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Harish Muramshetty Sent: Wednesday, 15 April 2009 12:45 To: ora-apps-dba@xxxxxxxxxxxxx Cc: oracle-apps-l@xxxxxxxxxxxxxxxxxxxx Subject: Re: Reg:create-oracle-9i-database-in-windows-manually Hi, Check the listener file and sqlnet.ora file. Make sure - In Sqlnet.ora file NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) Regards, Harish. On Wed, Apr 15, 2009 at 4:36 AM, NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx> wrote: Hello DBA, I'm trying to create a database manually on windows. I'm receiving ORA-12154: TNS:could not resolve service name error I have created the new service. Can anyone suggest me please? Thanks Mamta