R3trans check finished with return code: 12

[Former Member]

Dear All,

After update the SAPKernel from 175 to 254 , while stating the sap following error occurs :

Please reply me immed.

MIRCDEV:d02adm> cat startdb.log

-

---

Wed Sep 15 19:51:47 IST 2010

LOGFILE FOR STARTING ORACLE

Trying to start D02 database ...

-

---

Wed Sep 15 19:51:47 IST 2010

checking required environment variables

ORACLE_HOME is >/oracle/D02/102_64<

ORACLE_SID is >D02<

-

---

Wed Sep 15 19:51:47 IST 2010

check initora

-

---

Wed Sep 15 19:51:47 IST 2010

check initora

-

---

Wed Sep 15 19:51:47 IST 2010

checking V2 connect

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 15-SEP-2010 19:51:47

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/D02/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = MIRC

) (PORT = 1527))) (CONNECT_DATA = (SID = D02) (GLOBAL_NAME = D02.WORLD)))

OK (0 msec)

tnsping: V2 connect to D02

-

---

Wed Sep 15 19:51:47 IST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Wed Sep 15 19:51:47 IST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Wed Sep 15 19:51:47 IST 2010

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Sep 15 19:51:47 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1795162112 bytes

Fixed Size 2044744 bytes

Variable Size 905972920 bytes

Database Buffers 872415232 bytes

Redo Buffers 14729216 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

-

---

Wed Sep 15 19:51:58 IST 2010

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/D02/SYS/exe/run/startdb: Terminating with error code 12

Regards,

Santosh

[Former Member]

Dear Santosh,

Startdb.log showing that database is starting correctly...

But somehow R3trans failed to connect to Database...

Please check the database status using sqlplus

Post the trans.log.

Check SHLIB_PATH variable (for <SID>adm ).

it should be like-

SHLIB_PATH=/oracle/client/<path to instantclient dir>:/usr/sap/<SID>/SYS/exe/run

(you can define it in ".profile" of <sid>adm)

Then try R3trans -d.

If it still fail to connect, post "trans.log"

have you run "saproot.sh <SID>" as a ROOT after upgrading kernel ?

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh..

Using sqlplus my database is connected.

After updating the Kernel , I ran the saproot.sh (SID) command.

How to check my SHLIB_PATH Variable ? Please reply me immed.

Thaks for reply,

santosh

[Former Member]

detail trans.log as below :

MIRCDEV:d02adm> tail -100 trans.log

