Click to See Complete Forum and Search --> : Oracle missing libraries
DaveWolles
03-02-2004, 11:06 AM
I've been stuck with oracle on fedora for a while now, so i hope that someone can help me.
I just want to run a database locally but every time I want to start it with svrmgrl I've got always the same error
error while loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory
When I check the dependencies of oracle it says that I'm missing 3 files.
ldd -v oracle
libskgxp8.so => not found
libjox8.so => not found
libobk.so => not found
Could it be that these files are previously removed or during the installation maybe.
If not so, are there any experts that can help me with this problem.
Thx.
MunterMan
03-02-2004, 11:29 AM
found this at the oracle site
http://otn.oracle.com/products/text/x/FAQs/imt_Faq.html
19 Create index: "Error loading external" library problems
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open failed:
No such file or directory
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1
A. Stop your SQL*Net listener. Make sure that your LD_LIBRARY_PATH environment variable contains the following library directories:
$ORACLE_HOME/lib
$ORACLE_HOME/ctx/lib
Then restart your SQL*Net listener.
B. Check your tnsnames.ora file (usually in $ORACLE_HOME/network/admin), and look for something like:
sid_list_listener=...
(ENVS=LD_LIBRARY_PATH=/oracle/product/8.1.5/ctx/lib:)
(program=extproc)
If you have LD_LIBRARY_PATH in here, it MUST include both of the following paths(spelled out):
$ORACLE_HOME/lib and
$ORACLE_HOME/ctx/lib
Hope that helps.
If not, how did you install, from rpm's or binaries?
DaveWolles
03-02-2004, 11:44 AM
hi,
i installed with the tarfile i found on the oracle site (that extracts to Disk1)
i added the 2 directories and i get the following errors when i start the listener now:
NL-00280: error creating log stream /u01/oracle/product/8.1.7/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Linux error: 13: Permission denied.
so it should hopefully be just a matter of permissions now?
MunterMan
03-02-2004, 12:18 PM
The clue is in the error 'permission denied'.
Change the permissions and try again.
DaveWolles
03-03-2004, 04:33 AM
hi,
the listener starts ok now. but with the ldd oracle command there is still 1 file that cannot be found: libskgxp8.so => not found
when trying sqlplus it gives an error saying this file can't be found.
back to square one :(
also in tnsnames.ora i can't find something that's even close to
sid_list_listener=...
(ENVS=LD_LIBRARY_PATH=/oracle/product/8.1.5/ctx/lib
(program=extproc)
there is nothing in there that mentions LD_LIBRARY_PATH
pickarooney
03-03-2004, 07:51 AM
Have you set and exported your ORACLE_PATH before running?