cancel
Showing results for 
Search instead for 
Did you mean: 

EHP4 upgrade Error - phase MAIN_SHDINST/RUN_RSVWSCPY were negative

Former Member
0 Kudos

Hello

Currently I am doing EHP4 upgrade on Oracle 10g with Sun Solaris 5.10 , During preprocessing phase ( The EhP Installation program builds the shadow system from the original one.)

I am getting following error

Checks after phase MAIN_SHDINST/RUN_RSVWSCPY were negative!

Last error code set: BATCH JOB RSUPG_COPY_SHD_VIEWS FAILED: Error(s) found in the log(s), accumulated in "RSVWSCPY.ELG".

Log file for RSVWSCPY.ELG as below

  1. cat RSVWSCPY.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Clone shadow views ERRORS and RETURN CODE in RSVWSCPY.<SID>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1EETGCLN ORA-12154: TNS:could not resolve the connect identifier specified

1EETGCLN Unable to open connection to shadow system.

1EETGCLN Use function module CREATE_SHDDBCON to adjust the settings for connection UPGSHD.

cat sqlnet.ora

===========

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

  1. 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

  1. 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

  1. 05.01.06 set to default

#TCP.NODELAY=YES

  1. 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

cat tnsnames.ora

=============

<SID>.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <hostname>)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = <SID>)

(GLOBAL_NAME = <SID>.WORLD)

)

)

===

Could you please help me to fix the issue.

Thanks , BM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Dear Experts,

Do anyone has solved the above problem?If so, please share the details of the solution as I am facing the same issue & also I verified all the things mentioned in the posts.

Please share the solution details if you have ASAP.

Regards,

Bharath.

0 Kudos

Hi Folks,

I had the same error when upgrading to NW701 (EHP1.SP6):

  1. cat RSVWSCPY.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Clone shadow views ERRORS and RETURN CODE in RSVWSCPY.<SID>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1EETGCLN ORA-12154: TNS:could not resolve the connect identifier specified

1EETGCLN Unable to open connection to shadow system.

1EETGCLN Use function module CREATE_SHDDBCON to adjust the settings for connection UPGSHD.

and the solution was applying oss Note 339092 - DB MultiConnect with Oracle as secondary database, used tcod: dbco and had to correct the <SID> in table dbcon:

database connection name DBS username connection information

-


UPGSHD ORA SAPR3SHD <MySAPSID>

the same thing, as was reported above (replace the SID ETD with yours.

Former Member
0 Kudos

Were you able to resolve this issue? I am having the same issue during EhP4 install on a ECC 6.0 system.

Thanks.

piya

Former Member
0 Kudos

please share solution i'm having similar issue

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Clone shadow views ERRORS and RETURN CODE in RSVWSCPY.RSD

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1EETGCLN ORA-01017: invalid username/password; logon denied

1EETGCLN Unable to open connection to shadow system.

1EETGCLN Use function module CREATE_SHDDBCON to adjust the settings for connection UPGSHD.

thanks in advance

Former Member
0 Kudos

Hi,

Login to your SAP system and execute "CREATE_SHDDBCON" function module, on SE37 with the parameters, below;


DBUSER -> SAPR3SHD
DBPASS -> <password>
CONENV -> DTE

And execute the function module. This fm will update your shadow system password.

At the Os level, execute the command, below;


brconnect -u / -f chpass -o SAPR3SHD -p <password>

Or, by using SQLplus;


sqlplus "/as sysdba"

alter user SAPR3SHD identified by <password>;

This command will change your shadow system password at the datab ase level.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hello Orkur,

Like bharath reddy and others, I´m facing with the same error, but in my case the platform is OS/400 (V7R1M0) database DB4!

I´m doing an EHP5 upgrade and it stopped in phase MAIN_SHDINST/RUN_RSVWSCPY, the following error is show me:

Checks after phase MAIN_SHDINST/RUN_RSVWSCPY were negative!
Last error code set: BATCH JOB RSUPG_COPY_SHD_VIEWS FAILED: Error(s)
found in the log(s), accumulated in "RSVWSCPY.ELG".

In that RSVWSCPY.ELG file it have the following details:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Clone shadow views ERRORS and RETURN CODE in RSVWSCPY.PRD
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1EETGCLN 
1EETGCLN Unable to open connection to shadow system.
1EETGCLN Use function module CREATE_SHDDBCON to adjust the settings for connection UPGSHD.

I performed what you mentioned, I execute "Create_SHDDBCON" function module on SE37... but I didn´t continue this execution because I´m not sure what I have to fill in that parameters: DBUSER ; DBPASS and CONENV. You recommended some values to that fields/parameters... but where you have been seeking this values/information? How you know that?

...

Can you help me/us?

Thank you

JC project