Re: RAC

2004-01-20 Thread 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

Re: RAC

2004-01-20 Thread Joe Testa
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

RE: RAC setup on linux [again]

2004-01-20 Thread 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

RE: RAC

2004-01-20 Thread Hengen, Brian
, 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

RE: RAC

2004-01-20 Thread 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

RE: RAC

2004-01-20 Thread 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

Re: What is JAWS 4.0.2 for RAC? How to get it?

2004-01-19 Thread quriyat
Great!!! May be this is your way of solving problems. --- On Fri 01/09, Mladen Gogala [EMAIL PROTECTED] wrote: To: [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 17:04:25 -0800 Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will come.

RE: RAC

2004-01-19 Thread k.sriramkumar
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

Re: RAC on Win2K using RMAN to Create Standby

2004-01-15 Thread 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.

RE: RAC on Win2K using RMAN to Create Standby

2004-01-15 Thread 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

RAC on Win2K using RMAN to Create Standby

2004-01-14 Thread jwiegand
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. Thanks, Jeff -- Please see the official ORACLE-L FAQ:

RE: RAC setup on linux

2004-01-12 Thread 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

Re: RAC setup on linux

2004-01-12 Thread 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

RAC setup on linux

2004-01-09 Thread Joe Testa
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

Books on rac

2004-01-09 Thread Joe Testa
any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. 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:

Re: Books on rac

2004-01-09 Thread K Gopalakrishnan
AS OF NOW, I have not come across a book which talks about RAC at a detailed level (at least to the level we expect). There are couple of books in the market, but they cover very little on RAC (Concepts and Internals) But, the Oracle Documentation (At least for the RAC part) is very good

Re: Books on rac

2004-01-09 Thread Ron Rogers
Joe, Last year at the midaltantic Oracle users group seminars there was a presentation by Mike Ault what was very informative on RAC with a budget. I believe that he has some decent information available. You might check www.rampant-books.com for his works. Ron [EMAIL PROTECTED] 01/09/2004 2:59

RE: Books on rac

2004-01-09 Thread Rognes, Sten
I've read a couple of the books available on RAC: - Oracle9i RAC by Madhu Tumma and Mike Ault is decent, I'd give it a 2.5 out of 5. Good multi-platform coverage and decent coverage of the internals. The book suffers from poor layout/editing. The graphics look like they're photocopied

RE: Books on rac

2004-01-09 Thread John Kanagaraj
Joe/Ron, Hope I am not beating anyone down, but a colleague has this particular book and said that much of it was a 'cut-and-paste' from the manual... I haven't read it yet, but I can verify this (offline) if you so need. OTOH, I do know that Murali Vallath has a book out on RAC, and I know

RE: RAC setup on linux

2004-01-09 Thread 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

Re: Books on rac

2004-01-09 Thread Ryan
beware the rampant press books. Most of them seem to be total garbage. All in large print with little detail. I didnt think much of the Ault Internals book from Rampant... its basically stuff you can copy and paste from metalink. Dont know about his RAC book. However, all the other non-Ault books

Re: Books on rac

2004-01-09 Thread William R. Jones
Partly because of the complexity of the technology and uniqueness of each environment, no book in the field will be 100 per cent of what anyone of us needs; however, the following is on my database team's bookshelves: Oracle 9i RAC By Mike Ault Published August 2003 by Rampant Tech Press ISBN

RE: RAC setup on linux

2004-01-09 Thread 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

RE: Books on rac

2004-01-09 Thread April Wells
Title: RE: Books on rac wait... mine wasn't THAT bad... isn't out yet... but isn't that bad. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas @-- Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From

Re[2]: Books on rac

2004-01-09 Thread Jonathan Gennick
Dont know about his RAC book. However, all the other non-Ault books from AW Rampant are total trash. AW There is another RAC book with some stuff on 10g by a guy who monitors this AW listserv(Murali Vallath). I have a copy of it, but have not read it yet. AW Anyone read either of those RAC books

Re: Books on rac

2004-01-09 Thread Arup Nanda
Title: RE: Books on rac "all the other non-Ault books from Rampant are total trash." That's a pretty strong statement, Ryan! Mine is a non-Ault Rampant book; does it count, too? Before you trash the book and commit the statement, can I interest you in at least taking a look at

RE: Re[2]: Books on rac

2004-01-09 Thread April Wells
Title: RE: Re[2]: Books on rac Hi Jonathan Don asked me if I would be interested in writing the Programmers Interview book... the Apps book was just done, so I took him up on the offer. I am writing for CRC... in fact I have one in process now for them. April -Original Message

Re: Books on rac

2004-01-09 Thread Ryan
Title: RE: Books on rac OK, that statement wasn't fair. I have not looked at Arup's book. I have no interest in HIPAA. So I shouldn't speak on it. These are the Rampant books I have skimmed through that I do not like. However, I have skimmed through several. All the one's I have looked

Re: Books on rac

2004-01-09 Thread Jared . Still
[EMAIL PROTECTED] cc: Subject:Re: Books on rac beware the rampant press books. Most of them seem to be total garbage. All in large print with little detail. I didnt think much of the Ault Internals book from Rampant... its basically stuff you can copy and paste from metalink. Dont

Re: Books on rac

2004-01-09 Thread Jared . Still
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Books on rac OK, that statement wasn't fair. I have not looked at Arup's book. I have no interest in HIPAA. So I shouldn't speak on it. These are the Rampant books I have skimmed through that I do not like

RE: RAC setup on linux

2004-01-09 Thread Jared . Still
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

What is JAWS 4.0.2 for RAC? How to get it?

2004-01-09 Thread quriyat
Thanks ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: What is JAWS 4.0.2 for RAC? How to get it?

2004-01-09 Thread Mladen Gogala
Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will come. On 2004.01.09 19:44, quriyat wrote: Thanks ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the

RAC with RMAN

2004-01-06 Thread Spears, Brian
Is anybody Running Rac on Unix that is also implemented RMAN on it as well? What type of setup or special considerations did you run into if any? I am considering my options with RAC and whether to expect any bumps with RMAN and/or extra considerations. Feedback is greatly appreciated

RE: Hardware for RAC?

2004-01-02 Thread Niall Litchfield
Title: Message I'd also ask myself am I 'evaluating' RAC in which case presumably whatever hardware you can lay your hands on will be fine, or am I 'testing' RAC in which case I'd suggest that you need to purchase the same hardware as you would be using in a live environment, which would

Hardware for RAC?

2003-12-31 Thread Ikediugwu, Chinedu SITI-ITPSIE
), but using same Oracleand OS versions (9.2.0.4 Linux respectively)? 2. Can I set RAC up, using only the public network? Thanks in advance Regards Chinedu

