From: Harald Husemann (harald.husemann@materna.de)
Date: Tue Nov 21 2006 - 01:03:49 EST
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@materna.de>; 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@materna.de>; 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@materna.de>;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@materna.de>; 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@sunmanagers.org>; 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@sunmanagers.org>; Thu, 16 Nov 2006 15:19:44+0100 (MET) X-MimeOLE: Produced By Microsoft Exchange V6.5 Return-Path: <sunmanagers-bounces@sunmanagers.org> 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@sunmanagers.org X-Original-To: sunmanagers@sunmanagers.org X-BeenThere: sunmanagers@sunmanagers.org 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@sunmanagers.org> Errors-To: sunmanagers-bounces@sunmanagers.org 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@materna.de> In-Reply-To: <8F6F7A988C7AD44991073943F98A1285285BEB@postix.buc.materna.com> Thread-Topic: SUMMARY: SC 3.1 U4 on Sol 10 x86 + Ora 10g Thread-Index: AccJirU9UCYHUi3GQnS4jFxSr+HdfA== References: <8F6F7A988C7AD44991073943F98A1285285BEB@postix.buc.materna.com> List-Help: <mailto:sunmanagers-request@sunmanagers.org?subject=help> List-Subscribe: <http://www.sunmanagers.org/mailman/listinfo/sunmanagers>,<mailto:sunmanagers-request@sunmanagers.org?subject=subscribe> List-Unsubscribe: <http://www.sunmanagers.org/mailman/listinfo/sunmanagers>,<mailto:sunmanagers-request@sunmanagers.org?subject=unsubscribe> From: "Harald Husemann" <harald.husemann@materna.de> Sender: <sunmanagers-bounces@sunmanagers.org> To: <sunmanagers@sunmanagers.org> 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@materna.de 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@sunmanagers.org > 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@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagers _______________________________________________ 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:13 EDT