Re: Listener not listening ?

"Dooban" <doobas_at_terra.com> wrote in message news:Xns914DB93E7DAAremovedoobanterraes_at_194.179.8.156...
> C:\ORACLE\ORA81 -> Oracle 8.1.7
> C:\ORACLE\DEV6i -> Designer & Developer
>
> Path is first pointing to C:\ORACLE\ORA81.
>
> I have a tnsnames.ora in both ORACLE\ORA81 AND DEV6i. Both of them are the
> same file. The same applies for tnsnames.ora.
>
> TNSNAMES.ORA
>
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> )
> )
>
>
> LISTENER.ORA
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> (CONNECT_DATA =
> (SID = orcl)
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = Oracle8)
> (SID_NAME = orcl)
> )
> )
>
> C:\ORACLE\ORA81\BIN\TNSPING ORCL returns:
>
> Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))
> TNS-12541: TNS:no listener.
>
> C:\ORACLE\ORA81\BIN\SQLPLUSW SCOTT/TIGER_at_ORCL
>
> is able to get into the database. If I stop the listener and launch the
same
>
> C:\ORACLE\ORA81\BIN\SQLPLUSW SCOTT/TIGER_at_ORCL
>
> I get the following message:
>
> ERROR:
> ORA-12541: TNS:no listener
>
>
> I have enabled sqltracing but the resulting file is cryptic to me is about
> 134kb, making is even more cryptical (if possible).
>
> Thanks for the help and your time.
>
>
> p.d. Roel. Copying the files just as you said didnīt work either. I think
> the problem has to do with the listener.

Please zip the trace file up and e-mail it to me. I have dealt with similar issues before and I can read the output.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address