4 ETW000 R3trans version 6.14 (release 700 - 09.04.10 - 11:26:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 15.09.2010 - 20:47:27

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Sep 15 20:47:27 2010 319 0.000319

4 ETW000 [dev trc ,00000] db_con_init called 22 0.000341

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 112 0.000453

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/D02/SYS/exe/run/dboraslib.so' ... 28 0.000481

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/D02/SYS/exe/run/dboraslib.so"

FAILED

4 ETW000 "Unable to find library 'libclntsh.so.10.1'." 774 0.001255

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/D02/SYS/exe/run/dboraslib.so'

4 ETW000 98 0.001353

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/D02/SYS/exe/run') or dbms_t

e ('ORA')"

Regards,

santosh

[former_member709110]

Hi Santosh,

Check the permission on the file dboraslib.so . Another thing you might want to try is download the latest dboraslib and replace this one.

Regards,

Neel

[Former Member]

Hi

How to check my SHLIB_PATH Variable ? Please reply me immed.

Login as <sid>adm.

# echo $SHLIB_PATH

you may get output as "/usr/sap/<SID>/SYS/exe/run."

You can check it as follow:

As a <sid>adm user:

#export SHLIB_PATH=/oracle/client/<path to instantclient dir>:/usr/sap/<SID>/SYS/exe/run

Check if SHLIB_PATH exported correctly..

# echo $SHLIB_PATH

you should see output as:

/oracle/client/<path to instantcilent dir>:/usr/sap/<SID>/SYS/exe/run

Then try R3trans -d

you should get return code "0000"

If you get the above result, add the below line at the bottom of "/home/<sid>adm/.profile"

export SHLIB_PATH=/oracle/client/<path to instantclient dir>:/usr/sap/<SID>/SYS/exe/run

Can you post the output of "env" command as <sid>adm.

Regards

Rajesh Narkhede

[Former Member]

Hi,

ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/D02/SYS/exe/run/dboraslib.so"
FAILED
4 ETW000 "Unable to find library 'libclntsh.so.10.1'." 774 0.001255
4 ETW000 http://dbcon.c ,00000 *** ERROR => Couldn't load library '/usr/sap/D02/SYS/exe/run/dboraslib.so'

The error seems to be because SAP is not able to find the oracle client library 'libclntsh.so.10.1.

Create a soft link manually under the user 'root'.

cd /usr/lib/hpux64
ln -s /oracle/client/10x_64/instantclient/libclntsh.so.10.1

Ref: [SAP Note|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1449619]

After creating the softlink, try to start SAP once again.

Hope this solves the issue.

Regards,

Varadharajan M

[Former Member]

Dear Rajesh,

MIRCDEV:d02adm> echo $SHLIB_PATH

/usr/sap/D02/SYS/exe/run:/oracle/client/10x_64/instantclient

MIRCDEV:d02adm> export SHLIB_PATH=/oracle/client/:/usr/sap//SYS/exe/run

MIRCDEV:d02adm> R3trans -d

This is R3trans version 6.14 (release 700 - 09.04.10 - 11:26:00).

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/D02/S

e ('ORA')"

R3trans finished (0012).

Same error occurs..

santosh

[Former Member]

Dear Varadrajan,

1. pwd

/usr/lib/hpux64

1. ln -s /oracle/client/10x_64/instantclient/libclntsh.so.10.1

Usage: ln [-f] [-i] [-s] f1 f2

ln [-f] [-i] [-s] f1 ... fn d1

While giving the startsap command follwowing error ;

/usr/sap/D02/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

Regards,

Santosh

[Former Member]

Dear rajesh , Following is the env variable

MIRCDEV:d02adm> env

_=/usr/bin/env

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/lda

ux/share/man:/opt/ldapux/ypldapd/man:/opt/ipf/man:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/op

/wbem/share/man:/usr/dt/share/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/resmon/share/man/%L:/opt/resmon

share/man:/opt/VRTS/man:/opt/graphics/common/man:/opt/sfmdb/pgsql/man:/opt/sfm/share/man:/opt/amgr/man:/opt/amgr/man/%L

/opt/sec_mgmt/share/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/dsau/man:/opt/gnome/man:/opt/ignite/share/man/%L:

opt/ignite/share/man:/opt/perl_32/man:/opt/perl_64/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/swa/share/man

%L:/opt/swa/share/man:/opt/gwlm/man/%L:/opt/gwlm/man

THREAD=NOPS

SHLIB_PATH=/usr/sap/D02/SYS/exe/run:/oracle/client/10x_64/instantclient

PATH=/oracle/D02/102_64/bin:/opt/java1.4/bin:/home/d02adm:/usr/sap/D02/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/b

n:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sas/bin:/opt/wbe

/bin:/opt/wbem/sbin:/usr/bin/X11:/opt/resmon/bin:/usr/contrib/kwdb/bin:/opt/graphics/common/bin:/opt/sfm/bin:/opt/hpsmh

bin:/opt/upgrade/bin:/opt/gvsd/bin:/opt/sec_mgmt/bastille/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/o

t/gnome/bin:/opt/ignite/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/

in:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:.

NLS_LANG=AMERICAN_AMERICA.WE8DEC

COLUMNS=113

ORACLE_BASE=/oracle

EDITOR=vi

LOGNAME=d02adm

dbs_ora_tnsname=D02

ORACLE_SID=D02

ERASE=^H

PS1=MIRCDEV:d02adm>

DB_SID=D02

DIR_LIBRARY=/usr/sap/D02/SYS/exe/run

TNS_ADMIN=/oracle/D02/102_64/network/admin

dbs_ora_schema=SAPR3

SHELL=/usr/bin/sh

JAVA_HOME=/opt/java1.4

SAPDATA_HOME=/oracle/D02

HOME=/home/d02adm

TERM=ansi

ORACLE_HOME=/oracle/D02/102_64

PWD=/home/d02adm

TZ=IST-5:30

dbms_type=ORA

SAPSYSTEMNAME=D02

LINES=31

regards,

santosh

[Former Member]

Hi,

If I am not wrong, it is your DIALOG instance... right ?

If it is dialog instance yout might given wrong inputs at the time of installation...

Some env variables are wrongly set...

for example:

dbs_ora_tnsname=D02

ORACLE_SID=D02

PS1=MIRCDEV:d02adm>

DB_SID=D02

DIR_LIBRARY=/usr/sap/D02/SYS/exe/run

TNS_ADMIN=/oracle/D02/102_64/network/admin

dbs_ora_schema=SAPR3

SAPDATA_HOME=/oracle/D02

Correct values would be: (CI_DBSID would be your CI Instance DBSID.)

dbs_ora_tnsname=<CI_DBSID>
DB_SID=<CI_DBSID>
ORACLE_SID=<CI_DBSID>
TNS_ADMIN=/oracle/<CI_DBSID>/102_64/network/admin
DIR_LIBRARY=/usr/sap/<CI_DBSID>/SYS/exe/run
TNS_ADMIN=/oracle/<CI_DBSID>/102_64/network/admin
SAPDATA_HOME=/oracle/<CI_DBSID>
dbs_ora_schema=SAPR3

Check and compare above said variables with your CI instance...

You can temporary set it at shell using export command, if it works then modify ".dbenv_<hostname>.sh" in both <sid>adm and ora<sid> users home directory in DI instance host.

Once you tried this, post the result of "R3trans -d"

Regards.

Rajesh Narkhede

[Former Member]

Hi,

If it not a DIALOG Instance:

you can download and Install updated DB libraray from Service Market Place.

Additionally issue the below command as <SID>ADM.

# ln -s /oracle/client/10x_64/instantclient/libclntsh.so.10.1 /usr/lib/hpux64

Regards

Rajesh Narkhede

[fjhernanz]

Hi Santosh,

Please execute a R3trans -d and check for errors in the generated trans.log file. It should provide more information about the cause of the problem.

Br,

Javier

[Former Member]

Hi Javier,

Following is the check for R3trans -d

MIRCDEV:d02adm> R3trans -d

This is R3trans version 6.14 (release 700 - 09.04.10 - 11:26:00).

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/D02/SYS/exe/run') or dbms_typ

e ('ORA')"

R3trans finished (0012).

Regards,

santosh