Unable to connect Database.

[Former Member]

Hello,

I have installed and configure the EP system as distributed.

But the CI is not able to connect DB. If i start SAP then its start but not with my DB it is just starting without my actual DB.

When i check R3trans -d, it is showing the below message :

This is R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

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

R3trans finished (0012).

Then i checked the Trans.log so it is showing the below error :

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 22.05.2015 - 15:44:02

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]  Fri May 22 15:44:02 2015                              78  0.000078

4 ETW000  [dev trc     ,00000]  db_con_init called                                    17  0.000095

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

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

4 ETW000                                                                              44  0.000175

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

4 ETW000                                                                            4840  0.005015

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

4 ETW000                                                                              25  0.005040

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

4 ETW000                                                                              27  0.005067

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

4 ETW000                                                                             400  0.005467

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

4 ETW000                                                                              25  0.005492

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

4 ETW000                                                                              65  0.005557

4 ETW000  [dev trc     ,00000]  New connection 0 created                              22  0.005579

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

4 ETW000                                                                              29  0.005608

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

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

4 ETW000                                                                              25  0.005674

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                                                                              26  0.005700

4 ETW000  [dev trc     ,00000]  Got LIBPATH=/usr/lib:/lib:/usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient from environment

4 ETW000                                                                             391  0.006091

4 ETW000  [dev trc     ,00000]  -->oci_init1                                          17  0.006108

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.4.0', (dbsl 700 131011, UNICODE[2])

4 ETW000                                                                             123  0.006231

4 ETW000  [dev trc     ,00000]    Default connection: tnsname ='SID'                  14  0.006245

4 ETW000  [dev trc     ,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2)

4 ETW000                                                                              25  0.006270

4 ETW000  [dev trc     ,00000]  Application info callback registered.                 14  0.006284

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

4 ETW000                                                                            1457  0.007741

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0x110fac518)

4 ETW000                                                                             311  0.008052

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0x110fabdc8)

4 ETW000                                                                              27  0.008079

4 ETW000  [dev trc     ,00000]  NLS env.: lang=0041004D00450052004900430041004E      127  0.008206

4 ETW000  [dev trc     ,00000]            terr=0041004D00450052004900430041           20  0.008226

4 ETW000  [dev trc     ,00000]            char=00550054004600310036                   17  0.008243

4 ETW000  [dev trc     ,00000]  Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                              24  0.008267

4 ETW000  [dev trc     ,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE

4 ETW000                                                                              23  0.008290

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

4 ETW000  [dev trc     ,00000]  Connecting as /@SID on connection 0 (nls 0) ... (dbsl 700 131011, UNICODE[2])

4 ETW000                                                                              25  0.008331

4 ETW000  [dev trc     ,00000]  Allocating service context handle for con=0           27  0.008358

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      17  0.008375

4 ETW000  [dev trc     ,00000]  Attaching to DB Server SID (con=0,svchp=0x110faf6b8,srvhp=0x110faf8d8)

4 ETW000                                                                              65  0.008440

4 ETW000  [dev trc     ,00000]  Fri May 22 15:44:03 2015                           43647  0.052087

4 ETW000  [dev trc     ,00000]  Assigning server context 0x110faf8d8 to service context 0x110faf6b8

4 ETW000                                                                              37  0.052124

4 ETW000  [dev trc     ,00000]  Allocating user session handle                        41  0.052165

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con=0, usr='/',svchp=0x110faf6b8, srvhp=0x110faf8d8, usrhp=0x111030320)

4 ETW000                                                                              38  0.052203

4 ETW000  [dev trc     ,00000]  Assigning user session 0x111030320 to service context 0x110faf6b8

4 ETW000                                                                            7011  0.059214

4 ETW000  [dev trc     ,00000]  -->oci_prepare_stmt(con=0, len=52, stp=0x110fb9288)

4 ETW000                                                                              60  0.059274

4 ETW000  [dev trc     ,00000]         BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;                                                      

4 ETW000                                                                              27  0.059301

4 ETW000  [dev trc     ,00000]  -  oci_bind   ( 0: SQLT_STR, l=600, con=0, stp=0x110fb9288, vp=0x9001000a78d40cc,ip=0x9001000a78d3d00,rlp=(nil),rcp=(nil))

4 ETW000                                                                              79  0.059380

4 ETW000  [dev trc     ,00000]  -  oci_bind   ( 1: SQLT_STR, l=600, con=0, stp=0x110fb9288, vp=0x9001000a78d3e74,ip=0x9001000a78d3d02,rlp=(nil),rcp=(nil))

