on 11-22-2009 11:15 PM
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
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.