All About ADI in Oracle Applications

What is ADI? How this is used? Let's see the complete details about it...

Oracle ADI is a spreadsheet-based extension to Oracle Applications that offers full cycle accounting and asset management within the comfort and familiarity of a spreadsheet. Oracle ADI combines a spreadsheet’s ease of use with the power of Oracle Applications, to provide true desktop integration during every phase of your accounting cycle. You can create budgets, record transactions, add assets, reconcile inventory, and run financial statements and inventory reports all without leaving your spreadsheet.

You can run Oracle ADI as a stand-alone application, without installing the full client version of Oracle General Ledger (GL) or Oracle Assets on your PC. This gives you the ability to confirm and reconcile inventory, revise budgets, create journal entries, and define financial and asset reports from any location, without being connected to your server. You only need to connect when you want to transfer data to or from Oracle Applications.

Figure describes how ADI integrates with other applications.

Oracle ADI Key Features
Oracle ADI key features are as follows:
■ Budget Wizard, Journal Wizard, Report Wizard, and Analysis Wizard to
simplify your work with GL.
■ Account Hierarchy Editor to graphically create, maintain, and review account
structure hierarchies.
■ Spreadsheet-based interface to simplify asset creation and physical inventory
process.
■ Request Center for submitting, monitoring, and publishing your reports.

Oracle ADI Integrations
Oracle ADI integrates with the following modules:
Oracle General Ledger
GL is a comprehensive financial management solution that enhances financial
controls, data collection, information access, and financial reporting throughout the
enterprise. It is part of the Oracle E-Business Suite, an integrated set of applications
that are engineered to work together.
Oracle Assets
Oracle Assets is a comprehensive asset management solution that ensures
maintenance of accurate property and equipment inventory as well as optimal
accounting and tax strategies. It is part of the Oracle E-Business Suite, an integrated
set of applications that are engineered to work together.

Ref: http://download.oracle.com/docs/cd/B15436_01/current/acrobat/115csadiug.pdf

EBS 11i Application Desktop Integrator (ADI) Certified on 10gR2 Database

Client Applications Desktop Integrator (ADI) is now certified with Oracle E-Business Suite Release 11i running on the 10gR2 Database. Customers may continue using the client-installed ADI even after upgrading their E-Business Suite Release 11i environment to the 10gR2 Database.

This certification applies to all ADI functionality, including:

• General Ledger Journal Wizard
• Budget Wizard
• Report Wizard
• Analysis Wizard
• Account Hierarchy Editor
• Request Center
• Assets Integrators

Note that this certification applies only to Client ADI with Applications 11i. Client ADI cannot be used with Oracle E-Business Suite Release 12; webADI is available for Release 12 users.

For more details (and a useful Frequently Asked Questions summary for ADI), see:

• Client ADI for EBS 11i is Certified with 10g (Metalink Note 747386.1)

Ref: http://blogs.oracle.com/stevenChan/entry/ebs_11i_application_desktop_integrator_10gr2_certification

Unable to View Concurrent Requests Ouput Files

ISSUE:

"Unable to view Concurrent Requests log/output files"..

We are running 11.5.10.2 and recently did a clone of production to test. However, in the test environment when I run a concurrent request I am no longer able to view the logs or outputs through Oracle.

ERROR

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_TESTDB There may be a network configuration problem, or the TNS listener on node FNDFS_TESTDB may not be running. Please contact your system administrator.


CHECKING:

a) Check whether Concurrent Request log & Output files generated in $APPLCSF/log & $APPLCSF/out to confirm this is NOT Concurrent issue

RESEARCH:

• ADI: Unable To View Reports In ADI [ID 1018797.102]
• How To Set RRA:Service Prefix for Multiple Instances on One Server [ID 235785.1]
• Tracing the sqlnet connection in ADI [ID 223136.1]
• Troubleshooting the "Error Occurred While Attempting to Establish an Applications
File Server Connection" [ID 117012.1]

SOLUITION Path:

1. Perform the RRA Setup Diagnostic Test

This Step will identify all Profile Settings & TNSNames.ora,Hostname in
FND_CONCURRENT_QUEUES table in one go.

Ref: 11i : Oracle Application Object Library Report Review Agent Setup Test
[ID 200358.1]


Command-Line Usage Instructions

• If the latest Oracle Diagnostics patch has been installed, this diagnostic script
is already available on your system. Change directory to $IZU_TOP/bin and execute
the test from there.

• If the latest Oracle Diagnostics patch has not been installed, download and unzip
the latest Oracle Diagnostics patch (see Note 167000.1)
Once unzipped, the Oracle Diagnostics patch can be installed in the normal way
using adpatch (see Note 167000.1) or the test can be executed directly from the
patch directory. Change directory to /izu/bin and execute the test
from there.

• Run the test as follows:

UNIX
$ ./FNDValidateFNDFS115.sh

Windows NT/2000
> sh FNDValidateFNDFS115.sh

2. CrossCheck for multiple Node Name

Verify that the nodename specified in the FNDFS_ entry is the
same as the nodename in the above error message. This should also match the
node name returned from the following select statement:

SQL> select distinct LOGFILE_NODE_NAME
from FND_CONCURRENT_REQUESTS;

3. If this is Cloned Instance from PROD, then check whether any profile values still
pointing to PROD

SQL> select a.profile_option_value,b.profile_option_name from
fnd_profile_option_values a , fnd_profile_options b
where a.profile_option_id=b.profile_option_id
and upper(profile_option_value) like '%PROD%' ;

SQL> select * from fnd_profile_options where profile_option_id=&ID;
SQL> select * from fnd_profile_option_values where profile_option_id=&ID;

4. Mostly issue could be either RRA Profile setting issue or any other profile
setting pointing to PROD

Oracle APPS : Workflow Tables

Oracle Applications - Workflow Tables (Quick Review)

Important WF Tables:

wf_user_role_assignments
wf_user_roles
wf_roles
wf_items
wf_item_attributes
wf_item_attribute_values
wf_item_attributes_tl
wf_activities
wf_activities_tl
wf_activity_attributes
wf_activity_attributes_tl
wf_activity_transitions
wf_deferred--wf_control

WF_NOTIFICATION_ATTRIBUTES
WF_MESSAGES
WF_MESSAGES_TL
WF_MESSAGE_ATTRIBUTES
WF_MESSAGE_ATTRIBUTES_TL
WF_ETS
WF_PROCESS_ACTIVITIES


WF_ACTIVITIES table stores the definition of an activity. Activities can be Processes, notifications, functions or folders. A process activity is a modelled workflow process, which can be included as an activity in other processes to represent a subprocess. A notification activity sends a message to a performer. A functions activity performs an automated function that is written as a PL/SQL stored procedure. A folder activity is not part of a process, it provides a means of grouping activities.

WF_ITEMS is the runtime table for workflow processes. Each row defines one work item within the system.

WF_ITEM_ATTRIBUTES table stores definitions of attributes associated with a process. Each row includes the sequence in which the attribute is used as well as the format of the attribute data.

WF_NOTIFICATIONS holds the runtime information about a specific
instance of a sent message. A new row is created in the table each time a message is sent.

How to change the database listener port with EBS system

How to change the database listener port with EBS system

1. In dbtier xml file under /appsutil change the below line to reflect
the right port

1541

2. In /network/admin/

change the prot values manually in listener.ira and tnsnames.ora

3. Run autoconfg in db tier. if it completes perform the following

4. In apps tier xml file under /admin change the below line to reflect the
right port

1541

5. Run autoconfig in apps tier

Business Continuity - Implement Dataguard on R12

IMPLEMENTING Dataguard Physical Standby on R12 on 11g Database Using RMAN Hot Backup
=====================================================================


==> Machine 01 has an E-Business Suite Release 12.0.4 (PROD) DB_NAME=PROD01

==> Machine 02 is clean and will be used as the Standby machine DB_NAME=PROD02

==> Machine 03 will be clean and used as the Observer

1. Prepare the Existing Database as PRIMARY ==> Machine 01

1.Enable Archivelog mode in PRIMARY

SQL>archive log list

