cancel
Showing results for 
Search instead for 
Did you mean: 

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
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)
Alex Lavrov.
Honored Contributor

Re: Oracle 9 Error

Btw, as Oracle customer you should have an access to their metalink. It's a very big and good knowledge base/forum, you can find there answers to 99.99% of your questions.

If you don't have one, I suggest you to ask your account manager to get you one.
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Yogeeraj_1
Honored Contributor

Re: Oracle 9 Error

hi scott!

read all these post, at this stage it is preferrable that you log a TAR with Oracle through Metalink. They will help you out in very little time.

good luck!

best regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: Oracle 9 Error

As part of a conversion of a database from 32 bit to 64 bit you have to do an oracle word size conversion.

The database won't work right until that is done.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com