Unsatisfied data symbol

[Khalid A. Al-Tayaran]

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)

[Ian Lochray · Accepted solution]

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]

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.

[T G Manikandan]

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]

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

[Khalid A. Al-Tayaran]

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]

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]

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

[Khalid A. Al-Tayaran]

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]

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