[EMAIL PROTECTED] wrote:
Firstly, apology if this question sounds silly.
I am intrested in setting up a RAC configuration at my home with
a few desktop PC's. I would run either Win2K or Redhat Linux for the
same. I am not sure whether I would be able to setup the RAC using a few
desktop
I'm going down that path right now. I'll keep you all posted.
hardware: 2.0G, 1G of ram, 40G internal, 2 of those. external 120G
firewire HD.
waiting on the HD to continue, relatively new hardware so had to ditch
the whole RHAS 2.1 and aint willing to pay RH for AS3.
joe
Marcin
There's a new-ish RAC/Linux install guide on OTN:
http://otn.oracle.com/tech/linux/pdf/RAC_1030.pdf Interestingly enough the
guide specifically shows *not* to alias localhost at all (page 9).
Hmmm...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
If you are using Linux, you can use NBD's (network block devices) that will
allow you to use a third PC as a storage device. You can download the
drivers at http://nbd.sourceforge.net/
There's a pretty good paper out there as well, at
http://www.fi.muni.cz/~kripac/orac-nbd/ that will walk you
Any experience with ENBD (Extended NBD), also from SourceForge?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, January 20, 2004 3:20 PM
To: Multiple recipients of
Not personally. The testing that I did last year just used regular NBDs.
I'm not sure what the difference is. Basically, the NBDs allow you to use
container files as raw devices -- it's nice because you don't need to mess
around with the disks, just create some files and serve them up through
Dear All,
I am posting this again as It seems to have got lost
Regards
Sriram Kumar
-Original Message-
Sent: Monday, January 19, 2004 1:26 PM
To: '[EMAIL PROTECTED]'
Importance: High
Dear Guru's,
Firstly, apology if this question sounds silly.
I am intrested in
jwiegand wrote:
Good Day.
Has anyone succeeded in this and care to share? I've tried sharing out
the directory containing the Oracle backup, tried setting the Oracle
services to run under a Windows domain user, but continue to get
failures.
Hello,
Oracle on Windows don't support network drives.
True, but you can use a UNC address \\machine_name\shared_dir to copy a backup file
remotely. But you need to make sure that the user who fires off the copy command has
write access on the shared destination directory.
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred
I've set it before to prevent IP trips to the router for programs that use
IP to talk to itself (like some backup programs that work over a network).
But like I said, it's probably my lack of understanding of how proper
networking is to be setup... :)
Rich
Rich Jesse
Have you checked that it doesn't go to the router when you
set localhost to the address of your eth0 adapter and that
it does when you set it to 127.0.0.1? I would be very surprised
if the default route was used to resolve route from lo0-eth0.
When you do netstat -r, your LAN network address
Joe,
In random order, here's some hints:
Make sure you visit Werner's site, http://www.puschitz.com He has all sorts
of non-RAC ideas on how to install Oracle on all sorts of RH flavors.
Beware that RH AS 2.1 is bloody old. You may have problems with it
recognizing your newer hardware. Since
Title: RE: RAC setup on linux
joe-
There was a nice document on a *cookbook* to do this by Oracle. I'm not sure if I can get my hands on it as we were working to plan out a Linux install in November. That project fell out of priority.. I'll poke around, but not sure if I would hold high hopes
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RAC setup on linux
Joe,
In random order, here's some hints:
Make sure you visit Werner's site, http://www.puschitz.com He has all sorts
of non-RAC ideas on how to install Oracle on all sorts of RH flavors
Hi,
RAC is just a database option. If RDBMS 9.2 is certified against a
product means, 9.2 RAC is also certifid on that product. But all the
RAC features may not work with the certified option.. (Is it too
confusing?!(
Okay.. The TAF feature in RAC (okay... it is not a RAC feature!!) will
not
Actually I am having a problem connecting from Forms or even from
sqlplus 8.0.6 to RAC. Connection to RAC database or to single instance
from RAC ends with generic windows error. Oracle trace shows succesful
connection, folloved by errors 12560 and 12203. Oracle 9.2 clients are
working with no
I've used Apps 11.5.8 on RAC, so I know the 8.0.6 stack will connect just
fine to 9.2.0, RAC or no RAC.
For your debugging, you are going to have to work your way into it, starting
from the most basic level. Start from tnsping then sqlplus and work
your way up to the Forms and stuff, not the
Could anyone explain me the cause of this error?
I am using RAC over NFSv3, 9.2.0.4, kernel 2.6.0-test6
This last line is your problem. I certainly hope you aren't running a
production system on this configuration.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Hope this helps !!
Hello listers,
At OW, SF RAC users, IOUG and Oracle put their heads together to launch a
new RAC-SIG.
IOUG has started a RAC-SIG list server for its members.
http://www.ioug.org/ioug_p/dynamic_pkg.show?v_name=DISPLAY_RAC_SIG
Last week the RAC-SIG took a global turn,
http://lists.gridapp.com/mailman/listinfo.cgi/oracle-rac
HTH
GovindanK
On Thu, 13 Nov 2003 08:09:26 -0800, Browett, Darren
[EMAIL PROTECTED] said:
I am looking for a RAC listserv that is active.
I have signed up for one, unfortunately I can't rememer what the address
is and there has
been
cc:
Sent by: Subject: RE: RAC and Standby
Dr
[EMAIL PROTECTED]
y.com
10/12/2003 02:59
AM
Please
ORACLE-L [EMAIL PROTECTED]
racle.com cc:
Sent by: Subject: RE: RAC and
Standby Dr
[EMAIL PROTECTED]
y.com
10/12/2003 02:59
AM
If I understand you correctly and you want to use DataGuard for site
failover and RAC for machine failover, that should work without any
problems. It is indeed what I would recommend for a full HA configuration,
since RAC only answers the machine failover part, not site failover.
Pete
:
Sent by: Subject: RE: RAC and Standby Dr
[EMAIL PROTECTED]
y.com
Sep 2003 22:46:40 +0800
To: [EMAIL PROTECTED]
From: Hemant K Chitale [EMAIL PROTECTED]
Subject: RE: RAC for download -- re RAC Pricing
Check oraclestore.com. The default page just shows you the pricing
for the DB EE, true.
However, when you click on Database under Products in the left panel,
you
PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: 26 September 2003 12:05
To: Multiple recipients of list ORACLE-L
Subject: Re: Fwd: RE: RAC for download -- re RAC Pricing and
Partitioning
They are indeed, and their prices are (in the order you list them
Title: RE: RAC for download
Me thinks partitioning is part of EE but you must license it ... (so Uncle Larry can sponsor 2 laps in the BMW racing using your license money).
Raj
Rajendra dot Jamadagni
$70K per CPU !
Data Mining, OLAP, Advanced Security, Spatial and Label Security
are also seperately priced options.
Hemant
Date: Thu, 25 Sep 2003 22:46:40 +0800
To: [EMAIL PROTECTED]
From: Hemant K Chitale [EMAIL PROTECTED]
Subject: RE: RAC for download -- re RAC Pricing
Check oraclestore.com
To: Multiple recipients of list ORACLE-L
Subject: Re: RAC for download
I've seen the same kind of confusion with respect to the partitioning
option, where people have been informed by their sales rep that
partitioning option is part of EE. Well, yes, if you pay extra for it.
Mogens
Hemant K Chitale
:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: Wednesday, September 24, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RAC for download
I've seen the same kind of confusion with respect to the partitioning
option, where people have been informed by their sales
I was talking about partitioning, not about RAC.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Hemant K Chitale
Sent: Thursday, September 25, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC
://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Hemant K Chitale
Sent: Thursday, September 25, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning
oops, I forgot
Title: Message
RAC is a part of
the EE version, for whichever OS you have. You will still
need
to purchase the
hardware.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
quriyat Sent: Wednesday, September 24,
If the question is about price [referring to oraclestore], remember that
RAC
is an option and is generally at a 50% premium on the EE cost.
However, Mladen is right in that RAC is on the same CDs as the Enterprise
Edition.
If your servers are cluster-ready, the OUI automatically includes RAC
as
I've seen the same kind of confusion with respect to the partitioning
option, where people have been informed by their sales rep that
partitioning option is part of EE. Well, yes, if you pay extra for it.
Mogens
Hemant K Chitale wrote:
If the question is about price [referring to
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: Wednesday, September 24, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RAC for download
I've seen the same kind of confusion with respect to the partitioning
ORACLE-L
Subject: Re: RAC for download
I've seen the same kind of confusion with respect to the partitioning
option, where people have been informed by their sales rep that
partitioning option is part of EE. Well, yes, if you pay extra for it.
Mogens
Hemant K Chitale wrote
--- On Wed 09/24, Johnston, Tim [EMAIL PROTECTED] wrote:
From: Johnston, Tim [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Wed, 24 Sep 2003 14:34:49 -0800Subject: RE: RAC for downloadUm... I'd definitely get that in writing... I just looked at the oraclestore and it looks like
24, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RAC for download
I've seen the same kind of confusion with respect to the partitioning
option, where people have been informed by their sales rep that
partitioning option is part of EE. Well, yes, if you pay extra
Thanks Mogens,
It works great with no parallelism set.
But when parallelism is set to DEFAULT it fails
(intermittently). The tables are imported from a
Non-Rac production environment.
Found a note on Metalink last night which says DEFAULT
is calculated as : CPU_COUNT*PARALLEL_THREADS_PER_CPU
and
Shouldn't happen, but one would have to question the use of PQ on such a
small table anyway. You may be hitting some lower boundary condition that
the developers didn't even look at because the table's so small?
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
I'm not sure I understand. Is this a query that should access a 470
record table and which uses Parallel Query in a RAC environment? And
when it works, it executes in less than a second?
If yes, have you tested this query without Parallel Query?
If no, where did I misunderstand you?
Best
-Original Message-
From: Browett, Darren [mailto:[EMAIL PROTECTED]
I know there is the gv$ views which are the cluster wide
equivialent of
the v$ views,
but is there any gx$ views where are equivalent to the x$ views ???
I don't think so, but does the source code for a RAC view
Ron and all;Sorry took me so long to replay ... I got the flu :(
Anyways thanks so much for the reply. I went back and read more about TAF, I still am expecting to finish my selet call count on a 32 million row table even if I kill an instance with srvctl command.
Here is where I am at now. Thanks
Title: Message
Well,
that is because of your understanding of the word "failover". Don't be confused,
there are other words
in
desperate need of redefinition, too. One of them is "unbreakable".
To
make the long story short, "FAILOVER=ON" makes possible for Oracle*Net to
skip the
Title: Message
I see
some points that may be causing failover issues in the sample you supplied
below:
Let's
start by coveringthe assumptions I have made about your environment
:
1)
Assumption: You are using a client connection that can leverage TAF (such
as sqlplus or jdbc oci "thick"
Title: Re: RAC - setting up failover and load_balance
...it would also help to spell secondary correctly in the BACKUP= clause...
on 8/26/03 3:24 PM, Mladen Gogala at [EMAIL PROTECTED] wrote:
Well, that is because of your understanding of the word failover. Don't be confused
Robert:
It is normal behavior only. But you didn't say about the OS and Cluster
Software. Make sure you use the highspeed private interconnect for the
block transfer between instances. I have seen in many sites public
interconnect has used for cache transfer.
Other than that, you may want to try
Title: Message
Strictly speaking, it's not a part of Oracle DLM, it's a part of vendor's
cluster manager. In other words, it's a TCP stack
thing.
Your host must be able to have one "logical network card" that would
automagically distribute load among several
physical NIC's.
--Mladen
Title: Re: RAC interconnects
Check out the init.ora parameter CLUSTER_INTERCONNECTS. Have never used it, but it appears to be what youre looking for...
What platform?
on 8/8/03 6:09 AM, Jamadagni, Rajendra at [EMAIL PROTECTED] wrote:
Hi all,
Is it possible to somehow tell Oracle to use
Title: Re: RAC interconnects
Thanks Tim,
The problem with that parameter is Oracle will then restrict
communication to only those listed in there, overriding the failover provided by
OS and os clustering software.
Raj
Raj,
In current versions of RAC there is no other way (other than specifying
all the IPs in the Cluster_interconnects parameter) to force ALL
available private networks for GC traffic. I think this 'feature' is
available/planned for 10g. I have not tested that in beta.
Check with Oracle
Raj:
Raj:
Use the cluster_interconnects parameter to specify all the IPs used for
GC. But there is a catch. But sometimes a NIC failure will be seen as
Node failure (though it is a very very rare case).
BTW Why do you want to use both NICs for GC traffic? DO you see lots of
waits for messages?
Title: RE: RAC interconnects
KG,
yes we see the GC traffic a lot, when there are 4 production instances on each node and that is why we were interested in finding out if we could make oracle use both interconnects.
Any ideas?
Raj
-Original Message-
From: K Gopalakrishnan [mailto
In addition to Matthew's comments, I might add that
all Veritas documentation is available at support.veritas.com.
Jared
On Friday 25 July 2003 10:04, laura pena wrote:
- Configuration - Should each of these 3 LUN be on seperate disks?
- What is the smallest LUN that Hitachi 9570V can be? I
Sorry all my message got hacked here is the first paragraph
Going through the Veritas installation guide (pg 47) and I have a question on the required 3 LUN creation needed to support RAC for Veritas DBE/AC, when setting up Disk Coordinator:laura pena [EMAIL PROTECTED] wrote:
- Configuration -
itoGridApp SystemsEmail:
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura
penaSent: Friday, July 25, 2003 1:04 PMTo: Multiple
recipients of list ORACLE-LS
PROTECTED]Cell:
646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Matthew ZitoSent: Friday, July 25, 2003 1:54 PMTo:
Multiple recipients of list ORACLE-LSubject: RE: RAC - Configuring
Title: RE: RAC
Kay,
Can we get the Metalink note to run a single node RAC on Linux.
TIA
Suhen
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 22 July 2003 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC
Not required.. We
Suhen:
Check the Metalink note 166830.1 for the details.
KG
--- Suhen Pather [EMAIL PROTECTED] wrote:
Kay,
Can we get the Metalink note to run a single node RAC on Linux.
TIA
Suhen
-Original Message-
Sent: Tuesday, 22 July 2003 4:40 PM
To: Multiple recipients of list
Thanks KG for the info . You guys rock .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 11:39 PM
AK:
Very much possible and very simple if you are using Linux or Windoze. I
think there is a note on Metalink with
You
need at least 2 servers.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:49
PMTo: Multiple recipients of list ORACLE-LSubject:
RAC
Is it possible to setup RAC in one box only.
] On Behalf Of
Goulet, DickSent: Monday, July 21, 2003 4:04 PMTo:
Multiple recipients of list ORACLE-LSubject: RE:
RAC
You
need at least 2 servers.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday
Title: Message
You
must of taken the Oracle AdvancedComeback and Retort
class
Brad
O.
-Original Message-From: Matthew Zito
[mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 4:19
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
RAC
No,
its definitely
. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Odland, Brad
[mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 5:39
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
RAC
You
must of taken the Oracle AdvancedComeback and Retort
Title: Message
www.oaktable.net. Harrison redhouse has a
paper on this. Think vmware.
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
AKSent: 21 July 2003 19:49To: Multiple recipients of
list ORACLE-LSubject: RAC
Is it
AK:
Very much possible and very simple if you are using Linux or Windoze. I
think there is a note on Metalink with step by step instructions for
setting a RAC on single node -Linux.
It is slightly complicated if you want to run RAC on windows. I know
couple of guys here who are running RAC on
Not required.. We used to run OPS on single node :)) for testing
purposes. There are some step by step instructions in Metalink abt how
to do that.
--- Goulet, Dick [EMAIL PROTECTED] wrote:
You need at least 2 servers.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Title: RE: RAC or Oracle Fail Safe
Hi!
Of
course you have to plan your servers' capacity accordingly, that in the event of
node failure, the other node will not get too loaded. When one node crashes, the
second one has to deal with queries and transactions of both servers and we must
Title: RE: RAC or Oracle Fail Safe
Hi Rajesh,
Thanks for
the detailed reply and I really appreciate that. Certain clarifications.
1.
With reference to what you said about using both the
nodes, you meant that we can install another database (lets say for reporting purpose)
or/and also
Title: RE: RAC or Oracle Fail Safe
Hi Hussain,
Replies
are inline .
With
reference to what you said about using both the nodes, you meant that we can
install another database (lets say for reporting purpose) or/and also 9iAS on
one node and our main production database
Thank you to all those who replied and who intend to reply to this one :)
We are using Dell PE4600 servers. My concern was that I read it somewhere that if one
of the node goes down, then the clients have to restart the application to log in
again to the database, is that true? And is it any
Title: RE: RAC or Oracle Fail Safe
Hi Hussain !
RAC can have Active-Active or Active-Passive combination for two nodes. While OFS can't give you Active-Active combination of two nodes. Basically a resource sharing is not possible in Oracle Fail safe so one resource can be used by only one
Title: RE: RAC or Oracle Fail Safe
Answers in line...
-- I also believe that setting up RAC is more complex,
That's not totally true, For a DBA it shouldn't matter much, whether he is setting up RAC or OFS. But yes relatively RAC is a bit complex to manage.
-- and any change in node
One other note is that we have not had to failover due to a Win2K of Oracle
problem in 18 months of running failsafe. We have found it to be extremely
stable just not scalable froma CPU standpoint.
I totally agree with this. I am running FailSafe here also. The *only*
failover's I experience is
Hi!
RAC - One database, two (or more) instances servicing it concurrently. If
one node crashes, second one starts recovering, your uncommitted
transactions and session state variables (package variables) on failed
instance are lost.
FailSafe - One database, one instance servicing it at any time,
FailSafe comes with EE and works very well. It might even come with SE but I am not
sure. Our
production environment fails over in less than 2 minutes. It is much simpler to set up
( ie no
SAN, raw devices or OCFS) and a heck of a lotr cheaper ( 20K$ / CPU for RAC ). One
other
note is that we
:
Sent by: Subject: Re: RAC or Oracle Fail Safe
[EMAIL PROTECTED
PROTECTED]
07/16/2003 10:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RAC or Oracle Fail Safe
EE is not required to FailSafe. It comes at no cost with Standard Edition
as well
] On
Behalf Of Ravi Kulkarni
Sent: Thursday, July 10, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Matt,
What are jumbo frames? Are these assigning private
network IPs to cluster_interconnects parameter?
-Ravi.
--- Matthew Zito [EMAIL PROTECTED
Just for fun, have you tried using truss to find out which calls
are being used? That might help you.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 10, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L
Raj,
Yes.
Title: RE: RAC system Calls
That may be because with RAC there is more activity ... GCS traffic and more stats to update ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Mladen, As mentioned earlier, I have lots of times
funtion calls, which (my guess) relate to (60-70%)IPC
send completion sync waits I got in statspack. Dont
mean to fill your inboxes, but, pasting few truss
lines:
26949: read(14, 01 O\0\006\0\0\0\0\011 i.., 2064)
= 335
26949:
The times call is very cheap and could not possibly consume so much time.
Here is what man page says:
NAME
times - get process and child process times
SYNOPSIS
#include sys/times.h
clock_t times(struct tms *buffer);
DESCRIPTION
times() fills the structure pointed to
Title: RE: RAC system Calls
Raj:
I am
discussing this issue with Ravi offline. From the initial
IPC
dumps, It looks like the private interconnect is not
properly configured/used for cache fusion. I am waiting
for
more
details from him..
Best Regards,K Gopalakrishnan
-Original
Title: RE: RAC system Calls
Hmmm ...
Thanks KG
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion
.
-Thanks,
Ravi.
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
RE: RAC system CallsRaj:
I am discussing this issue with Ravi offline. From
the initial
IPC dumps, It looks like the private interconnect is
not
properly configured/used for cache fusion. I am
waiting for
more details from him
Title: RE: RAC system Calls
We don't use cluster_interconnects (it is null) ... but for us, the RAC is using the fat private interconnects without any problems.
Raj
Rajendra dot Jamadagni at nospamespn dot com
Do you use 1 or 2 interconnects? Does your oradebug
ipc dump show both IPs? For me shows:
SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 172.168.193.2 UDP 41143
sflags SSKGXPT_UPinfo for network 1
socket no 0 IP 0.0.0.0 UDP 0
Title: RE: RAC system Calls
Yup, we have 2 private interconnects and one public .. can't display the ips though ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
I have tested using cluster_interconnects parameter.
Oradebug IPC dump shows it chooses first IP correctly,
recognizes the 2nd interconnect, but with a wrong IP -
0.0.0.0. Looks like a bug.. Has anyone seen this
earlier?
(I understand there is a bug in HP with similar
behaviour - we are on
I've seen a problem with CLIC interface, which are, for some
reason, not used by oracle. It is a bug (Oxford is on HP-UX)
and there is a specific one-off patch. This was OPS, not RAC.
The symptoms are very similar: one of the processes was spinning
like crazy in the kernel mode. However, RAC !=
Ravi:
Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have you verified the private interconnect is used
for cache fusion transfer.. Make sure the cache fusion
is not going thru the public network.
Best Regards,
K Gopalakrishnan
I had a similar experience on OPS when we tried with
releasable locks. What is the platform? What kind of
interconnect do you have?
On 2003.07.10 12:44, K Gopalakrishnan wrote:
Ravi:
Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have
Title: RE: RAC system Calls
You seem to have timed_statistics=TRUE right ?? in RAC you will ALWAYS see GCS pings ... basically as long as cluster_database=true, even if only one node is running, you will still see Oracle trying to ping other instances.
My guess is that's what is happening
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of K Gopalakrishnan
Sent: Thursday, July 10, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Ravi:
Do you have a statspack report? I would like to see that. But
in any case
Title: RE: RAC time clocks (sysdate)
Our sysadmins use ntp or something like that ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can
Exactly. Surf over to http://www.ntp.org and follow the links to download
(binaries or source), install, and configure.
If it were me doing it, I'd probably setup an existing local non-RAC
Internet-connected server (if available) with ntp to sync to an external
stratum-2 server (see ntp docs for
Title: RE: RAC time clocks (sysdate)
thanks!
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003
10:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: RAC time clocks (sysdate)
Our sysadmins use ntp or something like that ..
Raj
Title: RE: RAC time clocks (sysdate)
Yup ... we got redundant time servers on dedicated boxes ... they feed to unix/windowz clients. No production boxes are EVER exposed to ANYTHING outside a firewall.
Raj
1 - 100 of 193 matches
Mail list logo