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

In our last gripping episode 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.
>

Have you relinked the executables? There should be a script to perform that action with the patch software.

If you have then an error occurred during the relink and an executable file could not be generated. There should be an installation/patch log somewhere that lists actions taken and the results and/or errors encountered.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.