From: Harald.Husemann@materna.de
Date: Wed Nov 15 2006 - 09:45:38 EST
Hi gurus,
sorry if this is a bit off-topic, but I think runnin' a SUN Cluster with an
Oracle database is a common task for many of us, so I hope some of you can
help...
Well, the environment:
Two x4200 and two SE3310 storages, building a SUN cluster. OS is Solaris 10
x86, SC version is 3.1U4, latest patches installed (EIS-DVD Sept. 2006).
Database is Oracle 10.2.0.
So far so good, I can start the database manually on both nodes, and connect
it by using sqlplus user/pwd@SID, as I would expect it.
But, when the cluster starts the database, I can't connect it, although the
cluster tells me it's running. Nevertheless, a tnsping works, so IMHO it can't
be network related. And, to make things even more crazy, a connect over the
socket by using 'sqlplus "/ as sysdba"' works, the only problem is the
IP-based connection...
It seems that I can connect the listener, but the listener can't connect the
database server (although it is listening on the socket, as the sqlplus "/as
sysdba" shows).
I've tracked the problem down to the server resource, it does not matter how
the listener is started, the problem is the server. I've examined the logs
from the cluster agent and the Oracle logs, I don't see any alerts or
warnings.
I hope, someone can shed some light on this...
Thanks in advance,
have a nice hackin',
Harald
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:41:11 EDT