problem in updates optimizer

[Former Member]

Hi All,

I am facing a problem in updates optimizer while runing through db13 but it is runing successfully at os lavel.

Log is given below :

18.01.2008 17:48:18 Job started

18.01.2008 17:48:18 Step 001 started (program RSDBAJOB, variant &0000000002580, user ID JITENDRA)

18.01.2008 17:48:18 Execute logical command BRCONNECT On host bslprtl

18.01.2008 17:48:18 Parameters:-u / -jid STATS20080118174818 -c -f stats -t PSAPPRD

18.01.2008 17:48:19 ld.so.1: brconnect: fatal: libclntsh.so.10.1: open failed: No such file or directory

18.01.2008 17:48:19 Process died due to signal 9

18.01.2008 17:48:19 Job finished

Kindly help how to resolve this issue.....

Regards,

Jitendra Tiwari

[fidel_vales]

hi,

to Jitendra:

> I am facing a problem in updates optimizer while runing through db13 but it is runing successfully at os lavel.

As which user have you executed the update statistics at OS level?

Have you installed the oracle 10g instantclient as indicated on the SAP notes?

what are your environment variables ofr the user <SID>adm?

to kaushal:

>The libclntsh.so.10.1 file is in the /export/home/oracle10g/lib32 directory which is specified in "Native Library Path Suffix"

1) That would be on your system.

2) That is the oracle client shared library, but SAP recommends to install the INSTANTCLIENT, and it will NOT be on the mentioned directory, even in YOUR system. BRCONNECT is looking for the instantclient not for the "normal" client.

Please, check note 819829 Oracle Database 10g: Instant Client 10.x on Unix where it is explained

to Eric:

>if you are using Oracle 9i, then use the BR*tools made for Oracle 9.

It is possible to use BRCONNECT 700 with Oracle 10g 9i, but I prefer to run BRCONNECT 640 with 9i as it can be complicated to set all variables.

Edited by: Fidel Vales on Jan 18, 2008 3:04 PM

[former_member204746]

if you are using Oracle 9i, then use the BR*tools made for Oracle 9.

[Former Member]

HI,

The libclntsh.so.10.1 file is in the /export/home/oracle10g/lib32 directory which is specified in "Native Library Path Suffix"

check startserv contain the path to LD_LIBRARY_PATH

or check the file permission

regards,

kaushal