Operating System - HP-UX
1753601 Members
7034 Online
108796 Solutions
New Discussion юеВ

db oracle in two nodes cluster

 
HPADM
Advisor

db oracle in two nodes cluster

Hi,
I have a cluster with two nodes and one package.
I have create the database from node A with control file and system datafile on the package.
Then I have copied the oratab, initshared.ora on node B.
I have tried to start oracle instance on node B.
Why doesn't it work?
I'm quite new to oracle?
Do I have to do something on node B before starting oracle.
The database is not in archivelog mode.
Thank you

4 REPLIES 4
HPADM
Advisor

Re: db oracle in two nodes cluster

I forgot to say that from node A it works fine
Brian Crabtree
Honored Contributor

Re: db oracle in two nodes cluster

Hmmm. Most likely, you do not have your volume groups mounted correctly on your secondary system. I can list out the commands needed, however they will need to be modified for your enviroment.

On your nodeA:

For each volume group, you will need to run the following commands:

# You want the minor number for this group
ll /dev//group
vgchange -a n /dev/
vgexport -s -p -v -m .map /dev/
vgchange -S y -c y /dev/
vgchange -a s /dev/

You will need to copy the .map files to nodeB.

On your nodeB (for each volume group):

mkdir /dev/
mknod /dev//group c 64 <# step 1 above>
vgimport -s -p -v -m .map /dev/
vgchange -a s /dev/

You might be able to get better information from Oracle on how this should be built. You will need to verify that the cluster software (MC/Serviceguard OPS edition) is installed, and you need to make sure that the DLM is configured correctly. I wouldn't recommend attempting to build an OPS cluster without training in Oracle administration basics, and I would suggest getting a book or taking a class on OPS administration as well.

Brian
Karthik S S
Honored Contributor

Re: db oracle in two nodes cluster

Hi

follow this thread in which we had some similar discussions ...

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x95ab3a1c04ffd61190050090279cd0f9,00.html

Karthik

Do or Die
For a list of all the ways technology has failed to improve the quality of life, please press three. - Alice Kahn
V. V. Ravi Kumar_1
Respected Contributor

Re: db oracle in two nodes cluster

hi,
on the node B, u should have all the directories which are specified in init.ora. also the directories related to VG in /dev should have 777 permissions. if the datafile and controlfile are on raw slices they also should have 666 permissions. Before actually test this thorough Fail Over, first test with manual vgchange.

regds
Never Say No