RE: RAC

[Hengen, Brian]

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 the
NBDs.  

--Brian
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, January 20, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L

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 list ORACLE-L


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 through the
installation and configuration of the NBDs.

The performance isn't great, but it works.  If you need more information,
let me know -- I did a paper on this at IOUG last year and would be happy to
send it to you.

Regards,
Brian
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hengen, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[Jesse, Rich]

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 list ORACLE-L


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 through the
installation and configuration of the NBDs.

The performance isn't great, but it works.  If you need more information,
let me know -- I did a paper on this at IOUG last year and would be happy to
send it to you.

Regards,
Brian
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[Hengen, Brian]

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 through the
installation and configuration of the NBDs.

The performance isn't great, but it works.  If you need more information,
let me know -- I did a paper on this at IOUG last year and would be happy to
send it to you.

Regards,
Brian

-Original Message-
[mailto:[EMAIL PROTECTED] 
Sent: Monday, January 19, 2004 9:30 PM
To: Multiple recipients of list ORACLE-L

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 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 PC's. I look fwd to your advise in setting up the same.

I believe an external storage is required for setting up RAC.
Can I configure a 3rd pc's hard disk as a external storage for RAC??.

Your views are very much appriciated.

Thanks and Regards

Sriram Kumar


DISCLAIMER:
This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended recipient
you should not disseminate,distribute,store,print, copy or deliver this
message.Please notify the sender immediately by e-mail if you have received
this e-mail by mistake and delete this e-mail from your system.E-mail
transmission cannot be guaranteed to be secure or error-free as information
could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or
contain viruses.The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as a result
of e-mail transmission. If verification is required please request a
hard-copy version.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hengen, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC setup on linux [again]

[Jesse, Rich]

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]   Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Friday, January 09, 2004 5:14 PM
To: Multiple recipients of list ORACLE-L



Rich, 

Before now, I've not heard of setting localhosts to the real IP address. 

I've only seen it aliased to loopback ( 127.0.0.1 ).  Why would you 
do otherwise? 

Jared 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC

[Joe Testa]

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 Przepiórowski wrote:

[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 PC's. I look fwd to your advise in setting up the same.
I believe an external storage is required for setting up RAC.
Can I configure a 3rd pc's hard disk as a external storage for RAC??.


Hello,
Yes, you can install RAC on PC.
You must have external storage. The cheaper way for PC is 2 x SCSI 
(ex. Adaptec 29160) plus SCSI HDD. You must connect two PC's and HDD 
together, using one cable.

look at:

http://www.ibiblio.org/pub/Linux/ALPHA/linux-ha/High-Availability-HOWTO-7.html#ss7.1 

regards,
--
Marcin Przepiórowski
www.oracledba.pl


--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC

[Marcin Przepiórowski]

[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 PC's. I look fwd to your advise in setting up the same.
I believe an external storage is required for setting up RAC.
Can I configure a 3rd pc's hard disk as a external storage for RAC??.
Hello,
Yes, you can install RAC on PC.
You must have external storage. The cheaper way for PC is 2 x SCSI (ex. 
Adaptec 29160) plus SCSI HDD. You must connect two PC's and HDD 
together, using one cable.

look at:

http://www.ibiblio.org/pub/Linux/ALPHA/linux-ha/High-Availability-HOWTO-7.html#ss7.1

regards,
--
Marcin Przepiórowski
www.oracledba.pl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[k.sriramkumar]

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 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 PC's. I look fwd to your advise in setting up the same.

I believe an external storage is required for setting up RAC.
Can I configure a 3rd pc's hard disk as a external storage for RAC??.

Your views are very much appriciated.

Thanks and Regards

Sriram Kumar


DISCLAIMER:
This message contains privileged and confidential information and is intended only for 
the individual named.If you are not the intended recipient you should not 
disseminate,distribute,store,print, copy or deliver this message.Please notify the 
sender immediately by e-mail if you have received this e-mail by mistake and delete 
this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or 
error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or 
incomplete or contain viruses.The sender therefore does not accept liability for any 
errors or omissions in the contents of this message which arise as a result of e-mail 
transmission. If verification is required please request a hard-copy version.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC on Win2K using RMAN to Create Standby

[QuijadaReina, Julio C]

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 State College

-Original Message-
Sent: Thursday, January 15, 2004 4:34 AM
To: Multiple recipients of list ORACLE-L

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.
You may copy backup file from one server to other manualny, and then
create standby database from backup.

regards,
Marcin Przpiórowski
Senior Oracle DBA
www.oracledba.pl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: QuijadaReina, Julio C
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC on Win2K using RMAN to Create Standby

[Marcin Przepiórowski]

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.
You may copy backup file from one server to other manualny, and then
create standby database from backup.
regards,
Marcin Przpiórowski
Senior Oracle DBA
www.oracledba.pl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC setup on linux

[Mladen Gogala]

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 should be 
listed without a gateway. Gateway should be present only in
the entry with your default route. If that's not so, then yes, you
do have a problem with the network setup.

On 01/12/2004 09:49:26 AM, "Jesse, Rich" wrote:
> 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   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> -Original Message-
> Sent: Friday, January 09, 2004 5:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Rich, 
> 
> Before now, I've not heard of setting localhosts to the real IP address. 
> 
> I've only seen it aliased to loopback ( 127.0.0.1 ).  Why would you 
> do otherwise? 
> 
> Jared 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC setup on linux

[Jesse, Rich]

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   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA

-Original Message-
Sent: Friday, January 09, 2004 5:14 PM
To: Multiple recipients of list ORACLE-L



Rich, 

Before now, I've not heard of setting localhosts to the real IP address. 

I've only seen it aliased to loopback ( 127.0.0.1 ).  Why would you 
do otherwise? 

Jared 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC setup on linux

[Jared . Still]

Rich,

Before now, I've not heard of setting localhosts to the real IP address.

I've only seen it aliased to loopback ( 127.0.0.1 ).  Why would you
do otherwise?

Jared







"Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/09/2004 12:39 PM
 Please respond to ORACLE-L

        
        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.

Beware that RH AS 2.1 is bloody old.  You may have problems with it
recognizing your newer hardware.  Since this was just a test for us on a
pair of 2.4Ghz P-IVs, I said "Screw it!" and went with RH9, which config'd
our Intel D845 MB, the built-in video, and the built-in 100baseT Ethernet
(our older 3com 100baseT PCI card for the private network was recognized
OK).

Something I have not seen anywhere else (perhaps it's just my lack of
understand of a "proper" network setup), but when you are creating the
/etc/hosts file, do NOT alias ANY nodenames to "localhost"!  The Cluster
Manager will fail.  For example, alias "localhost" to "127.0.0.1" and NOT to
"192.168.1.1" (or whatever your public/domain IP address is).

If you need to change kernel settings permanently, instead of echoing values
to a pseudo-file in /proc on boot, make the change in /etc/sysctl.conf

If you want to try OCFS, you *must* follow Wim's guide on OTN (can't
remember the URL, but it was an OracleWorld presentation!).  Without
following that, 1.08 and 1.09 are deathly slow to the point of unusability.
Also beware that OCFS won't work out-of-the box with RH9.  I patched 1.08,
following guidelines that IBM used to patch XFS for RH9.  If you want the
patched source, let me know.


The rest of my notes seem to mostly relate to that MetaLink doc.  If you
have problems, post here!  There's enough of us that have tried it, that I'm
sure you'll get an answer faster than Oracle Support.  :)

HTH!  GL!

Rich

Rich Jesse                           System/Database Administrator
[EMAIL PROTECTED]                  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Friday, January 09, 2004 1:54 PM
To: Multiple recipients of list ORACLE-L


Ok spent < 1K for hardware, got 2, 2.0Ghz cpu, 1 G of ram, couple of 
ethernet cards(one for private heartbeat, other to put on internal 
network) computers and external firewire drive, doing RH AS 2.1, OCFS, etc.

gonna build a lab setup next week.

any pointers as to what gotchas would be appreciated, otherwise i'll 
hack my way thru it like usual :)

thanks, joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC setup on linux

[Loughmiller, Greg]

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:-(

all one can say when I ask is *he77 no*


greg


-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 09, 2004 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RAC setup on linux



Ok spent < 1K for hardware, got 2, 2.0Ghz cpu, 1 G of ram, couple of 
ethernet cards(one for private heartbeat, other to put on internal 
network) computers and external firewire drive, doing RH AS 2.1, OCFS, etc.


gonna build a lab setup next week.


any pointers as to what gotchas would be appreciated, otherwise i'll 
hack my way thru it like usual :)


thanks, joe


-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC setup on linux

[Jesse, Rich]

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 this was just a test for us on a
pair of 2.4Ghz P-IVs, I said "Screw it!" and went with RH9, which config'd
our Intel D845 MB, the built-in video, and the built-in 100baseT Ethernet
(our older 3com 100baseT PCI card for the private network was recognized
OK).

Something I have not seen anywhere else (perhaps it's just my lack of
understand of a "proper" network setup), but when you are creating the
/etc/hosts file, do NOT alias ANY nodenames to "localhost"!  The Cluster
Manager will fail.  For example, alias "localhost" to "127.0.0.1" and NOT to
"192.168.1.1" (or whatever your public/domain IP address is).

If you need to change kernel settings permanently, instead of echoing values
to a pseudo-file in /proc on boot, make the change in /etc/sysctl.conf

If you want to try OCFS, you *must* follow Wim's guide on OTN (can't
remember the URL, but it was an OracleWorld presentation!).  Without
following that, 1.08 and 1.09 are deathly slow to the point of unusability.
Also beware that OCFS won't work out-of-the box with RH9.  I patched 1.08,
following guidelines that IBM used to patch XFS for RH9.  If you want the
patched source, let me know.


The rest of my notes seem to mostly relate to that MetaLink doc.  If you
have problems, post here!  There's enough of us that have tried it, that I'm
sure you'll get an answer faster than Oracle Support.  :)

HTH!  GL!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Friday, January 09, 2004 1:54 PM
To: Multiple recipients of list ORACLE-L


Ok spent < 1K for hardware, got 2, 2.0Ghz cpu, 1 G of ram, couple of 
ethernet cards(one for private heartbeat, other to put on internal 
network) computers and external firewire drive, doing RH AS 2.1, OCFS, etc.

gonna build a lab setup next week.

any pointers as to what gotchas would be appreciated, otherwise i'll 
hack my way thru it like usual :)

thanks, joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC and Forms6i

[Tim Gorman]

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 other way around.

Verify TNS listener connectivity via v806 version of "tnsping" first.  If
that doesn't work, then you have your problem at its most basic.  Next,
verify database connectivity via v806 version of "sqlplus".  If that doesn't
work, then again you have your problem at its most basic.

With errors like 12203 (i.e. "no listener found"), you should be able to
debug from the "tnsping" and "sqlplus" level.  If those work and your forms
continue to get these errors, and since these tools and the forms are
supposed to use the same SQL*Net stack, then this would best be explained by
a forms configuration problem.



on 12/1/03 4:09 AM, Bruno Vanters at [EMAIL PROTECTED] wrote:

> 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 problems.
> Search in Metalink revealed "The Certification of Database 9.2 with
> Forms 6i is incorrect at the
> concept level since the RSFs on which Forms/Reports are based cannot
> be made to work with the Database 9.2 components." so I got confused...
> Could you offer some advice for solving this problem?
> 
> K Gopalakrishnan wrote:
> 
>> 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 work with forms.
>> 
>> Is this what you are looking or something else?
>> 
>> 
>> Regards,
>> Gopal
>> 
>> --- Bruno Vanters <[EMAIL PROTECTED]> wrote:
>> 
>>> Hi all,
>>> 
>>> Oracle Forms & Reports patch 15 is certified with Oracle 9.2
>>> (according 
>>> to Metalink).
>>> Does that mean that Forms are certified against RAC too?
>>> Can anyone confirm that, having/knowing any working RAC9.2+Forms6i
>>> environments?
>>> 
>>> Thanks,
>>> Bruno Vanters
>>> Junior Oracle DBA
>>> 
>>> -- 
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>> -- 
>>> Author: Bruno Vanters
>>>  INET: [EMAIL PROTECTED]
>>> 
>>> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>>> San Diego, California-- Mailing list and web hosting services
>>> -
>>> To REMOVE yourself from this mailing list, send an E-Mail message
>>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>> the message BODY, include a line containing: UNSUB ORACLE-L
>>> (or the name of mailing list you want to be removed from).  You may
>>> also send the HELP command for other information (like subscribing).
>> 
>> 
>> 
>> =
>> Have a nice day !!
>> 
>> Best Regards,
>> K Gopalakrishnan,
>> Bangalore, INDIA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC and Forms6i

[Bruno Vanters]

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 problems.
Search in Metalink revealed "The Certification of Database 9.2 with 
Forms 6i is incorrect at the
concept level since the RSFs on which Forms/Reports are based cannot
be made to work with the Database 9.2 components." so I got confused...
Could you offer some advice for solving this problem?

K Gopalakrishnan wrote:

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 work with forms. 

Is this what you are looking or something else?

Regards,
Gopal
--- Bruno Vanters <[EMAIL PROTECTED]> wrote:

Hi all,

Oracle Forms & Reports patch 15 is certified with Oracle 9.2
(according 
to Metalink).
Does that mean that Forms are certified against RAC too?
Can anyone confirm that, having/knowing any working RAC9.2+Forms6i 
environments?

Thanks,
Bruno Vanters
Junior Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bruno Vanters
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bruno Vanters
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC and Forms6i

[K Gopalakrishnan]

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 work with forms. 

Is this what you are looking or something else?


Regards,
Gopal

--- Bruno Vanters <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Oracle Forms & Reports patch 15 is certified with Oracle 9.2
> (according 
> to Metalink).
> Does that mean that Forms are certified against RAC too?
> Can anyone confirm that, having/knowing any working RAC9.2+Forms6i 
> environments?
> 
> Thanks,
> Bruno Vanters
> Junior Oracle DBA
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bruno Vanters
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC and parallelism

[Tanel Poder]

> 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
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC listserv

[GovindanK]

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 no activity, but I think there was another one that mentioned a
> couple of weeks ago.
> 
> Thanks
> 
> Darren
> 
> 
> --
> Darren Browett P.EngThis
> message was transmitted
> Data Administrator  using
> 100% recycled electrons 
> Information and Communication Technology
> City of Coquitlam 
> P:(604)927 - 3614 
> E:[EMAIL PROTECTED] 
> 
> --- 

-- 
http://www.fastmail.fm - A fast, anti-spam email service.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC listserv

[Robertson Lee - lerobe]

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, it was officially launched at the
OW, Paris with the help of EOUG folks.  
 
With the new global RAC-SIG, we are happy to announce the launch of a new
global RAC-SIG discussion forum, that has no strings attached.  Its a
technical forum and requires no membership.  You can reach this discussion
forum at www.oracleracsig.org 

  
Regards,
 
Murali Vallath
President - RAC-SIG

[EMAIL PROTECTED]

Regards

Lee


-Original Message-
Sent: 13 November 2003 16:09
To: Multiple recipients of list ORACLE-L


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 no activity, but I think there was another one that mentioned a
couple of weeks ago.

Thanks

Darren


--
Darren Browett P.EngThis
message was transmitted
Data Administrator  using
100% recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).







**
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC and Standby Dr

[AK]

Rajesh ,
I think in 9i dataguard this task became little easier . It doesn't take
that much time to change role of database from primary to standby and vice
versa . That's what doc says I haven't tried it myself though.

-ak



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, October 12, 2003 10:29 PM


