Upgrade OracleAS 10g Release 2 (10.1.2.2.0) for Forms and Reports to Patchset 3 (10.1.2.3.0)
Metalink Note ID Refered : ID 437878.1
1) Download latest certified OracleAS patchset and Oracle E-Business Suite Interoperability Patch
Download the latest certified OracleAS 10g patchset. In addition, you will need the E-Business Suite/Forms Interoperability patch corresponding to the OracleAS 10g patchset you are installing. The number for the interoperability patch is given in the right-hand column.
Oracle Application Server 10g Oracle Application Server 10g Patchset Oracle Forms Oracle Reports Oracle E-Business Suite Interoperability Patch
OracleAS Patchset 10.1.2.3.0 5983622 10.1.2.3.0 10.1.2.3.0 7120543
2) Download Additional Patches
Platform Nature of Patch Patch
Linux Forms - Java Patch 9044638
Linux Forms - Platform-Specific 7121788
Linux Forms - C Patch 6857221
Linux 4407272
Linux 4526825
Linux 7329300
Linux 8557019
Linux Reports - Platform-Specific 5705981
Linux 7230832
Linux Reports - C Patch 7016961
Linux 5917053
Linux 6371228
Linux Reports - Java Patch 7140392
Linux Reports - Generic Patch 8300196
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Back Up OracleAS 10.1.2 ORACLE_HOME and Inventory folder
Oracle recommends that you make a backup of your existing environment before you install Oracle Application Server 10g Release 2 patchset 3 (10.1.2.3.0).This will enable you to restore your original environment if you encounter a problem with application of the patch, or need to remove the patch for some reason.
You are also advised to take a complete backup of the Inventory folder (either global or local) that contains the OracleAS 10.1.2 ORACLE_HOME inventory details.
5) Install the Application Server Latest Certified Patchset (10.1.2.3.0)
The steps in this section will install the OracleAS 10g 10.1.2.3.0 patchset on all application tier nodes hosting Forms and Reports services.
Note: All references to "ORACLE_HOME" refer to the OracleAS 10.1.2 Oracle Home that contains the Forms and Reports 10g installation. Ensure that you are using same oraInventory that was created during Oracle E-Business Suite Release 12 installation.
Unzip the Patchset
Unzip patch 5983622 into a temporary directory.
Apply OracleAS 10g Release 2 Patchset 3 (10.1.2.3.0)
The following steps will apply the patchset.
Execute runInstaller
Execute runInstaller (UNIX) and choose "Oracle Application Server and Developer Suite 10g R2 Software Update 10.1.2.3.0" as the install option.
On Linux and UNIX:
If you have a Global Inventory, invoke the Installer by changing to the appropriate directory and running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the Installer by changing to the appropriate directory running the command:
$ ./runInstaller -invPtrLoc <1012_ORACLE_HOME>/oraInst.loc
Supply the ias_admin default password
Supply the ias_admin default password 'secret' when prompted.
Note: You may see failures while executing OC4J configuration assistant as part of post install configuration steps. Please select Next to skip the configuration assistant. This action will skip the remaining configuration assistants, which is expected for Oracle E-Business Suite customers.
Shut Down Services Started by OUI during 10.1.2.3 Patchset Installation
During OracleAS 10g patchset 10.1.2.3 installation, Oracle Universal Installer may have started some processes from the OracleAS 10.1.2 Oracle Home. Before proceeding further, ensure you shut down any processes started by the Installer.
Export ORACLE_HOME=<10.1.2 Oracle Home>
$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/bin/emctl stop iasconsole
Do not source the environment using any of the Applications environment files.
6) Install the Additional Patches
Use opatch to install each of the additional patches you downloaded earlier, in the same order as in the table, and following the instructions in the accompanying README. Use opatch version 1.0.0.0.57 or higher. You can download the latest version of opatch via patch 6880880.
7) Download and apply 10.1.0.5 RSF fixes
Note: You must select 10.1.0.5 from the Release dropdown list before downloading.
Download patch 3559326 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5394728 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5261796 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
8) Apply the Oracle E-Business Suite Release 12 Interoperability Patch
Before applying the patch, you must enable Maintenance Mode:
1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 1 (Enable Maintenance Mode)
Step 3.7.2: Apply the Oracle E-Business Suite/Forms Interoperability Patch
Apply the patch driver from the Interoperability patch using AutoPatch.
Step 3.7.3: Disable Maintenance Mode from adadmin
After applying the patch, disable Maintenance Mode:
1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 2 (Disable Maintenance Mode)
9) Redeploy the new Forms EAR file
Redeploy the formsapp.ear file by following the instructions given in OracleMetaLink Note 397174.1, "Deploying a New Forms EAR File in Oracle Applications Release 12".
10) Post-Installation Steps
Rebuild Forms and Reports executables
cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk install
cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install
Regenerate JAR files
Verify the JAR files have been rebuilt
Verify that the fndforms.jar & fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in $OA_JAVA/oracle/apps/fnd/jar directory.
Regenerate the JAR Files (if required)
If the timestamp is not current but the installation steps completed successfully, run the AD Administration Utility to regenerate the JAR files:
1. Run the AD Administration Utility (adadmin)
2. Select Generate Applications Files
3. Generate Product JAR Files
Note: Do not opt to force the regeneration of all JAR files.
Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking their timestamps again.
11) Start All Services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Verify the Upgrade
Log on to E-Business Suite as any user, launch any form, select "About Applications" from the Help menu, and confirm that the Forms version (under Forms Server) shows as 10.1.2.3.0.
Run Forms compiler
Run the following command to display various component versions, and confirm that the Forms version shows as 10.1.2.3.0. This command requires the DISPLAY environment variable to be set correctly.
$ORACLE_HOME/bin/frmcmp help=y
Monday, 18 January 2010
Upgrade OracleAS 10g Release 3 (10.1.3.3.0) to Patchset 5 (10.1.3.5)
Upgrade OracleAS 10g Release 3 (10.1.3.3.0) to Patchset 5 (10.1.3.5)
Metalink Note ID Refered : ID 454811.1
1) Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)
Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 from Metalink
2) Download Environment Preparation Patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0
Download patch 8920270 from Metalink
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Take a Backup of the Oracle E-Business Suite Release 12 10.1.3 Oracle Home and Inventory
System administrators are strongly advised to take complete backup of the 10.1.3 Oracle Home and the Global Inventory before
executing these procedures.
In the event of failure, you can restore the Oracle Home and the Inventory before attempting to re-apply the patchset.
Global Inventory on all LINUX platforms are specified in file 'oraInst.loc' which should be present in /etc
If file 'oraInst.loc' does not exist at the above default location, it gets created under each ORACLE_HOME.
Check the value of "inventory_loc" in file oraInst.loc for the global inventory location.
5) Apply OracleAS 10g Release 3 (10.1.3.0) Patch Set 5 (10.1.3.5.0)
6) Set Your Environment to 10.1.3 ORACLE_HOME
Log in to the application tier as the OS user who owns the application tier file system.
Navigate to the /ora/10.1.3 and source the .env file to set your 10.1.3 ORACLE_HOME.
7) Apply OracleAS 10.1.3.5 Patch Set
1. Unzip patch 8626084 (OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into a temporary directory ( )
2. Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into alternative temp directory.
Follow the patch readme (perform steps 1, 2 and 3 only), then:
3. Change directory to /Disk1
4. Execute runInstaller
On UNIX and Linux:
If you have a Global Inventory, invoke the runInstaller program by running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the runInstaller program by running the command:
$ ./runInstaller -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc
Note: During the Installation, OUI may display the following warning messages.
1) Ensure that all OC4J instances are up and running prior to applying this patch.
2) At this time, Oracle Application Tier will be shut down. There will be a brief pause in the installer when the application tier processes are stopped.
Click the 'OK' button to proceed with the installation.
"Provide the Release 12 10.1.3 Oracle Home Name and Path as a value in 'Name' and 'Path' field of 'Destination region'. If you set the Release 12 10.1.3 Oracle Home properly, you will see Oracle Home name in the drop down list of 'Name' field.
Enter the user password for the OracleAS 10g 10.1.3 instance that is being patched. If you are upgrading from OracleAS 10g 10.1.3.0, the default password is 'secret'. Otherwise the default password is 'oafm', if it was not changed after Release 12 installation. Proceed to the end of the installation."
8) Shut Down Any Services Started by OUI during 10.1.3.5 Patch Set Installation
During 10.1.3.5 patchset installation, Oracle Universal Installer may have started some process from the OracleAS Oracle Home.
Before proceeding further, shut down any processes started by the installer.
9) Run AutoConfig
Run Autoconfig on Application Tier Node Only
10) Post-Installation Tasks (Regenerate appsborg.zip and appsborg2.zip files)
Run adadmin & choose Generate product JAR files (with NO force option) to generate the appsborg.zip and appsborg2.zip files.
11) Verify the OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Installation
To check the status of the patchset install, perform the following steps:
1. Invoke runInstaller from <1013_ORACLE_HOME>/oui/bin (on UNIX and Linux) or setup.exe (on Windows).
2. Click on Installed Products.
3. Select 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server Patchset 10.1.3.5 patch in the list.
Alternatively:
1. Run the command 'opatch lsinventory -detail'
2. Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show 10.1.3.5.0.
12) Start Application tier services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Metalink Note ID Refered : ID 454811.1
1) Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)
Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 from Metalink
2) Download Environment Preparation Patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0
Download patch 8920270 from Metalink
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Take a Backup of the Oracle E-Business Suite Release 12 10.1.3 Oracle Home and Inventory
System administrators are strongly advised to take complete backup of the 10.1.3 Oracle Home and the Global Inventory before
executing these procedures.
In the event of failure, you can restore the Oracle Home and the Inventory before attempting to re-apply the patchset.
Global Inventory on all LINUX platforms are specified in file 'oraInst.loc' which should be present in /etc
If file 'oraInst.loc' does not exist at the above default location, it gets created under each ORACLE_HOME.
Check the value of "inventory_loc" in file oraInst.loc for the global inventory location.
5) Apply OracleAS 10g Release 3 (10.1.3.0) Patch Set 5 (10.1.3.5.0)
6) Set Your Environment to 10.1.3 ORACLE_HOME
Log in to the application tier as the OS user who owns the application tier file system.
Navigate to the /ora/10.1.3 and source the .env file to set your 10.1.3 ORACLE_HOME.
7) Apply OracleAS 10.1.3.5 Patch Set
1. Unzip patch 8626084 (OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into a temporary directory ( )
2. Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into alternative temp directory.
Follow the patch readme (perform steps 1, 2 and 3 only), then:
3. Change directory to /Disk1
4. Execute runInstaller
On UNIX and Linux:
If you have a Global Inventory, invoke the runInstaller program by running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the runInstaller program by running the command:
$ ./runInstaller -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc
Note: During the Installation, OUI may display the following warning messages.
1) Ensure that all OC4J instances are up and running prior to applying this patch.
2) At this time, Oracle Application Tier will be shut down. There will be a brief pause in the installer when the application tier processes are stopped.
Click the 'OK' button to proceed with the installation.
"Provide the Release 12 10.1.3 Oracle Home Name and Path as a value in 'Name' and 'Path' field of 'Destination region'. If you set the Release 12 10.1.3 Oracle Home properly, you will see Oracle Home name in the drop down list of 'Name' field.
Enter the
8) Shut Down Any Services Started by OUI during 10.1.3.5 Patch Set Installation
During 10.1.3.5 patchset installation, Oracle Universal Installer may have started some process from the OracleAS Oracle Home.
Before proceeding further, shut down any processes started by the installer.
9) Run AutoConfig
Run Autoconfig on Application Tier Node Only
10) Post-Installation Tasks (Regenerate appsborg.zip and appsborg2.zip files)
Run adadmin & choose Generate product JAR files (with NO force option) to generate the appsborg.zip and appsborg2.zip files.
11) Verify the OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Installation
To check the status of the patchset install, perform the following steps:
1. Invoke runInstaller from <1013_ORACLE_HOME>/oui/bin (on UNIX and Linux) or setup.exe (on Windows).
2. Click on Installed Products.
3. Select 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server Patchset 10.1.3.5 patch in the list.
Alternatively:
1. Run the command 'opatch lsinventory -detail'
2. Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show 10.1.3.5.0.
12) Start Application tier services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Tuesday, 21 April 2009
Upgrade EBS database 9.2.0.6 to 10.2.0.4
1 Latest Autoconfig patch 6372396
2 10g Operability patch 4653225
3 Developer 6i - Patchset 17
4 Installation of 10g software
5 Installation of 10g companion products
6 Installation of patchset 10.2.0.4 ( 6810189)
7 Run 10g preupgrade check file in 9i database ( utlu102i.sql ) and (utltzuv2.sql)
8 Fix the things as suggested by script ulu102i.sql
9 gather dictionary stats
10 Analyze dictionary objects for possible corruption
11 Create a list of invalid objects after running utlrp
12 Create a list of users having connect role
13 use $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory in 10g home
14 Copy and modify the init.ora file from 9i Oracle home to new 10g Oracle Home
15 Create SYSAUX Tablespace
16 Set environment for the new Database 10g
17 Cold backup of 9i database
18 Start 9i database from 10g Oracle Home in upgrade mode
19 run catupgrd.sql
20 run utlu102s.sql
21 run utlrp.sql
22 Apply the Patch 5005469, to fix the KOREAN_MORPH_LEXER
23 run adgrants.sql
24 run AD_TOP/patch/115/sql/adctxprv.sql as sqlplus apps/pwd @adctxprv.sql manager CTXSYS
25 Implement the changes to CONTEXT_FILE with respect to new Oracle Home
26 run adstats.sql in restrict mode
27 Re-create custom database links.
28 Re-create grants and synonyms.
29 Apply Oracle Receivables patch 5753621.
30 Start the Application Tier.
31 Gather Schema stats with 10% estimate
2 10g Operability patch 4653225
3 Developer 6i - Patchset 17
4 Installation of 10g software
5 Installation of 10g companion products
6 Installation of patchset 10.2.0.4 ( 6810189)
7 Run 10g preupgrade check file in 9i database ( utlu102i.sql ) and (utltzuv2.sql)
8 Fix the things as suggested by script ulu102i.sql
9 gather dictionary stats
10 Analyze dictionary objects for possible corruption
11 Create a list of invalid objects after running utlrp
12 Create a list of users having connect role
13 use $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory in 10g home
14 Copy and modify the init.ora file from 9i Oracle home to new 10g Oracle Home
15 Create SYSAUX Tablespace
16 Set environment for the new Database 10g
17 Cold backup of 9i database
18 Start 9i database from 10g Oracle Home in upgrade mode
19 run catupgrd.sql
20 run utlu102s.sql
21 run utlrp.sql
22 Apply the Patch 5005469, to fix the KOREAN_MORPH_LEXER
23 run adgrants.sql
24 run AD_TOP/patch/115/sql/adctxprv.sql as sqlplus apps/pwd @adctxprv.sql manager CTXSYS
25 Implement the changes to CONTEXT_FILE with respect to new Oracle Home
26 run adstats.sql in restrict mode
27 Re-create custom database links.
28 Re-create grants and synonyms.
29 Apply Oracle Receivables patch 5753621.
30 Start the Application Tier.
31 Gather Schema stats with 10% estimate
Upgrade Rel 10.2.0.3 – 12.0.4 Oracle Applications database to version 10.2.0.4
Upgrade Rel 10.2.0.3 – 12.0.4 Oracle Applications database to version 10.2.0.4
1.) Install Oracle database patch 10.2.0.4 (Time: 1 hour)
a. Create 10.2 stage directory, cd to Disk1 directory and execute ./runInstaller.
2.) Apply database patches to 10.2.0.4 home (Time: 1 hour)
a. 4247037
b. 6870937
c. 7014646
d. 8362683
e. 7411865
f. 7038750 --- only available for 64 bit OS
g. 5386204
h. 7197637
i. 7496435 – all the patches in this bundle patch are covered by 8362683
( Please check the below patches are not covered in 8362683 if not pl apply)
Note: - patch #7278117 which is a part of 8362683 was giving a following error while applying. It has a conflict with the patch 7014646. As patch #7014646 is mentioned in the interop doc 454750.1, I chose to install 7014646 over 7278117.
Error:-
The following warnings have occurred during OPatch execution:
1) OUI-67301:
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
7014646 7278117
4) Prepare DB for Upgrade (Time: 20 minutes)
a. Shutdown all application services
b. Verify that 10.2.0.3 database is defined in /var/opt/oracle/oratab file.
Upgrade database {Time: 2 Hrs)
c. Run dbua from 10.2.0 Oracle Home/bin directory.
i. Choose database to be upgraded
ii. Choose not to backup database.
Used catupgrd.sql to upgrade the database because DBUA screen was dead slow and not responding. After that I executed utlrp.sql for compiling the components.
Post Upgrade {Time: 2Hr}
d. Add 10gR3 release specific parameters to the init.ora file and remove obsolete parameters follow the doc 216205.1 -- None required
e. Run changeperm.sh from $ORACLE_HOME/install.
f. Select comp_name,version,status from dba_registry;
In the out put ,status of all components should be Valid. If there is any invalid check the note 565600.1
g. Run autoconfig on db.
h. Copy $APPL_TOP/admin/adstats.sql to $ORACLE_HOME/appsutil/admin directory.
i. Shutdown database and startup in restricted mode and run adstats.sql as sysdba. Then shutdown database again and startup in normal mode.(make sure we have atleast 1.5GB)
j. Start the new database listener.
k. select owner, table_name, stattype_locked from dba_tab_statistics
where stattype_locked is not null
If there are any schemas (which has tables with locked statistics)
other than SYS, SYSTEM execute
the following command:
exec dbms_stats.unlock_schema_stats('');
or exec dbms_stats.unlock_schema_stats ('&name');
l. Run Gather statistics on fixed tables using the below sql
exec dbms_stats.gather_fixed_objects_stats;
m. Run adadmin and run program “recreate grants and synonyms”.
n. Startup application services and test login.
o. Run Gather Schema Stats (timings are exclusive of this step )
References: Metalink Doc. 454750.1 and For issues 555579.1
1.) Install Oracle database patch 10.2.0.4 (Time: 1 hour)
a. Create 10.2 stage directory, cd to Disk1 directory and execute ./runInstaller.
2.) Apply database patches to 10.2.0.4 home (Time: 1 hour)
a. 4247037
b. 6870937
c. 7014646
d. 8362683
e. 7411865
f. 7038750 --- only available for 64 bit OS
g. 5386204
h. 7197637
i. 7496435 – all the patches in this bundle patch are covered by 8362683
( Please check the below patches are not covered in 8362683 if not pl apply)
Note: - patch #7278117 which is a part of 8362683 was giving a following error while applying. It has a conflict with the patch 7014646. As patch #7014646 is mentioned in the interop doc 454750.1, I chose to install 7014646 over 7278117.
Error:-
The following warnings have occurred during OPatch execution:
1) OUI-67301:
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
7014646 7278117
4) Prepare DB for Upgrade (Time: 20 minutes)
a. Shutdown all application services
b. Verify that 10.2.0.3 database is defined in /var/opt/oracle/oratab file.
Upgrade database {Time: 2 Hrs)
c. Run dbua from 10.2.0 Oracle Home/bin directory.
i. Choose database to be upgraded
ii. Choose not to backup database.
Used catupgrd.sql to upgrade the database because DBUA screen was dead slow and not responding. After that I executed utlrp.sql for compiling the components.
Post Upgrade {Time: 2Hr}
d. Add 10gR3 release specific parameters to the init.ora file and remove obsolete parameters follow the doc 216205.1 -- None required
e. Run changeperm.sh from $ORACLE_HOME/install.
f. Select comp_name,version,status from dba_registry;
In the out put ,status of all components should be Valid. If there is any invalid check the note 565600.1
g. Run autoconfig on db.
h. Copy $APPL_TOP/admin/adstats.sql to $ORACLE_HOME/appsutil/admin directory.
i. Shutdown database and startup in restricted mode and run adstats.sql as sysdba. Then shutdown database again and startup in normal mode.(make sure we have atleast 1.5GB)
j. Start the new database listener.
k. select owner, table_name, stattype_locked from dba_tab_statistics
where stattype_locked is not null
If there are any schemas (which has tables with locked statistics)
other than SYS, SYSTEM execute
the following command:
exec dbms_stats.unlock_schema_stats('
or exec dbms_stats.unlock_schema_stats ('&name');
l. Run Gather statistics on fixed tables using the below sql
exec dbms_stats.gather_fixed_objects_stats;
m. Run adadmin and run program “recreate grants and synonyms”.
n. Startup application services and test login.
o. Run Gather Schema Stats (timings are exclusive of this step )
References: Metalink Doc. 454750.1 and For issues 555579.1
Tuesday, 9 September 2008
De-Support of RAW devices in Release 12G.
METALINK Note:578455.1
Oracle Server - Enterprise Edition - Version: 12.0 to 12.0
Information in this document applies to any platform.
Oracle Database Server 12g (Not yet released)
De-Support of Raw
This document is to announce the de-support of raw devices in a future Oracle 12 g release. This means customers can no longer keep their datafiles, OCR or Voting disks on raw devices in Oracle 12g.
Oracle Server - Enterprise Edition - Version: 12.0 to 12.0
Information in this document applies to any platform.
Oracle Database Server 12g (Not yet released)
De-Support of Raw
This document is to announce the de-support of raw devices in a future Oracle 12 g release. This means customers can no longer keep their datafiles, OCR or Voting disks on raw devices in Oracle 12g.
Monday, 8 September 2008
Oracle DBA/ Oracle Apps DBA interview questions
1. What is oid.
2. What is ocr & voting disk. How you recovery in case of lost this.
3. How to recover pfile without alert file( no pfile, no spfile, no alert file)
4. What is log miner. New features of log miner.
5. Recovery catalog lost how you recover the database with rman.
6. What is sso. How to intergrate with 11i
7. Single node to multi node, vice versa cloning steps.
8. Discoverer upgrade from 4i to 10g.
9. Portal installation. How to intergrate with your internal application.
10. Recover datafile without downtime.
11. What is database replay.
12. What is cache fusion. How it works.
13. How to recover truncate table.
14. What are the new features between 10g & 11g.
15. Please tell the story behind hot backup.
16. How to add datafile while hot backup. Is it possible if yes then how to do it.
17. What is db file sequential read & db file scattered read.
18. How you improve patching performance 10 steps.
19. How to Upgrade 10gR2 database from 9.2.0.5 in EBS 11.5.9 or 11.5.10.2
20 How to apply 11.5.10.2 Maintenance Pack.
2. What is ocr & voting disk. How you recovery in case of lost this.
3. How to recover pfile without alert file( no pfile, no spfile, no alert file)
4. What is log miner. New features of log miner.
5. Recovery catalog lost how you recover the database with rman.
6. What is sso. How to intergrate with 11i
7. Single node to multi node, vice versa cloning steps.
8. Discoverer upgrade from 4i to 10g.
9. Portal installation. How to intergrate with your internal application.
10. Recover datafile without downtime.
11. What is database replay.
12. What is cache fusion. How it works.
13. How to recover truncate table.
14. What are the new features between 10g & 11g.
15. Please tell the story behind hot backup.
16. How to add datafile while hot backup. Is it possible if yes then how to do it.
17. What is db file sequential read & db file scattered read.
18. How you improve patching performance 10 steps.
19. How to Upgrade 10gR2 database from 9.2.0.5 in EBS 11.5.9 or 11.5.10.2
20 How to apply 11.5.10.2 Maintenance Pack.
METALINK BANK
Note 186981.1 Fequently asked questions
Note 233436.1 SSO/OID Installation Guide
Note 261914.1 SSO/OID Implementation Guide
Note 305918.1 Portal Installation Guide
Note 313418.1 Discoverer installation Guide
Note 207159.1 Documentation Roadmap
Note 223927.1 Statement of Direction
Note:228257.1 RMAN 'Duplicate Database' Feature in Oracle9i / Oracle 10G Note:228257.1
Note 259694.1 Oracle10G RMAN Database Duplication
Note 228257.1 RMAN Duplicate Database in Oracle9i
Note 73912.1 RMAN Creating a Duplicate Database -- Oracle8i
Note 153961.1 - Semaphores and Shared Memory - An Overview
Note.412264.1- How to Backup Partition of Range Partitioned Table with Local Indexes
Note 263599.1 - Understanding and Troubleshooting Instance Load Balancing
Note 262066.1 - How To Size UNDO Tablespace For Automatic Undo Management
Note 268870.1 - How to Shrink the datafile of Undo Tablespace
Note 206007.1 - How To Automate Cleanup Of Dead Connections And INACTIVE
Note 1029252.6 - How to Resize a Datafile
Note 199298.1 - Diagnosing excessive redo generation
Note 359266.1 - FAQ ASMLIB CONFIGURE,VERIFY, TROUBLESHOOT
Note 266028.1 - ASM Using Files Instead of Real Devices on Linux
Note.443835.1- ASM Fast Mirror Resync - Example To Simulate Transient Disk Failure And Restore Disk
Note.438580.1 - How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
Note.445037.1 - ASM Fast Rebalance
Note.429098.1- 11g ASM New Feature
Note.451900.1 - ASMCMD - New commands in 11g
Note.431143.1 - ‘WARNING- allocation failure on disk ‘ Messages In Asm Alert Log
Note.419014.1 - ORA-15041 V$ASM_DISK Shows HUNG State for Dropped Disks
NOTE.345180.1 - How to duplicate a controlfile when ASM is involved
Note 158577.1 - NLS_LANG explained
Note 179133.1 - Windows NLS_LANG
Unix NLS_LANG - Metalink doc: 264157.1
Note 340512.1 - Timestamps and time zones - Frequently Asked Questions
Note 227338.1- Character Set Scanner - Frequently Asked Questions
Note 119164.1 - Changing Database Character Set - Valid Superset Definitions
Note 226692.1- Finding out your NLS Setup
Note 264157.1- The correct NLS_LANG setting in Unix Environments
Note 227338.1 - Character Set Scanner - Frequently Asked Questions
Internal Error – ORA-600/ORA -7445
Note 403747.1 - FAQ Physical Corruption
Note: 260459.1 - How to Analyze Problems Related to Internal Errors (ORA-600) and Core Dumps (ORA-7445) using Metalink
Note 41634.1 - Tkprof Simplistic Overview
Note 46234.1- Interpreting Explain planNote 22908.1 - What are Latches and What Causes Latch Contention
NOTE.228913.1- Systemwide Tuning using STATSPACK Reports
NOTE.164504.1- How to Check Why Shutdown Immediate Hangs?
Note 375935.1 - What To Do and Not To Do When ’shutdown immediate’ Hangs
NOTE.35934.1- Cost Based Optimizer - Common Misconceptions and Issues
Note 62365.1 - What to do with “ORA-60 Deadlock Detected” Errors
Note 203238.1- Using Parallel Execution
Note 377847.1- Unsafe Peeked Bind Variables and Histograms
Note 462072.1- File System’s Buffer Cache versus Direct I/O
Note 147468.1 - Checkpoint Tuning and Troubleshooting Guide
Note.458881.1 -Killed Session Hung Consuming 100% CPU
Note.468740.1 - “Pmon Failed To Acquire Latch” Messages in Alert Log -Database Hung
Note.430555.1 - Database Hung With “kksfbc child completion” and “Cursor- Pin X” Waits
NOTE.215858.1- Interpreting HANGANALYZE trace files to diagnose hanging
Note 396940.1- FAQ: ORA-4031
Note.443746.1- Automatic Memory Management(AMM) on 11g
Note 223730.1- Automatic PGA Memory Managment in 9i
Note 220970.1- RAC: Frequently Asked Questions
Note 374540.1 - Quick Guide: How To Set Up Load Balancing
Note 244241.1 - Rolling Patch - OPatch Support for RAC
Note 262004.1 - Configuring RHEL 3 and Oracle 9iR2 32-bit with Hugetlb
Note 260152.1 - Summary About the Large SGA & Address Space on RH Linux
Note 226209.1 - Linux: How to Check Current Shared Memory, Semaphore Values
Note 37914.1 - Raw Devices and Oracle - 20 Common Questions and Answers
Note 110888.1 - How to Trace Unix System Calls
Note 293561.1 - Unix Commands on Different OS’s
Note 18089.1 - UNIX: Connect AS SYSBDA / SYSOPER Privilege on Oracle RDBMS
Note 291686.1 - White Paper on Logminer
Note 157250.1:Freelist Management with Oracle 8i
Note 291686.1 - LogMiner Utility Release 8.1.x - 10g
Note 161549.1 - Oracle Database Server and Networking Patches for Microsoft Platforms
Note 1020945.6 - How to Setup Auditing
Note 70679.1 - How to Audit Logon/Logoff Events with Triggers
Note 222807.1 - How To Audit GRANT ANY PRIVILEGE Or GRANT ANY ROLE
Note 340240.1 - “An Assessment of the Oracle Password Hashing Algorithm”
Note 316889.1 - Complete Checklist for Manual Upgrades to 10gR2
Note 359483.1 Upgrading 9.2.0.6 to 10.1.0.4.2 with 11.5.10.2 Applications
Note 282038.1 Oracle Applications Release 11i with Oracle Database 10g Release 1 (10.1.0)
Note:342035.1 How to Show the Patch History for Merged Patches in OAM Doc ID: Note:342035.1
Note:228779.1 How to Merge Patches Using admrgpch Note:228779.1
Note:432597.1 Reducing Down Time When Applying Patch for Oracle E-Business Applications 11i
Note:231701.1 How to Find Patching History (10.7, 11.0, 11i)
Note:235447.1 Application Install AutoPatch Setup Test
Note:139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh
Note:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note:362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note:216205.1 Database Initialization Parameters for Oracle Applications 11i
Note:362135.1 Configuring Oracle Applications 11i with 10g R2 RAC & ASM
Note:257798.1 Using Discoverer 10g with Oracle Applications 11i
Note:139516.1 Discoverer 4i with Oracle Applications 11i
Note:257613.1 How to check the Discoverer versions installed on UNIX platforms
Note:66698.1 How To Create a Discoverer Desktop, Plus or Viewer Debug Trace For All Platforms
Note:118360.1 How To Configure MS Internet Explorer To Use Jinitiator with Discoverer Plus
Note Id:285267.1 Oracle E-Business Suite 11i and Database FAQ
Note Id:177610.1 Oracle Forms in Applications FAQ
Note Id:216664.1 FAQ: Cloning Oracle Applications Release 11i
Note Id:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
Note Id:364565.1 Troubleshooting RapidClone issues with Oracle Applications 11i
Note Id:398619.1 Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
Note Id:186981.1 Oracle Application Server with Oracle E-Business Suite Release 11i FAQ
Note Id:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note Id:295606.1 Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting
Note Id:218089.1 Autoconfig FAQ
Note Id:315674.1 How To Verify if Autoconfig is Enabled on 11.5.x
Note Id:165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
Note Id:341322.1 How to change the hostname of an Applications Tier using AutoConfig
Note Id:270519.1 Customizing an AutoConfig Environment
Note Id:362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note Id:220970.1 RAC: Frequently Asked Questions
Note Id:294652.1 E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
Note Id:312731.1 Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM
Note Id:287176.1 DMZ Configuration with Oracle E-Business Suite 11i
Note Id:377856.1 DMZ Reverse Proxy and Middle Tier In Different Domains
Note Id:123718.1 11i: A Guide to Understanding and Implementing SSL for Oracle Applications
Note Id:340178.1 Enabling SSL with Oracle Application Server 10g and the E-Business Suite
Note Id:243880.1 Shared APPL_TOP FAQ
Note Id:233428.1 Sharing the Application Tier File System in Oracle Applications 11i
Note Id:174436.1 Oracle Applications Patching FAQ
Note Id:224875.1 Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)
Note Id:139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh
Note Id:374915.1 HRMS PATCH INSTALL FAQ
Note Id:130608.1 ADPATCH BASICS
Note Id:314540.1 What Log Files are Generated with Adpatch, and Where are They Located?
Note Id:229423.1 Troubleshooting adpatch complaining of apps.zip existence issues
Note Id:136342.1 How To Apply a Patch in a Multi-Server Environment
Note Id:69336.1 Basic information about Concurrent Managers
Note Id:105133.1 Concurrent Manager Questions and Answers Relating to Generic Platform
Note Id:241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment
Note Id:210062.1 Generic Service Management (GSM) in Oracle Applications 11i
Note Id:189487.1 System Administration FAQ's
Note Id:342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)
Note Id:104531.1 Troubleshooting (Report Review Agent)
Note Id:305918.1 Using Oracle Portal 10g with Oracle E-Business Suite 11i
Note Id:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note Id:114534.996 OFA Single Sign-on through Apps 11i
Note Id:295606.1 Troubleshooting SSO with Oracle Applications
Note 233436.1 SSO/OID Installation Guide
Note 261914.1 SSO/OID Implementation Guide
Note 305918.1 Portal Installation Guide
Note 313418.1 Discoverer installation Guide
Note 207159.1 Documentation Roadmap
Note 223927.1 Statement of Direction
Note:228257.1 RMAN 'Duplicate Database' Feature in Oracle9i / Oracle 10G Note:228257.1
Note 259694.1 Oracle10G RMAN Database Duplication
Note 228257.1 RMAN Duplicate Database in Oracle9i
Note 73912.1 RMAN Creating a Duplicate Database -- Oracle8i
Note 153961.1 - Semaphores and Shared Memory - An Overview
Note.412264.1- How to Backup Partition of Range Partitioned Table with Local Indexes
Note 263599.1 - Understanding and Troubleshooting Instance Load Balancing
Note 262066.1 - How To Size UNDO Tablespace For Automatic Undo Management
Note 268870.1 - How to Shrink the datafile of Undo Tablespace
Note 206007.1 - How To Automate Cleanup Of Dead Connections And INACTIVE
Note 1029252.6 - How to Resize a Datafile
Note 199298.1 - Diagnosing excessive redo generation
Note 359266.1 - FAQ ASMLIB CONFIGURE,VERIFY, TROUBLESHOOT
Note 266028.1 - ASM Using Files Instead of Real Devices on Linux
Note.443835.1- ASM Fast Mirror Resync - Example To Simulate Transient Disk Failure And Restore Disk
Note.438580.1 - How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
Note.445037.1 - ASM Fast Rebalance
Note.429098.1- 11g ASM New Feature
Note.451900.1 - ASMCMD - New commands in 11g
Note.431143.1 - ‘WARNING- allocation failure on disk ‘ Messages In Asm Alert Log
Note.419014.1 - ORA-15041 V$ASM_DISK Shows HUNG State for Dropped Disks
NOTE.345180.1 - How to duplicate a controlfile when ASM is involved
Note 158577.1 - NLS_LANG explained
Note 179133.1 - Windows NLS_LANG
Unix NLS_LANG - Metalink doc: 264157.1
Note 340512.1 - Timestamps and time zones - Frequently Asked Questions
Note 227338.1- Character Set Scanner - Frequently Asked Questions
Note 119164.1 - Changing Database Character Set - Valid Superset Definitions
Note 226692.1- Finding out your NLS Setup
Note 264157.1- The correct NLS_LANG setting in Unix Environments
Note 227338.1 - Character Set Scanner - Frequently Asked Questions
Internal Error – ORA-600/ORA -7445
Note 403747.1 - FAQ Physical Corruption
Note: 260459.1 - How to Analyze Problems Related to Internal Errors (ORA-600) and Core Dumps (ORA-7445) using Metalink
Note 41634.1 - Tkprof Simplistic Overview
Note 46234.1- Interpreting Explain planNote 22908.1 - What are Latches and What Causes Latch Contention
NOTE.228913.1- Systemwide Tuning using STATSPACK Reports
NOTE.164504.1- How to Check Why Shutdown Immediate Hangs?
Note 375935.1 - What To Do and Not To Do When ’shutdown immediate’ Hangs
NOTE.35934.1- Cost Based Optimizer - Common Misconceptions and Issues
Note 62365.1 - What to do with “ORA-60 Deadlock Detected” Errors
Note 203238.1- Using Parallel Execution
Note 377847.1- Unsafe Peeked Bind Variables and Histograms
Note 462072.1- File System’s Buffer Cache versus Direct I/O
Note 147468.1 - Checkpoint Tuning and Troubleshooting Guide
Note.458881.1 -Killed Session Hung Consuming 100% CPU
Note.468740.1 - “Pmon Failed To Acquire Latch” Messages in Alert Log -Database Hung
Note.430555.1 - Database Hung With “kksfbc child completion” and “Cursor- Pin X” Waits
NOTE.215858.1- Interpreting HANGANALYZE trace files to diagnose hanging
Note 396940.1- FAQ: ORA-4031
Note.443746.1- Automatic Memory Management(AMM) on 11g
Note 223730.1- Automatic PGA Memory Managment in 9i
Note 220970.1- RAC: Frequently Asked Questions
Note 374540.1 - Quick Guide: How To Set Up Load Balancing
Note 244241.1 - Rolling Patch - OPatch Support for RAC
Note 262004.1 - Configuring RHEL 3 and Oracle 9iR2 32-bit with Hugetlb
Note 260152.1 - Summary About the Large SGA & Address Space on RH Linux
Note 226209.1 - Linux: How to Check Current Shared Memory, Semaphore Values
Note 37914.1 - Raw Devices and Oracle - 20 Common Questions and Answers
Note 110888.1 - How to Trace Unix System Calls
Note 293561.1 - Unix Commands on Different OS’s
Note 18089.1 - UNIX: Connect AS SYSBDA / SYSOPER Privilege on Oracle RDBMS
Note 291686.1 - White Paper on Logminer
Note 157250.1:Freelist Management with Oracle 8i
Note 291686.1 - LogMiner Utility Release 8.1.x - 10g
Note 161549.1 - Oracle Database Server and Networking Patches for Microsoft Platforms
Note 1020945.6 - How to Setup Auditing
Note 70679.1 - How to Audit Logon/Logoff Events with Triggers
Note 222807.1 - How To Audit GRANT ANY PRIVILEGE Or GRANT ANY ROLE
Note 340240.1 - “An Assessment of the Oracle Password Hashing Algorithm”
Note 316889.1 - Complete Checklist for Manual Upgrades to 10gR2
Note 359483.1 Upgrading 9.2.0.6 to 10.1.0.4.2 with 11.5.10.2 Applications
Note 282038.1 Oracle Applications Release 11i with Oracle Database 10g Release 1 (10.1.0)
Note:342035.1 How to Show the Patch History for Merged Patches in OAM Doc ID: Note:342035.1
Note:228779.1 How to Merge Patches Using admrgpch Note:228779.1
Note:432597.1 Reducing Down Time When Applying Patch for Oracle E-Business Applications 11i
Note:231701.1 How to Find Patching History (10.7, 11.0, 11i)
Note:235447.1 Application Install AutoPatch Setup Test
Note:139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh
Note:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note:362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note:216205.1 Database Initialization Parameters for Oracle Applications 11i
Note:362135.1 Configuring Oracle Applications 11i with 10g R2 RAC & ASM
Note:257798.1 Using Discoverer 10g with Oracle Applications 11i
Note:139516.1 Discoverer 4i with Oracle Applications 11i
Note:257613.1 How to check the Discoverer versions installed on UNIX platforms
Note:66698.1 How To Create a Discoverer Desktop, Plus or Viewer Debug Trace For All Platforms
Note:118360.1 How To Configure MS Internet Explorer To Use Jinitiator with Discoverer Plus
Note Id:285267.1 Oracle E-Business Suite 11i and Database FAQ
Note Id:177610.1 Oracle Forms in Applications FAQ
Note Id:216664.1 FAQ: Cloning Oracle Applications Release 11i
Note Id:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
Note Id:364565.1 Troubleshooting RapidClone issues with Oracle Applications 11i
Note Id:398619.1 Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
Note Id:186981.1 Oracle Application Server with Oracle E-Business Suite Release 11i FAQ
Note Id:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note Id:295606.1 Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting
Note Id:218089.1 Autoconfig FAQ
Note Id:315674.1 How To Verify if Autoconfig is Enabled on 11.5.x
Note Id:165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
Note Id:341322.1 How to change the hostname of an Applications Tier using AutoConfig
Note Id:270519.1 Customizing an AutoConfig Environment
Note Id:362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note Id:220970.1 RAC: Frequently Asked Questions
Note Id:294652.1 E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
Note Id:312731.1 Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM
Note Id:287176.1 DMZ Configuration with Oracle E-Business Suite 11i
Note Id:377856.1 DMZ Reverse Proxy and Middle Tier In Different Domains
Note Id:123718.1 11i: A Guide to Understanding and Implementing SSL for Oracle Applications
Note Id:340178.1 Enabling SSL with Oracle Application Server 10g and the E-Business Suite
Note Id:243880.1 Shared APPL_TOP FAQ
Note Id:233428.1 Sharing the Application Tier File System in Oracle Applications 11i
Note Id:174436.1 Oracle Applications Patching FAQ
Note Id:224875.1 Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)
Note Id:139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh
Note Id:374915.1 HRMS PATCH INSTALL FAQ
Note Id:130608.1 ADPATCH BASICS
Note Id:314540.1 What Log Files are Generated with Adpatch, and Where are They Located?
Note Id:229423.1 Troubleshooting adpatch complaining of apps.zip existence issues
Note Id:136342.1 How To Apply a Patch in a Multi-Server Environment
Note Id:69336.1 Basic information about Concurrent Managers
Note Id:105133.1 Concurrent Manager Questions and Answers Relating to Generic Platform
Note Id:241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment
Note Id:210062.1 Generic Service Management (GSM) in Oracle Applications 11i
Note Id:189487.1 System Administration FAQ's
Note Id:342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)
Note Id:104531.1 Troubleshooting (Report Review Agent)
Note Id:305918.1 Using Oracle Portal 10g with Oracle E-Business Suite 11i
Note Id:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note Id:114534.996 OFA Single Sign-on through Apps 11i
Note Id:295606.1 Troubleshooting SSO with Oracle Applications
Subscribe to:
Posts (Atom)