Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TNS error after installing 8.0.5 on RedHat Linux 5.2
Hi Scott
First of all, lsnrctl shouldn't be run from root. It should be run from the
Oracle owner only.
Secondly, in order to isolate your problems further, you can change the
level of trace_level_listener from OFF or USER to 16. This will dump every
call and every error message to the listener trace file.
Hth,
Sybrand Bakker, Oracle DBA
Scott Thomason wrote in message <374e272d.123865523_at_news.wcf.net>...
>After installing Oracle 8.0.5 on RedHat 5.2, I'm having trouble
>starting and/or stopping the listener. I get messages like the ones
>below. Interestingly, the installer-launched listener worked (I
>connected to it via a W95 client).
>
>
>Output from 'lsnrctl status' (executed from root):
>=======================================
>LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 27-MAY-99
>23:53:59
>
>(c) Copyright 1997 Oracle Corporation. All rights reserved.
>
>Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ora1))
>TNS-12224: TNS:no listener
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> Linux Error: 2: No such file or directory
>Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
>TNS-12224: TNS:no listener
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> Linux Error: 2: No such file or directory
>Connecting to
>(ADDRESS=(PROTOCOL=TCP)(Host=payday.2tpi.com)(Port=1521))
>TNS-12224: TNS:no listener
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> Linux Error: 111: Connection refused
>
>
>
>$ORACLE_HOME/network/admin/listener.ora:
>========================================
>#
># Installation Generated Net8 Configuration
># Version Date: Jun-17-97
># Filename: Listener.ora
>#
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= IPC)(KEY= ora1))
> (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
> (ADDRESS= (PROTOCOL= TCP)(Host= payday.2tpi.com)(Port= 1521))
> )
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= payday.2tpi.com.)
> (ORACLE_HOME= /ora/app/oracle/product/8.0.5)
> (SID_NAME = ora1)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (ORACLE_HOME = /ora/app/oracle/product/8.0.5)
> (PROGRAM = extproc)
> )
> )
>STARTUP_WAIT_TIME_LISTENER = 0
>CONNECT_TIMEOUT_LISTENER = 10
>TRACE_LEVEL_LISTENER = OFF
>
>
>
>$ORACLE_HOME/network/admin/tnsnames.ora:
>==========================================
>#
># Installation Generated Net8 Configuration
># Version Date: Oct-27-97
># Filename: Tnsnames.ora
>#
>extproc_connection_data =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = ora1))
> (CONNECT_DATA = (SID = extproc))
> )
>
>ora1 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= payday.2tpi.com)(Port= 1521))
> (CONNECT_DATA = (SID = ora1))
> )
>
>ora1_BEQ =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
>/ora/app/oracle/product/8.0.5)
> (argv0 = oracleora1)
> (args = '(DESCRIPTION =
>(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
> (envs =
>'ORACLE_HOME=/ora/app/oracle/product/8.0.5,ORACLE_SID=ora1')
> )
> )
>
Received on Fri May 28 1999 - 11:42:50 CDT
![]() |
![]() |