>> The output for above command will show whether archive is enabled or Not <<
>> If output shows as follows,then proceed for next step in this section to ENABLE ARCHIVE LOG Mode

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/PROD/11.1.0/db_1/RDBMS/
Oldest online log sequence 386
Current log sequence 387

SQL> shutdown immediate
SQL> startup mount

SQL> alter database force logging;
SQL> alter database archivelog;


>>
>>


2. Create Database Password Files

cd $ORACLE_HOME/dbs
orapwd file=orapw password= ignorecase="Y"

3. Create IFILE and add ifile entry in the pfile

Add the following Entry at end of pfile

IFILE=/oracle/PROD/db/tech_st/11.1.0/dbs/PROD__ifile.ora

Create IFILE as follows:

[oracle@emeaicm01 dbs]$ vi PROD_emeaicm01_ifile.ora


4. Create directory called " PROD_emeaicm01" and place all network files under this folder

[oracle@emeaicm01 PROD_emeaicm01]$ mkdir PROD_emeaicm01

Add IFILE entry on both TNSNAMES.ORA and LISTENER.ORA to use IFILE at the end of file

In Listener.ora
IFILE=/oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_emeaicm01/listener_ifile.ora

In Tnsnames.ora

IFILE=/oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_emeaicm01/PROD_emeaicm01_ifile.ora

Now, Create common IFILE for both Listener and Tnsnames entry

[oracle@emeaicm01 PROD_emeaicm01]$ vi PROD_emeaicm01_ifile.ora



3. Add the following Entries in for standby configuration

PROD01=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=emeaicm01.uk.oracle.com)(PORT=1533))
)
(CONNECT_DATA=
(SID=PROD)
)
)


PROD02=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=emeaicm02.uk.oracle.com)(PORT=1533))
)
(CONNECT_DATA=
(SID=PROD)
)
)



4. At PRIMARY , Set following parameters in IFILE

LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY'
LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
DB_RECOVERY_FILE_DEST_SIZE = 107374182400
DB_RECOVERY_FILE_DEST= '/oracle/archive'
DB_UNIQUE_NAME=PROD01
LOG_ARCHIVE_CONFIG='dg_config=(PROD01,PROD02)'
LOG_ARCHIVE_DEST_2='service=PROD02 valid_for=(online_logfiles,primary_role) db_unique_name=PROD02 LGWR ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30'
LOG_ARCHIVE_DEST_STATE_2=enable
FAL_SERVER='PROD02'
FAL_CLIENT='PROD01'
#standby_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'
standby_file_management=AUTO
parallel_execution_message_size=8192


5. Create standby redolog

>>>Create standby redo logs on the primary database to support the standby role. The standby redo logs must be the same size as the primary database online redo logs.
It is recommended that the number of standby redo logs is one more than the number of online redo logs. <<<<

Assume, We have 2 Online logs in PRIMARY, then we need to add 3 standby log files

SQL> alter database add standby logfile thread 1 group 3 ( '/oracle/PROD/db/apps_st/data/stdbylog03a.dbf', '/oracle/PROD/db/apps_st/data/stdbylog03b.dbf') size 1G;
SQL> alter database add standby logfile thread 1 group 4 ( '/oracle/PROD/db/apps_st/data/stdbylog04a.dbf', '/oracle/PROD/db/apps_st/data/stdbylog04b.dbf') size 1G;
SQL> alter database add standby logfile thread 1 group 5 ( '/oracle/PROD/db/apps_st/data/stdbylog05a.dbf', '/oracle/PROD/db/apps_st/data/stdbylog05b.dbf') size 1G;


Clone the Database Software to Standby
-----------------------------------------

6. Prepare the Database Tier for Cloning

As ORACLE user on one of the production database servers, run the adpreclone.pl script.
For Example:

cd $ORACLE_HOME/appsutil/scripts/
perl adpreclone.pl dbTier

In our case

cd $ORACLE_HOME/appsutil/scripts/PROD_emeaicm01
perl adpreclone.pl dbTier

Supply the APPS password when requested
Use the same port pool as Source

7. Copy Database Tier to Standby

Use following command to tar the source file , copy and untar in target ==> The following command will automatically tar,copy and untar in the target system

$ tar czvf - . |ssh -l oracle emeaicm02.uk.oracle.com "cd /oracle/PROD/db/tech_st; tar xvzf -"


>>>> It is recommended to use the same directory names on the standby site. <<<<<<


8. Configure the Standby Database Tier using Rapid Clone

At Standby Site, Execute the following adcfgclone.pl script for new database Oracle home:

$ cd $ORACLE_HOME/appsutil/clone/bin
perl adcfgclone.pl dbTechStack

Respond to the prompts appropriately:

Target instance is a Real Application Cluster (RAC) instance (y/n):
"n" in the single instance case
Target System database name:
Note, db_name, not db_unique_name
Number of DATA_TOP's on the target system [4]:
Usually only one for ASM.
Target system DATA_TOP 1:
For example, /oracle/PROD

Source The New Environment

$ cd /oracle/PROD/db/tech_st/11.1.0/
$ . . PROD_emeaicm02.env

9. Configure New Database for Communication between Primary and Standby

When adjusting parameters on the production site for Data Guard setup, you created an include file
holding TNS service definitions. Copy the file to the $TNS_ADMIN directory at your standby site and
name it _ifile.ora.

$ cd $TNS_ADMIN
$ mv PROD_emeaicm01_ifile.ora PROD_emeaicm02_ifile.ora


10. Configure Standby Database Data Guard Parameters

$ vi PROD_emeaicm02_ifile.ora
>> Add/change the following parameters <<

LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY'
LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
DB_RECOVERY_FILE_DEST_SIZE = 107374182400
DB_RECOVERY_FILE_DEST= '/oracle/archive'
log_archive_config='dg_config=(PROD_IN01,PROD_IN02)'
LOG_ARCHIVE_DEST_STATE_2=enable
#standby_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'
standby_file_management=AUTO
parallel_execution_message_size=8192
db_unique_name=PROD_IN02
log_archive_dest_2='service=PROD_IN01 valid_for=(online_logfiles,primary_role) db_unique_name=PROD_IN01 LGWR ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30'
fal_server='PROD_IN01'
fal_client='PROD_IN02'
log_file_name_convert='xx','xx'



Clone Application Tier to Standby
----------------------------------

# Use the same ORACLE_BASE as Source i.e /oracle/PROD
# Use the same port pool as Source, i.e port pool 12
# Setup SSH on both Primary and Standby nodes - Follow - How to setup SSH.doc
# Setup cron to periodically synchronise concurrent manager log and out files - Follow - How to use crontab to rsync CCM log and out files.doc


11. Prepare the Application Tier for Cloning

Log in to the APPLMGR user and run the following commands to prepare the application tier for
cloning:

$ cd /admin/scripts
$ perl adpreclone.pl appsTier


12. Copy the Application Tier to Standby

SR czvf - . |ssh -l oracle emeaicm02.uk.oracle.com "cd /oracle/PROD/apps; tar xzvf -"

13. Configure Standby Application Tier using Rapid Clone
Run adcfgclone.pl first to start configuring the new application tier file systems. These steps must be run
on each application tier node:

$ cd /clone/bin
$ perl adcfgclone.pl atTechStack

Answer prompts appropriately:

SRget system database SID:
Note: db_name, not db_unique_name
SRget system database server node:
Database server hostname, could be any node for RAC node if RAC used

To complete the configuration of environment run AutoConfig using the following commands:

$ cd /ad/12.0.0/bin
$ adconfig.sh contextfile=/appl/admin/.xml run=INSTE8

>>>AutoConfig will report errors regarding to database connection, these errors can be ignored as the
database is unavailable. <<<<

14. Setup cron to periodically synchronise concurrent manager log and out files

emeaicm01.uk.oracle.com is machine A (Primary machine)
emeaicm02.uk.oracle.com is machine B (Standby machine)

On the Standby machine:
mkdir -p /log
mkdir -p /out

mkdir -p /oracle/PROD/inst/apps/PROD_emeaicm01/logs/appl/conc/log
mkdir -p /oracle/PROD/inst/apps/PROD_emeaicm01/logs/appl/conc/out

On the Primary Machine
mkdir -p /log
mkdir -p /out

