Oracle 9i Rac scripts

2003-10-02 Thread Jack van Zanen
Hi All

Since I'm new to 9iRAC (as are a lot of people I guess) I need some help.
I'm working my way through the (tuning) docs and have compiled this set of
sql's for monitoring the Cluster. Could the people that have experience with
the 9i RAC cluster look at it and tell me what is missing or what is
absolute garbage. 

TIA


Jack







9iRAC.sql
Description: Binary data


Oracle 9i RAC on Windows using firewire

2003-03-05 Thread Jack van Zanen
Hi


We are not a Unix shop and would like to build a test setup of 9iRAC on
windows at the cheapest price.

I have a document that explains how to do it using SCSI disks but the parts
here are very expensive. I have heard that it is also possible to use
firewire disks to achieve the same. Does anybody have a document detailing
this setup? Technet mentions this only for LINUX and not for Windowz

TIA

Jacob A. van Zanen
Oracle DBA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jack van Zanen
  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: Oracle 9i RAC on Windows using firewire

2003-03-05 Thread Ron Rogers
Jack,
 www.tusc.com  has a white paper that created a RAC with firewire and
RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and
presented at the SEOUG Conference last month. 
Ron

 [EMAIL PROTECTED] 03/05/03 06:34AM 
Hi


We are not a Unix shop and would like to build a test setup of 9iRAC
on
windows at the cheapest price.

I have a document that explains how to do it using SCSI disks but the
parts
here are very expensive. I have heard that it is also possible to use
firewire disks to achieve the same. Does anybody have a document
detailing
this setup? Technet mentions this only for LINUX and not for Windowz

TIA

Jacob A. van Zanen
Oracle DBA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Jack van Zanen
  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: 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: Oracle 9i RAC on Windows using firewire

2003-03-05 Thread Arup Nanda
Try OakTable Network. They have a paper on Windows RAC setup details.
http://www.oaktable.net/userFiles.jsp.

Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 6:34 AM


 Hi


 We are not a Unix shop and would like to build a test setup of 9iRAC on
 windows at the cheapest price.

 I have a document that explains how to do it using SCSI disks but the
parts
 here are very expensive. I have heard that it is also possible to use
 firewire disks to achieve the same. Does anybody have a document detailing
 this setup? Technet mentions this only for LINUX and not for Windowz

 TIA

 Jacob A. van Zanen
 Oracle DBA


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Jack van Zanen
   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: Arup Nanda
  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: Oracle 9i RAC on Windows using firewire

2003-03-05 Thread Mark Leith
Jack,

Have you had a chat with Tom to see if they have upgraded the current $1000
RAC paper for windows? I think it was mentioned in the paper that they
planned to..

Mark

-Original Message-
Sent: 05 March 2003 14:06
To: Multiple recipients of list ORACLE-L


Jack,
 www.tusc.com  has a white paper that created a RAC with firewire and
RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and
presented at the SEOUG Conference last month.
Ron

 [EMAIL PROTECTED] 03/05/03 06:34AM 
Hi


We are not a Unix shop and would like to build a test setup of 9iRAC
on
windows at the cheapest price.

I have a document that explains how to do it using SCSI disks but the
parts
here are very expensive. I have heard that it is also possible to use
firewire disks to achieve the same. Does anybody have a document
detailing
this setup? Technet mentions this only for LINUX and not for Windowz

TIA

Jacob A. van Zanen
Oracle DBA


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jack van Zanen
  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: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: Oracle 9i RAC on Windows using firewire

2003-03-05 Thread Morten Egan
Hi,

It is true that the firewire stuff IS linux only. It was written by Wim 
Coekaerts (who I used to work together with in Oracle Dev.), who also 
wrote (together with his group) the cluster file system for linux. I 
haven't personally tried it yet, but an old collegue(sp?) of mine has 
tried it. Speedwise it still has some more ground to cover, but for a 
demo/test setup it's excellent and cheap.

Regards,
Morten
Jack van Zanen wrote:

Hi

We are not a Unix shop and would like to build a test setup of 9iRAC on
windows at the cheapest price.
I have a document that explains how to do it using SCSI disks but the parts
here are very expensive. I have heard that it is also possible to use
firewire disks to achieve the same. Does anybody have a document detailing
this setup? Technet mentions this only for LINUX and not for Windowz
TIA

Jacob A. van Zanen
Oracle DBA
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Morten Egan
 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: Oracle 9i RAC on Windows using firewire

2003-03-05 Thread Jack van Zanen
Hi Mark,



Yes

