rapidwiz log file locations in R12.2 from MOS

Rapidwiz log file location in R12.2 :

Before the installation starts:

$TMP/<MMDDHHMM>/<MMDDHHMM>.log
$TMP/<MMDDHHMM>/<hostname>_<SID>.xml
$TMP/<MMDDHHMM>/<hostname>_<SID>_apps.xml

The Rapidwiz Configuration File is saved in the following four locations:

$TMP/<MMDDHHMM>/conf_<SID>.txt
Primary $INST_TOP/conf_<SID>.txt
Secondary $INST_TOP/conf_<SID>.txt
<RDBMS ORACLE_HOME>/appsutil/conf_<SID>.txt

Preinstall System Check Logs:

$TMP/<MMDDHHMM>/<MMDDHHMM>.log 
$TMP/dbPreInstCheck.xxxxx.log
$TMP/wtprechk.xxxx/wtprechk.xxxx.log 

<Global Inventory>/logs/installActions<timestamp>.log

Database Tier:

Main installation log:

RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>.log

Oracle Home installation logs:

RDBMS $ORACLE_HOME/temp/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.install0.log
RDBMS $ORACLE_HOME/temp/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.default0.log
<Global Inventory>/logs/<timestamp>.log
<Global Inventory>/logs/cloneActions<timestamp>.log
<Global Inventory>/logs/install<timestamp>.log
<Global Inventory>/logs/installActions<timestamp>.log
<Global Inventory>/logs/installProfile<timestamp>.log
<Global Inventory>/logs/installSummary<timestamp>.log
<Global Inventory>/logs/OPatch<timestamp>.log
<Global Inventory>/logs/oraInstall<timestamp>.log
<Global Inventory>/logs/silentInstall<timestamp>.log

RMAN restore scripts (Install mode only):

<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac1.rman
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac2.sql
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single2.sql
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac21.sql
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single21.sql
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac3.rman

RMAN restore logs (Install mode only):

<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac1.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac2.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac3.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single1.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single2.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single3.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/LogOff.sql
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/fndClean.sql

Database characterset conversion (Install mode only):

<ORACLE_HOME>/appsutil/log/<Context Name>/addbccnv.txt

AutoConfig context file:

<RDBMS ORACLE_HOME>/appsutil/<Context Name>.xml

AutoConfig logs:

<RDBMS ORACLE_HOME>/appsutil/log/<Context Name>/<MMDDHHMM>/adconfig.log
<RDBMS ORACLE_HOME>/appsutil/log/<Context Name>/<MMDDHHMM>/NetServiceHandler.log
<RDBMS ORACLE_HOME>/temp/$CONTEXT_NAME/RACAutoConfig_nnnnn.log

Listener log:

<RDBMS ORACLE_HOME>/appsutil/log/$CONTEXT_NAME/addlnctl.txt

Applications Tier(s):

Both primary (run) and secondary (patch) edition file systems will each contain these logs:

Main installation log:

$INST_TOP/logs/<MMDDHHMM>.log

FMW and OHS TechStack Installation/Patching logs:

$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ebsfmwlayout.log
$APPL_TOP/admin/$CONTEXT_NAME/log/NetServiceHandler.log
$APPL_TOP/admin/$CONTEXT_NAME/log/adcvmlog.xml
$APPL_TOP/admin/$CONTEXT_NAME/log/executeac.log
$APPL_TOP/admin/$CONTEXT_NAME/log/deploytech.log

$APPL_TOP/admin/$CONTEXT_NAME/logs/wls1036.log
$APPL_TOP/admin/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.default0.log
$APPL_TOP/admin/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.install0.log

<Global Inventory>/logs/<timestamp>.log
<Global Inventory>/logs/cloneActions<timestamp>.log
<Global Inventory>/logs/install<timestamp>.log
<Global Inventory>/logs/installActions<timestamp>.log
<Global Inventory>/logs/installProfile<timestamp>.log
<Global Inventory>/logs/installSummary<timestamp>.log
<Global Inventory>/logs/OPatch<timestamp>.log
<Global Inventory>/logs/oraInstall<timestamp>.log
<Global Inventory>/logs/silentInstall<timestamp>.log

Forms Oracle Home installation logs:

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/admin/log/ohclone.log
$INST_TOP/admin/log/ApplyAppsTechStack_<MMDDHHMM>.log

Service Control logs:

