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

1. Make sure you set environment variable LD_LIBRARY_PATH correctly. (This point to directory with shared libraries)
2. Try relink your oracle products with script $ORACLE_HOME/install/utl/linux.sh.

charlie20000_at_my-deja.com wrote:

> 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
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> 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:
> ***********************************************************
>
> 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))
>
> 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
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> 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 Tue Dec 05 2000 - 00:16:24 CST