EHP5 upgrade Error - phase MAIN_SHDINST/RUN_RSVWSCPY were negative

[Former Member]

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.

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP note 1161052 which states below:

Error in Phase RUN_RSVWSCPY

In phase RUN_RSVWSCPY an error occurs and you can find the following error message in the RSVWSCPY.ELG file:

"1EETGCLN OCI returned error code -1."

See SAP Note 1489566 for a solution.

Thanks

Sunny

[Former Member]

Dear Paul,

Thank you very much !!

The issue resolved by following.

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.

[paul_power]

Hello Bharath,

Basically the DB connection to the shadow instances is using the UPGSHD

connection that is maintained in table DBCON. You can access it using

transaction DBCO.

I guess an incorrect entry was made in some dialog, run the function

module CREATE_SHDDBCON to recreate this entry with correct database

identifier, after which then rerun this phase again and it should

work correctly.

regards,

Paul