topic Oracle 9 Error in Operating System - HP-UX

Oracle 9 Error

Scott Buckingham — Thu, 05 May 2005 10:52:07 GMT

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?

Re: Oracle 9 Error

Alex Lavrov. — Thu, 05 May 2005 11:13:23 GMT

What do you have in SHLIB_PATH?

echo $SHLIB_PATH

Re: Oracle 9 Error

Jean-Luc Oudart — Thu, 05 May 2005 11:52:32 GMT

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

Re: Oracle 9 Error

Scott Buckingham — Thu, 05 May 2005 12:02:31 GMT

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

Re: Oracle 9 Error

Jean-Luc Oudart — Thu, 05 May 2005 12:18:22 GMT

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

Re: Oracle 9 Error

Scott Buckingham — Thu, 05 May 2005 12:56:59 GMT

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?

Re: Oracle 9 Error

Alex Lavrov. — Thu, 05 May 2005 13:07:34 GMT

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

Re: Oracle 9 Error

Scott Buckingham — Thu, 05 May 2005 13:38:57 GMT

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.

Re: Oracle 9 Error

Scott Buckingham — Thu, 05 May 2005 14:51:34 GMT

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?

Re: Oracle 9 Error

Alex Lavrov. — Thu, 05 May 2005 15:00:28 GMT

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

Re: Oracle 9 Error

Alex Lavrov. — Thu, 05 May 2005 15:38:36 GMT

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.

Re: Oracle 9 Error

Yogeeraj_1 — Thu, 05 May 2005 23:15:15 GMT

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

Re: Oracle 9 Error

Steven E. Protter — Thu, 05 May 2005 23:19:55 GMT

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