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