UPDATE: SC 3.1 U4 on Sol 10 x86 + Ora 10g]

Hi gurus,

an update to the "weird Oracle problem":

Although we thought re-setting the permissions did the trick, it took
out that we were not really lucky: After the next reboot and some work
on the system, we were again unable to connect the DB.
This time, we opened a case at SUN support, and got a very interesting
answer:

Oracle uses shared memory for the communication between the client(s)
and the server. To get the shared memory segment to use, a key is
generated out of the environment of the user running the command. This
key MUST be identical for the server and all clients - in our case, the
keys were different, so the client was unable to find the server.
You can show the keys with the command "ipcs", the best trick is as follows:

1. Start the DB manually, ensure you can connect it, and write down the
key ipcs shows for the shared memory realm of the Oracle user.
2. Shut down the DB, and let the cluster start it. Then, examine the
output of ipcs again, and if the keys are different, you have an env
problem. CAREFULLY examine the environment of the Oracle user, and the
settings for the Oracle server resource. In our system, the path for
ORACLE_HOME was different: The one in the cluster resource definition
had a trailing slash, the original path had none...

After fixing this, the problem was solved.

The next time I'm setting up Oracle in a clustered environment I will
take special care to these details.

Hope it helps someone of you out there in the administrator's world,

keep on hackin',