$INST_TOP/logs/appl/admin/log/adadminsrvctl.txt
$INST_TOP/logs/appl/admin/log/adalnctl.txt
$INST_TOP/logs/appl/admin/log/adapcctl.txt
$INST_TOP/logs/appl/admin/log/adcmctl.txt
$INST_TOP/logs/appl/admin/log/adforms-c4wsctl.txt
$INST_TOP/logs/appl/admin/log/adformsctl.txt
$INST_TOP/logs/appl/admin/log/adnodemgrctl.txt
$INST_TOP/logs/appl/admin/log/adoacorectl.txt
$INST_TOP/logs/appl/admin/log/adoafmctl.txt
$INST_TOP/logs/appl/admin/log/adopmnctl.txt
$INST_TOP/logs/appl/admin/log/adstpall.log
$INST_TOP/logs/appl/admin/log/adstrtal.log
$INST_TOP/logs/appl/admin/log/jtffmctl.txt 

References :

Troubleshooting Rapid Install for E-Business Suite Release 12.2 (Doc ID 1378579.1)

Rapidwiz errros while solaris to linux migration at FMW installation

Guys,

This error occurred while migration ebs 12.2 from solaris to linux. This is not complete 12.2 installation instead it was only FMW installation for migration activity.


Fatal Error: TXK Install Service

oracle.apps.fnd.txk.config.ProcessStateException: FileSys OS COMMAND Failed : Exit=1 See log for details. CMD= mv /appstier1/CLONE/fs2/inst/apps/CLONE_prodapp/temp/patches/17239083/jdk32 /appstier1/CLONE/fs2/EBSapps/comn/util/ ## Node=NodeId=484 Type=24 TypeName=filesys_patch_action Name= RefId=424 State=init ConfigDoc=APPS_JAVA_HOME ParentDoc=null Topology=R12 Action=os_cmd

    at oracle.apps.fnd.txk.config.FileSysPatchActionNode.doFileSysOSCmd(FileSysPatchActionNode.java:169)

    at oracle.apps.fnd.txk.config.FileSysPatchActionNode.processState(FileSysPatchActionNode.java:101)

    at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)

    at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)

    at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)

    at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)

    at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)

    at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)

    at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)

    at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)



Cannot install WebLogic Server

    RW-50010: Error: - script has returned an error:   1

solution :

As part of migration step i downloaded jdk 32 and 64 bit directories and kept under $COMMON_TOP/util. When rapidwiz tried to copy jdk from stage its was throwing the error. This log can be seen at the below

$APPL_TOP/admin/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.default0.log 
$APPL_TOP/admin/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.install0.log 

Fix :

- remove jdk directories if exists under $COOMON_TOP/util 

I was able to install successfully after doing the above. 

I am consolidating other fixes too in this post whichever i went through MOS.

1. Make sure you dont have higher version of binutils except 2.25 or 2.23.

   binutils-2.25.1-32.base.el7_4.2.x86_64 or binutils-2.23.52.0.1-16.el7.x86_64

Use the below to downgrade it.

 # yum downgrade binutils

 # rpm -Uvh --oldpackage binutils-2.25.1-32.base.el7_4.2.x86_64.rpm

2. Make sure there is adequate space in /tmp

Thanks!
Sikky

Step by Step : "How to download stage for ebs R12.2"

Hello DBA's,

This post is all about how to download and build stage for oracle E-business suite R12. I feel this would be really helpful for beginners. 

Go to https://edelivery.oracle.com and sign-in with your support credentials.

Left drop down --> Select download package

You can search Oracle E-business Suite in the search bar.

You can review the below Doc id to know what are all the files should be downloaded.

12.2 E-Business Suite Applications Installation Rapid Install Steps To Create the Stage Directories In Preparation For A 12.2 Installation (Doc ID 1596433.1)

All the mentioned zip files should be downloaded from section A-E.

Files to be downloaded :

V100052-01_1of3.zip

V100052-01_2of3.zip

V100052-01_3of3.zip

V100053-01_1of2.zip

V100053-01_2of2.zip

V100054-01.zip

V100055-01.zip

V100056-01.zip

V100057-01.zip

V100058-01.zip

V100059-01_1of2.zip

V100059-01_2of2.zip

V100060-01_1of3.zip

V100060-01_2of3.zip

V100060-01_3of3.zip

V46095-01_1of2.zip

V46095-01_2of2.zip

V100102-01.zip

V35802-01.zip

V35803-01_1of3.zip

V35803-01_2of3.zip

V35803-01_3of3.zip

V35804-01_1of2.zip

V35804-01_2of2.zip

