TNS-01201 Can't find Oracle executable; Configuring tnsnames.ora and listener.ora

Home -> Community -> Usenet -> c.d.o.server -> TNS-01201 Can't find Oracle executable; Configuring tnsnames.ora and listener.ora

From: <charlie20000_at_my-deja.com>
Date: Mon, 04 Dec 2000 13:25:15 GMT
Message-ID: <90g5vm$rus$1@nnrp1.deja.com>

I have installed Oracle 8.1.5 to my home linux system (together with the linux_815patches.tgz patch) and am trying to setup a database but can't connect. I am receiving a TNS-01201 error (see below).

I checked $ORACLE_HOME/bin and the "oracle" executable is not there although a filed called "oracle.pre-81502*" is there. I assume this to be the oracle executable prior to my installing the linux_815patches.tgz patch. I copied "oracle.pre-81502" to "oracle" and the listener did work (see the readout below) but still can't connect to the database, receiving a
ORA-12547: TNS:lost contact error, along with some messages relating to loading shared libraries (see below). I am wondering if the patch did not work correctly. I tried reinstalling the patch but this did not help. Any suggestions would be greatly appreciated! I checked all Oracle documentation and searched usenet but couldn't find anything helpful.

Also could this be related to whether I have my listener.ora and tnsnames.ora files configured properly? I had a hard time getting them to work. Please comment on whether these files are configured properly (see below) and a post of simple sample listener.ora and tnsnames.ora files for localhost access would be greatly appreciated. Thanks.

(Output Follows Below)

Receive the following error when I start up the listener:

LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 04-DEC-00 07:01:30

Starting /u01/app/oracle/product/8.1.5/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.1.5.0.0 - Production System parameter file is
/u01/app/oracle/product/8.1.5/network/admin/listener.ora
Log messages written to
/u01/app/oracle/product/8.1.5/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) Listening on: (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) TNS-01201: Listener cannot find executable
/u01/app/oracle/product/8.1.5/bin/oracle for SID ora1

when I rename $ORACLE_HOME/oracle.pre-81502 to "oracle" I get the following:

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.1.5.0.0 -
Production
Start Date                04-DEC-00 07:07:05
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/u01/app/oracle/product/8.1.5/network/admin/listener.ora
Listener Log File
/u01/app/oracle/product/8.1.5/network/log/listener.logServices
Summary...
ora1 has 1 service handler(s) The command completed successfully

when I then start up svrmgrl I get the following error:

Oracle Server Manager Release 3.1.5.0.0 - Production

oracleora1: error in loading shared libraries: libobk.so: cannot read file data: No such file or directory
oracleora1: error in loading shared libraries: libobk.so: cannot read file data: No such file or directory
ORA-12547: TNS:lost contact

MY TNSNAMES.ORA file:

ora1 =
DESCRIPTION =
( (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SID = ora1))
)

MY LISTENER.ORA file

#LISTENER =
# (ADDRESS =

#(PROTOCOL = TCP)
#(PORT = 1521)
#(HOST=127.0.0.1)
#)

SID_LIST_LISTENER=
(SID_LIST =
( SID_DESC =

      ((GLOBAL_DBNAME = )
      (ORACLE_HOME = /u01/app/oracle/product/8.1.5)
      (SID_NAME = ora1)

))

TRACE_LEVEL_LISTENER = OFF [[NOTE: I commented the first couple of lines of the listener.ora file out because I was getting some error saying I wasn't putting in correct address. So I just used the default. ]]

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 04 2000 - 07:25:15 CST