Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: TNS error after installing 8.0.5 on RedHat Linux 5.2

Re: TNS error after installing 8.0.5 on RedHat Linux 5.2

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 28 May 1999 18:42:50 +0200
Message-ID: <927909669.7052.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US