4 ETW000                                                                              33  0.059413

4 ETW000  [dev trc     ,00000]     CbApplInfoGet() failed (ignored 1).                18  0.059431

4 ETW000  [dev trc     ,00000]  -->oci_prepare_stmt(con=0, len=54, stp=0x110fba2e0)

4 ETW000                                                                              25  0.059456

4 ETW000  [dev trc     ,00000]         BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;                                                    

4 ETW000                                                                              24  0.059480

4 ETW000  [dev trc     ,00000]  -  oci_bind   ( 0: SQLT_STR, l= 40, con=0, stp=0x110fba2e0, vp=0x9001000a78d3d60,ip=(nil),rlp=(nil),rcp=(nil))

4 ETW000                                                                             894  0.060374

4 ETW000  [dev trc     ,00000]  -->oci_execute_stmt(con=0, stp=0x110fba2e0, iters=1, rowoff=0, dml_batch_errors=0)

4 ETW000                                                                              32  0.060406

4 ETW000  [dev trc     ,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,001s]

4 ETW000                                                                             557  0.060963

4 ETW000  [dev trc     ,00000]  -->oci_prepare_stmt(con=0, len=0, stp=0x110fba2e0)

4 ETW000                                                                              37  0.061000

4 ETW000  [dev trc     ,00000]         SELECT SID FROM V$MYSTAT WHERE ROWNUM<2                                                                   

4 ETW000                                                                              25  0.061025

4 ETW000  [dev trc     ,00000]  -->oci_define ( 0: SQLT_INT, l=  4, con=0, stp=0x110fba2e0, vp=0xfffffffffffe5e4,ip=0xfffffffffffe5e0,rlp=(nil),rcp=(nil))

4 ETW000                                                                              36  0.061061

4 ETW000  [dev trc     ,00000]  -->oci_execute_stmt(con=0, stp=0x110fba2e0, iters=1, rowoff=0, dml_batch_errors=0)

4 ETW000                                                                              31  0.061092

4 ETW000  [dev trc     ,00000]     OCIStmtExecute() failed with -1=OCI_ERROR        1278  0.062370

4 ETW000  [dev trc     ,00000]     SQL error 942:                                     18  0.062388

4 ETW000  [dev trc     ,00000]     ORA-00942: table or view does not exist                                                                       

4 ETW000                                                                              26  0.062414

4 ETW000  [dev trc     ,00000]  <--oci_execute_stmt(rc=942, iters-errors = 1-0) [time 0,001s]

4 ETW000                                                                              27  0.062441

4 ETW000  [dev trc     ,00000]  Could not read session ID from V$MYSTAT. rc=-1.       17  0.062458

4 ETW000  [dev trc     ,00000]  Now '/@SID' is connected: con=0, nls_hdl=0, session_id=-1.

4 ETW000                                                                              24  0.062482

4 ETW000  [dev trc     ,00000]  -->oci_prepare_stmt(con=0, len=0, stp=0x110fba2e0)

4 ETW000                                                                              27  0.062509

4 ETW000  [dev trc     ,00000]         ALTER SESSION SET NLS_SORT = BINARY                                                                       

4 ETW000                                                                              25  0.062534

4 ETW000  [dev trc     ,00000]  -->oci_execute_stmt(con=0, stp=0x110fba2e0, iters=1, rowoff=0, dml_batch_errors=0)

4 ETW000                                                                              31  0.062565

4 ETW000  [dev trc     ,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

4 ETW000                                                                             264  0.062829

4 ETW000  [dev trc     ,00000]  -->oci_prepare_stmt(con=0, len=0, stp=0x110fba2e0)

4 ETW000                                                                              32  0.062861

4 ETW000  [dev trc     ,00000]         SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)                                               

4 ETW000                                                                              25  0.062886

4 ETW000  [dev trc     ,00000]  -  oci_bind   ( 0: SQLT_STR, l=256, con=0, stp=0x110fba2e0, vp=0x9001000a7ad9738,ip=(nil),rlp=(nil),rcp=(nil))

4 ETW000                                                                              39  0.062925

4 ETW000  [dev trc     ,00000]  -  oci_bind   ( 1: SQLT_STR, l=256, con=0, stp=0x110fba2e0, vp=0xfffffffffffe2cc,ip=(nil),rlp=(nil),rcp=(nil))

4 ETW000                                                                            7154  0.070079

4 ETW000  [dev trc     ,00000]  -->oci_define ( 0: SQLT_STR, l=512, con=0, stp=0x110fba2e0, vp=0xfffffffffffe4cc,ip=0xfffffffffffe080,rlp=(nil),rcp=(nil))

