Re: ORA-12547: TNS:lost contact

lukehinds_at_gmail.com wrote:
> Hi *,
>
> I applied the 9.2.0.6 patch to one of our database servers, running
> 9.2.0.4.
>
> The installation completed without any errors (i used a response file
> with the silent option).
>
> When i now try to connect to the instance as sys or system i get the
> following:
>
> user_at_host:lib [15] sqlplus "/as sysdba"
>
> user_at_host:lib [16] echo $ORACLE_SID
>
> planet
>
> SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jul 29 04:26:05 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> ld.so.1: oracle: fatal: libodm9.so: open failed: No such file or
> directory
>
> ERROR:
>
> ORA-12547: TNS:lost contact
>
> user_at_host:lib [17] tnsping planet
>
> TNS Ping Utility for Solaris: Version 9.2.0.6.0 - Production on
> 29-JUL-2005 04:27:50
>
> Copyright (c) 1997 Oracle Corporation. All rights reserved.
>
> Used parameter files:
>
> Used TNSNAMES adapter to resolve the alias
>
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA =
> (SERVICE_NAME = planet)))
>
> OK (40 msec)
>
> user_at_planet:lib [19] ls -al libodm9.so
> lrwxrwxrwx 1 oracle dba 11 Jun 3 2003 libodm9.so ->
> libodmd9.so
>
> Thank in advance for any help.
>
> Luke

You failed to check the following environment variables:

ORACLE_HOME
ORACLE_BASE
LD_LIBRARY_PATH Are these correct? Also, check the permissions on $ORACLE_HOME/bin/oracle:

-rwsr-s--x 1 oracle dba 69458568 Jul 26 03:04 oracle

It truly appears this is a path issue, and the mentioned environment variables should be verified. Without further information, such as the O/S and version, it's difficult to tell you more. Also, I've not used the 'silent' install for patches, thus I am not familiar with what this accomplishes or leaves undone. I've patched my Oracle installation on Solaris 10 to 9.2.0.6 and have had no issues.

David Fitzjarrell Received on Fri Jul 29 2005 - 09:48:50 CDT