on 05-11-2011 8:26 AM
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
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
05.01.06 unsorported parameter now
#NAME.DEFAULT_ZONE = WORLD
05.01.06 set the default to 10
SQLNET.EXPIRE_TIME = 10
05.01.06 set to default
#TCP.NODELAY=YES
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Folks,
I had the same error when upgrading to NW701 (EHP1.SP6):
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Were you able to resolve this issue? I am having the same issue during EhP4 install on a ECC 6.0 system.
Thanks.
piya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.