ORA-01005: null password given;

[Former Member]

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

[stefan_koehler]

Hello Thom,

have you already tried to set a "new" password for the user SAPSR3?

It seems like that the password in the table SAPUSER is not valid (empty) anymore.

http://help.sap.com/saphelp_nw70/helpdata/en/4f/c3883989676778e10000000a11402f/content.htm

> brconnect -u system/<password>-f chpass -u SAPSR3

Regards

Stefan

[Former Member]

Hi!

No, we still have the same password. We are on Solaris.

As I mentioned when we set the kernel back to version 114 we can start system but it is not possible to log in into system.

With new Kernel SAP system does not start. Only Oracle-DB can be started manually. The R3trans -d gets error 12.

Do you have any ideas?

Should I execute brconnect commando -u system/<password>-f chpass -u SAPSR3 anyway?

[stefan_koehler]

Hello Thom,

> As I mentioned when we set the kernel back to version 114 we can start system but it is not possible to log in into system.

I am sorry, i missed that information in the first post. Indeed this looks very strange. Is the kernel version 114 able to access the SAPUSER table? Maybe the default password is used .. you can see this in the work process traces.

Just to get sure ... please run the following select statements to get the crypted password and users:

> shell> sqlplus "/ as sysdba"

> SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

> SLQ> SELECT * FROM <OWNER>.SAPUSER;

Regards

Stefan