Re: setting up HACMP and Oracle 8.1.6

We are using HACMP with 7.3.4.5. I am not a unix admin, but...

I assume you are trying to remount file systems from production over to test.

First of all, the file systems from production and test must be unique.

After your file systems mount on test, you must export your appropriate ORACLE_HOME
prior to starting the db, because it will expect to find init---.ora in ORACLE_HOME/dbs
for the database.

You will also want to include an entry in listener.ora on test for the production db,
however the host= parameter must match servername that tnsnames.ora is pointing to,
which is the production server.

HTH
Mike

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:

I hope someone may be able to shed some light on this. Oracle does not seem to have much information on setting up failover on HA, other than OPS (which we are not doing). I am not an HA expert, so I may just be missing something or not asking right questions.

HW: IBM S7A
OS: AIX 4.3.3
Oracle 8.1.6

Scenario: Two nodes, one set up production, the other test/batch. We are trying to configure so that when production goes down, it fails over to node B, shutting down test/batch in process. Oracle is installed on each node, but in different directories.

Problem: On failover to node B, there are problems starting up DB, and a noteable failure to start the listener. Listener log not much help. HACMP log shows:

Could not load program oracleeml:

        Dependent module libobk.a(shr.o) could not be loaded. Could not load module libobk.a(shr.o).
Error was: No such file or directory

The file does exist.

Anyone have ideas?

-Denise Horton-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: jacinth
  INET: jacinth_at_mail.ev1.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike J Kurth
  INET: Mike.J.Kurth_at_aexp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).