SAP not starting.

[Former Member]

Hi Guys,

I am facing problem with my sap system.

Here is the log from dev_w0.

Sat Jan 14 21:52:28 2012

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=00000000080F6C18, srvhp=00000000080F7758, usrhp=0000000008104670)

C CbApplInfoGet() failed (ignored 1).

C Now '/@PBD' is connected: con_hdl=0, nls_hdl=0, session_id=133.

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=00000000080F6C18,usrhp=0000000008104670)

C Disconnected (con=0) from ORACLE.

C Connecting as SAPSR3/<pwd>@PBD on connection 0 (nls 0) ... (dbsl 701 090311, UNICODE[2])

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=00000000080F6C18, srvhp=00000000080F7758, usrhp=0000000008104670)

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 28001:

C ORA-28001: the password has expired

C Detaching from DB Server (con_hdl=0,svchp=00000000080F6C18,srvhp=00000000080F7758)

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

[dbsloci.c 11330]

B ***LOG BY2=> sql error 28001 performing CON [dbsh#2 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> ORA-28001: the password has expired [dbsh#2 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error 28001 performing CON [dblink#4 @ 433] [dblink 0433 ]

B ***LOG BY0=> ORA-28001: the password has expired [dblink#4 @ 433] [dblink 0433 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1505]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10652]

Please advice how to proceed.

Regards

Abhishek

[Former Member]

Hi

You should use the script attached to OSS note

1519872 - SAP Database User Profile SAPUPROF

sapuprof_profile.zip

Regards

Yves

[Former Member]

Hi,

I have reset the password for SAPSR3 using below command

ALTER USER SAPSR3 IDENTIFIED BY <new_password>;

And then unlocked the SAPSR3 using

ALTER USER SAPSR3 account unlock;

But now in dev_w0 i m getting error stating.

CbApplInfoGet() failed (ignored 1).

C Now '/@PBD' is connected: con_hdl=0, nls_hdl=0, session_id=130.

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0000000008247118,usrhp=0000000008254B70)

C Disconnected (con=0) from ORACLE.

C Connecting as SAPSR3/<pwd>@PBD on connection 0 (nls 0) ... (dbsl 701 090311, UNICODE[2])

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0000000008247118, srvhp=0000000008247EC8, usrhp=0000000008254B70)

C

C Sun Jan 15 02:05:18 2012

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C ORA-01017: invalid username/password; logon denied

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

[dbsloci.c 11330]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#4 @ 433] [dblink 0433 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#4 @ 433] [dblink 0433 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 150

Please advice how to proceed.

Regards

Abhishek

[Former Member]

Hello Abhishek

have you checked Note 1576837 - ORA-01017: invalid username/password; ???

Cheers,

Diego.

[Former Member]

Hi Abhishek,

ORA-01017: invalid username/password; logon denied - What situation you getting this ? Did you do system copy ?

try below

sqlplus / as sysdba

truncate "OPS$XXXX\PBDADM".SAPUSER;

insert into "OPS$XXXX\PBDADM".SAPUSER values ('SAPSR3','your_password');

grant select, update on "OPS$XXXX\PBDADM".SAPUSER to "OPS$XXXX\SAPSERVICEPBD";

Regards,

Arjun

[Former Member]

Hi,

No we have not done system copy.

Just system got shutdown and now when i m starting the above mentioned error are coming in dev_w0

Regards

Abhishek

[Former Member]

Hello Abhishek,

Please reset the password as follows and try to restart the system.

brconnect -u system/<password> -f chpass -o sapsr3 -p <password>

Thanks,

Siva Kumar

[former_member189725]

change the password using brconnect as mentioned by Siva.

Make sure the password never expires in future , hence issue the following.

SELECT profile FROM dba_users WHERE username = 'SAPSR3';

Once you get the profile , then

ALTER PROFILE <profile_name> LIMIT PASSWORD_LIFE_TIME UNLIMITED;

This is never let the password to expire for all users belonging to the profile . In general the profile name is default.