Getting hold with Oracle Database 11gR2 RAC

Oracle Database 11gR2 MOS Notes Doc ID 1232802.1 RAC One — Changes in 11.2.0.2 Doc ID 1312225.1 Things to Consider Before Upgrade to 11.2.0.2 Grid Infrastructure Doc ID 1267828.1 SYS Password Management with RAC and Data Guard Doc ID 1276368.1 Complete checklist for out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2 Doc ID 341880.1 How to […]

Read the rest of this entry »

How to change ASM SYS Password and Creating SYSASM user 11g.

Things tried: SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We can not change the password for ASM databases via alter user command.Because passwords are managed through password file […]

Read the rest of this entry »

Tuning indexes on RAC environments-4

Excessive undo block shipment and contention for undo buffers I have seen this scenario in one my projects where  Oracle EBS workload is high. When a select statement needs to read a block with active transactions, it has to cleanout the block and undo the changes to create a CR version. If the active transactions […]

Read the rest of this entry »

Tuning indexes on RAC environments-3

Reversing the index key This is accomplished by executing the following SQL statement: ALTER INDEX <index_name> REBUILD REVERSE; A reverse key index will invert the bytes of the index key column, so that values originally stored in the same block may be spread across multiple index leaf blocks. That will reduce buffer busy contention especially […]

Read the rest of this entry »

Tuning indexes on RAC environments-1

Introduction and Significance of tuning indexes in RAC environments. Oracle E-Business environment with financial modules like AP and GL having large scale payment invoices transaction. Let me take example of one my public sector clients, they do process of 3 million payment instructions every night. Such most insert intensive applications running on RAC the frequency […]

Read the rest of this entry »

Index Performance Tuning Techniques for RAC

It’s been quite some time since my readers are requesting to see some posts on RAC performance tuning concepts and practices. In the process of testing some of the tuning techniques, as well as discussing and interpreting the results, I am preparing a four-day in depth session to understand index performance tuning techniques for RAC. […]

Read the rest of this entry »

Oracle Support – Useful Metalink References

Patch Set Updates for Oracle Products [ID 854428.1] Quick Guide to Avoid Issues in Creating DB Control Using EMCA [ID 750768.1] Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1] Oracle E-Business Suite Recommended Performance Patches [ID 244040.1] CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1] Cloning Oracle Applications Release 11i […]

Read the rest of this entry »

PeopleSoft on 10g RAC With ASM Best Practice Installation

Hardware and Software requirements (HP-UX 11i and Solaris 9.0) including the packages to be installed. Hardware Requirment:- RAM: – At least 1024 MB of physical RAM is required. SAT servers had 8GB of RAM. To check use the following command can be used. grep “Physical:” /var/adm/syslog/syslog.log Swap Configuration: – Between 512 MB and 2048 MB  […]

Read the rest of this entry »

How to alter Oracle Cluster Registry (OCR) and Voting Disk

ADD/REMOVE/REPLACE OCR Device Note: You must be logged in as the root user, because root own the OCR files. Make sure there is a recent copy of the OCR file before making any changes: ocrconfig –showbackup If there is not a recent backup copy of the OCR file, an export can be taken for the […]

Read the rest of this entry »

R12 RAC Cloning

RAC Cloning Details Note  : 559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems Patch : 5767290  : RAC-TO-RAC SUPPORT WITH RAPIDCLONE Supported Scenarios R12 Autoconfig Enabled on the dbTier and appsTier RAC conversion performed using on Note 388577.1. (This is the only RAC conversion method supported with Rapid Clone) […]

Read the rest of this entry »
|