Friday, 8 January 2016

R12: "APP-FND-01496: Cannot access application ORACLE password" Error Launching Forms After 12.1.3 Upgrade


Symptoms

On : 12.1.3 version, Forms for App Technology

While launching the forms after upgrading E-Business suite from  12.0.6 to 12.1.3, the following error is encountered:

Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

APP-FND-01496: Cannot access application ORACLE password
Cause: Application Object Library was unable access your ORACLE password.
  
Below is the version details found in the Database.

CREATE OR REPLACE PACKAGE fnd_gfm AS
/* $Header: AFGFMS.pls 120.10.12000000.2 2011/08/22 16:26:28 ctilley ship $ */

CREATE OR REPLACE PACKAGE BODY fnd_gfm AS
/* $Header: AFGFMB.pls 120.17.12010000.1 2008/07/25 14:15:26 appldev ship $ */
 
 
 

Solution

To implement the solution, please execute the following steps after 12.1.3 upgrade
1. Download and review the readme and pre-requisites for Patch 13322561.
   
Note: At the time of this writing, the latest CPU patch to be applied is 13322561. Please review doc id 1384016.1 for the latest Critical Patch Update to apply on your environment.
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions for CPU patch 13322561. If you are applying a patch other than 13322561 according to doc id 1384016.1, make sure to validate the right file versions.
AFGFMS.pls 120.10.12010000.2  
AFGFMB.pls 120.17.12010000.7 
You can use the commands like the following:
strings -a  $FND_TOP/patch/115/sql/AFGFMS.pls | grep Header 
strings -a  $FND_TOP/patch/115/sql/AFGFMB.pls | grep Header 
 5. Retest the issue and migrate to appropriate environments.
 
Thanks
Srini

Thursday, 7 January 2016

How to Install EBS Application 12.2



We need to create the user and group as following:
[root@apps ~]# groupadd dba
[root@apps ~]# useradd  -g dba oracle
[root@apps ~]# useradd  -g dba applmgr
Create the Directory structure as following:
[root@apps ~]# mkdir /u01/db
[root@apps ~]# chown -R oralce:dba /u01/db

We need to copy the all above zip files into /u01/Stage/ and change the permission to oracle:dba and change the mode(chmod 775 /u01/zipfiles)
Create the oraInventory Directory as following:
[root@apps ~]# mkdir /u01/db/oraInventory
[root@apps ~]# chown -R oralce:dba /u01/db/ oraInventory
[root@apps ~]# chmod -R 775 /u01/db/ oraInventory
goto /etc and edit the oraInst.loc file and set the oraInventory location as following:
[root@apps etc]# vi oraInst.loc
inventory_loc=/u01/db/oraInventory
[root@apps etc]# cat oraInst.loc
inventory_loc=/u01/db/oraInventory
Installation:
Goto the zip files location through root user and unzip the following zip file only
[root@apps Stage]#unzip V35215-01_1of3.zip
after unzip the above zip file, you need to follow the below steps:
[root@apps bin]# pwd
/u01/Stage/startCD/Disk1/rapidwiz/bin
[root@apps bin]# sh buildStage.sh
Build Stage Menu
——————————————————
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu
Enter your choice [4]: 1
Rapid Install Platform Menu
——————————————————
1.    Oracle Solaris SPARC (64-bit)
2.    Linux x86-64
3.    IBM AIX on Power Systems (64-bit)
4.    HP-UX Itanium
5.    Exit Menu
Enter your choice [5]: 2
/u01/Stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u01/Stage/startCD/Disk1/rapidwiz/bin
Please enter the directory containing the zipped installation media:
/u01/Stage
Unzipping V29856-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35231-01_2of5.zip
Unzipping V35804-01_1of2.zip
 After unzip all the files Stage is shown below:
Verifying stage area…

Directory /u01/Stage/TechInstallMedia is valid
Directory /u01/Stage/TechPatches/DB is valid
Directory /u01/Stage/TechPatches/MiddleTier is valid
Directory /u01/Stage/EBSInstallMedia/AppDB is valid
Directory /u01/Stage/EBSInstallMedia/Apps is valid
Directory /u01/Stage/EBSInstallMedia/AS10.1.2 is valid
Directory /u01/Stage/TechInstallMedia/database is valid
Directory /u01/Stage/TechInstallMedia/ohs11116 is valid
Directory /u01/TechInstallMedia/wls1036_generic is valid
Stage area verified.
Press enter to continue…

