| ora -12547 TNS: lost contact [message #152318] |
Thu, 22 December 2005 08:28  |
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  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Things to try:
1. Check if your LD_LIBRARY_PATH is pionting to the right directory:
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 |
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 #152330 is a reply to message #152322] |
Thu, 22 December 2005 09:37 |
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 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
