11I CLONING ISSUES:
*******************
Troubleshooting RapidClone issues with Oracle Applications 11i [ID : 364565.1]
DB TIER:
********
ISSUE 1:
kshell unable to connect.
orasdev@oraapps # export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
*********************************************************************************************************************
ISSUE 2:
While running adcfgclone on the "DBTIER" we would get the following error:
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/visdb/proddb/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing
ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for errors
When we would go through the adcfgclone.err:
vi /tmp/adcfgclone.err
orasdev@oraapps # cp $iAS_TOP/portal30/admin/plsql/lib/classes111.zip /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/jlib/
*********************************************************************************************************************
ISSUE 3:
While running adcfgclone on the "DBTIER" we would get the following error:
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for errors
orasdev@oraapps # vi /tmp/adcfgclone.err
orasdev@oraapps # /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory
*******************************************************************************************************************
ISSUE 4:
Jdk file installation
root@oraapps # chmod +x jdk-6u26-linux-i586-rpm.bin
root@oraapps # ./jdk-6u26-linux-i586-rpm.bin
*****************************************************************************************************************
ISSUE 5:
ln -s /usr/lib/libstdc++-libc6.2.2.so.3 /usr/lib/libstdc++-libc6.1-1.so.2
*********************************************************************************************************************
ISSUE 6:
The 806 installer uses the oratab file.
The file oratab needs to exist at:
/etc/oratab
Rapid Clone will use the oraInst.loc file.
The file oraInst.loc needs to exist at:
/etc/oraInst.loc
Please run the script /tmp/orainstRoot.sh as root
Restart adclone.pl after performing required corrections.
ERROR: Failed to execute /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/bin/adclone.pl
Please check logfile.
root@oraapps # cd /tmp
root@oraapps tmp # sh orainstRoot.sh
******************************************************************************************************************
ISSUE 7:
Beginning database tier Apply - Mon May 7 19:24:48 2012
Log file located at /sdev/p02/oracle/pixdb/9.2.0/appsutil/log/sdev_oraapps/Apply DBTier_05070724.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
RC-50014: Fatal: Execution of AutoConfig was failed
ERROR while running Apply... 50%
ERROR: Failed to execute /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/bin/adclone.pl
Please check logfile.
root@oraapps # vi /sdev/p02/oracle/pixdb/9.2.0/appsutil/log/sdev_oraapps/Apply DBTier_05070724.log
afmkinit.sh exiting with status 127
.end std out.
cp: error while loading shared libraries: /usr/lib/libc.so.6: invalid ELF header
touch: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
.end err out.
****************************************************
Skipping Profile Phase
Skipping Apply Phase
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /sdev/p02/oracle/pixdb/9.2.0/appsutil/install/sdev_oraapps
afmkinit.sh INSTE8_SETUP 127
AutoConfig is exiting with status 1
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: RC-50014: Fatal: Execution of AutoConfig was failed
at oracle.apps.ad.clone.ApplyDatabase.checkAutoConfigErr(ApplyDatabase.java:2792)
at oracle.apps.ad.clone.ApplyDatabase.runAutoConfig(ApplyDatabase.java:2587)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:595)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)
root@oraapps # vi /sdev/p02/oracle/pixdb/9.2.0/appsutil/bin/adgetlnxver.sh
Edit from LD to XD
**********************************************************************************************************************
APPS TIER:
**********
ISSUE 1:
kshell unable to connect.
orasdev@oraapps # export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
**********************************************************************************************************************
ISSUE 2:
/etc/oraInst.loc points to an Inventory that does not exist:
/home/orasdev/oraInventory
mkdir /home/orasdev/oraInventory: Permission denied at /sdev/p01/oracle/pixcomn/clone/bin/adclone.pl line 1331
ERROR: Failed to execute /sdev/p01/oracle/pixcomn/clone/bin/adclone.pl
Please check logfile.
root@oraapps # vi /etc/oraInst.loc
Edit from /home/orasdev/oraInventory to /home/applsdev/oraInventory
*********************************************************************************************************************
ISSUE 3:
Beginning application tier Apply - Mon May 7 20:16:57 2012
Log file located at /sdev/p01/oracle/pixappl/admin/sdev_oraapps/log/ApplyAppsTier_05070816.log
/ 50% completed
AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.
Restored the Context file in :
/sdev/p01/oracle/pixappl/admin/sdev_oraapps.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed
Completed Apply...
Mon May 7 20:21:57 2012
Beginning APPSIAS_sdev registration to central inventory...
ORACLE_HOME NAME : APPSIAS_sdev
ORACLE_HOME PATH : /sdev/p01/oracle/pixora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /home/applsdev/oraInventory/logs/OracleHomeCloner_05070821.log
ORACLE_HOME /sdev/p01/oracle/pixora/iAS was registered successfully.
Skipping the starting of services
INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors.
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem
Once Autoconfig issue is fixed , you can start services
root@oraapps # vi /sdev/p01/oracle/pixappl/admin/sdev_oraapps/log/ApplyAppsTier_05070821.log
error while loading shared library libdb.so.3
error while loading shared library libdl.so.2
error while loading shared library librt.so.1
adautoconfig.sh exiting status with 127
(or)
adautoconfig.sh exiting status with 49
Solution:-
[applsdev@oraapps]$ cd /sdev/p01/oracle/pixappl
[applsdev@oraapps]$ . ./APPSsdev_oraapps.env
[applsdev@oraapps]$ unset LD_LIBRARY_PATH
[applsdev@oraapps]$ echo $LD_ASSUME_KERNEL
2.4.19
[applsdev@oraapps]$ unset LD_ASSUME_KERNEL
Apply Below Patch:-
Download patch no : 6365595
[applsdev@oraapps]$ cd /home/applsdev
[applsdev@oraapps]$ ls
oraInventory 6365595 p6365595_11i_GENERIC.zip
[applsdev@oraapps]$ unzip p6365595_11i_GENERIC.zip
[applsdev@oraapps]$ sh $AD_TOP/bin/adadmin
Make the maintenance mode.
[applsdev@oraapps]$ cd /home/applsdev
[applsdev@oraapps]$ chmod -R 777 6365595
[applsdev@oraapps]$ cd 6365595/
[applsdev@oraapps 6365595]$ ls
ad b6365595.ldt f6365595.ldt marker1.txt README.html README.txt u6365595.drv
[applsdev@oraapps 6365595]$ adpatch
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AutoPatch
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.
Your default directory is '/oracle/PROD1/prod1appl'.
Is this the correct APPL_TOP [Yes] ?
AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adpatch.log] : 6365595.log
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [PROD1] : PROD1 *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [dev144] : dev144 *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'PROD1'
using ORACLE executables in '/oracle/PROD1/prod1ora/8.0.6'.
Is this the correct database [Yes] ?
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: manager
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
Identifier for the current session is 1756
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [11i.AD.I.2]
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
**************** S T A R T O F U P L O A D ****************
Start date: Thu Feb 23 2012 14:32:06
0 "left over" javaupdates.txt files uploaded to DB: Thu Feb 23 2012 14:32:06
0 patches uploaded from the ADPSV format patch history files: Thu Feb 23 2012 14:32:06
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Feb 23 2012 14:32:06
****************** E N D O F U P L O A D ******************
End date: Thu Feb 23 2012 14:32:06
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/home/oracle/6365595] :
Please enter the name of your AutoPatch driver file : u6365595.drv
Getting Oracle Applications Release...
Current installed release is 11.5.10.2
Reading patch driver file...
Parsing and loading patch driver file...
154 lines processed.
Not checking patch integrity as integrity checking flag is turned off.
Successfully read patch driver file.
Determining target release...
Current target release is 11.5.10.2
Determining which bug fixes to apply...
Done determining which bug fixes to apply.
Log and Info File sync point:
Thu Feb 23 2012 14:32:11
Turning off actions that reference unrecognized products.
Log and Info File sync point:
Thu Feb 23 2012 14:32:11
End of unrecognized products checking.
AutoPatch will run in serial mode.
Did not need to apply new applterr.txt.
Applying new applprod.txt (if any)...
Did not need to apply new applprod.txt.
Performing version checking for driver files...
Log and Info File sync point:
Thu Feb 23 2012 14:32:11
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.
Copying driver files into installation area...
No driver files were selected for copying.
Skipping...
ForceCopy driver files into installation area for Specified driver
since no such action is present for this driver file
Screening out files not valid for this installation...
Determining valid on-site files...
Skipping...
Extract object modules from libraries for Specified driver
since no such action is present for this driver file
Performing version checking...
Log and Info File sync point:
Thu Feb 23 2012 14:32:17
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.
Skipping...
Determine directories to create for Specified driver
since no such action is present for this driver file
Skipping...
Determine executables to link for Specified driver
since no such action is present for this driver file
Skipping...
Determine forms to generate for Specified driver
since no such action is present for this driver file
Skipping...
Determine Oracle Reports libraries to generate for Specified driver
since no such action is present for this driver file
Skipping...
Determine reports to generate for Specified driver
since no such action is present for this driver file
Skipping...
Determine if need to generate message files for Specified driver
since no such action is present for this driver file
Looking for active bug fixes with no active actions...
Reading customized files list (if any)...
This patch replaces the following customized files:
No customized files are replaced by this patch.
Copying files into installation area...
**********************************************************
You are running admvcode
Header information is:
$Header: aiopatch.lc 115.44 2004/07/07 09:05:05 cbhati ship $
Start of admvcode session
Date/Time is Thu Feb 23 2012 14:32:17
Filelist file is: /oracle/PROD1/prod1appl/admin/PROD1/out/copymast.txt
Patch Character Set is: us7ascii
On-site Character Set is: US7ASCII
Log and Info File sync point:
Thu Feb 23 2012 14:32:17
Information about files copied to the APPL_TOP would be written to the
informational message file.
No character set conversion is required.
Copying files to APPL_TOP...
0 directories created.
1 files copied without character set conversion.
0 files copied with successful character set conversion.
1 files copied successfully.
0 files had fatal errors.
admvcode is exiting with status 0
End of admvcode session
Date/time is Thu Feb 23 2012 14:32:17
**********************************************************
Done copying files into installation area.
Skipping...
ForceCopy files into installation area for Specified driver
since no such action is present for this driver file
Skipping...
Archive object modules into product libraries for Specified driver
since no such action is present for this driver file
Skipping...
Create Directories for Specified driver
since no such action is present for this driver file
Skipping...
Relink for Specified driver
since no such action is present for this driver file
Performing second half of mirrored copies...
No mirrored copies were executed in this patch.
Updating Oracle Applications Java files if necessary...
No Oracle Applications Java files required updates.
Checking to see if any files possibly included in the product JAR files
were copied by this patch...
No files possibly included in the product JAR files
were copied by this patch.
Skipping ...
Running AutoConfig to instantiate templates which affect
the generation of JAR files since none of these templates
were patched during this run of adpatch.
No product JAR files need to be re-generated.
Checking to see if adjborg.txt or any files included in
adjborg.txt were copied by this patch...
Neither adjborg.txt nor any file included in
adjborg.txt was copied by this patch.
Checking to see if adjborg2.txt or any files included in
adjborg2.txt were copied by this patch...
Neither adjborg2.txt nor any file included in
adjborg2.txt was copied by this patch.
Compiling JSP files...
Not compiling JSPs: no JSPs in patch.
No JSP files were compiled.
Skipping...
Run SQL scripts and EXEC commands for Specified driver
since no such action is present for this driver file
Attempting to maintain MRC...
No action necessary for MRC.
Skipping...
Compile invalid objects for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms library files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports for Specified driver
since no such action is present for this driver file
Skipping...
Generate graphics libraries for Specified driver
since no such action is present for this driver file
Skipping...
Generate graphics for Specified driver
since no such action is present for this driver file
Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file
Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file
Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.
Saving Patch History information to Database...
Trying to obtain a lock...
> Inserted 1 patch history records (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 9 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).
Updating the current-view snapshot...
Done saving Patch History information.
About to do IREP processing...
Attempting to process IREP files ...
The package FND_ADPATCH does not exist, continuing...
Done IREP processing.
Copying applprod.tmp to applprod.txt (if needed)...
Did not need to copy applprod.tmp to applprod.txt.
Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
Did not need to copy admin/PROD1/applterr.txt to admin/applterr.txt.
There is no timing information available for the current session.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.lgi
Errors and warnings are listed in the log file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.log
and in other log files in the same directory.
[applsdev@oraapps]$ cd $COMMON_TOP/admin/scripts/sdev_oraapps
[applsdev@oraapps]$ ./adautocfg.sh
Enter the APPS user password:
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using APPL_TOP location : /oracle/PROD1/prod1appl
Classpath : /oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/oracle/PROD1/prod1comn/java/appsborg2.zip:/oracle/PROD1/prod1comn/java
Using Context file : /oracle/PROD1/prod1appl/admin/PROD1_dev144.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring ABM_TOP.......COMPLETED
Configuring ECX_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring GL_TOP........COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring XNC_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring PA_TOP........COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring IMT_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
The log file for this session is located at: /oracle/PROD1/prod1appl/admin/PROD1_dev144/log/02231433/adconfig.log
REF : http://muthuappsdba.blogspot.in/2012/02/touch-error-while-loading-shared.html
DISABLE MAINTENANCE MODE USING ADADMIN
************************************************************************************************************************
ISSUE 4:
[applsdev@oraapps sdev_oraapps]$./adstrtal.sh apps/apps
You are running adstrtal.sh version 115.16
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adapcctl.sh start
script returned:
****************************************************
adapcctl.sh version 115.47
Starting Apache Web Server Listener (dedicated HTTP) ...
Starting Apache Web Server Listener (dedicated PLSQL) ...
adapcctl.sh: exiting with status 3
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version
Checking for FNDFS executable.
Starting listener process APPS_sdev.
adalnctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 115.24
Starting concurrent manager for sdev ...
Starting sdev_0508@sdev Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfrmctl.sh start
script returned:
****************************************************
You are running adfrmctl.sh version 115.37
Starting forms server for sdev on port 9051.
adfrmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adrepctl.sh start
script returned:
****************************************************
You are running adrepctl.sh version 115.31
starting Reports Server for sdev on port 7051.
adrepctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfmcctl.sh start
script returned:
****************************************************
You are running adfmcctl.sh version 115.19
Starting forms load balancing client for sdev.
adfmcctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfmsctl.sh start
script returned:
****************************************************
You are running adfmsctl.sh version 115.15
starting forms metrics server for sdev.
adfmsctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 115.16
Validating Fulfillment patch level via /sdev/p01/oracle/pixcomn/java
Fulfillment patch level validated.
Starting Fulfillment Server for sdev on port 9351 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Check logfile /sdev/p01/oracle/pixcomn/admin/log/sdev_oraapps/05081532.log for details
Exiting with status 1
solution:
Download and apply the OS library patch 6078836
root@oraapps # ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
**********************************************************
END
**********************************************************
For Oracle Linux 5 and Red Hat Enterprise Linux 5 only :
# ln -s /usr/bin/ld215 /usr/bin/ld
Download and apply the OS library patch 6078836 from My Oracle Support and create the following symbolic link:
# ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
But i resolved the issue by copying the libdb.so.3 file from working server instance to the required server.
FINALLY I CLONED AN 11I INSTANCE SUCCESSFULLY.
********************************************************************************************************************
ANOTHER ONE ISSUE 1:
applfdev@oraapps # perl adcfgclone.pl appsTier /fdev/p01/oracle/pixappl/admin/fdev_oraapps.xml
Cannot proceed with ApplyApplTop - the paths/ports in the context file are not valid.
RC-20403: The following port numbers are busy - please make sure the ports are available and try again.
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
s_webssl_port : 443
--------------------------------------
StackTrace:
java.lang.Exception: Cannot proceed with ApplyAppsTechStack - the paths/ports in the context file are not valid.
at oracle.apps.ad.clone.ApplyAppsTechStack.validateContext(ApplyAppsTechStack.java:428)
NOTHING TO WORRY
SOLUTION
applfdev@oraapps # perl adcfgclone.pl appsTier
REF : https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocID=390901.1&from=BOOKMARK&bmDocDsrc=KB&viewingMode=1143))
ID : 390901.1
*********************************************************************************************************************
ISSUE 2 :
Autoconfig exiting status with 1
When checking logfile
"Thread: Error:ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated"
SOLUTION :
applfdev@oraapps # sqlplus apps/apps
applfdev@oraapps # select APPL_TOP_ID, NAME from ad_appl_tops;
APPL_TOP_ID NAME
----------- --------------------------------------------------
2069 *PRESEEDED*
2072 oraapps
2075 ebs
2078 ebs
1)What to do next, how to take backup of ad_timestamps, ad_appl_tops?
2)How to remove the rows which correspond to current node (on which the script is failing)
esp search for these rows in AD_TIMESTAMPS(ID 727990.1)?
1. create table ad_appl_tops_bak as select * from ad_appl_tops;
create table ad_timestamps_bak as select * from ad_timestamps;
2. delete ad_appl_tops where APPLICATIONS_SYSTEM_NAME='rdev';
3. commit;
Now autoconfig success and instance up.
ID 727990.1
REF :
https://support.oracle.com/CSP/ui/flash.html#tab=Dashboard(page=Dashboard&id=h23bc530()),(page=KBNavigator&id=h23bfsdt(searchControl=1146&&&searchMode=1145&viewingMode=1143))
https://forums.oracle.com/forums/thread.jspa?threadID=1049923
*********************************************************************************************************************
11I APPLICATION ISSUE :
ISSUE :
While giving concurrent manager request through forms it show the following error message
" concurrent phase 'completed,error' and also it denotes previous server url in forms.
When we click 'view log' in application it shows the following error message.
+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDSCARU module: Active Responsibilities
+---------------------------------------------------------------------------+
Current system time is 14-MAY-2012 17:07:22
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
APPLLCSP Environment Variable set to :
XML_REPORTS_XENVIRONMENT is :
/mdev/p01/oracle/pixora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to: /mdev/p01/oracle/pixora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
Spawned Process 21853
ar60run: relocation error: /mdev/p01/oracle/pixora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Program exited with status 127
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 2908360.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
SOLUTION :
RPM PACKAGE MISSING
root@server2 # rpm -ivh compat-libcwait-2.1-1.i386.rpm
ISSUE SOLVED............................
REF : https://forums.oracle.com/forums/thread.jspa?threadID=2192653
***************************************************************************************************************************
ANOTHER ISSUE:
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:658)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)
controlfile created.
SOLUTION :
SQL> connect / as sysdba
SQL> shutdown immediate
SQL> startup mount
SQL> recover database using backup controlfile until cancel;
-- type CANCEL
SQL> alter database open resetlogs;
startup listener using script.
ISSUE SOLVED.....................................................................
********************************************************************************************************************************
ANOTHER ISSUE :
Autoconfig exiting status with 99
While checking logfile it shows as follows,
*******FATAL ERROR*******
PROGRAM : (txkGenExtSecConf.pl)
TIME : Wed Oct 14 22:41:34 2009
FUNCTION: TXK::IO::chmod [ Level 3 ]
MESSAGES:
error = Unable to chmod file - mode 511
errorno = Operation not permitted
SOLUTION
This error came in application tier. So i gave 777 permission to application files and rerun autoconfig
Now issue SOLVED......................................................................
*******************************************************************************************************************
ANOTHER ISSUE :
Autoconfig exiting status with 1
failed adadmprf.sh
while checking logfile it shows as follows,
Unique constraint error (00001) is OK if key already exists
Application server ID already exists for this host
While running adadmprf.sh it shows
ERROR:
ORA-12154: TNS:could not resolve service name
SOLUTION :
1) Login to sqlplus as user APPS
2) EXEC FND_CONC_CLONE.SETUP_CLEAN;
3) Repopulate FND_NODES by running Autoconfig on all middle tier nodes
4) SQL> SELECT table_name, column_name FROM all_tab_columns WHERE column_name LIKE 'APPLICATION%SYSTEM%NAME%';
5) SQL>create table FND_PRODUCT_GROUPS_BAK as select * from FND_PRODUCT_GROUPS;
6) SQL> update FND_PRODUCT_GROUPS set APPLICATIONS_SYSTEM_NAME = ‘<NEW DATABASE NAME>’ ;
7) COMMIT;
8) RUN AUTOCONFIG IN MIDDLE TIER
NOW ISSUE SOLVED...................
Ref : http://onlineappsdba.com/index.php/2008/05/13/cloning-oam-system-name-pointing-to-source-instance/
*********************************************************************************************************************
ISSUE:
While applying patch it shows following error message.
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
ORA-01403: no data found
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2472
ORA-06512: at line 2
AutoPatch error:
Error while executing statement (curr-vw inst)
Error calling adusnapInstCurrVwSnapshot(ebs,11.5.10.2).
Error calling adphistLoadPtchHistFromFStoDB2
Updating the current-view snapshot...
ORA-01403: no data found
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2095
ORA-06512: at line 2
AutoPatch error:
Error while executing statement (curr-vw updt)
SOLUTION :
SQL> select APPL_TOP_ID, NAME,APPLICATIONS_SYSTEM_NAME from ad_appl_tops;
APPL_TOP_ID NAME
----------- --------------------------------------------------
APPLICATIONS_SYSTEM_NAME
------------------------------
2069 *PRESEEDED*
*PRESEEDED*
2072 ebs
udev
SQL> select APPL_TOP_ID, NAME,APPLICATIONS_SYSTEM_NAME from ad_appl_tops_bak;
APPL_TOP_ID NAME
----------- --------------------------------------------------
APPLICATIONS_SYSTEM_NAME
------------------------------
2071 GLOBAL
hdev
2069 *PRESEEDED*
*PRESEEDED*
2070 ebs
hdev
SQL> update ad_appl_tops set APPL_TOP_ID='2070' where APPL_TOP_ID='2072';
-----> here 2070 is source id and 2072 is target id.
1 row updated.
SQL> commit;
Run Autoconfig and check the patching it solved........
Ref : http://oracleappstechnology.blogspot.in/2009/02/ora-01403-ora-06512-at.html
*******************************************************************************************************************************************************
Issue :
--------
While Running adcfgclone.pl on dbTier it shows following error message,
ora-27101 shared memory realm does not exist
linux error 2 no such file or directory
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Solution :
----------
Run autoconfig on appstier
Run $AD_TOP/bin/admkappsutil.pl and copy $INST_TOP/admin/out/appsutil.zip & unzip it to <RDBMS ORACLE_HOME>
Run $ORACLE_HOME/appsutil/bin/adbldxml.pl appsuser=apps appspasswd=apps
Run autoconfig on dbTier -> $ORACLE_HOME/appsutil/bin/adconfig.sh
Run adpreclone on dbTier
Run adpreclone on appsTier
Stop DB and its listener processes
Shutdown the Database with (Normal, Immediate ) Mode
Bring down the application services
Crosscheck with alert log whether DB has been shutdown completely
Run the following OS command to confirm/crosscheck that no DB process running , if any DB processes running , terminate them manually
ps -ef | grep pmon
Copy all the datafiles from Source to Target
Copy application file system to target.
Run the clone configuration command:
cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
perl adcfgclone.pl dbTier
Run the clone configuration command:
cd <COMMON_TOP>/clone/bin
perl adcfgclone.pl appsTier
**********************************************************************************************************************************************************************************************************
*******************
Troubleshooting RapidClone issues with Oracle Applications 11i [ID : 364565.1]
DB TIER:
********
ISSUE 1:
kshell unable to connect.
orasdev@oraapps # export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
*********************************************************************************************************************
ISSUE 2:
While running adcfgclone on the "DBTIER" we would get the following error:
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/visdb/proddb/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing
ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for errors
When we would go through the adcfgclone.err:
vi /tmp/adcfgclone.err
orasdev@oraapps # cp $iAS_TOP/portal30/admin/plsql/lib/classes111.zip /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/jlib/
*********************************************************************************************************************
ISSUE 3:
While running adcfgclone on the "DBTIER" we would get the following error:
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for errors
orasdev@oraapps # vi /tmp/adcfgclone.err
orasdev@oraapps # /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory
*******************************************************************************************************************
ISSUE 4:
Jdk file installation
root@oraapps # chmod +x jdk-6u26-linux-i586-rpm.bin
root@oraapps # ./jdk-6u26-linux-i586-rpm.bin
*****************************************************************************************************************
ISSUE 5:
ln -s /usr/lib/libstdc++-libc6.2.2.so.3 /usr/lib/libstdc++-libc6.1-1.so.2
*********************************************************************************************************************
ISSUE 6:
The 806 installer uses the oratab file.
The file oratab needs to exist at:
/etc/oratab
Rapid Clone will use the oraInst.loc file.
The file oraInst.loc needs to exist at:
/etc/oraInst.loc
Please run the script /tmp/orainstRoot.sh as root
Restart adclone.pl after performing required corrections.
ERROR: Failed to execute /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/bin/adclone.pl
Please check logfile.
root@oraapps # cd /tmp
root@oraapps tmp # sh orainstRoot.sh
******************************************************************************************************************
ISSUE 7:
Beginning database tier Apply - Mon May 7 19:24:48 2012
Log file located at /sdev/p02/oracle/pixdb/9.2.0/appsutil/log/sdev_oraapps/Apply DBTier_05070724.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
RC-50014: Fatal: Execution of AutoConfig was failed
ERROR while running Apply... 50%
ERROR: Failed to execute /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/bin/adclone.pl
Please check logfile.
root@oraapps # vi /sdev/p02/oracle/pixdb/9.2.0/appsutil/log/sdev_oraapps/Apply DBTier_05070724.log
afmkinit.sh exiting with status 127
.end std out.
cp: error while loading shared libraries: /usr/lib/libc.so.6: invalid ELF header
touch: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
.end err out.
****************************************************
Skipping Profile Phase
Skipping Apply Phase
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /sdev/p02/oracle/pixdb/9.2.0/appsutil/install/sdev_oraapps
afmkinit.sh INSTE8_SETUP 127
AutoConfig is exiting with status 1
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: RC-50014: Fatal: Execution of AutoConfig was failed
at oracle.apps.ad.clone.ApplyDatabase.checkAutoConfigErr(ApplyDatabase.java:2792)
at oracle.apps.ad.clone.ApplyDatabase.runAutoConfig(ApplyDatabase.java:2587)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:595)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)
root@oraapps # vi /sdev/p02/oracle/pixdb/9.2.0/appsutil/bin/adgetlnxver.sh
Edit from LD to XD
**********************************************************************************************************************
APPS TIER:
**********
ISSUE 1:
kshell unable to connect.
orasdev@oraapps # export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
**********************************************************************************************************************
ISSUE 2:
/etc/oraInst.loc points to an Inventory that does not exist:
/home/orasdev/oraInventory
mkdir /home/orasdev/oraInventory: Permission denied at /sdev/p01/oracle/pixcomn/clone/bin/adclone.pl line 1331
ERROR: Failed to execute /sdev/p01/oracle/pixcomn/clone/bin/adclone.pl
Please check logfile.
root@oraapps # vi /etc/oraInst.loc
Edit from /home/orasdev/oraInventory to /home/applsdev/oraInventory
*********************************************************************************************************************
ISSUE 3:
Beginning application tier Apply - Mon May 7 20:16:57 2012
Log file located at /sdev/p01/oracle/pixappl/admin/sdev_oraapps/log/ApplyAppsTier_05070816.log
/ 50% completed
AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.
Restored the Context file in :
/sdev/p01/oracle/pixappl/admin/sdev_oraapps.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed
Completed Apply...
Mon May 7 20:21:57 2012
Beginning APPSIAS_sdev registration to central inventory...
ORACLE_HOME NAME : APPSIAS_sdev
ORACLE_HOME PATH : /sdev/p01/oracle/pixora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /home/applsdev/oraInventory/logs/OracleHomeCloner_05070821.log
ORACLE_HOME /sdev/p01/oracle/pixora/iAS was registered successfully.
Skipping the starting of services
INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors.
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem
Once Autoconfig issue is fixed , you can start services
root@oraapps # vi /sdev/p01/oracle/pixappl/admin/sdev_oraapps/log/ApplyAppsTier_05070821.log
error while loading shared library libdb.so.3
error while loading shared library libdl.so.2
error while loading shared library librt.so.1
adautoconfig.sh exiting status with 127
(or)
adautoconfig.sh exiting status with 49
Solution:-
[applsdev@oraapps]$ cd /sdev/p01/oracle/pixappl
[applsdev@oraapps]$ . ./APPSsdev_oraapps.env
[applsdev@oraapps]$ unset LD_LIBRARY_PATH
[applsdev@oraapps]$ echo $LD_ASSUME_KERNEL
2.4.19
[applsdev@oraapps]$ unset LD_ASSUME_KERNEL
Apply Below Patch:-
Download patch no : 6365595
[applsdev@oraapps]$ cd /home/applsdev
[applsdev@oraapps]$ ls
oraInventory 6365595 p6365595_11i_GENERIC.zip
[applsdev@oraapps]$ unzip p6365595_11i_GENERIC.zip
[applsdev@oraapps]$ sh $AD_TOP/bin/adadmin
Make the maintenance mode.
[applsdev@oraapps]$ cd /home/applsdev
[applsdev@oraapps]$ chmod -R 777 6365595
[applsdev@oraapps]$ cd 6365595/
[applsdev@oraapps 6365595]$ ls
ad b6365595.ldt f6365595.ldt marker1.txt README.html README.txt u6365595.drv
[applsdev@oraapps 6365595]$ adpatch
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AutoPatch
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.
Your default directory is '/oracle/PROD1/prod1appl'.
Is this the correct APPL_TOP [Yes] ?
AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adpatch.log] : 6365595.log
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [PROD1] : PROD1 *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [dev144] : dev144 *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'PROD1'
using ORACLE executables in '/oracle/PROD1/prod1ora/8.0.6'.
Is this the correct database [Yes] ?
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: manager
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
Identifier for the current session is 1756
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [11i.AD.I.2]
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
**************** S T A R T O F U P L O A D ****************
Start date: Thu Feb 23 2012 14:32:06
0 "left over" javaupdates.txt files uploaded to DB: Thu Feb 23 2012 14:32:06
0 patches uploaded from the ADPSV format patch history files: Thu Feb 23 2012 14:32:06
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Feb 23 2012 14:32:06
****************** E N D O F U P L O A D ******************
End date: Thu Feb 23 2012 14:32:06
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/home/oracle/6365595] :
Please enter the name of your AutoPatch driver file : u6365595.drv
Getting Oracle Applications Release...
Current installed release is 11.5.10.2
Reading patch driver file...
Parsing and loading patch driver file...
154 lines processed.
Not checking patch integrity as integrity checking flag is turned off.
Successfully read patch driver file.
Determining target release...
Current target release is 11.5.10.2
Determining which bug fixes to apply...
Done determining which bug fixes to apply.
Log and Info File sync point:
Thu Feb 23 2012 14:32:11
Turning off actions that reference unrecognized products.
Log and Info File sync point:
Thu Feb 23 2012 14:32:11
End of unrecognized products checking.
AutoPatch will run in serial mode.
Did not need to apply new applterr.txt.
Applying new applprod.txt (if any)...
Did not need to apply new applprod.txt.
Performing version checking for driver files...
Log and Info File sync point:
Thu Feb 23 2012 14:32:11
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.
Copying driver files into installation area...
No driver files were selected for copying.
Skipping...
ForceCopy driver files into installation area for Specified driver
since no such action is present for this driver file
Screening out files not valid for this installation...
Determining valid on-site files...
Skipping...
Extract object modules from libraries for Specified driver
since no such action is present for this driver file
Performing version checking...
Log and Info File sync point:
Thu Feb 23 2012 14:32:17
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.
Skipping...
Determine directories to create for Specified driver
since no such action is present for this driver file
Skipping...
Determine executables to link for Specified driver
since no such action is present for this driver file
Skipping...
Determine forms to generate for Specified driver
since no such action is present for this driver file
Skipping...
Determine Oracle Reports libraries to generate for Specified driver
since no such action is present for this driver file
Skipping...
Determine reports to generate for Specified driver
since no such action is present for this driver file
Skipping...
Determine if need to generate message files for Specified driver
since no such action is present for this driver file
Looking for active bug fixes with no active actions...
Reading customized files list (if any)...
This patch replaces the following customized files:
No customized files are replaced by this patch.
Copying files into installation area...
**********************************************************
You are running admvcode
Header information is:
$Header: aiopatch.lc 115.44 2004/07/07 09:05:05 cbhati ship $
Start of admvcode session
Date/Time is Thu Feb 23 2012 14:32:17
Filelist file is: /oracle/PROD1/prod1appl/admin/PROD1/out/copymast.txt
Patch Character Set is: us7ascii
On-site Character Set is: US7ASCII
Log and Info File sync point:
Thu Feb 23 2012 14:32:17
Information about files copied to the APPL_TOP would be written to the
informational message file.
No character set conversion is required.
Copying files to APPL_TOP...
0 directories created.
1 files copied without character set conversion.
0 files copied with successful character set conversion.
1 files copied successfully.
0 files had fatal errors.
admvcode is exiting with status 0
End of admvcode session
Date/time is Thu Feb 23 2012 14:32:17
**********************************************************
Done copying files into installation area.
Skipping...
ForceCopy files into installation area for Specified driver
since no such action is present for this driver file
Skipping...
Archive object modules into product libraries for Specified driver
since no such action is present for this driver file
Skipping...
Create Directories for Specified driver
since no such action is present for this driver file
Skipping...
Relink for Specified driver
since no such action is present for this driver file
Performing second half of mirrored copies...
No mirrored copies were executed in this patch.
Updating Oracle Applications Java files if necessary...
No Oracle Applications Java files required updates.
Checking to see if any files possibly included in the product JAR files
were copied by this patch...
No files possibly included in the product JAR files
were copied by this patch.
Skipping ...
Running AutoConfig to instantiate templates which affect
the generation of JAR files since none of these templates
were patched during this run of adpatch.
No product JAR files need to be re-generated.
Checking to see if adjborg.txt or any files included in
adjborg.txt were copied by this patch...
Neither adjborg.txt nor any file included in
adjborg.txt was copied by this patch.
Checking to see if adjborg2.txt or any files included in
adjborg2.txt were copied by this patch...
Neither adjborg2.txt nor any file included in
adjborg2.txt was copied by this patch.
Compiling JSP files...
Not compiling JSPs: no JSPs in patch.
No JSP files were compiled.
Skipping...
Run SQL scripts and EXEC commands for Specified driver
since no such action is present for this driver file
Attempting to maintain MRC...
No action necessary for MRC.
Skipping...
Compile invalid objects for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms library files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports for Specified driver
since no such action is present for this driver file
Skipping...
Generate graphics libraries for Specified driver
since no such action is present for this driver file
Skipping...
Generate graphics for Specified driver
since no such action is present for this driver file
Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file
Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file
Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.
Saving Patch History information to Database...
Trying to obtain a lock...
> Inserted 1 patch history records (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 9 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).
Updating the current-view snapshot...
Done saving Patch History information.
About to do IREP processing...
Attempting to process IREP files ...
The package FND_ADPATCH does not exist, continuing...
Done IREP processing.
Copying applprod.tmp to applprod.txt (if needed)...
Did not need to copy applprod.tmp to applprod.txt.
Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
Did not need to copy admin/PROD1/applterr.txt to admin/applterr.txt.
There is no timing information available for the current session.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.lgi
Errors and warnings are listed in the log file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.log
and in other log files in the same directory.
[applsdev@oraapps]$ cd $COMMON_TOP/admin/scripts/sdev_oraapps
[applsdev@oraapps]$ ./adautocfg.sh
Enter the APPS user password:
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using APPL_TOP location : /oracle/PROD1/prod1appl
Classpath : /oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/oracle/PROD1/prod1comn/java/appsborg2.zip:/oracle/PROD1/prod1comn/java
Using Context file : /oracle/PROD1/prod1appl/admin/PROD1_dev144.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring ABM_TOP.......COMPLETED
Configuring ECX_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring GL_TOP........COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring XNC_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring PA_TOP........COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring IMT_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
The log file for this session is located at: /oracle/PROD1/prod1appl/admin/PROD1_dev144/log/02231433/adconfig.log
REF : http://muthuappsdba.blogspot.in/2012/02/touch-error-while-loading-shared.html
DISABLE MAINTENANCE MODE USING ADADMIN
************************************************************************************************************************
ISSUE 4:
[applsdev@oraapps sdev_oraapps]$./adstrtal.sh apps/apps
You are running adstrtal.sh version 115.16
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adapcctl.sh start
script returned:
****************************************************
adapcctl.sh version 115.47
Starting Apache Web Server Listener (dedicated HTTP) ...
Starting Apache Web Server Listener (dedicated PLSQL) ...
adapcctl.sh: exiting with status 3
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version
Checking for FNDFS executable.
Starting listener process APPS_sdev.
adalnctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 115.24
Starting concurrent manager for sdev ...
Starting sdev_0508@sdev Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfrmctl.sh start
script returned:
****************************************************
You are running adfrmctl.sh version 115.37
Starting forms server for sdev on port 9051.
adfrmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adrepctl.sh start
script returned:
****************************************************
You are running adrepctl.sh version 115.31
starting Reports Server for sdev on port 7051.
adrepctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfmcctl.sh start
script returned:
****************************************************
You are running adfmcctl.sh version 115.19
Starting forms load balancing client for sdev.
adfmcctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfmsctl.sh start
script returned:
****************************************************
You are running adfmsctl.sh version 115.15
starting forms metrics server for sdev.
adfmsctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 115.16
Validating Fulfillment patch level via /sdev/p01/oracle/pixcomn/java
Fulfillment patch level validated.
Starting Fulfillment Server for sdev on port 9351 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Check logfile /sdev/p01/oracle/pixcomn/admin/log/sdev_oraapps/05081532.log for details
Exiting with status 1
solution:
Download and apply the OS library patch 6078836
root@oraapps # ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
**********************************************************
END
**********************************************************
For Oracle Linux 5 and Red Hat Enterprise Linux 5 only :
# ln -s /usr/bin/ld215 /usr/bin/ld
Download and apply the OS library patch 6078836 from My Oracle Support and create the following symbolic link:
# ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
But i resolved the issue by copying the libdb.so.3 file from working server instance to the required server.
FINALLY I CLONED AN 11I INSTANCE SUCCESSFULLY.
********************************************************************************************************************
ANOTHER ONE ISSUE 1:
applfdev@oraapps # perl adcfgclone.pl appsTier /fdev/p01/oracle/pixappl/admin/fdev_oraapps.xml
Cannot proceed with ApplyApplTop - the paths/ports in the context file are not valid.
RC-20403: The following port numbers are busy - please make sure the ports are available and try again.
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
s_webssl_port : 443
--------------------------------------
StackTrace:
java.lang.Exception: Cannot proceed with ApplyAppsTechStack - the paths/ports in the context file are not valid.
at oracle.apps.ad.clone.ApplyAppsTechStack.validateContext(ApplyAppsTechStack.java:428)
NOTHING TO WORRY
SOLUTION
applfdev@oraapps # perl adcfgclone.pl appsTier
REF : https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocID=390901.1&from=BOOKMARK&bmDocDsrc=KB&viewingMode=1143))
ID : 390901.1
*********************************************************************************************************************
ISSUE 2 :
Autoconfig exiting status with 1
When checking logfile
"Thread: Error:ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated"
SOLUTION :
applfdev@oraapps # sqlplus apps/apps
applfdev@oraapps # select APPL_TOP_ID, NAME from ad_appl_tops;
APPL_TOP_ID NAME
----------- --------------------------------------------------
2069 *PRESEEDED*
2072 oraapps
2075 ebs
2078 ebs
1)What to do next, how to take backup of ad_timestamps, ad_appl_tops?
2)How to remove the rows which correspond to current node (on which the script is failing)
esp search for these rows in AD_TIMESTAMPS(ID 727990.1)?
1. create table ad_appl_tops_bak as select * from ad_appl_tops;
create table ad_timestamps_bak as select * from ad_timestamps;
2. delete ad_appl_tops where APPLICATIONS_SYSTEM_NAME='rdev';
3. commit;
Now autoconfig success and instance up.
ID 727990.1
REF :
https://support.oracle.com/CSP/ui/flash.html#tab=Dashboard(page=Dashboard&id=h23bc530()),(page=KBNavigator&id=h23bfsdt(searchControl=1146&&&searchMode=1145&viewingMode=1143))
https://forums.oracle.com/forums/thread.jspa?threadID=1049923
*********************************************************************************************************************
11I APPLICATION ISSUE :
ISSUE :
While giving concurrent manager request through forms it show the following error message
" concurrent phase 'completed,error' and also it denotes previous server url in forms.
When we click 'view log' in application it shows the following error message.
+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDSCARU module: Active Responsibilities
+---------------------------------------------------------------------------+
Current system time is 14-MAY-2012 17:07:22
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
APPLLCSP Environment Variable set to :
XML_REPORTS_XENVIRONMENT is :
/mdev/p01/oracle/pixora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to: /mdev/p01/oracle/pixora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
Spawned Process 21853
ar60run: relocation error: /mdev/p01/oracle/pixora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Program exited with status 127
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 2908360.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
SOLUTION :
RPM PACKAGE MISSING
root@server2 # rpm -ivh compat-libcwait-2.1-1.i386.rpm
ISSUE SOLVED............................
REF : https://forums.oracle.com/forums/thread.jspa?threadID=2192653
***************************************************************************************************************************
ANOTHER ISSUE:
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:658)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)
controlfile created.
SOLUTION :
SQL> connect / as sysdba
SQL> shutdown immediate
SQL> startup mount
SQL> recover database using backup controlfile until cancel;
-- type CANCEL
SQL> alter database open resetlogs;
startup listener using script.
ISSUE SOLVED.....................................................................
********************************************************************************************************************************
ANOTHER ISSUE :
Autoconfig exiting status with 99
While checking logfile it shows as follows,
*******FATAL ERROR*******
PROGRAM : (txkGenExtSecConf.pl)
TIME : Wed Oct 14 22:41:34 2009
FUNCTION: TXK::IO::chmod [ Level 3 ]
MESSAGES:
error = Unable to chmod file - mode 511
errorno = Operation not permitted
SOLUTION
This error came in application tier. So i gave 777 permission to application files and rerun autoconfig
Now issue SOLVED......................................................................
*******************************************************************************************************************
ANOTHER ISSUE :
Autoconfig exiting status with 1
failed adadmprf.sh
while checking logfile it shows as follows,
Unique constraint error (00001) is OK if key already exists
Application server ID already exists for this host
While running adadmprf.sh it shows
ERROR:
ORA-12154: TNS:could not resolve service name
SOLUTION :
1) Login to sqlplus as user APPS
2) EXEC FND_CONC_CLONE.SETUP_CLEAN;
3) Repopulate FND_NODES by running Autoconfig on all middle tier nodes
4) SQL> SELECT table_name, column_name FROM all_tab_columns WHERE column_name LIKE 'APPLICATION%SYSTEM%NAME%';
5) SQL>create table FND_PRODUCT_GROUPS_BAK as select * from FND_PRODUCT_GROUPS;
6) SQL> update FND_PRODUCT_GROUPS set APPLICATIONS_SYSTEM_NAME = ‘<NEW DATABASE NAME>’ ;
7) COMMIT;
8) RUN AUTOCONFIG IN MIDDLE TIER
NOW ISSUE SOLVED...................
Ref : http://onlineappsdba.com/index.php/2008/05/13/cloning-oam-system-name-pointing-to-source-instance/
*********************************************************************************************************************
ISSUE:
While applying patch it shows following error message.
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
ORA-01403: no data found
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2472
ORA-06512: at line 2
AutoPatch error:
Error while executing statement (curr-vw inst)
Error calling adusnapInstCurrVwSnapshot(ebs,11.5.10.2).
Error calling adphistLoadPtchHistFromFStoDB2
Updating the current-view snapshot...
ORA-01403: no data found
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2095
ORA-06512: at line 2
AutoPatch error:
Error while executing statement (curr-vw updt)
SOLUTION :
SQL> select APPL_TOP_ID, NAME,APPLICATIONS_SYSTEM_NAME from ad_appl_tops;
APPL_TOP_ID NAME
----------- --------------------------------------------------
APPLICATIONS_SYSTEM_NAME
------------------------------
2069 *PRESEEDED*
*PRESEEDED*
2072 ebs
udev
SQL> select APPL_TOP_ID, NAME,APPLICATIONS_SYSTEM_NAME from ad_appl_tops_bak;
APPL_TOP_ID NAME
----------- --------------------------------------------------
APPLICATIONS_SYSTEM_NAME
------------------------------
2071 GLOBAL
hdev
2069 *PRESEEDED*
*PRESEEDED*
2070 ebs
hdev
SQL> update ad_appl_tops set APPL_TOP_ID='2070' where APPL_TOP_ID='2072';
-----> here 2070 is source id and 2072 is target id.
1 row updated.
SQL> commit;
Run Autoconfig and check the patching it solved........
Ref : http://oracleappstechnology.blogspot.in/2009/02/ora-01403-ora-06512-at.html
*******************************************************************************************************************************************************
Issue :
--------
While Running adcfgclone.pl on dbTier it shows following error message,
ora-27101 shared memory realm does not exist
linux error 2 no such file or directory
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Solution :
----------
Run autoconfig on appstier
Run $AD_TOP/bin/admkappsutil.pl and copy $INST_TOP/admin/out/appsutil.zip & unzip it to <RDBMS ORACLE_HOME>
Run $ORACLE_HOME/appsutil/bin/adbldxml.pl appsuser=apps appspasswd=apps
Run autoconfig on dbTier -> $ORACLE_HOME/appsutil/bin/adconfig.sh
Run adpreclone on dbTier
Run adpreclone on appsTier
Stop DB and its listener processes
Shutdown the Database with (Normal, Immediate ) Mode
Bring down the application services
Crosscheck with alert log whether DB has been shutdown completely
Run the following OS command to confirm/crosscheck that no DB process running , if any DB processes running , terminate them manually
ps -ef | grep pmon
Copy all the datafiles from Source to Target
Copy application file system to target.
Run the clone configuration command:
cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
perl adcfgclone.pl dbTier
Run the clone configuration command:
cd <COMMON_TOP>/clone/bin
perl adcfgclone.pl appsTier
**********************************************************************************************************************************************************************************************************
No comments:
Post a Comment