EBS 11i and R12 configuration and environment file locations

EBS 11i and R12 configuration and environment file locations

 

File	Oracle Apps 11i	Oracle Apps R12
Environment Source file	$APPL_TOP/APPSORA.env	$APPL_TOP/APPS<$CONTEXT_NAME>.env
Context File (Middle tier)	$APPL_TOP/admin/$TWO_TASK.xml	$INST_TOP/appl/admin/$CONTEXT_NAME.xml
tnsnames.ora (OH)	$ORACLE_HOME/network/admin/<$CONTEXT_NAME >	$INST_TOP/ora/10.1.2/network/admin
listener.ora	$ORACLE_HOME/network/admin/<$CONTEXT_NAME >	$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_NAME >	$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/<$CONTEXT_NAME >	$LOG_HOME/appl/admin/log
Concurrent Request logs	$APPLCSF	$APPLCSF
Workflow mailer log	$APPLCSF/$APPLLOG/FNDCPGSC*.txt	$APPLCSF/$APPLLOG/FNDCPGSC*.txt
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

A. Startup/Shutdown Log files for Application Tier in R12

Instance Top is new TOP added in R12

–Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…

$INST_TOP/logs/appl/admin/log

–Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web)

$INST_TOP/logs/ora/ (10.1.2 & 10.1.3)

$INST_TOP/logs/ora/10.1.3/Apache/error_log[timestamp]

$INST_TOP/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)

$INST_TOP/logs/ora/10.1.2/network/ (listener log)

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

B. Log files related to cloning in R12

Preclone log files in source instance

Database Tier – $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

Application Tier –

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

Clone log files in target instance

Database Tier – $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log

Apps Tier – $INST_TOP/admin/log/ApplyAppsTier_.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

C. Patching related log files in R12

i) Application Tier adpatch log – $APPL_TOP/admin/$SID/log/

ii) Developer (Developer/Forms & Reports 10.1.2) Patch – $ORACLE_HOME/.patch_storage

iii) Web Server (Apache) patch – $IAS_ORACLE_HOME/.patch_storage

iv) Database Tier opatch log – $ORACLE_HOME/.patch_storage

D. Autoconfig related log files in R12

i) Database Tier Autoconfig log :

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log

ii) Application Tier Autoconfig log : $INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log

Autoconfig context file location in R12 – $INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml

E. R12 Installation Logs

Database Tier Installation

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log

RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Application Tier Installation

$INST_TOP/logs/.log

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log

$INST_TOP/logs/ora/10.1.2/install/make_.log

$INST_TOP/logs/ora/10.1.3/install/make_.log

$INST_TOP/admin/log/ApplyAppsTechStack.log

$INST_TOP/admin/log/ohclone.log

$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log

$APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log

$APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log

Inventory Registration:

$Global Inventory/logs/cloneActions.log

$Global Inventory/logs/oraInstall.log

$Global Inventory/logs/silentInstall.log

F. Other log files in R12

1) Database Tier

1.1) Relink Log files :

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log

1.2) Alert Log Files :

$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

1.3) Network Logs :

$ORACLE_HOME/network/admin/$SID.log

1.4) OUI Logs :

OUI Inventory Logs :

$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs

2) Application Tier

$ORACLE_HOME/j2ee/DevSuite/log

$ORACLE_HOME/opmn/logs

$ORACLE_HOME/network/logs

Tech Stack Patch 10.1.3 (Web/HTTP Server)

$IAS_ORACLE_HOME/j2ee/forms/logs

$IAS_ORACLE_HOME/j2ee/oafm/logs

$IAS_ORACLE_HOME/j2ee/oacore/logs

$IAS_ORACLE_HOME/opmn/logs

$IAS_ORACLE_HOME/network/log

$INST_TOP/logs/ora/10.1.2

$INST_TOP/logs/ora/10.1.3

$INST_TOP/logs/appl/conc/log

$INST_TOP/logs/appl/admin/log

TKPROF

TKPROF

File name of trace file

select rtrim(c.value,'/')|| '/'||d.instance_name|| '_ora_'|| ltrim(to_char(a.spid))||'.trc' from v$process a, v$session b, v$parameter c, v$instance d where a.addr=b.paddr and b.audsid=sys_context('userenv','sessionid') and   c.name='user_dump_dest';

