sqlplus /nolog failed oracle

[Former Member]

Hi,

I have the problem with sqlplus /nolog failed.

Whenever i am trying to run any action from DB13 it gives the following error.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000029, user ID KSHARMA)

Execute logical command BRCONNECT On host DSS-BWQA

Parameters: -u / -jid CHECK20070409115626 -c -f check

BR0801I BRCONNECT 7.00 (24)

ld.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directory

Killed

BR0278E Command output of '/oracle/BQ3/102_64/bin/sqlplus':

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory

BR0280I BRCONNECT time stamp: 2007-04-09 11.56.28

BR0279E Return code from '/oracle/BQ3/102_64/bin/sqlplus': 137

BR0302E SQLPLUS call for database instance BQ3 failed

BR0303E Determination of Oracle version failed

ld.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directory

BR0280I BRCONNECT time stamp: 2007-04-09 11.56.28

BR0301E SQL error -12547 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12547: TNS:lost contact

BR0310E Connect to database instance BQ3 failed

BR0806I End of BRCONNECT processing: cduzrcwy.log2007-04-09 11.56.28

BR0280I BRCONNECT time stamp: 2007-04-09 11.56.28

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished.

Since i have checked the link at os level.

lrwxrwxrwx 1 root root 36 Mar 16 08:09 hsdb_oing.so -> oracle/BQ3/

lrwxrwxrwx 1 root root 35 Mar 16 08:09 hsdb_inf.so -> oracle/BQ3/

lrwxrwxrwx 1 root root 36 Mar 16 08:09 hsdb_odbc.so -> oracle/BQ3

lrwxrwxrwx 1 root root 35 Mar 16 08:09 hsdb_ora.so -> oracle/BQ3/

lrwxrwxrwx 1 root root 35 Mar 16 08:09 libnavhoa.a -> oracle/BQ3/

lrwxrwxrwx 1 root root 35 Mar 16 08:09 hsdb_syb.so -> oracle/BQ3/

-rwxr-xr-x 1 orabq3 dba 6945352 Nov 2 12:49 liborasdkbase.so.10.2

-rwxr-xr-x 1 orabq3 dba 6945352 Nov 2 12:49 liborasdkbase.so

***********************************************************************************

is there is any problem with the same.

it Really Urgent.

Kindly mail me at : king.sharma@ril.com

Dont worry about rewards Points.

Regards,

King V.

[Former Member · Accepted solution]

Hi King,

cd to $ORACLE_HOME/bin then run command relink all

it should fix your issue.

Regards

Manohar

[Former Member · Accepted solution]

yes it is to some extent .there was also problem with DB operations.

Regards,

King V.

[Former Member]

Done

[Former Member]

Hello,

It seems to be a problem with relinking.

Pl Refer SapNote 499055 - Error when relinking the Oracle software at the following link

https://websmp203.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=499055&_NLANG...

Check the following thread also:

/community [original link is broken];jsessionid=8d92200630d63622db0ec9a0476182d4ea3eddad1206.e34Tb34Lb34PbO0Lb3eTahiPc3yNe0?messageID=1104338&#1104338

Hope this helps.

Pl award points if resolved.

Regards

[andreas_herzog]

"<b>ld.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directory</b>"

-> where are these so (libraries)?

-> look for them at disk level

<b>and...by the way...this here is db2 on win/unix...you're talking about oracle, next time plz use the appropriate section ;-)</b>

GreetZ, AH