Sanjay Forum

Patch Installation Steps: ------------------------- 1. Set your current directory to the directory where the patch is located. cd /6196748 2. Apply the patch. Use the following command to apply the patch to the ORACLE_HOME: opatch apply export PATH=$PATH:/usr/ccs/bin 1.Determine whether any currently installed one-off patches conflict with the PSU patch as follows: unzip p12419397_10204_Linux-x86-64.zip opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./12419397 The report will indicate the patches that conflict with PSU 12419397 and the patches for which PSU 12419397 is a superset. 2.Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands: unzip p12419397_10204_Linux-x86-64.zip cd 12419397 opatch apply 3.For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows: cd $ORACLE_HOME/rdbms/...

Maintenance Mode is a new mode of operation introduced with Release 11.5.10, in which the Oracle Applications system is made accessible only for patching activities not allowing the users to login to any responsibility. This provides optimal performance for AutoPatch sessions, and minimizes downtime needed. 1. Scheduling System Downtime Administrators can schedule 'System Downtime' using Oracle Applications Manager (OAM): Site Map --> Maintenance --> Manage Downtime Schedules When the System has been scheduled for 'Downtime', Apache should be re-started on Restricted Mode by using the Script (adaprstctl.sh). By doing this, users attempting to log on to Oracle Applications will be automatically redirected to a System Downtime URL showing a message similar to the following one: Scheduled Downtime Details Start Time : 17:30:00 12/11/2004 Expected Up Time : 09:00:00 12/12/2004 For Updates : famy2u@hotmail.com The system is currently undergoing a s...

The clone stage area contains all the cloning code required to run RapidClone and is created as follows Database Tier: $ORACLE_HOME/appsutil/clone Applications Tier: $COMMON_TOP/clone This contains the following directories and scripts : bin directory containing the configuration scripts for use on the target system: adclone.pl - the main cloning script adcfgclone.pl - used to configure the Target system, this calls adclone.pl adclonectx.pl - used to clone a Source XML file manually adchkutl.sh - checks for existence of require O/S utils, cc, make, ar and ld adaddnode.pl (Applications Tier only) - used when adding an additional node to an existing system. This script is used to add a new row(representing the new node) to AD_APPL_TOPS to ensure the Patch History data is applicable to all existing and new nodes context directory containing the context file templates : CTXORIG.xml - a copy of the source context file, and is used during the creation the Target Context file $C...

Questions & Answers ------------------- 1) When applying patches, where should the patch files reside so that ADPATCH can find them? The patches can be copied anywhere as long as the environment is set correctly when executing ADPATCH. Usually, the patches are located in a directory under $APPL_TOP. 2) Which drivers should be run first? If they have been run in the wrong order can you run them again? Patches that begin with 'db??????.drv' are database drivers. Database drivers should always be run after the patch.drv driver. The patch.drv is a file system patch which is used to update the file system with new versions of certain files. When there is more than one 'db' driver, the readme.txt should provide information on the required sequence for application. If 'db' drivers are not run in the correct order, you may rerun them using the correct sequence. 3) What does ADPATCH actually do with a ...

1. Which products provide patch sets? Answer ------ For character mode, there are no patch sets. Development does, when warranted, create cumulative server patches, but you may request single patches. For GUI, however, patch sets exist today for several products including Payables, Purchasing, Receivables, Order Entry, Assets, Projects, Inventory, Sales and Marketing, Cash Management and MRP. Any product with modular interdependencies has the potential for a product patch set. 2. Why aren't one-off client side patches provided as they have been for the server side? Answer ------ Oracle Applications code is highly modular and interdependent. When a fix is made to a single file, that file may in turn be included in several other application files. On UNIX and VMS servers, Oracle would send one single patched file and relink all affected files. In a 16-bit SmartClient environment relinking on site is not an o...

Oracle Apps 11i to R12 Upgrade Please follow the attached doc in the following Link. http://www.4shared.com/document/Uj0mjnIj/11510_TO_R12__upgrade.html

Questions and Answers What is a "Shared APPL_TOP"? Answer: A traditional multi-node installation requires the Applications file system on each node in the system. In a Shared APPL_TOP installation, the APPL_TOP and the COMMON_TOP file systems are installed on a shared disk resource mounted to each node in the system. These nodes can be used to provide standard application tier services, such as Forms, Web, and Concurrent processing. Any changes made in the shared APPL_TOP file system are immediately visible on all nodes. Note that each node continues to have a separate Applications techstack installation (see also question 2). What is a "shared application tier file system"? Answer: In a shared application tier file system installation, the APPL_TOP, the COMMON_TOP, and the Applications technology stack (ORACLE_HOMEs) are installed on a shared disk resource mounted to each node in the system. These nodes can be used to provide standard appl...

################################################################ ShutDown: Prod: ALTER SYSTEM SET log_archive_dest_state_2=DEFER; DR: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; SHUT IMMEDIATE; ################################################################ StartUp: DR: STARTUP NOMOUNT ALTER DATABASE MOUNT STANDBY DATABASE ; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Prod: ALTER SYSTEM SET log_archive_dest_state_2=ENABLE; ################################################################

Activating the Standby Database - Failover Method In the event of a disaster on the primary machine, you need to make the standby database active as soon as possible. In this example, it is assumed that the primary database server is not available and that the standby database needs to be activated as the primary database immediately. The standby database will need to be activated in its current state - no other redo from the primary database will be applied as it is assumed to be down The steps involved are: 1. If the standby database is in a RAC environment, stop all but one instance. oracle $ srvctl stop instance -d database_name> -i instance_name 2. If the standby database is in managed recovery mode, it will need to be cancelled and the instance shutdown using the IMMEDIATE option: SQL> recover managed standby database cancel; Media recovery complete. SQL> shutdown immediate 3. Startup the instance and then MOUNT the DB in standby mode: SQL> connect / as sysdba Conn...

What is rconfig ? rconfig is a command line tool introduced in Oracle Database 10g R2 to convert Single-Instance 10g R2 Database to RAC(Real Application Cluster). The other option is to use Convert to RAC option on the single-instance database target of Oracle Enterprise Manager Grid Control. How does rconfig works ? rconfig is located at $ORACLE_HOME/bin/. rconfig takes in a xml input file and convert the Single Instance database whose information is provided in the xml.This tool is documented in the RAC Admin Guide and a sample xml can be found $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC.xml. rconfig performs following steps : Migrate the database to ASM storage (Only if ASM is specified as storage option in the configuration xml file above) Create Database Instances on all nodes in the cluster Configure Listener and NetService entries Configure and register CRS resources Start the instances on all nodes in the cluster. What are the prerequisites befo...