V100061-01.zip

V29856-01.zip

V75792-01.zip

You dont need to download the rest.

Once downloaded you dont need to unzip all the files.  Please read the step below.

We should unzip only the below zip files :

V100052-01_1of3.zip

V100052-01_2of3.zip

V100052-01_3of3.zip

Enter option 1 to create new stage area

 Select your OS accordingly.

Provide the stage directory where all the zips are present. 

Thats it. The rest will be taken care by buildstage.sh script once this is done our stage is ready for installation.


References :

12.2 E-Business Suite Applications Installation Rapid Install Steps To Create the Stage Directories In Preparation For A 12.2 Installation (Doc ID 1596433.1)

https://docs.oracle.com/cd/E26401_01/doc.122/e22950.pdf

Please leave a comment if you like this post. 

How to apply weblogic patch in R12.2

Copy the patches and move to the below location :

$FMW_Home/utils/bsu/cache_dir

Unzip patches in above location. When you unzip the patch you will get the jar file named with 4 character. Ex : B47X. Use these jar files while applying patch. 

Command to apply weblogic patch in R12.2 :

bash-3.2$ bsu.sh -install -patch_download_dir=$FMW_Home/utils/bsu/cache_dir -patchlist=B47X -prod_dir=$FMW_HOME/wlserver_10.3

Checking for conflicts................

Conflict(s) detected - resolve conflict condition and execute patch installation again

Conflict condition details follow:

Patch B47X is mutually exclusive and cannot coexist with patch(es): YIJF,LL4G,D33T,VFS8,Y5AP

Command to rollback the conflicts :

bsu.sh -remove -patchlist=YIJF -prod_dir=$FMW_HOME/wlserver_10.3

bsu.sh -remove -patchlist=LL4G -prod_dir=$FMW_HOME/wlserver_10.3

bsu.sh -remove -patchlist=D33T -prod_dir=$FMW_HOME/wlserver_10.3

bsu.sh -remove -patchlist=VFS8 -prod_dir=$FMW_HOME/wlserver_10.3

bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3

Issue :

1.

bash-3.2$ bsu.sh -install -patch_download_dir=$FMW_Home/utils/bsu/cache_dir -patchlist=B47X -prod_dir=$FMW_HOME/wlserver_10.3

Exception in thread "main" Exception in thread "Thread-0" java.lang.OutOfMemoryError: Java heap space

        at org.apache.xmlbeans.impl.store.Cur.createElementXobj(Cur.java:257)

2.

bash-3.2$ bsu.sh -install -patch_download_dir=$FMW_Home/utils/bsu/cache_dir -patchlist=B47X -prod_dir=$FMW_HOME/wlserver_10.3

Checking for conflicts...........Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

        at java.util.Arrays.copyOf(Arrays.java:2367)

Fix :

Update MEM_ARGS parameter in bsu.sh file after taking backup under $FMW_HOME/utils/bsu/

#!/bin/sh

JAVA_HOME="/a01/appsclone/CLONE/fs2/EBSapps/comn/util/jdk"

MEM_ARGS="-Xms2048m -Xmx2048m -XX:+UseParallelGC"

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

adop fails with "invalid username/password; logon denied" for custom schema

Below error encountered in the txk delta level 10 patching . Please go through this post to fix this issue.

Scenario :

Applying patch 25828573.
    Log: /a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/ahqtest/25828573/log/u25828573.log

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

The patch has FAILED,
Please check the adpatch logs for more details.

You should check the file
/a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/ahqtest/25828573/log/u25828573.log

for errors.

    [UNEXPECTED]Error occurred executing "adpatch  abandon=yes restart=no workers=16   options=hotpatch     console=no interactive=no  defaultsfile=/a01/appsclone/CLONE/fs2/EBSapps/appl/admin/CLONE/adalldefaults.txt patchtop=/a01/appsclone/CLONE/fs_ne/EBSapps/patch/25828573 driver=u25828573.drv logfile=u25828573.log"
    [UNEXPECTED]Refer to the log files for more information.
    [UNEXPECTED]Apply phase has failed.


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.



We can get the detailed information from the adop log

/a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/*****/25828573/log/u25828573.log


Error :


sqlplus -s XX***/***** @/a01/appsclone/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/a01/appsclone/CLONE/fs2/EBSapps/appl/
ad/12.0.0/patch/115/sql/adaddls.pls ***** XX*** *****'
ERROR:
ORA-01017: invalid username/password; logon denied



An error occurred while running a SQL*Plus script.

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

The patch has FAILED,
Please check the adpatch logs for more details.

You should check the file
/a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/****/25828573/log/u25828573.log