4 ETW000                                                                             126  0.070205

4 ETW000  [dev trc     ,00000]  -->oci_define ( 1: SQLT_AFC, l=512, con=0, stp=0x110fba2e0, vp=0xfffffffffffe6cc,ip=0xfffffffffffe082,rlp=(nil),rcp=(nil))

4 ETW000                                                                              35  0.070240

4 ETW000  [dev trc     ,00000]  -->oci_execute_stmt(con=0, stp=0x110fba2e0, iters=1, rowoff=0, dml_batch_errors=0)

4 ETW000                                                                              56  0.070296

4 ETW000  [dev trc     ,00000]     OCIStmtExecute() failed with -1=OCI_ERROR         748  0.071044

4 ETW000  [dev trc     ,00000]     SQL error 942:                                     34  0.071078

4 ETW000  [dev trc     ,00000]     ORA-00942: table or view does not exist                                                                       

4 ETW000                                                                              36  0.071114

4 ETW000  [dev trc     ,00000]  <--oci_execute_stmt(rc=942, iters-errors = 1-0) [time 0,001s]

4 ETW000                                                                              27  0.071141

4 ETW000  [dbsloci.    ,00000]  *** ERROR => ORA-942 when accessing table SAPUSER

4 ETW000                                                                              31  0.071172

4 ETW000  [dev trc     ,00000]     set_ocica() -> SQL error code 942                  24  0.071196

4 ETW000  [dev trc     ,00000]  -->oci_get_errmsg (con=0, rc=942)                     27  0.071223

4 ETW000  [dev trc     ,00000]     OCIErrorGet -> SQL error code: 942                 42  0.071265

4 ETW000  [dev trc     ,00000]     ORA-00942: table or view does not exist                                                                       

4 ETW000                                                                              46  0.071311

4 ETW000  [dev trc     ,00000]  Disconnecting from connection 0 ...                   14  0.071325

4 ETW000  [dev trc     ,00000]  Rolling back transaction ...                          25  0.071350

4 ETW000  [dev trc     ,00000]  Closing user session (con=0,svchp=0x110faf6b8,usrhp=0x111030320)

4 ETW000                                                                             234  0.071584

4 ETW000  [dev trc     ,00000]  Disconnected (con=0) from ORACLE.                    417  0.072001

4 ETW000  [dev trc     ,00000]  Info: 99=DBSL_ERR_DB, oerr=942, try to connect with default password.

4 ETW000                                                                              43  0.072044

4 ETW000  [dev trc     ,00000]  Connecting as SAPR3/<pwd>@SID on connection 0 (nls 0) ... (dbsl 700 131011, UNICODE[2])

4 ETW000                                                                              26  0.072070

4 ETW000  [dev trc     ,00000]  Assigning username to user session: con=0, usrhp=0x111030320

4 ETW000                                                                              24  0.072094

4 ETW000  [dev trc     ,00000]  Assigning password to user session: con=0, usrhp=0x111030320

4 ETW000                                                                              27  0.072121

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con=0, usr=SAPR3/<pwd>, svchp=0x110faf6b8, srvhp=0x110faf8d8, usrhp=0x111030320)

4 ETW000                                                                             145  0.072266

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

4 ETW000                                                                            3301  0.075567

4 ETW000  [dev trc     ,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

4 ETW000                                                                             107  0.075674

4 ETW000  [dev trc     ,00000]     ORA-01017: invalid username/password; logon denied                                                            

4 ETW000                                                                              27  0.075701

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

4 ETW000                                                                              26  0.075727

4 ETW000  [dev trc     ,00000]     set_ocica() -> SQL error code 1017                 14  0.075741

4 ETW000  [dev trc     ,00000]  -->oci_get_errmsg (con=0, rc=1017)                    15  0.075756

4 ETW000  [dev trc     ,00000]     OCIErrorGet -> SQL error code: 1017                41  0.075797

4 ETW000  [dev trc     ,00000]     ORA-01017: invalid username/password; logon denied                                                            

4 ETW000                                                                              26  0.075823

4 ETW000  [dblink      ,00431]  ***LOG BY2=>sql error 1017   performing CON [dblink#5 @ 431]

4 ETW000                                                                              61  0.075884

4 ETW000  [dblink      ,00431]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]

4 ETW000                                                                              25  0.075909

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

Please help.

[former_member185239]

Hi Robby,

First of all , R3trans -d will not work for Java engine. It will always return that it will not able to connect to DB.

To analyse the issue , You have to follow the below things

- Try to open the config tool. If it able to connect , then your database is working fine

- You can also check the bootstrap log files for the same in work directory.

- Paste the bootstarp log file if the RC=66 , then you need to check the user SAPSR3DB user in dba_users table.

Either user is locked or expired.

With Regards

Ashutosh Chaturvedi

[manumohandas82]

Oops missed it was an EP system .

Please ignore my earlier post and proceeed as suggested BY Ashutosh

Thanks ,

Manu

[Former Member]

@Manu :OPS$ user is already there.

@ Ashutosh : the bootstrap log is  :

cat system.log

<!--LOGHEADER[START]/-->

<!--HELP[Manual modification of the header may cause parsing problem!]/-->

<!--LOGGINGVERSION[1.5.3.7185 - 630]/-->

<!--NAME[./bootstrap/system.log]/-->

<!--PATTERN[system.log]/-->

<!--FORMATTER[com.sap.tc.logging.ListFormatter]/-->

<!--ENCODING[UTF8]/-->

<!--LOGHEADER[END]/-->

#1.#B27D2FED6004000000000000005D012A000515C7A85645AE#1431322150412#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001005D012A000515C7A8564C7D#1431322150456#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002005D012A000515C7A8564D80#1431322150456#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003005D012A000515C7A8564E58#1431322150456#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004005D012A000515C7A8564F37#1431322150457#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005005D012A000515C7A862B9DB#1431322151270#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000004D014E000515C7A9D17B42#1431322175269#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001004D014E000515C7A9D17E6D#1431322175307#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002004D014E000515C7A9D17F53#1431322175307#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003004D014E000515C7A9D18037#1431322175307#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004004D014E000515C7A9D18100#1431322175308#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005004D014E000515C7A9DD5376#1431322176082#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED60040000000000000067004A000515C7AA5B5C92#1431322184304#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED60040000000000010067004A000515C7AA5B6045#1431322184343#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED60040000000000020067004A000515C7AA5B61B1#1431322184343#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED60040000000000030067004A000515C7AA5B62DE#1431322184344#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED60040000000000040067004A000515C7AA5B63F5#1431322184344#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED60040000000000050067004A000515C7AA6904EB#1431322185237#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000006200F8000515C7AB9AE9A2#1431322205243#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001006200F8000515C7AB9AED66#1431322205285#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002006200F8000515C7AB9AEE75#1431322205285#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003006200F8000515C7AB9AEF62#1431322205286#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004006200F8000515C7AB9AF059#1431322205286#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005006200F8000515C7ABA7FA83#1431322206140#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED600400000000000000820074000515C82D9AB081#1431324386270#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED600400000000000100820074000515C82D9AB41A#1431324386309#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED600400000000000200820074000515C82D9AB511#1431324386309#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED600400000000000300820074000515C82D9AB5EC#1431324386309#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED600400000000000400820074000515C82D9AB6C6#1431324386309#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED600400000000000500820074000515C82DA9C87A#1431324387296#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000004B01D4000515C82DD88E46#1431324390323#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001004B01D4000515C82DD891BF#1431324390363#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002004B01D4000515C82DD892CE#1431324390363#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003004B01D4000515C82DD893AB#1431324390364#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004004B01D4000515C82DD8947A#1431324390364#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005004B01D4000515C82DE44DB9#1431324391132#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000007500C4000515C82E0687EF#1431324393333#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001007500C4000515C82E068BBE#1431324393376#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002007500C4000515C82E068CDC#1431324393376#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003007500C4000515C82E068DD6#1431324393377#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004007500C4000515C82E068EF0#1431324393377#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005007500C4000515C82E13CC6F#1431324394244#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000007300FC000515C82E41FA49#1431324397235#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001007300FC000515C82E41FDD3#1431324397272#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002007300FC000515C82E41FED3#1431324397272#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003007300FC000515C82E41FFAC#1431324397272#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004007300FC000515C82E42008D#1431324397273#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005007300FC000515C82E4FA94E#1431324398167#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED600400000000000000460196000515CA0D273379#1431332431751#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED600400000000000100460196000515CA0D2736CE#1431332431804#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED600400000000000200460196000515CA0D2737C2#1431332431804#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED600400000000000300460196000515CA0D2738A1#1431332431804#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED600400000000000400460196000515CA0D273973#1431332431804#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED600400000000000500460196000515CA0D395074#1431332432989#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED600400000000000000460198000515CA0D659168#1431332435852#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED600400000000000100460198000515CA0D65950E#1431332435891#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED600400000000000200460198000515CA0D659638#1431332435891#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED600400000000000300460198000515CA0D65970D#1431332435891#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED600400000000000400460198000515CA0D6597D8#1431332435892#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED600400000000000500460198000515CA0D72195F#1431332436711#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000007800E2000515CA0D96C395#1431332439074#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001007800E2000515CA0D96C708#1431332439115#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002007800E2000515CA0D96C7EE#1431332439115#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003007800E2000515CA0D96C8D7#1431332439115#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004007800E2000515CA0D96C9A7#1431332439116#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005007800E2000515CA0DA6EE43#1431332440173#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000003C01E0000515CA0DD2FC9E#1431332443021#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001003C01E0000515CA0DD3034B#1431332443063#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002003C01E0000515CA0DD30426#1431332443063#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003003C01E0000515CA0DD30506#1431332443063#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004003C01E0000515CA0DD305D4#1431332443063#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005003C01E0000515CA0DE30579#1431332444108#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000004101F8000515CA1BC67FC2#1431332677087#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001004101F8000515CA1BC68331#1431332677124#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002004101F8000515CA1BC68424#1431332677125#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003004101F8000515CA1BC6850A#1431332677125#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004004101F8000515CA1BC685DD#1431332677125#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005004101F8000515CA1BD35248#1431332677963#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[main,5,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection {3}: code={0,number,integer}, state="{1}", message="{2}".#5#17002#<null>#Io exception: The Network Adapter could not establish the connection#jdbc:oracle:thin:@sapepdbci1-dr:1527:CPP#<null>#

#1.#B27D2FED6004000000000000006200F8000515CA2DB3FBFD#1431332977863#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001006200F8000515CA2DB3FF5D#1431332977901#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002006200F8000515CA2DB40067#1431332977901#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003006200F8000515CA2DB40159#1431332977901#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004006200F8000515CA2DB40226#1431332977902#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005006200F8000515CA2DC0ACAA#1431332978731#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[main,5,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection {3}: code={0,number,integer}, state="{1}", message="{2}".#5#17002#<null>#Io exception: The Network Adapter could not establish the connection#jdbc:oracle:thin:@sapepdbci1-dr:1527:CPP#<null>#

#1.#B27D2FED6004000000000000006500D0000515CA66575241#1431333928091#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001006500D0000515CA665755CE#1431333928129#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002006500D0000515CA665756AF#1431333928130#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003006500D0000515CA66575789#1431333928130#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004006500D0000515CA66575853#1431333928130#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005006500D0000515CA66657656#1431333929055#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000006500D2000515CA6687572E#1431333931238#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001006500D2000515CA66875AB1#1431333931276#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002006500D2000515CA66875BA0#1431333931277#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003006500D2000515CA66875CA1#1431333931277#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004006500D2000515CA66875D72#1431333931277#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005006500D2000515CA669413D5#1431333932110#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000004201BA000515CA66B4FF47#1431333934228#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001004201BA000515CA66B502C3#1431333934269#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002004201BA000515CA66B503B6#1431333934269#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003004201BA000515CA66B50481#1431333934269#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004004201BA000515CA66B50553#1431333934269#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005004201BA000515CA66C2AC1F#1431333935163#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

#1.#B27D2FED6004000000000000004201BC000515CA66E16D13#1431333937124#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_ssl.jar#

#1.#B27D2FED6004000000000001004201BC000515CA66E170F3#1431333937180#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/w3c_http.jar#

#1.#B27D2FED6004000000000002004201BC000515CA66E172EE#1431333937181#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_smime.jar#

#1.#B27D2FED6004000000000003004201BC000515CA66E173C1#1431333937181#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jsse.jar#

#1.#B27D2FED6004000000000004004201BC000515CA66E174A7#1431333937181#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###ConfigurationManager: found jar for secure store /sapmnt/CPP/CPP/global/security/lib/tools/iaik_jce.jar#

#1.#B27D2FED6004000000000005004201BC000515CA66EF30B1#1431333938081#/System/Database/sql/trace##com.sap.sql.trace.SQLTrace#######Thread[main,5,main]##0#0#Info#1#com.sap.sql.trace.SQLTrace#Java#com.sap.sql.trace_1602#com.sap.sql.log.OpenSQLResourceBundle#SQLTrace: Using implementation {0}.#1#LOGGING#

But it is not modified on today, Its of 10th May

And im not able to connect via configtool.

[manumohandas82]

Hi

Cn you check whether your Oracle  listner is running

the Network Adapter could not establish the connection#jdbc:oracle:thin:@sapepdbci1-dr:1527:CPP#<null>#

[ From ur CI server ]

lsnrctl -status

tnsping sapepdbci1

telnet sapepdbci 1527

Thanks ,

Manu

[Former Member]

Hi Manu,

The listener is running also able to Telnet.

When im starting sap it showing like :

startsap

Checking CPP Database

------------------------------

J2EE Database is not available via  test

See logfile JdbcCon.log

But still the sap is starting.

How it is starting without database ?

[manumohandas82]

Hi  Robby ,

Can you post the Java startup logs in /usr/sap/<CPP/JC<INS>/work directory

Also if possible post your Startup Profile

Thanks ,

Manu

[Former Member]

The log is here :

---------------------------------------------------

trc file: "/usr/sap/CPP/JC01/work/dev_bootstrap", trc level: 1, release: "700"

---------------------------------------------------

node name   : bootstrap

pid         : 8585256

system name : CPP

system nr.  : 01

started at  : Tue May 26 15:15:39 2015

arguments         :

          arg[00] : /usr/sap/CPP/JC01/exe/jlaunch

          arg[01] : pf=/usr/sap/CPP/SYS/profile/CPP_JC01_sapepapp01-dr

          arg[02] : -DSAPINFO=CPP_01_bootstrap

          arg[03] : pf=/usr/sap/CPP/SYS/profile/CPP_JC01_sapepapp01-dr

[Thr  1] Tue May 26 15:15:39 2015

[Thr  1] *** WARNING => INFO: Unknown property [instance.box.number=CPPJC01sapepapp01-dr] [jstartxx_mt. 841]

[Thr  1] *** WARNING => INFO: Unknown property [instance.en.host=sapepapp01-dr] [jstartxx_mt. 841]

[Thr  1] *** WARNING => INFO: Unknown property [instance.en.port=3200] [jstartxx_mt. 841]

[Thr  1] *** WARNING => INFO: Unknown property [instance.system.id=1] [jstartxx_mt. 841]

**********************************************************************

JStartupReadInstanceProperties: read instance properties [/usr/sap/CPP/JC01/j2ee/cluster/instance.properties]

-> ms host    : sapepapp01-dr

-> ms port    : 3900

-> OS libs    : /usr/sap/CPP/JC01/j2ee/os_libs

-> Admin URL  :

-> run mode   : normal

-> run action : NONE

-> enabled    : yes

**********************************************************************

**********************************************************************

Used property files

-> files [00] : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

**********************************************************************

**********************************************************************

Instance properties

-> ms host    : sapepapp01-dr

-> ms port    : 3900

-> os libs    : /usr/sap/CPP/JC01/j2ee/os_libs

-> admin URL  :

-> run mode   : normal

-> run action : NONE

-> enabled    : yes

**********************************************************************

**********************************************************************

Bootstrap nodes

-> [00] bootstrap            : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

-> [01] bootstrap_ID15898500 : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

-> [02] bootstrap_ID15898550 : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

-> [03] bootstrap_ID15898551 : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

**********************************************************************

**********************************************************************

Worker nodes

-> [00] ID15898500           : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

-> [01] ID15898550           : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

-> [02] ID15898551           : /usr/sap/CPP/JC01/j2ee/cluster/instance.properties

**********************************************************************

[Thr  1] JLaunchRequestQueueInit: create named pipe for ipc

[Thr  1] JLaunchRequestQueueInit: create pipe listener thread

[Thr 258] JLaunchRequestFunc: Thread 258 started as listener thread for np messages.

[Thr 515] WaitSyncSemThread: Thread 515 started as semaphore monitor thread.

[Thr  1] Tue May 26 15:15:40 2015

[Thr  1] SigISetDefaultAction : default handling for signal 20

[Thr  1] NiInit3: NI already initialized; param 'maxHandles' ignored (1;202)

[Thr  1] CPIC (version=700.2006.09.13)

[Thr  1] [Node: bootstrap] java home is set by profile parameter

        Java Home: /usr/java14_64

[Thr  1] JStartupICheckFrameworkPackage: can't find framework package /usr/sap/CPP/JC01/exe/jvmx.jar

**********************************************************************

JStartupIReadSection: read node properties [bootstrap]

-> node name          : bootstrap

-> node type          : bootstrap

-> node execute       : yes

-> java path          : /usr/java14_64

-> java parameters    : -Djco.jarm=1 -Xj9

-> java vm version    : J2RE 1.4.2 IBM J9 2.3 AIX ppc64-64 j9ap64142ifx-20100615 (JIT enabled)

-> java vm vendor     : IBM J9 VM (IBM Corporation)

-> java vm type       : server

-> java vm cpu        : ppc64

-> heap size          : 512M

-> root path          : /usr/sap/CPP/JC01/j2ee/cluster

-> class path         : ./bootstrap/launcher.jar

-> OS libs path       : /usr/sap/CPP/JC01/j2ee/os_libs

-> main class         : com.sap.engine.offline.OfflineToolStart

-> framework class    : com.sap.bc.proj.jstartup.JStartupFramework

-> registr. class     : com.sap.bc.proj.jstartup.JStartupNatives

-> framework path     : /usr/sap/CPP/JC01/exe/jstartup.jar:/usr/sap/CPP/JC01/exe/jvmx.jar

-> parameters         : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0158985

-> debuggable         : yes

-> debug mode         : no

-> debug port         : 60000

-> shutdown timeout   : 120000

**********************************************************************

[Thr 772] JLaunchIStartFunc: Thread 772 started as Java VM thread.

**********************************************************************

JHVM_LoadJavaVM: VM Arguments of node [bootstrap]

-> stack   : 1048576 Bytes

-> arg[  0]: exit

-> arg[  1]: abort

-> arg[  2]: vfprintf

-> arg[  3]: -Djco.jarm=1

-> arg[  4]: -Xj9

-> arg[  5]: -Dsys.global.dir=/usr/sap/CPP/SYS/global

-> arg[  6]: -Dapplication.home=/usr/sap/CPP/JC01/exe

-> arg[  7]: -Djava.class.path=/usr/sap/CPP/JC01/exe/jstartup.jar:/usr/sap/CPP/JC01/exe/jvmx.jar:./bootstrap/launcher.jar

-> arg[  8]: -Djava.library.path=/usr/java14_64/jre/bin:/usr/java14_64/jre/bin:/usr/java14_64/jre/bin/classic:/usr/sap/CPP/JC01/exe:/usr/sap/CPP/JC01/exe:/usr/sap/CPP/SYS/exe/run:/oracle/client/10x_64/instantclient:/usr/java14_64/jre/bin/j9vm:/usr/sap/CPP/JC01/exe::/usr/lib:/usr/sap/CPP/JC01/j2ee/os_libs:/usr/sap/CPP/JC01/exe:/usr/sap/CPP/JC01/exe:/usr/lib:/lib:/usr/sap/CPP/SYS/exe/run:/oracle/client/10x_64/instantclient

-> arg[  9]: -Dmemory.manager=512M

-> arg[ 10]: -Xmx512M

-> arg[ 11]: -DLoadBalanceRestricted=no

-> arg[ 12]: -Djstartup.mode=BOOTSTRAP

-> arg[ 13]: -Djstartup.ownProcessId=8585256

-> arg[ 14]: -Djstartup.ownHardwareId=Q1134382577

-> arg[ 15]: -Djstartup.whoami=bootstrap

-> arg[ 16]: -Djstartup.debuggable=yes

-> arg[ 17]: -DSAPINFO=CPP_01_bootstrap

-> arg[ 18]: -DSAPSTARTUP=1

-> arg[ 19]: -DSAPSYSTEM=01

-> arg[ 20]: -DSAPSYSTEMNAME=CPP

-> arg[ 21]: -DSAPMYNAME=sapepapp01-dr_CPP_01

-> arg[ 22]: -DSAPDBHOST=

-> arg[ 23]: -Dj2ee.dbhost=

**********************************************************************

[Thr 772] JHVM_LoadJavaVM: Java VM created OK.

**********************************************************************

JHVM_BuildArgumentList: main method arguments of node [bootstrap]

-> arg[  0]: com.sap.engine.bootstrap.Bootstrap

-> arg[  1]: ./bootstrap

-> arg[  2]: ID0158985

**********************************************************************

[Thr 772] Tue May 26 15:15:41 2015

[Thr 772] JHVM_RegisterNatives: registering methods in com.sap.bc.krn.perf.PerfTimes

[Thr 772] JLaunchIExitJava: exit hook is called (rc = 66)

[Thr 772] **********************************************************************

*** ERROR => The Java VM terminated with a non-zero exit code.

*** Please see SAP Note 943602 , section 'J2EE Engine exit codes'

*** for additional information and trouble shooting.

**********************************************************************

[Thr 772] SigISetIgnoreAction : SIG_IGN for signal 20

[Thr 772] JLaunchCloseProgram: good bye (exitcode = 66)

bash-4.2#

[former_member185239]

Hi robby,

Set the environment variable SAPDBHOST for user <sid>adm.

Then try to start the DB instance.

Select username , account_status from dba_users;

Check whether user sapsr3db is locked/expired or not. Also do paste the DEFAULT.PFL file.

With Regards

Ashutosh Chaturvedi

[Former Member]

Dear Ashutosh,

The default.pfl file is as follows:

SAPDBHOST = sapepdbci1-dr

j2ee/dbtype = ora

j2ee/dbname = CPP

j2ee/dbhost = sapepdbci1-dr

SAPSYSTEMNAME = CPP

OS_UNICODE = uc

SAPGLOBALHOST = sapepdbci1-dr

the user status is OPEN

[former_member185239]

Hi Robby,

Check the location of environment variable TNS_ADMIN.

tnsname.ora file should be present at TNS_ADMIN variable location.

Kindly check and confirm. Also do check the SAPDBHOST  environment variable.

With Regards

Ashutosh Chaturvedi.

[Former Member]

Dear Ashutosh,

################

# Filename......: tnsnames.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

CPP.WORLD =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS =

        (COMMUNITY = SAP.WORLD)

        (PROTOCOL = TCP)

        (HOST = sapepdbci1-dr)

        (PORT = 1527)

      )

    )

    (CONNECT_DATA =

      (SID = CPP)

      (GLOBAL_NAME = CPP.WORLD)

The tnsname.ora file is correct

[former_member185239]

Hi Robby,

Can you pls tells us the value of SAPDBHOST and TNS_ADMIN environment variable on server

sapepapp01-dr?

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

Its same like application server.

[former_member185239]

Hi Robby,

Can you please paste the content of secure storage.

- Open the configtool

- Click on connect to database

- Click on OK when it prompt the error.

- It will then show you the secure storage.

With Regards

Ashutosh Chaturvedi

[madasamy_arunachalam]

Hi Robby

Looks like the issue is with the listener, which may be started as local_listener or listener configuration is inconsistency status & have you upgraded the DB ?

to trouble shoot this,

A)  Check the parameter " local_listener" from db (run below command from SQL prompt)

   show parameter local_listener;

