Erman Arslan's Oracle Forum - Re: Migration to new server

Erman Arslan's Oracle Forum › EBS 12.1/12.0/11i

Re: Migration to new server

Posted by satish on Mar 16, 2022; 3:41am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migration-to-new-server-tp10762p10763.html

Log file

[oracrp@ssstuaterpdb02 bin]$ cat /u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0316020445.log
Using admin directory: /u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin
#----------------------------------------------
#------Log File time stamp: 0316020445------------
# $Header: CloneContext.java 120.92.12010000.21 2010/09/27 17:54:57 mismith ship $
# Running on - ssstuaterpdb02
# Source Host - null
# Domain Name - ssst.org
# Context Location - /u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml
# Context Type - null
# Context Template - null
# Clone Stage Area - /u02/CRP/db/tech_st/11.1.0/appsutil/clone
# Pairs File - /tmp/adpairsfile_12378.lst
# Destination Context - null
# Validation - true
# Platform Migration - false
# no prompt - false
#----------------------------------------------

Variables extracted from pairsfile: /tmp/adpairsfile_12378.lst
****************************************************/n
s_dbuser = oracrp
s_dbgroup = dba
****************************************************

PROMPT :
Target System Hostname (virtual or normal) [ssstuaterpdb02]
ANSWER :
ssstuaterpdb02

PROMPT :
Target Instance is RAC (y/n) [n]
ANSWER :
n

PROMPT :
Target System Database SID
ANSWER :
SSSEBSCR

PROMPT :
Target System Base Directory
ANSWER :
/u02/CRP

PROMPT :
Target System utl_file_dir Directory List
ANSWER :
/usr/tmp

PROMPT :
Number of DATA_TOP's on the Target System [1]
ANSWER :
1

PROMPT :
Target System DATA_TOP Directory 1 [/u02/PROD/db/apps_st/data]
ANSWER :
/u02/CRP/db/apps_st/data
Skipping the validation of s_dbhome1
Creating /u02/CRP/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.

PROMPT :
Target System RDBMS ORACLE_HOME Directory [/u02/CRP/db/tech_st/11.1.0]
ANSWER :
/u02/CRP/db/tech_st/11.1.0
Creating /u02/CRP/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.

PROMPT :
Do you want to preserve the Display [ssstindcpodb02:1.0] (y/n)
ANSWER :
n

PROMPT :
Target System Display [ssstuaterpdb02:0.0]
ANSWER :
ssstuaterpdb02:0.0

PROMPT :
Do you want the the target system to have the same port values as the source system (y/n) [y] ?
ANSWER :
8

PROMPT :
Do you want the the target system to have the same port values as the source system (y/n) [y] ?
ANSWER :
n
Started testing the availabilty of ports in port pool 8

Checking Database Port on ssstuaterpdb02: Port Value = 1529
Database Port available: Port Value = 1529
Checking DB ONS Local Port on ssstuaterpdb02: Port Value = 6308
DB ONS Local Port available: Port Value = 6308
Checking DB ONS Remote Port on ssstuaterpdb02: Port Value = 6408
DB ONS Remote Port available: Port Value = 6408

INFO: Unable to obtan DB Version!!!

INFO: Because DB Version could not be obtained, defaulting s_jdktop and s_jretop to adxdbctx.tmp defined values

setDestination s_contextfile to : /u02/CRP/db/tech_st/11.1.0/appsutil/SSSEBSCR_ssstuaterpdb02.xml
Clone Context Parameters:
Pairs File = /tmp/adpairsfile_12378.lst
Target XML File = /u02/CRP/db/tech_st/11.1.0/appsutil/SSSEBSCR_ssstuaterpdb02.xml
Template File = /u02/CRP/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

The following values will be used to create the context file

****************************************************

s_isWeb = YES
s_db_listener = SSSEBSCR
s_db_util_filedir = /usr/tmp
s_db_rollback_segs = NOROLLBACK
s_dbhome4 = /u02/CRP/db/apps_st/data
s_dbhome3 = /u02/CRP/db/apps_st/data
s_dbhost = ssstuaterpdb02
s_db_oh = /u02/CRP/db/tech_st/11.1.0
s_dbhome2 = /u02/CRP/db/apps_st/data
s_dbhome1 = /u02/CRP/db/apps_st/data
s_dbgroup = dba
s_dbGlnam = SSSEBSCR
s_dbdomain = ssst.org
s_dbSid = SSSEBSCR
s_dbuser = oracrp
s_isForms = YES
s_database_type =
s_temp = /u02/CRP/db/tech_st/11.1.0/appsutil/temp
s_db_ons_localport = 6308
s_hostname = ssstuaterpdb02
s_dbSidLower = sssebscr
s_cmanport = 1529
s_dbCluster = false
s_domainname = ssst.org
s_isAdmin = YES
s_isConc = YES
s_contextfile = /u02/CRP/db/tech_st/11.1.0/appsutil/SSSEBSCR_ssstuaterpdb02.xml
s_dbport = 1529
s_display = ssstuaterpdb02:0.0
s_contextname = SSSEBSCR_ssstuaterpdb02
s_db_ons_remoteport = 6408
s_clonestage = /u02/CRP/db/tech_st/11.1.0/appsutil/clone
s_base = /u02/CRP
****************************************************

