R12.2.4 LOG file Location

Oracle EBS R12.2.4 Log Files Location


AutoConfig log file location

a) Autoconfig Log Location on Application tier :

[root@Sujeet 12300959]# pwd

/u02/apps/fs1/inst/apps/PREPROD_chintels/admin/log/12300959

$INST_TOP/admin/log/$MMDDHHMM/adconfig.log

b) Autoconfig Log Location on Database tier:

[root@sujeet 12300958]# pwd
/u01/db/11.2.0/appsutil/log/PREPROD_sujeet/12300958

[root@sujeet 12300958]# cat adconfig.log


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

Patching Log files location

The Online Patching (ADOP) log files are located on the non-editioned file system (fs_ne),
Under : $NE_BASE/ EBSapps/ log/adop/ <adop_session_id>/ <phase>_<date>_<time>/ <context_name>/ log

[root@sujeet adop]# pwd
/u02/apps/fs_ne/EBSapps/log/adop

[root@sujeet adop]# ll
total 4
drwxr-xr-x 4 applchintels dba 4096 Aug 19 13:52 5
-rw-r--r-- 1 applchintels dba    0 Aug 19 11:53 adop_20150819_115248.log

Note: fs1 and fs2 are dual file system for software where as fs_ne contains non editioned objects

This log directory will contain patch logs, patch worker logs and other patch related log files
created for specific purposes.
Also, some patch tasks may create separate log files in the same directory from where patch
executable is started

 R12.2 Start & Stop Log Files location

Startup & Shutdown error message text files like adstrtal.txt, adstpall, adapcctl.txt,
adcmctl.txt…for services like oacore, forms, apache, opmn, weblogic admin server/node manager etc...

[root@sujeet log]# pwd
/u02/apps/fs1/inst/apps/PREPROD_chintels/logs/appl/admin/log

[root@sujeet log]# ls
adadminsrvctl.txt  adforms-c4wsctl.txt  adoaeactl.txt  adstrtal.log
adalnctl.txt       adformsctl.txt       adoafmctl.txt  hs_err_pid7136.log
adapcctl.txt       adnodemgrctl.txt     adopmnctl.txt  jtffmctl.txt
adcmctl.txt        adoacorectl.txt      adstpall.log   tempNMStart.log


Log files location for concurrent programs & managers

$NE_BASE/ inst/ <CONTEXT_NAME>/ logs/ appl/ conc/ log
 Output files for concurrent programs/managers

$NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out

Cloning related Log Files location

a) Pre-clone log files in source instance

     I. Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

 [root@sujeet ]# cd /u01/db/11.2.0/appsutil/log/PREPROD_sujeet/ 

 II. Application Tier

$INST_TOP/admin/log/ (StageAppsTier_MMDDHHMM.log)

b) Clone log files in target instance

    I. Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.log
   
II. Apps Tier

 $INST_TOP/admin/log/ApplyAppsTier_<time>.log

If your clone on DB Tier fails while running txkConfigDBOcm.pl (Check metalink note – 415020.1)
During clone step on DB Tier it prompts for “Target System base directory for source homes” and
during this you have to give like /base_install_dir like ../../r12 and not oracle home
like ../../r12/db/tech_st_10.2.0


Installation Related Logs:

There are four main phases (in context of logs) during R12.2 installation, here is log location
of all four phases .

a) The Rapidwiz Configuration File is saved in below locations:

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

b) Pre-install system check logs:

$TMP/<MMDDHHMM>/<MMDDHHMM>.log
$TMP/dbPreInstCheck.xxxxx.log
$TMP/wtprechk.xxxx/wtprechk.xxxx.log
<Global Inventory>/logs/installActions<timestamp>.log

c) Database tier

I. Main Installation log:

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

II. ORACLE HOME installation logs:

RDBMS $ORACLE_HOME/ temp/ $CONTEXT_NAME/ logs/ *.log
<Global Inventory>/logs/*.log

d) Application tier

Both primary(Run) and Secondary Edition (Patch) file systems will each contain these logs:

    I. Main Installation Log:

$INST_TOP/logs/<MMDDHHMM>.log

   II. FMW and OHS TechStack Installation/Patching logs:

$APPL_TOP/admin/$CONTEXT_NAME/log/*
<Global Inventory>/logs/*.log

   III. Forms Oracle Home installation logs:

$APPL_TOP/admin/$CONTEXT_NAME/log/*.log

Fusion Middleware (FMW_HOME) Log Files:

 a) Log files for OPMN and OHS processes:
Below directory contains log files related OPMN process(opmn.log), OPMN Debug logs(debug.log), HTTP Transaction logs (access.log), security settings related logs.

$IAS_ORACLE_HOME/ instances/ <ohs_instance>/ diagnostics/ logs

b) Log files for weblogic node manager:
Log file is generated by Node Manager and contains data for all domains that are controlled by Node Manager on a given physical machine.

$FMW_HOME/ wlserver_10.3/ common/ nodemanager/ nmHome1/ nodemanager.log

c) Log files for weblogic Oracle Management Service log file:
 Initial settings AdminServer and Domain level information is written in this log file.

$EBS_DOMAIN_HOME/sysman/log

d) Log files for server processes initiated through weblogic: 
Stdout and stderr messages generated by the server instance (server instances like forms, oafm, oacore etc) at NOTICE severity level or higher are written by Weblogic Node Manager to below directory.

$EBS_DOMAIN_HOME/ servers/ <server_name>/ logs/ <server_name>.out

og files file Online patching (adop)

The adop log files are located on the non-editioned file system (fs_ne), under:

$NE_BASE/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log

This log directory will contain patch logs, patch worker logs and other patch related log files
created for specific purposes Also, some patch tasks may create separate log files in the same directory.

Online pathcing filesystem cloning process related log files are found under:

$INST_TOP/admin/log

Log files for Autoconfig process

On Applicaion Tier: $INST_TOP/admin/log/<MMDDhhmm>
On Database Tier: $ORACLE_HOME/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm>

Log/Out files for Concurrent programs/managers

The path is defined by same variables that we used earlier for 11i/R12.1 . Log/Out files are
stored in Non-Editioned filesystem.

Log files: $APPLCSF/$APPLLOG (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/log)
Out files: $APPLCSF/$APPLOUT (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out)

Log files for OPMN and OHS processes

Below directory contains log files related OPMN process(opmn.log), OPMN Debug logs(debug.log),
HTTP Transaction logs (access.log), security settings related logs.

$IAS_ORACLE_HOME/instances/<ohs_instance>/diagnostics/logs

Log file for Weblogic Node Manager

Log file is generated by Node Manager and contains data for all domains that are controlled by
Node Manager on a given physical machine.

$FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log

Log file for Weblogic Oracle Management Service log file

Initial settings AdminServer and Domain level information is written in this log file

$EBS_DOMAIN_HOME/sysman/log

Log files for server processes initiated through Weblogic

Stdout and stderr messages generated by the server instance (server instnaces like forms, oafm,
oacore etc) at NOTICE severity level or higher are written by Weblogic Node Manager to below directory.

$EBS_DOMAIN_HOME/servers/<server_name>/logs/<server_name>.out

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...