TNS-01201 Can't find Oracle executable; Configuring tnsnames.ora and listener.ora
charli...@my-deja.com
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.
David Fitzjarrell
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
Alexey Pashchenko
point to directory with shared libraries)
2. Try relink your oracle products with script
$ORACLE_HOME/install/utl/linux.sh.
charli...@my-deja.com
charli...@my-deja.com wrote:
>
> ******************************************************************
> 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
>
I found the solution to the above on another post - I reinstalled 8.1.5
(on my Mandrake 7.2 system) using a typical install and not choosing
the create database option. I then got the "libobk.so" error. I solved
that by following the instructions below. Then I installed the
linux_815patches.tgz file. Here is the libobk.so solution (zip did not
work for me, I had to use fastjar which you can download from
www.redhat.com):
Subject: Re: libobk.so -> libdsbtsh8.so missing
From: Martin.H...@0800-einwahl.de
Date: 2000/02/19
Newsgroups: comp.databases.oracle.server
Many thanks, worked great after I used "zip lib.0.1.jar libdsbtsh8.so"
instead
of jar because jar was not in my path.
Martin
ykhogaly wrote:
>
> You can apply the following work around :
>
> 1) % cd
<mountpoint>/stage/Components/oracle/rdbms/8.1.5.0.0/1/DataFiles
>
> 2) % cp lib.0.1.jar $ORACLE_HOME/lib
>
> 3) % cd $ORACLE_HOME/lib
>
> 4) % jar xf lib.0.1.jar libdsbtsh8.so
>
> There now should be a libdsbtsh8.so in "$ORACLE_HOME/lib" with a
file size
> other than 0.
>
> 5) % rm libobk.so
>
> 6) % ln -s libdsbtsh8.so libobk.so
>
> 7) Relink oracle:
>
> % cd $ORACLE_HOME/rdbms/lib
> % make -f ins_rdbms.mk install
>
> Regards
>
> "The Views expressed here are my own and not necessarily those of
Oracle
> Corporation"
>
> "Martin Haltmayer" <Martin.H...@0800-einwahl.de> wrote in message
> news:38AB402C...@0800-einwahl.de...
> > I installed Oracle 8.1.5 EE for Linux with the patch of SuSE 6.3
> >
> > But the shared library $ORACLE_HOME/lib/libobk.so is empty (it is a
> > symbolic link to $ORACLE_HOME/lib/libdsbtsh8.so). I cannot start
> > sqlplus.
> >
> > Can someone please tell me where I can fill this library from?
> >
> > Martin