RE: Hardware for RAC?

2003-12-31 Thread Chandra Pabba
Title: Message Yes, you can use nodes from different OEM vendors for RAC. You will for sure need a private network or interconnect between the nodes for maintaining the heart-beat. HTH Chandra -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Hardware for RAC?

2003-12-31 Thread Ikediugwu, Chinedu SITI-ITPSIE
Title: Message Thanks a lot Chandra. Have a lovely New year -Original Message-From: Chandra Pabba [mailto:[EMAIL PROTECTED]Sent: 31 December 2003 15:04To: Multiple recipients of list ORACLE-LSubject: RE: Hardware for RAC? Yes, you can use nodes from different

RE: Hardware for RAC?

2003-12-31 Thread John Kanagaraj
RAC environment. Chinedu, before you launch into using/testing RAC, you should (or ITS should) ask itself the question 'Do I need RAC?'. Mogens Nørgaard, a gurufrom this list has an excellent article in IOUG's SELECT magazine on this topic. If you don't have IOUG membership, maybe Shell ITS can

ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC

2003-12-23 Thread Ranganath K
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC Hi there, I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied the 9.2.0.3.0

ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC

2003-12-23 Thread Ranganath K
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC Hi there, I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied the 9.2.0.3.0

RE: ORA-00600 signaled while mounting the database from the second instance of Oracle9i RAC

2003-12-23 Thread Jamadagni, Rajendra
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC Have you looked up on Metalink? there is ton of information out there. Raj Rajendra dot Jamadagni at nospamespn dot

RAC and Forms6i

2003-12-01 Thread Bruno Vanters
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

Re: RAC and Forms6i

2003-12-01 Thread 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

Re: RAC and Forms6i

2003-12-01 Thread 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

Re: RAC and Forms6i

2003-12-01 Thread 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

ORA-1652: unable to extend temp segment by 128 in tablespace TEMP on RAC

2003-12-01 Thread Ayhan Haktanir
Hi all, we upgrade 8.1.7 to 9.2.0.4 on RAC with 4 node we live performance problem. and to take ora-01652 temporary extent error. there is one temporary 25 GB before as default temporary tablespace. now new create temporary tablespace 25 GB on rawdevice and all user seting new temporary

RAC and parallelism

2003-11-26 Thread Bruno Vanters
, that it was done with height=3 and width=2. Could anyone explain me the cause of this error? I am using RAC over NFSv3, 9.2.0.4, kernel 2.6.0-test6 thanks, Bruno Vanters Junior Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruno Vanters INET: [EMAIL PROTECTED

Re: RAC and parallelism

2003-11-26 Thread 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

RE: OFA and RAC on raw devices

2003-11-20 Thread Muqthar Ahmed
: Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. 3. UNDO (RAW FILES) - Each node will have

RAC == TAF not supported for sessions coming through db links.

2003-11-20 Thread Murali_Pavuloori/Claritas
Yong, That is the problem. It is not documented. I think that is the reason why we went down that path of designing our application. I have an email from oracle rep (RAC team member). He confirmed that with Oracle product development. We were running RAC on Tru 64. I was told

OFA and RAC on raw devices

2003-11-19 Thread Gilles PARC
Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems

RE: OFA and RAC on raw devices

2003-11-19 Thread Muqthar Ahmed
Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. 3. UNDO (RAW FILES) - Each node

RE: OFA and RAC on raw devices

2003-11-19 Thread Gilles PARC
feature ? If you used soft links for datafiles, it means you have some sort of /oradata/db_name/ structure on each node. Right ? Does this prove helpful ? Regards At 06:05 19/11/2003 -0800, you wrote: Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access

Re: Does anything run on RAC? paper

2003-11-14 Thread Mogens Nørgaard
, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much appreciated. Thanks in advance, Sten

Re: Does anything run on RAC? paper

2003-11-14 Thread Pete Finnigan
Hi Go to Jonathan Lewis's website and send him an email about it, http://www.jlcomp.demon.co.uk, kind regards Pete In article [EMAIL PROTECTED], Rognes, Sten [EMAIL PROTECTED] writes I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck

RE: Does anything run on RAC? paper

2003-11-14 Thread Rognes, Sten
PROTECTED], Rognes, Sten [EMAIL PROTECTED] writes I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much appreciated. Thanks in advance, Sten -- Please

RE: Does anything run on RAC? paper

2003-11-14 Thread Pete Sharman
- Rognes, Sten Sent: Friday, November 14, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much

RAC listserv

2003-11-13 Thread Browett, Darren
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

RE: RAC listserv

2003-11-13 Thread 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

Re: RAC listserv

2003-11-13 Thread 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

Does anything run on RAC? paper

2003-11-13 Thread Rognes, Sten
I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much appreciated. Thanks in advance, Sten -- Please see the official ORACLE-L FAQ: http

RE: Does anything run on RAC? paper

2003-11-13 Thread Pete Sharman
for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much appreciated. Thanks in advance, Sten -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC

2003-11-06 Thread Jonathan Gennick
Wednesday, November 5, 2003, 9:14:34 AM, Hemant K Chitale ([EMAIL PROTECTED]) wrote: HKC There are times when you cannot afford to lose CACHed values, as John HKC Kanagaraj has pointed out HKC in Oracle Applications when generating Cheque numbers. Such sequences HKC required a patch in HKC

RE: Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC

2003-11-06 Thread Thater, William
Jonathan Gennick scribbled on the wall in glitter crayon: Would NOCACHE really prevent loss of sequence values? It seems to me that you could still find yourself in a situation where you grab NEXTVAL from a sequence, causing it to increment, and then you rollback your transaction. The

RE: Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC

2003-11-06 Thread Lord David
. Regards Daid Lord -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 14:49 To: Multiple recipients of list ORACLE-L Subject: RE: Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC Jonathan Gennick scribbled on the wall in glitter crayon

RE: ORDER -- was Re[2]: Sequences in OPS/RAC

2003-11-05 Thread Hemant K Chitale
RAC and I always use ORDER when I create SEQUENCE. The following information is from Oracle Manual: ORDER is necessary only to guarantee ordered generation if you are using Oracle with Real Application Clusters. If you are using exclusive mode, sequence numbers are always generated in order

Re[2]: Sequences in OPS/RAC

2003-11-04 Thread Hemant K Chitale
sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle

Sequences in OPS/RAC

2003-11-03 Thread Hemant K Chitale
I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only

RE: Sequences in OPS/RAC

2003-11-03 Thread Mercadante, Thomas F
Certified Professional -Original Message- Sent: Monday, November 03, 2003 10:39 AM To: Multiple recipients of list ORACLE-L I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article

RE: Sequences in OPS/RAC

2003-11-03 Thread Jamadagni, Rajendra
- Sent: Monday, November 03, 2003 10:39 AM To: Multiple recipients of list ORACLE-L I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has

Re: Sequences in OPS/RAC

2003-11-03 Thread Mladen Gogala
expensive and impose significant overhead on your cluster. On 11/03/2003 10:39:26 AM, Hemant K Chitale wrote: I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott

Re: Sequences in OPS/RAC

2003-11-03 Thread Tim Gorman
Sequences are mastered by the single SYS.SEQ$ table in each database. Cached or uncached, RAC or non-RAC, OPS or non-OPS, sequence numbers generated by this mechanism are unique across a database, not by instance. Each instance updates SEQ$ as individual numbers (noncached) or ranges of numbers

Re: Sequences in OPS/RAC

2003-11-03 Thread Hemant K Chitale
significant overhead on your cluster. On 11/03/2003 10:39:26 AM, Hemant K Chitale wrote: I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID

Re[2]: Sequences in OPS/RAC

2003-11-03 Thread Jonathan Gennick
?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one

Re: Re[2]: Sequences in OPS/RAC

2003-11-03 Thread Mladen Gogala
On 11/03/2003 12:04:26 PM, Jonathan Gennick wrote: Can you point us to the article? My guess is that the author is not familiar with Oracle, That shouldn't be considered enough of a reason not to write articles about oracle, should it? Mladen Gogala Oracle DBA Note: This message is

RE: Re[2]: Sequences in OPS/RAC

2003-11-03 Thread Muqthar Ahmed
Hi, I have RAC and I always use ORDER when I create SEQUENCE. The following information is from Oracle Manual: ORDER is necessary only to guarantee ordered generation if you are using Oracle with Real Application Clusters. If you are using exclusive mode, sequence numbers are always

RE: Re[2]: Sequences in OPS/RAC

2003-11-03 Thread tim
The problem is that the ORDER clause comes at the expense of CACHE. You can use SQL tracing to verify that each use of the sequence causes an update of SYS.SEQ$ when ORDER is set, effectively rendering the CACHE setting a no-op. So, especially in an OPS/RAC environment, the use of ORDERED

RE: Re[2]: Sequences in OPS/RAC

2003-11-03 Thread John Kanagaraj
, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re[2]: Sequences in OPS/RAC The problem is that the ORDER clause comes at the expense of CACHE. You can use SQL tracing to verify that each use of the sequence causes an update of SYS.SEQ$ when ORDER is set, effectively rendering

OFA and RAC on raw devices

2003-11-03 Thread Gilles PARC
Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems

RE: 9I RAC corporate standard.

2003-10-30 Thread Piet de Visser
Group, Tru64 was made for RAC. If you have the choice: Go Tru64 (just ignore the fact the platform will be decommissioned, some orgs still run openvms, that was clustering...) Linux will run RAC, but it will help if you bring the T64 methods to Linux when setting it up: - choose a CFS

New global RAC-SIG and discussion forum

2003-10-30 Thread Murali Vallath
Hello listers, At OW, SF RAC users, IOUG and Oracle put their heads together to launch a new RAC-SIG. IOUGhas started aRAC-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 wasofficially launched

RE: 9I RAC corporate standard.

2003-10-30 Thread Browett, Darren
To: Multiple recipients of list ORACLE-L Group, Tru64 was made for RAC. If you have the choice: Go Tru64 (just ignore the fact the platform will be decommissioned, some orgs still run openvms, that was clustering...) Linux will run RAC, but it will help if you bring the T64 methods to Linux when

9i RAC on AIX 5L

2003-10-29 Thread Robertson Lee - lerobe
Hi, Oracle 9.2.0.3 AIX 5L Anyone out there suffered serious performance issues with sorts to disk on this platform. we are using GPFS filesystems. The same query took about 16 minutes on a 8.1.7 database running on a small Tru/64 machine, the query on the p650/9.2.0.3 machine took over 6 hours

Re: 9i RAC on AIX 5L

2003-10-29 Thread Cesar Delgado
-L [EMAIL PROTECTED] cc: Subject:9i RAC on AIX 5L Hi, Oracle 9.2.0.3 AIX 5L Anyone out there suffered serious performance issues with sorts to disk on this platform. we are using GPFS filesystems. The same query took about 16 minutes on a 8.1.7 database running on a small Tru/64

RE: 9i RAC on AIX 5L

2003-10-29 Thread Robertson Lee - lerobe
recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9i RAC on AIX 5L Hi, Oracle 9.2.0.3 AIX 5L Anyone out there suffered serious performance issues with sorts to disk on this platform. we are using GPFS filesystems. The same query took about 16 minutes

RE: 9I RAC corporate standard.

2003-10-29 Thread Hemant K Chitale
on http://www.bradmark.com/site2/products/pdfs/9irac_config.pdf As far as I'm concerned, RAC's a major pain, unstable and not yet worth the risk -- for us. The idea for us being that we could move a DB or three to this RAC system with a no-cost OS on commodity hardware giving us HA and some load

RE: 9I RAC corporate standard.Jamadagni, Rajendra [Rajendra.Jamadagni@espn.com]

2003-10-29 Thread Spears, Brian
of list ORACLE-L [EMAIL PROTECTED] We don't have a corporate policy per se, but everything we have ('cept couple of dbs in the dmz) is RAC. PROD/DEVL/TEST/QA/DEMO etc etc everything same size same config (except maybe for scaled down SGA etc). Raj

