What: I am seeing index contention in my RAC environment and want to convert the index into a reverse key index. Is this the best option to increase throughput and scale-ability? Answer: When there is contention due to inserting data which is monotonically increasing as when a sequence is used there are waits like block […]
When dropping an online disk from a diskgroup why is ORA-15067 error returned?
Question: When converting a non-RAC instance to a RAC instance I get the “ORA-29760 instance_number parameter not specified RAC” error. SQL> startup; ORA-29760: instance_number parameter not specified USER (ospid: 29871): terminating the instance due to error 29760 Instance terminated by USER, pid = 29871 How do I fix the ORA-29760 Error? Answer: The oerr utility […]
Ready to upgrade your Grid Infrastructure and RAC database to 12c? Make sure to go through the following items so that your upgrade does not fail.
A quick guide of Oracle 12c RAC Installation on your laptop running on Windows. A step by step guide to configure Oracle 12c Grid and the database Software.