Board index Oracle

TNS error after installing 8.0.5 on RedHat Linux 5.2

TNS error after installing 8.0.5 on RedHat Linux 5.2

Post by Scott Thomas » Sat, 29 May 1999 04:00:00



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')
    )
  )

 
 
 
Top

TNS error after installing 8.0.5 on RedHat Linux 5.2

Post by Scott Thomas » Sat, 29 May 1999 04:00:00


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')
    )
  )

 
 
 
Top

TNS error after installing 8.0.5 on RedHat Linux 5.2

Post by Sybrand Bakke » Sat, 29 May 1999 04:00:00


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


>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')
>    )
>  )

 
 
 
Top

TNS error after installing 8.0.5 on RedHat Linux 5.2

Post by Fre » Sun, 30 May 1999 04:00:00




Quote:>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

I had the same problem and Oracle told me to do a lsnrctl stop, delete
any listener trace or log files, and re-link the networking libraries:

cd $ORACLE_HOME/network/lib
make -f ins_network.mk install

 
 
 
Top

1. sybase/redhat linux 5.2 install problem- port 7100 definition - sybase-problem.doc (0/1)

I installed the sybase rpm on redhat linux 5.2.  I followed
intructions on installing and configuring the adaptive server.
The example interface file uses port 7100 so I did too.
I can run startserver ok. But then when I try
isql -S myservername
I get error
"Unknown network type found in interface file"
The interface file has the line
myservername master tcp ether myhostrname 7100
Is port 7100 the correct port to use.
Is there anything I have to do to have port 7100 defined and ready for
use?  I tried adding 7100 to /etc services but that was not enough.
Any help will be greatly appreciated.  Once up and running I may be
able to help others.

2. User Group info. wanted

3. Redhat Linux 5.2 Install

4. Database connection without ODBC

5. d3 linux with redhat 6.0 vs redhat 5.2

6. ODBC VB4 Paradox7 Help!!!!

7. Redhat 5.2 Linux Error &Oracle 8.0.5

8. Oracle memory leaks under Linux RedHat 5.2

9. Newbe: Oracle 8 on Redhat Linux 5.2

10. ORA-12709: installation on Linux RedHat 5.2

11. Returning Only 1 Record....(Redhat Linux 5.2)

12. Universe and Redhat Linux 5.2


All times are UTC
Board index