Operating System - HP-UX
1748237 Members
3611 Online
108759 Solutions
New Discussion юеВ

Re: Oracle 9i RAC - Create User

 
Brian Crabtree
Honored Contributor

Re: Oracle 9i RAC - Create User

The other part of a RAC cluster is that (for HP-UX) the volume groups have to be in sync to be able to add a datafile to all of the instances. (A datafile can be added to a single instance, but will generate errors in the alertlog of the other instance, and will be unreadable).

This is not a simple process, and you should know a bit about Serviceguard clustering, volume group management, logical volume management, and Oracle administration before doing this.

Ok, there are some assumptions in this. First, you have a volume group created (vgdata) that does not have any logical volumes created, and is not currently active on any systems. Second, you have a cluster up and running.

1. vgchange -a y /dev/vgdata
2. lvcreate -L 500 -n lvuser /dev/vgdata
3. chown oracle:dba /dev/vgdata/rlvuser
4. vgchange -a n /dev/vgdata
5. vgchange -S y -c y /dev/vgdata
6. vgexport -s -v -p -m vgdata.map /dev/vgdata
7. vgchange -a s /dev/vgdata
8. Move the vgdata.map file to each system
(on each system)
9. mkdir /dev/vgdata
10. mknod /dev/vgdata/group c 64 0x010000
11. vgimport -s -v -p -m vgdata.map /dev/vgdata
12. chown oracle:dba /dev/vgdata/rlvuser
(on one system)
13. Create the tablespace with the /dev/vgdata/rlvuser as the datafile (or a symlink to this location). Symlinks should be used where possible, as this will simplify administration.

Please note, this is NOT to be used for active volume groups. It is similar, but more complex, and libable for more problems. I would recommend getting RAC training over trying to do self-learning on it.

Thanks,

Brian
Brian Crabtree
Honored Contributor

Re: Oracle 9i RAC - Create User

The other part of a RAC cluster is that (for HP-UX) the volume groups have to be in sync to be able to add a datafile to all of the instances. (A datafile can be added to a single instance, but will generate errors in the alertlog of the other instance, and will be unreadable).

This is not a simple process, and you should know a bit about Serviceguard clustering, volume group management, logical volume management, and Oracle administration before doing this.

Ok, there are some assumptions in this. First, you have a volume group created (vgdata) that does not have any logical volumes created, and is not currently active on any systems. Second, you have a cluster up and running.

1. vgchange -a y /dev/vgdata
2. lvcreate -L 500 -n lvuser /dev/vgdata
3. chown oracle:dba /dev/vgdata/rlvuser
4. vgchange -a n /dev/vgdata
5. vgchange -S y -c y /dev/vgdata
6. vgexport -s -v -p -m vgdata.map /dev/vgdata
7. vgchange -a s /dev/vgdata
8. Move the vgdata.map file to each system
(on each system)
9. mkdir /dev/vgdata
10. mknod /dev/vgdata/group c 64 0x010000
11. vgimport -s -v -p -m vgdata.map /dev/vgdata
12. chown oracle:dba /dev/vgdata/rlvuser
(on one system)
13. Create the tablespace with the /dev/vgdata/rlvuser as the datafile (or a symlink to this location). Symlinks should be used where possible, as this will simplify administration.

Please note, this is NOT to be used for active volume groups. It is similar, but more complex, and libable for more problems. I would recommend getting RAC training over trying to do self-learning on it.

Thanks,

Brian
Brian Crabtree
Honored Contributor

Re: Oracle 9i RAC - Create User

The other part of a RAC cluster is that (for HP-UX) the volume groups have to be in sync to be able to add a datafile to all of the instances. (A datafile can be added to a single instance, but will generate errors in the alertlog of the other instance, and will be unreadable).

This is not a simple process, and you should know a bit about Serviceguard clustering, volume group management, logical volume management, and Oracle administration before doing this.

Ok, there are some assumptions in this. First, you have a volume group created (vgdata) that does not have any logical volumes created, and is not currently active on any systems. Second, you have a cluster up and running.

1. vgchange -a y /dev/vgdata
2. lvcreate -L 500 -n lvuser /dev/vgdata
3. chown oracle:dba /dev/vgdata/rlvuser
4. vgchange -a n /dev/vgdata
5. vgchange -S y -c y /dev/vgdata
6. vgexport -s -v -p -m vgdata.map /dev/vgdata
7. vgchange -a s /dev/vgdata
8. Move the vgdata.map file to each system
(on each system)
9. mkdir /dev/vgdata
10. mknod /dev/vgdata/group c 64 0x010000
11. vgimport -s -v -p -m vgdata.map /dev/vgdata
12. chown oracle:dba /dev/vgdata/rlvuser
(on one system)
13. Create the tablespace with the /dev/vgdata/rlvuser as the datafile (or a symlink to this location). Symlinks should be used where possible, as this will simplify administration.

Please note, this is NOT to be used for active volume groups. It is similar, but more complex, and libable for more problems. I would recommend getting RAC training over trying to do self-learning on it.

Thanks,

Brian
Brian Crabtree
Honored Contributor

Re: Oracle 9i RAC - Create User

The other part of a RAC cluster is that (for HP-UX) the volume groups have to be in sync to be able to add a datafile to all of the instances. (A datafile can be added to a single instance, but will generate errors in the alertlog of the other instance, and will be unreadable).

This is not a simple process, and you should know a bit about Serviceguard clustering, volume group management, logical volume management, and Oracle administration before doing this.

Ok, there are some assumptions in this. First, you have a volume group created (vgdata) that does not have any logical volumes created, and is not currently active on any systems. Second, you have a cluster up and running.

1. vgchange -a y /dev/vgdata
2. lvcreate -L 500 -n lvuser /dev/vgdata
3. chown oracle:dba /dev/vgdata/rlvuser
4. vgchange -a n /dev/vgdata
5. vgchange -S y -c y /dev/vgdata
6. vgexport -s -v -p -m vgdata.map /dev/vgdata
7. vgchange -a s /dev/vgdata
8. Move the vgdata.map file to each system
(on each system)
9. mkdir /dev/vgdata
10. mknod /dev/vgdata/group c 64 0x010000
11. vgimport -s -v -p -m vgdata.map /dev/vgdata
12. chown oracle:dba /dev/vgdata/rlvuser
(on one system)
13. Create the tablespace with the /dev/vgdata/rlvuser as the datafile (or a symlink to this location). Symlinks should be used where possible, as this will simplify administration.

Please note, this is NOT to be used for active volume groups. It is similar, but more complex, and libable for more problems. I would recommend getting RAC training over trying to do self-learning on it.

Thanks,

Brian
Printaporn_1
Esteemed Contributor

Re: Oracle 9i RAC - Create User

Hi,

as stated in above post , lot of things to understand and done to create a new tablespace in RAC.
better try to understand your cluster , what is the service ? to connect to the DB cluster.
Not only one instance.
after that configure it with Net Assistant.
after successful connect with SQLPLUS.
Check gv$database , what instance and else ???


enjoy any little thing in my life