on 12-21-2009 5:02 PM
Batchjob RSUPG_COPY_SHD_VIEWS aborted. A review of SM37 log for this job shows an uncaught exception - ST22 says error is ORA-01017: invalid username/password logon denied. The job is run by DDIC in client 000. The dev_w0 shows the following error:
B Connect to UPGSHD as SAPR3SHD with SB2
C application info callback registered
C Client NLS setting (OCINlsGetInfo): connection handle 2 -> 'AMERICAN_AMERICA.UTF8'
C Connecting as SAPR3SHD/<pwd>@SB2 on connection 2 (nls_hdl 0) ... (dbsl 700 220409)
C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch
C 0 UTF8 0x107293c20 0x10729b6e0 0x1072abe78
C Starting user session: OCISessionBegin(con_hdl=2, usr=SAPR3SHD/<pwd>, svchp=0x107e2db28, srvhp=0x1072aed78, usrhp=0x107b29e98)
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 11239]
B ***LOG BY2=> sql error 1017 performing CON [dbds#2 @ 1056] [dbds 1056 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbds#2 @ 1056] [dbds 1056 ]
B ***LOG BY1=> sql error 1017 [dbacds#2 @ 1433] [dbacds 1433 ]
I used brtools to change SAPR3SHD pw to the default ('sap'), but it still fails with the error above. Any ideas? TIA
Steve
Edited by: Steve Robertson on Dec 21, 2009 7:55 PM
Hi Steve,
Have you tried to connect with this user to database with the password you changed with brtools ?
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sunny,
After I changed the password for SAPR3SHD, I did the following:
1) restarted the failing phase - still failed in the same batch job for the same reason
2) stopped and restarted SAPehpi - still failed in the same batch job forthe same reason
3) stopped and restarted the SAP system, restarted SAPehpi - failed again.
I thought that each time I ran this step it would be reconnecting with SAPR3SHD, is there another way to validate the pw change?
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.