1748182 Members
3534 Online
108759 Solutions
New Discussion юеВ

Re: Oracle 9 Error

 
SOLVED
Go to solution
Scott Buckingham
Regular Advisor

Oracle 9 Error

Yesterday, in an effort to free up some disk space, I uninstalled th 32 bit version of Oracle 9i. We haven't used it in quite some time, in fact, the database wasn't running at all. Instead, we use the 64 bit version which is on the same box. However, now when I try to access any of the commands for this version (sqlplus, imp, exp, etc.) I receive the following error:

ld.so.1: sqlplus: fatal: libclntsh.so.9.0: open failed: No such file or director
y
Killed

I have read that maybe I lost a link or I need to reestablish one for the libraries needed to run this, but I'm not real clear on what to link or if I really screwed something up and need to reinstall altogether.

Any thoughts?
Long time dabbler, first time Admin / DBA
12 REPLIES 12
Alex Lavrov.
Honored Contributor

Re: Oracle 9 Error

What do you have in SHLIB_PATH?

echo $SHLIB_PATH
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Jean-Luc Oudart
Honored Contributor

Re: Oracle 9 Error

Scott,

As far as I know Oracle9i is only 64 bits. (On HPUX).
Of course, you can have either a 32 bits or 64 bits client. Both libraries should ba available one being $ORACLE_HOME/lib (64 bits) the other one is the 32 bits version.

I'm not sure what do you mean when you "uninstalled the 32bit version" ?

What value do you have for ORACLE_HOME, PATH, SHLIB_PATH environment variables ?

Regards
Jean-Luc

fiat lux
Scott Buckingham
Regular Advisor

Re: Oracle 9 Error

This is actually an installation on a Solaris 8 platform. I used the runInstaller program found in my 9i_32 directory to uninstall the software. I then rm -r everything left in this directory. I still have my 9i setup, which is the 64 bit version. Here are my env var settings:

LD_LIBRARY_PATH=/software/oracle/product/9i/lib:/usr/openwin/lib
ORACLE_BASE=/software/oracle
ORACLE_DOC=/software/oracle/product/9i/doc
ORACLE_HOME=/software/oracle/product/9i
ORACLE_SID=TST9i
PATH=/usr/bin::/usr/bin:.:/software/oracle/product/9i/bin:.:/software/oracle/pro
duct/9i/sqlplus::/usr/sbin:.:/usr/ccs/bin::/software/oracle/product/9i/OPatch:
SHELL=/bin/sh
SHLIB_PATH=/software/oracle/product/9i/lib
Long time dabbler, first time Admin / DBA
Jean-Luc Oudart
Honored Contributor

Re: Oracle 9 Error

Ok SPARC.
not too familiar. It seems that thre is a 32 bits version.
If you uninstall the 32 bits version, did you use the OPracle installer to do so ?

You probably need to relink your Oracle products.

Regards
Jean-Luc
fiat lux
Scott Buckingham
Regular Advisor

Re: Oracle 9 Error

Yes, I ran Oracle's runInstaller program to uninstall the software.

How do I relink Oracle? I don't recall doing this before. Can it be done manually?
Long time dabbler, first time Admin / DBA
Alex Lavrov.
Honored Contributor
Solution

Re: Oracle 9 Error

At the bottom you have instruction on relinking oracle 9:

http://ist.uwaterloo.ca/~baumbach/ORACLEnotes/STARTUP_relinking_oracle.html


But before you proceed, I recommend you to consult with your DBA
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Scott Buckingham
Regular Advisor

Re: Oracle 9 Error

Thanks, Alex, I'll give this a try. As far as talking to our DBA, I'll have to do as I am the one acting in this capacity.
Long time dabbler, first time Admin / DBA
Scott Buckingham
Regular Advisor

Re: Oracle 9 Error

Well, relinking doesn't work either as I seem to be missing some library. Here is part of the error message:

ld: fatal: library -lclntsh: not found
ld: fatal: File processing errors. No output written to sqlplus
*** Error code 1
make: Fatal error: Command failed for target `sqlplus'

I've done some Google-ing on this and apparently I am missing libclntsh.a which I cannot find anywhere on the box. Will this warrant a re-install?
Long time dabbler, first time Admin / DBA
Alex Lavrov.
Honored Contributor

Re: Oracle 9 Error

Well, according to my googling, it's a part of 32bit libraries. If it wants 32bit libraries, ther is no point in relinking, because your goal is to relink it all with 64bit, right?

So I think the direction is to find out how to make it relink with 64bit libraries and not 32bit ..

Maybe I'm missing something ... Hope some DBA guru will see this thread ;)
I don't give a damn for a man that can only spell a word one way. (M. Twain)