Subscribe to Posts by Email

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Convert Single instance to rac to a different server

Convert Single Instance (ASM) to RAC Instance (ASM) to different Server

Assuming you have already the following environment setup and ready

    1. 11gr2 Clusterware is already installed on your target machine (XYZ)     2. Target xyz is configured with +DATA as diskgroup     2. Source ABC is having single instance in ASM […]

OEL 6.5 Kernel Not supporting to ACFS/ADVM

We have been running into issues in a training , that OEL 6.5 Kernel not shipped with ADVM/ACFS and deliberatly I have to get back to 6.3 or lesser kernel for 12c.

acfsload start -s gives the following error

acfs-9459: advm/acfs is not supported on this os version

Once I have installed the kernel 6.3 […]

CRS Startup : Oracle ORA-21561 : OID generation failed

After long time, I have been writing back now. I will running through a series of posts from now on Grid infrastructure issues.

The first one is Oracle ORA-21561 : OID generation failed

While starting crs / Adding the node the crs alert log will show the error Oracle ORA-21561 : OID generation failed

This […]

RACONENODE : convert your rac database to active/passive

Configuring RACONENODE in RAC database.

We all know that Oracle RAC is active/active configuration, but due to application compatibility (the design part like cache fusion incompatibilities etc) you will need to stick to active/passive configuration but you want High availability solution and you do not want to use any third party clustering like VCS, Answer […]

Step by Step Migrating RAC Database to a new Cluster

Excellent step by step document from my colleague, Venkat, with his kind permission I am publishing the same for all benefit.

Please note the following can be done using Duplicate database from active database without moving any backups etc. But that is another variant.

########################################################################################### Copy RAC database to another RAC Server ###########################################################################################

Task: Copy […]

12c: Step by Step 12c RAC DB Installation on Linux 64bit using Virtual Box

The first part I.e Grid Infrastructure (RAC) Installation is here

And the Final part You can download it from here

http://db.geeksinsight.com/wp-content/uploads/2013/07/Step-by-Step-Oracle-12c-RAC-Database-on-Linux-64bit.docx

-Thanks Geek DBA

An oldie: srvconfig 9i rac days, still useful in 11gr2

To Export cluster registry

    $srvconfig -exp file_name

To Import Cluster registry

    $srvconfig -imp file_name

To Upgrade the database cluster registry and database configuration

    $srvconfig -upgrade -dbname database_name -orahome oracle_homename

To Downgrade the database cluster registry and database configuration (This is rarely used in case of any […]

RAC: Recover lost voting and OCR Disks from backup

We have a lost voting disks issue yesterday, this occurs due to incorrect aliases or the device mapper persistent names have been changed after storage upgradation/migration.

CRS was not up and showing the error below Obviously the CSSD , cssd.log

No voting disks founds

So, we have lost the voting and OCR disks. […]

Quick Question: What happens when root.sh run in rac installation?

Hello,

I am bumped on the following to answer in a exact sequential way, hence want to note it here.

While in a rac installation, when you run root.sh , what are the sequence of actions that take place?

Node 1 Initial Setup Setup OLR for storing Oracle local registry data Setup GPnP wallet and […]

Installer has detected that the diskgroup name provided already exists on the system.

Hello,

After a failed crs installation, we have removed everything by using deconfigure and deinstall utility and freshly started the grid infrastruction installation, and we got this error

Checking Temp space: must be greater than 120 MB. Actual 2395 MB Passed Checking swap space: must be greater than 150 MB. Actual 32767 MB Passed […]