SUMMARY: SC 3.1 U4 on Sol 10 x86 + Ora 10g

<original posting below>

Hi agn,

no answer so far, it seems this was *rellay* a nice one, :-).
But, we were able to solve it together with the DB-guys, and here' s the
solution if someone of you come across this problem:

Symptom: Oracle can be started manually, but not with the cluster
commands. Furthermore, root cannot connect the database server using
"sqlplus "/ as sysdba"".

Reason: With the latest patches to 10g (Oracle 10.2.0.2) Oracle
introduced a new security model, making the user-rights in lib/, bin/
and so on more restrivtice. This prevents root from running the
commands, and causes the described problems.
There's a script in the Oracle install directory (don't know the exact
path, our db-admins did this), which resets the rights to the old ones -
and, voila, the cluster can start the database.

Keep on hackin',

Harald

Harald.Husemann@xxxxxxxxxx wrote:
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@xxxxxxxxxxxxxxx
http://www.sunmanagers.org/mailman/listinfo/sunmanagers




--
============================================
Harald Husemann
Professional Network Administrator
Materna GmbH - Vo_kuhle 37
D-44141 Dortmund, Germany
Phone: +49-231-9505-222
_______________________________________________
sunmanagers mailing list
sunmanagers@xxxxxxxxxxxxxxx
http://www.sunmanagers.org/mailman/listinfo/sunmanagers

Relevant Pages

  • RE: Oracle Auditing
    ... A few things about Oracle and the 'listener' service. ... accepts and manages connections from the client to the Oracle database. ... WLAN by understanding these threats, ...
    (Pen-Test)
  • Re: 10g listener configuration
    ... files are changed to localhost and I've restarted the listener, ... can't get the database to register with the listener. ... Have you tried on a clean system with a fresh install of the Oracle ...
    (comp.databases.oracle.server)
  • Re: Ora 10.2.0.1, Error ORA-12514
    ... I'm trying to install an Oracle Database version 10.2.0.1, ... If you comment it out then stop & start listener again ...
    (comp.databases.oracle.server)
  • Re: Slow access to the data base.
    ... "fo" will access the DB without passing through a listener? ... the oracle executable - it is a good example of what to check. ... And that vendor doesn't handle some tcp stuff correctly, ... the database for security reasons hence all connections go through the ...
    (comp.databases.oracle.server)
  • Re: ORA-27101: shared memory realm does not exist
    ... I was able to create and use a database. ... ORA-01034: ORACLE not available ... STATUS of the LISTENER ... Instance "DB1", status UNKNOWN, has 1 handlerfor this service... ...
    (comp.databases.oracle.misc)