- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to determine the oracle RAC partner?
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
тАО06-30-2004 08:16 AM
тАО06-30-2004 08:16 AM
Got many systems and most of them have oracle RAC installed. Question, how do you tell what is the partner system in a RAC environment?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2004 08:54 AM
тАО06-30-2004 08:54 AM
Re: How to determine the oracle RAC partner?
Without going into the database itself, you can look at the /etc/hosts file. There should be an entry of the partner system - what I have seen is this entry has a comment explaining that it is an interconnect system.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2004 09:28 AM
тАО06-30-2004 09:28 AM
Re: How to determine the oracle RAC partner?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2004 10:30 AM
тАО06-30-2004 10:30 AM
Re: How to determine the oracle RAC partner?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2004 02:58 PM
тАО06-30-2004 02:58 PM
SolutionIn the Hpux side you can only expect hints as to which nodes MIGHT be partners.
You see, an Oracle RAC instance member on one node does nto yet know which other node MIGHT join the RAC instance. There is no pre-set list in Oracle. Any node on the same cluster interconnect can join. All it need is the instance name and a unique thread adn instance number. The actual partners will be a subset of the nodes on the cluster interconnect (ics)
The best hint for that subset is to scan through $ORACLE_HOME/dbs/init*.ora files.
Parners would have the same instance name.
instance_number = X
thread = Y
instance_name = Z
fwiw,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2004 05:47 PM
тАО06-30-2004 05:47 PM
Re: How to determine the oracle RAC partner?
If you know the database name(s) try:
srvctl status db -d DBNAME
It will show sonething like:
[oracle@xxxjp01 oracle]$ srvctl status db -d XSZ
Instance XSZ1 is running on node xxxjp01
Instance XSZ2 is not running on node xxxjp02
Searching for init*.ora files as Hein writes will indeed help too.
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2004 05:53 PM
тАО06-30-2004 05:53 PM