Former Member

May 05, 2009 at 01:16 PM

Unable to start SAP due to the connection error with Oracle

1091 Views

Dear All,

We have done distributed installation. CI, Oracle has been installed successfully.

But when we tried to connect the DB from CI. we are getting the error

R3trans -d is giving the return code 00012, when we tried to start system from CI.

Following is the trans.log error

$ more trans.log

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

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

4 ETW000

4 ETW000 date&time : 05.05.2009 - 18:03:30

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] Tue May 5 18:03:30 2009 48 0.000048

4 ETW000 [dev trc ,00000] db_con_init called 11 0.000059

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

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

4 ETW000 37 0.000136

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

4 ETW000 3493 0.003629

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

4 ETW000 18 0.003647

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

4 ETW000 34 0.003681

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

4 ETW000 120 0.003801

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

4 ETW000 20 0.003821

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

4 ETW000 42 0.003863

4 ETW000 [dev trc ,00000] New connection 0 created 20 0.003883

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 23 0.003906

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

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

4 ETW000 18 0.003949

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 20 0.003969

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

4 ETW000 300 0.004269

4 ETW000 [dev trc ,00000] -->oci_initialize 20 0.004289

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 4762 0.009051

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 29 0.009080

4 ETW000 [dev trc ,00000] Connecting as /@BSW on connection 0 ... 22 0.009102

4 ETW000 [dev trc ,00000] Allocating service context handle 22 0.009124

4 ETW000 [dev trc ,00000] Allocating server context handle 13 0.009137

4 ETW000 [dev trc ,00000] Attaching to DB Server BSW (con_hdl=0,svchp=110791c98,svrhp=1107942f8)

4 ETW000 67 0.009204

4 ETW000 [dev trc ,00000] Assigning server context 1107942f8 to service context 110791c98

4 ETW000 39616 0.048820

4 ETW000 [dev trc ,00000] Allocating user session handle 29 0.048849

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110791c98,srvhp=1107942f8,usrhp=11079cd38)

4 ETW000 24 0.048873

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

4 ETW000 2415 0.051288

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1107942f8)

4 ETW000 28 0.051316

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110791c98,srvhp=1107942f8)

4 ETW000 18 0.051334

4 ETW000 [dev trc ,00000] Deallocating server context handle 1107942f8 142 0.051476

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 25 0.051501

4 ETW000 [dev trc ,00000] Try to connect with default password 20 0.051521

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@BSW on connection 0 ...

4 ETW000 19 0.051540

4 ETW000 [dev trc ,00000] Allocating server context handle 11 0.051551

4 ETW000 [dev trc ,00000] Attaching to DB Server BSW (con_hdl=0,svchp=110791c98,svrhp=1107942f8)

4 ETW000 27 0.051578

4 ETW000 [dev trc ,00000] Assigning server context 1107942f8 to service context 110791c98

4 ETW000 33038 0.084616

4 ETW000 [dev trc ,00000] Assigning username to user session 11079cd38 15 0.084631

4 ETW000 [dev trc ,00000] Assigning password to user session 11079cd38 13 0.084644

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110791c98,srvhp=1107942f8,usrhp=11079cd38)

4 ETW000 22 0.084666

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

4 ETW000 1858 0.086524

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1107942f8)

4 ETW000 18 0.086542

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110791c98,srvhp=1107942f8)

4 ETW000 19 0.086561

4 ETW000 [dev trc ,00000] Deallocating server context handle 1107942f8 123 0.086684

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 24 0.086708

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

4 ETW000 57 0.086765

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01034: ORACLE not available 18 0.086783

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 IBM AIX RISC System/6000 Error: 2: No such file or directory [dblink#1 @ 419]

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

Could you please provide us the relavant solution.