Enable Trace in Oracle E-Business Suite R12

Debugging tool for HTTP, OC4J and OPMN in E-Business Suite R12

How To Enable and Collect Debug for HTTP, OC4J and OPMN

Shutdown the http server, oc4j and opmn services

adapcctl.sh stop
adoacorectl.sh stop
adformsctl.sh stop
adoafmctl.sh stop
adopmnctl.sh stop

Enable http ODL logging
-----------------------
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf

OraLogMode oracle
OraLogSeverity TRACE:32
OraLogDir $LOG_HOME/ora/10.1.3/Apache/oracle


Please use the full path to $LOG_HOME e.g. OraLogDir /u01/inst/apps/JCB_atg/logs/ora/10.1.3/Apache/oracle

mkdir $LOG_HOME/ora/10.1.3/Apache/oracle

Increase OC4J logging for oacore
-------------------------------
edit j2ee-logging.xml adjust the following in file:

$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/j2ee-logging.xml




Increase OC4J logging for forms
------------------------------
edit j2ee-logging.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/forms/config/j2ee-logging.xml


edit orion-web.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml


debug_mode
true

Increase OPMN Logging
-------------------------------
edit opmn.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml



Note : Check log Location /u01/inst/apps/JB_atg/logs/ora/10.1.3/opmn/opmn.dbg

Startup the http server, oc4j and opmn (reverse the startup sequence above)

Upgrade Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

Upgrade Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

Oracle recommends that Oracle E-Business Suite 12 customers move to the latest and therefore most secure certified version of the Sun JRE Native Plug-in on either stream (JRE 5.0.x or JRE 6.0.x).

1. Check Version.

D:\oracle\PROD\apps\apps_st\appl>grep plugin %CONTEXT_FILE%
[!-- JDK plugins --]
[sun_plugin_ver oa_var="s_sun_plugin_ver"]1.5.0_13[/sun_plugin_ver]


2.Download the JRE Plug-in Interoperability Patch

Download the JRE Plug-in Oracle E-Business Suite interoperability patch 4377566

3.Download the Java Runtime Environment (JRE) 6 plug-in from

http://java.sun.com/javase/downloads/index.jsp

Select the Java Runtime Environment (JRE) 6 Update X ( where X is the current latest version)
Download the Windows Offline Installation version of the Plug-in.
If an earlier version of the JRE 6 Plug-in is required, it can be downloaded from the Sun archive site from http://java.sun.com/products/archive/ .

Select the required release from the drop down menu under, Java 2 Platform Standard Edition (J2SE) -> JDK/JRE - 6 .
Select the Download JRE.
Download the Windows Offline Installation, Multi-language version of the Plug-in.

4.Rename the JRE 6 Plug-in

Rename the downloaded JRE Native Plug-in file from jre-6_uxx-windows-i586-p.exe to j2se160xx.exe

(Where xx = the version number. Using jre-6_u13-windows-i586-p.exe as an example this would be j2se16013.exe).

5.Place the JRE 6 Plug-in on Web Application Tier

Move the j2se1600X.exe file to the web application tier and place it in %[COMMON_TOP]%\webapps\oacore\util\jinitiator..

6.Stop Apps or Shutdown Apache

Shutdown Apache (on normal mode) by running adapcctl.sh stop or by running adstpall.sh /

7.Enable 'Maintenance Mode' from adadmin

Enable 'Maintenance Mode' from adadmin, (Select menu option 5 > Change Maintenance Mode >Select menu option 1 > Enable Maintenance Mode)

7.Apply the patch driver in the interop patch using AutoPatch.

Apply the patch 4377566

8.Run the txkSetPlugin.cmd Script

Run the %FND_TOP%\bin\txkSetPlugin.cmd script against the web application tier node.

txkSetPlugin.cmd [appsora_path] [apps_pwd] [jversion]

9.Disable 'Maintenance Mode' through adadmin

Disable 'Maintenance Mode' from adadmin, (Select menu option 5 > Change Maintenance Mode > Menu option 2 > Disable Maintenance Mode)

10.Restart Apache or Start Apps

Restart Apache (on normal mode) by running adapcctl.sh start or adstrtal.sh /

txkSetPlugin.cmd D:\oracle\PROD\apps\apps_st\appl\APPSSIT_sitartha.cmd xxxxxx 16013

11.Check version Now.
D:\oracle\PROD\inst\apps\SIT_sitartha>grep plugin %CONTEXT_FILE%
[!-- JDK plugins --]
[sun_plugin_ver oa_var="s_sun_plugin_ver"]1.6.0_13[/sun_plugin_ver]

Enabling frmservlet R12 direct login

Enabling f60cgi direct login
Enabling frmservlet R12.0.6 direct login

Enable Method:

java oracle.apps.fnd.security.AdminAppServer apps_username/apps_password AUTHENTICATION OFF DBC={dbc_file_name}

java oracle.apps.fnd.security.AdminAppServer apps/xxxxxx AUTHENTICATION OFF DBC=VIS.dbc

Disable Method:
1.To activate basic server security, from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps_username/apps_password AUTHENTICATION ON DBC={dbc file path}

2.To activate full server security (SECURE mode), from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps_username/apps_password AUTHENTICATION SECURE DBC={dbc file path}

Check the status:

java oracle.apps.fnd.security.AdminAppServer apps_username/apps_password STATUS DBC={dbc_file_name}

java oracle.apps.fnd.security.AdminAppServer apps/xxxxxx STATUS DBC=VIS.dbc

Database Server
---------------
DATABASE_ID: VIS
AUTHENTICATION: SECURE

Application Server
------------------
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: 61753FFF2F867C9CEE040A8C00B0000328F16873181892135982523005112239

APP-FND-01542

Error Message

APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator.





Solution:

1. Backup context file .

2. Update the context variable:
s_appserverid_authentication

By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.

Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security

3. Run Autoconfig to instantiate the change.

Rapid Cloning Steps for Oracle EBS R12 (R12.0.6) Windows

Rapid Cloning Steps for Windows R12

Source System:
1.Run adpreclone.pl in Database Node
2.Perl $ORACLE_HOME\appsutil\scripts\$CONTEX_NAME\adpreclone.pl dbTier
3.Run adpreclone.pl in Apps Node
4.Perl $ADMIN_SCRIPTS_HOME\adpreclone.pl appsTier
5.Shut down the Applications and database
6.Change all services type into manual (option)
7.Restart the system (option)
8.Check if any FNDLIBR programs are running or not
9.Take a cold backup of database and applications

