Saturday, 1 December 2012

Important Oracle Support Notes.

Some of the important MOS Notes.

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;


To BottomTo Bottom


To BottomTo Bottom

No comments:

Post a Comment