on 10-20-2011 12:32 PM
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
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 share your suggestions to fix the issue.
Regards,
Bharath.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.