Harald
--
============================================
Harald Husemann
Professional Network Administrator
Materna GmbH - Vo_kuhle 37
D-44141 Dortmund, Germany
Phone: +49-231-9505-222
Received: from ganymed.materna.de ([139.2.34.141]) by
postix.buc.materna.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 16
Nov 2006 15:22:55 +0100
Received: from relay1.materna.de (ilos.materna.de [193.96.115.75]) by
mail-2525.materna.de (Postfix) with ESMTP id 1350F2477F for
<harald.husemann@xxxxxxxxxx>; Thu, 16 Nov 2006 15:22:55 +0100 (MET)
Received: from localhost (localhost [127.0.0.1])by relay1.materna.de
(Postfix) with ESMTP id D64EA46for <harald.husemann@xxxxxxxxxx>; Thu,
16 Nov 2006 15:22:54 +0100 (MET)
Received: from relay1.materna.de ([127.0.0.1])by localhost
(ilos.materna.de [127.0.0.1]) (amavisd-new, port 10024)with ESMTP id
ErgCnnfXNwqQ for <harald.husemann@xxxxxxxxxx>;Thu, 16 Nov 2006
15:22:45 +0100 (MET)
Received: from sunportal.sunmanagers.org (sunportal.sunmanagers.org
[128.100.17.250])by relay1.materna.de (Postfix) with ESMTPfor
<harald.husemann@xxxxxxxxxx>; Thu, 16 Nov 2006 15:22:44 +0100 (MET)
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Received: from sunportal.sunmanagers.org (localhost [127.0.0.1])by
sunportal.sunmanagers.org (Postfix) with ESMTP id 9A6B01E5E3;Thu, 16
Nov 2006 09:21:04 -0500 (EST)
Received: from relay2.materna-com.de
(relay2.materna-com.de[192.109.216.139]) by sunportal.sunmanagers.org
(Postfix) with ESMTPid 7BFE91E5D6 for <sunmanagers@xxxxxxxxxxxxxxx>;
Thu, 16 Nov 200609:19:48 -0500 (EST)
Received: from [172.30.112.211] (yellow.materna-com.de
[172.30.112.211])by relay2.materna-com.de
(Postfix-2.1-rc19/TIM-6.6.6) with ESMTP id534C9A9DF for
<sunmanagers@xxxxxxxxxxxxxxx>; Thu, 16 Nov 2006 15:19:44+0100 (MET)
X-MimeOLE: Produced By Microsoft Exchange V6.5
Return-Path: <sunmanagers-bounces@xxxxxxxxxxxxxxx>
X-OriginalArrivalTime: 16 Nov 2006 14:22:55.0322 (UTC)
FILETIME=[B52EABA0:01C7098A]
X-Virus-Scanned: amavisd-new at materna.de
X-imss-version: 2.044
X-imss-result: Passed
X-imss-scores: Clean:100.00000 C:0 M:0 S:0 R:0
X-imss-settings: Baseline:2 C:3 M:3 S:3 R:4 (0.0000 0.0000)
X-imss-scanInfo: M:B L:E SM:2
X-imss-tmaseResult: TT:1 TS:-27.2167 TC:1F TRN:76 TV:3.6.1039(14816.003)
Delivered-To: sunmanagers@xxxxxxxxxxxxxxx
X-Original-To: sunmanagers@xxxxxxxxxxxxxxx
X-BeenThere: sunmanagers@xxxxxxxxxxxxxxx
X-Mailman-Version: 2.1.9
List-Id: The Sun Managers Mailing List <sunmanagers.sunmanagers.org>
List-Archive: <http://www.sunmanagers.org/pipermail/sunmanagers>
List-Post: <mailto:sunmanagers@xxxxxxxxxxxxxxx>
Errors-To: sunmanagers-bounces@xxxxxxxxxxxxxxx
User-Agent: Thunderbird 1.5.0.5 (X11/20060719)
X-DCC-MATERNA-Metrics: ilos 32702; Body=1 Fuz1=1 Fuz2=1
Content-class: urn:content-classes:message
Subject: SUMMARY: SC 3.1 U4 on Sol 10 x86 + Ora 10g
Date: Thu, 16 Nov 2006 15:19:44 +0100
Message-ID: <455C7380.6010904@xxxxxxxxxx>
In-Reply-To: <8F6F7A988C7AD44991073943F98A1285285BEB@xxxxxxxxxxxxxxxxxxxxxx>
Thread-Topic: SUMMARY: SC 3.1 U4 on Sol 10 x86 + Ora 10g
Thread-Index: AccJirU9UCYHUi3GQnS4jFxSr+HdfA==
References: <8F6F7A988C7AD44991073943F98A1285285BEB@xxxxxxxxxxxxxxxxxxxxxx>
List-Help: <mailto:sunmanagers-request@xxxxxxxxxxxxxxx?subject=help>
List-Subscribe: <http://www.sunmanagers.org/mailman/listinfo/sunmanagers>,<mailto:sunmanagers-request@xxxxxxxxxxxxxxx?subject=subscribe>
List-Unsubscribe: <http://www.sunmanagers.org/mailman/listinfo/sunmanagers>,<mailto:sunmanagers-request@xxxxxxxxxxxxxxx?subject=unsubscribe>
From: "Harald Husemann" <harald.husemann@xxxxxxxxxx>
Sender: <sunmanagers-bounces@xxxxxxxxxxxxxxx>
To: <sunmanagers@xxxxxxxxxxxxxxx>
X-Converted-To-Plain-Text: from multipart/alternative by demime 1.01b
X-Converted-To-Plain-Text: Alternative section used was text/plain

<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
_______________________________________________
sunmanagers mailing list
sunmanagers@xxxxxxxxxxxxxxx
http://www.sunmanagers.org/mailman/listinfo/sunmanagers

Relevant Pages

  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver.odbc)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver)
  • RE: Vulnerability analysis tools
    ... Definitely you want your Oracle database behind a firewall. ... tell you the database is not meant to be exposed to the internet directly. ... 1- A web server hosted at an IDC ...
    (Security-Basics)
  • Re: problem connecting to db.
    ... Have you checked the listener log file on the database server? ... client is correct, and that the connection string that you are ... the Oracle client would be looking for a server ...
    (comp.databases.oracle.misc)
  • Re: test restore
    ... different server and have some questions. ... I then mounted the database but when i run "alter databse ... How can i use oracle to recognize this ...
    (comp.databases.oracle.server)