Clone Context will now iteratively apply changes
to create the new target context file.

instantiate file:
source : /u02/CRP/db/tech_st/11.1.0/appsutil/temp.xml
dest : /tmp/tmpCtxClone.xml
instantiate file:
source : /tmp/tmpCtxClone.xml
dest : /tmp/tmpCtxClone.xml
instantiate file:
source : /tmp/tmpCtxClone.xml
dest : /tmp/tmpCtxClone.xml
instantiate file:
source : /tmp/tmpCtxClone.xml
dest : /tmp/tmpCtxClone.xml
instantiate file:
source : /tmp/tmpCtxClone.xml
dest : /u02/CRP/db/tech_st/11.1.0/appsutil/SSSEBSCR_ssstuaterpdb02.xml
instantiate file:
source : /u02/CRP/db/tech_st/11.1.0/appsutil/temp.xml
dest : /tmp//dummy.xml
instantiate file:
source : /tmp//dummy.xml
dest : /tmp//dummy.xml
instantiate file:
source : /tmp//dummy.xml
dest : /tmp//dummy.xml
instantiate file:
source : /tmp//dummy.xml
dest : /tmp//dummy.xml
instantiate file:
source : /tmp//dummy.xml
dest : /tmp//dummy.xml

PROMPT :
Source and Target platforms differ. Rapid Clone will perform a platform migration.
Do you wish to continue? [y]
ANSWER :
y

The values for these variables will be retained from the source context

****************************************************

s_admin_restrictions = ON
s_metalink_id =
s_parallel_max_servers = 8
s_systemcsi = N/A
s_apps_version = 12.1.3
s_contextserial = 0
s_instThread = 0
s_sqlnet_expire_time = 10
s_contexttype = Database Context
s_db_sga_target = 1G
s_dbsharedpool_size = 300000000
s_db_shared_pool_size = 400M
s_clusterServicePort = 9998
s_scan_name =
s_dbcache_size = 163577856
s_rapidwizloc = /u02/StageR12/startCD/Disk1/rapidwiz
s_archive_format = %t_%s_%r.dbf
s_db_pga_aggregate_target = 1G
s_sqlnet_inbound_connect_timeout = 60
s_dbtype = PROD
s_proxyhost =
s_nthreads = 5
s_db_processes = 200
s_enable_listener_password = OFF
s_alt_service_instances =
s_dbClusterInst = 1
s_installedFrom = FS
s_update_scan = FALSE
s_undo_tablespace = APPS_UNDOTS1
s_adjreopts = -Xms128M -Xmx512M
s_dbQuorumDisk =
s_db_linkctrl =
s_dbcomp = oracle.apps.dbseed.fresh
s_db_sessions = 400
s_installloc = /u02/StageR12/startCD/Disk1
s_isDB = YES
s_proxyport =
s_database = db111
s_dbseed = Fresh Install
s_apps_user = APPS
s_lsnr_log_status = ON
s_dbfiles = 512
s_db_shared_pool_reserved_size = 40M
s_bits = 32
s_dbblock_buffers = 20000
s_sys_user = SYS
s_diag_adr_enabled = ON
s_dlsnstatus = enabled
s_db_plsql_native_library_subdir_count = 149
s_country_code =
s_subscribe_for_node_down_event = OFF
s_instNumber = 0
s_scan_port =

*********************************************

The new context file has been created at:
/u02/CRP/db/tech_st/11.1.0/appsutil/SSSEBSCR_ssstuaterpdb02.xml

*******************************************

Performing file system cleanup specific to Platform Migration:

StackTrace:
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at oracle.apps.ad.clone.util.CloneCleanser.doMigrate(CloneCleanser.java:98)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:717)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:5259)

RC-50004: Error occurred in CloneContext:
null
Context file creation not succesful
[oracrp@ssstuaterpdb02 bin]$
[oracrp@ssstuaterpdb02 bin]$