Migration to new server

[satish]

Dear erman,
Existing environment rhel 5 32 bit,app R12 1.3 and db 11.1.0.7

New server with rhel 9 54 bit installed.we are cloning existing environment to new server.

We faced this error while running clone.

[oracrp@ssstuaterpdb02 bin]$ perl adcfgclone.pl dbTechStack

 

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

 

Oracle Applications Rapid Clone

 

Version 12.0.0

 

adcfgclone Version 120.31.12010000.8

 

Enter the APPS password :

 

Running:
/u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u02/CRP/db/tech_st/11.1.0/appsutil/clone/jlib/java:/u02/CRP/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/u02/CRP/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_12378.lst -stage /u02/CRP/db/tech_st/11.1.0/appsutil/clone -dbTechStack 2> /tmp/adcfgclone_12378.err; echo $? > /tmp/adcfgclone_12378.res

 

Log file located at /u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0316020445.log

 

Provide the values required for creation of the new Database Context file.

 

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

 

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

 

Target System Database SID : SSSEBSCR

 

Target System Base Directory : /u02/CRP

 

Target System utl_file_dir Directory List :
RC-00212: Warning: Input value cannot be null

 

Target System utl_file_dir Directory List : /usr/tmp

 

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

 

Target System DATA_TOP Directory 1 [/u02/PROD/db/apps_st/data] : /u02/CRP/db/apps_st/data

 

Target System RDBMS ORACLE_HOME Directory [/u02/CRP/db/tech_st/11.1.0] :

 

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

 

Target System Display [ssstuaterpdb02:0.0] :

 

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

 

Invalid input value. 'y' or 'n' required.

 


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

 

Target System Port Pool [0-99] : 8

 

Checking the port pool 8
done: Port Pool 8 is free
Report file located at /u02/CRP/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /u02/CRP/db/tech_st/11.1.0/appsutil/temp/portpool.lst

 

Creating the new Database Context file from :
/u02/CRP/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

 


Source and Target platforms differ. Rapid Clone will perform a platform migration.
Do you wish to continue? [y] :
The new database context file has been created :
/u02/CRP/db/tech_st/11.1.0/appsutil/SSSEBSCR_ssstuaterpdb02.xml
RC-50004: Error occurred in CloneContext:
null
Check Clone Context logfile /u02/CRP/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0316020445.log for details.

 

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_12378.err if present.

[satish]

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]$

[ErmanArslansOracleBlog]

1)What is the MOS document that you follow for this task?
2)What is your source DB and target DB versions?
3)Please check source and target context files.. What are the values of platform oa_var=s_platform osd,  pathsep oa_var= osd, lib_ext oa_var osd ?


Gathere info:

*Platform migration

*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)

*MOS document that may be related -> RC-50004: Error Occurred In Clonecontext and "java.lang.NullPointerException" during Rapiclone on dbTier (Doc ID 443667.1)

[satish]

Dear erman,


Source is 32bit rhel 5 and target is rhel 9 64 bit
Db version in source and target is 11.1.0.7
Apps version in source and target r12.1.3
Target is new server and it is the first clone

Thank you

[ErmanArslansOracleBlog]

Please answer the questions 1 and 3 as well.

[satish]

Dear erman,

source server

[oraprod@SSSTINDCPODB02 ~]$ grep -i s_platform $CONTEXT_FILE
<platform oa_var="s_platform" osd="Linux">Linux</platform>
[oraprod@SSSTINDCPODB02 ~]$ grep -i pathsep $CONTEXT_FILE
<pathsep oa_var="/" osd="unix">/</pathsep>
[oraprod@SSSTINDCPODB02 ~]$ grep -i s_lib_ext $CONTEXT_FILE
<lib_ext oa_var="s_lib_ext" osd="Linux">so</lib_ext>
[oraprod@SSSTINDCPODB02 ~]$



target server

[oracrp@ssstuaterpdb02 ~]$ cd /u02/CRP/db/tech_st/11.1.0/appsutil/
[oracrp@ssstuaterpdb02 appsutil]$ grep -i s_platform SSSEBSCR_ssstuaterpdb02.xml
<platform oa_var="s_platform" osd="LINUX_X86-64">LINUX_X86-64</platform>
[oracrp@ssstuaterpdb02 appsutil]$ grep -i pathsep SSSEBSCR_ssstuaterpdb02.xml
<pathsep oa_var="/" osd="unix">/</pathsep>
[oracrp@ssstuaterpdb02 appsutil]$ grep -i s_lib_ext SSSEBSCR_ssstuaterpdb02.xml
<lib_ext oa_var="s_lib_ext" osd="LINUX_X86-64">so</lib_ext>

[satish]

Support said to Follow 471566.1...migration from 32bit to 64bit is 2 step process and first step is cloning.

[satish]

Dear erman,

Provided requested information.Any advice please.

Thank you

[ErmanArslansOracleBlog]

that's why I keep asking this question -> What is the MOS document that you follow for this task?
And Yes, you have to follow "Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Doc ID 471566.1)"

But you are saying "migration from 32bit to 64bit is 2 step process and first step is cloning." What do you mean by that?

You will prepare the source system and then copy it to the target and then configure it there.. You will also run adcfgclone, but when the right time comes..
During the way, you will do lots of stuff as documented in 471566.1..
You should follow that document line by line.

Please start this work from scratch by following 471566.1 line by line and ask me question if any.

*Any new question should be a new issue/thread. Please create a seperate question for your every seperate question.