cancel
Showing results for 
Search instead for 
Did you mean: 

EHP4 upgrade error: MAIN_SHDINST/RUN_RSVWSCPY Batchjob RSUPG_COPY_SHD_VIEWS

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi Steve,

Have you tried to connect with this user to database with the password you changed with brtools ?

Thanks

Sunny

Former Member
0 Kudos

Hi Sunny,

Yes, In the GUI I repeated the RUN_RSVWSCPY phase and got the same result.

Steve

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

I think you did not understand me. I asked you when you changed password of SAP<Schema>shd password. After that have you tried to connect to database with same user.

Also, after changing the password, please stop upgrade and start again upgrade tool to repeat the same phase.

Thanks

Sunny

Former Member
0 Kudos

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?

Former Member
0 Kudos

Sunny,

I also, in SQLPLUS, logged on successfully using sapr2shd with the new, changed password.

Steve

Former Member
0 Kudos

My impasse was resolved by following Juha Yli-Uotila's suggestion in thread:

;

his suggestion was this sql command:

SQL> update SAP<SCHEMA>.DBCON set PASSWORD='sap' where CON_NAME='UPGSHD' ;

Thanks Juha!

Edited by: Steve Robertson on Dec 24, 2009 8:31 PM

peter_dzurov
Contributor
0 Kudos

Hi,

please check following threads:

Former Member
0 Kudos

Thank you for your tip, I encountered sam problem, rsupg_copy_shd_views aborted due to ora-1017 erro, after update dbcon with new password the issue got resolved.

Answers (0)