>
> Thanks for the reply, Pete.
>
> We recommended EMC SRDF to keep the production and DR in sync, but the
> budget cannot provide for it. Now, with a standby DR, what I am scared of
> is, it would take me say 15 minutes tops, to activate the standby in case
> of a production  site failure. But then, making the production back to
real
> production, and DR back to standby, will take much more testing and time.
>
> Regards
> Raj
>
>
>
>
>
> "Pete Sharman"
> <[EMAIL PROTECTED]   To: Multiple recipients of
list 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
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> 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
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long-term Oracle DBA
>
>
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Sunday, October 12, 2003 4:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Folks,
>
> A project team here is flirting with the idea of having standby databases
> for the two production RAC nodes. The two standy nodes will be at a DR
> site.
> Any gotchas with this configuration?
>
> Regards
> Raj
>
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC and Standby Dr

[Pete Sharman]

A couple of comments on this.  First, if you did go the route of using SRDF,
the only supported mode for Oracle databases is synchronous.  That can be a
real performance hit depending on your configuration.  Second, since you
mentioned RAC I assume you're on 9i and in that release you can switch over
and switch back for planned failovers.  IIRC, you still need to recreate the
primary if you have a unplanned failure of the primary which leads to a
period of risk where you have no site failover capability while you rebuild
the primary.  Having 2 or more standby's can help to address that problem.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L



Thanks for the reply, Pete.

We recommended EMC SRDF to keep the production and DR in sync, but the
budget cannot provide for it. Now, with a standby DR, what I am scared of
is, it would take me say 15 minutes tops, to activate the standby in case of
a production  site failure. But then, making the production back to real
production, and DR back to standby, will take much more testing and time.

Regards
Raj




 

"Pete Sharman"

<[EMAIL PROTECTED]   To: Multiple recipients of
list 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

Please respond

to ORACLE-L

 

 





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
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA



-Original Message-
[EMAIL PROTECTED]
Sent: Sunday, October 12, 2003 4:39 AM
To: Multiple recipients of list ORACLE-L


Folks,

A project team here is flirting with the idea of having standby databases
for the two production RAC nodes. The two standy nodes will be at a DR site.
Any gotchas with this configuration?

Regards
Raj




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC and Standby Dr

[Rajesh . Rao]

Thanks for the reply, Pete.

We recommended EMC SRDF to keep the production and DR in sync, but the
budget cannot provide for it. Now, with a standby DR, what I am scared of
is, it would take me say 15 minutes tops, to activate the standby in case
of a production  site failure. But then, making the production back to real
production, and DR back to standby, will take much more testing and time.

Regards
Raj




   
  
"Pete Sharman" 
  
<[EMAIL PROTECTED]   To: Multiple recipients of list 
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 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




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
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA



-Original Message-
[EMAIL PROTECTED]
Sent: Sunday, October 12, 2003 4:39 AM
To: Multiple recipients of list ORACLE-L


Folks,

A project team here is flirting with the idea of having standby databases
for the two production RAC nodes. The two standy nodes will be at a DR
site.
Any gotchas with this configuration?

Regards
Raj




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC and Standby Dr

[Pete Sharman]

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
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
[EMAIL PROTECTED]
Sent: Sunday, October 12, 2003 4:39 AM
To: Multiple recipients of list ORACLE-L


Folks,

A project team here is flirting with the idea of having standby databases
for the two production RAC nodes. The two standy nodes will be at a DR site.
Any gotchas with this configuration?

Regards
Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

[Niall Litchfield]

One of the reasons I nearly baarfed (sorry) coffee all over my keyboard
when I saw the larryism from Oracle world on IBM's capacity on demand '
yes it is capacity on demand but it costs 45k a processor'
pots,kettles,black the whole thing really. 

Niall 

> -Original Message-
> From: [EMAIL 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) in 
> addition to the EE price:
> 
> $20K, $20K, $10K, $10K, $10K.
> 
> Mogens
> 
> Hemant K Chitale wrote:
> 
> >
> > oops, I forgot to mention Partitioning pricing.
> > Partitioning is also listed seperately under Enterprise Edition 
> > options. This is 25% of the EE price.
> >
> > Thus, EE is US$40K per CPU.  RAC is US$60K per CPU [40K + 20K]. 
> > Partitioning is US$50K per CPU [40K + 10K]  and RAC with 
> Partitioning 
> > would be US$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.   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 can see "Oracle Enterprise Edition Options" listed 
> >> seperately from "Oracle Database". RAC is under Enterprise Edition 
> >> Options while EE is under Database and the RAC price is 
> 50% of the EE 
> >> price.
> >>
> >> Thus, an RAC price is 150% of an EE price.
> >> Hemant
> >>
> >> At 11:44 AM 24-09-03 -0800, you wrote:
> >>
> >>> My dear friend, you're wrong. That practice has stopped with 8i. 
> >>> Partitioning option *is* an integral part of 9iEE without an 
> >>> additional check to sign. I got a verbal confirmation 
> from my oracle 
> >>> sales rep and I'll try getting a written (email) one as well.
> >>>
> >>> --
> >>> Mladen Gogala
> >>> Oracle DBA
> >>>
> >>>
> >>>
> >>> > -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 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 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
> >>> > > an installation option,  else, RAC does not apear in 
> the Oracle 
> >>> > > product list when you run the Installer.
> >>> > >
> >>> > > Hemant
> >>> > >
> >>> > > At 06:54 AM 24-09-03 -0800, you wrote:
> >>> > >
> >>> > >> RAC is a part of the EE version, for whichever OS you
> >>> > have. You will
> >>> > >> still need
> >>> > >> to purchase the hardware.
> >>> > >>
> >>> > >>
> >>> > >> --
> >>> > >> Mladen Gogala
> >>> > >> Oracle DBA
> >>> > >>
> >

Re: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

[Mogens Nørgaard]

They are indeed, and their prices are (in the order you list them) in 
addition to the EE price:

$20K, $20K, $10K, $10K, $10K.

Mogens

Hemant K Chitale wrote:

oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25% of the EE price.
Thus, EE is US$40K per CPU.  RAC is US$60K per CPU [40K + 20K].
Partitioning is US$50K per CPU [40K + 10K]  and RAC with Partitioning 
would be US$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.   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 can see "Oracle Enterprise Edition Options" listed seperately from
"Oracle Database".
RAC is under Enterprise Edition Options while EE is under Database
and the RAC price is 50% of the EE price.
Thus, an RAC price is 150% of an EE price.
Hemant
At 11:44 AM 24-09-03 -0800, you wrote:

My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.
--
Mladen Gogala
Oracle DBA


> -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
> 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 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
> > an installation option,  else, RAC does not apear in the Oracle
> > product list
> > when you run the Installer.
> >
> > Hemant
> >
> > At 06:54 AM 24-09-03 -0800, you wrote:
> >
> >> RAC is a part of the EE version, for whichever OS you
> have. You will
> >> still need
> >> to purchase the hardware.
> >>
> >>
> >> --
> >> Mladen Gogala
> >> Oracle DBA
> >>
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> >> Behalf Of quriyat
> >> Sent: Wednesday, September 24, 2003 10:05 AM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: RAC for download
> >>
> >> Hello all
> >>
> >> Where can i get RAC for download? I don't see one in
> OTN. Oracle
> >> store puts a high tag?
> >>
> >> Thanks
> >>
> >>
> --
> --
> >> No banners. No pop-ups. No kidding.
> >> Introducing My Way - http://www.myway.com
> >>
> >>
> >> Note:
> >> This message is for the named person's use only.  It may contain
> >> confidential, proprietary or legally privileged information.  No
> >> confidentiality or privilege is waived or lost by any
> >> mistransmission.  If you receive this message in error, please
> >> immediately delete it and all copies of it from your
> system, destroy
> >> any hard copies of it and notify the sender.  You must
> not, directly
> >> or indirectly, use, disclose, distribute, print, or copy
> any part of
> >> this message if you are not the intended recipient. Wang
> Trading LLC
> >> and any of its subsidiaries each reserve the right to monitor all
> >> e-mail communications through its networks.  Any views
> expressed in
> >> this message are those of the individual sender, except where the
> >> message states otherwise and the sender is authorized to
> state them
> >> to be the views of any such entity.
> >>
> >>
> >
> > Hemant K Chitale
> > Oracle 9i Database Administrator Certified Professional
> > My personal web site is :  http://hkchital.tripod.c

RE: RE: RAC for download -- re RAC Pricing and Partitioning

[Matthew Zito]

Of course, this pricing bears no relation to actual reality.  70% discounts
off list, especially on the addons like RAC, are not uncommon.  You just
have to push a bit. :)

Matt 

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://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 to mention Partitioning pricing.
> Partitioning is also listed seperately under Enterprise 
> Edition options. This is 25% of the EE price.
> 
> Thus, EE is US$40K per CPU.  RAC is US$60K per CPU [40K + 
> 20K]. Partitioning is US$50K per CPU [40K + 10K]  and RAC 
> with Partitioning would 
> be US$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.   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 can see "Oracle Enterprise Edition Options" listed 
> seperately from 
> >"Oracle Database". RAC is under Enterprise Edition Options 
> while EE is 
> >under Database and the RAC price is 50% of the EE price.
> >
> >Thus, an RAC price is 150% of an EE price.
> >Hemant
> >
> >At 11:44 AM 24-09-03 -0800, you wrote:
> >>My dear friend, you're wrong. That practice has stopped with 8i. 
> >>Partitioning option *is* an integral part of 9iEE without an 
> >>additional check to sign. I got a verbal confirmation from 
> my oracle 
> >>sales rep and I'll try getting a written (email) one as well.
> >>
> >>--
> >>Mladen Gogala
> >>Oracle DBA
> >>
> >>
> >>
> >> > -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 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 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
> >> > > an installation option,  else, RAC does not apear in 
> the Oracle 
> >> > > product list when you run the Installer.
> >> > >
> >> > > Hemant
> >> > >
> >> > > At 06:54 AM 24-09-03 -0800, you wrote:
> >> > >
> >> > >> RAC is a part of the EE version, for whichever OS you
> >> > have. You will
> >> > >> still need
> >> > >> to purchase the hardware.
> >> > >>
> >> > >>
> >> > >> --
> >> > >> Mladen Gogala
> >> > >> Oracle DBA
> >> > >>
> >> > >> -Original Message-
> >> > >> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On
> >> > >> Behalf Of quriyat
> >> > >> Sent: Wednesday, September 24, 2003 10:05 AM
> >> > >> To: Multiple recipients of list ORACLE-L
> >> > >> Subject: RAC for download
> >> > >>
> >> > >> Hello all
> >> > >>
> >> > >> Where can i get RAC for downl

RE: RAC for download -- re RAC Pricing

[Mladen Gogala]

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 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 can see "Oracle Enterprise Edition Options" 
> listed seperately from "Oracle Database". RAC is under 
> Enterprise Edition Options while EE is under Database and the 
> RAC price is 50% of the EE price.
> 
> Thus, an RAC price is 150% of an EE price.
> Hemant
> 
> At 11:44 AM 24-09-03 -0800, you wrote:
> >My dear friend, you're wrong. That practice has stopped with 8i. 
> >Partitioning option *is* an integral part of 9iEE without an 
> additional 
> >check to sign. I got a verbal confirmation from my oracle 
> sales rep and 
> >I'll try getting a written (email) one as well.
> >
> >--
> >Mladen Gogala
> >Oracle DBA
> >
> >
> >
> > > -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 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 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
> > > > an installation option,  else, RAC does not apear in the Oracle 
> > > > product list when you run the Installer.
> > > >
> > > > Hemant
> > > >
> > > > At 06:54 AM 24-09-03 -0800, you wrote:
> > > >
> > > >> RAC is a part of the EE version, for whichever OS you
> > > have. You will
> > > >> still need
> > > >> to purchase the hardware.
> > > >>
> > > >>
> > > >> --
> > > >> Mladen Gogala
> > > >> Oracle DBA
> > > >>
> > > >> -Original Message-
> > > >> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On
> > > >> Behalf Of quriyat
> > > >> Sent: Wednesday, September 24, 2003 10:05 AM
> > > >> To: Multiple recipients of list ORACLE-L
> > > >> Subject: RAC for download
> > > >>
> > > >> Hello all
> > > >>
> > > >> Where can i get RAC for download? I don't see one in
> > > OTN. Oracle
> > > >> store puts a high tag?
> > > >>
> > > >> Thanks
> > > >>
> > > >>
> > > --
> > > --
> > > >> No banners. No pop-ups. No kidding.
> > > >> Introducing My Way - http://www.myway.com
> > > >>
> > > >>
> > > >> Note:
> > > >> This message is for the named person's use only.  It 
> may contain 
> > > >> confidential, proprietary or legally privileged 
> information.  No 
> > > >> confidentiality or privilege is waived or lost by any 
> > > >> mistransmission.  If you receive this message in error, please 
> > > >> immediately delete it and all copies of it from your
> > > system, destroy
> > > >> any hard copies of it and notify the sender.  You must
> > > not, directly
> > > >> or indirectly, use, disclose, distribute, print, or copy
> > > any part of
> > > >> this message if you are not

RE: RAC for download -- re RAC Pricing

[Tony Johnson]

EE  40,000/CPU
RAC 20,000/CPU
Partitioning10,000/CPU

List prices in US Dollars for each are above. Of course, the promised grid pricing 
that was supposed
to be out last week but isnt yet may effect this ... we can all hope at least.

-Original Message-
Sent: Thursday, September 25, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L



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 can see "Oracle Enterprise Edition Options" listed seperately from
"Oracle Database".
RAC is under Enterprise Edition Options while EE is under Database
and the RAC price is 50% of the EE price.

Thus, an RAC price is 150% of an EE price.
Hemant

At 11:44 AM 24-09-03 -0800, you wrote:
>My dear friend, you're wrong. That practice has stopped with 8i.
>Partitioning option *is* an integral part of 9iEE without an additional
>check to sign. I got a verbal confirmation from my oracle sales rep
>and I'll try getting a written (email) one as well.
>
>--
>Mladen Gogala
>Oracle DBA
>
>
>
> > -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
> > 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 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
> > > an installation option,  else, RAC does not apear in the Oracle
> > > product list
> > > when you run the Installer.
> > >
> > > Hemant
> > >
> > > At 06:54 AM 24-09-03 -0800, you wrote:
> > >
> > >> RAC is a part of the EE version, for whichever OS you
> > have. You will
> > >> still need
> > >> to purchase the hardware.
> > >>
> > >>
> > >> --
> > >> Mladen Gogala
> > >> Oracle DBA
> > >>
> > >> -Original Message-
> > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > >> Behalf Of quriyat
> > >> Sent: Wednesday, September 24, 2003 10:05 AM
> > >> To: Multiple recipients of list ORACLE-L
> > >> Subject: RAC for download
> > >>
> > >> Hello all
> > >>
> > >> Where can i get RAC for download? I don't see one in
> > OTN. Oracle
> > >> store puts a high tag?
> > >>
> > >> Thanks
> > >>
> > >>
> > --
> > --
> > >> No banners. No pop-ups. No kidding.
> > >> Introducing My Way - http://www.myway.com
> > >>
> > >>
> > >> Note:
> > >> This message is for the named person's use only.  It may contain
> > >> confidential, proprietary or legally privileged information.  No
> > >> confidentiality or privilege is waived or lost by any
> > >> mistransmission.  If you receive this message in error, please
> > >> immediately delete it and all copies of it from your
> > system, destroy
> > >> any hard copies of it and notify the sender.  You must
> > not, directly
> > >> or indirectly, use, disclose, distribute, print, or copy
> > any part of
> > >> this message if you are not the intended recipient. Wang
> > Trading LLC
> > >> and any of its subsidiaries each reserve the right to monitor all
> > >> e-mail communications through its networks.  Any views
> > expressed in
> > >> this message are those of the individual sender, except where the
> > >> message states otherwise and the sender is authorized to
> > state them
> > >> to be the views of any such entity.
> > >>
> > >>
> > >
> > &g