To set tracing on before running session
 

SQL> SET TIMING ON

TIMED_STATISTICS is set to TRUE to get timing information in our trace files. 

SQL> alter session set timed_statistics=true;

MAX_DUMP_FILE_SIZE – Controls the maximum size of the trace file.
SQL> alter session set max_dump_file_size = unlimited;

Enable tracing for specific user session
SQL> alter session set events '10046 trace name context forever, level 12';

Execute SQLs or PL/SQLs to trace the session.

Stop tracing :-
SQL> alter session set events '10046 trace name context OFF';
 

For extended trace for another session.

SQL> EXEC SYS.DBMS_SYSTEM.SET_EV(&SID, &SERIAL_NUMBER, 10046, &TRACELEVEL, ' ');

To stop extended trace for another session.
 

SQL> EXEC SYS.DBMS_SUPPORT.STOP_TRACE_IN_SESSION(SID, SERIAL_NUMBER);
The SID and SERIAL# can be fetched from V$SESSION.
 

Default trace file location - udump directory.

To convert trace file (.trc) tkprof (.txt)

Go to the trace file location

e.g.
/Oracle/PROD/db/tech_st/11.1.0/admin/PROD_erpdbsvr/diag/rdbms/prod/PROD/trace

Connect SQLPLUS
SQL> alter session set timed_statistics=true;
SQL> alter session set sql_trace=true;

NOW OPEN DUPLICATE SESSION
Eg. $  tkprof PROD_dbrm_22096.trc
TKPROF <trace filename>

IT WILL ASK FOR OUTPUT FILE NAME
Eg. PROD_dbrm_22096.txt

tkprof <filename.trc> <output_filename> sys=no explain=apps/<password>
example: tkprof file1234.trc file1234.out explain=<apps/apps>

Enabling SSL or TLS in Oracle E-Business Suite Release 12

Enabling SSL or TLS in Oracle E-Business Suite Release 12

>> Backup context file

echo $CONTEXT_FILE
/U01/appl/PREP/inst/apps/PREP_weberp/appl/admin/PREP_weberp.xml
cd /U01/appl/PREP/inst/apps/PREP_weberp/appl/admin
cp PREP_weberp.xml PREP_weberp_15FEB15.xml

 

Step 1 - Set Your Environment
1. Logon to the application middle tier as the OS user who owns the middle tier files.
2. Source your middle tier environment file (APPS<sid_machine>.env) located in the APPL_TOP directory.
3. Navigate to the $INST_TOP/ora/10.1.3 and source the <sid_machine>.env file to set your 10.1.3
ORACLE_HOME variables.

[root@weberp ~]# su - appl
[appl@weberp ~]$ cd $INST_TOP/ora/10.1.3
[appl@weberp 10.1.3]$ pwd
/U01/appl/PREP/inst/apps/PREP_weberp/ora/10.1.3
[appl@weberp 10.1.3]$ ls
Apache       config    j2ee       network  PREP_weberp.env
cfgtoollogs  deconfig  javacache  opmn
 

 

Go to $INST_TOP
/U01/appl/PREP/inst/apps/PREP_weberp
Take backup of certs folder

Step 2 - Create a wallet
1. Navigate to the $INST_TOP/certs/Apache directory.
2. Move the existing wallet files to a backup directory in case you wish to use them again in the future.
3. Open the Wallet manager as a background process:
owm &
4. On the Oracle Wallet Manager Menu navigate to Wallet -> New.
Answer NO to: “Your default wallet directory doesn't exist. Do you wish to create it now?”
The new wallet screen will now prompt you to enter a password for your wallet.
Click YES when prompted:
“A new empty wallet has been created. Do you wish to create a certificate request at this time?”

 

ENTER 'NO'

 

CREATE WALLET PASSWORD

eg. test123

 

 

PRESS 'YES'
Step 3 - Create a Certificate Request
After clicking "Yes" in step 2 the Create Certificate Request Screen will pop up:
Fill in the appropriate values where:
Common Name: is the name of your server including the domain.
Organizational Unit: (optional) The unit within your organization.
.
Organization: is the name of your organization.
Locality/City: is your locality or city.
State/Province: is the full name of your State or Province - do not abbreviate.
Select your Country from the drop down list, and for the Key Size, select 2048 as a minimum. Click OK.
 

 

 

 

