Hi Experts,
My database and listener r up and running . now when i start SAP , it gives me error ,
wmgadm> startsap
Checking WMG Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
***********************************************************************
This is Saposcol Version COLL 20.95 700 - V3.72 64Bit
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 20931) is already running .....
************************************************************************
saposcol already running
ABAP Database WMG must be started on remote server
And when i did R3trans -d i got 00012 return code .
Trans.log states as below
[dev trc ,00000] Assigning server context 0x1b43728 to service context 0x1b41438
4 ETW000 72078 0.100843
4 ETW000 [dev trc ,00000] Allocating user session handle 51 0.100894
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728,usrhp=0x1b315e8)
4 ETW000 34 0.100928
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
4 ETW000 9125 0.110053
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x1b43728)
4 ETW000 23 0.110076
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728)
4 ETW000 22 0.110098
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1b43728 222 0.110320
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'
4 ETW000 41 0.110361
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 14 0.110375
4 ETW000 [dev trc ,00000] Try to connect with default password 54 0.110429
4 ETW000 [dev trc ,00000] Connecting as SAPDAT/<pwd>@WMG on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
4 ETW000 24 0.110453
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 25 0.110478
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1b29380 0x1b30dd0 0x1b41508
4 ETW000 23 0.110501
4 ETW000 [dev trc ,00000] Allocating server context handle 13 0.110514
4 ETW000 [dev trc ,00000] Attaching to DB Server WMG (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728)
4 ETW000 34 0.110548
4 ETW000 [dev trc ,00000] Assigning server context 0x1b43728 to service context 0x1b41438
4 ETW000 67834 0.178382
4 ETW000 [dev trc ,00000] Assigning username to user session 0x1b315e8 19 0.178401
4 ETW000 [dev trc ,00000] Assigning password to user session 0x1b315e8 45 0.178446
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728,usrhp=0x1b315e8)
4 ETW000 27 0.178473
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
4 ETW000 7041 0.185514
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x1b43728)
4 ETW000 22 0.185536
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728)
4 ETW000 21 0.185557
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1b43728 121 0.185678
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'
4 ETW000 56 0.185734
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 13 0.185747
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1033 performing CON [dblink#5 @ 431]
4 ETW000 109 0.185856
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#5 @ 431]
4 ETW000 21 0.185877
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'WMG'"
Please help me out