RE: RAC for download -- re RAC Pricing

[Hemant K Chitale]

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 can see "Oracle Enterprise Edition Options" listed seperately from
"Oracle Database".
RAC is under Enterprise Edition Options while EE is under Database
and the RAC price is 50% of the EE price.
Thus, an RAC price is 150% of an EE price.
Hemant
At 11:44 AM 24-09-03 -0800, you wrote:
My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.
--
Mladen Gogala
Oracle DBA


> -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
> 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 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
> > an installation option,  else, RAC does not apear in the Oracle
> > product list
> > when you run the Installer.
> >
> > Hemant
> >
> > At 06:54 AM 24-09-03 -0800, you wrote:
> >
> >> RAC is a part of the EE version, for whichever OS you
> have. You will
> >> still need
> >> to purchase the hardware.
> >>
> >>
> >> --
> >> Mladen Gogala
> >> Oracle DBA
> >>
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> >> Behalf Of quriyat
> >> Sent: Wednesday, September 24, 2003 10:05 AM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: RAC for download
> >>
> >> Hello all
> >>
> >> Where can i get RAC for download? I don't see one in
> OTN. Oracle
> >> store puts a high tag?
> >>
> >> Thanks
> >>
> >>
> --
> --
> >> No banners. No pop-ups. No kidding.
> >> Introducing My Way - http://www.myway.com
> >>
> >>
> >> Note:
> >> This message is for the named person's use only.  It may contain
> >> confidential, proprietary or legally privileged information.  No
> >> confidentiality or privilege is waived or lost by any
> >> mistransmission.  If you receive this message in error, please
> >> immediately delete it and all copies of it from your
> system, destroy
> >> any hard copies of it and notify the sender.  You must
> not, directly
> >> or indirectly, use, disclose, distribute, print, or copy
> any part of
> >> this message if you are not the intended recipient. Wang
> Trading LLC
> >> and any of its subsidiaries each reserve the right to monitor all
> >> e-mail communications through its networks.  Any views
> expressed in
> >> this message are those of the individual sender, except where the
> >> message states otherwise and the sender is authorized to
> state them
> >> to be the views of any such entity.
> >>
> >>
> >
> > Hemant K Chitale
> > Oracle 9i Database Administrator Certified Professional
> > My personal web site is :  http://hkchital.tripod.com
> > <http://hkchital.tripod.com/>
> >
> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
> > Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City
> > Network Services -- 858-538-5051 http://www.fatcity.com San Diego,
> > California -- Mailing list and web hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail
> message to:
> > [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> > message BODY, include a line containing: UNSUB ORACLE-L (or
> the name
> > of mailing list you want to be removed from). You 

Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

[Hemant K Chitale]

oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25% of the EE price.
Thus, EE is US$40K per CPU.  RAC is US$60K per CPU [40K + 20K].
Partitioning is US$50K per CPU [40K + 10K]  and RAC with Partitioning would 
be US$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.   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 can see "Oracle Enterprise Edition Options" listed seperately from
"Oracle Database".
RAC is under Enterprise Edition Options while EE is under Database
and the RAC price is 50% of the EE price.
Thus, an RAC price is 150% of an EE price.
Hemant
At 11:44 AM 24-09-03 -0800, you wrote:
My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.
--
Mladen Gogala
Oracle DBA


> -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
> 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 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
> > an installation option,  else, RAC does not apear in the Oracle
> > product list
> > when you run the Installer.
> >
> > Hemant
> >
> > At 06:54 AM 24-09-03 -0800, you wrote:
> >
> >> RAC is a part of the EE version, for whichever OS you
> have. You will
> >> still need
> >> to purchase the hardware.
> >>
> >>
> >> --
> >> Mladen Gogala
> >> Oracle DBA
> >>
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> >> Behalf Of quriyat
> >> Sent: Wednesday, September 24, 2003 10:05 AM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: RAC for download
> >>
> >> Hello all
> >>
> >> Where can i get RAC for download? I don't see one in
> OTN. Oracle
> >> store puts a high tag?
> >>
> >> Thanks
> >>
> >>
> --
> --
> >> No banners. No pop-ups. No kidding.
> >> Introducing My Way - http://www.myway.com
> >>
> >>
> >> Note:
> >> This message is for the named person's use only.  It may contain
> >> confidential, proprietary or legally privileged information.  No
> >> confidentiality or privilege is waived or lost by any
> >> mistransmission.  If you receive this message in error, please
> >> immediately delete it and all copies of it from your
> system, destroy
> >> any hard copies of it and notify the sender.  You must
> not, directly
> >> or indirectly, use, disclose, distribute, print, or copy
> any part of
> >> this message if you are not the intended recipient. Wang
> Trading LLC
> >> and any of its subsidiaries each reserve the right to monitor all
> >> e-mail communications through its networks.  Any views
> expressed in
> >> this message are those of the individual sender, except where the
> >> message states otherwise and the sender is authorized to
> state them
> >> to be the views of any such entity.
> >>
> >>
> >
> > Hemant K Chitale
> > Oracle 9i Database Administrator Certified Professional
> > My personal web site is :  http://hkchital.tripod.com
> > <http://hkchital.tripod.com/>
> >
> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
> > Author: Hemant K 

RE: RAC for download

[Jamadagni, Rajendra]

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 at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: RAC for download

[Mogens Nørgaard]

Mladen, you old respected warrior you're wrong, I'm sad to inform you.

Another way to get to Tim's place is this:

Go to http://www.oracle.com/corporate/pricing/content.html
Hit Price lists on the left hand side.
Hit US Commercial Price List
Undskyld.

There have been no changes - none - to the pricing structure of this.

Mogens

Johnston, Tim wrote:

Um...  I'd definitely get that in writing...  I just looked at the oracle
store and it looks like partitioning is still an extra cost item...  I also
checked the price guide...
http://www.oracle.com/corporate/pricing/ePLext.PDF

This also listed partitioning as an "Enterprise Edition Option"...

Tim

-Original Message-
Sent: Wednesday, September 24, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L
My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.
--
Mladen Gogala
Oracle DBA 



 

-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 
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 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
   

an installation option,  else, RAC does not apear in the Oracle 
product list
when you run the Installer.

Hemant

At 06:54 AM 24-09-03 -0800, you wrote:

 

RAC is a part of the EE version, for whichever OS you 
   

have. You will
   

still need
to purchase the hardware.
--
Mladen Gogala
Oracle DBA
   -Original Message- 
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
   Behalf Of quriyat 
   Sent: Wednesday, September 24, 2003 10:05 AM 
   To: Multiple recipients of list ORACLE-L 
   Subject: RAC for download

   Hello all

   Where can i get RAC for download? I don't see one in 
   

OTN. Oracle
   

   store puts a high tag?

   Thanks

   
   

--
--
   

   No banners. No pop-ups. No kidding. 
   Introducing My Way - http://www.myway.com

Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any 
mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your 
   

system, destroy 
   

any hard copies of it and notify the sender.  You must 
   

not, directly 
   

or indirectly, use, disclose, distribute, print, or copy 
   

any part of 
   

this message if you are not the intended recipient. Wang 
   

Trading LLC 
   

and any of its subsidiaries each reserve the right to monitor all 
e-mail communications through its networks.  Any views 
   

expressed in 
   

this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to 
   

state them 
   

to be the views of any such entity.

   

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
<http://hkchital.tripod.com/>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City 
Network Services -- 858-538-5051 http://www.fatcity.com San Diego, 
California -- Mailing list and web hosting services 

 

- 
   

To REMOVE yourself from this mailing list, send an E-Mail 
 

message to: 
   

[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
message BODY, include a line containing: UNSUB ORACLE-L (or 
 

the name 
   

of mailing list you want to be removed from). You may also send the 
HELP command for other information (like subscribing).

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED]

RE: RAC for download - thanks2all who replied

[quriyat]

 --- 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 partitioning is still an extra cost item... I alsochecked the price guide...http://www.oracle.com/corporate/pricing/ePLext.PDFThis also listed partitioning as an "Enterprise Edition Option"...Tim-Original Message-Sent: Wednesday, September 24, 2003 3:45 PMTo: Multiple recipients of list ORACLE-L<My dear friend, you're wrong. That practice has stopped with 8i.Partitioning option *is* an integral part of 9iEE without an additionalcheck to sign. I got a verbal confirmation from my oracle sales repand I'll try getting a written (email) one as well.--Mladen GogalaOracle DBA > -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 > 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 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> > an installation option, else, RAC does not apear in the Oracle > > product list> > when you run the Installer.> >> > Hemant> >> > At 06:54 AM 24-09-03 -0800, you wrote:> >> >> RAC is a part of the EE version, for whichever OS you > have. You will> >> still need> >> to purchase the hardware.> >> > >> > >> --> >> Mladen Gogala> >> Oracle DBA> >>> >> -Original Message- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On> >> Behalf Of quriyat > >> Sent: Wednesday, September 24, 2003 10:05 AM > >> To: Multiple recipients of list ORACLE-L > >> Subject: RAC for download> >>> >> Hello all> >>> >> Where can i get RAC for download? I don't see one in > OTN. Oracle> >> store puts a high tag?> >>> >> Thanks> >>> >> > --> --> >> No banners. No pop-ups. No kidding. > >> Introducing My Way - http://www.myway.com> >>> >> > >> Note:> >> This message is for the named person's use only. It may contain> >> confidential, proprietary or legally privileged information. No > >> confidentiality or privilege is waived or lost by any > >> mistransmission. If you receive this message in error, please > >> immediately delete it and all copies of it from your > system, destroy > >> any hard copies of it and notify the sender. You must > not, directly > >> or indirectly, use, disclose, distribute, print, or copy > any part of > >>
  this message if you are not the intended recipient. Wang > Trading LLC > >> and any of its subsidiaries each reserve the right to monitor all > >> e-mail communications through its networks. Any views > expressed in > >> this message are those of the individual sender, except where the > >> message states otherwise and the sender is authorized to > state them > >> to be the views of any such entity.> >> > >> > >> > Hemant K Chitale> > Oracle 9i Database Administrator Certified Professional> > My personal web site is : http://hkchital.tripod.com> > > >No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com

RE: RAC for download

[Johnston, Tim]

Um...  I'd definitely get that in writing...  I just looked at the oracle
store and it looks like partitioning is still an extra cost item...  I also
checked the price guide...

http://www.oracle.com/corporate/pricing/ePLext.PDF

This also listed partitioning as an "Enterprise Edition Option"...

Tim


-Original Message-
Sent: Wednesday, September 24, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L


My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.

--
Mladen Gogala
Oracle DBA 



> -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 
> 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 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
> > an installation option,  else, RAC does not apear in the Oracle 
> > product list
> > when you run the Installer.
> >
> > Hemant
> >
> > At 06:54 AM 24-09-03 -0800, you wrote:
> >
> >> RAC is a part of the EE version, for whichever OS you 
> have. You will
> >> still need
> >> to purchase the hardware.
> >>  
> >>  
> >> --
> >> Mladen Gogala
> >> Oracle DBA
> >>
> >> -Original Message- 
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> >> Behalf Of quriyat 
> >> Sent: Wednesday, September 24, 2003 10:05 AM 
> >> To: Multiple recipients of list ORACLE-L 
> >> Subject: RAC for download
> >>
> >> Hello all
> >>
> >> Where can i get RAC for download? I don't see one in 
> OTN. Oracle
> >> store puts a high tag?
> >>
> >> Thanks
> >>
> >> 
> --
> --
> >> No banners. No pop-ups. No kidding. 
> >> Introducing My Way - http://www.myway.com
> >>
> >>  
> >> Note:
> >> This message is for the named person's use only.  It may contain
> >> confidential, proprietary or legally privileged information.  No 
> >> confidentiality or privilege is waived or lost by any 
> >> mistransmission.  If you receive this message in error, please 
> >> immediately delete it and all copies of it from your 
> system, destroy 
> >> any hard copies of it and notify the sender.  You must 
> not, directly 
> >> or indirectly, use, disclose, distribute, print, or copy 
> any part of 
> >> this message if you are not the intended recipient. Wang 
> Trading LLC 
> >> and any of its subsidiaries each reserve the right to monitor all 
> >> e-mail communications through its networks.  Any views 
> expressed in 
> >> this message are those of the individual sender, except where the 
> >> message states otherwise and the sender is authorized to 
> state them 
> >> to be the views of any such entity.
> >>  
> >>  
> >
> > Hemant K Chitale
> > Oracle 9i Database Administrator Certified Professional
> > My personal web site is :  http://hkchital.tripod.com
> > <http://hkchital.tripod.com/>
> >
> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
> > Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City 
> > Network Services -- 858-538-5051 http://www.fatcity.com San Diego, 
> > California -- Mailing list and web hosting services 
> > 
> - 
> > To REMOVE yourself from this mailing list, send an E-Mail 
> message to: 
> > [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
> > message BODY, include a line containing: UNSUB ORACLE-L (or 
> the name 
> > of mailing list you want to be remove

RE: RAC for download

[Mladen Gogala]

My dear friend, you're wrong. That practice has stopped with 8i.
Partitioning option *is* an integral part of 9iEE without an additional
check to sign. I got a verbal confirmation from my oracle sales rep
and I'll try getting a written (email) one as well.

--
Mladen Gogala
Oracle DBA 



> -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 
> 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 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
> > an installation option,  else, RAC does not apear in the Oracle 
> > product list
> > when you run the Installer.
> >
> > Hemant
> >
> > At 06:54 AM 24-09-03 -0800, you wrote:
> >
> >> RAC is a part of the EE version, for whichever OS you 
> have. You will
> >> still need
> >> to purchase the hardware.
> >>  
> >>  
> >> --
> >> Mladen Gogala
> >> Oracle DBA
> >>
> >> -Original Message- 
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> >> Behalf Of quriyat 
> >> Sent: Wednesday, September 24, 2003 10:05 AM 
> >> To: Multiple recipients of list ORACLE-L 
> >> Subject: RAC for download
> >>
> >> Hello all
> >>
> >> Where can i get RAC for download? I don't see one in 
> OTN. Oracle
> >> store puts a high tag?
> >>
> >> Thanks
> >>
> >> 
> --
> --
> >> No banners. No pop-ups. No kidding. 
> >> Introducing My Way - http://www.myway.com
> >>
> >>  
> >> Note:
> >> This message is for the named person's use only.  It may contain
> >> confidential, proprietary or legally privileged information.  No 
> >> confidentiality or privilege is waived or lost by any 
> >> mistransmission.  If you receive this message in error, please 
> >> immediately delete it and all copies of it from your 
> system, destroy 
> >> any hard copies of it and notify the sender.  You must 
> not, directly 
> >> or indirectly, use, disclose, distribute, print, or copy 
> any part of 
> >> this message if you are not the intended recipient. Wang 
> Trading LLC 
> >> and any of its subsidiaries each reserve the right to monitor all 
> >> e-mail communications through its networks.  Any views 
> expressed in 
> >> this message are those of the individual sender, except where the 
> >> message states otherwise and the sender is authorized to 
> state them 
> >> to be the views of any such entity.
> >>  
> >>  
> >
> > Hemant K Chitale
> > Oracle 9i Database Administrator Certified Professional
> > My personal web site is :  http://hkchital.tripod.com
> > <http://hkchital.tripod.com/>
> >
> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
> > Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City 
> > Network Services -- 858-538-5051 http://www.fatcity.com San Diego, 
> > California -- Mailing list and web hosting services 
> > 
> - 
> > To REMOVE yourself from this mailing list, send an E-Mail 
> message to: 
> > [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
> > message BODY, include a line containing: UNSUB ORACLE-L (or 
> the name 
> > of mailing list you want to be removed from). You may also send the 
> > HELP command for other information (like subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
>

Re: RAC for download

[Mogens Nørgaard]

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 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
an installation option,  else, RAC does not apear in the Oracle 
product list
when you run the Installer.

Hemant

At 06:54 AM 24-09-03 -0800, you wrote:

RAC is a part of the EE version, for whichever OS you have. You will 
still need
to purchase the hardware.
 
 
--
Mladen Gogala
Oracle DBA

-Original Message- 
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of quriyat 
Sent: Wednesday, September 24, 2003 10:05 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RAC for download

Hello all

Where can i get RAC for download? I don't see one in OTN. Oracle
store puts a high tag?
Thanks


No banners. No pop-ups. No kidding. 
Introducing My Way - http://www.myway.com

 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any 
mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy 
any hard copies of it and notify the sender.  You must not, directly 
or indirectly, use, disclose, distribute, print, or copy any part of 
this message if you are not the intended recipient. Wang Trading LLC 
and any of its subsidiaries each reserve the right to monitor all 
e-mail communications through its networks.  Any views expressed in 
this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them 
to be the views of any such entity.
 
 
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com 


-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City 
Network Services -- 858-538-5051 http://www.fatcity.com San Diego, 
California -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
message BODY, include a line containing: UNSUB ORACLE-L (or the name 
of mailing list you want to be removed from). You may also send the 
HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC for download

[Hemant K Chitale]

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
an installation option,  else, RAC does not apear in the Oracle
product list
when you run the Installer.
Hemant
At 06:54 AM 24-09-03 -0800, you wrote:
RAC is
a part of the EE version, for whichever OS you have. You will still
need
to purchase the hardware.
 
 
--
Mladen Gogala
Oracle DBA 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of quriyat 
Sent: Wednesday, September 24, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RAC for download

Hello all

Where can i get RAC for download? I don't see one in OTN. Oracle
store puts a high tag?

Thanks


No banners. No pop-ups. No kidding.
Introducing My Way -
http://www.myway.com 

 
Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any
mistransmission.  If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender.  You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this
message if you are not the intended recipient. Wang
Trading LLC and any of its subsidiaries each reserve the right
to monitor all e-mail communications through its networks.  Any
views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
 
 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : 
http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC for download

[Mladen Gogala]

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, 2003 10:05 
  AMTo: Multiple recipients of list ORACLE-LSubject: RAC 
  for download
  


  
Hello all
Where can i get RAC for download? I don't see one in OTN. Oracle 
store puts a high tag?
Thanks

  
  
  No banners. No pop-ups. No 
  kidding.Introducing My Way - http://www.myway.com 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

RE: RAC Parallel Query Issues

[Pete Sharman]

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
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Kulkarni
Sent: Tuesday, September 16, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L


We are on 2-Node Rac 9204/Solaris8.

We are having intermittent issues with parallel
queries (The table has only 470 records, executes <
1sec otherwise):

SQL> /
select count(*)from eod
*
ERROR at line 1:
ORA-12805: parallel query server died unexpectedly

Trace File has:
kxfp_send_callback
Send timed out to slave 65535 inst 1 (qref
0x63f85fd0)
*** 2003-09-15 18:33:25.034
*** SESSION ID:(63.533) 2003-09-15 18:33:25.034 kxfp_send_callback
Send timed out to slave 65535 inst 1 (qref
0x63fc2004)
kxfplsig
Could not signal error 10388 in server P032
with serial 371201
dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168,
cqr 0x63f97584, err 10387
Interrupt Info top=1 size=8 top
err=-2147473260
Query May be hanging.Check V$PX_SESSION
OPIRIP: Uncaught error 12800. Error stack:
ORA-12800: system appears too busy for parallel query
execution
ORA-10387: parallel query server interrupt (normal)

v$px_session : has number of Slave Processes hanging.

Truss for process on
Instance 1:
door_return(0x, 0, 0x, 0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
Err#62 ETIME
read(0, 0xFE6C35E4, 1024)   (sleeping...)
signotifywait() (sleeping...)
door_return(0x, 0, 0x, 0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)

Instance 2:
poll(0x02FF15CC, 2, 2500)   (sleeping...)
poll(0x02FF15CC, 2, 2500)   = 0
poll(0x02FF15CC, 2, 0)  = 0
poll(0x02FF15CC, 2, 2500)   (sleeping...)
poll(0x02FF15CC, 2, 2500)   = 0
poll(0x02FF15CC, 2, 0)  = 0
poll(0x02FF15CC, 2, 2500)   (sleeping...)
poll(0x02FF15CC, 2, 2500)   = 0


Any inputs would be greatly appreciated.

Thanks,
Ravi.


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC Parallel Query Issues

[Ravi Kulkarni]

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 DOP is DEFAULT * INSTANCES.
The DOP it was using was 48 (6 cpus*4 thr/cpu*2
instances)
This is the same setting in Production(infact with
more cpus and hence larger DOP) but has been running
fine. I guess the issue is magnified due to slaves
being spawned at the other node and the QC sync'ing
with them. I see huge number 'IPC send completion
sync' events during this time. 
I had to alter degree from 'Default' to 2 for some
tables and disable parallelism to smaller lookup
tables to get it working. These went unnoticed in a
single instance box.
Thanks,
Ravi.

--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> 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 regards,
> 
> Mogens
> 
> Ravi Kulkarni wrote:
> 
> >We are on 2-Node Rac 9204/Solaris8.
> >
> >We are having intermittent issues with parallel
> >queries (The table has only 470 records, executes <
> >1sec otherwise):
> >
> >SQL> /
> >select count(*)from eod
> >*
> >ERROR at line 1:
> >ORA-12805: parallel query server died unexpectedly
> >
> >Trace File has:
> >kxfp_send_callback
> >Send timed out to slave 65535 inst 1 (qref
> >0x63f85fd0)
> >*** 2003-09-15 18:33:25.034
> >*** SESSION ID:(63.533) 2003-09-15 18:33:25.034
> >kxfp_send_callback
> >Send timed out to slave 65535 inst 1 (qref
> >0x63fc2004)
> >kxfplsig
> >Could not signal error 10388 in server P032
> >with serial 371201
> >dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168,
> >cqr 0x63f97584, err 10387
> >Interrupt Info top=1 size=8 top
> >err=-2147473260
> >Query May be hanging.Check V$PX_SESSION
> >OPIRIP: Uncaught error 12800. Error stack:
> >ORA-12800: system appears too busy for parallel
> query
> >execution
> >ORA-10387: parallel query server interrupt (normal)
> >
> >v$px_session : has number of Slave Processes
> hanging.
> >
> >Truss for process on
> >Instance 1:
> >door_return(0x, 0, 0x, 0)
> >(sleeping...)
> >lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
> >(sleeping...)
> >lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
> >Err#62 ETIME
> >read(0, 0xFE6C35E4, 1024)   (sleeping...)
> >signotifywait() (sleeping...)
> >door_return(0x, 0, 0x, 0)
> >(sleeping...)
> >lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
> >(sleeping...)
> >
> >Instance 2:
> >poll(0x02FF15CC, 2, 2500)   (sleeping...)
> >poll(0x02FF15CC, 2, 2500)   = 0
> >poll(0x02FF15CC, 2, 0)  = 0
> >poll(0x02FF15CC, 2, 2500)   (sleeping...)
> >poll(0x02FF15CC, 2, 2500)   = 0
> >poll(0x02FF15CC, 2, 0)  = 0
> >poll(0x02FF15CC, 2, 2500)   (sleeping...)
> >poll(0x02FF15CC, 2, 2500)   = 0
> >
> >
> >Any inputs would be greatly appreciated.
> >
> >Thanks,
> >Ravi.
> >
> >
> >__
> >Do you Yahoo!?
> >Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> >http://sitebuilder.yahoo.com
> >  
> >
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also se

Re: RAC Parallel Query Issues

[Mogens Nørgaard]

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 regards,

Mogens

Ravi Kulkarni wrote:

We are on 2-Node Rac 9204/Solaris8.

We are having intermittent issues with parallel
queries (The table has only 470 records, executes <
1sec otherwise):
SQL> /
select count(*)from eod
*
ERROR at line 1:
ORA-12805: parallel query server died unexpectedly
Trace File has:
kxfp_send_callback
   Send timed out to slave 65535 inst 1 (qref
0x63f85fd0)
*** 2003-09-15 18:33:25.034
*** SESSION ID:(63.533) 2003-09-15 18:33:25.034
kxfp_send_callback
   Send timed out to slave 65535 inst 1 (qref
0x63fc2004)
kxfplsig
   Could not signal error 10388 in server P032
with serial 371201
   dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168,
cqr 0x63f97584, err 10387
   Interrupt Info top=1 size=8 top
err=-2147473260
   Query May be hanging.Check V$PX_SESSION
OPIRIP: Uncaught error 12800. Error stack:
ORA-12800: system appears too busy for parallel query
execution
ORA-10387: parallel query server interrupt (normal)
v$px_session : has number of Slave Processes hanging.

Truss for process on
Instance 1:
door_return(0x, 0, 0x, 0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
Err#62 ETIME
read(0, 0xFE6C35E4, 1024)   (sleeping...)
signotifywait() (sleeping...)
door_return(0x, 0, 0x, 0)
(sleeping...)
lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)
Instance 2:
poll(0x02FF15CC, 2, 2500)   (sleeping...)
poll(0x02FF15CC, 2, 2500)   = 0
poll(0x02FF15CC, 2, 0)  = 0
poll(0x02FF15CC, 2, 2500)   (sleeping...)
poll(0x02FF15CC, 2, 2500)   = 0
poll(0x02FF15CC, 2, 0)  = 0
poll(0x02FF15CC, 2, 2500)   (sleeping...)
poll(0x02FF15CC, 2, 2500)   = 0
Any inputs would be greatly appreciated.

Thanks,
Ravi.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC 9i database - gx$ views ?

[Mladen Gogala]

No, those are XXX$ views.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Browett, Darren
Sent: Wednesday, September 03, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L


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
???

Thanks

Darren


--
Darren Browett P.EngThis
message was transmitted
Data Administrator  using
100% recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC 9i database - gx$ views ?

[Jacques Kilchoer]

> -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 show any gx$ views?
for example, what does this show you?
select * from v$fixed_view_definition where view_name = 'V$PING' ;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC - setting up failover and load_balance

[laura pena]

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 for any input. --my single instance is called VLDB,  --I am using sqlplus to try and failover at the session level.  --All other assumption you stated are correct. --I can fail over the session itself (example listed)
SQL> select machine,failover_type,failover_method,failed_over,count(*)  2  from v$session  3  group by machine,failover_type,failover_method,failed_over  4  SQL> /
MACHINE  FAILOVER_TYPE -FAILOVER_M FAI   COUNT(*)-- --- --VLDBN2   SELECTBASIC  NO  
 1    
My error when I issue a svrctl stop instance -d VLDB instance -i VLDBN2
SQL> select count(*) From voicelog.cdr_table;select count(*) From voicelog.cdr_table  *ERROR at line 1:ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> select machine,failover_type,failover_method,failed_over,count(*)  2  from v$session  3  group by machine,failover_type,failover_method,failed_over;
MACHINE  FAILOVER_TYPE -FAILOVER_M FAI   COUNT(*)-- --- --VLDBN2   NONENONE   NO  14!

VLDBN2   SELECTBASIC  YES  1
 
Here is my new tnsnames.ora file. BTW, I was using a different client, now I just go onto the VLDBN2 box and set up the tnsnames as follow:LISTENERS_VLDB =  (ADDRESS_LIST =    (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN1)(PORT = 1521))    (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN2)(PORT = 1521))  )VLDB =  (DESCRIPTION =    (ADDRESS_LIST =  (LOAD_BALANCE =ON)  (FAILOVER=ON)  (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN2)(PORT = 1521))    )    (CONNECT_DATA =  (SERVER = DEDICATED)  (SERVICE_NAME = VLDB)  (FAILOVER_MODE= (TYPE=SELECT)
 (METHOD=BASIC) (BACKUP=SECONDARY) (RETRIES=10) (DELAY=10)  )    )  )SECONDARY =  (DESCRIPTION = (load_balance=NO) (failover=ON) (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN1)(PORT = 1521))    (CONNECT_DATA =    (SERVICE_NAME = VLDB)   (FAILOVER_MODE=  (TYPE=SELECT) 
 (METHOD=BASIC)  (RETRIES=10)  (DELAY=10)   )    )  )
VLDBN2 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN2)(PORT = 1521))    (CONNECT_DATA =  (SERVICE_NAME = VLDB)  (INSTANCE_NAME = VLDBN2)    )  )VLDBN1 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN1)(PORT = 1521))    (CONNECT_DATA =  (SERVICE_NAME = VLDB)  (INSTANCE_NAME = VLDBN1)    )  )EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))    )    (CONNECT_DATA =  (SID = PLSExtProc)  (PRESENTATION = RO)    ) 
 )LISTENER_VLDBN2 =  (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN2)(PORT = 1521))
