- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i RAC - Create User
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2003 12:47 PM
тАО05-14-2003 12:47 PM
Re: Oracle 9i RAC - Create User
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2003 12:47 PM
тАО05-14-2003 12:47 PM
Re: Oracle 9i RAC - Create User
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2003 12:47 PM
тАО05-14-2003 12:47 PM
Re: Oracle 9i RAC - Create User
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2003 12:47 PM
тАО05-14-2003 12:47 PM
Re: Oracle 9i RAC - Create User
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-18-2003 10:42 PM
тАО05-18-2003 10:42 PM
Re: Oracle 9i RAC - Create User
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 ???
- « Previous
-
- 1
- 2
- Next »