If this return a value, then your DB has local listener ; to check this further;

1) stop db

2) stop listener (lsnrctl stop)

3) delete .oracle folder from /tmp directory (this directory will be created when you start the listener)

4) start listener ("lsnrctl start CPP") , CPP is SID here ?

5) do not start db now, go to next step 6

6) start sap instance by running "startsap" script

I believe,  startsap script should  bringing up db and EP instance;

next, you need  to check this (bit confusing ) note to resolve this issue on permanent basis...

1915325 - Configuration of Oracle Database Parameter 'LOCAL_LISTENER'

regards

Swami

[Former Member]

Hi Ashutosh,

below is the configetool data :

[Former Member]

Dear Madasamy,

The listener is not started as local listener running.

The command output is as follows :

SQL> show parameter local_listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string

SQL>

[madasamy_arunachalam]

Hi Robby

This means, no listener issue then.

Anyway, can you perform above steps 1 to 4 & check for listener "CPP"  is coming up?

then step 6 ?

have you upgraded the DB for any patch set ?

regards

Swami

[madasamy_arunachalam]

Robby

Also can you ?

1) rename startsap.trc file under /home/cppadm

2) perform startsap

3) if still there is an error,

can you attach the trace file startsap.trc, will be at /home/cppadm/startsap.trc

regards

Swami

[madasamy_arunachalam]

Hi

The trace file /usr/sap/CPP/JC01/work/dev_bootstrap, shows warning for unknown property...

[Thr  1] Tue May 26 15:15:39 2015
[Thr  1] *** WARNING => INFO: Unknown property [instance.box.number=CPPJC01sapepapp01-dr] [jstartxx_mt. 841]
[Thr  1] *** WARNING => INFO: Unknown property [instance.en.host=sapepapp01-dr] [jstartxx_mt. 841]
[Thr  1] *** WARNING => INFO: Unknown property [instance.en.port=3200] [jstartxx_mt. 841]
[Thr  1] *** WARNING => INFO: Unknown property [instance.system.id=1] [jstartxx_mt. 841]

Timestamps shows 26th May, is it still the case ?

Is there any manual change in the properties file ?  instance.properties@ /usr/sap/CPP/<instance#>J01/j2ee/cluster

Check all required ports are available at OS level , e.g. 3901 will be used by AIX default NIM services

netstat -Aan | grep LISTEN | grep 3901

Is AIX version 6.1 or 7.1 ?

regards

Swami

[manumohandas82]

Check the following Note

361641 - Creating OPS$ users on UNIX