RE: 9I RAC corporate standard.

2003-10-29 Thread Browett, Darren
I couldn't agree more, after the pains of an initial install (i.e. steep learning curve), I was able to create/re-create a test environment in 1-2 days. That included moving hardware around, setting up the SAN, installing the O/S, patching it, installing 9.2.0.1 rac, then patching

Re: 9I RAC corporate standard.

2003-10-29 Thread Tanel Poder
I tried installing RHAS 2.1 ($60 duhveloper edition), but it's so old (based on RH7.2) that it couldn't identify our newish hardware (Intel D845 MB). Just for the record, Redhat Enterprise Linux 3 is available now. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: 9I RAC corporate standard.

2003-10-29 Thread Jesse, Rich
H...interesting... http://ftp.redhat.com/pub/redhat/linux/enterprise/3/en/os/i386/SRPMS/ Me and a coworker are pondering rolling our own RHASESLESELSESES3 package for RAC testing... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED

Re: 9I RAC corporate standard.

2003-10-29 Thread Tanel Poder
- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 10:19 PM H...interesting... http://ftp.redhat.com/pub/redhat/linux/enterprise/3/en/os/i386/SRPMS/ Me and a coworker are pondering rolling our own RHASESLESELSESES3 package for RAC testing

9I RAC corporate standard.

