Skip to Content
0
Former Member
Feb 05, 2009 at 10:07 AM

Oracle SAPSR3 user locked

1338 Views

Hi

I am new to SAP.

I have installed SAP ERP 6.0 on Win 64 bit with Oracle 10.2

Installation was successful. All the processes in SAP management cosole were up.

I checked the following urls

http:
<IP>:50000\nwa

http:
<IP>:50000\irj

http:
<IP>:50000\rep

http:
<IP>:50000\sld

I was able to login in nwa with J2EE_ADMIN

For some reasons I had to restart my server, after that I found that disp_work dint start and SAPSR3 was locked. I am unable to recall any significant change that can cause this issue.

As guided on different forums and on SAP note 400241 & 50088, I checked the following

dev_w<xx> logs were showing message

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@NG1 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000117E8120 00000000117F0350 000000001180CB78

C Attaching to DB Server NG1 (con_hdl=0,svchp=000000001180CA38,srvhp=000000001180EE68)

C Starting user session (con_hdl=0,svchp=000000001180CA38,srvhp=000000001180EE68,usrhp=00000000117F0B68)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

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

[dbsloci.c 11044]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@NG1 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000117E8120 00000000117F0350 000000001180CB78

C Starting user session (con_hdl=0,svchp=000000001180CA38,srvhp=000000001180EE68,usrhp=00000000117F0B68)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=28000

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=000000001180CA38,srvhp=000000001180EE68)

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

[dbsloci.c 11044]

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

B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 28000 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-28000: the account is locked [dblink#5 @ 431] [dblink 0431 ]

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

I checked the users in oracle database service

I found following users [NG1 is SID and SAP-SERVER is macine name]

OPS$SAP-SERVER\NG1ADM

OPS$SAP-SERVER\SAPSERVICENG1

OPS$SAP-SERVER\SAPSERVICESR3

I tried to connect to sqlplus with all above users, it was fine. Even tried to connect without machine name that also worked fine.

I checked sqlnet.ora, settings were fine

SQLNET.AUTHENTICATION_SERVICES = (NTS)

I checked Oracle parameter remote_os_authent, its value is true

os_authent_prefix is OPS$

password for SAPSR3 user in oracle was not SAP

Everything looked OK, finally I changed the password for SAPSR3 to SAP and executed the command

brconnect -u NG1ADM/SAP12345 -f chpass -o SAPSR3 -p SAP

and started my SAP server instance, it started successfully.

Can anybody help on this, how can I keep a different password for SAPSR3.

Do I need to create users like :-

OPS\NG1ADM

OPS\SAPSERVICENG1

OPS\SAPSERVICESR3

Thanks

Ruhi