Unable to start SAP due to the connection error with Oracle

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

Check SAP Note 491174 - Composite SAP note for ORA-01034.

Thanks

Sushil

[Former Member]

hi

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

Check for your ORACLE_HOME and ORACLE_SID

ORA-01034 is thrown during you attempt to upgrade because there is an invalid entry in one of the following files:

/etc/oratab

/var/opt/oracle/oratab

Regards,

Nitin Salunkhe

[abhimanyu_pandey]

Hi.. Prasad,

Have you properly configured your netconfiguration for oracle, If not first configure it and then try.

If yes, then use SQLPLUS username/password@BSW command to connect to your remote Oracle server.

Regards,

Abhimanyu