s Sakhalkar

Mar 20, 2009 at 06:51 PM

Instance not starting

80 Views

Hello All,

My SAP server is not starting,please find attached the R3trans -d , trans.log output

4 ETW000 r3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).

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

4 ETW000

4 ETW000 date&time : 21.03.2009 - 00:18:51

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] Sat Mar 21 00:18:53 2009 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 16292 0.016292

4 ETW000 [dev trc ,00000] using "D:\usr\sap\GPS\SYS\exe\nuc\NTI386\dboraslib.dll"

4 ETW000 35 0.016327

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 14 0.016341

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 22 0.016363

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.158)

4 ETW000 166 0.016529

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 22 0.016551

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 31 0.016582

4 ETW000 [dev trc ,00000] New connection 0 created 25 0.016607

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 28 0.016635

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

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

4 ETW000 19 0.016677

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 22 0.016699

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 242 0.016941

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 34299 0.051240

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 34 0.051274

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 4301 0.055575

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

4 ETW000 [dev trc ,00000] Connecting as /@GPS on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 28 0.055636

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

4 ETW000 26 0.055662

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026C5E80 026CB3B4 026CAC3C

4 ETW000 142 0.055804

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

4 ETW000 [dev trc ,00000] Allocating server context handle 22 0.055853

4 ETW000 [dev trc ,00000] Attaching to DB Server GPS (con_hdl=0,svchp=026CAB88,srvhp=026CEDFC)

4 ETW000 61 0.055914

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12514

4 ETW000 37725 0.093639

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

4 ETW000 25 0.093664

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12514 10761 0.104425

4 ETW000 [dev trc ,00000] Try to connect with default password 18 0.104443

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

4 ETW000 22 0.104465

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

4 ETW000 22 0.104487

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026C5E80 026CB3B4 026CAC3C

4 ETW000 21 0.104508

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=026CEDFC) 14 0.104522

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=026CAB88,srvhp=026CEDFC)

4 ETW000 21 0.104543

4 ETW000 [dev trc ,00000] Deallocating server context handle 026CEDFC 20 0.104563

4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.104584

4 ETW000 [dev trc ,00000] Attaching to DB Server GPS (con_hdl=0,svchp=026CAB88,srvhp=026CEDFC)

4 ETW000 33 0.104617

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12514

4 ETW000 19846 0.124463

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

4 ETW000 24 0.124487

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12514 14 0.124501

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

4 ETW000 18719 0.143220

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [dblink#5 @ 431]

4 ETW000 22 0.143242

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