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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值