topic Re: Unsatisfied data symbol in Operating System - HP-UX

Unsatisfied data symbol

Khalid A. Al-Tayaran — Fri, 28 Feb 2003 10:18:01 GMT

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)

Re: Unsatisfied data symbol

Ian Lochray — Fri, 28 Feb 2003 10:36:33 GMT

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.

Re: Unsatisfied data symbol

Ravi_8 — Fri, 28 Feb 2003 10:49:01 GMT

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.

Re: Unsatisfied data symbol

T G Manikandan — Fri, 28 Feb 2003 11:07:09 GMT

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

Re: Unsatisfied data symbol

T G Manikandan — Fri, 28 Feb 2003 12:12:50 GMT

Make sure that all Oracle processes are down when the re-linking is carried out

Re: Unsatisfied data symbol

Khalid A. Al-Tayaran — Fri, 28 Feb 2003 14:16:18 GMT

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,,,,,,,,,

Re: Unsatisfied data symbol

Khalid A. Al-Tayaran — Fri, 28 Feb 2003 14:17:48 GMT

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,,,,,,,,,

Re: Unsatisfied data symbol

Steven E. Protter — Fri, 28 Feb 2003 15:59:03 GMT

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

Re: Unsatisfied data symbol

Khalid A. Al-Tayaran — Sat, 01 Mar 2003 06:12:06 GMT

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?

Re: Unsatisfied data symbol

Steven E. Protter — Sun, 02 Mar 2003 02:22:53 GMT

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