Connect to multiple Applications 11i Instance using ADI

I had issue with connecting to ADI to individual instance when more than one Oracle Applications were running on same server. I performed following to overcome issue. 1. Defined the RRA: Service Prefix in each of your instances at site level as FNDFS_ntest. 2. Added in the Desktop PC tnsnames.ora in $ORACLE_HOME/network/admin and $ORACLE_HOME/net80/admin should be equal and include definitions for FNDFS which name should be FNDFS__

FNDFS_ntest_nfinox = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=nfinox)(PORT=1522)) (CONNECT_DATA=(SID=FNDFS)) )

3. Added given two services in each tnsnames in the 8.0.6 ORACLE HOME of each instance in the applications server is generated by AutoConfig including these two services: FNDFS_ntest = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=nfinox)(PORT=1522)) (CONNECT_DATA=(SID=FNDFS)) ) FNDFS_ntest_nfinox = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=nfinox)(PORT=1522)) (CONNECT_DATA=(SID=FNDFS)) ) 4. Restarted the Concurrent Managers -- All the instances 5. Restarted the APPS Listener -- All the instances

Create Global oraInventory for Oracle Applications 11i

Some time I am not able to apply database patch (using opatch) to RDBMS home due to global inventory issue. So I thought of putting all the steps together to recreate global inventory problem. 1. Login as oracle user and identify the oracle Inventory location by referring to content of /var/opt/oracle/oraInst.loc.

$ cat /var/opt/oracle/oraInst.loc inventory_loc=/local/oracle/admin/ntst/oraInventory inst_group=dba

2. Renamed old inventory

$cd /local/oracle/admin/ntst

$mv oraInventory oraInventory.old

$chmod 777 oraInventory

3. Downloaded patch Patch 5035661 for HP-UX 32 (my os is HP-UX)

4. Login as

$ . $APPL_TOP/APPSORA.env

$ pwd /reports/ntrg/patches/secjuly07 $ echo $IAS_ORACLE_HOME /apps/OEBS/ntrg/iAS $ unzip -od /apps/OEBS/ntrg/iAS p5035661_11i_HPUX11.zip

$ cd $IAS_ORACLE_HOME/appsoui/setup $ pwd /apps/OEBS/ntst/iAS/appsoui/setup $ perl OUIsetup.pl

Check log from above script and ensure it was successful.

5. Go to parent directory of oraInventory and change its permission to 777 recursively.

$ pwd /local/oracle/admin/ntrg/oraInventory

$ chmod -R 777 *

6. Login as oracle and set enviroment

$cd /reports/ntrg/patches/secjuly07 $unzip -od $ORACLE_HOME p5035661_11i_HPUX11.zip

$ cd $ORACLE_HOME/appsoui/setup $pwd /local/oracle/product/9.2.0.8.2/appsoui/setup

$perl OUIsetup.pl

Log file : /local/oracle/product/9.2.0.8.2/appsoui/setup/OUIsetup.log

7. Check if you can list oraInventory

$cd $ORACLE_HOME/OPatch/

$./opatch lsinventory

8. You can also invoke universal installer to check the home registration validity in global inventory.

$export DISPLAY=:0.0

$cd $ORACLE_HOME/appsoui/oui/install

$./runInstaller.sh

It will invoke universal installer and you can see RDBS home registered there.

Subject: How to Recreate the Global oraInventory Note: 295185.1

Custom Forms/Menu Failes with Listener Servlet with Oracle Applications 11i

Last week we configured oracle application forms from socket mode to servelete move in production. We were not able to start any forms/menus from oracle applications. When we further investigated issue and did following. 1. Go to $APACHE_TOP/Jserv/etc/ 2. Add all custom tops in the formservlet.ini file. Put custom top between “#Begin Customization” and “End Customization”. #Begin Customization SEXX_TOP=/apps/OEBS//appltop/sexx/custom #End Customization 3. Begin Customization and end Customization entries are needed if instance is autoconfig enabled else SEXX_TOP will be overwritten by autoconfig. 4. You need not to restart services. You can log off and login again.

How to turn on trace for apache and Jserv to troubleshoot Selfservice Issue?

Most of time Oracle ask us to generate trace file of Apache and Jserv so I though of putting all steps together. 1. Please enable debug in your Apache Conf files Bring down Apache - Set LogLevel debug in the following files httpd.conf, httpd.conf_pls, and jserv.conf - Edit the .../iAS/Apache/Jserv/etc/jserv.properties to enable debug for the java portion of the Apache jserv. example log=true / log.timestamp=true 2. Delete all existing logs from $IAS_ORACLE_HOME/A* ./Apache/logs/ ./Jserv/logs/ ./Jserv/jvm/logs/ 3. Restart Apache 4. Recreate your issue 5. Provide all log and config files with the following script To be executed from the .../iAS/Apache directory: zip logfile.zip \ ./Apache/logs/*_log* \ ./Apache/conf/*.conf \ ./Jserv/logs/*.log \ ./Jserv/logs/jvm/* \ ./Jserv/etc/*.properties \ ./Jserv/etc/*.conf \ ./Jserv/etc/*.ini \ ./Jserv/etc/*.txt

Oracle Applications Clear Cache

Refer given below to clear cache in E-Business Suite. 1. Apache - shutdown iAS server- go to $OA_HTML or $COMMON_TOP (11.5.10) directory- remove the directory _pages- restart iAS server 2. Browser -Netscape :- go to menu Edit => Preferences…, - choose 'Cache' in 'Advanced' category,- click on buttons 'Clear Memory Cache' and 'Clear Disk Cache'.- close all Netscape windows and restart new browser session. -Internet Explorer :- go to menu Tools => Internet Options…,- select 'General' tab,- click on button 'Delete Files' in 'Temporary Internet files' zone- close all IE windows and restart new browser session. 3. Jinitiator -Two possibilities depending of Jinitiator version, for instance: - delete all files in directory : C:\Program Files\Oracle\Jinitiator 1.1.7.27\jcache\ (Jinitiator version directory may be different) or - go to Start => Parameters => Control Panel- double-click on Jinitiator 1.3.1.18 (or other version)- in the new pop-up window, click on "Cache" Tab- click on "Clear Jar Cache " button. On prompt, click Yes. (you can also delete directly all files under directory:C:\Documents and Settings\\Oracle Jar Cache) After clearing cache bound Apache and Forms server.