Oracle Error-TNS no Listner in TOAD

I have installed Oracle 9i on my PC and able to logon in SQL plus without the host string part. The user name and the password are 'scott' and 'tiger'. When ever I put my host string 'ORAP' it gives an error message ' ORA-12541- TNS No Listner'. I have started all the services and the tnsnames.ora file is also fine.

I installed the third party tool TOAD. Although I'm able to logon in SQL plus without the host string I'm unable to logon in TOAD without the database. Can anyone suggest a remedy for this?

Here is the entry for my tnsnames.ora file.

ORAP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = your-e659457a65)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORAP)
)
)

re: Oracle Error-TNS no Listner in TOAD

Are you sure your-e659457a65 is the host name.

re: Oracle Error-TNS no Listner in TOAD

Yes The host name is correct, I checked in System Properties under Control pannel.

re: Oracle Error-TNS no Listner in TOAD

Hi,

Does your Net Configuration Test Successfully..?
I'am using Oracle 9i, My TNSnames.ora reads something like this :

SNAME.DOMNAME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVRNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SNAME)
)
)


Regards
Veena

re: Oracle Error-TNS no Listner in TOAD

Yes Net Configuration is fine.

re: Oracle Error-TNS no Listner in TOAD

Hi,

Check If This Can Help You

Regards
Veena

re: Oracle Error-TNS no Listner in TOAD

Thanks, I have already started the TNSLISTNER.... TOAD and SQL PLUS were working fine for me. I formatted my PC few Days ago. This Problem occured after the reinstalloation of 9i and TOAD.

I can't imagine why TOAD is not working without database name(HOST String) whlist SQL plus is working without the host string.

I'm in an urgent situation to sort out this problem. Because It is an headache to write PL/SL Programs in SQL Plus. I tried with SQL Navigator as well, But stil the same result