Target System:
Prepare your target system as per the source system configuration
1.Install Windows Server 2003 service pack 2 Ent Edition(Target system is windows server 2003)
2.Install Visual Studio 2005
3.Install Active perl
4.Install Cygwin Change make version from 3.81 into 3.80
5.Copy the Source system backup into target system
6.Set perl locations by using existing env file(It varies DB node and Apps Node, We will set this two times)
7.Goto the $ORACLE_HOME\appsutil\clone\bin folder and the post clone scripts
8.Run Postclone scripts in db Tier
9.Perl $ORACLE_HOME\appsutil\clone\Bin\adcfgclone.pl dbTier
10.Run Postclone in Apps Tier
11.Perl $COMMON_TOP\clone\bin\adcfgclone.pl appsTier

Finishing Tasks:
1.Update the profile options
Rapid clone will update the site level profile options only, we need to update instance level profile options manually
2.Update the printer settings
3.Update the workflow configuration settings
Cloning an Oracle Applications instance will not update the host and instance specific information used by Oracle Workflow. Review the following tables and columns to verify there is no instance specific data in the Workflow configuration on the target system.

Important Notes:
a).While running Postclone in appsTier it prompts hostname, we should give like hostname.domainname for example sys10.sample.com
b).While running post clone in appsTier it prompts visual studio directory don’t include bin folder. For example give like c:\vc\VC, don’t give like c:\vc\VC\bin

Windows Oracle Apps monitor Command Line Process Viewer and Killer

Windows Oracle Apps monitor Command Line Process Viewer and Killer

Download file process.exe

Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03
Copyright(C) 2002-2003 Craig.Peacock@beyondlogic.org
Usage: process [-v] [-t] [-c]
process [-q] [Process Name/PID] [timeout sec(optional)]
process [-k] [-s] [-r] [Process Name/PID]
process [-p] [Process Name/PID] {RealTimeHighAboveNormal
NormalBelowNormalLow}
process [-a] [Process Name/PID] [Mask(To Set)]
-v View Processes.
-t View Kernel and User CPU Times.
-c View Process Creation Times.
-q Send WM_CLOSE Message. Default timeout is 60 Sec
-k Kill Process. (Terminate)
-s Suspend Process.
-r Resume Suspended Process.
-p Set Process Priority.
-a Get/Set Affinity Mask of Process.

FND Check
D:\>process grep FND
FNDLIBR.exe 7020 1 8 0 NT AUTHORITY\SYSTEM
FNDSM.exe 636 1 8 0 NT AUTHORITY\SYSTEM
FNDCRM.exe 6500 1 8 0 NT AUTHORITY\SYSTEM
FNDSCH.exe 7176 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6288 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6656 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 1456 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7908 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6156 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7936 1 8 0 NT AUTHORITY\SYSTEM

Forms Check
D:\>process grep frm
frmweb.exe 6956 2 8 0 NT AUTHORITY\SYSTEM
frmweb.exe 6100 2 8 0 NT AUTHORITY\SYSTEM

Killing Process ID
Killing Process ID in Windows
D:\>process grep not
notepad.exe 6168 1 8 0 ARTHA\Administrator
D:\>process -k 6168
Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03
Copyright(C) 2002-2003 Craig.Peacock@beyondlogic.org
Killing PID 6168 'notepad.exe'

Kill FNDLIBR.exe

D:\>process -k FNDLIBR.exe

Kill frmweb.exe

D:\>process -k frmweb.exe

All Process
D:\>process

Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03
Copyright(C) 2002-2003 Craig.Peacock@beyondlogic.org

ImageName PID Threads Priority CPU Owner
Idle 0 8 0 5 Error 0x6 : The handle is invalid.
System 4 109 8 0 Error 0x5 : Access is denied.
smss.exe 336 2 11 0 NT AUTHORITY\SYSTEM
csrss.exe 384 15 13 0 NT AUTHORITY\SYSTEM
winlogon.exe 412 18 13 0 NT AUTHORITY\SYSTEM
OAMKSVC.exe 1704 2 8 0 NT AUTHORITY\SYSTEM
tnslsnr.exe 1724 3 8 0 NT AUTHORITY\SYSTEM
opmn.exe 1764 1 8 0 NT AUTHORITY\SYSTEM
opmn.exe 1784 19 8 0 NT AUTHORITY\SYSTEM
isqlplussvc.exe 1832 2 8 0 NT AUTHORITY\SYSTEM
TNSLSNR.EXE 1912 3 8 0 NT AUTHORITY\SYSTEM
oracle.exe 1932 58 8 0 NT AUTHORITY\SYSTEM
java.exe 1940 10 8 0 NT AUTHORITY\SYSTEM
svchost.exe 1968 3 8 0 Error 0x5 : Access is denied.
TeamViewer_Service.exe 2060 4 8 0 NT AUTHORITY\SYSTEM
tlntsvr.exe 2076 4 8 0 Error 0x5 : Access is denied.
TeamViewer.exe 2296 7 8 0 NT AUTHORITY\SYSTEM
java.exe 3280 55 8 0 NT AUTHORITY\SYSTEM
Apache.exe 3568 516 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3600 1 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3608 1 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3616 1 8 0 NT AUTHORITY\SYSTEM
rotatelogs.exe 3624 1 8 0 NT AUTHORITY\SYSTEM
rotatelogs.exe 3632 1 8 0 NT AUTHORITY\SYSTEM
rotatelogs.exe 3640 1 8 0 NT AUTHORITY\SYSTEM
cmd.exe 3648 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7020 1 8 0 NT AUTHORITY\SYSTEM
FNDSM.exe 636 1 8 0 NT AUTHORITY\SYSTEM
RCVOLTM.exe 6092 1 8 0 NT AUTHORITY\SYSTEM
POXCON.exe 3088 1 8 0 NT AUTHORITY\SYSTEM
INCTM.exe 8148 1 8 0 NT AUTHORITY\SYSTEM
java.exe 5600 26 8 0 NT AUTHORITY\SYSTEM
FNDCRM.exe 6500 1 8 0 NT AUTHORITY\SYSTEM
FNDSCH.exe 7176 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6288 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6656 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 1456 1 8 0 NT AUTHORITY\SYSTEM
INVLIBR.exe 7704 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7908 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 6156 1 8 0 NT AUTHORITY\SYSTEM
FNDLIBR.exe 7936 1 8 0 NT AUTHORITY\SYSTEM
PALIBR.exe 440 1 8 0 NT AUTHORITY\SYSTEM
Process.exe 7928 1 13 0 ARTHA\Administrator