They did not have the expertise for firewire at the time (and still don't).
I'll figue it out somehow and inform him when it works.

Cheers


Jack

-Original Message-
Sent: woensdag 5 maart 2003 15:51
To: Multiple recipients of list ORACLE-L


Jack,

Have you had a chat with Tom to see if they have upgraded the current $1000
RAC paper for windows? I think it was mentioned in the paper that they
planned to..

Mark

-Original Message-
Sent: 05 March 2003 14:06
To: Multiple recipients of list ORACLE-L


Jack,
 www.tusc.com  has a white paper that created a RAC with firewire and
RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and
presented at the SEOUG Conference last month.
Ron

 [EMAIL PROTECTED] 03/05/03 06:34AM 
Hi


We are not a Unix shop and would like to build a test setup of 9iRAC
on
windows at the cheapest price.

I have a document that explains how to do it using SCSI disks but the
parts
here are very expensive. I have heard that it is also possible to use
firewire disks to achieve the same. Does anybody have a document
detailing
this setup? Technet mentions this only for LINUX and not for Windowz

TIA

Jacob A. van Zanen
Oracle DBA


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jack van Zanen
  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: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: Jack van Zanen
  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: Oracle 9i RAC

2002-10-22 Thread chao_ping
This is a multi-part message in MIME format.

--=002_Dragon673057471320_=
Content-Type: text/plain;
  charset=GB2312
Content-Transfer-Encoding: quoted-printable

[EMAIL PROTECTED]=A3=AC=C4=FA=BA=C3=A3=A1 

=A1=A1=A1=A1hi, just two nodes, cluster software, interconnect and the=
 shared disk.
Look at oracle metalink or otn oracle installation guide for=
 more help.

=3D=3D=3D=3D=3D=3D=3D=3D 2002-10-21 02:43:00 
=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D


Dear List, 

I am currently making a study on the Oracle 9i RAC. Could anybody=
 give me the hardware and software requirements for implementing=
 the same or a link to the same. 

Regards 
Prem Chandran N 

=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D 
=3D 
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2
=C0=F1=A3=A1

=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping
[EMAIL PROTECTED]
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-22

--=002_Dragon673057471320_=
Content-Type: text/html;
  charset=GB2312
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META content=3Dtext/html; charset=3Dgb2312=
 http-equiv=3DContent-Type
META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD
BODY bgColor=3D#eaeaeaFONT size=3D2FONT=
 face=3D=CB=CE=CC=E5[EMAIL PROTECTED]=A3=AC=C4=FA=BA=C3=A3=A1/FONT 
/FONT
DIVnbsp;/DIV
DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1hi, just two nodes, cluster=
 software, interconnect 
and the shared disk./FONT/DIV
DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Look at oracle=
 metalink or otn 
oracle installation guide for more help./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D=
 2002-10-21nbsp;02:43:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA 
=3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2
TABLE width=3D100%
  TBODY
  TR
TD width=3D100%
  BLOCKQUOTE 
  style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;=
 MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT:=
 0pxBRFONT 
face=3Dsans-serif size=3D2Dear List,/FONT BRBRFONT=
 face=3Dsans-serif 
size=3D2I am currently making a study on the Oracle 9i=
 RAC. Could anybody 
give me the hardware and software requirements for=
 implementing the same 
or a link to the same./FONT BRBRFONT=
 face=3Dsans-serif 
size=3D2Regards/FONT BRFONT face=3Dsans-serif=
 size=3D2Prem Chandran 
N/FONT=
 /BLOCKQUOTE/TD/TR/TBODY/TABLE/FONT/DIV
DIV
PFONT face=3D=CB=CE=CC=E5 size=3D2=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D 
=3D =3D =3D =3D =3D =3D =3D =3D=
 =3D =3D /FONT/P
PFONT face=3D=CB=CE=CC=E5 
size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2BR=C0=F1=A3=A1/FONT/P
DIVnbsp;/DIV
DIVFONT face=3D=CB=CE=CC=E5=
 
size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping/FONT/DIV
DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5=
 
size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA
 
href=3Dmailto:chao_ping;vip.163.com[EMAIL PROTECTED]/A/FO=
NT/DIV
DIVFONT face=3D=CB=CE=CC=E5=
 
size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-22/FONT/DIV=

DIVnbsp;/DIV/DIV/BODY/HTML

--=002_Dragon673057471320_=--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: chao_ping
  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).



Is Oracle 9i RAC out

2001-06-28 Thread Eric . Desai

I know that the Oracle 9i database is out for linux.  Does anyone know if
Oracle 9i Real Application Cluster is out yet for linux?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Is Oracle 9i RAC out

2001-06-28 Thread Oliver Artelt


Yes, is an option in the oui

oli

[EMAIL PROTECTED] wrote:
 I know that the Oracle 9i database is out for linux.  Does anyone know if
 Oracle 9i Real Application Cluster is out yet for linux?
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).
 
 

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH  Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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