Re: TNS Listner could not resolve Service_Name

di_marcello_at_hotmail.com wrote:

> Dear all,
>
> i 'am a newbee for oracle,
> I have one problem after creating the database (8i): i want to connect using
> the database manager to create a table space, but when i want to connect i
> get the error message: TNS Listner could not resolve Service_Name giving in
> connect discruptor.
>
> What am i doing wrong here?
>
> Thanks for helping me.
> greetings di_marcello_at_hotmail.com

From what you have posted it is impossible to tell whether you are doing anything wrong other than providing minimal information. Knowing your operating system would be very helpful but assuming Windows ...

Go to the Oracle BIN directory and type the following:

lsnrctl status

If the listener is started the output from the above command will give you the time it has been up in hours, minutes, seconds. If not you may see an error message. Write it down (all of it).

If the listener is not started try starting it manually:

lsnrctl start

It will either start (something you can verify but waiting 10 seconds and running lsnrctl status) or you will get an error message.

Assuming the listener is started look in the Oracle subdirectory in \network\admin for the files listener.ora, sqlnet.ora, and tnsnames.ora. Are they there? Open tnsnames.ora using notepad. Is there a listing in there for your Oracle database on your machine?

Daniel Morgan Received on Tue Jan 07 2003 - 10:30:06 CST