RE: PART2 - Yep.....it's a Monday......
Title: Yep.it's a Monday.. What the heck... Monday story from last week.. Low voltage guys were working under the raised floor in the datacenter to pull SAN cable and network cables. Upon getting to the patch panel (wrong one), they found no open ports on the Brocade Switch. so thinking that they had a little precedence, went ahead and unplugged a few:-) Took down a few servers and databases.. Now vendors dont have badges to the data center;-) greg -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: PART2 - Yep.it's a Monday.. My damager just DTS'ed a bunch of tables that are critical for ourweb apps to work back on themselves. When he set up the DTS he thought he was going from our production box to our test box but did the DTS from production to production. The problem was that he had the tables be deleted as the first part of the DTS. At least I know that my backups work. Had everything restored in about 15 minutes and the web sites are up and running. Yea, I know it is SQL Server but I have to deal with that also. At least he doesn't mess with my Oracle DB's. Any other Monday stories for today?? Dave -Original Message-From: Bobak, Mark [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time.Yeah, it's a Monday. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes.sighI have a feeling lunch will be a little late today... At least I wasn't the one who caused the crash.;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown
RE: RAC setup on linux
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: DBA tasks
Title: RE: DBA tasks deja vu.. story of our lives around here. greg -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 08, 2004 11:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBA tasks That was funny. Thanks, I needed that. : ) Another funny thread might be silly instance names people use for development databases, but then oops! The database is now production. Patrice -Original Message- Sent: January 8, 2004 9:34 AM To: Multiple recipients of list ORACLE-L I had one like that: I created a database under our 7.1.6, because We need an Oracle database for development. When? Yesterday! I gave them usernames and passwords and made sure that TNSNAMES was configured. In monitoring a few weeks later, I noticed no activity, so I asked them, That database you wanted right away isn't being used, is there a problem. No problem, we just had a delay, we're going to be starting any day now. Two years later, I was upgrading some databases to 8. The database had still not been used, other than a few objects created. Should I upgrade this database?, I asked. Oh no, don't bother, we're not using it. Can I delete it? No, please keep it around. We're going to need it anytime now. A year later, I backed it up with export to tape, in case I ever wanted it back, and deleted it (along with Oracle home for 7.1.6). Five years later, I don't think anyone ever noticed that it was gone. The tape is in a drawer somewhere. Most troublefree database I've ever had. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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: Re[2]: another OCP question -- help me guys
Title: RE: Re[2]: another OCP question -- help me guys brutal, absolutely brutal... Rachel, can ya out-source your sacrificial lamb for our use as well:-) -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 11:54 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: another OCP question -- help me guys Now I understand their use, I shall immediately go out and hire an art history major as the deparmental sacrifical lamb (and dartboard while we are at it) I'm still a hands-on DBA, although I have some paperwork responsibilities as well. Not management, other than my own work :) Rachel --- Mladen Gogala [EMAIL PROTECTED] wrote: On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote: Oh yeah -- how does having a college degree in art history make a person a better DBA? how does my degree, which is in computer science but which is 28 years old, have anything to do with current programming and database work? Believe it or not, a college degree in art history really does help in two ways. First, people exposed to sufficient quantity of art tend to be nobler and more spiritual, according to the popular beliefs, then cynical mathematicians and computer geeks like me. Being noble and spiritual means that they don't fight back but do as they're told which makes them into good corporate drones. Art history is like an army boot camp for wannabe geeks. Their appearance also tends to be much more pleasant and polished then an appearance of a hard core computer geek. Second, art history majors make perfect sacrificial lambs. An art history major in IT department can be blamed for anything from bad weather, corrupt backup tape to stupid application design. My understanding is that you've moved to the management, which is the move that I admire and respect. As a manager, you should know the value of a sacrificial lamb that can be blamed for anything. If you want to make the next step in your career, the step from management to damagement, you'll have to learn how to play the blame shifting game. Art history majors are priceless for that. -- 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: table reorganizations
Title: RE: table reorganizations beers for all in celebration of the birthday!! Rachel's buying:-) greg -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: table reorganizations I usually recommend Gospel by Jonathan for its completeness and a wide range of subjects. The book you mentioned is great for beginner as well. As for the number 42, I'll continue using it until this Saturday (1/10/2004) when it will become 43. Inflation is not as big as you think. PS: --- I was born on 1/10/1961, and that makes January 10th so special. I don't have to work on that great day, mostly because it's Saturday. On 01/07/2004 03:09:53 PM, Thater, William wrote: Mladen Gogala scribbled on the wall in glitter crayon: Lemme guess: you just started on your new job as a DBA? You are another person to which can only wholeheartedly recommend Jonathan's book. As for your questions, the answer is 42. actually, if she's just starting out, i'd recommend Marlene, Rachel and Jim's book first, then Jonathan's. and are you sure it's not 57 now due to inflation? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Perfection of means and confusion of ends seem to characterize our age. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
extreme parallelism:-) A share-nothing architecture. and some specific software that takes advantage of a hardware configuration.. It's pretty cool stuff for the high end in size DB's. I have seen/performed several comparisons.. And when you are spinning thru large result sets (millions of rows) - TD was the winner hands down... And it's ratherexpensive stuff. They provide specific hardware along with the software. So they would be a Hardware/Software vendor Jonathan is correct - WalMart uses Teradata. -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003 7:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp so what features does teradata have that oracle doesnt for VLDBs? - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Thursday, December 11, 2003 6:59 PM Subject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp Maybe they should rename the product Petadata. If they did, then its a good thing that they didn't name it "TeraFile". PdJonathan Gennick [EMAIL PROTECTED] wrote: Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R very nice. what is teradata? I never hear that dbms mentioned.Isn't Teradata what Walmart uses? From what I know, it'salways been aimed at the market for really, really bigdatabases. Hence the prefix "tera", which isn't so biganymore. Maybe they should rename the product Petadata.Best regards,Jonathan Gennick --- Brighten the corner where you arehttp://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]Join the Oracle-article list and receive onearticle on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body.-- Please see the official ORACLE-! L FAQ: http://www.orafaq.net-- Author: Jonathan GennickINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing
RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
by definition, their product is a combination of software/hardware. Their hardware runs an NCR flavor of Unix, has specific disk farms, and has a specialized piece of hardware/software for the BY-NET(their version of the interconnect). you combine their nodes into cliques (4 nodes to a clique), and bolt multiple Cliques together.. Their RDBMS is embedded with the hardware as well.. Usually don't purchase just the software - it's a package (hardware and software)... The hardware can run Windoze, but the ability to plug in the multiple nodes together as a shared nothing infrastructure works best with their Unix OS on their wintel hardware. oh well - it's friday, its cold, and there is a bunch of high school football on TV in Georgia this weekend greg -Original Message-From: eric king [mailto:[EMAIL PROTECTED]Sent: Friday, December 12, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT But if you run it on small server, ie Windows 2000/XP with less than 1GB memory, Teradata performance is aweful. It hangs from time to time and even some simple query takes considerable time, while Oracle and Microsoft SQL Server never behave like that. - Original Message - From: Loughmiller, Greg To: Multiple recipients of list ORACLE-L Sent: Friday, December 12, 2003 10:29 AM Subject: RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT extreme parallelism:-) A share-nothing architecture. and some specific software that takes advantage of a hardware configuration.. It's pretty cool stuff for the high end in size DB's. I have seen/performed several comparisons.. And when you are spinning thru large result sets (millions of rows) - TD was the winner hands down... And it's ratherexpensive stuff. They provide specific hardware along with the software. So they would be a Hardware/Software vendor Jonathan is correct - WalMart uses Teradata. -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003 7:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp so what features does teradata have that oracle doesnt for VLDBs? - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Thursday, December 11, 2003 6:59 PM Subject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp Maybe they should rename the product Petadata. If they did, then its a good thing that they didn't name it "TeraFile". PdJonathan Gennick [EMAIL PROTECTED] wrote: Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R very nice. what is teradata? I never hear that dbms mentioned.Isn't Teradata what Walmart uses? From what I know, it'salways been aimed at the market for really, really bigdatabases. Hence the prefix "tera", which isn't so biganymore. Maybe they should rename the product Petadata.Best regards,Jonathan Gennick --- Brighten the corner where you arehttp://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]Join the Oracle-article list and receive onearticle on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body.-- Please see the official ORACLE-! L FAQ: http://www.orafaq.net-- Author: Jonathan GennickINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing
RE: Strange behavior continued...
Title: RE: Strange behavior continued...
bambi -
not that I can provide any insight on your strange behavior, I mean the SQL:-)
But this provided some thought on some chaos going on here on a nice Friday afternoon in Atlanta. thanks for the help:-)
-Original Message-
From: Bellow, Bambi [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 12, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Strange behavior continued...
More weirdity based on the situation from the last email...
SQL insert into junk values ('Y');
1 row created.
SQL select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2 minus select * from junk ) b;
T T
- -
Y X
SQL insert into junk2 values ('Y');
1 row created.
SQL select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2 minus select * from junk ) b;
no rows selected
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bellow, Bambi
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).
Anyone used EMC Timefinder to replicate DB's
hey guys - Working on some replication efforts.. And I haven't used EMC Timefinder to push data from one DB to another.. Are there any documents with the details available? I'm working on getting thru the EMC web site as well as metalink, but wanted to throw this out on the list since everyone is so helpful:-) And I'm also in too much of a hurry to RTFM:-) since I need to get something done by Wednesday.. Thanks in advance! Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: orbitz fiasco
Title: RE: orbitz fiasco On my Soapbox My expensive free advice RAC *can* provide a higher level of availability. It isn't the complete answer, but offers a level of improvement. But one needs to consider the complete infrastructure for high availability(Web servers, app servers, db servers, storage, fiber switches, SAN, QFE's, HBA's,etc,etc) /My expensive free advice /Off my soapbox Seems like someone made a critical tactical error in the heat of the moment.. It can happen to everyone as we have found that 64% of outages are *Human Errors* and not technology related.. greg -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 20, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: orbitz fiasco I don't know whether this is true or not, but this case written here shows exactly why RAC does not give you real high availability, the database itself remains single point of failure. Tanel. I was at an Oracle usergroup meeting last week and a guy at Oracle said the following happened. Can anyone confirm? Just curious. 1. Orbitz did an upgrade to some software other than Oracle. I think it was firmware. They did NOT test it first. Did it directly in production. 2. This corrupted a control file. They did multiplex their control files. 3. However, they chose to restore the control file from tape. This invalidated their database. 4. So the delay was restoring the whole database from tape and rolling forward. Anyone know if that is what what happened? Wouldnt surprise me, however, it is Oracle's side of the story... I know atleast one other person from the list was there. I forget the guys name who said it. He is one the RAC specialists. -- 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: Oracle Magazine Awards
Title: RE: Oracle Magazine Awards Cash is King Give the guy the pitiful cash:-) Now you need to setup a donation website;-) -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 20, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Magazine Awards No, I prefer the pitiful cash. You take the recognition, I'll take the money and run. On 2003.11.20 14:50, Jamadagni, Rajendra wrote: Sometimes Peer recognition is more important that pitiful cash. 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- tate.ky.us] Sent: Thursday, November 20, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Congratulations to all the award winners! Btw, do they get any cash awards or just a piece of paper? -Original Message- Sent: Thursday, November 20, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Congratulations to the following folks that appeared in the 2003 Editors Choice Awards ( I finally received my issue of the mag ) Arup Nanda - DBA of the Year Tony Jambu - Consultant of the Year Mogens Nogaard - Educator of the Year Tom Kyte - Oracle Book Author of the Year There were many other, I only mentioned those that I have had the opportunity to meet and/or converse with via email, or sometimes even in person. ( all of these conditions allow me to drop their names when the opportunity arises ) Congratulations folks! ( I don't know if all of them frequent this list ) Jared ** 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. **5 -- 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: 9i- User ANONYMOUS
Title: RE: 9i- User ANONYMOUS the XMLDB requires that account for some of the *potential* capabilities that can be used with XMLDB. greg -Original Message- From: GovindanK [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 13, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i- User ANONYMOUS $OH/rdbms/admin/catqm.sql . HTH GovindanK On Thu, 13 Nov 2003 06:59:37 -0800, Senthil Kumar [EMAIL PROTECTED] said: Hi Group, Recently I have installed oracle 9i (R2). I have seen a user called ANONYMOUS which is locked. There is no documentation about this user. I have used DBCA to create the database. For what reason this user is? TIA Senthil. -- http://www.fastmail.fm - The way an email service should be -- 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: OT: Need help with SQL*Server
Title: RE: OT: Need help with SQL*Server Not only BCP.. Create a DTS package to suck it in.. It will allow you to do source to target mapping.. Copy the file over, and have them use the facility to map and import the data via the GUI. Just an alternative to the good old BCP.. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 31, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: Need help with SQL*Server Sure; bcp is pretty straightforward. It can handle all sorts of formats on the data file (much more flexible than exp/imp or sql*loader in my experience) I maintain a sybase dba page here: www.bossconsulting.com/sybase_dba Click on my personal faq link then scroll down to the bcp specific pages. there's a few topics in there that you may find interesting. the basic commands are pretty easy: % bcp database..table in/out datafile.csv -Uuser -Ppassword -Sservername -c (-c tells you ascii mode). You can also specify a control file, if the data isn't in the most pristine format. You can also create a test target table for your data on sybase , do a test bcp OUT to get a copy of the control file. Or insert a test record, bcp THAT out and see how bcp expects the data to be formatted. I suggest taking this offline if you want further help. hope this helps, boss OK folks I'm out on the dark side, once again. Does anyone remember how MicroSlop's BCP utility in SQL*server works? I've got a user who bought a third party SQL*server application, I won't go there, and he needs to move some data from a desktop to a laptop SQL*server database. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: Todd Boss 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: Outsourcing's dirty secret
Title: RE: Outsourcing's dirty secret not only salries, but job opportunities as well:-) greg -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Outsourcing's dirty secret But sure as hell does drive salaries down over here. On 10/30/2003 03:04:24 PM, [EMAIL PROTECTED] wrote: The perception of outsourcing has been that you can send your work offshore, and get it done cheaper, with higher quality. I think that this article helps to dispel that as a myth. It may or may not be less expensive, it may or may not be better. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Outsourcing's dirty secret What is also unfortunate that the company X which outsourced its project to India, didn't do its job right ... If you just want the cheapest Rolex, you can't complain about its quality later on. I am not saying this couldn't have happened, whatever happened is unfortunate, but I am just saying that the company didn't understand CYA sufficiently, it is just a blame game now. C'mon ... I think that article is one side of the coin. 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, October 30, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List - If a manager seems to be contemplating outsourcing, you might want to post this. Unless you work for an outsourcer. ;-) http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_Outsourcing.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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 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: DBA Support Database
Title: RE: DBA Support Database I'll throw in my *very expensive free* comments... expensive free comments This begins to create the corporate metadata and architecture as Peter mentions. We are on this road, and there are several tools that can do *auto discovery*. There are some very nice tools on the market for asset discovery. They have *exit points* where one could write some basic code to access those assets(sql getting v$ info and store in your metadata?). We have built an enterprise repository to maintain infrastructure data, application, servers, network devices, and transport layers. And now we are going down the *yellow brick road* to begin the data acquisition process. We too, will also define and assign accountability to those elements within our repository. /expensive free comments greg -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 30, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBA Support Database Just a quick reply to this. You are, in fact, formulating the sort of request which would be input to a corporate data architecture. We have built such a thing, and it includes the issues you refer to. More importantly, we have identified who is responsible for every single piece of data in the system. The management of an attribute in a table can in fact be traced right back up to that level of senior management where they don't even know how to spell 'Oracle'... peter edinburgh -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 30, 2003 3:30 PM To: Multiple recipients of list ORACLE-L Subject: DBA Support Database I was thinking about putting together a database that contains a list of DBAs, servers, databases, and applications. The database would be used by the Helpdesk and Management to see who is responsible for a given application or database when problems occur. I thought I would check first and see if anyone has already designed such a database and might be willing to share it. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. . http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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).
Oracle 8 support notice?
Hey folks, there was a post late last week that had the details of the 8i Support extension. Would someone be so kind to forward that post to me "off post" please? Specifically - looking for the metalink info that spells that out. Thanks! Greg
RE: SAME and separating disk and index tablespaces
Title: RE: SAME and separating disk and index tablespaces Maybe we have been lucky. But we use the SAME methodology. We have removed a considerable amount of human effort in regards to layout of datafiles and disk layout. And based on the stats that I have seen from the Storage team/SA's, we have *maybe* seen a 2-5% performance hit in access time. That info needs to be confirmed-but the disk technology has been improved so dramatically-that older rules of thumb aren't necessary for *specific* environments. There is still logical separation of tables/indexes as mentioned below.. But we typically present a single file system for the datafiles Does this work in all cases for us - nope! But it covers a majority of the environments and we address the *unique* environments accordingly. But considering the number of databases and the volume of disk space - more effective for us. just a comment:-) greg -Original Message- From: vikas kawatra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 08, 2003 8:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME and separating disk and index tablespaces Great responses ! Thanks very much .. -Original Message- Dave Hau Sent: Wednesday, October 08, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Hi Gaja, I agree that throughput can always be improved by adding more drives to the striped array. However, this does not improve access time. If you have your tables and indexes on the same striped array, necessarily the two I/O's have to be done sequentially, incurring two times access time at a minimum. However, if you separate the two into different arrays, then you can access them in parallel, starting to get data from each disk array in 1* access time. This makes sense esp. in scenarios where response time is more important than throughput, and also in use cases where your access pattern is random rather than sequential. So I feel that there's a tradeoff between access time and throughput. If you have ten drives, and you stripe all of them into a single array and put both your data and indexes onto this array, you get maximum throughput but you're sacrificing access time for throughput. However, if you build two arrays each consisting of five drives, and put your data and indexes onto each array, you get half of the previous throughput, but you get better access time because now your data and index access can be truly in parallel. Regards, Dave [EMAIL PROTECTED] wrote: Hi Hans/Vikas, I tend to agree that the old draconian rule that thou shalt always separate indexes from tables may not apply any more. We used to apply that principle in the past when the number of available spindles was not adequate. Seems like with 256G drives in the market, we are being pushed back in time, in some way!!! The way I look at the problem is purely from an IOPS perspective. For example, if each physical disk is capable of 256 IOPS (ignore the cache configured here) and you have 10 disks in your volume, then the total I/O capacity on this volume is 2560 IOPS. Separation of objects across multiple volumes may becomes an issue, only when the demand for I/O outstrips the supply (in this case 2560 IOPS). Even then, you can always add more drives to the existing volume and restripe, i.e., adding 5 more drives to 10 drives increases the I/O capacity by 50%. At the end of the day, the I/O sub-system does not care, whether it is servicing a data segment, index segment or undo segment. But, in certain environments, that I have dealt with, there has been a need to separate heavily and concurrently accessed objects (does not matter whether these objects are all indexes or tables or both). This may be true only for certain objects and certain queries. So, please don't apply this in a blanket fashion. Empirical data is always the best justification mechnism for a configuration exercise such as this. Plus, you may have partitioning and other requirements such as parallelism that impact the placement and availability of your data. This in turn will control the number of logical volumes that need to be created. I think the idea and philosophy behind SAME is noble - Use all available drives, so that you do not have localized hot-spots. But the implementation of SAME and how many volumes you need in your enviroment, is a function of your custom needs based on your system and application demands. When you over-simplify something, you lose the flexibility. The art factor here (which requires some planning) is in achieving a balance between simplicity, flexibility, performance, manageability and availability. Hope that helps, Gaja --- Hans de Git [EMAIL PROTECTED] wrote: Vikas, Spend an hour on reading this usenet thread: http://groups.google.nl/groups?hl=nl==UTF-8=UTF-8=brjz8 .15%24707.245%40news.oracle.comrnum=1prev=/groups%3Fhl%3Dnl%26lr%3D%26
RE: DBA needed in Austin, TX
Title: Message dry heat?? Not sure about Austin, butI have some co-workers in Dallas where they say it's 100x100: 100 degrees with 100% humidity... greg -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 10:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DBA needed in Austin, TX I really like that "no DBA left behind" program of yours, but TX is too hot for me. I know it's a dry heat but nevertheless, I do prefer colder climate. You can keep the Dixie Chicks. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 11:25 PMTo: Multiple recipients of list ORACLE-LSubject: Re: DBA needed in Austin, TXDavid forgot to mention a couple of things about working for AISD: - We don't wear neckties (well, David does sometimes). - We get 23 paid Holidays (how does 2 weeks off for Christmas and a week off for Spring Break sound?). - We have an unlimited site license for Oracle EE. I slap databases out there as needed without a second thought. - Before he became MIS Director, David was an Oracle DBA and a UNIX Sys Admin before that, so he really understands the technology and the challenges. - Did I mention that we don't wear neckties? AISD's infrastructure is truly awesome. The fiber WAN allows our widely-scattered users to connect dependably to our databases and me to push tons of data around quickly and reliably. All the UNIX and other servers (not to mention our Users' PCs) are either brand new or about 3 years or less old. The oldest Oracle databases we have are 8.1.7.0.0 and we've already started upgrading to 9.2.0.4.0. We'll be moving our only Win2k database to HP-UX in the next few months. All the other DBs are already on either HP-UX or Linux. We've got a couple of less-than-perfect 3rd Party COTS applications for Financials and Student Information, but we're rapidly applying Oracle features to improve them and add functionality their producers never even thought of, as well as providing Web-enabled access to our thousands of AISD users and the Community at large. Our Developers have hardly a Duh(veloper) among them and their supervisor is top-notch, too. An all-round great bunch of folks to work with District-wide. I've been with AISD for 15 months - my first Public Sector gig ever - and I'm loving it. Also, with the Economy the way it is (and will be for a while to come), this Public Sector organization is very competitive in salary and benefits with the Private Sector. I know, I shopped around and got other offers before coming here. Oh, and Austin being the "Live Music Capital of the World" doesn't hurt, either. And I certainly don't want to forget the part about not having to wear a necktie!Jack C. ApplewhiteDatabase AdministratorAustin Independent School DistrictAustin, Texas512.414.9715 (wk)512.935.5929 (pager, [EMAIL PROTECTED])[EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 03:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DBA needed in Austin, TXWith permission from Jared:'Needed' is kind of strong. We've got a position open, but we're not realneedy folks. We're a school district. The 37th (depending on the day ofthe week) largest in the United States. If we were a business, it'd bepretty good-sized. Our annual operating budget is 730 million dollars plus(of which MIS gets a really small, tiny, little itty bit), we have 15,000employees, 130 branch offices, our own police force and post office. Wefix 150,000 meals a day and need to collect cash or validate for everyperson through the cafeterias. We're moving from a mainframe environmentto client-server computing with an Oracle back-end running on HPUX andLinux for both our student data and ERP systems. It's a pretty dynamicshop. We've got 40 or so people (depending on the day of the week) splitinto three areas, business systems, student systems and programming. Wedon't do the network piece, but that's solid - switched gigabit ethernetrunning on over 300 miles of fiber with 100MB to the desktop.I don't hire or set salaries. HR does that. I only recommend. The salaryfor this position will be somewhere between $60K and $80K depending onexperience (and whatever bizarre decisions are reached by the compensationanalyst).You've got to be REAL strong in backup and recovery. And curious. We'replanning to go where no
RE: Cary's book -- Out of stock !
Title: RE: Cary's book -- Out of stock ! Mine came in the mail yesterday as well. First couple of chapters are out of the way. Reading a technical book and football games are a wonderful thing. greg -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]] Sent: Monday, September 22, 2003 7:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cary's book -- Out of stock ! In Fact... it looks like I just might have Cary's book at home. USPS says it's delivered!!! WOO HOO! Perhaps I should offer it up to the highest bidder! Start an Ebay auction for it! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/22/2003 2:24 PM Well I got my shipment notification that Amazon has sent me my copy!! Waiting with anticipation. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/22/2003 1:49 PM Ah Cary, you're not giving yourself enough credit. It'll probably be sold out by the end of this week at the latest. It's like the hottest book out there now (seriously). I know I showed someone here the pre-released copy you gave us in the Hotsos 101 class in Chicago, and he was asking when he could buy the book. -Scott Stefick -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, September 22, 2003 12:00 PM To: Multiple recipients of list ORACLE-L I'm not sure what's up with Amazon. It was released last week, and it's showing up at people's houses now when purchased from other sources. Consider canceling your Amazon pre-order and buying it direct from oreilly.com. ...I'm pretty sure it's going to be several months before O'Reilly sells all the copies they printed. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Monday, September 22, 2003 9:05 AM To: Multiple recipients of list ORACLE-L what was the initial printing? congrats Cary. Hope I can get a copy soon. From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/09/22 Mon AM 09:09:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Cary's book -- Out of stock ! It's up to the publisher as to when they will print more, Cary has no control over that. However... it apparently never GOT to Amazon, as I had it on pre-order there, and it is still listed as to be released and not shipping :( --- Prem Khanna J [EMAIL PROTECTED] wrote: Hi List, I have placed an order for Cary's book @bookpool. Does someone know when it will be in stock ? Can Mr.Cary Millsap let me know that ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com 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 http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com 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 http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com 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
RE: OFA and Shared Storage
Title: RE: OFA and Shared Storage we use a single/double file system.. The LUN is made up of multiple physical disks, striped/mirrored across the multiple spindles based on the storage requirements. The disk technology has come a long way. Plus there have been several bench marks/white papers similar to this topic... But we still use the OFA file structure to maintain the consistency across the many systems and databases... greg -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Monday, September 22, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: OFA and Shared Storage In my opinion, SAN storage begs the question about whether OFA makes sense anymore. If you can configurte the SAN storage so that all files are striped across all disk, then everything is spread. And if the SAN is mirrored, then just why are we working so hard? EMC SAN disk has such an incredible uptime, that worrying about losing things like control files are (almost) a thing of the past. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, September 22, 2003 2:05 PM To: Multiple recipients of list ORACLE-L I read some posts on here with shared storage such as SAN and Network Appliances its no longer necessary to multiplex datafiles on different disks, since the storage array handles that for you. How do you ensure that control files and redo log files are kept safely apart so that no one disk failure in the shared storage can take them all out? According to the OFA(well the abbreviated version I have in front of me) 4-5 disks is optimal for multiplexing. Does this no longer apply with shared storage? How do you ensure database available with shared storage? if your not multiplexing datafiles? I may have read some peoples posts incorrectly. Im just digging into backup and recovery. -- 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: 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: 'Test' Note on Metalink...
Title: RE: 'Test' Note on Metalink... I'm curious as to who has time to search for such an item these days:-) greg -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Subject: 'Test' Note on Metalink... Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj 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: in case anyone missed it
Title: RE: in case anyone missed it tell everyone beer after the presentation -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 27, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: in case anyone missed it been there, done that, its not near as bad as it seems, the attendees dont want you to fail, they want to learn something, so most of them are quite supportive. joe Thater, William wrote: Joe Testa scribbled on the wall in glitter crayon: IOUG-2004 conference call for papers is open. one just has to be crazy enough to stand in front of a room filled with people LOOKING AT YOU, and present.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Nothing great was ever achieved without enthusiasm. - Ralph Waldo Emerson -- 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: Tough Oracle DBA experience
Title: RE: Tough Oracle DBA experience hang on... You mean you get *paid* to watch College Football:-) What a job;-) I get paid a little bit for college football..But officiating the game isn't the same as *watching* the game. Greg -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Saturday, August 23, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tough Oracle DBA experience Create a new top 5 list ... it is fun It stinks to be in office on Sat, but it is the start of College Football season, and I have to _watch_ the games till 11pm tonight, while sitting in office. 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: Ryan [mailto:[EMAIL PROTECTED]Sent: Saturday, August 23, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Tough Oracle DBA experience how about DBAs with attitude problems? DBAs who refuse developers access to v$ views. DBAs who refuse to listen to developers. DBAs who who refuse to explain any decisions to developers. DBAs who are pure production DBAs and have no knowledge of development and cant even write PL/SQL? Ive worked with quite a few DBAs who only know a fraction of what they think they do. Same holds true for developers and managers. So its not one way. Attitude is harder to overcome than competence. Someone with a good attitude can learn. Someone who knows and has a bad attitude can be intolerable. The worst kind though is the jack of all trades who thinks he/she knows everything about everything yet only knows a little about everything. Those are the worst. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Saturday, August 23, 2003 4:24 PM Subject: RE: Tough Oracle DBA experience Top 5 problems ... 1. Developers (who think they know everything) 2. Developers (who think, others think they know everything) 3. Developers (who think but just not coherently) 4. Developers (who DON'T think at all) 5. Developers (these work for Oracle) 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: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 23, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Tough Oracle DBA experience Dear All, I am collecting (Just writing in a book ) of all tough problems , great issues handled with Oracle RDBMS as a DBA. Request you kindly send us the Top 5 Problems , Difficult scenarios(the most tough problems , with solution u did.)you faced so far in your DBA life. Hope to see many responses to this , atleast by Monday. Thanks a lot. Regards Rajuveera
RE: Tough Oracle DBA experience
Title: Message went to many many notre dame games:-) -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Monday, August 25, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tough Oracle DBA experience So not everybody on this list cheers for Notre Dame? I'm so disappointed... --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stefick Ronald S Contr ESC/HRIDDSent: Monday, August 25, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tough Oracle DBA experience That would make him a GOOD ref! ;o) -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Tough Oracle DBA experience Aaaah, you are one of those refs who always make calls against the Fighting Irish? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Loughmiller, GregSent: Monday, August 25, 2003 10:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Tough Oracle DBA experience hang on... You mean you get *paid* to watch College Football:-) What a job;-) I get paid a little bit for college football..But officiating the game isn't the same as *watching* the game. Greg -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Saturday, August 23, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tough Oracle DBA experience Create a new top 5 list ... it is fun It stinks to be in office on Sat, but it is the start of College Football season, and I have to _watch_ the games till 11pm tonight, while sitting in office. 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: Ryan [mailto:[EMAIL PROTECTED]Sent: Saturday, August 23, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Tough Oracle DBA experience how about DBAs with attitude problems? DBAs who refuse developers access to v$ views. DBAs who refuse to listen to developers. DBAs who who refuse to explain any decisions to developers. DBAs who are pure production DBAs and have no knowledge of development and cant even write PL/SQL? Ive worked with quite a few DBAs who only know a fraction of what they think they do. Same holds true for developers and managers. So its not one way. Attitude is harder to overcome than competence. Someone with a good attitude can learn. Someone who knows and has a bad attitude can be intolerable. The worst kind though is the jack of all trades who thinks he/she knows everything about everything yet only knows a little about everything. Those are the worst. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Saturday, August 23, 2003 4:24 PM Subject: RE: Tough Oracle DBA experience Top 5 problems ... 1. Developers (who think they know everything) 2. Developers (who think, others think they know everything) 3. Developers (who think but just not coherently) 4. Developers (who DON'T think at all) 5. Developers (these work for Oracle) 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: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 23, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Tough Oracle DBA
RE: Collaboration Suite
Title: RE: Collaboration Suite we have it as a trial. I'll go along with the ability to admin the product... this version is tough to admin. greg -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 21, 2003 2:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Collaboration Suite Brian: I have just implemented OCS for one of our client in the middle east and it will be live from this month end. It is working like a charm. Let me know if you have any specific questions. I will try to answer. Basically it is an excellent product for end users and not so good for administrators (at least the current versions) Best Regards, K Gopalakrishnan -Original Message- Brian Haas Sent: Wednesday, August 20, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Hello all, We're looking at Oracle collaboration suite and I'm wondering if anyone here is using it? If so, how is it working? Any issues? I know Oracle corp is using it for all their internal mail so I assume it could handle our 500 or so users just fine. Thanks, -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas 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: 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: Oracle World anyone?
Title: RE: Oracle World anyone? chevy's was good the previous time(s). but I happened to be part of the group that was left with a larger than normal tab.. But, we'll find a bouncer and have them be the gate keeper for the cash:-) greg -Original Message- From: Molina, Gerardo [mailto:[EMAIL PROTECTED]] Sent: Friday, August 15, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle World anyone? I can make a reservation at Chevy's again this year. We should cover the rules on paying the tab, though. For large groups, Chevy's requires 1 tab. That means no one should leave the party without putting a reasonable estimate of their part of the tab into the pot (including drinks) in cash. No promises that so and so will pick up their share of the tab, because chances are, when it comes time to pay the tab, that will not happen. Last year, the people that were left when the tab was paid had to cover for those that left early without paying. Not a pleasant way to end an otherwise cheerful evening. Gerardo -Original Message- Sent: Friday, August 15, 2003 9:34 AM To: Multiple recipients of list ORACLE-L I'll be presenting there. Come see me on Monday for 9i goodies that aren't so well known as some of the other more heavily marketed features. Its also a chance to see someone try get through 100 plus slides in an hour without taking a breath. Only got to 98 last year at UKOUG so I'm keen to break the 100 barrier :-) Are we all doing the standard oracle-l mexican next to the moscone on one of the nights ? Anyone live in SF that can arrange a booking ? Preferred nights ? Cheers Connor --- John Kanagaraj [EMAIL PROTECTED] wrote: And there will be a bunch of us 'Silicon Valley' types who can arrange a get-together for ORACLE-L members. The rowdy bunch that got together last year nearly tore up the Restaurant, btw John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 14, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle World anyone? Thursday, August 14, 2003, 9:24:29 PM, you wrote: SM Just completed the registration, and was wondering how much company I was SM going to have there. SM Who else has plans to attend? I'll be there. I'm even presenting this year. 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 technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: John Kanagaraj 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services --
RE: 100 instances on same server !!!
we throw'm on there until we hit a predetermined capacity mark.. If it's a 100, cool.. Or if it's 20.. Just depends on the app, volume of txn's and memory requirements The caveats that are considered are some of the necessary kernal parms (semaphores, shared memory,etc).. Load it up, watch the capacity of the server.. And push the envelope:-) Greg -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 8:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 100 instances on same server !!! We have about 35 instances on each node of RAC they are of course DEVL/ACPT types. 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: Dilip Patel [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 100 instances on same server !!! Thanks for the replies so far. Considering the fact that my database is tiny ( just around 3 GB ), How many of them can work on same server? I can just test with 5 instances, with limited hardware. Will the CPUs be able to take load of 100 instances? Is it worth experimenting this? I am on 8.1.7.4 and the application is already built. I stand no chance of changing the code. That is why using individual schemas for individual users is not an option. Right now I am just asked if 100 instances can run on same server and I don't have solid answer. Just on side note, canI ask, What is the maximum number of instances anyone has ever worked/heard being installedwith in same server? Thanks again. Dilip. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM Subject: Re: What books recommended for Data Modeling ? 100 instances woh . If you are in 9i look at possibilities like contextor label security . or creating another schema .-ak- Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 9:24 PM I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundredtrainees at a time. For this he wants to install hundred database instances onsame server machine, which *each* will be accessed simultaneously from 100different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each roundof training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible.Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardwareneeded for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be
oracle logical standby
folks - listening to a preso from a vendor where they will use logical standby to accomplish some of the 99.999 availability requirements... so I'm wondering, does anyone have some extensive experience with the logical standby to share? the good stuff, the bad stuff, pitfalls, gotcha's, and general things to run away from.. Then on the other hand-what things should someone try to leverage? thanks in advance! Greg Loughmiller
RE: clustering
Title: Message I would be interested if it's other platforms as well.. we are embarking on the "golden path of RAC" -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 11:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: clustering Bala, Do you have a bug# associated with this one? We are on AIX, so this is *very* interesting to me. TIA 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: Balakrishnan, Ashok - VSCM [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 6:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: clustering We used to experience problems in our RAC environment when there's an interconnect failure. There's a workaround for that problem, that was worked for us - Create a directory under $ORACLE_HOME/rdbms called ".aixopt". Create (touch) a file called SUSTAIN_IPC_FAILURE (uppercase - 0 byte file). We're using 9.2.0.3 2node RAC on AIX 5L / HACMP 4.4 Does Sun or Tru64 have similar workarounds or does it work flawlessly without the workaound. Having this workaround tells RAC to make sure atleast there's one surviving instance in the cluster instead of all instances crashing. Here's the section from alert log filewith an example of handling failures of all 3 interconnects. Marking down Network with IP 192.168.17.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:29 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:29 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:29 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:30 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:33 2003Marking down Network with IP 192.168.19.11WARNING!!! NO COMMON NETWORKS FOR ALL NODES TO COMMUNICATESUSTAINING IPC FAILURETHIS SHOULD BE THE ONLY INSTANCE RUNNING IN THIS CLUSTER -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: clustering Hrrrmm - well, we've never seen the problem you describe, and we've got a pretty big RAC environment here (clusters from two to six nodes, and we combine dev clusters to build bigger ones as we need). What the situation you describe sounds like is what happens when there's interconnect failure. Each node thinks independently that its been separated from the rest of the cluster and (effectively) shoots itself in the head. This causes every instance to hang. This is why the crafty RAC Jedi designs well their interconnect architecture. But yes, if you're willing to take the "completely 2n capacity" cluster route and have two databases, double the oracle licenses, two storage arrays, two fibre channel networks, etc., that is the highest availability/reliability cluster you can have - although at the highest cost and complexity. Which clustering solution is right for you? Cheap and inelegant? Expensive and bullet-proof? Well, that's why we get paid the big bucks, right? :) 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 Tanel PoderSent: Monday, July 28, 2003 7:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: clustering However, failed transactions must be handled from client side. Queries may migrate to surviving nodes transparently. Also, currently RAC has many problems, such all nodes hanging when one node dies. Completely separate systems are still (an will always be) the most available solution. Tanel. - Original Message - From: Indy Johal To: Multiple recipients of list ORACLE-L Sent: Monday, July 28, 2003 7:49 PM Subject: Re: clustering Another Important different is that RAC is best High Availability solution in case of System/Instance
RE: Oracle unlimited concurrent license
Title: RE: Oracle unlimited concurrent license Depending on the type of data/application ; one can buy licensing based on the CPU, nbr of CPU's within the nodes. For example; what if you have a n-tier application where the data maintained within the Oracle RDBMS is exposed to an un-countable population? The example of licensing that I have seen in that case has been license the old fashion way-class of box, cpu, nbr of CPU's. There are all types of different licensing arrangements that can occur. It really depends on the creativity of the sales and supply chain folks within each company. But I agree with Dennis - get the contract out and have an individual familiar with the contract read the fine print with you... greg -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Monday, June 30, 2003 6:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle unlimited concurrent license Peter Concurrent licenses were offered years ago. I have not heard of an unlimited concurrent, but it may well be that Oracle Sales sold them one. The key would be finding the sales agreement they and Oracle signed and seeing what it says. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 4:10 PM To: Multiple recipients of list ORACLE-L My management is claiming that we have an unlimited concurrent users license on one of our AIX machines and that we do not need to upgrade the license when we increase the number of processors. The Oracle web site section on licensing lists only two types of licenses for Enterprise Edition, Named users and Processor Based. Has anyone heard of this other type? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: DENNIS WILLIAMS 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: Do Not Call
Title: RE: Do Not Call Paradox for DOS -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: Do Not Call There have been over 10,000,000 entries made in the National Do Not Call Registry since Friday June 27. Does anyone know the database engine in which this is stored? Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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).
opinion of listers on product(s)
hey guys- Looking at a couple of products for some data replication as part of a continuous availability effort. Just curious, looking for some "reactions", do's and dont's,plus and minus to those who have used the following "software data replication tool(s)" : Quest SharePlex Data Mirror Transformation Server Omni Replicator Infamous Oracle Streams Seeing that there may be someemployees of these vendors on the LIST ; let's try tokeep the comments clear ,concise, and objective:-) so that we don't offend anyone. But if you feel the need to share some venting ; send that email to me instead of the LIST;-) thanks in advance! Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: High-availability database question !!!!
Title: RE: High-availability database question Check into the HP metro cluster. RAC would provide the multiple Node environment; but one would think that a continuous availability scenario would indicate the need for the database to be redundant on another system. The HP Metro Cluster may be able to address the database(disk) redundancy. And depending on the application, volume of data and transaction rate - the 2 way replication gig may be a possible solution. Not necessarily the desired solution; but a possible solution. In addition to the 24x7 that you mention; is there any activity around the other components of the environment for example, load balancing? The web servers? Application servers? One can create a 7x24 environment; but will a service degradation be acceptable? Just some thoughts Greg -Original Message- From: Jose Ruivo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 25, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: High-availability database question Hi, When you say maintenance does it includes Oracle patches application? If not, consider Oracle 9i RAC with Dataguard. José Ruivo -Original Message- Sent: quarta-feira, 25 de Junho de 2003 11:00 To: Multiple recipients of list ORACLE-L Goodday all We have cutomer who is having a database which should be available 24x7. Now we can't get even a maintenance time to do the database. We tried on several occasion but nothing happens. Now they want us to provide them with a solution to be able to work on another database if we need to do maintenance. Could you guys come up with some ideas what we can offer them. Is there any other alternatives besides replication and standby database. Currently the system is running as a package in a cluster environment, HP-UX, so when we go replication route possibilities are that we might have to forget about high-availabilty cluster environment due to things like disk space and memory for switching over during failure. Neither do the standby database a good option in a situation where you'll needing a longer downtime. Please help. Thanx, Junior DBA On Tue, 24 Jun 2003 08:19:18 -0800 ([EMAIL PROTECTED]) wrote: Hi there, I got a question on log. If my program crashes, can I check some log to see what recent transaction is? It will give me a big help on trouble shooting. Thanks, Jin -- 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). ___ LOOK GOOD, FEEL GOOD - WWW.HEALTHIEST.CO.ZA Cool Connection, Cool Price, Internet Access for R59 monthly @ WebMail http://www.webmail.co.za/dialup/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas 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: Jose Ruivo 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).
Oracle releases by the different platforms...
Title: IOUG Live 2003 does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Greg
RE: V$LOCK definition
Title: RE: V$LOCK definition for some applications, it becomes expressed in terms of days :-) -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Monday, June 16, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: V$LOCK definition Folks, Question here, the CTIME column in V$LOCK is expressed in what? Seconds, milli-seconds, What?? Anyone know? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: db file sequential read [WAS:wait event puzzler]
Title: RE: db file sequential read [WAS:wait event puzzler] But it took them awhile to get 7.3.4 stable:-) Spent many an hours watching latch contention and spin count(as well as hash algorithms playing havoc, hard parses when not required, and the engine puking on the SGA memory structures..) bring down my 734 database a few years ago. We got to the point that support couldn't support me (department of the redundancy department.) The resolution for our problem was the development of a bug patch for the 7.3.4 stuff by development being on site at the client. Oh, how I miss the days of total chaos :-) Greg -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 12, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: db file sequential read [WAS:wait event puzzler] I must confess that I checked by using strace on Linux and, true enough, for index read, I've got read calls and for full table scan, I've got readv (scatter/gather IO). Obviously, I'll have to re-learn some stuff from version 7. I successfully forgot versions 4, 5.0, 5.1.22, 6.0.36, 7.0.16, 7.1.16 and 7.2. I'll try forgetting 7.3.4 as well although it's the last really stable version of oracle. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 12, 2003 4:24 AM To: Multiple recipients of list ORACLE-L Mladen: Prior to 8i (or 8) you see the multiblock sequential reads while doing the reads from the sort segments or temporary segments. But in 8i sort IO is done as direct IO and we see some other waits. Starting from 8i the db file sequential read is always a single block read which TYPICALLY happens during index scans.. Are you convinced? Best Regards, K Gopalakrishnan --- Gogala, Mladen [EMAIL PROTECTED] wrote: A SINGLE block? I was convinced that it was = DB_FILE_MULTIBLOCK_READ_COUNT blocks. Are you sure? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Dennis: THe event 'db file sequential read' is NOT always an INDEX Scan. It is just a single block read which TYPICALLY happens during an INDEX scan. The word 'TYPICALLY' is the key here. Best Regards, K Gopalakrishnan -Original Message- Meng, Dennis Sent: Wednesday, June 11, 2003 11:02 AM To: Multiple recipients of list ORACLE-L Good day all, We have a bunch of queries in our data warehouse environment that are taking a long time to complete. I did a select on v$session_wait on one of the queries when it is running and it shows the wait event to be 'db file sequential read', which means it is scanning index blocks, correct? But when I put the p1 p2 p3 values into another query to see which segment it belongs to, it shows me a table, not an index. How can this be? -- 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: 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).
FW: Happy Birthday, RAID
Title: FW: Happy Birthday, RAID For the BAARF zealots of our list. :-) ok, now I'll duck down and avoid the shots. Greg -Original Message- From: Storage Report [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 12, 2003 9:10 AM Subject: Happy Birthday, RAID = THE EWEEK STORAGE REPORT = News, analysis, technical evaluation and management guidance on storing and managing data and building network infrastructures. June 12, 2003 = In This Edition = David Morgenstern: Happy Birthday, RAID The Storage Report: 1. IBM, Infineon Talk Up MRAM 2. Sun Refines Storage Roadmap 3. Leaking Device Drivers Create Security Hole 4. Storage Web Digest: Startup Persist Launches Content Appliance 5. Review: Bridging the Backup Gap --ALSO AT THE STORAGE SUPERSITE AND EWEEK.COM --ELSEWHERE ON ZIFF DAVIS To visit the Storage Supersite, click here: http://eletters.sec.ziffdavis.com/zd/cts?d=73-7-1-1-44194-811-1 === Sponsored by IBM Tivoli == Storage Resource Management That Enables Business on demand How do you add storage capacity while reducing administrative and financial challenges? Click here to register for the IBM Webcast. Learn how intelligent storage management software can help your business to reduce cost and improve ROI. http://www.ibm.com/tivoli/r/srm-eweek = = David Morgenstern = Happy Birthday, RAID Fifteen years after its creation, the storage technology has become essential to data integrity. However, Storage Supersite Editor David Morgenstern wonders if it shouldn't inspire a similar drive for parity among applications, operating systems and computing hardware.
RE: RAC, fail over and timeout .. Big Question
Title: RAC, fail over and timeout .. Big Question It would be interesting to see if the pre-connect helps you out or not.. We are getting ready to work thru similar issues/testing... Greg -Original Message-From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]Sent: Thursday, June 12, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC, fail over and timeout .. Big Question Raj: I am afraid, there are not much alternatives you can think of. Even the SELECT fail over will takearoundfew seconds since it has to attach the PGA to the second instance and run the query from where it is failovered, though you can overcome this by enabling pre-connect. Pls let me know if you got any nice ideas ;) Best Regards,K Gopalakrishnan -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Thursday, June 12, 2003 7:50 AMTo: Multiple recipients of list ORACLE-LSubject: RAC, fail over and timeout .. Big Question Hi all, here is a (hopefully) tricky one ... We have a two node RAC (9202), two applications run on either side, no problems there. We have a business critical process that runs all the time on node T2. This process needs to have a set response time or it affects business. And it is written in VB. Currently we have already handled the situations when a node is down (or machine is down) it fails over to the other side and continues. What we need to cater for is when DB is up, but sick (i.e. not responding). We need to be able to specify a timeout in the queries and when we get no response in the specified time, we need to automatically fail over to the other side. The queries in the application are optimally written, they are sub-second or single digit second queries. So, a query taking a long time would be about 10-15 seconds. While we are fishing for ideas, has anyone implemented anything like this? Any ideas? Thanks in advance 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: Oracle ambushes Peoplesoft with $5.1bn bid
Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid better to buy than to build :-) Or just hire the talent... -Original Message- From: Tony Johnson [mailto:[EMAIL PROTECTED]] Sent: Friday, June 06, 2003 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid RDB was developed by DEC and was purchased by Oracle. When I 1ast saw it in depth 10 years ago it wqas quite nice. From what I also understand that the Cost Based Optimizer from 8i and on was part of RDB replacing the 7i Oracle developed version. -Original Message- Sent: Friday, June 06, 2003 12:40 PM To: Multiple recipients of list ORACLE-L And what exactly is RDB to Oracle RDBMS? Predecessor? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 06, 2003 1:04 PM To: Multiple recipients of list ORACLE-L What's really interesting is the quote from Larry indicating that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS. Take all the goodies, no development on the purchased technology. Not sure if it appears in this arcticle, I saw it on Zdnet. Jared Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/06/2003 06:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Oracle ambushes Peoplesoft with $5.1bn bid http://www.theregister.co.uk/content/53/31079.html OoooOO === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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: 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). -- 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: Chris: Thank you!
Title: RE: Chris: Thank you! got some 6.0.36 diskettesfor those interested:-) -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 8:31 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Chris: Thank you! Dang ... last Friday we threw away Oracle 6/7/8 disks and printed manuals ... Let me see still ... 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 ! Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 03 Jun 2003 14:19:44 -0800 I have to tell you this, my friends: Today, a package arrived here in Maaloev on the oak table. It contained Oracle version 5.1.C and 6.0 on 5.25'' diskettes. The sender was Chris G. from Nokesville, VA. This will go right into the Oracle Museum, and I hope to be able to let you guys one day try to install version 5 on a DOS PC at some future conference. Chris - I owe you a case of beer or two. And your name will be forever saved in the Oracle Museum. Thank you. Mogens PS. Version 5 and 6 docs are most welcome, if anyone can live without them.
RE: DBLink to SQL Server problem
Title: RE: DBLink to SQL Server problem since you are going to sqlserver - I wonder if you need to place the following on the object/database ... from dbname.owner.table@msql I haven't seen the doc you mention(and forgive me if this is redundant info you know)-but SQL has the concept of multiple databases within the instance, and each DB has a DBO account.. select table.column from [EMAIL PROTECTED] Just a thought-but would be interested in knowing the solution when you are able to get this working.. I just came across a project where we may need to do this here.. greg -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 02, 2003 9:34 AM To: Multiple recipients of list ORACLE-L Subject: DBLink to SQL Server problem I created a DBLink to a SQL Server database following DocID: 114820.1. It seemed to work fine until I tried a real query. If I do something like a SELECT COUNT(*) or SELECT * it works fine; tdispach select count(*) from [EMAIL PROTECTED]; COUNT(*) - 1207 But if I try to select on a specific field or have a WHERE clause specifying a filed I get this; tdispach select mpp_id from [EMAIL PROTECTED]; select mpp_id from [EMAIL PROTECTED] * ERROR at line 1: ORA-00904: invalid column name I know that the column name is correct so something else is not translating properly. I tried a fully qualified column name of MANPOWERPROFILE.MPP_ID and that got the same error. I don't see any setting in my DSN that could effect this. Anyone have any ideas, hunches or clues? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave 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: Running multiple instances on a [large] server
Title: RE: Running multiple instances on a [large] server We run upto 22 instances on large SUN boxes... Each environment has their own oracle home, own file system, and in some cases-their own UNIX account for the environment.. One loses a little space for the multiple oracle homes, and it does add some overhead for the operations.. But when we need to migrate a database to a new server;we can shutdown the DB-umount,mount on the new system, and crank it up. We have been in a situation where the machine resources choked, and we were able to move a couple of databases with less than a 3 minute hit for an outage. Would have been less if the operations guys(SA's) had things tee'd up, and ready to hit it with the Driver too. greg -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 11, 2003 3:49 AM To: Multiple recipients of list ORACLE-L Subject: Running multiple instances on a [large] server One of the teams here is planning to run anything from 8 to 16 database instances [no indication on sizing yet, but gut-feel SGAs are 200MB to 1GB and DB sizes 500MB to 40GB] on a large server, something like a Sun E6800 or an equivalent HP or Fujitsu server. 1. How many of you do run, and are comfortable running, multiple databases on the same server, whether it is partitioned or not ? 2. Do you create a seperate ORACLE_HOME for each instance ? 3. Do you just buy the Oracle DB CPU license on the total number of CPUs on the server ? My positioning is a. We might not be able to create 8 partitions but partition such that we have a max of 2 or 3 instances in one partition. Hopefully, I can dynamically change CPU partitioning to reallocate CPU to another group of instances. b. Each instance should have it's own ORACLE_HOME. [Disk space is not a constraint]. c. Just add up the number of CPUs on the server, across all partitions, and buy a CPU license. Also, a CPU license is much preferable to Named-User as some of these databases would host Portals for 1,000+ end-users. Hemant K Chitale 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: I am an idiot - WAS -deadlock problem
Title: RE: I am an idiot - WAS -deadlock problem go girls... fire the shots at'em :-) -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, March 10, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: I am an idiot - WAS -deadlock problem I'm having a blonde moment. It was a permissions issue. The table was in a different users schema. DUH. Dave -Original Message- Sent: Monday, March 10, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Does it have foreign keys? Farnsworth, Dave wrote: I am trying to do a TRUNCATE TABLE My_Table but keep getting this error; A self-deadlock among DDL and parse locks is detected. In most cases, this self-deadlock is handled internally. This should be reported to Oracle Support ONLY IF an error is signalled back to the user on a command-line or screen. The following information may aid in finding the problem. ORA-04020: deadlock detected while trying to lock object DFARNSWORTH.REGION_ZIPS This is in my test environment and there should not be anything else locking the table. Any ideas?? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave 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: Suzy Vordos 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: Farnsworth, Dave 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: Big SGA.......
duct
tape
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]Sent: Monday, March 03, 2003 5:10
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Big SGA...
Sybase, Schmybase, Oracle, Schmoracle -- the
concepts are still the same. Developers create tables and indexes and
then write SQL, thinking that the RDBMS is at fault if performance doesn't
match expectations.
They have to understand that the structures they
have created or the queries they have written may simply be inefficient,
expending too much work. I don't know how to measure that in Sybase, but
I'm reasonably sure that there must be a way.
I used to joke that I could get
OracleERP/Appsto run on a Palm Pilot if I were permitted to
reallytune the SQL. The work performed by an application is not an
immutable monolith, especially with the Oracle RDBMS and all of the
performance statistics it keeps. It is very much susceptible to
improvement.
First, they must make a reasonable attempt to
*fix* the problem (by making SQL more efficient). If that doesn't work,
thenthey should*accomodate* the problem by buying more hardware,
increasing buffer sizes, etc. The key with the latter approachis
to realize that you haven't fixed anything, only accomodated it by throwing
resources at it.
Pop quiz: Think of a parent with a spoiled
child who is making a scene in public. How do you quiet the child?
:-)
- Original Message -
From:
Loughmiller, Greg
To: Multiple
recipients of list ORACLE-L
Sent: Monday, March 03, 2003 2:28
PM
Subject: RE: Big SGA...
one little piece of information..(considered
critical probably:-) )
There isn't an opportunity to use statspack... The
current application is running on sybase:-)
I
do have other teams researching the questions you mention. its a real fun
project...
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]Sent: Monday, March 03, 2003 2:02
PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Big SGA...
Please start using STATSPACK now to gather
and keep statistics. You are certainly going to need "before" and
"after" statistics to analyze.
Some questions:
Why does the development group think that
I/O is the problem? Have they been gathering data? Have you
seen it? Do you concur that their data proves that I/O is a
performance problem belonging to the Oracle database?
Let's assume that there is an I/O
problem. There are two ways to address I/O (as stated in the YAPP
report of www.oraperf.com):
reduce the *cost* per I/O request or reduce the *number* of I/O
requests. The former implies getting a better/faster I/O
subsystem, redistributing I/O load to different volumes, etc. Not
trivial. The latter implies improving the Buffer Cache Hit Ratio
(BCHR) by increasing the size of the Buffer Cache or it implies making
queries more efficient, so that they simply don't issue so many I/O
requests (either to the Buffer Cache or to the disk).
Gathering STATSPACK data and searching for
the SQL statements generating the largest number of "physical I/O"
requests might be illuminating for the developers. If you work with
them on a one-by-one basis on tuning each of these SQL statements, you
might see dramatic improvements in performance.
Suggest to them that *after* you are
confident that there are no tunable SQL statements, then you might
consider increasing the size of the Buffer Cache.Doing
sois a last resort, not a first response. This is because
doing so does not fix the real problem, it only accomodates the real
problem, which is inefficient SQL.
Hope this helps...
-Tim
- Original Message -
From:
Loughmiller, Greg
To: Multiple
recipients of list ORACLE-L
Sent: Monday, March 03, 2003 10:59
AM
Subject: Big SGA...
hey folks..
Hoping for a little feedback and opinion
please. Having a discussion with the development group
...
The
development group is thinking that a VERY LARGE SGA would solve some of
their I/O problems. For example, they believe that a SGA consisting of
over 8GB of db block buffers would resolve their multitude of
issues.I feel that they open another can of worms with something
such as this.. And granted-there hasn't really been an infrastructure
evaluation-and the SA group is currently performing that review of the
environment.
Big SGA.......
hey folks.. Hoping for a little feedback and opinion please. Having a discussion with the development group ... The development group is thinking that a VERY LARGE SGA would solve some of their I/O problems. For example, they believe that a SGA consisting of over 8GB of db block buffers would resolve their multitude of issues.I feel that they open another can of worms with something such as this.. And granted-there hasn't really been an infrastructure evaluation-and the SA group is currently performing that review of the environment. One could suggest that they could "cache" some very large tables in the SGA; but there seems to be some sense of a down side to this.. Could you all provide some input on "Extremely large SGA's"? In the area of 8GB or so.. BUT, most of this would be the database blocks. Would you all be so kinds to provide your thoughts please? TIA Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: Big SGA.......
one
little piece of information..(considered critical
probably:-) )
There
isn't an opportunity to use statspack... The current application is running on
sybase:-)
I do
have other teams researching the questions you mention. its a real fun
project...
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]Sent: Monday, March 03, 2003 2:02
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Big SGA...
Please start using STATSPACK now to gather and
keep statistics. You are certainly going to need "before" and "after"
statistics to analyze.
Some questions:
Why does the development group think that I/O is
the problem? Have they been gathering data? Have you seen
it? Do you concur that their data proves that I/O is a performance
problem belonging to the Oracle database?
Let's assume that there is an I/O problem.
There are two ways to address I/O (as stated in the YAPP report of www.oraperf.com): reduce the *cost*
per I/O request or reduce the *number* of I/O requests. The former
implies getting a better/faster I/O subsystem, redistributing I/O load to
different volumes, etc. Not trivial. The latter implies
improving the Buffer Cache Hit Ratio (BCHR) by increasing the size of the
Buffer Cache or it implies making queries more efficient, so that they
simply don't issue so many I/O requests (either to the Buffer Cache or to
the disk).
Gathering STATSPACK data and searching for the
SQL statements generating the largest number of "physical I/O" requests might
be illuminating for the developers. If you work with them on a
one-by-one basis on tuning each of these SQL statements, you might see
dramatic improvements in performance.
Suggest to them that *after* you are confident
that there are no tunable SQL statements, then you might consider increasing
the size of the Buffer Cache.Doing sois a last resort, not a
first response. This is because doing so does not fix the real problem,
it only accomodates the real problem, which is inefficient SQL.
Hope this helps...
-Tim
- Original Message -----
From:
Loughmiller, Greg
To: Multiple
recipients of list ORACLE-L
Sent: Monday, March 03, 2003 10:59
AM
Subject: Big SGA...
hey folks..
Hoping
for a little feedback and opinion please. Having a discussion with the
development group ...
The development
group is thinking that a VERY LARGE SGA would solve some of their I/O
problems. For example, they believe that a SGA consisting of over 8GB of db
block buffers would resolve their multitude of issues.I feel that they
open another can of worms with something such as this.. And granted-there
hasn't really been an infrastructure evaluation-and the SA group is
currently performing that review of the environment.
One could
suggest that they could "cache" some very large tables in the SGA; but there
seems to be some sense of a down side to this.. Could you all provide some
input on "Extremely large SGA's"? In the area of 8GB or so..
BUT, most of this would be the database blocks. Would you all be so kinds to
provide your thoughts please?
TIA
Greg
Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS)
678.893.3217
(office)
RE: Big SGA.......
Title: RE: Big SGA... BINGO!! The politics is definitely a key contributor to all projects here in this shop:-) greg -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Monday, March 03, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Big SGA... One additional consideration on this topic is the politics of the situation. If your shop is one where development has undue influence on upper management decisions (i.e. the tail wagging the dog), the politics might be such that garbage is deployed and it's expected that the support people (i.e. sys admin and DBA) will throw enough hardware and general tweaking to get the app to run fast enough to be useful. In such a situation, a monster SGA might not be much help, but you can at least point to the monster SGA and say There it is! ... Not that I would know of any such shop where this situation occurs ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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 and SUN config question...
Title: RE: Oracle and SUN config question... I guess I wasn't very clear in the initial posting. Hangovers can be a dreadful thing.. Let's assume that I have 16 Databases on a SUN enterprise server. The architecture is to install Oracle and it's associated components all in one container. And within this container; I'll have an $ORACLE_HOME, a database,et,etc. And each container is owned by a different account(oradb1, oradb2,oradb3,etc,etc). Think of a container as an OS domain. Yet without the overhead of the OS.. Sure, there is some differences of opinion on why to do this,etc. Not wanting to get into those discussion of merit right now. But I'm looking to find out how to isolate the oraInst.loc file for each individual container. The idea in our environment is to be able to lift and drop that container to another enterprise server for one reason or the other. We select a database-and move the container to a different box. If everything is within the container; there really isn't any configuration changes to worry about because I moved a database from box A to box B. The underlying architecture at the OS level allows us to do this (storage is on the SAN, mucho brocade switches and HBA cards,etc). Now if I want to move database JOSE on server TEQUILA to server PORCELINETHRONE-I would like to have the oraInst.loc and oratab within that container. And at one time-I thought that on SUN there was an environment variable/install option that would allow one to position those files accordingly. So the oratab file can be handled via environment variables. No sweat there, got that one covered..But what about the oraInst.loc? thank greg -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle and SUN config question... The quick and dirty way would be to use soft links. Or you can change the oracle startup scripts (I think). Might there be a line like: ORATAB=/your/favorite/spot in the startup/shutdown scripts?? -Original Message- I have a quick question.. In a SUN environment, how would one place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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).
Oracle and SUN config question...
I have a quick question.. In a SUN environment, how would one place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle I seem to remember a method on making that happen...But I have either encountered a Senior moment or I have destroyed that brain cell from last nites opportunity to talk with my friend, Jose, and his partner "the worm".. (not to mention the possibility of talking to Jose's friend - Earl) Thanks in advance! Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: Teradata baned from IOUG???
go get'm big dawg In all honesty, this was educational to me as I'm not sure that a lot of people understand the process for the selection.. I have learned something today. And once that's accomplished, I need to celebrate.. So now I can go home and drink beer for the rest of the day:-) Matt-I65 was really ugly last weekend with the Sunday Ice:-) -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Teradata baned from IOUG??? Alright, Mogens. I'll stand up here. I'm one of the two DBA focus area managers (FAMs) for IOUG 2003. My fellow FAM and abstract reviewers (3 of them) and I are the ones who choose this presentation (along with all the others in the DBA track). None of us are employed by TUSC or by Oracle. You statement: "how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through." is technically accurate. The only other presentation with the word "ratio" in the title was rejected.However, there are a number ofotherspresentations that fall within this specific area oftuning by a number of people, including Roger Schrag, Cary Millsap,Jonathan Lewis, I cannot and will not go into the particulars of why a specific presentation was chosen, but I can tell you that no weight was given to the employer of the speaker. Matt Adams - GE Appliances - [EMAIL PROTECTED]We have enough youth.How about a fountain of intelligence? -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???Then why this feeling (in other countries, too) that IOUG should be called TOUG instead? Funny how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through. Funny how an abstract like the following nonsense makes it through the process. Just downright funny, strange and not very convincing... who in their right mind said this was a professional presentation that would be of interest to any serious optimiser guy or girl? Somebody must have said Aye to this. Are you ready? Here we go:"Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. " Henry Poras wrote: Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego).I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently.Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Title: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? oops.. Just talked with the good old Veritas/Sun boys the software would need to be there to handle and configure the inter-connoect:-) -Original Message- From: Loughmiller, Greg Sent: Friday, February 21, 2003 12:20 PM To: '[EMAIL PROTECTED]' Subject: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are: 1. File systems-use veritas Cluster manager 2. Raw Devices - Gotta use the SUN Cluster 3.x So I assume these guys would be on top of it since the mtg we had was this past week.. Our POC was with Veritas; and the options for implementation are listed above... Hope this helps-and please, if you have confirmation otherwise-it would be very interesting info to obtain. Thanks! Greg -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:16 AM To: Multiple recipients of list ORACLE-L Subject: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash 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: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Title: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are: 1. File systems-use veritas Cluster manager 2. Raw Devices - Gotta use the SUN Cluster 3.x So I assume these guys would be on top of it since the mtg we had was this past week.. Our POC was with Veritas; and the options for implementation are listed above... Hope this helps-and please, if you have confirmation otherwise-it would be very interesting info to obtain. Thanks! Greg -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:16 AM To: Multiple recipients of list ORACLE-L Subject: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster?? I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash 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: GRRRRR OWS
Title: RE: GR OWS LMAO.. Now you need a database named WHUP and A$$ -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: GR OWS A good website for appropriate telephone technique can be found at www.roydmercer.com Roy D. Mercer is such an inspiration that we even have test databases named ROY and MERCER. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: Automatic Segment Space Management
Title: RE: Automatic Segment Space Management In a very isolated test scenario with RAC; it removed a tremendous amount of free list contention(as well as header block..). In addition, we removed latch contention for a couple of specific latches as well.. But keep in mind; this was a very isolated test scenario.. Not sure how it would react with an ERP type of environment.. greg -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 9:34 AM To: Multiple recipients of list ORACLE-L Subject: Automatic Segment Space Management I'm continuing to introduce myself to 9i. I've been reading about Automatic Segment Space Management, and I just wondered if anybody had any positive/negative experiences with it. I got some good info at: http://www.dbazine.com/burleson11.html Thank you, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter 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: Using Soft Links for Datafiles
Title: RE: Using Soft Links for Datafiles Raj- We used the symbolic links on a regular basis in a previous life.. But we did not have the opportunity to use RMAN, so I am not able to address that right now. But when we lost sym links; we actually had to restore and recover. And that's why we treated the sym links with some special gloves. Not that I'm putting a plug in, but hat platform are you going to use RAC upon? There is a product by Veritas on the market that will allow you to use cooked files with RAC. In some initial testing-it worked Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: Using Soft Links for Datafiles Resending. Any takers? - Forwarded by Rajesh Rao/JPMCHASE on 02/07/03 11:51 AM - Rajesh Rao/JPMCHASE@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] CHASE cc: Sent by: Subject: Using Soft Links for Datafiles root@fatcity. com February 06, 2003 04:23 PM Please respond to ORACLE-L We are in the process of creating a 9.2 RAC database. And we are being forced to follow a standard whereby, all files are to be in a directory structure, say /local. No standards have yet been defined, if one were using raw volumes. And since we will be using raw volumes for the datafiles, to enforce the standards, we are being asked to create symbolic links from /local datafiles to the raw volumes. To convince them otherwise, I have seemed to dug up two issues. 1. For some reason, if the link breaks or is removed while the databases are up and running, its akin to taking a datafile offline, which would neccesitate a recovery. 2. While doing a restore, RMAN would restore the files to the link directory and not to the actual raw volume. Does this hold water? Anyone has other ideas or gotchas with using symbolic links for datafiles? Or Am I just being paranoid? I commonly use links for raw datafiles. Doing so aids the adoption of meaningful naming conventions - Steve Adams Thanks 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: 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: Take Care of your DBAs
Title: RE: Take Care of your DBAs I'll add to this... the kids school has been closed several times over the past few years due to the threat of snow.. folks go off the deep end down here... the weatherman can make or break the local Kroger with a run on bread and milk if they even mention snow. greg -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:01 AM To: Multiple recipients of list ORACLE-L Subject: RE: Take Care of your DBAs You gentlemen do not know what it is like to have snow related traffic problems. In Atlanta a snow flake can cause a multi-car pileup with a 3 hour commute delay. Why just having cold weather (20 degrees F) will cause schools to close. Boy I miss New England. Transplanted CT Yankee, Ron [EMAIL PROTECTED] 01/30/03 10:09AM It's nice to have four seasons. As long as the temperature doesn't drop under 60 during any of those four seasons. Four feet of snow? Here in CT, we had few inches and the traffic collapsed. What do you drive? Sherman tank? -- 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). -- 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).
Oracle Silent Installs and Response files...
Hey guys- Have any of you all messed around with the silent install/response files? I'm looking for tips, advice, do's, don'ts,etc,etc TIA Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: ORA-29702: error occurred in Cluster Group Service operation
Title: RE: ORA-29702: error occurred in Cluster Group Service operation
I wonder if it has something to do with the Clustered file system based on a couple of error messages...
In the messages-I see reference to the iofence-timer.
Just a thought
greg
-Original Message-
From: From [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-29702: error occurred in Cluster Group Service operation
Hello all...
I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. This is based on the
Oracle Linux+Firewire project:
http://otn.oracle.com/tech/linux/open_source.html
I'm getting the ORA-29702 during database create.
Any ideas?
Sean
-- sqlplus, create database --
SQL onnect / as sysdba;
Connected to an idle instance.
SQL startup nomount;
ORACLE instance started.
Total System Global Area 135336428 bytes
Fixed Size 451052 bytes
Variable Size 96468992 bytes
Database Buffers 37748736 bytes
Redo Buffers 667648 bytes
SQL create database EASTWEST
maxinstances 5
maxlogfiles 10
character set we8iso8859p1
datafile '/ocfs/oradata/EASTWEST/sysEASTWEST01.dbf' size 500m reuse
default temporary tablespace tempts tempfile
'/ocfs/oradata/EASTWEST/tmpEASTWEST01.dbf'
size 50m reuse
undo tablespace UNDO_WEST datafile
'/ocfs/oradata/EASTWEST/undEASTWEST01.dbf' size 50m reuse
logfile
'/ocfs/oradata/EASTWEST/logEASTWEST01a.dbf' size 25m
reuse,
'/ocfs/oradata/EASTWEST/logEASTWEST01b.dbf' size 25m
reuse;
2 3 4 5 6 7 8 9 10 11 create database EASTWEST
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-29702: error occurred in Cluster Group Service operation
-- cm.log output --
oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan 8 02:39:05 2003 }
OemNodeConfig(): Network Address of node0: 192.168.0.9 (port 9998)
{Wed Jan 8 02:39:05 2003 }
OemNodeConfig(): Network Address of node1: 192.168.0.8 (port 9998)
{Wed Jan 8 02:39:05 2003 }
WARNING: OemInit2: Opened file(/ocfs/oradata/foo 8), tid = main:8192
file = oem.c, line = 491 {Wed Jan 8 02:39:05 2003 }
InitializeCM: ModuleName = iofence-timer {Wed Jan 8 02:39:05 2003 }
InitializeCM: Kernel module iofence-timer is not loaded, try to
load(/sbin/insmod iofence-timer) {Wed Jan 8 02:39:05 2003 }
ClusterListener (pid=13717, tid=24580): Registered with watchdog daemon.
{Wed Jan 8 02:39:05 2003 }
WARNING: InitializeCM: Kernel module iofence-timer cannot be loaded,
please check if the module is in system lib path., tid = main:8192 file =
cmstartup.c, line = 311 {Wed Jan 8 02:39:08 2003 }
CreateLocalEndpoint(): Network Address: 192.168.0.9
{Wed Jan 8 02:39:08 2003 }
NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Wed Jan 8 02:39:13 2003
}
HandleUpdate(): SYNC(0) from node(0) completed {Wed Jan 8 02:39:15 2003 }
HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Wed Jan 8 02:39:15
2003 }
NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Wed Jan 8 02:39:15
2003 }
Successful reconfiguration, 1 active node(s) node 0 is the master, my
node num is 0 (reconfig 1) {Wed Jan 8 02:39:15 2003 }
oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan 8 02:44:00 2003 }
OemNodeConfig(): Network Address of node0: 192.168.0.9 (port 9998)
{Wed Jan 8 02:44:00 2003 }
OemNodeConfig(): Network Address of node1: 192.168.0.8 (port 9998)
{Wed Jan 8 02:44:00 2003 }
WARNING: OemInit2: Opened file(/ocfs/oradata/foo 8), tid = main:8192
file = oem.c, line = 491 {Wed Jan 8 02:44:00 2003 }
InitializeCM: ModuleName = iofence-timer {Wed Jan 8 02:44:00 2003 }
InitializeCM: Kernel module iofence-timer is not loaded, try to
load(/sbin/insmod iofence-timer) {Wed Jan 8 02:44:00 2003 }
ClusterListener (pid=13800, tid=24580): Registered with watchdog daemon.
{Wed Jan 8 02:44:00 2003 }
WARNING: InitializeCM: Kernel module iofence-timer cannot be loaded,
please check if the module is in system lib path., tid = main:8192 file =
cmstartup.c, line = 311 {Wed Jan 8 02:44:00 2003 }
CreateLocalEndpoint(): Network Address: 192.168.0.9
{Wed Jan 8 02:44:00 2003 }
NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Wed Jan 8 02:44:05 2003
}
HandleUpdate(): SYNC(0) from node(0) completed {Wed Jan 8 02:44:07 2003 }
HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Wed Jan 8 02:44:07
2003 }
NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Wed Jan 8 02:44:07
2003 }
Successful reconfiguration, 1 active node(s) node 0 is the master, my
node num is 0 (reconfig 1) {Wed Jan 8 02:44:07 2003 }
WARNING: ReadCommPort: received error=104 on recv()., tid =
ClientProcListener:81929 file = unixinc.c, line = 762 {Wed Jan 8 02:45:16
2003 }
WARNING: ReadCommPort: socket closed by peer on recv()., tid =
ClientProcListener:90121 file = unixinc.c, line = 754 {Wed Jan 8 02:45:16
2003 }
WARNING: ReadCommPort: socket closed by peer on recv()., tid =
ClientProcListener:98313 file = unixinc.c, line = 754 {Wed Jan 8 02:45:16
2003 }
WARNING: ReadCommPort: socket closed by peer on recv()., tid =
ClientProcListener:106505 file = unixinc.c, line =
Question about a session error with 9iRAC
Have any of you all seen this error-and really understand what causes this type of situation? The scenario is where we have several sessions up and running; and a couple will get this error when we try to use the TAF functionality while ripping the legs out from underneath an Orale instance... the session should be a "select" only session (we thought) Thanks oerr ora 2540825408, 0, "can not safely replay call"// *Cause: The connection was lost while doing this call. It may not be// safe to replay it after failover.// *Action: Check to see if the results of the call have taken place, and then// replay it if desired.// Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
9i RAC and Backup/Recovery....
Title: 9i RAC and Backup/Recovery Hey guys- Anyone out there got any gotchas related to backup with RMAN within a 9i RMAN environment? Or better yet-any test scenarios that folks would like to see Thanks! Greg
RE: 1998 Openworld CD
Title: RE: 1998 Openworld CD Jeremiah- You won't believe this!! I have two of them:-) And one of them has not even been opened. So let's contact each other offline from the list to figure this out. Greg Loughmiller [EMAIL PROTECTED] -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Subject: 1998 Openworld CD I believe 1998 was the last year they provided CDs with papers and presentations. Does anyone still have the 1998 CD and is willing to share it? Please mail me directly off list: [EMAIL PROTECTED] Thanks, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
We were the other way around in our testing lately:-) We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention.. anyway, more tests to follow -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 10:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]Sent: Sunday, December 15, 2002 8:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOBIn the 9i SQL Reference Guide Release 2 9.2,under "CREATE TABLESPACE", "segment_management_clause"Restrictions on the AUTO clause:·You can specify this clause only for permanent, locally managed tablespace. ·You cannot specify this clause for the SYSTEM tablespace. In the 9i Application Developer's Guide - Large Objects (LOBs) Release 2 9.2,the chapter "What's New with Large Objects (LOBs) ?", under"LOB Features Introduced with Oracle 9i, Release 2 (9.2)" ,under "Removed Restrictions" :Locally managed tablespaces restriction removed You can now create LOB columns in locally managed tablespaces.Also, in the 9iRelease2 9.2.0 Administrator's Guide,Chapter 11 "Managing Tablespaces", there is no restriction on LOBsfor Segment_Space_Management AUTO. [here, too, there's a lineindicating Segment_Space_Management AUTO is preferred for RACenvironments]Specifying Segment Space Management in Locally Managed TablespacesWhen you create a locally managed tablespace using the CREATE TABLESPACE statement, the SEGMENT SPACE MANAGEMENT clause allows you to specify how free and used space within a segment is to be managed. Your choices are:·MANUAL Specifying MANUAL tells Oracle that you want to use free lists for managing free space within segments. Free lists are lists of data blocks that have space available for inserting rows. This form of managing space within segments is called manual segment-space management because of the need to specify and tune the PCTUSED, FREELISTS, and FREELISTS GROUPS storage parameters for schema objects created in the tablespace. MANUAL is the default. ·AUTO This keyword tells Oracle that you want to use bitmaps to manage the free space within segments. A bitmap, in this case, is a map that describes the status of each data block within a segment with respect to the amount of space in the block available for inserting rows. As more or less space becomes available in a data block, its new state is reflected in the bitmap. Bitmaps allow Oracle to manage free space more automatically, and thus, this form of space management is called automatic segment-space management.Automatic segment-space management is a simpler and more efficient way of managing space within a segment. It completely eliminates any need to specify and tune the PCTUSED, FREELISTS, and FREELISTS GROUPS storage parameters for schema objects created in the tablespace. If such attributes should be specified, they are ignored.Automatic segment-space management delivers better space utilization than manual segment-space management, and it is self tuning in that it scales with increasing the number of users, as well as instances. For a Real Application Clusters environment, automatic segment-space management allows for a dynamic affinity of space to instances, thus avoiding the hard partitioning of space inherent with using free list groups.For many standard workloads, application performance when using automatic segment space management is better than the performance of a well tuned application using manual segment-space management.Bottomline : Either it was a bug or a restriction, it was not possible in 9.0.1 and supposed to be possible in 9.2.0 --- definitelyworks in 9.2.0.2Why do you say "In a single instance environment unless you are doing something out of the ordinary, use of the clause will probably be detrimental. " ?HemantAt 03:03 PM 14-12-02 -0800, you wrote: Was the prohibitition on placing LOB's into tablespaces with automatic segment space management only a bug. I ask because the description of "auto" segment space management includes the following restrictionsRestrictions on AUTO: * You can specify this clause only for permanent, locally managed tablespace. * You cannot specify this clause for the SYSTEM tablespace.* You cannot
RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB :-0 Our ASS managment does a lot of thrashing lately... It's close enuf to Friday and a 2 week vacation as well. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB ASS Management? I'm snickering, I know it's juvenile humor, but... LOL! Let me tell you, my ASS is not on the Free List. And thrashing? I'll leave that one alone! Sorry everyone. Couldn't resist. Is it Friday yet... -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB Depending on your circumstances, ASS Management can eliminate severe contention on the freelists / freelist groups area. However, because Oracle is overgenerous with its allocation of bitmap blocks (which may turn out to be in excess of 1% of your database), you may end up thrashing your system because most of your buffer space is flooded with hot BMBs and the data has to keep thrashing on and off disk. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 December 2002 17:51 We were the other way around in our testing lately:-) We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention.. anyway, more tests to follow -Original Message- Sent: Thursday, December 19, 2002 10:09 AM To: Multiple recipients of list ORACLE-L As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Faking an ORA-600
Title: RE: Faking an ORA-600 How about taking the text of the ORA-600 error and CAT the text to the end of your alert file? I am assuming that you will be parsing the alert log for that type of notification greg -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 3:52 PM To: Multiple recipients of list ORACLE-L Subject: Faking an ORA-600 We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Recipe for application design to run on RAC
Title: RE: Recipe for application design to run on RAC So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-) I guess thats what I get when I picked a group of guys that are all on the injured reserve Seriously though--What if 50% of the blocks of data for schema1 are "owned" by db2? do you eventually see where ownership is transferred to the "active" node, reducedcache fusion activity and then transfer of blocks? Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2 thanks! Greg -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Recipe for application design to run on RAC H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
OT: Password Generator...
Title: OT: Password Generator... Hey folks- I have a question that was presented to me by a web development team.. Does anyone know of products,procedures,etc that would generate a random password for a user? For example-similar to that at MetaLink when you forget your password-and they send you a new one that is just a string of characters/numeric digits... Thanks! Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: Oracle Real Application Clusters
We are performing a rather detailed POC of RAC within a SUN environment... Be glad to share some details once we complete this to those interestedI'm hoping for a detailed document with detailed use cases... But that does assume those who are in the separate areas will accomplish that as desired... thanks greg -Original Message- Sent: Wednesday, October 23, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Aye to that, but you'll need at least two, possibly three, identical clusters, not just one. One cluster for production and an identical cluster for QA/Test, and possibly one for development (though that last is often regarded as unnecessary). Skimping on the QA/Test environment is the leading edge of failure... RAC itself requires additional DBA expertise as well as additional OS SysAdmin expertise for cluster hardware/OS, each of which costs more to obtain/maintain (either by hiring experienced/talented or training to build or both). Clustering is not a low-cost solution from any perspective... RAC is a solution for certain specific high-availability and high-scaleability requirements (not including data-center failure, a.k.a. disaster-recovery), so it's a good idea to be certain that you are planning a solution that meets your own specific requirements before proceeding. RAC should not be a high-level management decision -- it is a specific technical solution to meet specific technical requirements, which themselves should have been derived from the requirements of the business. There are several other possible H/A solutions in Oracle9i (i.e. physical standby, logical standby, advanced replication, OS failover solutions, RAC, etc), each of which addresses the same H/A problems in different ways with differing levels of complexity and cost. - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Wednesday, October 23, 2002 6:43 AM IMHO, the main requirement is that you have to have a system that needs to be up 24x7 on a cluster and your ability to fork enough money to Oracle and your server vendor (to get two identical machines) and your networking vendor (for redundant network connections). Rest everything is easy ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, October 23, 2002 3:04 AM To: Multiple recipients of list ORACLE-L Dear All, We are planning to implement ORAC for our application, can anybody tell me where to get good information on the system requirements for implementing the same. Regards Prem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Get together at OOW
- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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). === message truncated === __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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.com -- Author: Loughmiller, Greg 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: ETL architecture
An example of what we have/do here.. Not that it's perfect-but it seems to fit the need... We use an ETL tool (Informatica) from a central server. The scripts,etc will connect to the multiple datasources (oracle, db2, sybase, informaix,redbrick) to obtain the data based on the business rules and requirements... We also have the source systems extract and ftp to the ETL server as well. It's not the preferred method-but certain systems have a time critical issue when the extracts are ran.. Typically-if the business rules ask for 3 data elements. We get most of the important stuff from a table so we can extend the warehouse without going back to the source... There is some T going on as it loads those misc. data sources into the Staging area (oracle with the ETL). Or it takes the data straight to the warehouse (teradata). But multiple projects that require data for the different ?DW subject areas will use the same ETL infrastructure. greg -Original Message- Sent: Wednesday, October 16, 2002 2:26 PM To: Multiple recipients of list ORACLE-L Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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.com -- Author: Loughmiller, Greg 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 (Real Application Clusters)
Push the question about the requirement of RAW devices.. and ask if Veritas's product can work without any restrictions.. The veritas clustered file system is supposedly ok to use with RAC where you can take advantage of using file systems. But I haven't seen confirmation of that. also-ask about the differences in the hardware they are showing you as compared to your environment.. There are some differences in the implementation based on the hardware You should probably get good feel on how Oracle believes RAC could fit into your environment. Are you looking for 100% availability? Or just scalability? Can the environment take a 5 minute downtime for a Clustering solution? Or do you need to have the environment up all of the time... And as Rich indicates-the transparent application failover can be cool. But does your app use JDBC? Thick or thin? From our discussions with Oracle (as we prepare for a full blown POC of rAC) that one will need to use the thick JDBC client (cuz of the OCI layer) to take advantage of some of the TAF features.. This may not be the case in the future though.. oh well-time for coffee greg -Original Message- Sent: Thursday, September 26, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Specifically ask about RAC's performance with respect to platform. I saw a demo that HP put on at a WOUG meeting where the NT cluster took 20-30 seconds to fail over. While this isn't earth-shattering, there was mention made that Unix/Linux failover times only took about 1-2 seconds. Might be an issue for e-commerce or such. Very impressive demo they put on. I especially liked the transparent query failover and load balancing. Da-rool, da-rool. Of course, for us to convert our concurrent user licenses to per-CPU licensing for RAC, well... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Subject: RAC (Real Application Clusters) I am visiting Oracle next week and will be getting a dog-and-pony show on Oracle 9i and RAC (Real Application Clusters). Does anyone have any experience or comments on this product/technology? Can you suggest some burning questions I can pose to Oracle when we get the demos? This is a technical overview and we will be seeing conversions (Apps and non-Apps environments) as well as failure scenarios. Any advice/comments are welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Loughmiller, Greg 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: Best method to move Filesystems to RAW Devices.
Nat- You may want to check out a product from Veritas.. *Supposedly* their clustered file system product is *approved* with 9i RAC on a SUN platform.. This is strictly from the rumor mill and I have no solid documentation to confirm (CYA). I am actually in the beginning phases of a project to build out a pair of SUN 6800's for a RAC environment. And we want to explore all possibilities for configuration options... greg -Original Message- Sent: Friday, September 20, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Joe, We are planning to move to RAC. Per Oracle RAW devices is must for RAC. As you said, Yes there is little performance gain just moving to RAC and more work to DBA's/SA's. But this seems to be the main requirement for RAC. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 8:53 AM the first question is WHY go to raw devices?, OPS/RAC? other than those 2 reasons(and i'm not sure RAC requires it like OPS did), there is very little performance gain with the advances in filesystem types. just curious. joe Nat wrote: We are planning to move to raw devices for all our existing file systems. Our database size is around 400 Gig. What is the recommended method that you guys feel is best as far as time required to convert and ease of conversion. We feel we cannot use export - import as this may take more time for conversion.. I checked many documents to find out the best method, there are few suggestions to use RMAN to convert to raw. seems it is fastest. At this point we have not configured RMAN on our databases so this suggestion seems to be of no use for us. Please let me know, if any of you went through this exercise and any suggestions and tips will be more beneficial, Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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.com -- Author: Loughmiller, Greg 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).
Question on Oracle 9iAS and Oracle 6i/9i tools...
We will be building an environment (multiple hosts and environments) that will be used for reporting. And we will be using the Oracle suite of products (9iAS, iDS). I'm tasked with determining some of the architecture of the environment. And primarily for the Oracle 9i environment used as a repository and some of the 9iAS infrastructure... And having not had the time to play in the sand box - I need to make some blind assumptions. But was hoping that folks on the list could offer some suggestions... For example-how large of a repository is typically required for the Oracle MetaData used for the reports? I assume that it depends on the number of reports,etc.. But is there any rule of thumb(you know-like a swag) that you all have used in sizing the environment? What about other file system space requirements to consider??? For example-one of the tasks will be that the reports will be executed the evening before-and the output would be saved.. Will this require additional disk space as part of the 9iAS implementation? What typical space and file system setup have you all seen as best practices for the 9iAS environment? I know, I know - read the #$$^%$#$%# manual... But unfortunately-there is a rather tight deadline with not much lead time.. So I would appreciate any tips that you could offer from your experience in the implementation of this suite of tools... Thanks in advance! Greg Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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).
Oracle Reports 6i Vs 9i
Does anyone have an opinion as to which is easier to implement, architecture, performance and development differences? We are working on implementing on of these.. We have a standard on App Servers and we need to consider the use of BEA/Iplanet and being used as a proxy... thanks! Greg Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Why use a Unix Pipe to uncompress a file?
We used it to migrate databases... For example.. We would export, compress and send it to a pipe via RSH on a different box... thin that pipe would be used as std input into an import process. The data never hit disk except into the new database. greg -Original Message- Sent: Wednesday, August 14, 2002 9:29 PM To: Multiple recipients of list ORACLE-L I know why i did it in the past, 32 bit os, 2G limitation of single file. i could run an export, compress on the fly and have a uncompressed file that is 2G. hence you need to work it backwards, since if its 2G, the uncompress will choke(or truncate). amazingly, that is NOT a stupid idea. joe Pat Howe wrote: I am trying to work thru the one of the scripts that I inherited and I was wondering if someone could shed some light on why the author used a UNIX PIPE to uncompress a file. Code : mknod /tmp/testdb_data_01.dbf_pipe p uncompress /tmp/testdb_data_01.dbf_pipe /u06/oracle/oradata/testdb/tbs/data_01.dbf sleep 1 cp data_01.dbf.Z /tmp/testdb_data_01.dbf_pipe Background : File 'data_01.dbf.Z' exists in compress format. We are currently in the directory where this file resides. My Confused Analysis : line 1 : creates a pipe file called 'testdb_data_01.dbf_pipe' in the '/tmp' directory line 2 : In the background we start to uncompress from the 'PIPE file' (FIFO) into my destination directory '/u06/oracle/oradata/testdb/tbs/data_01.dbf' line 3 : Puts the script to sleep for 1 second (no idea why) line 4 : In the background it copies the compressed file (data_01.dbf.Z) to the PIPE Therefore as the copy occurs (line4) - the PIPE (using a First-In-First-Out) starts to uncompress my file (line2). Question : What does this gain me ? Ie ; Why would the author do this ? Seems to me to be alot of additional IO copying the file to '/tmp'. Why not just uncompress the file directly to its destination directory (/u06/oracle/oradata/testdb/tbs/) ? Thanks in advance _ Patrick J. Howe Oracle DBA VeriSign, Inc. 4501 Intelco Loop SE Olympia, WA 98507 Phone : 360.493.6284 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: a couple of questions
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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).
Dedicated connections and Memory usage
Need a little assistance on some concepts, so to speak.. When looking at the processes(dedicated connections) of an 816 database on a UNIX environment-the memory used for each process appears to be the same as the SGA. It's been awhile since I had to dig into this, but I thought that the dedicated connections had their own PGA(real memory of the machine). So is it coincidence that the dedicated connections (all 180 of them) are using the same amount of memory as the SGA?? What am I missing here??? TIA Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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:
the little red button is my favorite -Original Message- Sent: Wednesday, June 26, 2002 4:24 PM To: Multiple recipients of list ORACLE-L try: Ctl-Alt-Del. Works wonders. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 1:33 AM press F1 first, then ask more -Original Message- From: Ravindra B [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra B 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BELOV 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Re:RE: Alternative to Crystal Reports
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.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: RE: Online vs offline backups
And what pain do you create by backing up the online redo logs anyway? Considering you are backing up the database anyway-the online redo logs will not add hours to that cycle.. It's worth the effort, cuz those puppies are like gold(as well as the archived logs).. Been burnt one too many times as Jared has indicated about shutdown immediate... greg -Original Message- Sent: Thursday, June 20, 2002 10:38 PM To: Multiple recipients of list ORACLE-L O, here we go again. I don't care what logic, documentation, oracle support and/or common sense have to say on the matter. Back up those redo logs! Just don't restore them unless you need them. 'shutdown immediate' doesn't always work the way one would hope, especially on Windoze NT. I've restored a database here which required those online redo logs for recovery. Think of it as cheap insurance, and one less reason to keep your resume up to date. Jared chal_ping [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/19/2002 05:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: Online vs offline backups Ferenc Mantfeld£¬ The same person that advocated a cold backup did not back up the online redo logs, so what use was it anyway, since the only way they would force open their DB is with a resetlogs option anyway. For cold backup, oracle does not recommend backup the online redo log. And if you restore the whole cold backup, why need the online redo log? I am sure people doing cold backup will do shutdown normal/immediate, not shutdown abort.So there is no need to backup the online redo log at all! Backup the online redo log also take the risk of damage the current online redo log when you want to do full recovery. So, never backup the online redo log when doing cold backup. Ö Àñ£¡ chal_ping [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chal_ping 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). W±?zØ^¡÷âr?,B?m¶ÿ?(§Ú©?ëa¢² 2ZçR?e§b? ¢aZ?È×ÂäIêïǬó?ßÎtçQ@_Î|?9ÓRjpâz jX¢¹âhû?׫ëZqǬ³óX§¸¬¶ÄèDCTL¨º?÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k «¹ör+rr§¢×\²¥?à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§y?µ¨§x5%9,Bè®Ø^©¡ù X§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^ BÏr¦jw_¢º- êâ?«b¢ybë.n?¸ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Oracle Developer/DBA Needed in Macon, Georgia-Local Candi
ya just have to understand where Noble is located... Most of the family trees dont have branches :-) greg -Original Message- Sent: Tuesday, February 19, 2002 3:20 PM To: Multiple recipients of list ORACLE-L HUMM, After the fiasco in Noble who in their right mind would want to go to Georgia. :-) Reply Separator Author: OraStaff [EMAIL PROTECTED] Date: 2/19/2002 7:38 AM Stable manufacturing firm in Macon, Georgia is looking for an Oracle developer who has some DBA functions as well. Oracle development is the key. If the candidate has strong development skills and is interested in doing some DBA functions and some knowledge of the functions, resumes would be welcomed. This is a full-time staff position. *Only candidates who live in the Macon and 285 loop area will be considered. No relocation is provided. Only sent a resume if you are in this area. ** No Sponsorship is available. DO NOT send your resume if you have H-1B status. *Candidates Need to have solid Oracle Forms, Reports, PL/SQL experience.. some DBA experience is highly preferred. Base salary is in the 70-80 K range. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: One/Macon/Dev/DBA/Larson All inquiries held in confidence. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: SCOTT/TIGER
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: VLDB backup policy
-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Blocking illegal connections
Is the development group(the illegal connections) on a different sub-net of the network? We just blocked the sql*net port (1521) at a router from the development subnet to the production environment... It wasn't fool proof-but made it more difficult to get to the production environment If you have static IP(doubtful), one could use sqnnet.ora.. But that was very practical in our shop.. Greg -Original Message- Sent: Thursday, December 13, 2001 7:55 AM To: Multiple recipients of list ORACLE-L This is my whoison.sql - not mine but I don't remember where I got it. ttitle off set pages 40 lines 132 column value heading '' column sessions_current format 999,999,999 heading '# Currently Logged On' column sessions_highwater format 999,999,999 heading 'Most # Logged On' column pusername format a8 heading 'Process|User' column terminal format a14 heading 'Terminal' column pprogram format a26 heading 'Process program' column susername format a8 heading 'Session|User' column server format a9 heading 'Server' column osuser format a8 heading 'Op Sys|User' column sprogram format a27 heading 'Session program' select value from v$parameter where name='db_name'; select sessions_current, sessions_highwater from v$license; select p.username pusername, s.terminal, p.program pprogram, s.username susername, server, osuser, s.program sprogram from v$process p, v$session s where addr=paddr(+) / If you look at program from v$session you should be able to find Toad etc. Walter K alden14004 To: Multiple recipients of list ORACLE-L @yahoo.com [EMAIL PROTECTED] Sent by: rootcc: Subject: Blocking illegal connections 12/12/2001 05:20 PM Please respond to ORACLE-L Hi, We're trying to prevent users from connecting to our production database via illegal connections (i.e. tools like TOAD, etc.). Does anyone have any suggestions on how to block connections from query tools (i.e. Toad, SQL Nav, etc.) in such a way that an error message is reported back to the tool user that the connection is prohibited? We've tried designing a logon trigger with a PRAGMA definition but the error message is not getting relayed back to the client. As always, your feedback is appreciated! -w __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Recommenations for a DB conversion using SQL Loader
Previous conversion that we did-we also built the indexes after the data was there.. we had a ton of data.. And it was 3x faster to build the indexes and add constraints after the data got to the destination.. Greg -Original Message- Sent: Wednesday, December 12, 2001 12:42 PM To: Multiple recipients of list ORACLE-L Ken, A few things you could try here: 1) disable the foreign key constraints for the load or 2) load the parent tables before the child tables If you have a huge amount, you might want to consider dropping all of the indexes, except for the primary and unique key constraints. (I don't like to take chances when it comes to data integrity.) This would save you a boatload of time. Regards, Jeff - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 9:45 AM I am working on a one time DB conversion project for a state government entity. I have a DB (8.1.7 on W2000 server) setup without the application SW that I am using to load the data into from flat files. When I get this data loaded I will then load it into the production tables at the client site. I will not be running any applications on this DB, it's for conversion purposes only. I am running into some constraint violation problems since I am loading the data to each table one at a time. Would it be prudent to disable the constraints until I get all the data loaded? Any and all suggestions are welcome. Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JeffCox 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Problems with SQL Server Link Server to ORACLE
Title: Problems with SQL Server Link Server to ORACLE See if your connection can perform some sort of select via the ODBC in SQL I have been playing around with moving data from Oracle to SQL via a DTS package And got some nasty error messages when the columns were mismatched(for example, moving a varchar to float,etc), permissions on the ORalce side, and permissions on the SQL side... I actually had to create a user(same name and password) on each database.. Shouldn't have to-but that got around one of my problems... HTH -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 3:15 AMTo: Multiple recipients of list ORACLE-LSubject: Problems with SQL Server Link Server to ORACLE Hi List, Problem receiving this error on a Link Server from SQL Server 7.0 and 2000 to Oracle 817 INSERTED INTO IR TABLE IR_MAXIMO_WORKORDER [SQLSTATE 01000] (Message 0) INSERTED INTO MAXIMO TABLE MAXTFMC..MAXIMO.IR_WO_IN [SQLSTATE 01000] (Message 0) OLE DB provider 'MSDAORA' could not INSERT INTO table '[MAXTFMC]..[MAXIMO].[IR_WO_IN]'. Unknown provider error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error 7312). The step failed. The ODBC that has been setup on both these SQL Servers is Oracle ODBC driver, I have personally created the connections and tested them - thus it can be assumed that the ODBC links work. The enviroments are as follows: Sql Server 1 Sql Server 7.0 Win NT 4.0 Service Packs 6a. Oracle ODBC Driver Sql Server 2 Sql Server 2000 Win NT 4.0 Service Packs 6a Oracle ODBC Driver Oracle System Oracle 8.1.7 Win 2k The problem appears to be resolved when the Link Server is rebuild using Microsoft OLE DB Provider for ODBC Drivers, which is substantial slower that the Microsoft OLS DB Provider to Oracle which has worked for a couple of weeks and yesterday suddenly decided not to work anymore. Does anyone have any idea of what is happening here? TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Standby Database
There may be some solutions available at the hardware level as well.. For example-SRDF on an EMC cabinet... and define the online redo logs/archive logs as part of the data transfer.. But there are performance problems with that as well. greg -Original Message- Sent: Thursday, November 29, 2001 12:40 AM To: Multiple recipients of list ORACLE-L If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janardhana Babu 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: RMAN, Netbackup question
Richard-I've seen ti done before.. But I can't remember the details. I had a couple of guys on my team at a previous shop do it. Greg -Original Message- Sent: Thursday, November 29, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hi all, I have a question regarding RMAN working with Netbackup. Is it possible to kick off multiple streams to write to the tape? I tried through RMAN to have 4 channels, but they are queued at the Netbackup Server. I want them to go in parallel. Now, it seems that for the Class Type Oracle, it's won't allow multiple data sterams. That option is greyed out. Thanks Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Listers meeting at OOW
good tequila too -Original Message- Sent: Tuesday, November 27, 2001 8:05 PM To: Multiple recipients of list ORACLE-L Chevy's was good, we will need a reservation -- and it's loud but everything will be loud --- John Kanagaraj [EMAIL PROTECTED] wrote: Hi all, I don't know the SF restaurants well enough, but Chevy's seems good enough. Howard and 3rd is close enough to Moscone. I will also be attending only the vendor exhibits, but will certainly meet the listers if all agree to this location/date/time. (I am hoping y'all will!!) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Molina, Gerardo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 1:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listers meeting at OOW Chevy's at Howard and 3rd is a good spot. I'll probably be attending only the vendor exhibits but I'll try to make the list get-together. Gerardo -Original Message- Sent: Tuesday, November 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L To continue the discussion on getting together at Openworld: How about Tuesday evening, around 7:00? Someone who knows downtown SF want to suggest a place? My preference is not too loud or too smoky. Call out on the list if you are going to come, so we can keep track of how many chairs to steal from nearby tables. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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
RE: Crontabs and Oracle
. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
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.com -- Author: Loughmiller, Greg 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: Oracle - SQL Server
Or , =gulp= , you could use ASP/COM type objects too. and use the infamous ODBC... greg -Original Message- Sent: Wednesday, October 03, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Hmm, very interesting, that may be a good option. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, October 03, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Also, I believe there is JDBC for MSSQL now - previous there was some sort of JDBC-ODBC bridging thing, or something like that. So you could probably use Java stored procedures in Oracle, maybe with a PL/SQL wrapper, and get at your MSSQL data like that via stored procedure calls. Hmm. g -Original Message- Sent: Tuesday, October 02, 2001 10:15 PM To: Multiple recipients of list ORACLE-L Oh geez, here I go again. This is trivial with Perl, DBD::Oracle and DBD::ODBC. Whether it is useful to you depends on a number of things. * can you use an Oracl copy of the SQL server data? * does the data always need to be fresh? * how fresh? * how big is it? Since it's temporary, this may work for you. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: I/O Performance/bottlenecks on EMC Symmetrix
Title: RE: I/O Performance/bottlenecks on EMC Symmetrix We saw this at a previous location and we found that we had logical volumes on the same disk.. Used for different applications, and even different systems!! For example-someone placed TEMP for DB1 and TEMP for DB2 on the same disk unknowingly This created just a small contention problem... This is a common problem when large sym cabinets are set up with "logical volumes split to different systems". Each LV may be defined such that you wont know that they are on the same disk. If you are using BCV's, and clustering-it get's even more detailed and confusing... Have the EMC rep come in, take a look at the "bin" file of your sym cabinet(s).. And see where the logical volumes are living.. Draw a map of the bin file with a graphical representation of each LV, and where they live... Greg -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 13, 2001 10:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: I/O Performance/bottlenecks on EMC Symmetrix At one site I worked using Oracle Financials we were having serious performance problems at what seemed to us random intervals. Spent months looking at the database after the Unix boys had said that there was no way we could have I/O problems with the throughput capabililities of EMC and the Symetrix set up we had. Eventually turned out that 3 systems were sharing the same disks and the disks had not been striped. Therefore other system were causing us performance problems. If you have an EMC support contract which I think you must have you, the SA's get all the free GUI tools that allow them to look at channels and logical/physical layout. Ask them about. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 September 01 12:55 To: Multiple recipients of list ORACLE-L Subject: I/O Performance/bottlenecks on EMC Symmetrix !! Please do not post Off Topic to this List !! Hi All, Does anybody here on the list have experience with EMC/symmetrix storage units.? We have our databases on this machine and I have a feeling the the I/O performance is not very good. I can not proof it since I do not have any experience/data/access to that machine. We do however have a very cooperative UNIX group but they also lack experience with performance on this machine. Who can give me pointers about I/O throughput that can be reached, configuration pittfalls etc.. Example: RS6000 8CPU's and 4Gb memory with storage on EMC/symmetrix. Job takes about 2 hours to complete. F50 1 CPU 1Gb memory (TEST machine) local disks. same job takes 0.5 hours to complete. Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and
RE: Roles and Responsibilities
How about some of these... Administer data... plans for database-related implementation and upgrades ensure the database integrity, security and availability (backups!! standby databases, OPS) Use data dictionary to ensure data integrity and security Recover corrupted data (use the backups now) Use tuning tools to improve database performance (understand the information Oracle provides) Maintain physical data models from logical data models Implement and maintain physical database systems (build new systems, new databases) Perform application RDBMS tuning. (tune the SQL...) Assist development staff Evaluate database management systems and versions (go to 9i?) Monitor assigned development projects to ensure compliance with standards. Work with Sys Admins to configure and balance the environment. Secure the operational databases and monitor Develop and implement data and database related standards, procedures and guidelines Perform logical and physical data modeling Manage database objects Design relational database models Coordinate testing activities. Maintain development, test and production environments Ensure that test data is current and functioning Monitor database efficiency and ensure optimal performance (monitor, report, revise, and refine) Capacity Planning. (need more memory, disks, CPU) Manage the process of configuration Management for the databases(physical and logical) Plan/schedule for DBMS installation Install/upgrade DBMS Plan/implement the production database operating environment(s) Establish database support procedures Provide day-to-day database support for production systems Provide information on new database technology to management Evaluate new database technology Support production databases using tools/utilities to tune, optimize performance and resolve technical database issues Develop and implement database standards and guidelines. Provide technical expertise and direction Provide technical direction for customer support purposes Kind of long, kind of wordy... But I used these at a previous job for Job descriptions/functions in building a career path for DBA's (entry, Jr, Sr,etc).. Not sure if this is what you are looking for.. This data came from several different sources. We just pulled it together and added a few items related to our environment... But it was used in building the job descriptions/career path(the HR stuff) for a centralized Oracle DBA team... HTH Greg -Original Message- Sent: Tuesday, September 04, 2001 6:36 PM To: Multiple recipients of list ORACLE-L Hi. My boss asked me to supply him with a detail paper on what DBA functions, roles and responsibilities. Could you please tell me any information or the websites for that kind of information ? Tia. Aldi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: OFA (Optimal Flexible Architecture) in practice
We used OFA with a small modification.. We used raw devices for the data files of the tablespaces. Then we built symbolic links to all of the necessary devices from a core directory. Those sym links were placed in a single directory off the $ORACLE_BASE. For example, all of the sym links would be in the following: $ORACLE_BASE/links/dbname It worked well for us... This may not fit the requirements of other shops... Greg -Original Message- Sent: Thursday, July 05, 2001 9:15 PM To: Multiple recipients of list ORACLE-L Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g.. /u02/oradata/db_name1/userdata01.dbf /u02/oradata/db_name2/userdata01.dbf /u03/oradata/db_name1/userdata02.dbf /u03/oradata/db_name2/userdata02.dbf You cannot cd to a given subdirectory, ls -ltR | more to see all the datafiles associated with a given database. Instead, from / you have to ls -ltR | grep db_name1 to scan the full file system. Seems like there should be a better way. Any input, pro or con, is appreciated. Linda, The point of OFA is to spread out the database over different drives for performance reasons. For example, you might want to separate indexes from data. Would what you are proposing allow for multiple drives? Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Re[2]: OT: Ari and his company have been noted in InfoWorld.
We did something similar to this 4 years ago using the 2 way pagers, email, home grown algorithm similar to secure key(give me a number and I'll check to see if it's the correct sequence), and a heck of a lot of PERL programming. So IF WE HAD COVERAGE on the 2-way pager(RIM pager using bellsouth's paging network)-it didn't require a lot of $$$. Shoot Walt-it may have had coverage in Absarokas ;-) Greg -Original Message- Sent: Thursday, July 05, 2001 3:41 PM To: Multiple recipients of list ORACLE-L InfoWorld. Well, we have remote access from home too, but it might be convenient to be able to do this stuff while I'm running from a grizzly in the Absarokas. That way I wouldn't have to hang around the house all weekend waiting for a call that might never come. Of course it's a moot point for us since (1) we're never on call here, and (2) there probably won't be wireless coverage in the Absarokas for another 200 years or so. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, July 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: ORA-27146: post/wait initialization failed
Check the parms in the /etc/system and in the init as well We ran into this when we did not have enough semaphores/message queues defined on the system. Also look in the TMPO file system for the .oracle directory.. sometimes removing that afte a shutdone and prior to startup resolved the issue.. greg -Original Message- Sent: Thursday, June 28, 2001 4:53 AM To: Multiple recipients of list ORACLE-L I have just installed Oracle 8.1.6 on Solaris 2.6 The machine already has Oracle 8.0.4 installed.. (I shut this database down, as I intended to remove all of it. Now I am getting this error when I try to startup my new 8.1.6 database. TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Virus again
yep... The boys in network admin initially said they would strip the virus-now they have said that they are going to block email from the list. I mentioned why not block email from the user-and their response was that other users from the list could get infected.. and exhibited an example where individual here on a Fin Apps list got infected.. bummer.. greg -Original Message- Sent: Thursday, June 28, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Did anyone else get that virus crap again? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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: Backups on raw devices
we used raw devices for years... And never had a problem with hot backups and restores... I question the need to skip the fist block of the raw device.. We never did that... Even in a parallel server mode as well Greg -Original Message- Sent: Friday, June 15, 2001 7:10 PM To: Multiple recipients of list ORACLE-L I agree as long you put the TS in backup mode. Also I'm not sure about skipping the header block! Regards, Waleed -Original Message- Sent: Friday, June 15, 2001 6:42 PM To: Multiple recipients of list ORACLE-L How would this be any different than reading a file system when write activity is taking place? It doesn't matter if it's the OS or Oracle managing the disk, block can and will be split during a hot backup. I think your sysadmins need to reconsider. And if I'm all wet on this, someone will be sure to tell me. :) Jared On Friday 15 June 2001 12:37, Jenkins, Michael wrote: We have parallel server running on on a Sun Cluster 2.2 and we are looking for the easiest way to perform hot backups. Now, I know that you have to use the dd command and skip the header at the beginning. Everything I read on metalink indicates that you can use basically the same paradigm as a hot backup on cooked file systems. But, the sysadmins here tell me that the raw device can't be backed up if there is any write activity on the data file that is currently being backed up. Now we all know that contrary to popular belief there is write activity on a data file even when the tablespace is in backup mode. Is rman or some other block-level backup utility the only way to get a reliable hot backup on raw devices? Does anybody have any experience with hot backups that are made while the database still has active users logged in? I look forward to everyone's thought on this. Thanks. Michael L. Jenkins Oracle Certified DBA Nextel Communications Norcross, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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).
Script examples for NT. (yuk!)
Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you would mind sharing a couple of NT type scripts with me.. For example-setting variables to the return of a SQL statement to be used in the shell,etc... Any help would be appreciated.. TIA Greg Loughmiller mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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).