Build Stage Menu
——————————————————
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu

Enter your choice [4]: 4
Now, we start the Installation through root user as following:

[root@apps rapidwiz]# pwd
/u01/Stage/startCD/Disk1/rapidwiz
[root@apps rapidwiz]# ./rapidwiz
apps 1
Click Next
apps 2
Click Next 
apps 3
Click Next 
apps 4
Click Yes
apps 5
Click Next
apps 6
Enter the Database configurations and Click Next
apps 7
Select suite licensing and Click Next
apps 8
Click Next
apps 9
Click Next
apps 10
Select the Language and character set as following
apps 11
Enter the Application configurations and Click Next as following
apps 12
Enter the Weblogic username & password as following: (password like oracle123)
apps 13
Click Next
apps 14
After Validate the system configurations Click Next 
apps 15
Rapid Install wizard will now install Oracle E-Business Suite. It will take 3-4 hours time to Install.
apps 16




apps 18
After Validate the complete Installation Click Next
apps 19
Click Finish
apps 20
Now, Installation has completed successfully….
Now, we check opmnctl status are alive or not by using the  following command
opmn











Now, you should be able to access applications home page as following
Example
http://<host name>.<domain name>:<HTTP port>/OA_HTML/AppsLogin

For example: (My URL)
http://apps.weblogic.com:8000/OA_HTML/AppsLogin
apps 21
Now, we enter the username and password to access the applications
username=sysadmin
password=sysadmin
apps 22
Also you should be able to access weblogic console home page as following
Example
http://<host name>.<domain name>:<HTTP port>/console

For example: (My URL)
http://apps.weblogic.com:7001/console
username=weblogic
password=oracle123
apps 23
Now, we see the servers details as following
apps 24
Here we can see following Mange servers in weblogic:
1.forms-c4ws_server1
2.forms_server1
3.oacore_server1
4.osfm_server1
We hope this post will help you to Install E-biz application 12.2

Thanks
Srini

Wednesday, 6 January 2016

Apps DBA Daily tasks ...



 

eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node
Being Apps. DBA, one should check the subsequent on Daily Basis in order to make sure that everything is working fine. This post is relating to ADMIN NODE.
Listener Status
$ lsnrctl status PROD(Listner Name)
File System Space Utilization
$ df -h
$df -sg
SQL> !df -sg /u99
Filesystem GB blocks Free* %Used   Iused   %Iused Mounted on
/dev/u99      599.85   490.19     19%    4108       1%             /u99
SQL>

Operating System – eBusiness DB and Concurrent Processes
$ ps -ef |grep pmon|grep -v grep
$ ps -ef |grep FNDLIBR|grep -v grep
eBusiness DB Instance
SQL> SELECT instance_name,host_name,TO_CHAR(startup_time,’DD-MON-YYY HH:MM:SS AM’) startedat FROM v$instance;
Invalid Objects
SQL> select owner,object_name,object_type from dba_objects where status’VALID’;
Inactive Users
SQL> select username,command,status,server,osuser,machine,terminal,program,module,action from v$session where status’INACTIVE’;
Active Sessions
SQL> select inst_id,count(*) from gv$session group by inst_id;
Active Users Detail
SQL> select username,command,status,osuser,process,machine,terminal,program,module,action from v$session where status’ACTIVE’;
Check inactive form sessions also for server load:
select distinct b.sid,b.serial# ,b.status,b.program,b.username,b.action,b.module,
to_char( b.logon_time, ‘dd-MON-yyyy hh24:mi:ss’ ) logon_time,
trunc( sysdate-b.logon_time ) “Dy”,
trunc( mod( (sysdate-b.logon_time)*24, 24 ) ) “Hr”,
trunc( mod( (sysdate-b.logon_time)*24*60, 60 ) ) “Mi”,
trunc( mod( (sysdate-b.logon_time)*24*60*60, 60 ) ) “Sec”
from gV$access a,gv$session b, gv$process c
where a.sid=b.sid
and b.paddr=c.addr
and b.status=’INACTIVE’
and (b.action like ‘%FRM%’ or b.action like ‘%frm%’ or b.program like ‘%TOAD%’ or b.program like ‘%toad%’ or b.program like
‘SQL%’ or b.program like ‘%sql%’ or b.program like ‘%FRM%’
or b.program like ‘%frm%’ or b.action like ‘SQL%’ or b.action like ‘sql%’ or b.action like ‘TOAD%’ or b.action like ‘toad%’)
and (trunc( mod( (sysdate-b.logon_time)*24,24)) >=12 or trunc( sysdate-b.logon_time )>=1)
Data Files Status:
SQL> select name,status from v$datafile;
Log Files Status
SQL> select * from v$log;
Archiving Errors
SQL> select error from v$archive_dest;
Tablespace Free Space
SQL> select tablespace_name,round (sum(bytes)/1024/1024) Free_Space_MB from dba_free_space group by (TABLESPACE_NAME);
Invalid Indexes
SQL> select index_name,table_name from dba_indexes where status =’INVALID’ and owner=’APPS’;
eBusiness 11i/R12 – Applications Listener Status
$ sh $COMMON_TOP/admin/scripts/PROD_oracle2/adalnctl.sh status
Checking on the status of Report Server
$ sh $ORACLE_HOME/admin/scripts/PROD_oracle2/adrepctl.sh status
Database Connectivity via Apps. user without Connect String
$ sqlplus -S -M “HTML ON TABLE ‘BORDER=”2″‘” “apps/****” @/oracle/appsprod/oui/venkat/appschk.sql > /oracle/appsprod/oui/venkat/output.html
Database Growth:
select to_char(creation_time, ‘RRRR Month’) “Month”, sum(bytes)/1024/1024/1024 “Growth in GB” from sys.v_$datafile where creation_time > SYSDATE-365 group by to_char(creation_time, ‘RRRR Month’);

Thanks
Srini

Useful Metalink Docs for Oracle Core and Apps DBA


 

Note.174436.1 : Oracle Applications Patching FAQ
Note.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
Note.175485.1 : How to Apply an 11i Patch When adpatch is Already Running
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
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
Note.243693.1 : Rapid Clone Coredumps when Running Adcfgclone.pl
Note.398619.1 : Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
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
Note.316277.1 : Unable To Change Guest User Password In Oracle Applications
Note.295484.1 : Clear Server Cache and Bounce Apache (Web Server)
Note.113947.1 : Step by Step Troubleshooting Guide to Solve APPS Invalid
Note.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
Note.298550.1 : Troubleshooting Workflow Data Growth Issues
Note.469213.1 : How To Encrypt The Apps Password In Wdbsvr.App
Note.293369.1 : OPatch documentation list
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:186150.1 Creating a logical standby
Note:214071.1 Creating a logical standby with Data Guard Manager
Note:232240.1 Performing a switchover
Note:227196.1 Performing a failover
Note:233261.1 Tuning Log Apply Services
Note:215020.1 Troubleshooting Logical Standbys
Note:210989.1 Applying Patchsets with Logical Standby in Place
Note:233519.1 Known Issues with Logical Standby
Note:240874.1 Primary Site and Network Configuration Best Practices
Note:240875.1 9i Media Recovery Best Practices
Note:60545.1 How to Extract Controlfiles, Datafiles, and Archived Logs from RMAN Backupsets
Note:139516.1 Discoverer 4i with Oracle Applications 11i
Note.257798.1 Discoverer 10g (9.0.4) with Oracle Applications 11i
Note.139516.1 Installation of Discoverer 4i
Note.74660.1 : Resolving Invalid Objects in Oracle Applications
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.133972.1 : How to Reset the APPS and APPLSYS Passwords in Release 11.5
Note.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
Note.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
Note.144689.1 : How to Generate a Report (.rdf) File from the UNIX Command
Note.144599.1 : How to Generate a .pll Library File for Applications 11i
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.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.338003.1 : How to change the hostname and/or port of the Database Tier
Note.341322.1 : How to change the hostname of an Apps Tier using AutoConfig
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 Exp/Imp Process for Oracle Applications Release 11i
Note.333785.1 : Oracle Applications Internationalization Guide
Note.343253.1 : Tns-12555, Tns-12560, Tns-00525, Linux Error : 1 Starting
Note.150168.1 : Obtaining Forms Runtime Diagnostics (FRD) In Oracle
Note.283225.1 : How to Recreate the Listener for Event and Listener for
Note.153960.1 : FAQ : X Server testing and troubleshooting
Note.337937.1 : Step By Step – 10gR2 RAC with ASM install on Linux(x86) –
Note.225456.1 : Troubleshooting Guide for Cloning Issues
Note.253763.1 : After Cloning on Target instance FRM-92050 Failed to
Note.189867.1 : Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102
Note.363759.1 : How To Add Diagnostic Tools To Responsibility Menu
RDBMS and E-Business Suite Installation and Configuration
*********************************************************
118218.1 11i. Installing a Digital Cerificate on both the Server and Client.
252217.1 Requirements for Installing Oracle 9iR2 on RHEL3
146469.1 Installation & Configuration of Oracle Login server & Portal3i
146468.1 Installation of Oracle9i Application Server(9iAS)
152775.1 XML gateway installation
165700.1 Multiple Jserv configuration
207159.1 Documentation of 9iAS
210514.1 Express Server WebIV Note numbers
170931.1 Notes on Motif troubleshooting
177610.1 Oracle Forms in Applications FAQ
258021.1 How to monitor the progress of a materialized view refresh (MVIEW)
330250.1 Tips & Tricks To Make Apache Work With Jserv
139684.1 Oracle Applications Current Patchset Comparison Utility – patchsets.sh
236469.1 Using Distributed AD in Applications Release 11.5.
96630.1 Cash Management Overview
233428.1 Sharing the Application Tier File System in Oracle Applications 11i
243880.1 Shared APPL_TOP FAQ
330250.1 Tips & Tricks To Make Apache Work With Jserv
241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment
209721.1 How to Change the Port Number on one Machine, When we Use Multiple Collaboration Suite Tiers
177377.1 How to change passwords in Portal (Database and lightweight user passwords)
304748.1 Internal: E-Business Suite 11i with Database FAQ
166213.1 SPFILE internals ** INTERNAL ONLY **
216208.1 Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release
11i Troubleshooting
*******************
186981.1 Oracle Application Server with Oracle E-Business Suite Release 11i
Physical Standby
*****************
Note:180031.1 Creating a Data Guard physical standby
Note:214071.1 Creating a Data Guard physical standby with Data Guard Manager
Note:232649.1 Configuring gap resolution
Note:232240.1 Performing a switchover
Note:227196.1 Performing a failover
Note:187242.1 Applying Patchsets with Physical Standby in Place
Logical Standby
****************
Note:186150.1 Creating a logical standby
Note:214071.1 Creating a logical standby with Data Guard Manager
Note:232240.1 Performing a switchover
Note:227196.1 Performing a failover
Note:233261.1 Tuning Log Apply Services
Note:215020.1 Troubleshooting Logical Standbys
Note:210989.1 Applying Patchsets with Logical Standby in Place
Note:233519.1 Known Issues with Logical Standby
Dataguard General Information
*****************************
Note:205637.1 Configuring Transparent Application Failover with Data Guard
Note:233509.1 Data Guard Frequently Asked Questions
Note:225633.1 Using SSH with 9i Data Guard
Note:233425.1 Top Data Guard Bugs
Note:219344.1 Usage, Benefits and Limitations of Standby RedoLogs
Note:201669.1 Setup and maintenance of Data Guard Broker using DGMGRL
Note:203326.1 Data Guard 9i Log Transportation on RAC
Note:239100.1 Data Guard Protection Modes Explained
Dataguard Configuration Best Practices
**************************************
Note:240874.1 Primary Site and Network Configuration Best Practices
Note:240875.1 9i Media Recovery Best Practices
Frequently Asked Questions
**************************
68993.1 Concurrent Managers on NT
1013526.102 Changing and Resetting Release 11 Applications Passwords
130608.1 ADPATCH BASICS
74924.1 ADI (Applications Desktop Integrator) Installation
61552.1 DIAGNOSING DATABASE HANGING ISSUES
114226.1 How to Set Up Apache and JSERV w/ Oracle XSQL, JSP, and Developer
146469.1 Installing and Configuring Oracle Login Server and Oracle Portal 3i with Oracle Applications 11i
146468.1 Installing Oracle9i Application Server 1.0.2.2.2 with Oracle Applications 11i
62463.1 Detailed Guide on How the Intelligent Agent Works
104452.1 Troubleshooting (Concurrent Manager Unix specific)
122662.1 How to change the hostname or domainname of your portal
231286.1 Configuring the Oracle Workflow 2.6 Java-based Notification Mailer with Oracle Applications 11i
230688.1 Basic ApacheJServ Troubleshooting with IsItWorking.class
204015.1 Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle8i EE
158818.1 Migrating the Workflow Mailer to the APPLMGR Account
185431.1 Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
177089.1 OAM11i Standalone Mode Setup and Configuration
172174.1 WF 2.6: Oracle Workflow Notification Mailer Architecture in Release 11i
166021.1 Oracle Applications Manager 11i – Pre-requisite Patches
166115.1 Oracle Applications Manager 11i integrated with Oracle Applications 11i
165041.1 Generic Service Management Functionality
204090.1 Generic Service Management Configuration using Applications Context Files
139863.1 Configuring and Troubleshooting the Self Service Framework with Oracle Applications (latest version)
187735.1 Workflow FAQ – All Versions
166830.1 Setting up Real Application Cluster (RAC) environment on Linux – Single node
158868.1 Step by Step, Oracle 9iAS Installation Process
123243.1 Scheduling Web Reports Via Oracle Reports Server CGI
165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
RMAN and Backup & Restore
**************************
60545.1 How to Extract Controlfiles, Datafiles, and Archived Logs from RMAN Backupsets
10gR2 Setup Installation, ASM,CRS, RAC , Troubleshooting
********************************************************
471165.1 Additional steps to install 10gR2 RAC on IBM zSeries Based Linux (SLES10)
407086.1 USING CLONING IN CRS/RAC WINDOWS ENVIRONMENTS TO ADD A NODE
414163.1 10gR2 RAC Install issues on Oracle EL5 or RHEL5 or SLES10 (VIPCA Failures)
467753.1 Veritas clusterware 5.0 not recognized by Oracle due to the fact that Veritas
467176.1 RAC: Installing RDBMS Oracle Home Hangs The Oui
466975.1 Step to remove node from Cluster when the node crashes due to OS or H/w
330358.1 CRS 10g R2 Diagnostic Collection Guide
401132.1 How to install Oracle Clusterware with shared storage on block devices
392207.1 CSSD Startup fails with NSerr (12532,12560) transport:(502,0,0) during Install
333166.1 CSSD Startup Fails with NSerr (12546,12560) transport:(516,0,0) During install
330929.1 CRS Stack Fails to Start After Reboot ORA-29702 CRS-0184
463255.1 Enable trace for gsd issues on 10gR2 RAC
338924.1 CLUVFY Fails With Error: Could not find a suitable set of interfaces for VIPs
462616.1 Reconfiguring the CSS disktimeout of 10gR2 Clusterware for Proper LUN Failover
461884.1 How To Disable Fatal Mode Oprocd On HP-UX Itanium 10gR2
404474.1 Status of Certification of Oracle Clusterware with HACMP 5.3 & 5.4
329530.1 Using Redhat Global File System (GFS) as shared storage for RAC
458324.1 Increased ‘Log File Sync’ waits in 10gR2
341214.1 How To clean up after a Failed (or successful) Oracle Clusterware Installation
454638.1 srvctl command failed – An unexpected exception has been detected in native
276434.1 Modifying the VIP or VIP Hostname of a 10g Oracle Clusterware Node
383123.1 PRKP-1001 CRS-215 srvctl Can not Start 2nd Instance
358620.1 How To Recreate Voting And OCR Disk In 10gR1/2 RAC
200346.1 RAC: Frequently Asked Questions
220970.1 RAC: Frequently Asked Questions
269320.1 Removing a Node from a 10g RAC Cluster
430266.1 How to install 10gR2 and 9iR2 on the same node with different UDLM requirement
283684.1 How to Change Interconnect/Public Interface IP Subnet in a 10g Cluster
391790.1 Unable To Connect To Cluster Manager Ora-29701
294430.1 CSS Timeout Computation in RAC 10g (10g Release 1 and 10g Release 2)
316583.1 VIPCA FAILS COMPLAINING THAT INTERFACE IS NOT PUBLIC
416868.1 CDMP DIRECTORIES AND TRW FILES ON RAC
414177.1 Executing root.sh errors with “Failed To Upg Oracle Cluster Registry Config
390483.1 DRM – Dynamic Resource management
390880.1 OCR Corruption after Adding/Removing voting disk to a cluster when CRS stack
309542.1 How to start/stop the 10g CRS ClusterWare
396643.1 CVU HAS INCORRECT ORA_CRS_HOME VARIABLE AFTER APPLYING CRS BUNDLE II
387205.1 The 10.1.0.4 DB Cannot Start With 10.2.0.2.0 CRS And ASM
270512.1 Adding a Node to a 10g RAC Cluster
395156.1 Startup (mount) of 2nd RAC instance fails with ORA-00600 [kccsbck_first]
363777.1 How to Completely Remove a Service so that its Service_id Can Be Reused
391112.1 Database Resource Manager Spins Lmon To 100% Of Cpu
365530.1 Permissions not set correctly after 10gR2 installation
357808.1 Diagnosability for CRS / EVM / RACG
284752.1 10g RAC: Steps To Increase CSS Misscount, Reboottime and Disktimeout
332180.1 ASMCMD – ASM command line utility
371434.1 Using Openfiler iSCSI with an Oracle database
338047.1 cluvfy ERROR: Unable to retrieve database release version
183408.1 Raw Devices and Cluster Filesystems With Real Application Clusters
367564.1 Server Reboots When Rolling Upgrading CRS(10gr1 -> 10gr2)
358545.1 Root.sh is failing with CORE dumps, during CRS installation
343092.1 How to setup Linux md devices for CRS and ASM
295871.1 How to verify if CRS install is Valid
331934.1 RAC Single Instance (ASM) startup fails with ORA-27300/ORA-27301/ORA-27302
341974.1 10gR2 RAC Scheduling and Process Prioritization
341971.1 10gR2 RAC GES Statistics
341969.1 10gR2 RAC OS Best Practices
341965.1 10gR2 RAC Reference
341963.1 10gR2 RAC Best Practices
313540.1 Manually running cvu to verify stages during a CRS/RAC installation
331168.1 Oracle Clusterware consolidated logging in 10gR2
339710.1 Abnormal Program Termination When Installing 10gR2 on RHAS 4.0
339383.1 CSSD FAILURE DOES NOT REBOOT THE NODE
337937.1 Step By Step – 10gR2 RAC with ASM install on Linux(x86) – Demo
280209.1 10g RAC Performance Best Practices
CLONING
*********
216664.1 FAQ: Cloning Oracle Applications Release 11i
230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
135792.1 Cloning Oracle Applications Release 11i
Discoverer
************
139516.1 Discoverer 4i with Oracle Applications 11i
257798.1 Discoverer 10g (9.0.4) with Oracle Applications 11i
139516.1 Installation of Discoverer 4i
AutoConfig
************
165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
218089.1 Autoconfig FAQ
Real Application Clusters(RAC)
*******************************
181503.1 Real Application Clusters Whitepapers (OTN)
280209.1 10g RAC Performance Best Practices (INTERNAL ONLY)
302806.1 IBM General Parallel File System (GPFS) and Oracle RAC on AIX 5L and IBM eServer pSeries
270512.1 Adding a Node to a 10g RAC Cluster
137288.1 Manual Database Creation in Oracle9i (Single Instance and RAC)
292776.1 10g RAC Lessons Learned
280216.1 10g RAC Reference (INTERNAL ONLY)
269320.1 Removing a Node from a 10g RAC Cluster
226561.1 9iRAC Tuning Best Practices (INTERNAL ONLY)
220178.1 Installing and setting up ocfs on Linux – Basic Guide
208375.1 How To Convert A Single Instance Database To RAC In A Cluster File System Configuration
255359.1 Automatic Storage Management (ASM) and Oracle Cluster File System (OCFS) in Oracle10g
341963.1 10gR2 RAC Best Practices (INTERNAL ONLY)
273015.1 Migrating to RAC using Data Guard
329530.1 Using Redhat Global File System (GFS) as shared storage for RAC
270901.1 How to Dynamically Add a New Node to an Existing 9.2.0 RAC Cluster
203326.1 Data Guard 9i Log Transportation on RAC
169539.1 A Short Description of HA Options Available in 9i
160120.1 Oracle Real Application Clusters on Sun Cluster v3
226569.1 9iRAC Most Common Performance Problem Areas (INTERNAL ONLY)
251578.1 Step-By-Step Upgrade of Oracle Cluster File System (OCFS v1) on Linux
247135.1 How to Implement Load Balancing With RAC Configured System Using JDBC
139436.1 Understanding 9i Real Application Clusters Cache Fusion
285358.1 Creating a Logical Standby from a RAC Primary Using a Hot Backup
222288.1 9i Rel 2 RAC Running on IBM’s General Parallel File System
226567.1 9iRAC Related Init.ora Parameters (INTERNAL ONLY)
210889.1 RAC Installation with a NetApp Filer in Red Hat Linux Environment
341965.1 10gR2 RAC Reference (INTERNAL ONLY)
341969.1 10gR2 RAC OS Best Practices (INTERNAL ONLY)
226566.1 9iRAC Related Latches (INTERNAL ONLY)
220970.1 RAC: Frequently Asked Questions
268202.1 Dynamic node addition in a Linux cluster
285455.1 HOW TO MAKE AN EXCLUSIVE INSTANCE AVAILABLE ON MULTIPLE CLUSTER NODES.
332257.1 Using Oracle Clusterware with Vendor Clusterware FAQ
245079.1 Steps to clone a 11i RAC environment to a non-RAC environment
235158.1 How To Enable/Disbale Archive Log Mode on Oracle9i Real Application Cluster
210022.1 How To Add A New Instance To The Existing Two Nodes RAC Database Manually
317516.1 Adding and Deleting a Cluster Node on 10gR2 / Linux
271685.1 How to Run Autoconfig for RAC Environment on Apps Tier Only
278816.1 How to Setup Parallel Concurrent Processing using Shared APPL_TOP for RAC Environment
334459.1 How to change hostname in RAC environment
250378.1 Migrating Applications 11i to use Oracle9i RAC (Real Application Clusters).
295998.1 How to solve corruptions on OCFS file system
345081.1 How to Rename a RAC Database in a 10g Real Application Clusters Environment
312051.1 How To Remove Ocfs From Linux Box.
PORTAL
*******
228516.1 How to copy (export/import) Portal database schemas of IAS 9.0.2 to another database
330391.1 How to copy (export/import) Portal database schemas of IAS 10.1.2 to another database
UPGRADES
*********
125767.1 Upgrading Devloper6i with Oracle Applications 11i
216550.1 RDBMS upgrade to 9.2.0
161779.1 Upgradation of HTTP Server
212005.1 Upgrade Oracle Applications to 11.5.8
139863.1 Self Servie Framework Upgrade
112867.1 Express Server & OFA upgrade
124606.1 Jinitiator upgrade
130091.1 JDK upgrade to 1.3
130091.1 Upgrading Oracle Applications 11i to use JDK 1.3
144069.1 Upgrading to Workflow 2.6 with Oracle Applications 11i
159657.1 Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9i
EXPORT / IMPORT
***************
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 277650.1 – How to Use Export and Import when Transferring Data Across Platforms or Acros…
Note 243304.1 – 10g: Transportable Tablespaces Across Different Platforms
Note 341733.1 – Export/Import DataPump Parameters INCLUDE and EXCLUDE – How to Load and Unload..

Thanks
Srini