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.
Tuesday, 9 September 2008
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)