Skip to Content
0
Former Member
Jan 22, 2014 at 09:37 AM

SAP Startup error after kernel upgrade

86 Views

Hi

I have upgraded to kernel 700 patch 278 but unfortunately after that system is not getting up. Database is

started successfully but R3trans -d is giving following error.

ERROR => CONNECT failed with sql error '1005'

ORA-01005: null password given; logon denied

After that to troubleshoot I reverted the kernel upgrade to older version 700 sp 185 then system starts successfully.

Please see attached trans.log

Please suggest in this.

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,033s]

Got SAPSR3's password from OPS$-user

Disconnecting from connection 0 ...

Rolling back transaction ...

Closing user session (con_hdl=0,svchp=110a68a40,usrhp=110ad2e40)

Now I'm disconnected from ORACLE

Connect as 'SAPSR3' with found password from table SAPUSER

Connecting as SAPSR3/<pwd>@MES on connection 0 (nls_hdl 0) ... (dbsl 700 140910)

Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

0 UTF8 110a5cda0 110a68d38 110a69dd8

Assigning username to user session: con_hdl=0, usrhp=110ad2e40

Assigning password to user session: con_hdl=0, usrhp=110ad2e40

Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=110a68a40, srvhp=110a6ba00, usrhp=110ad2e40)

OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR

OCISessionBegin(OCI_DEFAULT) failed with SQL error 1005:

ORA-01005: null password given; logon denied

server_detach(con_hdl=0,stale=1,svrhp=110a6ba00)

Detaching from DB Server (con_hdl=0,svchp=110a68a40,srvhp=110a6ba00)

Deallocating server context handle 110a6ba00 from con_hdl=0

*** ERROR => CONNECT failed with sql error '1005'

set_ocica() -> SQL error code 1005

-->oci_get_errmsg (con_hdl=0, rc=1005)

OCIErrorGet -> SQL error code: 1005

ORA-01005: null password given; logon denied

***LOG BY2=>sql error 1005 performing CON [dblink#8 @ 433]

***LOG BY0=>ORA-01005: null password given; logon denied [dblink#8 @ 433]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'MES'"

Regards

Sukhwinder

Attachments

trans.txt.zip (3.2 kB)