Step 4 - Submit the Certificate Request to a Certifying Authority
You will need to export the Certificate Request before you can submit it to a Certifying Authority.
1.    Click on Certificate [Requested] to Highlight it.
2.    From the menu click Operations -> Export Certificate Request
3.    Save the file as server.csr
4.    From the menu click Wallet and then click Save.
5.    On the Select Directory screen change the Directory to your fully qualified wallet directory.
6.    Click OK.
7.    From the menu click Wallet and check the Auto Login box.
Be sure to make this password something you will remember. You will need to use the password whenever you open the wallet with Oracle Wallet Manager or perform operations on the wallet using the Command Line Interface. With a uto login enabled processes submitted by the OS user who created the wallet will not need to supply the password to access the wallet.
8.    Exit the Wallet Manager.
The wallet directory will now contain the following files:
•    cwallet.sso
•    ewallet.p12
•    server.csr
You may now submit server.csr to your Certifying Authority to request a Server Certificate.
 

 

Change path to save file

 

From the menu click Wallet and check the Auto Login box.

 

b64InternetCertificate.txt file location
/U01/appl/PREP/apps/tech_st/10.1.2/sysman/config
 

Applications Technology : R12 User Guides

Applications Technology : R12 User Guides

Lifecycle Management

Oracle E-Business Suite Installation Guide: Using Rapid Install	E12842-04
Maintaining Oracle E-Business Suite Documentation Set	NA
Oracle E-Business Suite Maintenance Procedures	E13675-03
Oracle E-Business Suite Maintenance Utilities	E13676-03
Oracle E-Business Suite Patching Procedures	E12148-04
Oracle E-Business Suite Upgrade Guide, Release 11i to 12.1.3	E16342-03
Oracle iSetup Developer's Guide	E15842-01
Oracle iSetup User's Guide	E12899-04
Oracle Diagnostics Framework User's Guide	E12895-03

System Administration

Oracle E-Business Suite System Administrator's Guide Documentation Set	NA
Oracle E-Business Suite System Administrator's Guide - Configuration	E12893-04
Oracle E-Business Suite System Administrator's Guide - Maintenance	E12894-04
Oracle E-Business Suite System Administrator's Guide - Security	E12843-05
Oracle E-Business Suite Flexfields Guide	E12892-04
Oracle Alert User's Guide	E12951-04
Oracle E-Business Suite CRM System Administrator's Guide	E12898-03

Architecture and Common Applications

Oracle E-Business Suite Concepts	E12841-04
Oracle E-Business Suite Multiple Organizations Implementation Guide	E13423-04
Oracle Trading Community Architecture Administration Guide	E13568-04
Oracle Trading Community Architecture Reference Guide	E13569-04
Oracle Trading Community Architecture Technical Implementation Guide	E13662-04
Oracle Trading Community Architecture User Guide	E13570-04
Oracle Common Application Calendar Implementation Guide	E13405-04
Oracle Common Application Calendar User Guide	E13407-04

UserInterface, Development, and Personalization

Oracle E-Business Suite User's Guide	E12896-04
Oracle E-Business Suite Developer's Guide	E12897-04
Oracle E-Business Suite User Interface Standards for Forms-Based Products	E12900-03
Oracle Application Framework Personalization Guide	E12646-04

Integration

Oracle E-Business Suite Integrated SOA Gateway Developer's Guide (zipped)	E12065-06
Oracle E-Business Suite Integrated SOA Gateway Implementation Guide	E12169-06
Oracle E-Business Suite Integrated SOA Gateway User's Guide	E12064-06
Oracle e-Commerce Gateway Implementation Manual	E12953-03
Oracle e-Commerce Gateway User's Guide	E12952-03
Oracle Workflow Administrator's Guide	E12903-04
Oracle Workflow API Reference	E12904-04
Oracle Workflow Client Installation Guide	E12779-03
Oracle Workflow Developer's Guide	E12905-04
Oracle Workflow User's Guide	E12906-04
Oracle XML Gateway User's Guide	E12954-04

Reporting and Desktop Integration

Oracle E-Business Suite Desktop Integration Framework Developer's Guide	E15877-02
Oracle Report Manager User's Guide	E12901-04
Oracle Web Applications Desktop Integrator Implementation and Administration Guide	E12902-04