Skip to Content
0
Former Member
Jun 24, 2009 at 03:13 AM

SAP JAVA system not coming up after restart

257 Views

Hello SAP experts,

I have a following enviorment

SAP WAS JAVA only

OS:- solaris

DB;- 9207

Kernel:= 640

I had a daily schedule restart of the system.

But after shutting down the system is not coming up and also i chekeced the logs it was related to R3trans.

the R3trans -d log is as seen below:-

Line:-----

"trans.log" [Read only] 44 lines, 4056 characters

4 ETW000 R3trans version 6.09 (release 640 - 13.01.05 - 10:38:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 24.06.2009 - 13:04:46

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 Jun 24 13:04:46 2009 733 0.000733

4 ETW000 [dev trc ,00000] db_con_init called 66 0.000799

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

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

4 ETW000 206 0.001321

4 ETW000 [dev trc ,00000] Wed Jun 24 13:04:47 2009 92178 0.093499

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/DC2/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 283 0.093782

4 ETW000 [dev trc ,00000] Library '/usr/sap/DC2/SYS/exe/run/dboraslib.so' loaded

4 ETW000 88 0.093870

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/DC2/SYS/exe/run/dboraslib.so

4 ETW000 110 0.093980

4 ETW000 [dev trc ,00000] Version of '/usr/sap/DC2/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.55)

4 ETW000 520 0.094500

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/DC2/SYS/exe/run/dboraslib.so

4 ETW000 94 0.094594

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/DC2/SYS/exe/run/dboraslib.so

4 ETW000 266 0.094860

4 ETW000 [dev trc ,00000] New connection 0 created 98 0.094958

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 00

0, con_max = 255, con_opt = 255, occ = NO

4 ETW000 112 0.095070

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 147 0.095217

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 88 0.095305

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 92 0.095397

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/DC2/920_64 from environment

4 ETW000 1837 0.097234

4 ETW000 [dev trc ,00000] -->oci_init1 123 0.097357

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 73 0.097430

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

4 ETW000 9213 0.106643

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error -1 performing CON [dblink#2 @ 419]

:$

4 ETW000 266 0.094860

4 ETW000 [dev trc ,00000] New connection 0 created 98 0.094958

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 00

0, con_max = 255, con_opt = 255, occ = NO

4 ETW000 112 0.095070

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 147 0.095217

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 88 0.095305

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 92 0.095397

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/DC2/920_64 from environment

4 ETW000 1837 0.097234

4 ETW000 [dev trc ,00000] -->oci_init1 123 0.097357

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 73 0.097430

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

4 ETW000 9213 0.106643

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error -1 performing CON [dblink#2 @ 419]

4 ETW000 356 0.106999

4 ETW000 [dblink ,00419] ***LOG BY0=>'OCI_ERROR' [dblink#2 @ 419] 61 0.107060

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DC2'"

~

Line:-----

So i changed the NLS parameter from

Old value:-ORA_NLS33=/oracle/DC2/920_64/ocommon/nls/admin/data

New value:- ORA_NLS33/oracle/client/92x_64/ocommon/nls/admin/data

Now R3trans -x worked fine but R3trans -d is not working well its giving the following utput

6% R3trans -d

This is R3trans version 6.09 (release 640 - 13.01.05 - 10:38:00).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 -


db call info -


2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

nus650pa:dc2adm 7% R3trans -x

This is R3trans version 6.09 (release 640 - 13.01.05 - 10:38:00).

unicode enabled version

R3trans finished (0000).

So please help me out for the same.

Apreciating your valuable help.

Thanks and Regards,

Ramkrishna