cancel
Showing results for 
Search instead for 
Did you mean: 

Unsatisfied data symbol

SOLVED
Go to solution
Khalid A. Al-Tayaran
Valued Contributor

Unsatisfied data symbol


Hi all,

I applied the september 2002 bundle patches for HP-UX 11.0 on our development machine with no problems.

But, on out production machine I faced the following errors:
/usr/lib/pa20_64/dld.sl: Unsatisfied data symbol '_sobuf' in load module '/oracl
e/PRD/817_64/bin/oracle'.
Now our SAP database is not running. The oracle metalink tells me that I need some patches: PHSS_10565, PHSS_14920 and PHSS_15731. The strange thing is that my development system doesn't have them. I did:
swlist -l product PHSS_10565
ERROR: Software "PHSS_10565" was not found on host....

Also, from svrmgrl I get the same error. Please help, production is still down.

(HP-UX 11.0, Oracle 8.1.7)

9 REPLIES
Ian Lochray
Respected Contributor
Solution

Re: Unsatisfied data symbol

You may need to relink the Oracle executables. Try linking svrmgrl first. If that works, relink everything. Details on relinking Oracle executables can be found in Oracle Note ID 131321.1.
Ravi_8
Honored Contributor

Re: Unsatisfied data symbol

Hi,

mount the oracle 8.1.7 media and execute rootpre.sh which does the link.
if this couldn't solve, you may need to apply the above patches.
never give up
T G Manikandan
Honored Contributor

Re: Unsatisfied data symbol

After your patch installation you need to re-link oracle executables.

Add your $ORACLE_HOME/lib(and lib64 if 64bit) path to the SHLIB_PATH.

then just do a
$ relink all from $ORACLE_HOME/bin

Revert
T G Manikandan
Honored Contributor

Re: Unsatisfied data symbol

Make sure that all Oracle processes are down when the re-linking is carried out
Khalid A. Al-Tayaran
Valued Contributor

Re: Unsatisfied data symbol

Hi,

Thanks guys for the for all replies...

I've been searching with my colleague for the solution. Most if not all say I need to relink the executables. I found the same note that Ian mentioned.

Ravi: thanks, I think the above solution does the same job.

TG Mani. The notes I found do mention that the listner should bo stopped. Alos in my pathL lib64 was not added before.

Thanks,,,,,,,,,

Khalid A. Al-Tayaran
Valued Contributor

Re: Unsatisfied data symbol

Hi,

Thanks guys for the for all replies...

I've been searching with my colleague for the solution. Most if not all say I need to relink the executables. I found the same note that Ian mentioned.

Ravi: thanks, I think the above solution does the same job.

TG Mani. The notes I found do mention that the listener should be stopped. Also, in my path: lib64 was not added before.

Thanks,,,,,,,,,


Steven E. Protter
Exalted Contributor

Re: Unsatisfied data symbol

You may need to do this.

Install the December 2002 patch set as required by oracle.

Oracle has a list of additional required patches.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=43507.1

Any patch in there needs to be checked for a newer patch on itrc.hp.com

After these steps, relink needs to be done.

Oracle requires the above steps in order to reliably run their database.

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
Khalid A. Al-Tayaran
Valued Contributor

Re: Unsatisfied data symbol


Hi,

I forgot to ask this question. Why did we need to relink the oracle executables on our production machine but not on the development machine after applying the same bundle patch?
Steven E. Protter
Exalted Contributor

Re: Unsatisfied data symbol

The oracle executables are created using compilers like c++ etc. Those comipilers are commonly updated in patch sets from HP.

The created executables might be different thant the ones create from the earlier compilers.


So, if you are having a problem, after installing the patch set, its a good idea to bring down the database and relink oracle.

On the other hand, when I'm installing HP patches and not having problems with oracle or internet application server, I don't relink either.

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