cancel
Showing results for 
Search instead for 
Did you mean: 

EHP5 upgrade Error - phase MAIN_SHDINST/RUN_RSVWSCPY were negative

Former Member
0 Kudos

Dear Experts,

Currently I am doing EHP5 upgrade on Oracle 10g with SuSE-LINUX10 OS , 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 share your suggestions to fix the issue.

Regards,

Bharath.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi All,

Please follow below instructions to resolve your problem:

Go to SE37, give FM name CREATE_SHDDBCON & excute.

Then provide the parameter values as mentioned below

DBUSER : <Schema for your shadow instance>

DBPASS : <Password of above schema>

CONENV : <SID>

Regards,

Bharath.