Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Admin directories, OPS, and OFA rule 10

Admin directories, OPS, and OFA rule 10

From: Poore, Vincent G <vincent.poore_at_eds.com>
Date: Fri, 20 Dec 2002 14:39:07 -0800
Message-ID: <F001.00520895.20021220143907@fatcity.com>


I'm going to build a new database cluster using OPS 8.1.7. I have a question about the OFA standard and rule 10.

It states:
OFA 10 If you are using Oracle Parallel Server, select exactly one node N to act as Oracle administrative  home for the cluster to house the
administrative subtree defined in rule OFA 5. Let h be the Oracle software owner's login home directory on node N. Create a directory named for each instance  accessing database d within the adump,
bdump, cdump, logbook, pfile, and udump direc- tories of N:h/admin/d. On every node n in the cluster except N, mount the remote directory N:h/admin/d as the administrative directory for database d (i.e., as n:h/admin/d).

An 2-node example of the udump directory:

These directories would exist on node1 (the admin node):
/u01/app/oracle/admin/mydb/udump/mydb1
/u01/app/oracle/admin/mydb/udump/mydb2

On node 2 the admin dir would be mounted as node1:/u01/app/oracle/admin/mydb /u01/app/oracle/admin/mydb

And hence, both instance directories would be accessable to either node

This doesn't seem like a reasonable rule from a high-availabliity standpoint. If node1 fails, the admin directory on node2 disappears.

Am I missing something?

I am contemplating building a separate
/u01/app/oracle/admin/mydb

on both nodes.

Then, on node1 I could mount node2 as
node2:/u01/app/oracle/admin/mydb /u01/app/oracle/admin2/mydb

and then on node2 mount node1's admin dir as node1:/u01/app/oracle/admin/mydb /u01/app/oracle/admin1/mydb

I have separate admin trees for high-availablity, but can still reference both conveniently like the following command to list trace files:

ls -lrt /u01/app/oracle/admin*/mydb/udump/*.trc

What have others done?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Poore, Vincent G
  INET: vincent.poore_at_eds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Dec 20 2002 - 16:39:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US