for errors.

adop could not connect to custom schema to execute the script, thus patch is resulting into error. Perform the below to fix this issue. 

Solution :

Script location : $AD_TOP/patch/115/sql

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adaddls.pls
Enter value for 1: *********** (System Password)
Connected.
Enter value for 2: XXCUST (Custom username)
old   1: grant create procedure to &&2
new   1: grant create procedure to XXCUST

Grant succeeded.

old   1: ALTER SESSION SET CURRENT_SCHEMA = &2
new   1: ALTER SESSION SET CURRENT_SCHEMA = XXCUST

Session altered.

old   2:   execute immediate 'drop synonym &2..APPS_DDL';
new   2:   execute immediate 'drop synonym XXAHQ.APPS_DDL';

PL/SQL procedure successfully completed.


Package created.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bash-3.2$ sqlplus system

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Sep 26 15:32:07 2018

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adaddlb.pls
Enter value for 1: ********* (System password)
Connected.
Enter value for 2: XXCUST
old   8:        where grantee='&2'
new   8:        where grantee='XXCUST'
Enter value for 2: XXCUST
old  14:     execute immediate 'grant execute on sys.dbms_sql to &&2';
new  14:     execute immediate 'grant execute on sys.dbms_sql to XXCUST';

PL/SQL procedure successfully completed.

old   1: ALTER SESSION SET CURRENT_SCHEMA = &2
new   1: ALTER SESSION SET CURRENT_SCHEMA = XXCUST

Session altered.


Package body created.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Manually connect to the schema and confirm whether its working.

Retry the adop once again. you can use the below :

adop phase=apply patches=patch_number abandon=no restart=yes

If its failing you can perform the below.

As you can see the error above it was failing at the step below. So i ran the step below manually.


sqlplus -s XXCUST/XXCUST @/a01/appsclone/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/a01/appsclone/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls opensys_33 XXCUST XXCUST'


I was able to run adop without any issue with autoskip flag option.

adop phase=apply patches=25828573 abandon=no restart=yes flags=autoskip 

we can use the below to skip the failed adop session or if you manually performed the failed step. 

abandon=no restart=yes flags=autoskip 

This command will restart the patch once again from starting onwards and will skip all the failures if any comes. But make sure to review the log file at the end of the patch application that you have skipped the failures that you want to.

Thanks!
Sikky

Adop erros : APPS.AD_ZD_ADOP became invalid

Error :

This post is about one of the error i encountered while applying txk patch. This error is due to AD_ZD_ADOP package became invalid due to one of the opatch which applied this morning.

Due to invalid package i was unable to perform any operation in adop.

bash-3.2$ adop phase=apply patches=25828573 hotpatch=yes abandon=no restart=yes flags=autoskip

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /a01/appsclone/CLONE/fs2/inst/apps/CLONE_ahqtest/appl/admin/CLONE_ahqtest.xml
    Patch edition context: /a01/appsclone/CLONE/fs1/inst/apps/CLONE_ahqtest/appl/admin/CLONE_ahqtest.xml
    Patch file system free space: 329.79 GB

Validating system setup.

 Statement Handler Error Code: 4063
 Statement Handler Error Message: ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
 Reference of statement-handler is valid, not attempting database reconnect.
 Failed to execute SQL statement:
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
 Error Message:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)    [UNEXPECTED]Error determining whether this is a multi-node instance

 Statement Handler Error Code: 4063
 Statement Handler Error Message: ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
 Reference of statement-handler is valid, not attempting database reconnect.
 Failed to execute SQL statement:
  select ad_zd_adop.validate_session_id('') from dual

 Error Message:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)

i queried dba_objects and confirmed the below. 

select object_name,object_type,owner,status from dba_objects where status='INVALID';

OBJECT_NAME          OWNER                          STATUS  OBJECT_TYPE

-------------------- ------------------------------ ------- -------------------

AD_ZD_ADOP           APPS                           INVALID PACKAGE BODY

FND_DIAGNOSTICS      APPS                           INVALID PACKAGE BODY

XX_AR_MASTER_DATA_DE APPS                           INVALID PACKAGE BODY

I ran utlrp and compile apps schema option through adadmin but it dint fix the issue. 

But the below did.

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> commit;

Commit complete.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

Query once again dba_objects and confirm the package became valid. Then after i was able to run adop. 

Thanks!