serviceGuard and oracle ODG

[Boerbokrib]

Hi

I have been asked to setup a package with oracle dataguard.

I have managed to install all the bits and pieces and made the package.

I can halt and start the package on the primary node no problems. It brings the database down and up.

When i try fail it over to the other node it does not work.

We have a primary node with primary ODG database. On the second node we have the standby ODG database that is being replicated to by the primary.

How do i get the package to swing to the second node and move the standby into primary odg database and the primary into standby mode?

I have attached my .conf file. i have enabled the standby paramter.

any help please.

[Stephen Doud]

There are 2 documents that may give you the help you need:

HP Serviceguard Toolkit for Oracle Data Guard 

> Using the Serviceguard Toolkit for Oracle Data Guard in an HP Serviceguard Cluster B.01.00, September 2010 (the README)

> Configuring HP Serviceguard Toolkit for Oracle Data Guard  (page 12 - Setting up the toolkit)

[Boerbokrib]

Hi

The second document is the one i used for the setup.

The first link throws an error.

The page you requested can not be found.

• If you typed the URL yourself, please make sure that the spelling is correct.
• If you clicked on a link to get here, there may be a problem with the link.
• Try using your browser's "back" button or the "return to previous page" link below to choose a different link on that page, or use search to find what you are looking for.

We apologize for the inconvenience!

[Dennis Handly]

>The first link throws an error.

It works for me in firefox and IE7.

[Boerbokrib]

Hi works in fire fox. Have seen those documents as well.

Just to clarify we have a node1 with its own eva and own data area with the primary database on the node1.

Via dataguard it replicates to node 2 with aits own eva and own data area with the standby database.

I need the package to to stop the primary database. start the standby database and then use the relocatable ip address.

I used the documents you have refered me to to do this. But i do not see the standby database being changed.

I can stop and start the package on node1 and it stops and starts the database.

However when i try to start it on node 2 it fails.

[Boerbokrib · Accepted solution]

Problem solved.

there was an entry in the /var/opt/oracle/oraInst.loc.

that had a hashed out entry. However this was not seen by the cluster scripts.

took out entry. so file looks like this.

inventory_loc=/orabin/oraInventory
inst_group=dba