ORA-04030: out of process memory

SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS
non-lib hp,pdzgM64_New_Link)

Solution
1.SQL>select object_name,object_type from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE
----------------------------------- -------------------
XLA_00200_AAD_S_000010_PKG PACKAGE BODY
XLA_00200_AAD_S_000011_PKG PACKAGE BODY

2. SQL> alter system set plsql_optimize_level =0;
System altered.

3.SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
Package body altered.

4.SQL> alter package apps.XLA_00200_AAD_S_0000011_PKG COMPILE BODY;
Package body altered.

5.SQL> alter system set plsql_optimize_level =2;
System altered.

Upgrading of Java 6.0 with Oracle E-Business Suite Release 12

Upgrading Latest Update of JDK 6.0 on all Application Tier Nodes

Step 1 Download Latest Update of JDK 6.0
http://java.sun.com/javase/downloads/index.jsp
Note : Download the 32-bit JDK, and not the Java Runtime Environment (JRE). Do not use the 64-bit version, which is not supported.

Step 2 Stop all Application Tier Server Processes

cd %INST_TOP%\admin\scripts\
adstpall.cmd

Step 3 Replace the JDK Home Used with Oracle EBS Release 12

cd [IAS_ORACLE_HOME]\appsutil\
rename jdk jdk_old
mkdir jdk
cd jdk
Install the downloaded latest update of JDK 6.0 here, i.e., [IAS_ORACLE_HOME]\appsutil\jdk
Move all files and subdiectories under /* to the folder of [IAS_ORACLE_HOME]\appsutil\jdk
After moving all files and subdirectories under one level up under [IAS_ORACLE_HOME]\appsutil\jdk, you can safely remove the empty folder of

Step 4 Restart all Application Tier Server Processes

cd %INST_TOP%\admin\scripts\
adstrtal.cmd

Step 5 AutoConfig running on the Application tier.

Upgrading To Latest Update of JRE 6.0 for AutoConfig on Database Tier Nodes

Step 1 Download Latest Update of JRE 6.0

http://java.sun.com/javase/downloads/index.jsp
Note : Download the 32-bit JRE only, and not the Java SE Development Kit (JDK).

Step 2 Replace the JRE Home Used with Oracle EBS Release 12

cd [ORACLE_HOME]\appsutil\
rename jre jre_old
mkdir jre
cd jre
Install the downloaded latest update of JRE 6.0 here, i.e., [ORACLE_HOME]\appsutil\jre
Move all files and subdiectories under /* to the folder of [ORACLE_HOME]\appsutil\jre
After moving all files and subdirectories under one level up under [ORACLE_HOME]\appsutil\jre, you can safely remove the empty folder of

Step 3 AutoConfig running on the Database tier.

Verify the Application Tier Node Configurations

Step 3.1.1. Change to the OA_HTML directory on the Web server.
Step 3.1.2. Create a file called JDKtest.jsp
Using a text editor, create a file called JDKtest.jsp under [OA_HTML] with the following line:

The JDK version is:<%= System.getProperty("java.version") %> :[%= System.getProperty("java.version") %]

Step 3.1.3. Compile the JDKtest.jsp script
Use the command to compile the jsp file:

perl -x $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'JDKtest.jsp'

Step 3.1.4. Run the JDKtest.jsp script from a web browser
Access the JSP file from a web browser, using the URL:
http://[web server]:[port]/OA_HTML/JDKtest.jsp

The version should display "1.6.0_x", where x is the number of the installed JDK 6.0 latest update.

%ADJVAPRG% -version
echo %CLASSPATH%

%AFJVAPRG% -version
echo %AF_CLASSPATH%


Doc Id : 455492.1

Oracle Apps EBS R12 Rapidwiz actually do

Oracle Apps EBS R12 Rapidwiz actually do

What does Rapidwiz actually do?

RapidWiz Installations of Oracle Applications Release 12 uses Rapid Clone and AutoConfig functionality.

The basics of how this Rapid Wizard installation works are:-

1.RapidWizard collects user information required for configuration of system, and creates a configuration file
2.RapidWizard checks Port availability and file space required
3.Zip files from the "oraDB and oraAppDB" DVD stage area are then uncompressed onto the file system
4.Each Disk directory contains a driver which is read to control the unzip phase
5.The DB Techstack is relinked and reconfigured using an install driver, templates and the configuration file
6.Control files are created
7.The RDBMS ORACLE_HOME is registered into the Global Inventory
8.The DB is started, and further configuration is performed
9.Zip files from the "oraAS" (Developer Tools and As10g" DVD stage area are then uncompressed onto the file system
10.The Apps Techstack is relinked and reconfigured using the install driver, templates and the configuration file
11.The Developer Tools and As10g ORACLE_HOMEs are registered into the Global Inventory
12.Zip files from the "oraApps" (APPL_TOP, COMMON_TOP etc) stage are uncompressed onto the file system
13.APPL_TOP is reconfigured with system using values in the configuration file and services are started
14.Post install checks are performed to check success of the installation

Oracle Apps EBS R12 Installing Log Files

Oracle Apps EBS R12 Installing Log Files

Where are the log files?

The following are referenced in this document

{MMDDHHMM} : MM (Month) DD (Day) HH (Hour) MM (Minute)
{Timestamp} : {This may include Year, Month, Day, and Time}
{Base Install} : Location chosen during the RapidWiz configuration phase
$CONTEXT_NAME : {SID}_{hostname}
RDBMS $ORACLE_HOME} : {Base Install}/db/tech_st/10.2.0
$IAS_ORACLE_HOME : {Base Install}/apps/tech_st/10.1.3
Tools $ORACLE_HOME : {Base Install}/apps/tech_st/10.1.2
$INST_TOP : {Base Install}/inst/apps/$CONTEXT_NAME
$APPL_TOP : {Base Install}/apps/apps_st/appl

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 3 locations:-

$TMP/{MMDDHHMM}/conf_{SID}.txt$INST_TOP/conf_{SID}.txt{RDBMS ORACLE_HOME}/appsutil/conf_{SID}.txt

Database Tier:

RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_{SID}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/{MMDDHHMM}/adconfig.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/{MMDDHHMM}/NetServiceHandler.log

Applications Tier(s):

$INST_TOP/logs/{MMDDHHMM}.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/logs/ora/10.1.2/install/make_{MMDDHHMM}.log
$INST_TOP/logs/ora/10.1.3/install/make_{MMDDHHMM}.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_{MMDDHHMM}.log
$APPL_TOP/admin/$CONTEXT_NAME/log/{MMDDHHMM}/adconfig.log
$APPL_TOP/admin/$CONTEXT_NAME/log/{MMDDHHMM}/NetServiceHandler.log

Inventory Registration:

{GlobalInventory}/logs/cloneActions{timestamp}.log{GlobalInventory}/logs/oraInstall{timestamp}.log{Global Inventory} /logs/silentInstall{timestamp}.log

Discoverer 10g with Oracle E-Business Suite Release 12

Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12

1.Install Oracle Discoverer 10g Release 2 (10.1.2.0.2)
Pls See the post http://oracledbas.blogspot.com/2008/12/oracle-business-intelligence-discoverer.html
2.Configure Oracle Discoverer 10g Release 2 (10.1.2.0.2)

In the Discoverer10g $ORACLE_HOME/opmn/conf/opmn.xml file check the variable for FND_SECURE. This variable specifies the directory where Discoverer is trying to locate dbc files. By

default this is set to $ORACLE_HOME/discoverer/secure.

cat $ORACLE_HOME/opmn/conf/opmn.xml grep FND_SECURE
cd $ORACLE_HOME/discoverer
mkdir -p secure

3.Copy Database Connection file

Copy R12 Instance($FND_SECURE) to BI(Discover) $ORACLE_HOME/discoverer/secure

4.Update tnsnames.ora file

Add TNS (tnsnames.ora) Both R12 and BI(Discover) Check tnsping

5.In Oracle R12 Change xml in s_disco_url parameter
cd $INST_TOP/appl/admin
[applmgr@sys33 admin]$ cat VIS_sys33.xml grep s_disco_url
Change s_disco_url in your Discoverer url
After change Check
[applmgr@sys33 admin]$ cat VIS_sys33.xml grep s_disco_url
http://sys22.doyen.in:7777

6.Set Applications profile options in Oracle E-Business Suite

Log into E-Business Suite Release 12 with the System Administrator responsibility
Navigate to the Profile > System form
Query the %Discoverer% profile options.

7.Regenerate your Business Views

Logon to Oracle E-Business Suite as SYSADMIN
Choose the "Business Views Setup" responsibility
Navigate to Reports > Run > Pick Single Request > "Generate ALL Business Views"

In case you don't have "Business Views Setup" responsibility assigned to SYSADMIN user, please do the following:

Logon to Oracle E-Business Suite as SYSADMIN
Choose the "System Administrator" responsibility.
Navigate to Security > User > Define and add responsibility "Business Views Setup" to user SYSADMIN.

8. Login Discoverer
http://sys22.doyen.in:7777/

Discoverer Plus
http://sys22.doyen.in:7777/discoverer/plus






Discoverer Viewer

373634.1: Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12

Enable SSL Oracle E-Business Suite Release 12

Enable SSL Oracle Application R12 (Apps R12)

The most significant change for Secure Sockets Layer (SSL) support in E-Business Suite Release 12 is the use of the mod_ossl module for the Oracle HTTP Server. Like mod_ssl, the mod_ossl plug-in enables strong cryptography for Oracle HTTP Server. In contrast to the OpenSSL module, mod_ossl is based on the Oracle implementation of SSL, which supports SSL 3, and is based on Certicom and RSA Security technology.

Secure Sockets Layer (SSL)
SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data integrity for secure transactions. Exchange of data between the client and server in such secure transactions is said to use the Secure Sockets Layer (SSL).

SSL uses 2 types of Certificates:
User certificates
These are Certificates issued to servers or users to prove their identity in a public key/private key exchange.

Trusted certificates
These are Certificates representing entities whom you trust - such as certificate authorities who sign the user certificates they issue.


The main steps for setting up SSL on the Middle Tier are:

Method 1

Set Your Environment.
Create a wallet.
Create a Certificate Request.
Submit the Certificate Request to a Certifying Authority
Import your Server Certificate to the Wallet.
Update the JDK Cacerts File
Update the Context File.
Run Autoconfig.
Restart the middle tier services.


Method 2

User Create or Converting Existing Certificates

$INST_TOP/ora/10.1.3/.env

cd $INST_TOP/certs/Apache

Backup the existing wallet files

Creating user Certificates

Pls See the Post Creating User Certificates.

(OR)

Copy server.key, server.crt, and ca.crt to the $INST_TOP/certs/Apache directory.(Converting Existing Certificates)


$ORACLE_HOME/Apache/Apache/bin/ssl2ossl -cert ./server.crt -key ./server.key -cafile ./ca.crt -wallet . -ssowallet yes

cat ca.crt >> $ORACLE_HOME/sysman/config/b64InternetCertificate.txt

cd $OA_JRE_TOP/lib/security directory
Backup the existing cacerts file.
Copy your ca.crt file to this directory
Add your Apache ca.crt to cacerts:
keytool -import -alias ApacheRootCA -file ca.crt -trustcacerts -v -keystore cacerts

Change the Context File.

$echo $CONTEXT_FILE
/apps/oracle/VIS/inst/apps/VIS_sys33/appl/admin/VIS_sys33.xml

Run adautocfg.sh script in the Middle Tier $ADMIN_SCRIPTS_HOME directory

Restart Middle Tier .

Note:376700.1 Enabling SSL in Release 12

Oracle Application R12.0.4 missing oraInventory Create oraInventory

Oracle Application R12.0.4 missing oraInventory Create oraInventory

I have Install Oracle Application R12.0.4 after i will see oraInventory missing

I will Create oraInventory

Solutions

1.cp /etc/oraInst.loc /etc/oraInst.loc.bak

2.cp $ORACLE_HOME/oraInst.loc $ORACLE_HOME/oraInst.loc.bak

3../runInstaller -silent -attachHome ORACLE_HOME="Oracle_Home_Location" ORACLE_HOME_NAME="Oracle_Home_Name"

4. Check $ORACLE_HOME/OPatch/opatch lsinventory

Steps

[oracle@194150-web1 bin]$ ./runInstaller -silent -attachHome ORACLE_HOME="/db01/oracle/VIS/db/tech_st/10.2.0" ORACLE_HOME_NAME="VIS_DB__db01_oracle_VIS_db_tech_st_10_2_0"
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /home/oracle/oraInventory
/home/oracle/oraInventory/orainstRoot.sh

[root@194150-web1 10.2.0]# /home/oracle/oraInventory/orainstRoot.sh
Changing permissions of /home/oracle/oraInventory to 770.
Changing groupname of /home/oracle/oraInventory to oinstall.
The execution of the script is complete


[oracle@194150-web1 bin]$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.4

Oracle Interim Patch Installer version 10.2.0.3.4
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /db01/oracle/VIS/db/tech_st/10.2.0
Central Inventory : /home/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.4
OUI version : 10.2.0.3.0
OUI location : /db01/oracle/VIS/db/tech_st/10.2.0/oui
Log file location : /db01/oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch2008-11-21_18-10-37PM.log

Lsinventory Output file location : /db01/oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2008-11-21_18-10-37PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (4):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Products 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 4 products installed in this Oracle Home.


Interim patches (41) :

Patch 6317866 : applied on Wed Jan 16 12:57:15 CST 2008
Created on 20 Aug 2007, 05:13:31 hrs US/Pacific
Bugs fixed:
5254539, 5842961, 5893501, 6041535, 4587572, 5908594, 6167999, 6317851
5084757, 5095815, 5199213, 4686006, 6317866, 5382842, 5302124, 5119354
5073249, 5371149, 5385629, 5960707

Patch 4932527 : applied on Wed Jan 16 12:56:00 CST 2008
Created on 1 Apr 2007, 22:18:45 hrs US/Pacific
Bugs fixed:
4932527

Patch 4882839 : applied on Wed Jan 16 12:54:16 CST 2008
Created on 10 Sep 2007, 06:25:08 hrs US/Pacific
Bugs fixed:
4882839

Patch 5889331 : applied on Wed Jan 16 12:54:06 CST 2008
Created on 6 Jun 2007, 00:33:12 hrs PST8PDT
Bugs fixed:
5889331

Patch 5959099 : applied on Wed Jan 16 12:53:36 CST 2008
Created on 16 Apr 2007, 05:22:53 hrs US/Pacific
Bugs fixed:
5491132, 5694997, 5959099, 5667235, 5253806

Patch 5746153 : applied on Wed Jan 16 12:51:43 CST 2008
Created on 16 Feb 2007, 10:26:31 hrs US/Eastern
Bugs fixed:
5746153

Patch 5668025 : applied on Wed Jan 16 12:51:12 CST 2008
Created on 2 Apr 2007, 06:21:55 hrs US/Pacific
Bugs fixed:
5668025

Patch 5477912 : applied on Wed Jan 16 12:50:41 CST 2008
Created on 14 May 2007, 04:01:25 hrs US/Pacific
Bugs fixed:
5477912

Patch 5392772 : applied on Wed Jan 16 12:50:31 CST 2008
Created on 2 Apr 2007, 06:32:24 hrs US/Pacific
Bugs fixed:
5392772

Patch 5066528 : applied on Wed Jan 16 12:50:00 CST 2008
Created on 2 Apr 2007, 07:30:03 hrs US/Pacific
Bugs fixed:
5066528

Patch 4967236 : applied on Wed Jan 16 12:49:20 CST 2008
Created on 2 Apr 2007, 05:32:08 hrs US/Pacific
Bugs fixed:
4967236

Patch 5206570 : applied on Wed Jan 16 12:47:37 CST 2008
Created on 19 Jan 2007, 05:54:29 hrs US/Pacific
Bugs fixed:
5206570

Patch 4966417 : applied on Wed Jan 16 12:47:01 CST 2008
Created on 2 Mar 2007, 00:58:29 hrs US/Pacific
Bugs fixed:
4966417

Patch 4733582 : applied on Wed Jan 16 12:46:27 CST 2008
Created on 2 Apr 2007, 02:21:29 hrs US/Pacific
Bugs fixed:
4733582

Patch 4054238 : applied on Wed Jan 16 12:46:17 CST 2008
Created on 5 Mar 2007, 23:15:31 hrs US/Pacific
Bugs fixed:
4054238

Patch 4898580 : applied on Wed Jan 16 12:45:47 CST 2008
Created on 8 Nov 2007, 08:42:45 hrs US/Pacific
Bugs fixed:
4898580

Patch 4592596 : applied on Wed Jan 16 12:45:34 CST 2008
Created on 21 Jan 2007, 22:23:42 hrs US/Pacific
Bugs fixed:
4592596

Patch 6121268 : applied on Wed Jan 16 12:43:31 CST 2008
Created on 17 Jun 2007, 02:48:13 hrs PST8PDT
Bugs fixed:
6121268

Patch 6121267 : applied on Wed Jan 16 12:43:26 CST 2008
Created on 17 Jun 2007, 02:26:19 hrs PST8PDT
Bugs fixed:
6121267

Patch 6121266 : applied on Wed Jan 16 12:43:22 CST 2008
Created on 17 Jun 2007, 02:16:12 hrs PST8PDT
Bugs fixed:
6121266

Patch 6121264 : applied on Wed Jan 16 12:43:18 CST 2008
Created on 17 Jun 2007, 02:11:41 hrs PST8PDT
Bugs fixed:
6121264

Patch 6121263 : applied on Wed Jan 16 12:43:10 CST 2008
Created on 17 Jun 2007, 02:11:04 hrs PST8PDT
Bugs fixed:
6121263

Patch 6121261 : applied on Wed Jan 16 12:43:02 CST 2008
Created on 17 Jun 2007, 01:57:24 hrs PST8PDT
Bugs fixed:
6121261

Patch 6121260 : applied on Wed Jan 16 12:42:58 CST 2008
Created on 17 Jun 2007, 01:50:40 hrs PST8PDT
Bugs fixed:
6121260

Patch 6121258 : applied on Wed Jan 16 12:42:47 CST 2008
Created on 17 Jun 2007, 01:47:05 hrs PST8PDT
Bugs fixed:
6121258

Patch 6121257 : applied on Wed Jan 16 12:42:44 CST 2008
Created on 17 Jun 2007, 01:45:01 hrs PST8PDT
Bugs fixed:
6121257

Patch 6121250 : applied on Wed Jan 16 12:42:35 CST 2008
Created on 17 Jun 2007, 03:08:07 hrs PST8PDT
Bugs fixed:
6121250

Patch 6121249 : applied on Wed Jan 16 12:42:22 CST 2008
Created on 17 Jun 2007, 01:37:51 hrs PST8PDT
Bugs fixed:
6121249

Patch 6121248 : applied on Wed Jan 16 12:42:19 CST 2008
Created on 17 Jun 2007, 01:37:06 hrs PST8PDT
Bugs fixed:
6121248

Patch 6121247 : applied on Wed Jan 16 12:42:08 CST 2008
Created on 17 Jun 2007, 01:27:10 hrs PST8PDT
Bugs fixed:
6121247

Patch 6121246 : applied on Wed Jan 16 12:42:00 CST 2008
Created on 17 Jun 2007, 01:24:45 hrs PST8PDT
Bugs fixed:
6121246

Patch 6121245 : applied on Wed Jan 16 12:41:15 CST 2008
Created on 17 Jun 2007, 01:22:56 hrs PST8PDT
Bugs fixed:
6121245

Patch 6121244 : applied on Wed Jan 16 12:41:05 CST 2008
Created on 17 Jun 2007, 01:21:05 hrs PST8PDT
Bugs fixed:
6121244

Patch 6121243 : applied on Wed Jan 16 12:40:54 CST 2008
Created on 17 Jun 2007, 01:18:48 hrs PST8PDT
Bugs fixed:
6121243

Patch 6121242 : applied on Wed Jan 16 12:40:50 CST 2008
Created on 17 Jun 2007, 01:12:31 hrs PST8PDT
Bugs fixed:
6121242

Patch 6121183 : applied on Wed Jan 16 12:40:42 CST 2008
Created on 17 Jun 2007, 01:43:54 hrs PST8PDT
Bugs fixed:
6121183

Patch 6079591 : applied on Wed Jan 16 12:40:38 CST 2008
Created on 17 Jun 2007, 02:51:31 hrs PST8PDT
Bugs fixed:
6079591

Patch 5240469 : applied on Wed Jan 16 12:39:44 CST 2008
Created on 13 Feb 2007, 01:18:47 hrs US/Eastern
Bugs fixed:
5240469

Patch 4247037 : applied on Wed Jan 16 12:38:08 CST 2008
Created on 08 JAN 2008, 14:14:14 hrs US/Pacific
Bugs fixed:
4247037

Patch 5556081 : applied on Fri Oct 26 01:24:56 CDT 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Fri Oct 26 01:24:49 CDT 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974



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

OPatch succeeded.

Oracle Application Upgrade 12.0.6 (6728000) Patch Error for Demantra

Oracle E-Business Suite R12 Upgrade 12.0.6 (6728000) Patch Error for Demantra

Error

/u02/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

The following Oracle Forms objects did not generate successfully:

au resource MSCDSPOP.pll
au resource MSCFNORD.pll
au resource MSCFPPSC.pll
au resource MSCIOPOP.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Case:

Dermatra db link not working ..

Solutions

Fix the Dermantra db link

After run

frmcmp_batch module=$AU_TOP/resource/MSCDSPOP.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCDSPOP.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCFNORD.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCFNORD.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCFPPSC.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCFPPSC.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCIOPOP.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCIOPOP.plx module_type=library batch=no compile_all=special

Continue as if it were successful [No] : Yes

Report Builder:Warning: REP-0004: Unable to open user preference file.

Oracle E-Business Suite R12 Report Builder:Release 10.1.2.2.0 Warning: REP-0004: Unable to open user preference file.

Error:

REP-0004: Warning: Unable to open user preference file.

Report Builder: Release 10.1.2.2.0 - Production on Mon Nov 17 14:43:42 2008


Solution

Copy prefs.ora from $ORACLE_HOME/tools/admin to $HOME

cp $ORACLE_HOME/tools/admin/prefs.ora $HOME/prefs.ora

Upgrade Oracle E-Businees Sutie R12.0.6

Upgrade ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6)

The 12.0.6 Release Update Pack (RUP6) combines patches created across the E-Business Suite after the initial release of Oracle Applications 12.0 into a thoroughly tested, high-quality release pack. You apply it only to an existing Release 12.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, or FIN and HRMS family RUP5 system. Note that RUP6 is cumulative and delivers error corrections and system updates included in RUP1 (12.0.1), RUP2 (12.0.2), and RUP3 (12.0.3), RUP4 (12.0.4), FIN and HRMS family RUP5, along with those included in RUP6 (12.0.6), to bring your 12.0 system to the full 12.0.6 Release Update level.

1.OFF-CYCLE PRODUCTS ===> 6767273

2.R12.AD.A.DELTA.6 (7305220)
3.ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) (6728000)
4.CONSOLIDATED ONLINE HELP FOR 12.0.6(7109200)


Patch Applying Steps

Pre-install Tasks
1.Apply the Patch R12.AD.A.DELTA.6
R12.AD.A.DELTA.6 (7305220)
Pre-install Tasks for R12.AD.A.DELTA.6
Run perl $AD_TOP/bin/admsi.pl -patch_top=/home/applmgr/patch/7305220 -appspass=apps

[applmgr@sys38 patch]$ perl $AD_TOP/bin/admsi.pl -patch_top=/home/applmgr/patch/7305220 -appspass=apps
Gathering Information..
Logfile for this session is located at admsi.log
Generating installation instructions for patch 7305220..
Updating database....
install_7305220.html generated successfully
install_7305220.txt generated successfully

You must shut down all Application tier services before performing the tasks in this section. Instructions for running AD Grants Run the adgrants.sql script as a user that can connect as
SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Usage:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
Or, copy adgrants_nt.sql (Windows) from this patch directory to
%ORACLE_HOME%\appsutil\admin.
3. Set the environment to point to ORACLE_HOME on the database server.
4. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
Windows:
C:\> sqlplus /nolog
SQL> connect / as sysdba
SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql

Apply The Patch 7305220

Patch Apply
2. Apply the Patch RUP6
ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) (6728000)
i)Apply the Patch 6728000
ii)Run Autoconfig.

Post-install Tasks
3. Apply the Patch CONSOLIDATED ONLINE HELP FOR 12.0.6
CONSOLIDATED ONLINE HELP FOR 12.0.6(7109200)
Apply the Patch 7109200

4. Update database tier nodes with the RUP6 code level.
After you have updated to Release 12.0.6, perform the following post-update steps to update all database tier nodes with the code level provided by RUP6:

Application tier:
Run AutoConfig on the APPL_TOP.
Run the admkappsutil.pl utility to create the file appsutil.zip in the /admin/out directory.
perl /bin/admkappsutil.pl

Database tier:
Copy or FTP the appsutil.zip file to the .
Uncompress appsutil.zip under the .
cd unzip -o appsutil.zip
Run AutoConfig on the .

ORA-12705: Cannot access NLS data files or invalid environment specified

Upgare Oracle E-Business Suite R12.0.0 to R12.0.4 After runing adautocfg.sh geting Error ORA-12705: Cannot access NLS data files or invalid environment specified

Autoconfig Log

[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:


[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
afdbprf.sh INSTE8_PRF 1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
adcrobj.sh INSTE8_APPLY 1


AutoConfig is exiting with status 2


adcrobj.sh started at Sun Nov 16 02:21:23 IST 2008

Parameters passed are : -nopromptmsg

The environment settings are as follows ...

ORACLE_HOME : /u01/oracle/VIS/db/tech_st/10.2.0
ORACLE_SID : VIS
TWO_TASK :
PATH : /u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin
Library Path : /u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/dt/lib:/u01/oracle/VIS/db/tech_st/10.2.0/ctx/lib

SQLPLUS Executable : /u01/oracle/VIS/db/tech_st/10.2.0/bin/sqlplus


SQL*Plus: Release 10.2.0.2.0 - Production on Sun Nov 16 02:21:23 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.


Solution:


1.Check $ORA_NLS10
2.Check ORACLE_HOME/nls/data/9idata
3.Check xml file in the Parameter s_db_oranls
/u01/oracle/VIS/db/tech_st/10.2.0/ocommon/nls/admin/data
Change $ORA_NLS10 Path
/u01/oracle/VIS/db/tech_st/10.2.0/nls/data/9idata

or

Create $ORACLE_HOME/nls/data/old/cr9idata.pl

Create nls/data/9idata directory

cd $ORACLE_HOME/nls/data/old

perl cr9idata.pl

Creating directory /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata ...
Copying files to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata!

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

Install Oracle E-Business Suite R12 Required Space

Oracle Application R12(EBS) Required Space for Vision Database.

Application Tier File System Architecture

Oracle DB Server

Oracle Home The location of the 10g R2 ORACLE_HOME (database home), which contains files for running and maintaining the RDBMS.

Data Top (SYS) ==> Derived from the Base Install directory, this is the mount point for all database system files.
Data Top (LOG) ==> Derived from the Base Install directory, this is the mount point for all database log files.
Data Top (TXN) ==> Derived from the Base Install directory, this is the mount point for all transaction data and index files.
Data Top (ARCHIVE) ==>Derived from the Base Install directory, this is the mount point for all archive, media, advanced queue, summary,and undo files.

ORACLE_HOME(tech_st) = 4.2G
DATA_TOP(apps_st) = 128G

Oracle Application Server

Base Install directory ==> The top-level directory that Rapid Install uses to install the Applications node technology stack . All subdirectory names are derived from this directory.

Instance directory ==> The top-level directory for an Applications instance. This directory is referred to as the Instance Home, and denoted by the environment variable $INST_TOP.

COMMON_TOP ==> Holds directories for files used across products or in conjunction with third-party products. It contains the following subdirectories:
• admin - contains several subdirectories used for concurrent manager log and out directories, scripts used during installation,and scripts used for daily maintenance of the instance.
• html - contains files used by html-based products such as JSP files, java scripts, xml files, and style sheets.
• java - location of all JAR files. Also holds third-party Java files and other zip files.
• portal - contains Rapid Install Portal files.The Rapid Install Portal is a web page thatprovides access to post-installation tasks,Server Administration scripts, installation documentation, and online help.
• temp - used for caching by certain processes such as Oracle Reports.
• util - contains third-party utilities such as JDK, JRE, and Unzip.

Tools ORACLE_HOME ==> The AS 10.1.2 ORACLE_HOME directory, used for the Developer 10i products (Forms and Reports).

Web ORACLE_HOME ==> The AS 10.1.3 ORACLE_HOME directory, used for the Oracle HTTP Server. Sometimes also referred to as the Java ORACLE_HOME. Temp Directory Contains temporary files. This directory is not used during installation.

APPL_TOP(apps_st)=19G
COMMON_TOP(apps_st)=3.1G
ORACLE_HOME(tech_st)=2.6G

INST_TOP=474M

Total Requried =159G

Oracle R12 Installing Error Part-I

Oracle R12 Installing Error
Error:

$./rapidwiz

I found this error " Exception in thread "main" java.lang.UnsatisfiedLinkError:

/app03/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory".

Workaround:

Run ldd libmawt.so

[root@194150-web1 xawt]# ldd libmawt.so
linux-gate.so.1 => (0xffffe000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0xf7fa4000)
libm.so.6 => /lib/tls/libm.so.6 (0xf7f81000)
libmlib_image.so => not found
libawt.so => not found
libXext.so.6 => not found
libX11.so.6 => not found
libdl.so.2 => /lib/libdl.so.2 (0xf7f7c000)
libjava.so => not found
libjvm.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0xf7e4d000)
/lib/ld-linux.so.2 (0x56555000)

Solution:

Install X11 packages and Install Below all the RPMS WITH THEIR PREQUISTIES for Oracle R12.

binutils-2.15.92.0.2-21.x86_64.rpm
compat-db-4.1.25-9.i386.rpm (32-bit)
compat-db-4.1.25-9.x86_64.rpm
control-center-2.8.0-12.rhel4.5.x86_64.rpm
gcc-3.4.6-3.x86_64.rpm
gcc-c++-3.4.6-3.x86_64.rpm
glibc-2.3.4-2.25.i686.rpm (32-bit)
glibc-2.3.4-2.25.x86_64.rpm
glibc-devel-2.3.4-2.25.i386.rpm (32-bit)
glibc-devel-2.3.4-2.25.x86_64.rpm
glibc-common-2.3.4-2.25.x86_64.rpm
gnome-libs-1.4.1.2.90-44.1.x86_64.rpm
libstdc++-3.4.6-3.i386.rpm (32-bit)
libstdc++-3.4.6-3.x86_64.rpm
libstdc++-devel-3.4.6-3.i386.rpm (32-bit)
libstdc++-devel-3.4.6-3.x86_64.rpm
libgcc-3.4.6-3.i386.rpm (32-bit)
libgcc-3.4.6-3.x86_64.rpm
make-3.80-6.EL4.x86_64.rpm
pdksh-5.2.14-30.3.x86_64.rpm
setarch-1.6-1.x86_64.rpm
sysstat-5.0.5-11.rhel4.x86_64.rpm
xscreensaver-4.18-5.rhel4.11.x86_64.rpm
openmotif21-2.1.30-11.RHEL4.6.i386.rpm**
libaio-0.3.105-2.x86_64.rpm
libaio-0.3.105-2.i386.rpm (32-bit)
libaio-devel-0.3.105-2.x86_64.rpm

After Installed Check

ldd libmawt.so
[root@sys38 xawt]# ldd libmawt.so
/usr/lib/libcwait.so (0x001dd000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x0055d000)
libm.so.6 => /lib/tls/libm.so.6 (0x00915000)
libmlib_image.so => not found
libawt.so => not found
libXext.so.6 => /usr/X11R6/lib/libXext.so.6 (0x002db000)
libX11.so.6 => /usr/X11R6/lib/libX11.so.6 (0x001df000)
libdl.so.2 => /lib/libdl.so.2 (0x00f78000)
libjava.so => not found
libjvm.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0x002e9000)
/lib/ld-linux.so.2 (0x00456000)

After IP Change Oracle APPS R12 Web Application Services Failed

After IP Change Oracle APPS R12 Web Application Services Failed

oafm,forms,oacore status down

ERROR Message...

Oracle Apps stratup Log

Root Service Oracle Process Manager for VIS_sys38 adopmnctl.sh Started
Web Entry Point Services Oracle HTTP Server VIS_sys38 adapcctl.sh Failed
Web Application Services OACORE OC4J Instance VIS_sys38 adoacorectl.sh Failed
Web Application Services FORMS OC4J Instance VIS_sys38 adformsctl.sh Failed
Web Application Services OAFM OC4J Instance VIS_sys38 adoafmctl.sh Failed
Batch Processing Services OracleTNSListenerAPPS_VIS_sys38 adalnctl.sh Started
Batch Processing Services OracleConcMgrVIS_sys38 adcmctl.sh Started
Batch Processing Services Oracle ICSM VIS_sys38 ieoicsm.sh Disabled
Batch Processing Services Oracle Fulfillment Server VIS_sys38 jtffmctl.sh Started
Other Services Disabled
Other Services OracleFormsServer-Forms VIS_sys38 adformsrvctl.sh Disabled
Other Services Oracle Metrics Client VIS_sys38 adfmcctl.sh Disabled
Other Services Oracle Metrics Server VIS_sys38 adfmsctl.sh Disabled
Other Services Oracle MWA Service VIS_sys38 mwactlwrpr.sh Disabled


================================================================================

APPS R12 Web Application Services Logs..

11/10/08-19:18:43 :: adoacorectl.sh version 120.11.12000000.2


11/10/08-19:18:43 :: adoacorectl.sh: starting OPMN if it is not running

opmnctl: opmn is already running.

11/10/08-19:18:43 :: adoacorectl.sh: Starting OPMN managed OACORE OC4J instance

opmnctl: starting opmn managed processes...
================================================================================
opmn id=sys38.doyen.in:6200
0 of 1 processes started.

ias-instance id=VIS_sys38.sys38.doyen.in
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
OC4J/oacore/default_group/

Error
--> Process (index=1,uid=1832654593,pid=29902)
failed to start a managed process after the maximum retry limit
Log:
/u02/oracle/VIS/inst/apps/VIS_sys38/logs/ora/10.1.3/opmn/OC4J~oacore~default_group~1


11/10/08-19:19:14 :: adoacorectl.sh: exiting with status 204


================================================================================

OPMN managed OACORE OC4J instance Logs..


[applmgr@sys38 ~]$ sh /u02/oracle/VIS/inst/apps/VIS_sys38/admin/scripts/adoacorectl.sh status

You are running adoacorectl.sh version 120.11.12000000.2

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: VIS_sys38.sys38.doyen.in
-------------------+--------------------+---------+---------
ias-component process-type pid status
-------------------+--------------------+---------+---------
OC4J oafm N/A Down
OC4J forms N/A Down
OC4J oacore N/A Down
HTTP_Server HTTP_Server 29760 Alive


adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /u02/oracle/VIS/inst/apps/VIS_sys38/logs/appl/admin/log/adoacorectl.txt for more information ...


Solution


1.Stop Oracle Apps Tier (Stop Oracle Apps Servies)

2. cd $INST_TOP/ora/10.1.3/j2ee

rm -fr oacore/persistence/*
rm -fr oafm/persistence/*
rm -fr forms/persistence/*

3.Start Oracle Apps Tier (Start Oracle Apps Servies)

4.adoacorectl.sh status

[applmgr@sys38 persistence]$ sh /u02/oracle/VIS/inst/apps/VIS_sys38/admin/scripts/adoacorectl.sh status

You are running adoacorectl.sh version 120.11.12000000.2

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: VIS_sys38.sys38.doyen.in
-------------------+--------------------+---------+---------
ias-component process-type pid status
-------------------+--------------------+---------+---------
OC4J oafm 31945 Alive
OC4J forms 31874 Alive
OC4J oacore 31780 Alive
HTTP_Server HTTP_Server 29760 Alive


adoacorectl.sh: exiting with status 0