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