How To Diagnose
Components With NON VALID Status In DBA_REGISTRY After an Upgrade [ID
753041.1] Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration (Doc ID |
How do you manually install/deinstall Oracle Workspace Manager [ID 731576.1] |
11gR2 Clusterware and Grid Home - What
You Need to Know [ID 1053147.1] How to Configure GoldenGate Extract When Adding or Removing Redo Log Threads in an Oracle RAC ? (Doc ID 1267901.1) DNS and DHCP Setup Example for Grid Infrastructure GNS (Doc ID 946452.1) How to Setup SCAN Listener and Client for TAF and Load Balancing [Video][Article ID 1188736.1] How To Convert an 11gR2 GNS Configuration To A Standard Configuration Using DNS Only[Article ID 1489121.1] 11gR2 RAC: How to re-install the Grid Infrastructure without disturbing the RDBMS installations.[Article ID 1276975.1] NOTE:456021.1 - How to Reinstall CRS Without Disturbing Installed Oracle RDBMS Home(s)
DBFS (White Paper/Demo): How To Setup & Configure 11.2.0.X DBFS Filesystems On RAC Cluster Configurations (CRS Managed) On Linux. (Doc ID 1591515.1)
MOS Doc: How ToMove the Central Inventory to Another Location [299260.1] |
How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC [ID 284785.1] |
ORA-28002: the password will expire within days [ID 1064334.1] |
Manual installation, deinstallation and verification of Oracle Text 11gR2 [ID 970473.1] |
LogMiner Utility Release 8.1.x - 10g [ID 291686.1] - 300395.1 |
Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime. [ID 837308.1] |
Note:271196.1 Automatic SQL Tuning - SQL Profiles. |
How To Downgrade From Database 11.2 To Previous Release (includes 11.2.0.3-11.2.0.1) [ID 883335.1] |
How to Reload the JVM in 11.2.0.x [ID 1112983.1] |
Troubleshooting Oracle JVM [ID 1220993.1] |
RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) [Article ID 810394.1] |
How to Modify Public Network Information including VIP in Oracle Clusterware (Doc ID 276434.1) |
How To : How to Recreate OCR/Voting Disk Accidentally Deleted- [Article ID 399482.1] |
How to Modify Private Network Information in Oracle Clusterware (Doc ID 283684.1) |
How to restore ASM based OCR after complete loss of the CRS diskgroup on Linux/Unix systems [ID 1062983.1] |
How to Downgrade 11.2.0.3 Grid Infrastructure Cluster to Lower 11.2 GI or Pre-11.2 CRS [ID 1364946.1 |
1053147.1 - About 11gr2 cluster |
Things to Consider Before Upgrading to 11.2.0.2 Grid Infrastructure/ASM [ID 1312225.1]================== |
How To Downgrade From Database 11.2 To Previous Release (includes 11.2.0.3-11.2.0.1) [ID 883335.1] |
How to Add a New Node and/or RAC Instance to an Existing 10gR2 CRS/RAC System [ID 1076916.1] |
RAC and Oracle Cluster0. .....xmmxware Best Practices and Starter Kit (Platform Independent) [Article ID 810394.1] |
Oracle RACOne Node -- Changes in 11.2.0.2 [ID 1232802.1] |
[Article ID 1332452.1] |
10gR2, 11gR1 and 11gR2 Oracle Clusterware (CRS / Grid Infrastructure) & RAC Command (crsctl, srvctl, cluvfy etc) Syntax and Reference |
Package for disabling AWR without a Diagnostic Pack license in Oracle [ID 436386.1] |
11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained [ID 887522.1] |
step By Step Guide On How To Configure And Test Client-Failover For Dataguard Switchover And Failover. [ID 740029.1] |
http://www.oracle.com/technetwork/database/features/availability/oracle-database-maa-best-practices-155386.html |
RAC and Oracle Clusterware Best Practices and Starter Kit (Linux) [ID 811306.1] |
How To Reload the SYS.DBMS_STATS Package [ID 1310365.1] |
Problem : DBMS_STATS_INTERNAL Invalid upgrading to 11.2.0.2 or 11.2.0.3 |
NOTE:1050908.1 - Troubleshoot Grid Infrastructure Startup Issues |
NOTE:1053147.1 - 11gR2 Clusterware and Grid Home - What You Need to Know |
NOTE:1069369.1 - How to Delete or Add Resource to OCR |
NOTE:942166.1 - How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation |
NOTE:969254.1 - How to Proceed from Failed Upgrade to 11gR2 Grid Infrastructure on Linux/Unix |
Mount 10g Database reports error ORA-29701 when using ASM 11gR2 SIHA [ID 1061845.1] |
Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1] |
CRS-4665 Error while trying to pin node [ID 1299367.1] |
Linux: How to Configure the DNS Server for 11gR2 SCAN [ID 1107295.1] |
RAC and Oracle Clusterware Best Practices and Starter Kit (AIX) [ID 811293.1] |
My Oracle Support Note 1291877.1- patch availability |
How to Validate Network and Name Resolution Setup for the Clusterware and RAC [ID 1054902.1] |
Troubleshoot 11gR2 Grid Infrastructure/RAC Database runInstaller Issues [ID 1056322.1] |
Note 395525.1 How to Enable Oracle SQLNet Client, Server, Listener, Kerberos and External procedure Tracing from Net Manager. |
Ref: Why FRA Diskgroup Gets Mounted/Dismounted ? [ID 603204.1] |
. Please refer to note 603505.1 for the rest of available recordings |
WHEN AWR SNAPSHOTS ARE NOT GENERATED AUTOMATICALLY, HOW To DIAGNOSE. [ID 787409.1] |
WRH$_ACTIVE_SESSION_HISTORY Does Not Get Purged [ID 387914.1] |
10gR2, 11gR1 and 11gR2 Oracle Clusterware (CRS / Grid Infrastructure) & RAC Command (crsctl, srvctl, cluvfy etc) Syntax and Reference [ID 1332452.1] |
How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues [ID 376442.1] |
WARNING: Heavy Swapping Observed On
System In Last 5 Mins.After upgrade to 11.2.0.3 [ID 1452790.1] How to Modify SCAN Setting or SCAN Listener Port after Installation (Doc ID 972500.1) Linux: How to Configure the DNS Server for 11gR2 SCAN (Doc ID 1107295.1) How To Convert an 11gR2 GNS Configuration To A Standard Configuration Using DNS Only[Article ID 1489121.1
CTSSD Runs in Observer Mode Even Though No Time Sync Software is Running (Doc ID 1054006.1)
DNS and DHCP Setup Example for Grid Infrastructure GNS[Article ID 946452.1]
GNS configuration of RAC Database[Community Discussion ID 667324]
[Article ID 1264691.1] - exp/imp [Article ID 1264715.1] - datapump Oracle Server - Export and Import FAQ [ID 175624.1] Note:556636.1 "Oracle Server - Export Data Pump and Import DataPump FAQ" Configuring non-raw multipath devices for Oracle Clusterware 11g (11.1.0, 11.2.0) on RHEL5/OL5 [ID 605828.1] How To identify a 'corrupt' row when error is raised but no row information provided [ID 869305.1] Merged Incremental Backup Strategies [ID 745798.1] It is important that you read MetaLink Doc 415884.1, if you are performing a migration to a different platform with the same endian. Oracle suggests that you should perform a CONVERT DATABASE, but later admits that you only need to perform a CONVERT on tablespaces containing UNDO segments. how to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1] ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1] Master Note - Oracle GoldenGate [ID 1298817.1] Note:215187.1 SQLT (SQLTXPLAIN) - Tool that helps to diagnose SQL statements performing poorly (Doc ID 215187.1) Note:464246.1 - “Wait for stopper event to be increased” (http://srakwal.wordpress.com/2008/03/09/wait-for-stopper-event-to-be-increased/) Information On Installed Database Components and Schemas [ID 472937.1] How To Manually Install Data Mining In Oracle 11g? [ID 818314.1] How to Specify Hidden Hints (Outlines) on SQL Statements in Oracle 8i [ID 92202.1] Loading Hinted Execution Plans into SQL Plan Baseline.(787692.1) How to Enable USE_STORED_OUTLINES Permanently [ID 560331.1] How to Find out the Reason for PLS-00201 in PL/SQL[Article ID 269973.1] How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade[Article ID 753041.1] How to manage DB Control 11.x for RAC Database with emca [ID 578011.1] Oracle ASMLib Software Update Policy for Red Hat Enterprise Linux Supported by Red Hat (Doc ID 1089399.1) How To Rename A Diskgroup On ASM 11gR2?[Article ID 948040.1] Handling Block Corruptions in Oracle7 / 8 / 8i / 9i / 10g / 11g How to Add Node/Instance or Remove Node/Instance in 10gR2, 11gR1 and 11gR2 Oracle Clusterware and RAC [ID 1332451.1] How to Remove a Listener From CRS Using Netca in Silent Mode [ID 452485.1] Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64) [ID 1441282.1] Master Note: Troubleshooting Oracle Background Processes [ID 1509616.1] How to Diagnose Slow TNS Listener / Connection Performance [ID 557416.1] What to Do if 11gR2 Grid Infrastructure is Unhealthy [ID 1068835.1] High 'cursor: pin S wait on X' and/or 'library cache lock' Waits. Cause: Shared Pool/Buffer Cache Resize Activity [ID 742599.1] 10gR2, 11gR1 and 11gR2 Oracle Clusterware (CRS / Grid Infrastructure) & RAC Command (crsctl, srvctl, cluvfy etc) Syntax and Reference [ID 1332452.1] To Bottom http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/CLUSTER_23.shtml#Remove the Node to be Deleted from Oracle Clusterware undocumented parameter in 11g http://oracleinaction.blogspot.com/2013/01/parameters-in-oracle-11g-in-this-post-i.html 12c em installation http://www.oracle-base.com/articles/12c/cloud-control-12cr1-installation-on-oracle-linux-5-and-6.php Encrypt and decrypt data http://www.oracle-base.com/articles/8i/data-encryption.php http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1396058400346694178 http://arup.blogspot.com/2008/08/diagnosing-library-cache-latch.html Error faced while oem config http://taliphakanozturken.wordpress.com/tag/config-ora-01921-role-name-mgmt_user-conflicts-with-another-user-or-role-name/ Issues faced. CREATE INDEX <tablename> ON <Column Name> * ERROR at line 1: ORA-00600: internal error code, arguments: [smboPut:fixedlen2], [4], [7], [0], [8198014], [], [], [], [], [], [], [] Database Version: 11.2.0.3 RAC Workaround: Set following session level perameter alter session set "_newsort_enabled"=false; And recreate index. vktm Background process consumes high cpu Set the below parameter (11g) - Consult oracle support _disable_highres_ticks=false _timer_precision=900 Changing hint using outlines ================== - UPDATE OUTLN.OL$HINTS SET OL_NAME=DECODE(OL_NAME,'HINTSQL','ORIGINALSQL','ORIGINALSQL','HINTSQL') WHERE OL_NAME IN ('ORIGINALSQL','HINTSQL'); List all undocumented parameter:- SET linesize 235 col Parameter FOR a50 col SESSION FOR a28 col Instance FOR a55 col S FOR a1 col I FOR a1 col D FOR a1 col Description FOR a90 SELECT a.ksppinm "Parameter", decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl) "Session", c.ksppstvl "Instance", decode(p.isses_modifiable,'FALSE','F','TRUE','T') "S", decode(p.issys_modifiable,'FALSE','F','TRUE','T','IMMEDIATE','I','DEFERRED','D') "I", decode(p.isdefault,'FALSE','F','TRUE','T') "D", a.ksppdesc "Description" FROM x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter p WHERE a.indx = b.indx AND a.indx = c.indx AND p.name(+) = a.ksppinm AND UPPER(a.ksppinm) LIKE UPPER('%&1%') ORDER BY a.ksppinm; |
Saturday, 1 December 2012
Important Oracle Support Notes.
Some of the important MOS Notes.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment