Monday, March 12, 2012

SAP not starting because of database Error

Problem: SAP was not starting, because the dispatcher work process was unable to connect to the database.

Observations:1. Found in the dispatcher log (disp_dev) that all the Work Process were getting killed.
2. Ran R3trans –d and found that the log showed the error

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSID's password 68 0.066880
4 ETW000 [dev trc ,00000] Connecting as /@SID on connection 0 ... 28 0.066908
4 ETW000 [dev trc ,00000] Allocating service context handle 30 0.066938
4 ETW000 [dev trc ,00000] Allocating server context handle 25 0.066963
4 ETW000 [dev trc ,00000] Attaching to DB Server SID (con_hdl=0,svchp=025EA574,svrhp=025EB17C)
4 ETW000 70 0.067033
4 ETW000 [dev trc ,00000] Assigning server context 025EB17C to service context 025EA574
4 ETW000 40583 0.107616
4 ETW000 [dev trc ,00000] Allocating user session handle 56 0.107672
4 ETW000 [dev trc ,00000] Wed Nov 21 12:19:55 2007 227 0.107899
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=025EA574,srvhp=025EB17C,usrhp=025F3948)
4 ETW000 39 0.107938
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 7285 0.115223
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 34 0.115257
4 ETW000 [dev trc ,00000] Try to connect with default password 95 0.115352
4 ETW000 [dev trc ,00000] Connecting as SAPSID/@SID on connection 0 ...
4 ETW000 29 0.115381
4 ETW000 [dev trc ,00000] Assigning username to user session 025F3948 20 0.115401
4 ETW000 [dev trc ,00000] Assigning password to user session 025F3948 29 0.115430
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=025EA574,srvhp=025EB17C,usrhp=025F3948)
4 ETW000 35 0.115465
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 8428 0.123893
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 32 0.123925
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#1 @ 419]
4 ETW000 145 0.124070
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#1 @ 419]
4 ETW000 29 0.124099
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SID'"

3. When tried to logging into sqlplus “ / as sysdba” from command prompt using the userid (adm), it gave the following error “Insufficient Privileges”




4. Found that the parameter
SQLNET.AUTHENTICATION_SERVICES = was having the value “(NONE)” in file “sqlnet.ora” Parameter file.

5. Changed the parameter to SQLNET.AUTHENTICATION_SERVICES = (NTS), since then it started working

No comments: