cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans -x failing with returncode 12

Former Member
0 Kudos

Hi,

Below is the error when running R3trans -x with return code 0012. This happens form new app server in new host, which I am adding now. When starting, it could not check, if DB is running.. when tried with R3trans -x, below is the error it shows up. ( We have CI and DB are running on another hosts are fine)

Looks there is a access issue from new app server to DB server ?

================================================================================================

bwkadm> more startsap_.log

Checking BWK Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

The database on sapbwvdb did not start successfully.

Exiting /usr/sap/BWK/SYS/exe/run/startsap.

=================================================================================================

bwkadm> R3trans -x

This is R3trans version 6.14 (release 700 - 20.04.09 - 13:27:00).

unicode enabled version

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

R3trans finished (0012).

bwkadm>

=================================================================================================

bwkadm> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 20.04.09 - 13:27:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 22.11.2009 - 16:38:42

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Sun Nov 22 16:38:42 2009 5316 0.005316

4 ETW000 [dev trc ,00000] db_con_init called 83 0.005399

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

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

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

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

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

4 ETW000 188 0.162827

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

4 ETW000 9525 0.172352

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

4 ETW000 156 0.172508

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

4 ETW000 1088 0.173596

4 ETW000 [dev trc ,00000] New connection 0 created 785 0.174381

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 178 0.174559

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

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

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 127 0.174830

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 6377 0.181207

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 206 0.181413

4 ETW000 [dev trc ,00000] application info callback registered 103 0.181516

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR 10091 0.191607

4 ETW000 [dev trc ,00000] OCIErrorGet() failed with rc=-2 733 0.192340

4 ETW000 [dev trc ,00000] -> no further error details available 81 0.192421

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned -1 (for default NLS handle)

4 ETW000 111 0.192532

4 ETW000 [dev trc ,00000] set_ocica() -> OCI return code -1 1234 0.193766

More(92%)

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error -1 performing CON [dblink#7 @ 431] 1385 0.195151

4 ETW000 [dblink ,00431] ***LOG BY0=>OCI returned error code -1. [dblink#7 @ 431] 125 0.195276

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

bwkadm>

Edited by: Raj on Nov 22, 2009 6:21 PM

Edited by: Raj on Nov 22, 2009 6:23 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Raj,

See if following links helps you to resolve the problem.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=443867]

[http://www.dbmotive.com/oracle_error_codes.php?type=ORA&errcode=12154]

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Raj

Check your oracle listner is up or not

Pls run the following command to start oracle listner

login on Os with ORASID user

lsnrctl start

Thanks,

Sandeep Singh DS

Former Member
0 Kudos

Hi,

What SAP kernel version and patch level are you using on the app server? Ensure you are using the latest kernel and dbsl patch level. What Oracle client version are you on?

Please make sure that you set environment correctly..

Note 602843 Environment settings for R/3/Oracle on UNIX

Former Member
0 Kudos

Thanks!! I ensured ENV is set as in CI instance. Now the Error is ORA-12154.. Not sure, if new app server needs any entry in tnsnames.ora / sqlnet.ora or any other ports opened for DB communication. Also, we use NFS mount for Kernel and it is copied to new instance when it is started.

Oracle Client = /oracle/client/10x_64/lib

While starting new application instance.

==============================================================

Checking BWK Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

The database on sapbwkdb did not start successfully.

Exiting /usr/sap/BWK/SYS/exe/run/startsap.

================================================================

From - trans.log file ( R3trans -x)

================================================================

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 104 0.179614

4 ETW000 [dev trc ,00000] Allocating server context handle 84 0.179698

4 ETW000 [dev trc ,00000] Attaching to DB Server BWK (con_hdl=0,svchp=0x101a0ba48,srvhp=0x101a0efc8)

4 ETW000 205 0.179903

4 ETW000 [dev trc ,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 93636 0.273539

4 ETW000 [dev trc ,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 494 0.274033

4 ETW000 [dev trc ,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 131 0.274164

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 12154 136 0.274406

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=12154) 148 0.274554

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 12154 317 0.274871

4 ETW000 [dev trc ,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 124 0.274995

4 ETW000 [dev trc ,00000] Try to connect with default password 75 0.275070

4 ETW000 [dev trc ,00000] Connecting as SAPBIW/<pwd>@BWK on connection 0 (nls_hdl 0) ... (dbsl 700 220409)

4 ETW000 128 0.275198

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatc

h

4 ETW000 119 0.275317

4 ETW000 [dev trc ,00000] 0 UTF8 0x1019f3780 0x1019fb1d0 0x101a0

bb18

4 ETW000 135 0.275452

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x101a0efc8) 79 0.275531

Former Member
0 Kudos

I was trying to start new app server from host different from CI host. Currently CI and DB are running. Below are start log..

When tried with R3trans -x, I got ORA-12154

Checking BWK Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

The database on sapbwkdb did not start successfully.

Exiting /usr/sap/BWK/SYS/exe/run/startsap.

==========================================

R3trans -x

4 ETW000 [dev trc ,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 67838 0.344029

4 ETW000 [dev trc ,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 370 0.344399

4 ETW000 [dev trc ,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 127 0.344526

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 12154 78 0.344710

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=12154) 99 0.344809

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 12154 293 0.345102

4 ETW000 [dev trc ,00000] ORA-12154: TNS:could not resolve the connect identifier specified

JPReyes
Active Contributor
0 Kudos

All the info you need is in SAP Note 443867 - ORA-12154 Collective SAP note

Regards

Juan

Former Member
0 Kudos

Warren / Juan / Manoj / Sandeep -- Thanks !!. yes. it is resolved. The issue was /oracle/SID/.../.../network/admin/<files> were missing in new app server. I created them, it works fine. Initially, I looked at DB host for these... later realised that these dir are also needed in New app server host.

Thanks,R