Oracle 9i Rac scripts
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
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
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
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
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
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
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
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
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
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).