Problem with work process starting after a kernel update

[Former Member]

Hi,

I have a problem when starting an instance after a kernel update. I change the kernel and work processes doesn´t work when try to start instance. The error that log shows is,

C Attaching to DB Server CRD (con_hdl=0,svchp=05BFF0B4,srvhp=05C00044)

C Starting user session (con_hdl=0,svchp=05BFF0B4,srvhp=05C00044,usrhp=05C0887C)

C Now '/@CRD' is connected: con_hdl=0, nls_hdl=0, session_id=19.

C Got SAPCRD's password from OPS$-user

C Disconnecting from connection 0 ...

C Close user session (con_hdl=0,svchp=05BFF0B4,usrhp=05C0887C)

C Now I'm disconnected from ORACLE

C Connecting as SAPCRD/ OCI-call 'OCISessionBegin' failed: rc = 1017

C *** ERROR => CONNECT failed with sql error '1017'

B ***LOG BY2=> sql error 1017 performing CON

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied

B ***LOG BY2=> sql error 1017 performing CON

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256)

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1)

Database is Oracle 9.2, and it is running and open.

I check note "Note 400241 - Problems with ops$ or sapr3 connect to Oracle" but it doesn´t help me.

It looks like a login procedure change between my old dboraslib.dll and my current dll.

Any idea??

Thanks.

[Former Member]

Hi Pablo,

This must be problem with Oracle user only. You can confirm that by checing R3trans -d and view the trans.log .

Also try login to oracle using schema user,OPS$ users manually.

Reinitialize the Schema user and OPS$ user using brtools and will resolve the problem.

Regards,

Karthick.

[Former Member]

Did you try to connect to oracle manually?

[debasissahoo]

HI,

ORA-01017: invalid username/password

if it was working before.. Check whether password for the database users have expired..

SQL> select username, account_status from dba_users;

if password change is required, use BR*tools only.

Regards,

Debasis.

Edited by: Debasis Sahoo on Apr 24, 2009 5:55 PM