Saturday 20 July 2013

RC-50004: Fatal: Error occurred in ApplyAppsTier

Cause :

When i ran the adcfgclone.pl in R12 application tier i got the RC-50004: Fatal Error.

RC-50004: Fatal: Error occurred in ApplyAppsTier
 
StackTrace -
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NoSuchMethodError: oracle.apps.ad.autoconfig.InstantiateFile.writeReport(Ljava/util/Vector;Loracle/apps/ad/util/LogFile;I)V
at oracle.apps.ad.clone.ApplyApplTop.checkAutoConfigErr(ApplyApplTop.java:590)
at oracle.apps.ad.clone.ApplyApplTop.runAutoConfig(ApplyApplTop.java:558)
at oracle.apps.ad.clone.ApplyApplTop.doConf(ApplyApplTop.java:339)
at oracle.apps.ad.clone.ApplyApplTop.doApply(ApplyApplTop.java:382)
at oracle.apps.ad.clone.ApplyApplTop.<init>(ApplyApplTop.java:267)
at oracle.apps.ad.clone.ApplyAppsTier.<init>(ApplyAppsTier.java:105)
... 6 more
 
ERROR while running Apply...
Fri Apr 26 09:10:48 2013
ERROR: Failed to execute /oracle2/TEST/apps/apps_st/comn/clone/bin/adclone.pl
Please check logfile.


Solution :

Check the 10.1.2 and 10.1.3 home entry in the oraInst.loc file and change the  Production orainventry location to test orainventry location and try again to run the adcfgclone.pl script.

Step 1:

bash-cd /oracle2/TEST/apps/tech_st/10.1.3
bash-3.00$ cat oraInst.loc
inventory_loc=/oracle2/TEST/apps/tech_st/10.1.3/admin/oraInventory


change the oraInventory location in 10.1.3 home oraInst.loc file using the vi editor.

Step 2 :


bash- cd /oracle2/TEST/apps/tech_st/10.1.2
bash-3.00$ pwd
/oracle2/TEST/apps/tech_st/10.1.2
bash-3.00$ cat oraInst.loc
inventory_loc=/oracle2/TEST/apps/tech_st/10.1.2/admin/oraInventory


change the oraInventory location in 10.1.2 home oraInst.loc file using the vi editor.

Regards,
Vijay.

Process of Adpreclone.pl script in DB and Apps

adpreclone.pl : This is the preparation phase, will collects information about the source system, creates a cloning stage area, and generates templates and drivers. All of these are to reconfigure the instance on a Target machine.
 

Preclone will do the following:

Convert Symbolic links

All symbolic links pointing to a static path will be converted into relative paths

Create templates

Any files under the $ORACLE_HOME that contain system specific information, will be replicated and converted into a template. These templates are placed into the $ORACLE_HOME/appsutil/template directory.

Create driver(s)

A driver file, relating to these new templates is created called instconf.drv. This contains a list of all the templates and their locations, and the destination configuration files that these templates will create.
This driver file is called instconf.drv and is placed into directory
$ORACLE_HOME/appsutil/driver

Create Stage area

A clone stage is created containing the required java code and scripts to reconfigure the instace on the Target machine

Rapid Clone stage area:

dbTier : $ORACLE_HOME/appsutil/clone
appsTier(s) - $COMMON_TOP/clone

The stage area(s) consist of the following directories:-

 jre used to run the java code on the Target machine.
 bin contains the RapidClone scripts that can be run on the Target machine

·                        adclone.pl is the main cloning script
·                        adcfgclone.pl  is used to configure the Target system, this calls adclone.pl
·                        adclonectx.pl is used to clone a Source XML file manually
·                        adaddnode.pl is used to add a new node to the Patch History tables
·                        adchkutl.sh checks for existence of require O/S utils, cc, make, ar and ld
  
 jlib contains all the Rapid Clone java code, jdbc libraries etc
 context contains templates used for a Target XML file
 data (Database Tier only) contains the driver file, and templates used to generate the control file SQL script
 adcrdb.zip contains the template and list of data files on the Source
 addbhomsrc.xml contains information on the datafile mount points of the Source
 appl 
(Applications Tier only) this is used when merging appltops, i.e Multi-node to Single node cloning
Executing adpreclone.pl
will create a log file:-
 
Rapid Clone:

dbTier : $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/StageDBTier_xxxxxx.log
appsTier : $APPL_TOP/admin/$CONTEXT_NAME/log/StageAppsTier_xxxxxx.log
Once this adpreclone.pl
step has been completed successfully, all the java .class files under the following directories should be identical to those under $JAVA_TOP/oracle :

RDBMS $ORACLE_HOME/appsutil/java/oracle

RDBMS $ORACLE_HOME/appsutil/clone/jlib/java/oracle
$COMMON_TOP/clone/jlib/java/oracle
 

Adpreclone Process in Detail :

When running adpreclone.pl dbTier :

This will run in two steps Techstack and database.
 
Techstack:

It will create following directories in the ORACLE_HOME/appsutil/clone
Jlib, db, data where "Jlib" relates to libraries "db" will contain the techstack information, "data" will contain the information related to datafiles and required for cloning.
Creates driver files at ORACLE_HOME/appsutil/driver/instconf.drv

Converts inventory from binary to xml, the xml file is located at $ORACLE_HOME/appsutil/clone/context/db/Sid_context.xml

 
Prepare database for cloning:

This includes creating datbase control file script and datafile location information file at
$ORACLE_HOME/appsutil/template
adcrdbclone.sql, dbfinfo.lst

