- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- 2 oracle databases sharing same volume group
Operating System - HP-UX
1747980
Members
4396
Online
108756
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО09-12-2000 11:41 AM
тАО09-12-2000 11:41 AM
2 oracle databases sharing same volume group
I have 2 separate oracle databases on the same node sharing a volume group of disks.
Should i just have one MC/SG pkg that handles both databases for monitoring, halting, switching and startup, since both databases will have to be handled as a pair because of the sharing of the volume group?
If so, how can i configure 2 monitor scripts that handle both databases in the event of a failure? Any suggestions would be appreciated.
Should i just have one MC/SG pkg that handles both databases for monitoring, halting, switching and startup, since both databases will have to be handled as a pair because of the sharing of the volume group?
If so, how can i configure 2 monitor scripts that handle both databases in the event of a failure? Any suggestions would be appreciated.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 12:22 PM
тАО09-12-2000 12:22 PM
Re: 2 oracle databases sharing same volume group
I would not normally recommend this, but since you have both databases sharing the VG you will have to define them in a single package. This reduces your flexibility in the envronment, but if the databases are logically connected so tightly that it makes no sense to run one without the other then perhaps this is not a drawback.
As to monitoring scripts, there should be no significantdifference between configuring 2 databases into the package and configuring one. Just make sure your startup, shutdown, monitoring scripts are aware of all databases/processes.
As to monitoring scripts, there should be no significantdifference between configuring 2 databases into the package and configuring one. Just make sure your startup, shutdown, monitoring scripts are aware of all databases/processes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 01:38 PM
тАО09-12-2000 01:38 PM
Re: 2 oracle databases sharing same volume group
I have had to do the same thing in a couple of Serviceguard setups and have had no problems. Indeed one setup has three databases sharing the same package.
With disks getting so much bigger, in some cases, a lack of physical spindles makes it difficult to spread a database over enough to get good performance.
Also with the smaller K servers and SCSI disks the number of disks that can be connected becomes an issue in a Serviceguard environment where all the busses are dual connected.
I have just one monitor script that is driven from a file (/etc/svtab) that contains details of the databases to be started.
With disks getting so much bigger, in some cases, a lack of physical spindles makes it difficult to spread a database over enough to get good performance.
Also with the smaller K servers and SCSI disks the number of disks that can be connected becomes an issue in a Serviceguard environment where all the busses are dual connected.
I have just one monitor script that is driven from a file (/etc/svtab) that contains details of the databases to be started.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 02:51 PM
тАО09-12-2000 02:51 PM
Re: 2 oracle databases sharing same volume group
I think options are quite limited.
Because you are sharing the same VG you have no choice but to have one package. You can also have one monitor script that monitors all the essential components of both instances and moves the whole database in case of failure.
Because you are sharing the same VG you have no choice but to have one package. You can also have one monitor script that monitors all the essential components of both instances and moves the whole database in case of failure.
Minimum effort maximum output!
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP