ORA-01005: null password given;

[#1]

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/<pwd>@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

[Former Member]

Hi Thom

Is you system Window based ?

For hint Check out 1194799,

Cheers

Shaji