mkdir -p /oracle/PROD/inst/apps/PROD_emeaicm02/logs/appl/conc/log
mkdir -p /oracle/PROD/inst/apps/PROD_emeaicm02/logs/appl/conc/out

You can set the timings to push files according to your requirement.
In our case, we have set the timing for 30 mintues as follows:

From machine A
===============

The files will be pushing from machine A every 30 minutes, on the hour and half hour, so our entries will be:

$ crontab -e

#
## Push log and out files from this machine to emeaicm02 every 30 minutes, on the hour and half hour
#
00,30 * * * * rsync -av /oracle/PROD/inst/apps/PROD_emeaicm01/logs/appl/conc oracle@emeaicm02: /oracle/PROD/inst/apps/PROD_emeaicm01/logs/appl --rsync-path=/usr/bin/rsync >> /tmp/rsync_01_00-30.log
#

As crontab uses “vi” syntax, save changes using :wq!

From machine B
==============

We will also be pushing files from machine B every 30 minutes, on the quarter hour and three quarter hour, so our entries will be:

#
## Push log and out from this machine to emeaicm01 every 30 minutes at quarter past, and quarter to.
#
15,45 * * * * rsync -av /oracle/PROD/inst/apps/PROD_emeaicm02/logs/appl/conc oracle@emeaicm01:/oracle/PROD/inst/apps/PROD_emeaicm02/logs/appl --rsync-path=/usr/bin/rsync >> /tmp/rsync_01_15-45.log
#


15. Setup SSH on both Primary and Standby nodes

On Primary Node: (Machine 1)
----------------------------

· Log in as oracle
· Generate the ssh key by issuing the following command:
ssh-keygen -t rsa (then press enter 3 times)

$ ssh-keygen -t rsa
Generating public/private rsa key pair.

· Press the Enter key three times.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
5a:58:7e:65:ae:71:1a:82:2c:95:98:5b:48:b3:52:ac oracle@emeaicm15.uk.oracle.com
· CD into the .ssh directory, which is located under the home directory. Note that a file called id_rsa.pub is created.

$ ls -lrt $HOME/.ssh/
total 24
-rw-r--r-- 1 oracle dba 948 Mar 3 10:57 known_hosts
-rw-r--r-- 1 oracle dba 240 Mar 4 10:15 id_rsa.pub
-rw------- 1 oracle dba 887 Mar 4 10:15 id_rsa

· Update authorized_keys file to enable ssh ‘loopback’

$ cat $HOME/.ssh/id_rsa.pub >> $HOME/.ssh/authorized_keys

· Use SCP to copy id_rsa.pub to the /tmp directory of the Remote Nodes.
$ scp $HOME/.ssh/id_rsa.pub oracle@emeaicm16.uk.oracle.com:/tmp
oracle@emeaicm16.uk.oracle.com's password:
id_rsa.pub 100% 240 0.2KB/s 00:00

On the Remote Node(s):

