ora 01005 linux,ORA-01005: null password given;
Hi!
We have problem to start SAP system after DB recover.
Attempt with Kernel 133
the SAP system will be started, unfortunately no log in is possible. We get in SAP log in windows bellow the error: DB-error, meanwhile the user/password is correct.
Attempt with Kernel 133
After Kernel-Patch (from 114 to 133) we have problems to start SAP system due to ORA-error:
ORA-01005: null password given; logon denied.
Enclosed the R3trans log-file:
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,
stmth_p=1011b2bd0)
4 ETW000
1665 0.201694
4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE
ROWNUM<2
4 ETW000
54 0.201748
4 ETW000 [dev trc ,00000] Connected to session 70.
1329 0.203077
4 ETW000 [dev trc ,00000] Now '/@ES6' is connected: con_hdl=0,
nls_hdl=0, session_id=70.
4 ETW000
33 0.203110
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,
stmth_p=1011b2bd0)
4 ETW000
31 0.203141
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000
26 0.203167
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,
stmth_p=1011b2bd0)
4 ETW000
849 0.204016
4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER
WHERE USERID IN (:A0, :A1)
4 ETW000
28 0.204044
4 ETW000 [dev trc ,00000] Got SAPSR3's password from OPS$-user
1613 0.205657
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ...
31 0.205688
4 ETW000 [dev trc ,00000] Rolling back transaction ...
64 0.205752
4 ETW000 [dev trc ,00000] Closing user session
(con_hdl=0,svchp=1011a6e78,usrhp=101197028)
4 ETW000
243 0.205995
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE
1340 0.207335
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/@ES6 on
connection 0 (nls_hdl 0) ... (dbsl 700 030508)
4 ETW000
145 0.207480
4 ETW000 [dev trc ,00000] Nls CharacterSet
NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000
29 0.207509
4 ETW000 [dev trc ,00000] 0 UTF8
1 10118edc0 101196810 1011a6f48
4 ETW000
28 0.207537
4 ETW000 [dev trc ,00000] Assigning username to user session
101197028 18 0.207555
4 ETW000 [dev trc ,00000] Assigning password to user session
101197028 28 0.207583
4 ETW000 [dev trc ,00000] Starting user session
(con_hdl=0,svchp=1011a6e78,srvhp=1011a9168,usrhp=101197028)
4 ETW000
57 0.207640
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin'
failed with rc=1005
4 ETW000
197 0.207837
4 ETW000 [dev trc ,00000]
server_detach(con_hdl=0,stale=1,svrhp=1011a9168)
4 ETW000
24 0.207861
4 ETW000 [dev trc ,00000] Detaching from DB Server
(con_hdl=0,svchp=1011a6e78,srvhp=1011a9168)
4 ETW000
24 0.207885
4 ETW000 [dev trc ,00000] Deallocating server context handle
1011a9168 8982 0.216867
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error
'1005'
4 ETW000
73 0.216940
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code
1005 50 0.216990
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1005 performing CON
[dblink#5 @ 431]
4 ETW000
178 0.217168
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01005: null password given;
logon denied [dblink#5 @ 431]
4 ETW000
25 0.217193
2EETW169 no connect possible: "DBMS = ORACLE ---
dbs_ora_tnsname = 'ES6'"
~
Can some one please help to solve this problem?
Thank you very much!
Regards
Thom
文章来自于网络,如果侵犯了您的权益,请联系站长删除!