LISTENER_VLDBN1 =  (ADDRESS = (PROTOCOL = TCP)(HOST = VLDBN1)(PORT = 1521))
Ron Yount <[EMAIL PROTECTED]> wrote:


I see some points that may be causing failover issues in the sample you supplied below:
 
Let's start by covering the 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" driver) thin clients cannot use TAF
2) This tnsnames entry comes from the tnsnames.ora on  you client/application host.
3) You have two instances: vldbn1, vldbn2 for a single database ? name unknown
4) You wish to operate with vldbn1 as the primary database, and vldbn2 as the secondary
 
Now let's apply those assumptions to your entry.
-
a) When the application connects, it does so with a Net Service Name of "VLDB"
 
b) Your failover=on parameter will allow an attempt to connect using two different listeners on port 1521 using the stated IP address.  Oracle will attempt both entries before giving you a failed "connection" error.
 
c) Your load_balance=yes parameter instructs oracle to randomly try one of your two connect descriptors (as opposed to a top down use of the list)
 
d) You will ONLY connect to an instance with a service_name of "vldbn2"  this may be the start of your problems, unless both instances are registering with their respective listeners with the same service_name (vldbn2).  You may want to consider a generic "sha

Re: RAC - setting up failover and load_balance

[Tim Gorman]

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, 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 non-functioning
TNS descriptor, not that the application should simply fail over and continue from another node. The application
will simply fail, without the desired "over", unless it's written using OCI, which is the only means for an 
application to resume on one of the surviving nodes. In other words, it is the TNS descriptor that "fails over", 
not your application. I hope that things are clearer now.
 
 
--
Mladen Gogala
Oracle DBA 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura pena
Sent: Tuesday, August 26, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RAC - setting up failover and load_balance

So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks if you are interested) and I am attempting to setup my failover and loadbalancing from a client.
 
 
I brought down VLDBN1 
and  Thought I should fail over to VLDB2 ... but I did not.
 
 
Here is what I have in my tnsnames.ora:
 
VLDB =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = yes)
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.25)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = VLDBN2)
   (FAILOVER_MODE=
 (BACKUP=SECONDAY)
  (TYPE=select)
  (METHOD=basic)
  (RETRIES=5)
  (DELAY=5)
   )
)
)
SECONDARY =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
 (CONNECT_DATA =
(SERVICE_NAME = VLDBN2)
)
)
 
Any ideas?

RE: RAC - setting up failover and load_balance

[Ron Yount]

Title: Message



I see 
some points that may be causing failover issues in the sample you supplied 
below:
 
Let's 
start by covering the 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" driver) thin clients cannot use 
TAF
2) 
This tnsnames entry comes from the tnsnames.ora on  you client/application 
host.
3) You 
have two instances: vldbn1, vldbn2 for a single database ? name 
unknown
4) You 
wish to operate with vldbn1 as the primary database, and vldbn2 as the 
secondary
 
Now 
let's apply those assumptions to your entry.
-
a) 
When the application connects, it does so with a Net Service Name of 
"VLDB"
 
b) 
Your failover=on parameter will allow an attempt to connect using two different 
listeners on port 1521 using the stated IP address.  Oracle will attempt 
both entries before giving you a failed "connection" error.
 
c) 
Your load_balance=yes parameter instructs oracle to randomly try one of your two 
connect descriptors (as opposed to a top down use of the 
list)
 
d) You 
will ONLY connect to an instance with a service_name of "vldbn2"  this may 
be the start of your problems, unless both instances are registering with their 
respective listeners with the same service_name (vldbn2).  You may want to 
consider a generic "shared by both instances", service_name of "vldb".  
This is done by setting the service_names parameter for each instance to the 
same value "vldbn2"  The service_name used for registration with the 
listener can be verified with lsnrctl services on each node.  You should 
find one service with two "instances" registered.  e.g. Service "vldb" has 
two handlers, "vldbn1" and "vldbn2"

This 
is where your initial "connect" information stops, and TAF configuration begins, 

therefore, the settings above are about establishing a 
new connection,
the 
settings below are about how TAF is going to handle a failure of your 
connection.


e) 
backup=secondary, when/if your connection is lost due to an instance failure on 
vldbn1, use a separate alias "SECONDARY" to get connected 
again.
 
f) 
type=select - If you are running a select statement, it will be replayed on the 
new connection and records you have not yet received will be given to 
application
 
g) 
retries=5, delay=5 (Consider increasing these, because you are only allowing 25 
seconds for instance recovery on the surviving instance and the ability to 
accept new connection requests).  It is not uncommon for this to take 
longer depending upon the nature of the primary instance 
failure..
 
h) 
method=basic, after failure, establish a new connection, e.g. Do not preconnect 
prior to failure
 
i) 
your "SECONDARY" Net Service Name entry looks fine, but note that in your 
original connection, you specified "service_name" of vldbn2, and you are 
specifying the same service name in this entry... No where do I see that you are 
allowing connections to an instance with a service name of vldbn1 (You probably 
intended to do this in the "VLDB" or primary entry.
 
HTH, 

Don't 
hesitate to ask additional questions.
 
If you 
use the following init/spfile parameters, the following entry should work after 
both instances are restarted to reflect the changes:
Instance 1: "instance_name = vldbn1" and "service_names 
= vldb" and "db_name = "vldb"

Instance 2: "instance_name = vldbn2" and "service_names 
= vldb" and "db_name = "vldb"

 

VLDB =(DESCRIPTION 
=    (FAILOVER=ON)    (LOAD_BALANCE 
= no) 
- Direct first attempt to vldbn1 host if it is available (Ordered 
attempts)    (ADDRESS_LIST 
=  (ADDRESS = (PROTOCOL = TCP)(HOST = 
10.10.250.25)(PORT = 1521)) -- Always try me 
first, if not available, use next 
entry.  (ADDRESS = (PROTOCOL = TCP)(HOST 
= 10.10.250.26)(PORT = 1521))    )    
(CONNECT_DATA =  (SERVER = 
DEDICATED)  (SERVICE_NAME = 
VLDB)       (FAILOVER_MODE=    
 (BACKUP=SECONDAY)    
  (TYPE=select)    
  (METHOD=basic)    
  (RETRIES=5)    
  (DELAY=5)       
)    ))
 
SECONDARY =(DESCRIPTION 
=
  
(FAILOVER=ON)
  
(LOAD_BALANCE=NO) - Try to direct entries to host with instance vldbn2 if 
available  (ADDRESS = (PROTOCOL = 
TCP)(HOST = 10.10.250.26)(PORT = 1521)) - Always 
try me first, if not available, try next 
entry.  (ADDRESS = (PROTOCOL = 
TCP)(HOST = 10.10.250.25)(PORT = 
1521)) (CONNECT_DATA 
=    (SERVICE_NAME = 
VLDB)    ))
HTH, 

Don't 
hesitate to ask additional questions.
-Ron-

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura 
  penaSent: Tuesday, August 26, 2003 4:49 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RAC - setting up failover and 
  load_balance
  So I have RAC setup ( Solaris 2.8 ,

RE: RAC - setting up failover and load_balance

[Mladen Gogala]

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 non-functioning
TNS 
descriptor, not that the application should simply fail over and continue from 
another node. The application
will 
simply fail, without the desired "over", unless it's written using OCI, which is 
the only means for an 
application to resume on one of the surviving nodes. In other words, it 
is the TNS descriptor that "fails over", 
not 
your application. I hope that things are clearer now.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura 
  penaSent: Tuesday, August 26, 2003 5:49 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RAC - setting up failover and 
  load_balance
  So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks 
  if you are interested) and I am attempting to setup my failover and 
  loadbalancing from a client.
   
   
  I brought down VLDBN1 
  and  Thought I should fail over to VLDB2 ... but I did not.
   
   
  Here is what I have in my tnsnames.ora:
   
  VLDB =(DESCRIPTION =    
  (FAILOVER=ON)    (LOAD_BALANCE = yes)    
  (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = 
  TCP)(HOST = 10.10.250.25)(PORT = 1521))  
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 
  1521))    )    (CONNECT_DATA 
  =  (SERVER = 
  DEDICATED)  (SERVICE_NAME = 
  VLDBN2)       
  (FAILOVER_MODE=     
  (BACKUP=SECONDAY)      
  (TYPE=select)      
  (METHOD=basic)      
  (RETRIES=5)      
  (DELAY=5)       )    
  ))
  SECONDARY =(DESCRIPTION =  (ADDRESS 
  = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))    
   (CONNECT_DATA =  
    (SERVICE_NAME = VLDBN2)    ))
   
  Any ideas?
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

Re: RAC - lms process

[K Gopalakrishnan]

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 bindling lms process to the
specific processor if your OS supports that. And also increasing the
priority also helps.

And there is an underscore parameter where you can change the lock down
converts, you can try that after checking with Oracle Support !




--- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> Running RAC on 9.2.0.3 the lms processes seem to be very busy.
> Anyone
> have any thoughts on that?
> 
> Robert
> -- 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC interconnects

[Jamadagni, Rajendra]

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:[EMAIL PROTECTED]]
Sent: Saturday, August 09, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RAC interconnects



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?


KG



--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Is it possible to somehow tell Oracle to use all available
> interconnects
> (between nodes) for the GC traffic? We have 2 private interconnects
> but we
> see all the traffic only on one of them. The other is used only if
> the first
> one is not available.
> 
> If Oracle could use both, it would balance the load too ??
> 
> Is it possible?
> 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 is an art !
> 
> >
*This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*1
> 



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: RAC interconnects

[K Gopalakrishnan]

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 support for any known issues (bugs??) for this
parameters. Otherwise you can use them..!


KG






--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> 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-
> Sent: Saturday, August 09, 2003 3:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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?
> 
> KG
> 
> 
> --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > 
> > Is it possible to somehow tell Oracle to use all available
> > interconnects
> > (between nodes) for the GC traffic? We have 2 private interconnects
> > but we
> > see all the traffic only on one of them. The other is used only if
> > the first
> > one is not available.
> > 
> > If Oracle could use both, it would balance the load too ??
> > 
> > Is it possible?
> > 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 is an art !
> > 
> > >
>
*This
> > e-mail message is confidential, intended only for the named
> > recipient(s) above and may contain information that is privileged,
> > attorney work product or exempt from disclosure under applicable
> law.
> > If you have received this message in error, or are not the named
> > recipient(s), please immediately notify corporate MIS at (860)
> > 766-2000 and delete this e-mail message from your computer, Thank
> >
>
you.*1
> > 
> 
> 
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> >
This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*2
> 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC interconnects

[Jamadagni, Rajendra]

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
 
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 is an art ! 

  -Original Message-From: Tim Gorman 
  [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 10:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  RAC interconnectsCheck out the init.ora 
  parameter CLUSTER_INTERCONNECTS.  Have never used it, but it appears to 
  be what you're 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 all available interconnects (between 
nodes) for the GC traffic? We have 2 private interconnects but we see all 
the traffic only on one of them. The other is used only if the first one is 
not available.If Oracle could use both, it would balance 
the load too ?? Is it possible? 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 is an art ! 
  
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: RAC interconnects

[Tim Gorman]

Title: Re: RAC interconnects



Check out the init.ora parameter CLUSTER_INTERCONNECTS.  Have never used it, but it appears to be what you’re 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 all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available.

If Oracle could use both, it would balance the load too ?? 

Is it possible? 
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 is an art ! 

RE: RAC interconnects

[Mladen Gogala]

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 GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Jamadagni, RajendraSent: Friday, August 08, 2003 9:09 
  AMTo: Multiple recipients of list ORACLE-LSubject: RAC 
  interconnects
  Hi all, 
  Is it possible to somehow tell Oracle to 
  use all available interconnects (between nodes) for the GC traffic? We have 2 
  private interconnects but we see all the traffic only on one of them. The 
  other is used only if the first one is not available.
  If Oracle could use both, it would balance 
  the load too ?? 
  Is it possible? 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 is an art ! 



Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, 
except where the message states otherwise and the sender is authorized to state 
them to be the views of any such entity.
 

Re: RAC interconnects

[K Gopalakrishnan]

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?

KG


--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Is it possible to somehow tell Oracle to use all available
> interconnects
> (between nodes) for the GC traffic? We have 2 private interconnects
> but we
> see all the traffic only on one of them. The other is used only if
> the first
> one is not available.
> 
> If Oracle could use both, it would balance the load too ??
> 
> Is it possible?
> 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 is an art !
> 
> >
*This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*1
> 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC - Configuring Disk Coordinator

[Jared Still]

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 guess I can ask our
> rep if no ones knows. -Should these LUNs be mirrored?
> - Coordinator disks are used to support IO fencing can anyone elborate how
> this happens?
>
> Thanks in advance,
>
> Lizz
>
>
>
> -
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC - Configuring Disk Coordinator

[Matthew Zito]

Title: Message



 
 Whoops - I missed  a question in there.  Smallest lun 
possible?  On the older HDS thunder systems, you can make teeny-tiny luns - 
I'm guessing the 9570V is the same way.  Make a raid group and carve a few 
small luns out of it.
 
Matt
--Matthew 
ZitoGridApp 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 
  Matthew ZitoSent: Friday, July 25, 2003 1:54 PMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: RAC - Configuring 
  Disk Coordinator
   
  To 
  answer your questions.
   
  1) 
  Ideally, yes, though they don't need to be.
  2) 
  Absolutely.  Veritas will get very unhappy if it loses access to those 
  disks
  3) 
  SCSI-3 Persistent Reservation.  When a node "malfunctions", another node 
  will issue a SCSI-3 reservation against the 3 coordinator disks.  When 
  the broken node tries to access those disks (as it does every few seconds 
  normally) it will be rejected and the box will panic (I'm pretty sure it 
  panics - test it)
   
  Feel 
  free to email me off-list if you have any other questions.
   
  Thanks,
  Matt
   
  --Matthew ZitoGridApp 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-LSubject: Re: RAC - 
Configuring Disk Coordinator

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 - Should each of these 3 LUN be on seperate 
  disks?- What is the smallest LUN that Hitachi 9570V can be? I guess I 
  can ask our rep if no ones knows.-Should these LUNs be mirrored? - 
  Coordinator disks are used to support IO fencing can anyone elborate how 
  this happens?
   
  Thanks in advance,
   
  Lizz
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software


Do you Yahoo!?Yahoo! 
SiteBuilder - Free, easy-to-use web site design 
software

RE: RAC - Configuring Disk Coordinator

[Matthew Zito]

Title: Message



 
To 
answer your questions.
 
1) 
Ideally, yes, though they don't need to be.
2) 
Absolutely.  Veritas will get very unhappy if it loses access to those 
disks
3) 
SCSI-3 Persistent Reservation.  When a node "malfunctions", another node 
will issue a SCSI-3 reservation against the 3 coordinator disks.  When the 
broken node tries to access those disks (as it does every few seconds normally) 
it will be rejected and the box will panic (I'm pretty sure it panics - test 
it)
 
Feel 
free to email me off-list if you have any other questions.
 
Thanks,
Matt
 
--Matthew ZitoGridApp 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-LSubject: Re: RAC - Configuring Disk 
  Coordinator
  
  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 - Should each of these 3 LUN be on seperate disks?- 
What is the smallest LUN that Hitachi 9570V can be? I guess I can ask our 
rep if no ones knows.-Should these LUNs be mirrored? - Coordinator 
disks are used to support IO fencing can anyone elborate how this 
happens?
 
Thanks in advance,
 
Lizz


Do you Yahoo!?Yahoo! 
SiteBuilder - Free, easy-to-use web site design 
software
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software

Re: RAC - Configuring Disk Coordinator

[laura pena]

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 - Should each of these 3 LUN be on seperate disks?- What is the smallest LUN that Hitachi 9570V can be? I guess I can ask our rep if no ones knows.-Should these LUNs be mirrored? - Coordinator disks are used to support IO fencing can anyone elborate how this happens?
 
Thanks in advance,
 
Lizz


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: RAC

[AK]

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 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 Windows on their laptop. You
> need to get a USB disk (or flash disk) to set up the raw partitions and
> you can run RAC on WIndows too...
> 
> 
> 
> 
> --- AK <[EMAIL PROTECTED]> wrote:
> > Is it possible to setup RAC in one box only. Just to play with it .
> > Dont have more hardware .
> > 
> > -ak
> 
> 
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[K Gopalakrishnan]

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 ORACLE-L
> 
> 
> 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 
> > 
> > -Original Message-
> > Sent: Monday, July 21, 2003 2:49 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Is it possible to setup RAC in one box only. Just to play with it .
> > Dont have more hardware .
> >  
> > -ak
> > 
> > 
> 
> 
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[Suhen Pather]

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 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 
> 
> -Original Message-
> Sent: Monday, July 21, 2003 2:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Is it possible to setup RAC in one box only. Just to play with it .
> Dont have more hardware .
>  
> -ak
> 
> 



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[K Gopalakrishnan]

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 
> 
> -Original Message-
> Sent: Monday, July 21, 2003 2:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Is it possible to setup RAC in one box only. Just to play with it .
> Dont have more hardware .
>  
> -ak
> 
> 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC

[K Gopalakrishnan]

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 Windows on their laptop. You
need to get a USB disk (or flash disk) to set up the raw partitions and
you can run RAC on WIndows too...




--- AK <[EMAIL PROTECTED]> wrote:
> Is it possible to setup RAC in one box only. Just to play with it .
> Dont have more hardware .
> 
> -ak


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC

[Niall Litchfield]

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 possible to setup RAC in one box only. Just 
  to play with it . Dont have more hardware .
   
  -ak

RE: RAC

[Jamadagni, Rajendra]

Title: Message



try with cluster_database=true ... Oracle will immediately start all the 
GC traffic...
 
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 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 Advanced Comeback 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 possible to do it with one - I know we've done it 
in the lab.  It wasn't me hands-on-the-keyboard doing the work, but as 
it was explained to me, you basically trick the sole node into thinking that 
it used to have a friend, and that friend had died in a horrible horrible 
accident and that it should boldly carry on for the both of 
them.
 
Matt
--Matthew ZitoGridApp 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 
  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, July 21, 2003 2:49 
PMTo: Multiple recipients of list ORACLE-LSubject: 
RAC
Is it possible to setup RAC in one box 
only. Just to play with it . Dont have more hardware .
 
-ak
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: RAC

[Odland, Brad]

Title: Message



You 
must of taken the Oracle Advanced Comeback 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 possible to do it with one - I know we've done it in the 
  lab.  It wasn't me hands-on-the-keyboard doing the work, but as it was 
  explained to me, you basically trick the sole node into thinking that it used 
  to have a friend, and that friend had died in a horrible horrible accident and 
  that it should boldly carry on for the both of them.
   
  Matt
  --Matthew ZitoGridApp 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 
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, July 21, 2003 2:49 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  RAC
  Is it possible to setup RAC in one box only. 
  Just to play with it . Dont have more hardware .
   
  -ak

RE: RAC

[Matthew Zito]

Title: Message



 
No, 
its definitely possible to do it with one - I know we've done it in the 
lab.  It wasn't me hands-on-the-keyboard doing the work, but as it was 
explained to me, you basically trick the sole node into thinking that it used to 
have a friend, and that friend had died in a horrible horrible accident and that 
it should boldly carry on for the both of them.
 
Matt
--Matthew ZitoGridApp 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 
  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, July 21, 2003 2:49 
PMTo: Multiple recipients of list ORACLE-LSubject: 
RAC
Is it possible to setup RAC in one box only. 
Just to play with it . Dont have more hardware .
 
-ak

RE: RAC

[Goulet, Dick]

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. Just 
  to play with it . Dont have more hardware .
   
  -ak

Re: RAC

[Ron Rogers]

AK,
 I remember reading about just what you want to do. It is complicated
to set up but it is do-able.
see METALINK:

Doc ID: Note:166830.1
- Single node
Type: BULLETIN
Status: PUBLISHED
Ron

>>> [EMAIL PROTECTED] 07/21/03 02:49PM >>>
Is it possible to setup RAC in one box only. Just to play with it .
Dont have more hardware .

-ak
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC or Oracle Fail Safe

[Tanel Poder]

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 
not forget, that also rollback of failed nodes uncommitted transactions has to 
be done!
 
Of 
course when you got more nodes, then the impact of one node failure would be 
smaller..
 
Tanel.
 

  
  Here I 
  would beg to differ. RAC is more safe. _Almost_ half of your online user (who 
  are on surviving node) won’t even notice the node failure when one node in a 
  RAC environment goes down. And those who were unlucky users (connected to 
  failed node), can connect immediately to the surviving node, without any 
  delay. Of course you need to configure these parameters manually. While in OFS 
  environment your users have to wait till the time surviving node brings up the 
  database and all related services (listener etc) completely. 
  
  The 
  price you may for these features is more money and more complex database 
  environment to manage.
   

RE: RAC or Oracle Fail Safe

[RAJESH DAYAL]

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 on the other

 

Yes you can do that. You can very well make use of
other node, in above ways. Advantage of running some standard services would be
that they will also fail-over to the surviving node. So _effectively_ you are using both the nodes
at any point of time. Here we have 2 node cluster where one node is running
Database and another node is running 9ias Server. and they failover to each
other automatically if one of them them goes down. In fact you can decide your
failback policies also so that the nodes know when (may be off-peak hour) to
fail-back once the failed node is back. 

 

Incase of
OFS, the database service fails over from one node to the other, and then it
starts, but it is automatic, right?

 

    Yes, it is a
configurable parameter and can be set to automatic mode.

 

When you talk
about Resources and that they can’t be shared, you are not referring to the
shared storage vault (we are using DAS – Direct Attached Storage) because that
has to be at least available to both the servers. And when the database fails
over from one server to the other, and it starts its services on the other
server, then the obviously that other server will make use of the DAS on which
reside our datafiles.

 

I think you got me wrong here. “They can’t be shared
at the same point of time”. Actually the shared storage would be physically
connected to both the nodes. And they can/will have multiple drives defined on
them ( say U,V,W,X).So at one point of time say U&V would be owned by node1
and W&X would be owned by node2. If node1 fails then node2 will own all the
4 drives U,V,W and X.

 

RAC costs
roughly 20k$ per CPU and it doesn’t come bundled with Oracle 9i License? (For
confirmation purposes)

 

    Absolutely
right.

 

From
various mails I gather that OFS is basically a safe bet, if the hardware
supporting is good. And if, God-forbid, one server goes down then the only time
lapse is the time it takes to start the services on the other server.

 

Here I would beg to differ. RAC is more safe. _Almost_ half of your online user (who are
on surviving node) won’t even notice the node failure when one node in a RAC
environment goes down. And those who were unlucky users (connected to failed
node), can connect immediately to the surviving node, without any delay. Of
course you need to configure these parameters manually. While in OFS
environment your users have to wait till the time surviving node brings up the
database and all related services (listener etc) completely. 

The price you may for these features is more money
and more complex database environment to manage.

 

The
transactions taking place at the time when main server goes down will be lost,
I mean it will give a feeling of hung database or some other error.

 

    I
think  users will have a
hung screen with/without some ORA error message.

 

Hope this helps you decide,

 

Regards,

Rajesh

 

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Hussain
Ahmed Qadri
Sent: Saturday, July 19, 2003
11:44 AM
To: Multiple recipients of list
ORACLE-L
Subject: 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 9iAS on one node and our main production database on the
other

2.  
Incase of OFS, the database service fails over from
one node to the other, and then it starts, but it is automatic, right?

3.  
When you talk about Resources and that they can’t be
shared, you are not referring to the shared storage vault (we are using DAS –
Direct Attached Storage) because that has to be at least available to both the
servers. And when the database fails over from one server to the other, and it
starts its services on the other server, then the obviously that other server
will make use of the DAS on which reside our datafiles.

4.  
RAC costs roughly 20k$ per CPU and it doesn’t come
bundled with Oracle 9i License? (For confirmation purposes) 

5.  
From various mails I gather that OFS is basically a
safe bet, if the hardware supporting is good. And if, God-forbid, one server
goes down then the only time lapse is the time it takes to start the services
on the other server.

6.  
The transactions taking place at the time when main
server goes down will be lost, I mean it will give a feeling of hung database
or some other error.

 

Thanks in advance, and

RE: RAC or Oracle Fail Safe

[Hussain Ahmed Qadri]

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 9iAS on one node and our main production database on the other

2.  
Incase of OFS, the database service fails over from
one node to the other, and then it starts, but it is automatic, right?

3.  
When you talk about Resources and that they can’t be
shared, you are not referring to the shared storage vault (we are using DAS –
Direct Attached Storage) because that has to be at least available to both the
servers. And when the database fails over from one server to the other, and it
starts its services on the other server, then the obviously that other server
will make use of the DAS on which reside our datafiles.

4.  
RAC costs roughly 20k$ per CPU and it doesn’t come
bundled with Oracle 9i License? (For confirmation purposes) 

5.  
From various mails I gather that OFS is basically a
safe bet, if the hardware supporting is good. And if, God-forbid, one server
goes down then the only time lapse is the time it takes to start the services
on the other server.

6.  
The transactions taking place at the time when main
server goes down will be lost, I mean it will give a feeling of hung database
or some other error.

 

Thanks in
advance, and waiting for your reply.

 

Regards,

 

Hussain

 

 

-Original
Message-
From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003
12:30 PM
To: Multiple recipients of list
ORACLE-L
Subject: 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 node at one point of time. ( Resource means Hard Disk Space, Oracle
Service, Listener etc).

RAC can give "Transparent Application Failover" TAF which is out of
consideration in OFS.

In case of node failure on RAC System, the user will just need to attempt
relogin and he will be connected _immediately_ to another surviving instance (
If tnsnames.ora is configured properly). While there is a significant amount of
delay in case of OFS, the Database service has to failover from one node to
another node and this may take it's own _sweet_ amount of time based on amount
and type of activity being performed on the database.

Of course both the systems are screwed when your (shared) storage system is
down ;-)

Lastly why would someone want to use only 1 out of 2 nodes when it is possible
to use both the nodes? One possible answer is that, on one node you configure
One server (say 9iAS) and on another node you configure database. Then under
normal condition they will run on their respective nodes and when one fails
they would switch-over to the surviving node. So your performance may suffer
for the time during which any node is down.

So you are the best judge to decide now ;-)

Just my .2 c

Regards,
Rajesh


 -Original Message-
HREF="" PROTECTED]">mailto:[EMAIL PROTECTED] 
On Behalf Of Hussain Ahmed Qadri
Sent:   Wednesday, July 16, 2003 8:44 PM
To: Multiple recipients of list ORACLE-L
Subject:    RAC or Oracle Fail Safe

Hello all,

We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using
W2K, and now are in the process of deploying Oracle 9i on it. For the purpose
of high availability (HA), we are deliberating on setting up either RAC or
Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle
Fail Safe, i.e. if one node is down due to any problem, then the other takes
over, then can we do without RAC?
Which of these two is more transparent to the user, i.e. which will take less
time to shift the load from one node (server) to the other node?
Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice
versa.

Regards,

Hussain

DBA SKMCH&RC

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hussain Ahmed Qadri
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list
and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC or Oracle Fail Safe

[Mercadante, Thomas F]

"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 when the morons running the data center install
software on the primary server and reboot the box.  Failsafe brings the DB
up on the other box without any problems.  Works great.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, July 16, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L


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 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.

-Original Message-
Sent: Wednesday, July 16, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L


Hello all,

We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes,
using W2K, and now are in the process of deploying Oracle 9i on it. For the
purpose of high availability (HA), we are deliberating on setting up either
RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA
with oracle Fail Safe, i.e. if one node is down due to any problem, then the
other takes over, then can we do without RAC?
Which of these two is more transparent to the user, i.e. which will take
less time to shift the load from one node (server) to the other node?
Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice
versa.

Regards,

Hussain

DBA SKMCH&RC

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hussain Ahmed Qadri
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tony Johnson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC or Oracle Fail Safe

[RAJESH DAYAL]

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 shifting (when active is down, passive becomes active) is transparent  to the user

Not true really, user's session will flash error message and he will have to re login. This is true in both the cases(unless you implement TAF "Transparent Application Failover" logics in your application for RAC". One major difference would be that in RAC user can re-login immediately, while in OFS he has to wait till the other node bring the database up.

-- Doesn't the second node automatically take over?

Yes other node can be configured to take over automatically base on some simple in-built logic. But a DB recovery might be required depending on specific cases.

--  And this means that the user has to log in again, do I get it right?

   Yes you are right here.

HTH,
Rajesh

 -Original Message-
HREF="">mailto:[EMAIL PROTECTED]]  On Behalf Of Hussain Ahmed Qadri
Sent:   Thursday, July 17, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject:    RE: RAC or Oracle Fail Safe

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 different on RAC?
We have the licensed RAC and Oracle Fail Safe CDs, so that is not an issue. I also believe that setting up RAC is more complex, so we wanted to confirm that if Fail Safe gives us HA, 24x7, and any change in node shifting (when active is down, passive becomes active) is transparent  to the user then we should go for Fail safe.
By the way, we intend to keep cluster settings of ACTIVE and PASSIVE, is there any issue regarding this?

Tanel Poder: you said that, " in event of failure you can start up instance on another node that will mount, recover and open the database."
Doesn't the second node automatically take over? And this means that the user has to log in again, do I get it right?


Best Regards,

Hussain

-Original Message-
Sent: Wednesday, July 16, 2003 10:44 PM
To: Multiple recipients of list ORACLE-L

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, in event of
failure you can start up instance on another node that will mount, recover
and open the database.

With RAC you can have some kind of transparent failover which is able to
reexecute your queries on survived instance, but AFAIK for uncommitted
transaction survivability your app has to be coded to support it. Also, with
RAC you may scale your system up to support more users in some cases.

RAC is additional $20k per CPU, FailSafe comes with EE, I believe.

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 7:44 PM


> Hello all,
>
> We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes,
using W2K, and now are in the process of deploying Oracle 9i on it. For the
purpose of high availability (HA), we are deliberating on setting up either
RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA
with oracle Fail Safe, i.e. if one node is down due to any problem, then the
other takes over, then can we do without RAC?
> Which of these two is more transparent to the user, i.e. which will take
less time to shift the load from one node (server) to the other node?
> Can any one explain the benefits of using RAC over Oracle Fail Safe, or
vice versa.
>
> Regards,
>
> Hussain
>
> DBA SKMCH&RC
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hussain Ahmed Qadri
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
A

RE: RAC or Oracle Fail Safe

[RAJESH DAYAL]

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 node at one point of time. ( Resource means Hard Disk Space, Oracle Service, Listener etc).

RAC can give "Transparent Application Failover" TAF which is out of consideration in OFS.

In case of node failure on RAC System, the user will just need to attempt relogin and he will be connected _immediately_ to another surviving instance ( If tnsnames.ora is configured properly). While there is a significant amount of delay in case of OFS, the Database service has to failover from one node to another node and this may take it's own _sweet_ amount of time based on amount and type of activity being performed on the database.

Of course both the systems are screwed when your (shared) storage system is down ;-)

Lastly why would someone want to use only 1 out of 2 nodes when it is possible to use both the nodes? One possible answer is that, on one node you configure One server (say 9iAS) and on another node you configure database. Then under normal condition they will run on their respective nodes and when one fails they would switch-over to the surviving node. So your performance may suffer for the time during which any node is down.

So you are the best judge to decide now ;-)

Just my .2 c

Regards,
Rajesh


 -Original Message-
HREF="">mailto:[EMAIL PROTECTED]]  On Behalf Of Hussain Ahmed Qadri
Sent:   Wednesday, July 16, 2003 8:44 PM
To: Multiple recipients of list ORACLE-L
Subject:    RAC or Oracle Fail Safe

Hello all,

We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC?
Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node?
Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa.

Regards,

Hussain

DBA SKMCH&RC

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hussain Ahmed Qadri
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC or Oracle Fail Safe

[Hussain Ahmed Qadri]

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 different on RAC?
We have the licensed RAC and Oracle Fail Safe CDs, so that is not an issue. I also 
believe that setting up RAC is more complex, so we wanted to confirm that if Fail Safe 
gives us HA, 24x7, and any change in node shifting (when active is down, passive 
becomes active) is transparent  to the user then we should go for Fail safe.
By the way, we intend to keep cluster settings of ACTIVE and PASSIVE, is there any 
issue regarding this?

Tanel Poder: you said that, " in event of failure you can start up instance on another 
node that will mount, recover and open the database."
Doesn't the second node automatically take over? And this means that the user has to 
log in again, do I get it right?


Best Regards,

Hussain

-Original Message-
Sent: Wednesday, July 16, 2003 10:44 PM
To: Multiple recipients of list ORACLE-L

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, in event of
failure you can start up instance on another node that will mount, recover
and open the database.

With RAC you can have some kind of transparent failover which is able to
reexecute your queries on survived instance, but AFAIK for uncommitted
transaction survivability your app has to be coded to support it. Also, with
RAC you may scale your system up to support more users in some cases.

RAC is additional $20k per CPU, FailSafe comes with EE, I believe.

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 7:44 PM


> Hello all,
>
> We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes,
using W2K, and now are in the process of deploying Oracle 9i on it. For the
purpose of high availability (HA), we are deliberating on setting up either
RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA
with oracle Fail Safe, i.e. if one node is down due to any problem, then the
other takes over, then can we do without RAC?
> Which of these two is more transparent to the user, i.e. which will take
less time to shift the load from one node (server) to the other node?
> Can any one explain the benefits of using RAC over Oracle Fail Safe, or
vice versa.
>
> Regards,
>
> Hussain
>
> DBA SKMCH&RC
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hussain Ahmed Qadri
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hussain Ahmed Qadri
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls .......

[VIVEK_SHARMA]

Matt,List

Does this have a benefit for SINGLE instance Database Server connected to Multiple 
Application Servers (Client Server Architecture) ? 

OS = Solaris 9 
Application , DB Servers = SF15K machines 
Network = 1 GBPS interconnects routing thru a switch 

May I further extend this to ask if you have any advisable Solaris 9 Kernel parameters 
settings as the %sys Utilization on the DB Server is Very High 
( 40 % ) for Hybrid nature of Trans ?

Thanks

Vivek


-Original Message-
Sent: Friday, July 11, 2003 2:14 AM
To: Multiple recipients of list ORACLE-L


Jumbo frames are the use of larger than normal MTU (Maximum Transmission
Unit) settings on gigabit Ethernet links.  The traditional limit for
Ethernet frames is 1500 bytes, which was fine for 10 and 100 megabit
Ethernet links.  With gigabit, however, since you lose a certain minimum
amount of bandwidth to signaling overhead (preamble, postamble, header
info, etc.) and that the Ethernet card has to do a certain minimum
processing for each Ethernet frame it receives, a huge amount of CPU
overhead can be spent on trying to fill a gigabit pipe.  The other
problem is that if the host(s) are sending/receiving data larger than
1500 bytes, the data packet has to be fragmented into multiple, smaller
packets, which then have to be reassembled on the far side.  Since this
all has to be done on the host CPU rather than the Ethernet card, it
increases both bus overhead and CPU time.

With jumbo frames, you use a >1500 byte MTU - the exact amount varies by
implementation, but they're generally in the 9000-9200 byte range.
That's a 6x improvement in the amount of data per ethernet frame, plus
there's less reassembly.  Unfortunately, Sun never really embraced it as
a technology, so unless you're running one of a couple of third-party
gigabit cards, I think you're probably out of luck.  

The specific relevance to RAC, which I somehow managed to mention, is
that data blocks being shuttled 'tween nodes (depending on the
blocksize) can be placed into a smaller number of ethernet frames,
reducing both latency and overhead.  Ideally, each block will fit into
one ethernet frame, but as always, YMMV.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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]> wrote:
> > 
> > And are you using jumbo frames on your interconnect?
> >  That can make a
> > significant contribution to reducing overhead from a
> > system standpoint.
> > 
> > Thanks,
> > Matt
> > 
> > --
> > Matthew Zito
> > GridApp Systems
> > Email: [EMAIL PROTECTED]
> > Cell: 646-220-3551
> > Phone: 212-358-8211 x 359
> > http://www.gridapp.com
> > 
> > > -Original 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, 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
> > > 
> > >  
> > > 
> > > 
> > > -Original Message-
> > > Ravi Kulkarni
> > > Sent: Thursday, July 10, 2003 9:30 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hello List,
> > > 
> > > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > > Consistently noticed the following :
> > > - Very high Kernel usage (averaging 45%) on TOP
> > > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > > Total ela time)
> > > - On trussing top process, found Oracle to be
> > issuing
> > > huge number of "times" system calls in addition to
> > 
> > > read/writes(which I think are select/inserts)

Re: RAC or Oracle Fail Safe

[Jared . Still]

And to add to that, I don't believe that FailSafe is even required to use 
Oracle with MS Clusters.

IIRC, it's just to simplify the cluster setup.

FailSafe certainly isn't need for setting up failover withi Veritas 
Cluster Server.

Jared







"Allen R. Lucas" <[EMAIL PROTECTED]>
Sent by: [EMAIL 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.



  
"Tanel Poder"   
 
[EMAIL PROTECTED]> cc:
            Sent by:   Subject: Re: RAC or Oracle 
Fail Safe 
[EMAIL PROTECTED]   
ty.com   
  
  
07/16/2003   
12:44 PM   
Please respond   
to ORACLE-L   
  
  




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, in event 
of
failure you can start up instance on another node that will mount, recover
and open the database.

With RAC you can have some kind of transparent failover which is able to
reexecute your queries on survived instance, but AFAIK for uncommitted
transaction survivability your app has to be coded to support it. Also,
with
RAC you may scale your system up to support more users in some cases.

RAC is additional $20k per CPU, FailSafe comes with EE, I believe.

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 7:44 PM


> Hello all,
>
> We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes,
using W2K, and now are in the process of deploying Oracle 9i on it. For 
the
purpose of high availability (HA), we are deliberating on setting up 
either
RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA
with oracle Fail Safe, i.e. if one node is down due to any problem, then
the
other takes over, then can we do without RAC?
> Which of these two is more transparent to the user, i.e. which will take
less time to shift the load from one node (server) to the other node?
> Can any one explain the benefits of using RAC over Oracle Fail Safe, or
vice versa.
>
> Regards,
>
> Hussain
>
> DBA SKMCH&RC
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hussain Ahmed Qadri
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Allen R. Lucas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www

Re: RAC or Oracle Fail Safe

[Allen R. Lucas]

EE is not required to FailSafe.  It comes at no cost with Standard Edition
as well.



   
 
"Tanel Poder"  
 
  
[EMAIL PROTECTED]> cc: 
 
Sent by:   Subject: Re: RAC or Oracle Fail Safe
 
[EMAIL PROTECTED]  
   
ty.com 
 
   
 
   
 
07/16/2003 
 
12:44 PM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




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, in event of
failure you can start up instance on another node that will mount, recover
and open the database.

With RAC you can have some kind of transparent failover which is able to
reexecute your queries on survived instance, but AFAIK for uncommitted
transaction survivability your app has to be coded to support it. Also,
with
RAC you may scale your system up to support more users in some cases.

RAC is additional $20k per CPU, FailSafe comes with EE, I believe.

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 7:44 PM


> Hello all,
>
> We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes,
using W2K, and now are in the process of deploying Oracle 9i on it. For the
purpose of high availability (HA), we are deliberating on setting up either
RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA
with oracle Fail Safe, i.e. if one node is down due to any problem, then
the
other takes over, then can we do without RAC?
> Which of these two is more transparent to the user, i.e. which will take
less time to shift the load from one node (server) to the other node?
> Can any one explain the benefits of using RAC over Oracle Fail Safe, or
vice versa.
>
> Regards,
>
> Hussain
>
> DBA SKMCH&RC
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hussain Ahmed Qadri
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing li

RE: RAC or Oracle Fail Safe

[Tony Johnson]

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 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.

-Original Message-
Sent: Wednesday, July 16, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L


Hello all,

We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, 
and now are in the process of deploying Oracle 9i on it. For the purpose of high 
availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. 
The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one 
node is down due to any problem, then the other takes over, then can we do without RAC?
Which of these two is more transparent to the user, i.e. which will take less time to 
shift the load from one node (server) to the other node?
Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa.

Regards,

Hussain

DBA SKMCH&RC

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hussain Ahmed Qadri
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tony Johnson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC or Oracle Fail Safe

[Tanel Poder]

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, in event of
failure you can start up instance on another node that will mount, recover
and open the database.

With RAC you can have some kind of transparent failover which is able to
reexecute your queries on survived instance, but AFAIK for uncommitted
transaction survivability your app has to be coded to support it. Also, with
RAC you may scale your system up to support more users in some cases.

RAC is additional $20k per CPU, FailSafe comes with EE, I believe.

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 7:44 PM


> Hello all,
>
> We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes,
using W2K, and now are in the process of deploying Oracle 9i on it. For the
purpose of high availability (HA), we are deliberating on setting up either
RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA
with oracle Fail Safe, i.e. if one node is down due to any problem, then the
other takes over, then can we do without RAC?
> Which of these two is more transparent to the user, i.e. which will take
less time to shift the load from one node (server) to the other node?
> Can any one explain the benefits of using RAC over Oracle Fail Safe, or
vice versa.
>
> Regards,
>
> Hussain
>
> DBA SKMCH&RC
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hussain Ahmed Qadri
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RAC system Calls

[Mladen Gogala]

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 != OPS and I don't have
any experience with RAC.


On 2003.07.11 20:24, Ravi Kulkarni wrote:
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 Solaris)
SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 164.22.21.1 UDP 61635
sflags SSKGXPT_UP
info for network 1
socket no 12IP 0.0.0.0  UDP 61636
sflags SSKGXPT_UP
Is there a workaround to make Oracle choose the
correct IP for the interconnect?
TIA,
Ravi.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> 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 are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
>
>
> -Original Message-
> Sent: Friday, July 11, 2003 4:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> sflags SSKGXPT_DOWN
>
> Even 172.168.193.2 is not one of the (2) IPs we have
> for interconnect.
>
> Thanks,
> Ravi.
>
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > 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
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> >
> >
> > -Original Message-
> > Sent: Friday, July 11, 2003 3:34 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Correct. Looks like we need to configure
> > CLUSTER_INTERCONNECTS parameter. Automatic
> > configuration (Sun Cluster3.0/RAC) did not choose
> > the
> > (correct) IP(s) for interconnect. KG noticed it. I
> > have sent netstat -ai, oradebug IPC dump, ping -s
> > info
> > to him. If you are interested, I can paste it
> here.
> >
> > -Thanks,
> > Ravi.
> > >
>
This
> > e-mail message is confidential, intended only for
> > the named recipient(s) above and may contain
> > information that is privileged, attorney work
> > product or exempt from disclosure under applicable
> > law. If you have received this message in error,
> or
> > are not the named recipient(s), please immediately
> > notify corporate MIS at (860) 766-2000 and delete
> > this e-mail message from your computer, Thank
> >
>
you.*2
> >
>
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
>
__
Do you Yahoo!?
SBC Yahoo! D

RE: RAC system Calls

[Ravi Kulkarni]

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 Solaris)

SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 164.22.21.1 UDP 61635
sflags SSKGXPT_UP
info for network 1
socket no 12IP 0.0.0.0  UDP 61636
sflags SSKGXPT_UP

Is there a workaround to make Oracle choose the
correct IP for the interconnect?

TIA,
Ravi.


--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> 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 are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 4:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
> sflags SSKGXPT_DOWN
> 
> Even 172.168.193.2 is not one of the (2) IPs we have
> for interconnect.
> 
> Thanks,
> Ravi.
> 
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > 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
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> > 
> > 
> > -Original Message-
> > Sent: Friday, July 11, 2003 3:34 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Correct. Looks like we need to configure
> > CLUSTER_INTERCONNECTS parameter. Automatic
> > configuration (Sun Cluster3.0/RAC) did not choose
> > the
> > (correct) IP(s) for interconnect. KG noticed it. I
> > have sent netstat -ai, oradebug IPC dump, ping -s
> > info
> > to him. If you are interested, I can paste it
> here.
> > 
> > -Thanks,
> > Ravi.
> > >
>
This
> > e-mail message is confidential, intended only for
> > the named recipient(s) above and may contain
> > information that is privileged, attorney work
> > product or exempt from disclosure under applicable
> > law. If you have received this message in error,
> or
> > are not the named recipient(s), please immediately
> > notify corporate MIS at (860) 766-2000 and delete
> > this e-mail message from your computer, Thank
> >
>
you.*2
> > 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---

RE: RAC system Calls

[Jamadagni, Rajendra]

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 are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Ravi Kulkarni [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls



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_UP    info for network 1
    socket no 0 IP 0.0.0.0   UDP 0
    sflags SSKGXPT_DOWN


Even 172.168.193.2 is not one of the (2) IPs we have
for interconnect.


Thanks,
Ravi.


--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> 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
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Correct. Looks like we need to configure
> CLUSTER_INTERCONNECTS parameter. Automatic
> configuration (Sun Cluster3.0/RAC) did not choose
> the
> (correct) IP(s) for interconnect. KG noticed it. I
> have sent netstat -ai, oradebug IPC dump, ping -s
> info
> to him. If you are interested, I can paste it here.
> 
> -Thanks,
> Ravi.
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
> 



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: RAC system Calls

[Ravi Kulkarni]

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
sflags SSKGXPT_DOWN

Even 172.168.193.2 is not one of the (2) IPs we have
for interconnect.

Thanks,
Ravi.

--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> 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
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Correct. Looks like we need to configure
> CLUSTER_INTERCONNECTS parameter. Automatic
> configuration (Sun Cluster3.0/RAC) did not choose
> the
> (correct) IP(s) for interconnect. KG noticed it. I
> have sent netstat -ai, oradebug IPC dump, ping -s
> info
> to him. If you are interested, I can paste it here.
> 
> -Thanks,
> Ravi.
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls

[Jamadagni, Rajendra]

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
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Ravi Kulkarni [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls



Correct. Looks like we need to configure
CLUSTER_INTERCONNECTS parameter. Automatic
configuration (Sun Cluster3.0/RAC) did not choose the
(correct) IP(s) for interconnect. KG noticed it. I
have sent netstat -ai, oradebug IPC dump, ping -s info
to him. If you are interested, I can paste it here.


-Thanks,
Ravi.



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: RAC system Calls

[Ravi Kulkarni]

Correct. Looks like we need to configure
CLUSTER_INTERCONNECTS parameter. Automatic
configuration (Sun Cluster3.0/RAC) did not choose the
(correct) IP(s) for interconnect. KG noticed it. I
have sent netstat -ai, oradebug IPC dump, ping -s info
to him. If you are interested, I can paste it here.

-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..
> 
> 
> 
> Best Regards,
> K Gopalakrishnan
> 
> 
> 
> 
> -Original Message-
> Jamadagni, Rajendra
> Sent: Friday, July 11, 2003 7:34 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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 are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 8:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Raj,
> Yes. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> 
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls

[Jamadagni, Rajendra]

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 is an art ! 

  -Original Message-From: K Gopalakrishnan 
  [mailto:[EMAIL PROTECTED]Sent: Friday, July 11, 2003 1:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: 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
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: RAC system Calls

[K Gopalakrishnan]

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 Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, 
RajendraSent: Friday, July 11, 2003 7:34 AMTo: Multiple 
recipients of list ORACLE-LSubject: 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 are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 
-Original Message- Sent: 
Thursday, July 10, 2003 8:14 PM To: Multiple recipients 
of list ORACLE-L 
Raj, Yes. Timed_statistics=true. But I 
see the 'times' even in single instance(non-rac)database 
but relatively called negligible number of times. 
-Ravi. 

RE: RAC system Calls

[Gogala, Mladen]

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 

  clock_t times(struct tms *buffer);

 DESCRIPTION
  times() fills the structure pointed to by buffer with time-accounting
  information.  The structure defined in  is as follows:

   struct tms {
   clock_t tms_utime;  /* user time */
   clock_t tms_stime;  /* system time */"
   clock_t tms_cutime; /* user time, children */
   clock_t tms_cstime; /* system time, children */
   };

  This information comes from the calling process and each of its
  terminated child processes for which it has executed a wait(),
  wait3(), or waitpid().  The times are in units of 1/CLK_TCK seconds,
  where CLK_TCK is processor dependent The value of CLK_TCK can be
  queried using the sysconf() function (see sysconf(2)).


Your problem is with the preceding "read" call. Try to figure out where is
attempting to read from, is there a process handling the file/device and
to which process is all that kernel CPU time billed. Try with ps -el and
top. Also, try with "netstat -i" to see whether you're retransmitting on
the high speed interconnect.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, July 11, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L


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:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED0D8) 
 = 225698576
26949:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBED0D8) 
 = 225698577

Thanks,
Ravi.
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> 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. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > 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 ... but I
> could
> > be very well wrong, I
> > have RAC experience, but never tried to truss the
> > top processes.
> > 
> > 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
> is
> > an art !
> > 
> > 
> > -Original Message-
> > Sent: Thursday, July 10, 2003 12:30 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello List,
> > 
> > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > Consistently noticed the following :
> > - Very high Kernel usage (averaging 45%) on TOP 
> > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > Total ela time)
> > - On trussing top process, found Oracle to be
> > issuing
> > huge number of "times" system calls in addition to
> > read/writes(which I think are select/inserts).
> > Has anyone noticed this in your environment. I am
> > guessing these to be inter-instance pings, but
> could
> > not get any hits in Doc/Metalink to confirm this.
> > "times" call is clocking lot of CPU. Is this
> normal
> > ? 
> > Any pointers would be helpful ? If this is out of
> > context, is there a separate list for RAC?
> > 
> > Thanks,
> > Ravi.
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.c