· Login as the oracle user
· Remove specialized .login, .profile or similar files which cause extra verbiage to be displayed to the screen.
· Create a directory called .ssh in the home directory
$ mkdir $HOME/.ssh
mkdir: cannot create directory `/home/oracle/.ssh': File exists

· Copy the content of /tmp/id_rsa.pub (copied from the Primary Node) into a new file named authorized_keys. (If you already have a file called authorized_keys in this directory, open it in vi, go to the bottom of the file, add one blank line and then copy and paste the contents of the file /tmp/id_rsa.pub into the existing file and save it.)

$ cat /tmp/id_rsa.pub >> $HOME/.ssh/authorized_keys

· Verify that the .ssh directory permission is set to 700
$ chmod 700 $HOME/.ssh
· Verify that the authorized_keys file permission is set to 600
$ chmod 600 $HOME/.ssh/authorized_keys
· Verify that the $HOME directory does not have write permissions for group and others.
$ chmod go-w $HOME
· Ensure that the ssh daemon is running
$ ps -ef |grep -i ssh

root 2418 22004 0 10:25 ? 00:00:00 sshd: oracle [priv]
oracle 2420 2418 0 10:25 ? 00:00:00 sshd: oracle@pts/1
oracle 2690 2421 0 10:37 pts/1 00:00:00 grep -i ssh
root 22004 1 0 Feb29 ? 00:00:00 /usr/sbin/sshd

Test the installation:
~~~~~~~~~~~~~~~~~~~~~


· Login to the PrimaryNode as oracle user.

Execute the following command, replacing [user] with the username on the Remote Node, and [SERVER] with the host name of the Remote Node:
ssh -l [user] [SERVER]
$ uname -n
emeaicm15.uk.oracle.com

$ ssh -l oracle emeaicm15 (connect to same machine)
Last login: Tue Mar 4 10:41:52 2008 from emeaicm15.uk.oracle.com

$ uname -n
emeaicm15.uk.oracle.com
· When prompted to confirm the identity, respond "Yes".
· Disconnect from the server.

$ exit
Connection to emeaicm16 closed

$ ssh -l oracle emeaicm16 (connect to machine 2)
Last login: Tue Mar 4 10:41:52 2008 from emeaicm15.uk.oracle.com

$ uname -n
emeaicm16.uk.oracle.com
· When prompted to confirm the identity, respond "Yes".
· Disconnect from the server.

$ exit
Connection to emeaicm16 closed
· Execute the following commands:

$ uname -n
emeaicm15.uk.oracle.com

$ ssh oracle@emeaicm16 uname -n
emeaicm16.uk.oracle.com

The remote hostname should appear, followed by the prompt, and you should not be asked to enter and ID or password. If you are prompted for a password, verify the following:
§ The content of the authorized_keys file contains the content of id_rsa.pub of the client
§ The permissions of the authorized_keys file are set to 600.
§ The permissions of the .ssh directory are set to 700.
The permissions of the $HOME directory do not include execute for group and other.


Now repeat the steps again as follows (to enable SSH in the opposite direction)

On Standby Node: (machine 2)

· Log in as oracle
· Generate the ssh key by issuing the following command:
ssh-keygen -t rsa (then press enter 3 times)

$ ssh-keygen -t rsa
Generating public/private rsa key pair.

· Press the Enter key three times.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
6c:7d:4c:5c:21:9d:d6:8e:1f:6d:9c:52:2f:88:1c:3d oracle@emeaicm16.uk.oracle.com
· CD into the .ssh directory, which is located under the home directory. Note that a file called id_rsa.pub is created.

$ ls -lrt $HOME/.ssh/
-rw-r--r-- 1 oracle dba 703 Feb 18 09:54 known_hosts
-rw-r--r-- 1 oracle dba 240 Mar 4 10:32 authorized_keys
-rw-r--r-- 1 oracle dba 240 Mar 4 10:49 id_rsa.pub
-rw------- 1 oracle dba 887 Mar 4 10:49 id_rsa

· Update authorized_keys file to enable ssh ‘loopback’

$ cat $HOME/.ssh/id_rsa.pub >> $HOME/.ssh/authorized_keys
· Use SCP to copy id_rsa.pub to the /tmp directory of the Remote Nodes.

$ scp $HOME/.ssh/id_rsa.pub oracle@emeaicm15.uk.oracle.com:/tmp
oracle@emeaicm15.uk.oracle.com's password:
id_rsa.pub 100% 240 0.2KB/s 00:00

On the Primary Node: (Machine 1)

· Login as the oracle user
· Copy the content of /tmp/id_rsa.pub (copied from the Primary Node) into file named authorized_keys
$ cat /tmp/id_rsa.pub >> $HOME/.ssh/authorized_keys
· Verify that the .ssh directory permission is set to 700
$ chmod 700 $HOME/.ssh
· Verify that the authorized_keys file permission is set to 600
$ chmod 600 $HOME/.ssh/authorized_keys
· Verify that the $HOME directory does not have write permissions for group and others.
$ chmod go-w $HOME
· Ensure that the ssh daemon is running
$ ps -ef |grep -i ssh

root 2418 22004 0 10:25 ? 00:00:00 sshd: oracle [priv]
oracle 2420 2418 0 10:25 ? 00:00:00 sshd: oracle@pts/1
oracle 2690 2421 0 10:37 pts/1 00:00:00 grep -i ssh
root 22004 1 0 Feb29 ? 00:00:00 /usr/sbin/sshd

Test the installation at both Node(s):
--------------------------------------

· Login to the Remote Node as oracle user (Machine 2).
· Execute the following command, replacing [user] with the username on the Remote Node, and [SERVER] with the host name of the Remote Node:
ssh -l [user] [SERVER]

$ uname -n
emeaicm16.uk.oracle.com

$ ssh -l oracle emeaicm16 (connect to same machine)
Last login: Tue Mar 4 10:41:52 2008 from emeaicm16.uk.oracle.com

$ uname -n
emeaicm16.uk.oracle.com

$ exit
Connection to emeaicm16 closed

$ ssh -l oracle emeaicm15 (connect to machine 1)
Last login: Tue Mar 4 10:41:52 2008 from emeaicm16.uk.oracle.com

$ uname -n
emeaicm15.uk.oracle.com
· When prompted to confirm the identity, respond "Yes".
· Disconnect from the server.

$ exit
Connection to emeaicm15 closed
· Execute the following commands:

$ uname -n
emeaicm16.uk.oracle.com

$ ssh oracle@emeaicm15 uname -n
emeaicm15.uk.oracle.com

The remote hostname should appear, followed by the prompt, and you should not be asked to enter and ID or password. If you are prompted for a password, verify the following:
§ The content of the authorized_keys file contains the content of id_rsa.pub of the client
§ The permissions of the authorized_keys file are set to 600.
§ The permissions of the .ssh directory are set to 700.
§ The permissions of the $HOME directory do not include execute for group and other.



16. Establish the Standby Database

Create a hot backup using Recovery Manager (RMAN)

Take Backup of Primary Database and Copy the backup to Standby(Machine02) using RMAN HOT BACKUP

a)set RDBMS_ORACLE_HOME env file
b) $ rman target /

RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup database plus archivelog;
}

>>>>For RMAN: Monitoring Recovery Manager Jobs ==> Ref Note 144640.1

To monitor the Rman Backup job, Please execute the following in SQLPLUS as sysdba

SQL> SELECT sid, spid, client_info FROM v$process p, v$session s
WHERE p.addr = s.paddr
AND client_info LIKE '%id=rman%';



SQL> SELECT sid, serial#, context, sofar, totalwork,round(sofar/totalwork*100,2) "% Complete"
FROM v$session_longops
WHERE opname LIKE 'RMAN%'
AND opname NOT LIKE '%aggregate%'
AND totalwork != 0
AND sofar <> totalwork
/


SQL> SELECT sid, seconds_in_wait AS sec_wait, event FROM v$session_wait
WHERE wait_time = 0
ORDER BY sid;

Take backup of current controlfile at primary for standby site in RMAN

For Backup as Backupset:

RMAN> run
{
allocate channel c1 type disk;
backup current controlfile for standby;
}


For Backup as COPY :

RMAN> run
{
allocate channel c1 type disk;
backup as copy current controlfile for standby;
}

Once backup is done, copy the backup with archivelogs & Standby controlfile to remote location(standby)

rsync -av /oracle/archive oracle@machine02.oracle.com:/oracle/archive

17. At Standby (Machine02), Startup mount the Standby database

The following command will automatically duplicate the database using backup taken at primary and
mount the database

$ rman target sys/oracle@prod_in01 auxiliary sys/oracle@prod_in02

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY
DORECOVER NOFILENAMECHECK;


Run the following command to check the standby database details

SQL> select database_role,switchover_status,checkpoint_change#,switchover#,dataguard_broker,guard_status,current_scn,flashback_on from v$database

The output should be similar to the following:


DATABASE_ROLE SWITCHOVER_STATUS CHECKPOINT_CHANGE# SWITCHOVER# DATAGUAR GUARD_S CURRENT_SCN FLASHBACK_ON
--------------- ------------------ ---------------------- ----------- --------------- ------------------- ------------------
PHYSICAL STANDBY NOT ALLOWED 5965111847227 83208404 ENABLED NONE 5965112465873 YES


18. On the primary database enable the previously deferred remote destination by executing this command
from SQL*Plus connected as sysdba:

SQL> alter system set log_archive_dest_state_2=enable SID='*';

19. Place the standby database in managed recovery by executing this command from SQL*Plus
connected as sysdba:

SQL> recover managed standby database using current logfile disconnect;

20. Verify whether the standby is correctly applying redo from the primary.
On the primary database, archive the current log using the following SQL statement:

>>Find the current Sequence and last archived log sequence:

SQL> archive log list;

>>Archive the current redolog sequence:

SQL> alter system archive log current;


On the standby database, query the v$archived_log view to verify that the logs are received and applied:

SQL> select thread#, sequence#, applied,
to_char(first_time, 'mm/dd/yy hh24:mi:ss') first,
to_char(next_time, 'mm/dd/yy hh24:mi:ss') next,
to_char(completion_time, 'mm/dd/yy hh24:mi:ss') completion
from v$archived_log order by first_time;

You can also execute the following query to find the shipping details on both primary and standby

SQL> select process,status,sequence# from v$managed_standby;

21. If incase the logs are not shipping, Please check the following

a) Check alertlog file on Primary and see whether log_archive_dest_2 is reachable and check any TNS
error, if the standby destination not reachable, fix the TNS issue

b) Check the status of the log_archive_dest_2

SQL> select status,error from v$archive_dest;

>> If any error from above statement, you shall defer it temporarily

SQL> alter system set log_archive_dest_state_2=defer;

c) Once the error is rectified on log_archive_dest_2, you can execute the following query to enable it

SQL> alter system set log_archive_dest_state_2=enable;

d) If logs are not shipping and if you want to apply manually, you shall move/copy the missing archivelog
from primary to standby manually using OS scp command and run the following command to apply
the changes

SQL> alter database register logfile '/oracle/archive/PROD_IN02/archivelog/2008_11_18/o1_mf_1_34_4l5bb7b4_.arc';


SWITCHOVER
============

1. Switchover Primary Database to Remote Standby Database

a) Shutdown Production E-Business Suite -
Shut down E-Business Suite application tier. Ensure the application is completely shutdown.

b) On the NoteIMARY database , Issue the following command to commit to switchover to
standby:

SQL> alter database commit to switchover to standby with session shutdown;

c) Shutdown the NoteIMARY database
SQL> shutdown immediate

d) Stop the NoteIMARY database listener: on all database nodes:

lsnrctl stop

e) On the STANDBY database, verify that it is ready to be converted to the new primary:

SQL> select switchover_status from v$database;

You should see the following value:
SWITCHOVER_STATUS
-----------------
TO PRIMARY

f) On the STANDBY database, execute the following command to convert it to be the new primary:

SQL> alter database commit to switchover to primary;

g) Enable Flashback on the STANDBY database (Optional)

SQL> alter database flashback on;

h) Open the STANDBY Database (New Primary database)

SQL> alter database open;

i) Remove the Old Application Topology
Connect to the new primary database using SQL*Plus as user APPS and execute the following
commands:

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
SQL> commit;

j) Configure the Standby Database Tier
Run AutoConfig on STANDBY database(New Primary) node to configure the Oracle home for use
by the E-Business Suite.

$ cd $ORACLE_HOME/appsutil/scripts/
$ ./adautocfg.sh

k) Start Original PRIMARY as Standby
Start the database listener on database node at the original primary site:

$ lsnrctl start

Start and mount database instance and then start managed recovery:

SQL> startup mount;
SQL> recover managed standby database using current logfile disconnect;

On the New PRIMARY database at the standby site enable remote archiving by executing this
command from SQL*Plus connected as sysdba:

SQL> alter system set log_archive_dest_state_2=enable SID='*';

Verify whether logs are switching from New PRIMARY to this Standby database as described in
Step 20.

l) Perform the Cloning Finishing Tasks as per Note 406982.1

Oracle Metalink Notes for Oracle Apps DBAs.

Oracle Metalink Notes for Oracle Apps DBAs.

Dear Friends,

The following are the list of Oracle Metalink Notes, which ORACLE Support suggests
for various issues on different versions

Note: You need to have an account in Oracle Metalink to access notes.

NOTE.166650.1 :Working Effectively With Oracle Support Services


Autoconfig
**********
NOTE.218089.1 : Autoconfig FAQ
NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.270519.1 :Customizing an AutoConfig Environment

Patching
********
NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running

Cloning
*******
NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ: Cloning Oracle Applications Release 11i
NOTE.135792.1 : Cloning Oracle Applications Release 11i
NOTE.362473.1 : Cloning E-Business Suite Using Hot Backup for Minimal
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i
NOTE.452056.1 : Business Continuity for Oracle Applications Release 12 on Database
Release 10gR2
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
Note 243880.1 : Shared APPL_TOP FAQ


IOBJ
****
NOTE.74660.1 : Resolving Invalid Objects in Oracle Applications

NOTE.338879.1 : Landscape1309 - Linux Landscape Quick Reference
NOTE.341782.1 : Linux Quick Reference

NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.370274.1 : New Features in Oracle Application 11i

NOTE.275734.1 : India Localization
NOTE.47837.1 : Applications Utilities FAQ
NOTE.189487.1 : System Administration FAQ's
NOTE.289786.1 : Installing Oracle Applications: A Guide to Using Rapid
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.243693.1 : Rapid Clone Coredumps when Running Adcfgclone.pl
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.331746.1 : Oracle Accelerator FAQ for Global Product Support (Internal
NOTE.144751.1 : Applications Patching - Time Saving Techniques
NOTE.232833.1 : Oracle Applications Release Notes, Release 11i (11.5.9)
NOTE.110372.1 : 11i: How to Clean up the UNIX Environment After Install
NOTE.156219.1 : Net8i/9i Basic configuration of LISTENER.ORA and TNSNAMES.
NOTE.69725.1 : Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.139949.1 : NEED TO CLEAR APACHE, BROWSER OR JINITIATOR CACHE FOR
NOTE.133972.1 : How to Reset the APPS and APPLSYS Passwords in Release 11.5
NOTE.216980.1 : FNDLOAD Fails with PLS-306 in call to LOAD_ROW

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.222663.1 : Internationalization Update Notes for the Oracle E-Business Suite 11i
NOTE.372952.1 : Customer Translations

NOTE.168330.1 : Reload Applications Related Java Objects
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.233436.1 : Installing Oracle Application Server 10g with Oracle E-
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)

NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.1076329.6 : SQL*Plus Errors - SP1.MSB Not Found
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -

NOTE.269293.1 : Oracle Applications Tablespace Model FAQs
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.268837.1 : Gathering Debug Weboam Log

NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.112577.1 : How to customize reports at runtime using XML - simple
NOTE.144689.1 : How to Generate a Report (.rdf) File from the UNIX Command
NOTE.211424.1 : How to Enable a Large SGA(over 1.7GB) on RedHat Advanced
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.144599.1 : How to Generate a .pll Library File for Applications 11i
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.208375.1 : How To Convert A Single Instance Database To RAC In A
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :

NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.1067473.6 : Custom Forms do not Show up in FNDSCMON Form
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack

NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)

NOTE.233038.1 : AD Command Line Options

NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.342459.1 : Diagnostics Overview

NOTE.394615.1 : Adaddnode.Pl failed with : ORA-00001 : unique constraint

NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.341322.1 : How to change the hostname of an Applications Tier using AutoConfig

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.72324.1 : Guidelines on Resolving NLS/MLS issues

NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.331221.1 : 10g Export/Import Process for Oracle Applications Release 11i
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications Release 11i
NOTE.259552.1 : 11.5.9 Category 3 Preupgrade Instructions for 9.2.0.4

NOTE.341281.1 : How to disable the language selection option available in AppsLocalLogin.jsp

NOTE.389472.1 : OATM Migration fails with ORA-22853 for LOB objects

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization


NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.123670.1 : Use Scanner Utility before Altering the Database Character
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.258895.1 : SYS.RULE$ marked as having convertible data (ORA-12716 when
NOTE.258902.1 : SYS.JOB$ marked as having convertible data

NOTE.43208.1 : Certified Compilers
NOTE.270806.1 : 11.5.9 : Invalid Objects - IES Java Classes
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.343253.1 : Tns-12555, Tns-12560, Tns-00525, Linux Error : 1 Starting

NOTE.150168.1 : Obtaining Forms Runtime Diagnostics (FRD) In Oracle
NOTE.210193.1 : Use of Multiple Organizations In Oracle Applications
NOTE.165035.1 : Current Issues - Multiple Organizations Architecture
NOTE.208267.1 : Improved Convert to Multi-Org Process In Oracle
NOTE.226456.1 : Multiple Organizations in Oracle Applications R11i, March
NOTE.259546.1 : Setting Up Multiple Organizations in Oracle HRMS
NOTE.131081.1 : How can I find which version of Portal I am running ?


NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications

NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-

NOTE.283225.1 : How to Recreate the Listener for Event and Listener for

NOTE.153960.1 : FAQ : X Server testing and troubleshooting

NOTE.146468.1 : Installing and Upgrading Oracle9i Application Server with
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.351283.1 : Interoperability Notes : Oracle Applications Release 11i
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.317226.1 : Concurrent Managers Do Not Start With GSM Profile Option
NOTE.311015.1 : Adgendbc.sh Errors Running AutoConfig


NOTE.337937.1 : Step By Step - 10gR2 RAC with ASM install on Linux(x86) -

NOTE.266043.1 : Support of Linux and Oracle Products on Linux
NOTE.224302.1 : Raw Devices on Linux

NOTE.134395.1 : Cannot Connect to Personal Home Page : Your Session is no
NOTE.351646.1 : Configuring Oracle E-Business Suite Release 11i with 10g

NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

NOTE.70276.1 : HOW TO INTEGRATE APPLICATIONS RELEASE 11 WITH CUSTOM
NOTE.273449.1 : Diagnosing Login Problems with Apps 11.5.9 (FND.G)
NOTE.139863.1 : Configuring and Troubleshooting the Self Service Framework


NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i

NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.252422.1 : Requesting Translation Synchronization Patches
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i


NOTE.68713.1 : Troubleshooting Self-Service Web Applications Login
NOTE.304489.1 : Using Oracle Applications with a Split Configuration

NOTE.225074.1 : 11i AOL : Cannot login to PHP after DB upgrade to 9.2.0.2
NOTE.358140.1 : Troubleshooting Unix coredumps and obtaining stack traces

NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX

NOTE.1812.1 :
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64

NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.300172.1 : Obsolescence of KOREAN_LEXER Lexer Type
NOTE.225456.1 : Troubleshooting Guide for Cloning Issues
NOTE.161474.1 : Oracle Applications Remote Diagnostics Agent (APPS_RDA)
NOTE.111383.1 : The Basics About Report Review Agent (FNDFS) on 11i

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.316447.1 : About Oracle XML Publisher Release 5.5
NOTE.295036.1 : About XML Publisher Release 5.0
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3

NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.124606.1 : Upgrading JInitiator with Oracle Applications 11i

NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
NOTE.1010501.7 : FAQ : Licensing and de-licensing a product, country-specific


NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise

NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.403311.1 : United States Time Zone Changes 2007 : E-Business Suite

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.240862.1 : Install Oracle Unicode Fonts for Dynamic Image Generation
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.400830.1 : How to Render Non ASCII Characters in Personalized
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.403311.1 : United States & Canada 2007 Daylight Saving Time (DST)
NOTE.289788.1 : Upgrading Oracle Applications
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.189867.1 : Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102

NOTE.253763.1 : After Cloning on Target instance FRM-92050 Failed to

NOTE.274783.1 :


Amol's Bookmark
*********************************************************************
NOTE.167000.1 : eBusiness Suite Support - Oracle Diagnostics Support Pack
NOTE.235307.1 : OSS Application Diagnostics Tools : FAQ and Troubleshooting
NOTE.231142.1 : About Oracle Diagnostics version 2.1
NOTE.262006.1 : About Oracle Diagnostics 2.2
NOTE.300976.1 : Support Diagnostics Newsletter for Applications Core
NOTE.357223.1 : "This test can be executed only after logging into
NOTE.363759.1 : How To Add Diagnostic Tools To Responsibility Menu

Installation
*********

NOTE.215868.1 : 11i Release Notes
NOTE.77219.1 : Applications Release 11.0.3 One-Hour Install for Unix
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.110372.1 : 11i : How to Clean up the UNIX Environment After Install
NOTE.169402.1 : How To Cleanup After A Failed Applications Installation On
NOTE.48602.1 : How do I determine which products are fully installed, and
NOTE.124353.1 : WIN : Manually Removing all Oracle Components on Microsoft
NOTE.275493.1 : Removing 10g Database and Software from AIX, HP-UX, Linux,
NOTE.279519.1 : How to completely remove 8i / 9i Database and Software from
NOTE.232831.1. : Oracle Applications NLS Release Notes 11.5.9 - B10846-01
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.187240.1 : Applications AOL Scenarios : Is It Supported ?
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.316806.1 : Oracle Applications Installation Update Notes, Rel 11.5.10.2
NOTE.360079.1 : Global and Local Inventory explained
NOTE.295185.1 : How to Recreate the Global oraInventory
NOTE.197028.1 : Software Requirements and Tools for Oracle Applications
NOTE.201392.1 : Visual C++ Requirement for Release 11i on Windows
NOTE.268776.1 : GNU Make Requirement for Release 11i For Windows
NOTE.181244.1 : Configuring VNC Or XVFB As The X Server For Applications 11i
NOTE.153960.1 : FAQ : X Server testing and troubleshooting

Patching
*******

NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.252422.1 : Requesting Translation Synchronization Patches in Release
NOTE.316366.1 : 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)
NOTE.259484.1 : Release 11.5.10 Maintenance Pack Installation Instructions
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.358247.1 : ORA-00001 : unique constraint violated error while applying
NOTE.358417.1 : Unable to Start Concurrent Managers After Applying 11i.
NOTE.353414.1 : Application Technology Group (ATG) Patching Policy
NOTE.359198.1 : XDF files fail to load on HP-UX, Memory Fault(Coredump)
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.337274.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 3
NOTE.244040.1 : Oracle E-Business Suite Recommended Performance Patches
NOTE.367756.1 : Uploading Java Objects To Patch History Tables Fails While
NOTE.76708.1 : Using ADSPLICE To Add Products To The APPL_TOP In

Cloning
******

NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ : Cloning Oracle Applications Release 11i
NOTE.242123.1 : Create new middle tier node in existing Apps 11i
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.364565.1 : Troubleshoot RapidClone or OAM Clone issues

Upgrade
*******
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.289765.1 : Oracle Applications Release 11i (11.5.10) Upgrade Assistant
NOTE.289788.1 : Upgrading Oracle Applications


Autoconfig
**********
NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.218089.1 : Autoconfig FAQ
NOTE.270519.1 : Customizing an AutoConfig Environment
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.341322.1 : How to change the hostname of an Applications Tier using
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.108865.1 : How To Create a Database Connection(DBC) File and

AD Utilities
**********
NOTE.233038.1 : AD Command Line Options

Relinking
********

NOTE.69798.1 : Basics of Relinking an Executable or Binary in an Oracle
NOTE.1009722.6 : How to relink Oracle Concurrent Program Executables on Unix

OAM
****

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.117264.1 : FAQ (Oracle Applications Manager)
NOTE.177089.1 : OAM11i Standalone Mode Setup and Configuration
NOTE.214962.1 : How To Determine The Version Of OAM (Oracle Application
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.166115.1 : Oracle Applications Manager 11i integrated with Oracle
NOTE.185431.1 : Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
NOTE.73959.1 : Installation and Configuration of Oracle Application Manager
NOTE.225024.1 : Oracle Applications Manager 11i Documentation Roadmap
NOTE.338317.1 : Basic Information on Cloning An 11.5.10 System Using OAM

NLS/MLS
*******

NOTE.15389.1 : NLS DEBUGGING SUCCESS GUIDE ** INTERNAL ONLY **
NOTE.227332.1 : NLS considerations in Import/Export - Frequently Asked
NOTE.15095.1 : Export/Import and NLS Considerations
NOTE.175300.1 : A Guide to Debugging Globalization (NLS) Support Issues
NOTE.124721.1 : Migrating an Applications Installation to a New Character


Forms
*****

NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.177610.1 : Oracle Forms in Applications FAQ
NOTE.141012.1 : How to Manually Generate an 11.5 Form on Unix

Apps Database
*************

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.285267.1 : Oracle E-Business Suite 11i and Database FAQ
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.183078.1 : Recreating Applications 11i JAVA objects in the database
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i,
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.340859.1 : Upgrading Oracle Applications 11i Database to 10g with
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.216211.1. : Nologging in the E-Business Suite

NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g

RAC / Apps RAC
**************

NOTE.220970.1 : RAC : Frequently Asked Questions
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.270901.1 : How to Dynamically Add a New Node to an Existing 9.2.0 RAC
NOTE.294652.1 : E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.277825.1 : How to setup Tnsnames.ora (806) for 11i and RAC

Database
********

NOTE.1012933.6 : General Information : Alert Logs and Trace Files
NOTE.209870.1 : How to Reload the JVM in 9.2.0.X
NOTE.175472.1 : How to Reload the JVM in 8.1.7.X
NOTE.159143.1 : Separating Multiple 8i or 9i Oracle Versions to Avoid
NOTE.307349.1 : OUI tips for Oracle RDBMS 10.1.X on OpenVMS
NOTE.130814.1 : How to move LOB Data to Another Tablespace


System Administration
*******************

NOTE.189457.1 : Oracle Applications Systems Administration Setup and Usage
NOTE.290525.1 : Oracle User Management FAQ
NOTE.316277.1 : Unable To Change Guest User Password In Oracle Applications
NOTE.311552.1 : How to optimize the purge process in a high transaction
NOTE.154850.1 : How to Run the Purge Concurrent Request and/or Manager Data

Jserver
******

NOTE.295484.1 : Clear Server Cache and Bounce Apache (Web Server)
NOTE.220188.1 : Oracle Applications Release 11i apps.zip Re-architect
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

Invalid Objects
*************

NOTE.60558.1 : Troubleshooting the Source of Invalid Objects
NOTE.266910.1 : How To Resolve IES Invalid Java Classes After Loading JAR
NOTE.113947.1 : Step by Step Troubleshooting Guide to Solve APPS Invalid

UNIX / LINUX / WINDOWS
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.28588.1 : TECH : Using Truss / Trace on Unix

Advanced Configuration
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.226880.1 : Configuration of Load Balancing and Transparent Application
NOTE.97926.1 : Failover Issues and Limitations [Connect-time failover and
NOTE.123718.1 : 11i : A Guide to Understanding and Implementing SSL for

Techstack
NOTE.162488.1 : Complete Guide to JInitiator 1.1.8 Setup & Troubleshooting
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.94091.1 : Example : Identifying Connection String Problems in JDBC

Workflow
NOTE.298550.1 : Troubleshooting Workflow Data Growth Issues


General
NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.224882.1 : Common Commands asked by Oracle Support for Troubleshooting
NOTE.110415.1 : Payables MRC Frequently Asked Questions
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.257650.1 : Resolving Problems with Connection Idle Timeout
NOTE.270523.1 : How To Find the Oracle Applications Framework and Rollup
NOTE.301504.1 : "Cannot Complete Applications Logon" Error After Selecting
NOTE.315094.1 : JTF Login Page - an operational assessment for CRM

NOTE.242490.1 :
NOTE.282038.1 :
NOTE.342861.1 :
NOTE.209999.1 :
REMARK.56942.1 :
NOTE.198160.1 :
NOTE.159244.1 :





NOTE.186981.1 : Oracle Application Server with Oracle E-Business Suite
NOTE.333436.1 : Oracle E-Business Suite 11i on Windows Server 2003 Service
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.158577.1 : NLS_LANG Explained (How does Client-Server Character
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.43208.1 : Certified Compilers

NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :

NOTE.260393.1 : Java Mailer and Other 11.5.9/OWF G Current Issues in

NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets

NOTE.125767.1 : Upgrading Developer 6i with Oracle Applications 11i

NOTE.371438.1 : adpreclone.pl dbTier fails with RC-50409 : Topology
NOTE.342332.1 :
NOTE.135949.1 : Troubleshooting the Personal Home Page Login Problems in 11.
NOTE.164317.1 : Upgrading JDBC drivers with Oracle Applications 11i
NOTE.302035.1 : How to Test a JDBC Thin Driver Connection From the SSO
NOTE.365735.1 : How to use Digital Certificates for 11i Applications
NOTE.357922.1 : Autoconfig Reverts to old Context File Values.

NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA

NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java

NOTE.165123.1 : JAVA CLASS - ORA-29534 : referenced object
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications

NOTE.271218.1 : Yellow bar's and Java security error , The daddy of all

NOTE.294932.1 : Recommendations to Install Oracle Applications 11i
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications

NOTE.233428.1 :
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i

NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual

NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.159270.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,

NOTE.303237.1 : Migrating Red Hat Linux 2.1 or 3.0 to Red Hat Linux 4.0
NOTE.91985.1 :
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.272789.1 : Post Clone Problem : Login/Portal Server Installation May
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle

NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.131321.1 : How to Relink Oracle Database Software on UNIX
NOTE.231876.1 : Windows OS Upgrade for 11i E-Business Suite

NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide

NOTE.209810.1 : How to Relink Oracle Applications 11i Programs After

NOTE.361428.1 : Using Linux Desktop Clients with Oracle Applications 11i

NOTE.296559.1 :
NOTE.275734.1 : India Localization
NOTE.364439.1 : Tips and Queries for Troubleshooting Advanced Topologies

NOTE.372928.1 : Oracle Critical Patch Update July 2006 Documentation Map
NOTE.372931.1 : E-Business Suite Critical Patch Update Note
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.292996.1 : How to Re-Install Intermedia on an 11i Environment

NOTE.160121.1 : Introduction to Sun Cluster v3
NOTE.188135.1 : Documentation Index for Real Application Clusters

NOTE.251351.1 : How to Change the Characterset in a Standby Database in 9i
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications

NOTE.1009718.6 : HOW TO SOLVE UNDEFINED SYMBOL ERRORS ON UNIX AND VMS

NOTE.316889.1 : Complete checklist for manual upgrades to 10gR2


NOTE.223721.1 : How to Install XVFB on Linux for dynamic image generartion
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE : 163400.1 : Release Content Documents and Features Summary Matrices

NOTE.253918.1 : Autopatch Fails with "Unable to call adppdepRunFndLoad

NOTE.166650.1 : Working Effectively With Oracle Support Services
NOTE.333785.1 : Oracle Applications Internationalization Guide

NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions

NOTE.17210.1 : Supported NLS Character Sets

NOTE.179133.1 : The correct NLS_LANG in a Windows Environment

NOTE.226565.1 : 9iRAC Useful Views and Statistics (INTERNAL ONLY)

NOTE.387046.1 : RCONFIG : Frequently Asked Questions

NOTE.200340.1 : RAC : Cache Fusion

NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.312594.1 : Get Warning Messages Trying To Generate Jar Files From
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent
NOTE.365228.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 4
NOTE.371016.1 : How To License A New Product.

NOTE.151654.1 : How To Start the License Manager After Installing Oracle

NOTE.279430.1 : How To Change Project Installation From Shared To Full

NOTE.123891.1 :
NOTE.123891.1 : How to deactivate a language in e-Business Suite
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.341437.1 : Business Continuity for Oracle Applications Release 11i

NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.304748.1 : Internal : E-Business Suite 11i with Database FAQ
NOTE.308320.1 : How to install the 10.1.0 Enterprise Manager Grid Control

NOTE.291901.1 : Maintenance Mode - A New Feature in 11.5.10
NOTE.134527.1 : TNS-00516 Starting TNS Listener

NOTE.300482.1 : Overview of Using Java with Oracle E-Business Suite Release
NOTE.208256.1 : WIN : How to Remove a Single ORACLE_HOME and Its Traces on
NOTE.363827.1 : Rebaselined Oracle Applications Technology Components for
NOTE.373611.1 : How to move Concurrent Processing Server from one node to


NOTE.240818.1. :
NOTE.69660.1 : Understanding Data Auditing in Oracle Application Tables

NOTE.60828.1 : Overview of Oracle Applications AuditTrails
NOTE.134949.1 : Release 11.0.3 and Oracle 8i Release 8.1.6 Interoperability
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i

NOTE.189256.1 : UNIX : Script to Verify Installation Requirements for Oracle
NOTE.296559.1 : FAQ : Common Tracing Techniques within the Oracle
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions

NOTE.399789.1 : NLS Frequently Asked Questions

NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions

NOTE.110849.1 : Installing and Relinking Oracle Developer on UNIX Platforms

NOTE.76535.1 :
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.310840.1 : AFPCAL Received Failure Code While Parsing or Running
NOTE.371434.1 : Using Openfiler iSCSI with an Oracle database

NOTE.233040.1 : When Oracle Applications Automatic Patch Prerequisite
NOTE.236469.1 : Using Distributed AD in Applications Release 11.5.
NOTE.233043.1 : 11.5.9 Oracle E-Business Suite Consolidated Update 2
NOTE.108185.1 : Oracle Applications Object Library SQL scripts
NOTE.201662.1 : How To Manually Relink on Windows NT or Windows 2000

NOTE.306906.1 : How to create missing DB objects from xdf files

NOTE.396708.1 : Guidelines to Determine whether a Bug or SR is a LinuxOS

NOTE.166762.1 : Oracle Applications Manager 11i Availability
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.216589.1 : Step By Step Guide to Creating a Custom Application in
NOTE.105127.1 : FAQ (Customization)
NOTE.243880.1 : Shared APPL_TOP FAQ
NOTE.409045.1 : How to clone from Rac to Non-rac in Oracle Applications 11i.

NOTE.373611.1 : How to move Concurrent Processing Server from one node to

NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications

NOTE.261428.1 : Setting up 11i E-Business suite using a hardware load

NOTE.224875.1 : Installation, Patching & Upgrade Frequently Asked Questions

NOTE.278816.1 : How to Setup Parallel Concurrent Processing using Shared

NOTE.286506.1 : Sharing Middle-tier Oracle Home in E-Business Suite 11i

NOTE.105133.1 : Concurrent Manager Questions and Answers Relating to
NOTE.69336.1 : Basic information about Concurrent Managers
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
*********************************************************************



NOTE.416338.1 : How To Upgrade JDK / J2SE 1.4 Sub-Versions
NOTE.225165.1 : Patching Best Practices and Reducing Downtime
NOTE.368628.1 : Is The 'Personal Home Page' Mode Supported In Oracle 11i Applications?

NOTE.387859.1 : Using AutoConfig to Manage System Configurations in Oracle
NOTE.402306.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.160214.1 : How to change the oracle users, APPS, APPLSYS and

NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.335515.1 : Relink fails for Oracle 9.2.0.7.0 on LINUX x86 server on

NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator

NOTE.402312.1 : Oracle Applications Installation and Upgrade Notes Release

NOTE.394692.1 : Oracle Applications Documentation Resources, Release 12

NOTE.603104.1 : Troubleshooting RapidClone issues with Oracle Applications R12
NOTE.384248.1 : Sharing The Application Tier File System in Oracle E-Business Suite Release 12

NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems

NOTE.393861.1 : Globalization Guide for Oracle Applications Release 12
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.184876.1 : Oracle Application Object Library Middle (Web) Tier Setup
NOTE.403385.1 : Duplicate Responsibilities Created On Sysadmin Login And



NOTE.380483.1 : Oracle E-Business Suite Release 12 Additional Configuration
NOTE.148903.1 : Interoperability Notes Oracle Applications Release 11i with
NOTE.364704.1 : A Guide to Configure, Maintain & Troubleshoot JDBC Buffers

NOTE.148902.1 : Interoperability Notes Oracle Applications Release 11.0
NOTE.337762.1 : How to Remove an Oracle Applications 11i node

NOTE.399362.1 : Oracle Applications Release 12 Upgrade Sizing and Best
NOTE.104457.1 : Invalid Objects In Oracle Applications FAQs
NOTE.132604.1 : Upgrading OJSP with Oracle Applications 11i
NOTE.215268.1 : Implementing and Using the JSP Precompiler

NOTE.316900.1 : ALERT : Oracle 10g Release 2 (10.2) Support Status and Alerts

NOTE.189908.1 : ALERT : Oracle9i Release 2 (9.2) Support Status and Alerts
NOTE.380490.1 : Oracle E-Business Suite R12 Configuration in a DMZ

NOTE.269291.1 : Oracle Applications Tablespace Migration Utility User
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.406982.1 : Cloning Oracle Applications Release 12 with Rapid Clone
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.419839.1 : How to enable Apache, OC4J and OPMN logging in Oracle
NOTE.422419.1 : How To Enable and Collect Debug for HTTP, OC4J and OPMN in

NOTE.15390.1 : How to Determine and Change DB_NAME or ORACLE_SID
NOTE.375682.1 : About Oracle Applications Technology ATG_PF.H Rollup 5

NOTE.135715.1. : Diagnostic Steps for Intermittent FRM-99999 & FRM-92100
NOTE.185489.1 : Setting Up Parallel Concurrent Processing On Unix Server
NOTE.431496.1 : Java In The Database For Oracle Applications : Introduction
NOTE.183408.1 : Raw Devices and Cluster Filesystems With Real Application
NOTE.277366.1 : Technology Validation Utility for Oracle Applications
NOTE.394448.1 : Getting Started with the Application Management Pack for
NOTE.412044.1 : Application Management Pack for Oracle E-Business Suite
NOTE.375113.1 : Oracle Diagnostics 2.4
NOTE.405425.1 : Oracle Diagnostics 2.5

NOTE.201340.1 : Using Forms Listener Servlet with Oracle Applications 11i
NOTE.160337.1 : How To Manually Change The APPS, APPLSYS and APPLSYSPUB
NOTE.372322.1 : HP Tru64 UNIX Migration Strategy for Oracle E-Business

NOTE.303709.1 : Reclaiming unused space in APPLSYSD tablespace

NOTE.130183.1 : How to Get Log Files from Various Programs for Oracle
NOTE.269129.1 : How to Implement Printing for Oracle Applications : Getting

NOTE.297522.1 :
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.452120.1 : How to locate the log files and troubleshoot RapidWiz for
NOTE.312640.1 : Oracle Text : Re-installation of Applications 11i (11.5.10)

**************
*** iSetup ***
**************
NOTE.402785.1 : iSetup dependency with Deinstall and Reinstall of XMLDB
NOTE.368670.1 : About Oracle iSetup Minipack 11i.AZ.H
NOTE.243554.1 : How to Deinstall and Reinstall XML Database (XDB)


NOTE.244523.1 : Security Alert #57 : Buffer Overflows in EXTPROC of Oracle
NOTE.433435.1 : Japanese characters are displayed like square boxes in
NOTE.455366.1 : Investigating NoClassDefFoundError in eBusiness 11i when
NOTE.197409.1 : Error Opening Oracle*Terminal File fmrweb.res
NOTE.312553.1 : How To Use the Original Forms for Reprint Instead of the
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12

NOTE.458452.1 : Complying with Daylight Saving Time (DST) and Time Zone
NOTE.189367.1 : Best Practices for Securing the E-Business Suite
NOTE.300969.1 : Troubleshooting SSL with Oracle Applications 11i
NOTE.444524.1 : About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.428262.1 : How to identify the form name attached to an f60webmx

NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.405521.1 : Oracle Enterprise Manager Grid Control Release Notes for
NOTE.187905.1 : bde_imt_index_status.sql - List all interMedia Text indexes
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC

NOTE.345106.1 : Login Links On New Rapid Install Homepage Do Not Function
NOTE.443521.1 : Enterprise Manager Grid Control Plug-in for Oracle Applications, Version 1.0/1.2

NOTE.398412.1 : Workflow Queues Creation Scripts
NOTE.77483.1 : External Support FTP site : Information Sheet

NOTE.122452.1 : Global Customer Services Policy Regarding Customizations
NOTE.257911.1 : How To Use Rotatelogs In 9iAS Release 1 (1.0.2.x)
NOTE.276845.1 : Apache Web Server Hangs Every Other Time Running Adapcctl.
NOTE.218893.1 : How to Create The Service Manager 'FNDSM' on Oracle
NOTE.437878.1 : Upgrading Forms and Reports 10g in Oracle Applications
NOTE.290807.1 : Upgrading Sun JRE with Oracle Applications 11i

NOTE.280167.1 : AS10g with Apps 11i - Summary of Login process

NOTE.357218.1 : Troubleshooting JDeveloper setup for Oracle Applications
NOTE.403339.1 : Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade


NOTE.463249.1 : After Clone Forms Is Trying To Connect To Target Instance
NOTE.386374.1 : How to enable/disable/change password of the listeners for Oracle Applications 11i


NOTE.454750.1 : Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes

NOTE.428503.1 : Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 10.2.0.3

NOTE.443761.1 : How to check if a certain Patch was applied to Oracle Applications instance using 'adpatch'?

NOTE.291783.1 : Getting Started with the Oracle Grid Control Plug-in for Oracle Applications in Release 11i (AMP v1)

NOTE.468980.1 : How to Remove the Language Icons in the AppsLocalLogin.jsp


NOTE.398619.1 : Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)

NOTE.295606.1 : Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting

NOTE.169706.1 : Oracle® Database on AIX®,HP-UX®,Linux®,Mac OS® X,
Solaris®,Tru64 Unix® Operating Systems Installation and
Configuration Requirements Quick Reference (8.0.5 to 11.1)

NOTE.109665.1 : Organization Setup Frequently Asked Questions - FAQ
NOTE.434395.1 : ATG Service Request Creation
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.469213.1 : How To Encrypt The Apps Password In Wdbsvr.App
NOTE.293369.1 : OPatch documentation list
NOTE.275379.1 : Script To Check What Workflow Related Patches Are Installed
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC

NOTE.264157.1 : The correct NLS_LANG setting in Unix Environments
NOTE.91985.1 : Step by Step on Cloning the ORACLE_HOME (Including DB) and
NOTE.74838.1 : Migrating Apps Release 11.0 from UNIX Host To A Second

NOTE.396009.1 : Database Initialization Parameters for Oracle Applications Release 12

NOTE.391406.1 : How to get a clean Autoconfig Environment
NOTE.560719.1 : How to troubleshoot iSetup issues
NOTE.406376.1 : Oracle E-Business Tax Release 12 Known Issues
NOTE.577713.1 : On Windows, After 10g Upgrade, Running Autoconfig on Apps
NOTE.343917.1 : Frequently Asked Questions : Oracle E-Business Suite Support
NOTE.553831.1 : java.lang.ArrayIndexOutOfBoundsException Error when

NOTE.119319.1 : How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen


NOTE.554336.1 : How Do You Manually Generate A Form In Release 12 (frmcmp)


NOTE.444286.1 : How to manually generate a R12 report on Unix
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual Hostnames and Business Continuity


NOTE.555081.1 : Concurrent Manager Does Not Start if the Profile Option "Concurrent : GSM Enabled" is Set "Y" at Site Level


NOTE.149124.1 : Creating a StatsPack performance report
NOTE.471566.1 : Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit

NOTE.397757.1 : How to Speed Up Index Creation on FND_LOBS by indexing Only FND_HELP Data

NOTE.375127.1 : How to restart the adworker having status fixed,restart,wait
NOTE.353150.1 : OPatch Failing Validation Phase When Archiving Really Did Not Fail

NOTE.215527.1 : Maintenance Wizard Overview
NOTE.564465.1 : Sysadmin And User Responsibility Not Available
NOTE.219968.1 : SQL*Net, Net8, Oracle Net Services - Tracing and Logging at a Glance


NOTE.417122.1 : Resolving the Library Cache Locks
NOTE.419475.1 : Removing Credentials from a Cloned EBS Production Database

Oracle Applications 11i/12 Online Documentation

http://www.oracle.com/technology/documentation/applications.html

Note: There are many other notes on various issues available in Oracle Metalink
For any specific issue, you shall always contact ORACLE SUPPORT for complete assistance.