Re: Listener not listening ?

From: Dooban <doobas_at_terra.com>
Date: 2 Nov 2001 00:00:48 GMT
Message-ID: <Xns914DB93E7DAAremovedoobanterraes@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. Received on Thu Nov 01 2001 - 18:00:48 CST