Home » RDBMS Server » Networking and Gateways » ora -12547 TNS: lost contact
ora -12547 TNS: lost contact [message #152318] Thu, 22 December 2005 08:28 Go to next message
oradba16
Messages: 54
Registered: September 2005
Member
HI,
i am using Oracle 8.1.7 running on solaris 8. I can not get into svrmgrl or sqlplus due to the above error ld.So.1: libskgxp8.so: open failed: no such file or directory
ora -12547 TNS: lost contact

THIS IS MY LISTENER AND TNSNAMES WHAT I CONFIGURED

LISTENER.ORA
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Rajesh)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = kesd)
(ORACLE_HOME = /export/home/oracle/OraHome1)
)
)

TNSNAMES.ORA
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

WHEN I CHECK THE LISTENER STATUS IT IS SHOWING LISTENER IS UP BUT NO SERVICE HANDLING BY IT.

EVEN I HAV SET THE LIBRARY PATH IN .PROFILE AS
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:$ORACLE_HOME/odbc/lib;export LD_LIBRARY_PATH

I DONT WHAT GOING WRONG.

Not sure what is going on, I followed the install docs to and am still unable to get into server manager and or sqlplus to start the new database.CAN ANYONE PLZ HELP ME
Re: ora -12547 TNS: lost contact [message #152320 is a reply to message #152318] Thu, 22 December 2005 08:37 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Things to try:

1. Check if your LD_LIBRARY_PATH is pionting to the right directory:

echo $LD_LIBRARY_PATH


2. Check if you have a file called libskgxp8.so

find $ORACLE_HOME -name libskgxp?.so


3. Try to relink Oracle and svrmgrl

make -f ins_svrmgr.mk svrmgrl
make -f ins_rdbms.mk ioracle


Best regards.

Frank
Re: ora -12547 TNS: lost contact [message #152322 is a reply to message #152320] Thu, 22 December 2005 09:06 Go to previous messageGo to next message
oradba16
Messages: 54
Registered: September 2005
Member
hi
i gave the two command what u had given it
when i 'echo' the first command it shows the same path what i given in .profile

when i gave the second one
$find $ORACLE_HOME -name libskgxp8.so
it also displays nothing

so what can i do now...
help me... to resolve
Re: ora -12547 TNS: lost contact [message #152324 is a reply to message #152322] Thu, 22 December 2005 09:11 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Restore the file from backup or try to relink as explained above.

Best regards.

Frank
Re: ora -12547 TNS: lost contact [message #152330 is a reply to message #152322] Thu, 22 December 2005 09:37 Go to previous messageGo to next message
oradba16
Messages: 54
Registered: September 2005
Member
hi
when i gave,
$ make -f ins_svrmgr.mk svrmgrl

$make -f ins_rdbms.mk ioracle

this shows
ins_svrmgr.mk: No such file or directory
ins_rdbms.mk:No such file or directory
so wat can i do.how to restore this (libskgxp8.so) from backup
plz sketch that in details plz.where the backup will be?
Re: ora -12547 TNS: lost contact [message #173980 is a reply to message #152330] Thu, 25 May 2006 07:49 Go to previous messageGo to next message
ruli
Messages: 1
Registered: May 2006
Junior Member
when I installing the Oracle 8i on RHEL 4 ES, i haved the similar problem, the problem is in gcc. I resolve it aplying following steps:

1.relink all with gcc32.
2. relink all whth gcc292.

and the problem disapeared.

good luck, and sorry for my english

U can ask me about the installation procedure by ICQ: 288372046

[Updated on: Thu, 25 May 2006 07:53]

Report message to a moderator

Re: ora -12547 TNS: lost contact [message #274125 is a reply to message #173980] Sun, 14 October 2007 03:02 Go to previous message
khosravi
Messages: 68
Registered: April 2006
Member
I had this problem ("ORA-12547: TNS:lost contact" error) when i installed oracle 10 R2 on "linux fedora core 3" i solved it by installing
libaio-0.3.105-2.i386.rpm

be happy

Previous Topic: ora-12514 after i restart the service
Next Topic: DBLink Creation - ORA-12154
Goto Forum:
  


Current Time: Mon Dec 05 04:54:06 CST 2016

Total time taken to generate the page: 0.07574 seconds