2003-10-28 Thread Spears, Brian
Hi, Has anyone started to implement 9I Rac as a corporate standard... IE. many or all the apps being deployed on 9I RAC clusters? We are looking at doing it and wanted to know what other people had as experience in doing it or on the way to attempting it. If so, what hardware platform

RE: 9I RAC corporate standard.

2003-10-28 Thread Jesse, Rich
move a DB or three to this RAC system with a no-cost OS on commodity hardware giving us HA and some load-balancing. I tried installing RHAS 2.1 ($60 duhveloper edition), but it's so old (based on RH7.2) that it couldn't identify our newish hardware (Intel D845 MB). Without a clear path to add

RE: 9I RAC corporate standard.

2003-10-28 Thread Khedr, Waleed
I'm glad you had some energy left to describe your pain getting RAC to work on Linux (specially RHAS developer). I regret every minute of pain I spent trying to do the same! Waleed -Original Message- Sent: Tuesday, October 28, 2003 6:39 PM To: Multiple recipients of list ORACLE-L Well

RE: 9I RAC corporate standard.

2003-10-28 Thread Jamadagni, Rajendra
We don't have a corporate policy per se, but everything we have ('cept couple of dbs in the dmz) is RAC. PROD/DEVL/TEST/QA/DEMO etc etc everything same size same config (except maybe for scaled down SGA etc). Raj

RAC vs Fail Safe

2003-10-18 Thread Luc Demanche
Title: Message Hi gurus, I'm in a process of evaluating a high availability strategy. What the difference between RAC and Fail Safe ? Luc

RE: RAC and Standby Dr

2003-10-13 Thread 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

Re: RAC and Standby Dr

2003-10-13 Thread AK
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

RE: RAC and Standby Dr

2003-10-12 Thread 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

  1   2   3   4   5   6   >