Generates database creation driver file at ORACLE_HOME/appsutil/clone/data/driver
data.drv

Copy JDBC Libraries at ORACLE_HOME/appsutil/clone/jlib/classes12.jar and appsoui

 
When Running adpreclone appsTier :

This will create stage directory at $COMMON_TOP/clone. This also run in two steps.

 
Techstack:
 
Creates template files for
Oracle_iAS_Home/appsutil/template
Oracle_806_Home/appsutil/template


Creates Techstack driver files for
 
IAS_ORACLE_HOME/appsutil/driver/instconf.drv
806_ORACLE_HOME/appsutil/driver/instconf.drv

 
APPL_TOP preparation:

-   It will create application top driver   file$COMMON_TOP/clone/appl/driver/appl.drv
-   Copy JDBC libraries$COMMON_TOP/clone/jlib/classes111.zip

 

Now Shutdown all the services of Application and database for Copy the file System to target location

Configuring the target system
Once it is done .


Regards,
Vijay. 

Monday 15 July 2013

File Locations in Oracle Applications 11i and R12


 FileOracle Apps 11iOracle Apps R12
Environment Source fileAPPSORA.envAPPS<SID>_<hostname>.env
Context File (Middle tier)$APPL_TOP/admin/$TWO_TASK.xml$INST_TOP/appl/admin/$TWO_TASK_<hostname>.xml
tnsnames.ora (OH)$ORACLE_HOME/network/admin/<CONTEXT>$INST_TOP/ora/10.1.2/network/admin
listener.ora$ORACLE_HOME/network/admin/<CONTEXT>$INST_TOP/ora/10.1.2/network/admin
appsweb.cfg$OA_HTML/bin$INST_TOP/ora/10.1.2/forms/server
tnsnames.ora (Apache)$IAS_ORACLE_HOME/network/admin/<CONTEXT>$INST_TOP/ora/10.1.3/network/admin
jsev.properties$IAS_ORACLE_HOME/Apache/Jserv/etc$INST_TOP/ora/10.1.3/opmn/conf/opmn.xml
httpd.conf$IAS_ORACLE_HOME/Apache/Apache/conf$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
apps.conf$IAS_ORACLE_HOME/Apache/Apache/conf$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
formservlet.ini$IAS_ORACLE_HOME/Apache/Jserv/etc$ORACLE_HOME/forms/server/default.env
topfile.txt$APPL_TOP/admin$APPL_CONFIG_HOME/admin
adovars.env$APPL_TOP/admin$APPL_CONFIG_HOME/admin
adjborg2.txt$APPL_TOP/admin$APPL_CONFIG_HOME/admin
SSL Certificates$COMMON_TOP/admin/certs$INST_TOP/certs
AD scripts logs$COMMON_TOP/admin/log/<SID_hostname>$LOG_HOME/appl/admin/log
Concurrent Request logs$APPLCSF$APPLCSF
Apache logs$IAS_ORACLE_HOME/Apache/Apache/logs$LOG_HOME/ora/10.1.3/Apache
Jserv logs$IAS_ORACLE_HOME/Apache/Jserv/logs$LOG_HOME/ora/10.1.3/j2ee
javacache.log$COMMON_TOP/rgf/<SID_hostname>$LOG_HOME/appl/rgf

Environmental variables
====================
VariableOracle Apps 11iOracle Apps R12
APPL_TOP$HOME/<SID>appl$HOME/apps/apps_st/appl
COMMON_TOP$HOME/<SID>comn$HOME/apps/apps_st/comn
ORACLE_HOME  (applmgr)$HOME/<SID>ora/8.0.6$HOME/apps/tech_st/10.1.2
IAS_ORACLE_HOME$HOME/<SID>ora/iAS$HOME/apps/tech_st/10.1.3
ORACLE_HOME (oracle)$HOME/<SID>db/10.2.0$HOME/db/tech_st/10.2.0
ORADATA$HOME/<SID>data$HOME/db/apps_st/data
JAVA_TOP, OA_JAVA$COMMON_TOP/java$COMMON_TOP/java/classes
OA_HTML$COMMON_TOP/html$COMMON_TOP/webapps/oacore/html
FND_SECURE$FND_TOP/secure/<SID>$INST_TOP/appl/fnd/12.0.0/secure
ADMIN_SCRIPTS_HOME$COMMON_TOP/admin/scripts/<SID>$INST_TOP/admin/scripts
LOG_HOME-$INST_TOP/logs
FORMS_WEB_CONFIG_FILE-$INST_TOP/ora/10.1.2/forms/server/appsweb.cfg
AF_JLIB-$COMMON_TOP/java/lib
JAVA_BASE-$COMMON_TOP/java
INST_TOP-$HOME/inst/apps/<CONTEXT>
ORA_CONFIG_HOME-$INST_TOP/ora
APPLCSF$COMMON_TOP/admin$LOG_HOME/appl/conc
Regards,
Vijay.

After the Cloning Reports are not generating in PDF and XML format in cloned instance.

Cause 

User could not generate the reports in pdf and xml format in new cloned instance.

Solution :

1. Login in to the System Administrator Responsibility.

 
 2.  Add the XML Publisher Administrator Responsibility. 



3. Go to the Administration Responsibility   —> General Properties option in the cloned instance.



4. Check the temporary directory location in the General properties and change the Production instance template location to clone instance template location.


5. Restart  the Output Post Processor (OPP).

6. Now User can generate the forms in PDF and XML format.

Regards,
Vijay.