RE: RAC system Calls

[Ravi Kulkarni]

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:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED0D8) 
 = 225698576
26949:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBED0D8) 
 = 225698577

Thanks,
Ravi.
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> 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. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > 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 ... but I
> could
> > be very well wrong, I
> > have RAC experience, but never tried to truss the
> > top processes.
> > 
> > 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
> is
> > an art !
> > 
> > 
> > -Original Message-
> > Sent: Thursday, July 10, 2003 12:30 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello List,
> > 
> > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > Consistently noticed the following :
> > - Very high Kernel usage (averaging 45%) on TOP 
> > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > Total ela time)
> > - On trussing top process, found Oracle to be
> > issuing
> > huge number of "times" system calls in addition to
> > read/writes(which I think are select/inserts).
> > Has anyone noticed this in your environment. I am
> > guessing these to be inter-instance pings, but
> could
> > not get any hits in Doc/Metalink to confirm this.
> > "times" call is clocking lot of CPU. Is this
> normal
> > ? 
> > Any pointers would be helpful ? If this is out of
> > context, is there a separate list for RAC?
> > 
> > Thanks,
> > Ravi.
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Ravi Kulkarni
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web
> > hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> > >
>
*This
> > e-mail message is confidential, intended only for
> > the named recipient(s) above and may contain
> > information that is privileged, attorney work
> > product or exempt from disclosure under applicable
> > law. If you have received this message in error,
> or
> > are not the named recipient(s), please immediately
> > notify corporate MIS at (860) 766-2000 and delete
> > this e-mail message from your computer, Thank
> >
>
you.*1
> > 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.o

RE: RAC system Calls

[Jamadagni, Rajendra]

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 are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, July 10, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L



Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: RAC system Calls

[Gogala, Mladen]

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. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> 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 ... but I could
> be very well wrong, I
> have RAC experience, but never tried to truss the
> top processes.
> 
> 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 is
> an art !
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 12:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello List,
> 
> We are running Benchmark tests on Solaris 2-Node
> RAC.
> Consistently noticed the following :
> - Very high Kernel usage (averaging 45%) on TOP 
> - Statspack has "IPC Send Completion sync" waits
> (70%
> Total ela time)
> - On trussing top process, found Oracle to be
> issuing
> huge number of "times" system calls in addition to
> read/writes(which I think are select/inserts).
> Has anyone noticed this in your environment. I am
> guessing these to be inter-instance pings, but could
> not get any hits in Doc/Metalink to confirm this.
> "times" call is clocking lot of CPU. Is this normal
> ? 
> Any pointers would be helpful ? If this is out of
> context, is there a separate list for RAC?
> 
> Thanks,
> Ravi.
> 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> >
*This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*1
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls

[Matthew Zito]

Nah - no reason not to use it, especially given how long they've been
around.  Basically you should enable jumbo frames everywhere you can -
whenever your box talks to a host that doesn't support them, it just
won't use them, and when it can it'll get the performance advantage
(side note: your switch has to support jumbo frames as well, but every
major managed switch manufacturer does, so that's not such a big deal).
Everyone wins.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Ravi Kulkarni
> Sent: Thursday, July 10, 2003 7:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC system Calls
> 
> 
> Hey Matt, 
> Thanks for the useful info.
> 
> >into a smaller number of ethernet frames,
> > reducing both latency and overhead.  Ideally, each
> > block will fit into one ethernet frame,
> We are using 16K blocksize, so we cannot avoid
> datagram splits with 9k frames - but certainly, sounds
> better than with 1500 frames.
> >so unless you're running one of a couple of
> third-party gigabit cards, I think you're probably out
> of luck. 
> Will check with SysAdmins if the GigE we have
> supports. Are there any risks/disadvantages of using
> 9k frames for interconnect?
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls

[Ravi Kulkarni]

Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> 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 ... but I could
> be very well wrong, I
> have RAC experience, but never tried to truss the
> top processes.
> 
> 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 is
> an art !
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 12:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello List,
> 
> We are running Benchmark tests on Solaris 2-Node
> RAC.
> Consistently noticed the following :
> - Very high Kernel usage (averaging 45%) on TOP 
> - Statspack has "IPC Send Completion sync" waits
> (70%
> Total ela time)
> - On trussing top process, found Oracle to be
> issuing
> huge number of "times" system calls in addition to
> read/writes(which I think are select/inserts).
> Has anyone noticed this in your environment. I am
> guessing these to be inter-instance pings, but could
> not get any hits in Doc/Metalink to confirm this.
> "times" call is clocking lot of CPU. Is this normal
> ? 
> Any pointers would be helpful ? If this is out of
> context, is there a separate list for RAC?
> 
> Thanks,
> Ravi.
> 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> >
*This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*1
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls

[Ravi Kulkarni]

Hey Matt, 
Thanks for the useful info.

>into a smaller number of ethernet frames,
> reducing both latency and overhead.  Ideally, each
> block will fit into one ethernet frame, 
We are using 16K blocksize, so we cannot avoid
datagram splits with 9k frames - but certainly, sounds
better than with 1500 frames.
>so unless you're running one of a couple of
third-party gigabit cards, I think you're probably out
of luck. 
Will check with SysAdmins if the GigE we have
supports. Are there any risks/disadvantages of using
9k frames for interconnect?

Thanks,
-Ravi.

--- Matthew Zito <[EMAIL PROTECTED]> wrote:
> 
> Jumbo frames are the use of larger than normal MTU
> (Maximum Transmission
> Unit) settings on gigabit Ethernet links.  The
> traditional limit for
> Ethernet frames is 1500 bytes, which was fine for 10
> and 100 megabit
> Ethernet links.  With gigabit, however, since you
> lose a certain minimum
> amount of bandwidth to signaling overhead (preamble,
> postamble, header
> info, etc.) and that the Ethernet card has to do a
> certain minimum
> processing for each Ethernet frame it receives, a
> huge amount of CPU
> overhead can be spent on trying to fill a gigabit
> pipe.  The other
> problem is that if the host(s) are sending/receiving
> data larger than
> 1500 bytes, the data packet has to be fragmented
> into multiple, smaller
> packets, which then have to be reassembled on the
> far side.  Since this
> all has to be done on the host CPU rather than the
> Ethernet card, it
> increases both bus overhead and CPU time.
> 
> With jumbo frames, you use a >1500 byte MTU - the
> exact amount varies by
> implementation, but they're generally in the
> 9000-9200 byte range.
> That's a 6x improvement in the amount of data per
> ethernet frame, plus
> there's less reassembly.  Unfortunately, Sun never
> really embraced it as
> a technology, so unless you're running one of a
> couple of third-party
> gigabit cards, I think you're probably out of luck. 
> 
> 
> The specific relevance to RAC, which I somehow
> managed to mention, is
> that data blocks being shuttled 'tween nodes
> (depending on the
> blocksize) can be placed into a smaller number of
> ethernet frames,
> reducing both latency and overhead.  Ideally, each
> block will fit into
> one ethernet frame, but as always, YMMV.
> 
> Thanks,
> Matt
> 
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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]> wrote:
> > > 
> > > And are you using jumbo frames on your
> interconnect?
> > >  That can make a
> > > significant contribution to reducing overhead
> from a
> > > system standpoint.
> > > 
> > > Thanks,
> > > Matt
> > > 
> > > --
> > > Matthew Zito
> > > GridApp Systems
> > > Email: [EMAIL PROTECTED]
> > > Cell: 646-220-3551
> > > Phone: 212-358-8211 x 359
> > > http://www.gridapp.com
> > > 
> > > > -Original 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, 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
> > > > 
> > > >  
> > > > 
> > > > 
> > > > -Original Message-
> > > > Ravi Kulkarni
> > > >

RE: RAC time clocks (sysdate)

[Matthew Zito]

Oh, that could definitely be true.  My impression on that point had
always been that the really bad form was to have all 100+ hosts on your
network hit the public stratum-1 servers, hence the delgation to local
stratum-2s.  But it is definitely better form to never touch the
stratum-1s.  So, if it wasn't proper manners before, Rich has convinced
me: Thou Shalt Not Use Stratum-1 Servers Unless Thou Art Sharing Thy
Stratum-2s

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Jesse, Rich
> Sent: Thursday, July 10, 2003 4:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC time clocks (sysdate)
> 
> 
> Hey Matt!
> 
> I thought that it was a bit of proper manners to avoid 
> hitting the public stratum-1 servers unless you were planning 
> on being a public stratum-2, just to avoid overloading the stratum-1s.
> 
> Thoughts?
> Rich
> 
> Rich Jesse 
> System/Database Administrator 
> 
> Quad/Tech Inc. 
> A Subsidiary of Quad/Graphics 
> 
> Sussex, Wisconsin USA
> 414-566-7633 phone 
> [EMAIL PROTECTED] 
> www.qtiworld.com 
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 3:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Beware, NTP can be a complicated critter to get working in a 
> proper fashion. The best way to configure your NTP is to have 
> one or two local stratum 2 or stratum 3 servers that all of 
> your nodes sync off of (a good choice for these servers are 
> servers that do other low-load internal services like mail 
> relay or DNS).  Those servers should each be configured with 
> two unique stratum 1 or 2 servers and then set up to peer off 
> of each other.  Then, point your database servers at your 
> stratum 2 servers.  If your servers are too far out of sync 
> with the rest of the world, NTP won't change the clocks 
> instantaneously, but will gradually "drift" your clocks into 
> sync.  If you want to rush the process, stop the ntpd 
> process, use ntpdate to set the clock one time, and then 
> restart ntp.  The drift should be small enough that will 
> immediately maintain synchronization.
>  
> The above config is a little bit over-engineered if you only 
> have a few hosts, but if you don't already have a global time 
> management system configured, now is the time (no pun 
> intended) to do it - its one of those things that should be 
> required for any infrastructure.  Properly synchronized time 
> makes things like auditing, monitoring, and general sanity an 
> order of magnitude easier.  The above system will easily 
> scale to up to a few hundred hosts and basically insures that 
> the time will be consistent across the infrastructure as a 
> whole.  The other nice thing about NTP is that its an 
> interesting protocol, for those who care about such things, 
> since it actually makes a distinct effort to take network 
> latency and so-such into consideration when setting the time.
>  
> Thanks,
> Matt
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC time clocks (sysdate)

[Jesse, Rich]

Hey Matt!

I thought that it was a bit of proper manners to avoid hitting the public
stratum-1 servers unless you were planning on being a public stratum-2, just
to avoid overloading the stratum-1s.

Thoughts?
Rich

Rich Jesse 
System/Database Administrator 

Quad/Tech Inc. 
A Subsidiary of Quad/Graphics 

Sussex, Wisconsin USA
414-566-7633 phone 
[EMAIL PROTECTED] 
www.qtiworld.com 


-Original Message-
Sent: Thursday, July 10, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


Beware, NTP can be a complicated critter to get working in a proper fashion.
The best way to configure your NTP is to have one or two local stratum 2 or
stratum 3 servers that all of your nodes sync off of (a good choice for
these servers are servers that do other low-load internal services like mail
relay or DNS).  Those servers should each be configured with two unique
stratum 1 or 2 servers and then set up to peer off of each other.  Then,
point your database servers at your stratum 2 servers.  If your servers are
too far out of sync with the rest of the world, NTP won't change the clocks
instantaneously, but will gradually "drift" your clocks into sync.  If you
want to rush the process, stop the ntpd process, use ntpdate to set the
clock one time, and then restart ntp.  The drift should be small enough that
will immediately maintain synchronization.
 
The above config is a little bit over-engineered if you only have a few
hosts, but if you don't already have a global time management system
configured, now is the time (no pun intended) to do it - its one of those
things that should be required for any infrastructure.  Properly
synchronized time makes things like auditing, monitoring, and general sanity
an order of magnitude easier.  The above system will easily scale to up to a
few hundred hosts and basically insures that the time will be consistent
across the infrastructure as a whole.  The other nice thing about NTP is
that its an interesting protocol, for those who care about such things,
since it actually makes a distinct effort to take network latency and
so-such into consideration when setting the time.
 
Thanks,
Matt
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC system Calls

[Matthew Zito]

Jumbo frames are the use of larger than normal MTU (Maximum Transmission
Unit) settings on gigabit Ethernet links.  The traditional limit for
Ethernet frames is 1500 bytes, which was fine for 10 and 100 megabit
Ethernet links.  With gigabit, however, since you lose a certain minimum
amount of bandwidth to signaling overhead (preamble, postamble, header
info, etc.) and that the Ethernet card has to do a certain minimum
processing for each Ethernet frame it receives, a huge amount of CPU
overhead can be spent on trying to fill a gigabit pipe.  The other
problem is that if the host(s) are sending/receiving data larger than
1500 bytes, the data packet has to be fragmented into multiple, smaller
packets, which then have to be reassembled on the far side.  Since this
all has to be done on the host CPU rather than the Ethernet card, it
increases both bus overhead and CPU time.

With jumbo frames, you use a >1500 byte MTU - the exact amount varies by
implementation, but they're generally in the 9000-9200 byte range.
That's a 6x improvement in the amount of data per ethernet frame, plus
there's less reassembly.  Unfortunately, Sun never really embraced it as
a technology, so unless you're running one of a couple of third-party
gigabit cards, I think you're probably out of luck.  

The specific relevance to RAC, which I somehow managed to mention, is
that data blocks being shuttled 'tween nodes (depending on the
blocksize) can be placed into a smaller number of ethernet frames,
reducing both latency and overhead.  Ideally, each block will fit into
one ethernet frame, but as always, YMMV.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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]> wrote:
> > 
> > And are you using jumbo frames on your interconnect?
> >  That can make a
> > significant contribution to reducing overhead from a
> > system standpoint.
> > 
> > Thanks,
> > Matt
> > 
> > --
> > Matthew Zito
> > GridApp Systems
> > Email: [EMAIL PROTECTED]
> > Cell: 646-220-3551
> > Phone: 212-358-8211 x 359
> > http://www.gridapp.com
> > 
> > > -Original 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, 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
> > > 
> > >  
> > > 
> > > 
> > > -Original Message-
> > > Ravi Kulkarni
> > > Sent: Thursday, July 10, 2003 9:30 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hello List,
> > > 
> > > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > > Consistently noticed the following :
> > > - Very high Kernel usage (averaging 45%) on TOP
> > > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > > Total ela time)
> > > - On trussing top process, found Oracle to be
> > issuing
> > > huge number of "times" system calls in addition to
> > 
> > > read/writes(which I think are select/inserts). Has
> > anyone
> > > noticed this in your environment. I am guessing
> > these to be
> > > inter-instance pings, but could not get any hits
> > in
> > > Doc/Metalink to confirm this. "times" call is
> > clocking lot of
> > > CPU. Is this normal ?
> > > Any pointers would be helpful ? If this is out of
> > > context, is there a separate list for RAC?
> > > 
> > > Thanks,
> > > Ravi.
> > > 
> > > 
> > > 
> > >