Thanks to all who responded. As it turns out, the haoracle agent

requires that the Oracle connectivity files (listener.ora and

tnsnames.ora) need to be placed in a specific directory -

/var/opt/oracle. That *was* in the documentation, but I overlooked it.

(Silly me, I thought that the haoracle agent would look for the files in

the directory that Oracle actually expects them to be in. But I

digress...)

After creating symbolic links for the tnsnames.ora and listener.ora

files in /var/opt/oracle, another error started occurring:

ID[SUNWcluster.ha.haoracle_fmon.4520]: igdblh01:ORRTEPRD: cannot find

the SQL*Net service for ORRTEPRD

This error was due to the ORRTEPRD entry in the tnsnames.ora file

containing the IP address of the logical host, not the logical

hostname. Changing the HOST entry to the logical hostname did the

trick.

Thanks to Mark, Syd, and Jeff for your quick responses. Maybe I'll be a

sysadmin one day after all... : )

Brian

--
--------------------------------------
|Brian McGraw -- Oracle DBA|
|------------------------------------|
| mailto:BMcGraw@mindspring.com |
|http://bmcgraw.home.mindspring.com |
--------------------------------------

>Hello all ->>I have an error message that keeps showing up in the hastatus command,>for a certain node in my cluster (2 Ultra 220Rs, with 2 D1000 storage>arrays running Sun Cluster 2.2 with the Oracle High Availability>agent). It says:>>ID[SUNWcluster.ha.haoracle_fmon.4510]: igdblh01:ORRTEPRD: cannot open>tnsnames.ora file>>I've referred to the documentation's Error Messages Guide, but it
wasn't>exactly helpful. It says:>> More Information: Cannot open tnsnames.ora file> Background: None> Suggested Fix: None

S
U BEFORE POSTING please READ the FAQ located at
N ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/faq
. and the list POLICY statement located at
M ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/policy
A To submit questions/summaries to this list send your email message to:
N sun-managers@codeprof.ececs.uc.edu
A To unsubscribe from this list please send an email message to:
G majordomo@codeprof.ececs.uc.edu
E and in the BODY type:
R unsubscribe sun-managers
S Or
. unsubscribe sun-managers original@subscription.address
L To view an archive of this list please visit:
I http://www.latech.edu/sunman.html
S
T