Oracle 9 Error

[Scott Buckingham]

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?

[Alex Lavrov.]

What do you have in SHLIB_PATH?

echo $SHLIB_PATH

[Jean-Luc Oudart]

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

[Scott Buckingham]

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

[Jean-Luc Oudart]

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

[Scott Buckingham]

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?

[Alex Lavrov. · Accepted solution]

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

[Scott Buckingham]

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.

[Scott Buckingham]

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?

[Alex Lavrov.]

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 ;)

[Alex Lavrov.]

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.

[Yogeeraj_1]

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

[Steven E. Protter]

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