Re: OT: Solaris: Finding the cause for disk space growth
Check out the du (disk usage) command. man du [EMAIL PROTECTED] 01/23/04 03:44AM Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to knowwhich files/directories are growing. Is there any way to find out? Regards Naveen
RE: Help - 9ias broke - hostname was changed
Have the SysAdmin change the hostname back. Haven't used 9iAS but in the past, the hostname was embedded in the install config files. You can put in a DNS alias for your old hostname for a work around. [EMAIL PROTECTED] 01/23/04 11:44AM Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord DavidSent: Friday, January 23, 2004 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting
Re: Veritas Backup Question
I am from the old school, doesn't use RMAN, but soon will w/ our 9i upgrades. I recommend to use RMAN if you are starting out and buy this book. http://www.bookpool.com/.x/dt3bpjmwz1/sm/0072226625 hth, Gene [EMAIL PROTECTED] 01/15/04 03:14AM Teresita Castro wrote: Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He has been working with *Veritas NetBackup 4.5 for Windows* for three moths with out results. We still can not make a backup of our data bases.Hello,Did you use RMAN to backup your database ?If yes, did you use RMAN with recovery catalog or in nocatalog mode ?Did you install Veritas NetBackup Agent for Oracle ?regards,Marcin Przepio'rowskiSenior Oracle DBAwww.oracledba.pl-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: =?ISO-8859-7?Q?Marcin_Przepio=27rowski?= 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 removed from). You mayalso send the HELP command for other information (like subscribing).
Read Only TBS Backup Confirmation
ENV: - AIX 4.3.3 - Oracle 8.1.7 I have one tablespace which is read only.Can I just copy the datafiles from a Read Only tablespace for a valid backup? For the rest of the db, I backup hot or cold. Is anyone copying Read Only Tablespace datafiles for backups? I haven't found this method officially supported by Oracle, but have read that is safe to copy Read Only datafiles (makes sense), just wondering if anyone is doing it? Thanks, Gene
RE: Backups in a DW Environment
I put all databases in archive mode, i.e. dev, test, and production. I can use test db's to test backup/recovery scenario's. The only time they are not in archive mode is when I am doing a major load (import,sqlload,etc). After I am done loading data, I put them back into archive mode. What does it cost you, a few archives? Ha, well worth it :). GenePS. On a side note, Robert Freeman, your book is a must have using RMAN. Thanks for writing it! [EMAIL PROTECTED] 01/09/04 04:54PM My personal opinion is all production databases should be in archivelogmode. Period. End of story.Less down time, more recovery optionsit's all good.Having said that, given a specific business case, with a specific set ofrequirements, one could argue for noarchivelog mode, and you might evenconvince me...but I doubt it...;-)-MarkMark J. BobakOracle DBAProQuest CompanyAnn Arbor, MI"Imagination was given to man to compensate him for what he is not, anda sense of humor was provided to console him for what he is." --Unknown-Original Message-Sent: Friday, January 09, 2004 4:25 PMTo: Multiple recipients of list ORACLE-LHave a question on backups in a DW environment.Our DW is somewhat small at the moment but projectedto grow. I seem to be having a hard time trying toconvince the sys admin that I don't want archivelogging turned on. To me, it does'nt make much sense.He's proposed using EMC BCV's which I've agreed to(and also sounds like a good idea) but also wants toturn on archiving. My thinking is why turn onarchiving if I can restore my DB from last night'sBCV's and then bring it up to date by re-loading anydata that was loaded after the BCV split.Our system is not 24x7 so we can shutdown before theBCV split. Also, it's not directly accessed by usersfor ad-hoc queries. Automated processes access thedatabase and build cubes using Cognos tools. Usersaccess these and not the DB directly.So, again I don't see the need for archive logging.Any thoughts?mohammed__Do you Yahoo!?Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakeshttp://hotjobs.sweepstakes.yahoo.com/signingbonus-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: mkb 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bobak, Mark 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 removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Unix question
grep command will help you or you could venture to the sed command. grep is probably the most used unix command. To learn more, man grep . [EMAIL PROTECTED] 12/22/03 07:54AM Hallo all of you,Is there anyone whom could help me with the unix command how to find all rows , that doesnt exists "try" in a file.I mean how to find all rows which doesnt have the characters try in.Maybe this is too simple, but would appreciate anyone whom could give me some quick help.Thanks in advanceRoland-- 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.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).
Re: IMP using the same DMP file
On the subject of export/import, has anyone exported a 1 TB db and imported it into another db? The largest I have done is 300gb w/out problems. [EMAIL PROTECTED] 11/05/03 05:04PM You can import the same file into two instances simultaneously, because"imp" doesn't lock the import file, unless the import file was producedby simultaneous export into the same file from two different instances, in which case you have something what is scientifically known as "monster mess" and is really appropriate for the Halloween time.On 11/05/2003 04:49:36 PM, Whittle Jerome Contr NCI wrote: Hi, We were just wondering if you can IMP into two instances using the same dmp file at the same time? We need to refresh both our development and test instances with data from our production database and doing both at once might save some time. 8.1.7 and Unix. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 Mladen GogalaOracle DBANote: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.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).
Re: 8i Support
General support ends Dec 31, 2004, was Dec 31, 2003. [EMAIL PROTECTED] 10/28/03 03:44PM List,Is any body know when Oracle stop supporting for 8i?Thanks,Hamid AlaviOffice : 818-737-0526Cell phone : 818-416-5095-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hamid Alavi 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 removed from). You mayalso send the HELP command for other information (like subscribing).
Re: EMC Snapshot Technology
I don't use snapshots, but have used EMC BCV's in the past and now use IBM's Flashcopy for backups. I backup 1TB db in ~20 mins using Flashcopy. Then I take it off to tape, i.e. filesystems monted on a TSM Backup server, hence no resources needed from the production server :). hth, Gene [EMAIL PROTECTED] 10/08/03 09:39PM We are implementing Oracle RAC on two Windows nodes, connected to an EMCSAN. We'll also have a failover sight. We are using S.A.M.E. disk configuration, with only one logical volume,and backups/archivelogs dumping to another volume.The SAN is an EMC Clariion CX400. I immediately vetoed snapshots, opting for RMAN, but I'm now taking asecond look. Does anyone use the snapshot technology as a solution for full backups? Thanks,Jeff-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: jwiegand 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: A quick note
Lee - Interesting you were using IBM Flashcopy and you had problems. I am using FlashCopy v2 and have not seen any problems. Can you enlighten me what I should look out for? Thanks, Gene [EMAIL PROTECTED] 10/09/03 06:44AM At the risk of being dragged off and strung up (and keeping it brief as I amvery busy), I really thought it was quite good. Maybe it is the "change isas good as a rest" syndrome.Quite intuitive and fairly easy to get dramatic performance gains byparameter tweaking and runstats (equiv. of analyzing but takes up much lesstime). Quite good command line tools for index advising and explains etc.Was particularly impressed at how easy it was to set up EEE (equiv. ofParallel Server I suppose)Downside is there is very little out there book-wise (h, wonder if thereis a niche market there - DB2 for Oracle DBAs ??) and backups are potentialpitfalls. We have had several issues using Flash Copy on a Shark and thearchive logging is a bitch to set up.Just my 2p (bugger the Euro) worth.Lee-Original Message-Sent: 08 October 2003 22:45To: Multiple recipients of list ORACLE-LSo Lee... As an experienced Oracle guy, what are your thoughts about DB2?-Original Message-Sent: Wednesday, October 08, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LI suggest you buy your mushrooms from the supermarket like the rest of usinstead of picking them in those strange fields my friend-Original Message-Sent: 08 October 2003 17:25To: Multiple recipients of list ORACLE-LHey good to see you back again Lee.The big change here is that all Oracle knowledge has been cyber-engineeredinto an automoton called Tanel Poder.Any query to the list is routed by a big fast connection into a huge serverwith hundreds of CPU's and unlimited memoryAn almost instantaneous reply is automatically generated , often completewith complex examples and code cuts to demonstrate the point.The best part is that is that the machine is programmed to exibit almosthumanistic type responses (occasionally) John-Original Message-Robertson Lee - lerobeSent: 08 October 2003 11:34To: Multiple recipients of list ORACLE-LHi everyone,I'm back in the land of the living after spending a year on a DB2 EEEproject. I've just started working on a 9i RAC solution so the questionswill soon be flooding in. I will be lucky if I can even remember to spellspqlusl , I mean sqlplus :-)CheersLee**The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged.If the reader of this message is not the intendedrecipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictlyprohibited.If you have received this communication in error,please re-send this communication to the sender anddelete the original message or any copy of it from yourcomputer system. Thank You.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hallas, John, Tech Dev 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).-- Please see the official
RE: EMC Snapshot Technology
Tom - I can do either a cold or hot backup. It is all scripted. I prefer cold backups. IBM did try to sell us TDP for Oracle, get this, to open the db on the backup server to back it up using RMAN. The files on the backup server are just that files, no need for Oracle utilities to back them up. High Level Events of a Flash Copy Backup: - Backup Server exports volume group, umounts filesystems backed up. - Backup Server executes begin hot/cold backup script on remote production server. - Backup Server executes FlashCopy Establish Tasks. - Backup Server executes end hot/cold backup script on remote production server. - Backup Server recreates volume group, mounts filesystems. - Backup Server backs up filesystems to tape. Advantages: - Online Backup of Production DB on Backup Server. - Datafiles can used for partial restore or FlashCopy Reverse can be used for full restore. - Copy of Production DB can be used for testing, data warehouse, web purposes. - Resources used for VLDB is on Backup Server not Production DB Server. hth, Gene P.S. If you need more details, feel free to call me. "Mercadante, Thomas F" [EMAIL PROTECTED] 10/09/03 08:08AM Gene, What happens when you need to perform a recovery from the Flashcopy backup? Is Flashcopy done while the database is open or closed? If the database is open, then I assume that you would need to perform an incomplete recovery? Just curious. I am in the middle of setting up new IBM/AIX boxes, and we will using either EMC or IBM Shark disk. Flashcopy was mentioned as a possible solution for backups. But I don't like being boxed in to performing an incomplete recovery. Tom Mercadante Oracle Certified Professional -Original Message-From: Gene Sais [mailto:[EMAIL PROTECTED]Sent: Thursday, October 09, 2003 8:35 AMTo: Multiple recipients of list ORACLE-LSubject: Re: EMC Snapshot Technology I don't use snapshots, but have used EMC BCV's in the past and now use IBM's Flashcopy for backups. I backup 1TB db in ~20 mins using Flashcopy. Then I take it off to tape, i.e. filesystems monted on a TSM Backup server, hence no resources needed from the production server :). hth, Gene [EMAIL PROTECTED] 10/08/03 09:39PM We are implementing Oracle RAC on two Windows nodes, connected to an EMCSAN. We'll also have a failover sight. We are using S.A.M.E. disk configuration, with only one logical volume,and backups/archivelogs dumping to another volume.The SAN is an EMC Clariion CX400. I immediately vetoed snapshots, opting for RMAN, but I'm now taking asecond look. Does anyone use the snapshot technology as a solution for full backups? Thanks,Jeff-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: jwiegand 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Locally managed System Tablespace
Personally I agree w/ Dennis, If it works, don't mess w/ it. I am moving to LMT Undo TBS when I upgrade to 9i from 8i. Gene [EMAIL PROTECTED] 10/07/03 10:29AM Thomas To me, the main benefits are in manageability. I feel in mostcircumstances the performance benefits will be small. As an approach, I have created all new tables in LMT with uniform extentsover the last several years. I have moved tables that grow steadily to LMT.I have left a lot of older, static tables in dictionary-managed for the timebeing, but overall that is probably under 5% of the storage. My theory isdon't mess with stuff that works.Dennis WilliamsDBA, 80%OCP, 100% DBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Monday, October 06, 2003 6:09 PMTo: Multiple recipients of list ORACLE-LIs it really worth the effort to convert dictionary-managed systemtablespaces to locally-managed in 9.2? Ostensibly, I should see some performanceimprovements due to less recursive sql, etc; but from Googling/Metalink in looking for moreinfo, it doesn't appear as though many sites have bothered to convert.The process is like this:a) Convert all dictionary-managed to LMTs.b) - cold backup - DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL - another cold backupSeems as though it might be better to wait until 10G when I assume Oraclewill convert to LMT as part of the migration process; unless anyone can offer somecompelling reasons?Jeffery D ThomasDBAThomson Information ServicesThomson, Inc.Email: [EMAIL PROTECTED]Indy DBA Master Documentation available at:http://gkmqp.tce.com/tis_dba-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Thomas Jeff 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 removed from). You mayalso 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.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).
RE: Off Topic: PC Firewall Recommendation
I second that https://grc.com website. It is a great resource for testing your vulnerabilities! [EMAIL PROTECTED] 09/30/03 06:54PM Whatever you use go to https://grc.com/x/ne.dll?bh0bkyd2 and http://grc.com/lt/leaktest.htm for testing your firewall product and make sure that the basic stuff is configured correctly.Also want to check out the URL http://grc.com/lt/scoreboard.htm about various PC firewall products "leaking" and possible issues which certain versions.-f-Original Message-Sent: Tuesday, September 30, 2003 3:10 PMTo: Multiple recipients of list ORACLE-L-- snip If you're feeling frisky, consider replacing the router/firewall with a PC(with 2 nics) running BSD or Linux. You can also find distros tweaked toact as a firewall/router - that's what I've done.-- snip The Linux distro I used was www.smoothwall.com (which is the similar towww.ipcop.com ) and I found that it worked very well. even on a sub 100MHzPC with 16MB RAM. Of course I had to load a customized module for IPSecbypass to allow me to connect to work using a Cisco VPN client.-Original Message-Sent: Monday, September 29, 2003 1:05 PMTo: Multiple recipients of list ORACLE-LKENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 29, 2003 9:05AM said; I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XPhas a firewall but it is not the greatest.ZoneAlarm on the desktop - free version or pay to upgrade to the proversion.Assuming you have a home network, you also want to buy a DSL/Cable router -which has it's own firewall built in.If you're feeling frisky, consider replacing the router/firewall with a PC(with 2 nics) running BSD or Linux. You can also find distros tweaked toact as a firewall/router - that's what I've done.FWIW, a friend of mine had his XP system plugged directly into his RRconnection. Friend said he didn't need a firewall or router (I'm not intothat security crap, I just want to play games). Friend has now had toreformat his box (and lost work) because his box was rooted, blasted andfubared within days of hooking it to the cable connection w/out a firewall.YMMV.~brian-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Brian Dunbar 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Suri, Deepak 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Faan DeSwardt 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Re[2]: DBA needed in Austin, TX
The Mongolian Wok here in West Palm Beach went out of business, probably b/c Palm Beach County residents can't decide what ingredients to pick :). One thing about Texas, is that they have the highest homeowners insurance fees in the country. They get their share of All of nature's disasters. However, this would not stop me from moving to Texas, as long as I never have to move back to NY :). Gene [EMAIL PROTECTED] 09/26/03 12:49PM What is so special about htat Mongolloid BBQ?--Mladen GogalaOracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Gennick Sent: Friday, September 26, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: Re[2]: DBA needed in Austin, TX Friday, September 26, 2003, 11:49:40 AM, you wrote: Jaite Raj, Jaite It's "Mongolian Barbeque" and still there. Now there's even a Jaite "Mongolian BBQ North". It's a chain. They're in Lansing, Michigan too. I remember them being a bit different in that you went around and collected a dish of raw meat, or other stuff besides meat, and they cooked it for you while you watched. 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 onearticle on Oracle technologies per month by email. To join, visithttp://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.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 in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).Note:This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen Gogala INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).
RE: URGENT REPORTS
What I like about VNC, is that all you need for a client is a browser. http://ip.address:5800 gets you a nice java client connection. Gene [EMAIL PROTECTED] 09/24/03 06:14PM If y'all do choose a VNC route, I'd highly recommend the free and GPL'dTightVNC from http://www.tightvnc.com/Better compression, better security, and better performance then otherRFB-compliant VNC flavors.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Wednesday, September 24, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSetting up vnc server and directing DISPLAY to that is easier, I think. Ihave a Apps reports server setup which has run for few years for now withvnc server.Tanel.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, Rich INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).
Re: ADMIN: Warning about virus threats this week
I think its a GREAT IDEA! Thank you for maintaining this list and keeping it virus free, well almost :). Other lists, I belong to are slamming me w/ the SOBig virus. Gene [EMAIL PROTECTED] 08/22/03 03:39PM Hello everyone --As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists.In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you.What this means to you is that unless you've sent a properly formatted request or command to ListGuru, you now will NOT get a response. If you are a subscriber to a list and you try to post, but your posting address has changed, you will NOT be told that your address needs changed. Etc. Instead, auto-responses like these will be thrown away and your messages, effectively, ignored. I know this sounds rather "rude" ;-), but I assure you, the intent is not to be rude at all -- it is to reduce the amount of E-mail traffic being sent to the net by these viruses.I apologize in advance if this causes any problems or confusion for anyone. If you have any questions or concerns about whether your mail was received okay here or your subscription is working, please contact me directly. I expect that these measures will be needed for the next few weeks, but after that I will return ListGuru's functionality to normal. Please bear with us during the intervening weeks.Thank you!Bruce A. BergmanListMaster, Fat City Hosting-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bruce A. Bergman 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 removed from). You mayalso send the HELP command for other information (like subscribing).
Opinions on Oracle InterConnect
We have a new project kicking off and the vendor plans on implementing Oracle InterConnectfor Oracle Application Interfaces. Has anyone used this product? Are there other similar products out there? I have been told Oracle InterConnect is free. Will it work Asyncronously? Thanks for any insight on this product. Gene
RE: Veritas like RMAN?
Rachel - I am confused, now mind you it doesn't take much :).Can you clarify on a statement you made? Oracle will not support hot backups unless done w/ RMAD? I currently do hot backups w/ scripts using IBM's flashcopy. Is the Oracle Tablespace hot backup mode no longer supported? Thanks,Gene [EMAIL PROTECTED] 07/23/03 03:04PM Michael But you do have a good reason why the client should hire you. ;-)Dennis WilliamsDBA, 80%OCP, 100% DBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, July 23, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LI was afraid of that--Performing Remote Agent backupMedia Name: "Media created 7/18/2003 08:00:06 PM"Backup of "\\FAILSAFE\V$ "Backup set #11 on storage media #1Backup set description: "DailyBackup"Backup Type: FULL - Back Up Files - Reset Archive BitBackup started on 7/19/2003 at 12:59:44 AM.Backup completed on 7/19/2003 at 1:11:05 AM.Backed up 31 files in 4 directories.Processed 5,785,060,909 bytes in 11 minutes and 21 seconds.Throughput rate: 486.1 MB/min--This doesn't give me a "warm" feeling. Alert log shows NOTHING.This is a manufacturing site where the click of a bar codereader is moving materials from one location to another andthat may or may not occur at any time. I'm not positive thatone could say that this would never happen. Every time I'vebeen in there looking around random jobs are coming intodbms_jobs in what appears to be all hours of the night.They have an export, but I think that's it. If they takea backup on Sunday, I think everything is shutdown. ItMIGHT be good if the moon is right.Maks.-Original Message-Rachel CarmichaelSent: Wednesday, July 23, 2003 12:59 PMTo: Multiple recipients of list ORACLE-Lyou don't have backups. Oracle will only support recovery from hotbackups taken when the tablespaces are not flagged as in backup mode ifyou do the backup via RMAN.Technically, if you are very very lucky, the moon is in the seventhhouse and Jupiter has aligned with Mars, you *MIGHT* be able to use thehot backup taken without RMAN. If and only if there is absolutely NOactivity whatsoever in the database from the time the backup startsuntil when it finishes. Even then, recovery is still not supported.--- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing "hot" backups using Veritas... HOWEVER, the alert log shows no signs what so ever of "alter tablespace xyz begin/end backup"... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwarehttp://sitebuilder.yahoo.com-- 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.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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Michael Kline 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 removed from). You mayalso 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.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
RE: Veritas like RMAN?
Thanks for the clarification.You got me nervous :) [EMAIL PROTECTED] 07/23/03 04:09PM that's not quite what I said.I said Oracle will not support hot backups done without putting thetablespace into "backup mode" unless that hot backup is done with RMAN.at least that's what I thought I was saying.you can still do the good old-fashioned "alter tablespace beginbackup"/backup the datafiles/"alter tablespace end backup" sort of hotbackupor you can use RMAN and not have to do the begin/end backup--- Gene Sais [EMAIL PROTECTED] wrote: Rachel - I am confused, now mind you it doesn't take much :). Can you clarify on a statement you made? Oracle will not support hot backups unless done w/ RMAD? I currently do hot backups w/ scripts using IBM's flashcopy. Is the Oracle Tablespace hot backup mode no longer supported? Thanks, Gene [EMAIL PROTECTED] 07/23/03 03:04PM Michael But you do have a good reason why the client should hire you. ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L I was afraid of that -- Performing Remote Agent backup Media Name: "Media created 7/18/2003 08:00:06 PM" Backup of "\\FAILSAFE\V$ " Backup set #11 on storage media #1 Backup set description: "DailyBackup" Backup Type: FULL - Back Up Files - Reset Archive Bit Backup started on 7/19/2003 at 12:59:44 AM. Backup completed on 7/19/2003 at 1:11:05 AM. Backed up 31 files in 4 directories. Processed 5,785,060,909 bytes in 11 minutes and 21 seconds. Throughput rate: 486.1 MB/min-- This doesn't give me a "warm" feeling. Alert log shows NOTHING. This is a manufacturing site where the click of a bar code reader is moving materials from one location to another and that may or may not occur at any time. I'm not positive that one could say that this would never happen. Every time I've been in there looking around random jobs are coming into dbms_jobs in what appears to be all hours of the night. They have an export, but I think that's it. If they take a backup on Sunday, I think everything is shutdown. It MIGHT be good if the moon is right. Maks. -Original Message- Rachel Carmichael Sent: Wednesday, July 23, 2003 12:59 PM To: Multiple recipients of list ORACLE-L you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if you do the backup via RMAN. Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form...I've been told they are doing "hot" backups using Veritas... HOWEVER, the alert log shows no signs what so ever of "alter tablespace xyz begin/end backup"... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place.Is Veritas capable of this? If so, why is there a Veritas interface to RMAN???Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Michael Kline 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 mai
RE: Physical Design Question
I do the same. One OH for each version. Listener uses the latest OH. Databases set env script for OH required. Simple and it works. I couldn't imagine having 14 OH's for14 8i databases onone server :). Now if I were running on Windows then I would have one db per server hence one OH. Its all relative, do what you like! Gene [EMAIL PROTECTED] 07/18/03 09:19AM Ray, Boy are you ever. In our location every version gets an Oracle_Home. Databases that share the same version share the same home. BTW: Oracle Support recommends using the listener for the highest version installed. I do that it works very darn well, unless your into extproc's. Then you should have an extproc listener for each version installed.Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-Sent: Thursday, July 17, 2003 7:29 PMTo: Multiple recipients of list ORACLE-Lmy 2cents...Every instance get it's own oracle home, user id and group id. Total isolation and separation. Itmakes our auditors happy too!Then again, I may be an extremist...Ron ThomasHypercom, Inc[EMAIL PROTECTED]Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Physical Design Question .com 07/17/2003 05:14 PM Please respond to ORACLE-L Well, since nobody else has jumped on this...-Original Message- Here's my situation: 1. Should I use a separate Oracle Home for each DB?Not unless you have some peculiar situation there. Use separate ORACLE_HOMEfor each version of Oracle but not each database. Pros: --Allows upgrade/patching of 1 DB at a time without affecting others (some are home-grown, some are 3rd party).The separate ORACLE_HOME for each version takes care of this. You justchange the ORACLE_HOME in the oratab when you upgrade the database. If youuse environment setting scripts, have them grab the correct ORACLE_HOME fromthe oratab.something like:export ORACLE_HOME=`/usr/bin/nawk -F: '$1 == SID {print $2}'SID="$ORACLE_SID" "$ORATAB"`where ORATAB is the path to your oratab file.Sorry, I got no opinions on your storage arrangement.--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.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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ron Thomas 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- 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.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).
RE: how to schedule a job every alternate sundays in unix cron
lol, actually makes sense :). wondering how the perl version would look like?Gene [EMAIL PROTECTED] 07/17/03 02:49PM what a freekin nightmare! I'd hate to be the next poor bloke who has todecifer this...Tom MercadanteOracle Certified Professional-Original Message-Sent: Thursday, July 17, 2003 2:35 PMTo: Multiple recipients of list ORACLE-LBrilliant. :)[EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]07/16/2003 11:29 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: how to schedule a job every alternate sundays inunix cron0 1 * * 0 /usr/bin/ksh -c "[ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \%2)) -eq 0 ] /path/myscript.ksh"This will run myscript.ksh on even Sundays at 1 a.m.If ?'s, email me direct. kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: how to schedule a job every alternate sundays in unix cron Sent by: [EMAIL PROTECTED] .com 07/16/2003 06:09 AM Please respond to ORACLE-L Hello All,OS: Solaris 2.8I have to run a backup script in every alternateSunday.I cant find a way to submit it in cron.Can somebody help me how to setup a job to runalternate Sundays in unix cron .Thanks and Regards,Srinivas__Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!http://sbc.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: kommareddy sreenivasa 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 removed from). You mayalso 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.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).-- 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.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).-- 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.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).
RE: Do Not Call
http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov Well, if it were unix then it couldn't be SQLserver. It is Windows, therefore I assume its SQLserver, but it could be Oracle. But who runs Oracle on Windows anyway *hahahaha* [EMAIL PROTECTED] 07/01/03 02:29PM 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).
RE: Oracle Names
When using names, always have more than one nameserver and add these 2 lines to sqlnet.ora. It sure helps when one fails. Been there :) NAMES.INITIAL_RETRY_TIMEOUT = 5#Wait num seconds before going to next nameserver,def=15 NAMES.REQUEST_RETRIES = 2 #Number of retries for nameserver,def=5 Gene [EMAIL PROTECTED] 06/12/03 03:42PM Re pushing the tnsnames.ora out to desktops:I considered that, but there were too many versions of it out there, and the users may have ODBC DSN' s dependent on the contentsof their tnsnames.ora.Re the share drive: Considered that too, but it's too easy fornet admins to re-arrange drives without advance warning.( it has happened )I compromised. The tnsnames.ora stays on the desktops.The sqlnet.ora has this line:NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES)so that their tnsnames will still work, but I can make changesin the name servers without worrying about their tnsnames files.Updating the names servers is pretty simple, and I don't haveto schedule a change to all the desktops.Works for me anyway.JaredStephen Lee [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]06/12/2003 12:01 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Oracle NamesI never liked names, but that's just me. I thought keeping the namesservers up to date, and making sure every client was configured to use thename servers, was a pain in the butt. You can have multiple names serversto eliminate a single point of failure.The method I liked the best was to have the PC admin people push a newtnsnames.ora out to client machines using push software. Let THEM fuss withit!Another method that works is to have the tnsnames.ora on a share and stick ashortcut on the client desktop that will update the local tnsnames.ora whenthe user clicks on it. -Original Message- 1. Are any of you using the Oracle Names? 2. Is it as easy to configure as Oracle makes it sound, or is it difficult? 3. Is Names reasonably robust? I can see this as yet another single point of failure.-- 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.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).-- 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.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).
Re: RMAN framework scripts, etc
test - is the list still working? [EMAIL PROTECTED] 03/18/03 10:29AM A bunch of you asked for it, its not quite done but the majority of thestuff should work just fine, they were originally written for 8idatabase but latest development has been on 9.2.0.3, although I've triedto NOT use any 9i specific stuff in them.yes they are free and you can use to your hearts content just pleasegive credit where credit is due(like on the license agreement).just like what you paid for it, is how much its worth. You get what youpay for, there is no guarantee whatsoever, if you blow up your databaseduring a restore test, I'm not responsible.That being said: the .zip file(its got a password on it, which I'lltell you in a minute), is located(there is zip available for most if notall unix platforms as well as windoze). If you don't have access to zipon either platform, send an email to the [EMAIL PROTECTED]and when i have time i'll send you a non-key version(once this is readyfor prime-time, the "production" version will not have a key).http://www.oracle-dba.com/rman_betaits the only file in that directory. These scripts were all written forunix(mostly aix and linux) but should be portably to any *nix. They have NOT been tested to run in windows via mkstoolkit or cygwin. If someone wants to take that task on, let me know.This will be the only time the key for the file will be sent in anemail, after since the code is open and in the free domain(but I needsome control over it while still in development mode),the key is: d42x21I hope to have a new build every 2 weeks or so and the key can always berequested by sending an email to [EMAIL PROTECTED] .You'll see that there is some "menu" framework started and its includedbut is far from finished.Any questions feel free to email me here [EMAIL PROTECTED] or[EMAIL PROTECTED]Joe, happy backups and restores :)Joseph S TestaChief Technology OfficerData Management Consultingp: 614-791-9000f: 614-791-9001-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Joseph S Testa 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 removed from). You mayalso send the HELP command for other information (like subscribing).
Test - Delete me
Re:File Restoration/Recovery
Now, you could put the tablespaces in read only mode, then the copy would work. But then again, could you put all the tablespaces in read only mode ? h, don't think so :). [EMAIL PROTECTED] 03/14/03 11:54AM Gary, Only if 1) The database is shutdown prior to the copy of the datafiles, andeverything else that compromises the database (online redo, control files,etc...) or 2) the effected tablespaces are put into hot backup mode before thecopy, in which case when you restore the files Oracle will ask for the archiveredo to roll them forward to the rest of the database. As far as "returning theskeleton database based on these files" he's smoking something good!! What Ibelieve he's more likely asking for is a schema export.Dick GouletReply SeparatorAuthor: Gary Chambers [EMAIL PROTECTED]Date: 3/14/2003 7:44 AMAll...A developer working on a Solaris 2.6 server running Oracle 7.3.4 desiresa nightly backup (by simply copying them to a backup directory) of thedatafiles of an active instance. I explain that it will be a waste oftape because the files will be corrupt and useless. He counters, "Aslong as these files are there, irrespective of their state, oracle [sic]provides the tools to restore the skeleton database based on thesefiles."Will this be the case? I understand that there will [most likely] besome loss of data, but will Oracle "fix" itself to a point where it'suseful again? TIAGary Chambers//--// Lucent Technologies ITO/Servers/Unix// Senior Unix System Administrator// 4 Robbins Road, Westford, MA 01886// 978-399-0481 / 888-480-6924 (Pager)// Nothing fancy and nothing Microsoft// Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Gary Chambers 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 removed from). You mayalso 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.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).
RE: TAR and Linux info
Ron - also ff 1 at a time to find a good file. some pgms put an extra eof or eot depending on pgm used. Just a thought. [EMAIL PROTECTED] 03/12/03 03:14PM It might be a tape problem, but I think it is unusual for a tape to be thishosed without errors being generated when the backup was created. If it isknown that a backup was created without errors on this tape, and the tapehas not been mishandled since then, then my first question would be: At whatdensity was the tape created, and are you reading from the tape at thatdensity?When you finally get to the point that you can locate the "files" on thetape, then other questions come up, such as:Was the tape actually written in tar format?Are additional parameters required, such as blocksize, etc.? -Original Message- Thanks for the response. I did locate the "mt" command and tried to advance to tape to the 5 file count and I received Input/Output errors anf the operation stopped. I guess the tape is shot and I will have to recreate the datafile and tablespace. Thanks to all. Ron-- 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.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).-- 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.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).
Re: Database vs File System
If you have millions of documents it may be better to have them stored in the db. If you have terabytes of documents that are pretty much static/read-only then you may want to have a separate db for the images and one for your data. [EMAIL PROTECTED] 03/11/03 04:58AM We have got a requirement to keep all the documents on repository. We arelooking on the possibility of keeping documents on Database or filesysytem. Could you please let me know your views which one I should go for.Regards,Dhanvir This email and any attached to it are confidential and intended only for theindividual or entity to which it is addressed. If you are not the intended recipient,please let us know by telephoning or emailing the sender. You should also delete the email andany attachment from your systems and should not copy the email or any attachment ordisclose their content to any other person or entity. The views expressed here are not necessarilythose of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426.England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR11DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Rathi Dhanvir 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: POLL: Database to DBA ratio
27 databases to 1 dba, mixed dev, test, and prod. [EMAIL PROTECTED] 03/11/03 11:29AM 3:1 Production, Development, my personal test DB : MeCraig Healey -Original Message- href="">mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:59 To: Multiple recipients of list ORACLE-L build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. **This email and any files transmitted with it are confidential and intended solelyfor the use of the individual or entity to whom they are addressed and may containconfidential and/or privileged material. Any review, retransmission, disseminationor other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statementsand opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeperfor the presence of computer viruses (www.mimesweeper.com)***-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Craig Healey 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Upgrade to AIX 5.2
So it appears that Oracle 8.1.7 databases and 9.2 databases can not co-exist on the same server, i.e. AIX 4.3.3 32 bit. If this is the case, then all databases on the server must be upgraded at the same time? Current Env: AIX 4.3.3 32 bit Oracle 8.1.7 Proposed Env: AIX 5.2 64 bit Oracle 9.2 Plan to get there: - Boot AIX 4.3.3 server to 64 bit - Install Oracle 9.2 64 bit Patch for AIX 4.3.3 - Change env scripts to point to Oracle 9.2 - Migrate/upgrade all databases from 8.1.7 to 9.2 - Upgrade AIX to 5.2 - Install Oracle 9.2 64 bit binaries Then there is the alternate plan: - Free up a server - Upgrade AIX 4.3.3 to 5.2 64 bit on this new server - Install Oracle 9.2 64 bit - Export 8.1.7 database and import to new 9.2 database - Continue this process on a per database basis, no rush to do all databases on server Any thoughts, experiences, opinions are appreciated. Thanks, Gene [EMAIL PROTECTED] 02/27/03 03:19PM Tracy,We are still debating this issue with our preferred App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, as *none* of the new features of 9i would be used by the Vendor. Sad but true. There will be more testing time allocated to 9i/AIX 5L update, as several other software pieces would be tested for the first time with that combination. We will need to install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet. If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L, this would have been a bit simpler... Regards,- Kirti -Original Message-Sent: Thursday, February 27, 2003 1:36 PMTo: Multiple recipients of list ORACLE-LJohn/Kirti,We are in the same boat with you. However, we were looking to first upgrade toAIX 5L first and leave our existing 8.1.7 32-bit databases (booting the serverin 32 bit mode). In a subsequent phase we would upgrade 8.1.7 32-bit to 9.264-bit. The downside to this is that it will affect all databases on theserver. We would need to test the complexity/timing/risk to determine if thisis the appropriate choice. Kirti, with the option that you are leaningtowards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L(there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3to 9.2/5L. Do you know what effort is involved in that transition? Is itcomplex/time consuming or just pointing to a new oracle_home? Thanks 02/27/2003 05:43 AM PSTPlease respond to [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]cc:It appears that way. We are also pondering on this upgrade as well.But if one takes this route, that is, running 5L in 32-bit mode, one can notinstall 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX5L. It is not planned to be available, either.So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OSto AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 laterthis year)..- Kirti-Original Message-Sent: Thursday, February 27, 2003 7:09 AMTo: Multiple recipients of list ORACLE-LSo 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode???John-Original Message-Sent: 27 February 2003 12:24To: Multiple recipients of list ORACLE-LCertify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7(8i) On IBM AIX -Based SystemsOperating System: IBM AIX -Based Systems Version 5.2 (5L)Oracle Server - Enterprise Edition Version 8.1.7 (8i)N/A Version N/AStatus: CertifiedProduct Version Note:Terminal Oracle8i releaseTo obtain Patch Sets from MetaLink, click the "Patches" button to the left.Certification Note:Existing patch sets: 8.1.7.1.0 (without JDBC), 8.1.7.1.0b (includes JAVAVM, Context and JDBC), 8.1.7.2.0 8.1.7.3.0 8.1.7.4.0Oracle 8i 32-bit on AIX 5L (5.1 5.2)Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bitmode. This mode is not supported, as Oracle 8i uses at least one 32-bitkernel extension. AIX-based systems must be booted with kernels in 32-bitmode.Warning about missing "crash" during installation of Oracle 8i.The error message "crash: not found" may appear during execution ofrootpre.sh on AIX 5L. This warning may be ignored. Alternatively, thewarning can be avoided by creating the following script and renaming it to"/usr/sbin/crash":#!/bin/kshread inputif [ X"$input" = Xle ]; thenecho lke | /usr/sbin/kdb | \/usr/bin/awk '/^ *[0-9]+/ {printf("LoadList entry at 0x%s\n Name:%s\n\n",$2,$6)}fiApril WellsOracle DBAGreat spirits have always encountered violent opposition from mediocre minds-- Albert Einstein-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Tracy Rahmlow
Re: How to load pictures/documents in oracle
I don't have much experience developing applications using blobs but here is a link to help get you started. http://developer.iplanet.com/appserver/samples/database/docs/blob.html Gene [EMAIL PROTECTED] 02/28/03 10:04AM Hi,I have never had to insert pictures/documents in the oracle database beforeand would like to give it a go. Does anybody have some scripts that I cantear apart to look at how to do it (examples I find more usefull thanbooks). I tried finding useful info on the net but did not find any concreteanswers.TIAJackJacob A. van ZanenOracle DBAQuant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED]Visit our web site at http://www.quantsystems.nl/-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jack van Zanen INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).
RE: IOUG setting up
Paula - Not sure what part of Florida you are from, but here is the link for South Florida's OUG http://www.sfoug.org/SFOUG.jsp Gene [EMAIL PROTECTED] 02/27/03 01:11PM Paula, I just did a search at ioug.org and it looks like there are 5 OracleUser Groups in FL. (Guessing based on your e-mail address :) It wouldbe much easier to get involved with one of those that starting a new onethat would be competing for members and vendor support.Take a look at ioug.org. Click User Group from the left side of the screen. Click Local/Region Contact Information. Choose FL from the State drop-down box and click Search from the greenbar towards the top of the page. Try to get ahold of someone on that list from the closest group to youand see when they meet. If you would like to get involved, I know thatmany user groups value volunteers to help put on events (sign in sheet,greeter, snack coordinator, etc.) Better yet, prepare a presentation("What I needed to forget about tuning once I got my Cert").Good luckStephen AndertPresident, AZORA [EMAIL PROTECTED] 02/27/03 09:49AM Guys,I wish to setup an IOUG group in my city. I wish to do this so I canbringin some of the more relevant training available for Oracle DBA's inthisarea - Mogens, Cary, Robert, etc. Any advice on the best way to dothisfrom folks who have - quickest way to get it up and running, generateinterest, arrange speakers, funding. Perhaps working with localvendor?-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephen Andert 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: shared tnsnames.ora
If you are not going to use Onames, another consideration is to create an DNS alias for your db server host and use the alias in the tnsnames file for host value. It makes it easy to the move database to another server and make 1 change to DNS. On the listener side, I always use localhost for host value.hth, Gene [EMAIL PROTECTED] 02/27/03 03:49PM Below is the end of my own tnsnames.ora located on my PC. There is a commonnetwork tnsnames.ora on a network share located on my 'R' drive. Thenetwork version has all the permanent databases defined in it. I can addany temporary or new test servers to my copy of tnsnames.ora and still getto all the permanent entries when ever I need to. Works great!R. Smithtest.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = someserver) (Port = 1521) ) ) (CONNECT_DATA = (SID=test) ) )ifile=r:\tnsnames.ora-Original Message-Sent: Thursday, February 27, 2003 2:24 PMTo: Multiple recipients of list ORACLE-LUse Oracle Names. Easy to setup/maintain. never touch a client configagain.Ron ThomasHypercom, Inc[EMAIL PROTECTED]Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ine.com To:[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: shared tnsnames.ora 02/27/2003 12:56 PM Please respond to ORACLE-LI am looking for info on how you support a large number of PCs (200+) andkeep each ones tnsnames.ora file in sync. It seems that most people do nottouch them. Some try to modify them and when new databases are created, thetnsnames.ora files must be changes as well. It seems to bethat a shared tnsnames.ora file on a network drive may work. I remember athread awhile back aboutthe order of resolution (home directory, then OH/network/admin .).Again, I am asking aboutpeople using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x)on 10+ differentservers. I have just started to think about this and posted here before Istarted my MetaLinksearch.TIA for any info.JFJohn Fedock"K" Line America, Inc.www.kline.com( 804.327.* [EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ron Thomas 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 in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).If you are not the intended recipient of this e-mail message, any use,distribution or copying of the message is prohibited. Please let me knowimmediately by return e-mail if you have received this message by mistake,then delete the e-mail message. Thank you.-- 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.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).
Re: AIX question
Everything in IBM land is 'ls...' something. I think lscfg should give you more info, not sure of all the switches. Gene [EMAIL PROTECTED] 02/21/03 12:19PM AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa 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: AIX question
Lisa - If you don't get enough email, you can also subscribe to the AIX listserv :). [EMAIL PROTECTED] Gene -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: AIX question AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa 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 Names Server 8.1.7 on HP 11
You may also want to add these 2 parameters to your sqlnet.ora. Speeds up the switch to another nameserver. NAMES.INITIAL_RETRY_TIMEOUT = 5# Wait num seconds before going to next nameserver, default=15NAMES.REQUEST_RETRIES = 2# Number of retries for nameserver, default=5 Gene [EMAIL PROTECTED] 02/20/03 12:19PM We've currently got Names Server running on 4 host boxes. If one Names server is down, the client is configured to automatically attempt to connect to the next one in the list. We had a problem recently were, if we issued a tnsping from any of the clients we got the following message. TNS-03505 – Failed to resolve name This implies that our client PC is unable to resolve the name and hence was not able to connect to the database. Usually this implies that something is wrong with all our Oracle Names servers. Inorder to resolve this problem, I had to kill the Names Server on each of the 4 boxes and restart it. The Names servers had somehow lost connection to the Oracle Names repository database, although the servers appear to be attached to the database. I reckon we canreduce the chances of this problem occuring again, by adding a second Oracle Names database repository in our database cluster. This means, that if the NAMES servers lose connection to one repository, they can fall back on the second database without any loss of service. What have other people done with their Names Server and respository and do they see any draw backs with the above. Sorry for the long email. TIA With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
RMAN BCV/Flashcopy Question?
I plan on using a product from IBM called Flashcopy, similar to EMC's BCV (third mirror). Typically, I put the tablespaces in hot backup via scripting before splitting the third mirror. How can RMAN be used in a similar fashion? Can RMAN put the db in a hot backup state so the third mirror can be split and then backed up to tape? Thanks, Gene
Re: Oracle 8i or 9i ?
Not to depress you, but at this time, in Florida the DBA job market is dismal. The best way to move into a DBA job would be do it within your current organization, i.e. move from developer/sys admin/etc. to DBA. It would be difficult for an organization to hire a newbie DBA from the outsidewith full confidencemanaging their databases. I would guess most DBAs got their 1st DBA job within the organization they were already in. Good luck, Gene [EMAIL PROTECTED] 02/14/03 10:23AM Hello, I'm thinking of going to school to get Oracle certified. There are 2 schools in my area that are offering Oracle certs but one offers Oracle 8i courses w/ an upgrade to 9i, while the other offers all 9i courses. If i go to the schools who offers 9i courses, would I miss out on valuable 8i knowledge? Whichschool should I attend?The courses will last about 7 or 8 months. Also,is this a good "in demand" field to get into?What chances am I looking at togetting hired as a newbieDBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!!
RE: RMAN BCV/Flashcopy Question?
Thanks Dennis for your suggestions. So it appears in my environment, I am best off sticking w/ my trusty hot backup scripts. Using RMAN for 3rd mirror splits doesn't appear to benefit me. Using RMAN to backup to a 3rd mirror would be less efficient than using EMC BCV or IBM Flashcopy, as these services are done internally, not at the os level. [EMAIL PROTECTED] 02/14/03 11:44AM Gene - Hopefully someone will have better ideas than these, but I'll make acouple of suggestions. RMAN can issue SQL commands to your target database, so you could tryhaving it issue the alter tablespace command. Then after you do the backupyou could register the backup with RMAN. Almost more effort than it isworth. You might also consider using that extra disk space on the mirror as abackup site for RMAN -- backup to disk then move to tape. You could comparethe various recovery scenarios and decide if this would enable you torecover faster than a hot backup.Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Friday, February 14, 2003 9:59 AMTo: Multiple recipients of list ORACLE-LI plan on using a product from IBM called Flashcopy, similar to EMC's BCV(third mirror). Typically, I put the tablespaces in hot backup viascripting before splitting the third mirror. How can RMAN be used in asimilar fashion? Can RMAN put the db in a hot backup state so the thirdmirror can be split and then backed up to tape?Thanks,Gene-- 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.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).
RE: Backup and Recovery
Sony - I suggest you take the Oracle Backup/Recovery course. [EMAIL PROTECTED] 02/10/03 08:28PM Hi Ruth,In my company we run export for our daily backup. Why is it not best way todo backup ? and about RMAN, is it third party program on oracle or it isalready include in oracle, or if it is a script, would you share it to me ?I use oracle 9i on windows 2000 server.TIA,Sony -Original Message- From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 9:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Backup and Recovery Export is not the best way to do backup. Have a look at rman, it comes with the rdbms. Ruth - Original Message - From: Santosh Varma mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, February 10, 2003 6:43 AM Subject: Backup and Recovery Hello list, I am implementing a software in Oracle 8.1.7. The client wants to have the backup and recovery procedure. As of now, they are using EXPORT utility. Could any one of you tell me any other utility which the client will be able to use for Backup of their data ? Thanks and Regards, Santosh Varma -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Sony kristanto 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 removed from). You mayalso send the HELP command for other information (like subscribing).
Re: multiple oracle homes
Ray - I have always used #2 and never had a problem. I do set Oracle_Base Oracle_Home to different values for each version. e.g. /oracle1/dbserver/7.3.4 /oracle1/dbserver/8.1.7 /oracle1/appserver/1.0.2 ... hth, Gene P.S. The root directory is different on all my servers to support HA, i.e. oracle1 is on node 1, oracle2 on node 2, This allows me to have a failover and still have the primary secondary mount points available. [EMAIL PROTECTED] 02/07/03 09:23AM On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems likethere are two different approaches on the surface:1. use two different userids, ora817 and ora920, to do the install. Thisseems stupid, since it replicates the product directory structure andoraInventory stuff under different ownership. This might be safer sinceit is like running one version in that everything is seperate, butmaybe there are operational issues to not using the oracle userid.Seems like there may be a gotcha waiting in the wings. Like maybe youcan't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environmentvars as needed. Seems like you could damage the first install if youmade a mistake. Also, it seems like in a stressful failure situationyou don't want to have to think about who's on first? I don't know, third base.Are both paths valid? ===Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ray Stell 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Skipping a table on import
Another thought, move the table to a different (new) schema, create synonym and privileges required, then export user=original schema(s), then do your import. Gene [EMAIL PROTECTED] 02/07/03 09:28AM John,A quick check turned up a "medium" parfile for me - only 1201 tableslisted. The file size is 14KB, so I guess it's not an issue for 8i. Evenon larger parfiles I've never gotten an error - for neither HP-UX norWin2k.Jack C. ApplewhiteDatabase AdministratorAustin Independent School DistrictAustin, Texas512.414.9715 (wk)512.935.5929 (pager)[EMAIL PROTECTED] John.Hallas@voda fone.co.uk To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: Skipping a table on import 02/07/2003 07:38 AM Please respond to ORACLE-L Jack,I always knew there was a limit on the size of a parfile which I hadassumedwas a maximum no of tables allowed. However I recently found out that it isa byte limit on the overall file parameter. (It was 8K in 7.x )Do you not hit this limit with several thousand table names (presumablynot,otherwise you would not do it ) ??John-Original Message-[mailto:[EMAIL PROTECTED]]Sent: 07 February 2003 13:04To: Multiple recipients of list ORACLE-LCraig,I had to smile when you stated you had 400 tables and were reluctant tolist them in the export or import parfile. Our 3rd party StudentInformation system has over 47,000 tables. I frequently do exports and/orimports with parfiles listing several thousand tables. It's not a problemat all.Spool the following to a text file and incorporate it (with minor editingto add the parens and remove the first comma) into your parfile...Select ',' || Table_NameFrom User_TablesWhere Table_Name 'theTableYouDoNotWant';Jack C. ApplewhiteDatabase AdministratorAustin Independent School DistrictAustin, Texas512.414.9715 (wk)512.935.5929 (pager)[EMAIL PROTECTED] "Craig Healey" [EMAIL PROTECTED] To: Multiplerecipientsof list ORACLE-L om [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Skipping a tableonimport 02/07/2003 04:04 AM Please respond to ORACLE-LHi,I'm trying to import the live schema into a test schema, but 1 or 2tables have a lot of data and it's taking hours. Is there a way to skipcertain tables during an import?We're using 8.1.7We have 400 tables, so I'd like to avoid having to list all the tablesin the export statement.I have to pre-create the tables to put them in the correct tablespace,so could I alter the table definitions to force import to skipparticular ones?Any help is appreciated.Craig Healey--Author: Craig Healey INET: [EMAIL PROTECTED]--Author: INET: [EMAIL PROTECTED]--Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]-- 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.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).
RE: RMAN - questions.. Rob Freeman?
Resending, just wondering if there any Shark FlashCopy users out there. So far, it doesn't look good. Gene [EMAIL PROTECTED] 02/06/03 05:03PM Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder works for quick disk backups from experience. However, EMC is not an option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say flashcopy works the same if not better than EMC BCVs. Question, is this pure marketing slop or does flashcopy work as advertised? I have seen many mentions and experience w/ EMC but have never seen flashcopy mentioned here. Thanks for any insight to flashcopy you can provide. Lisa - I am using timed statistics, AIX 4.3.3 ML 8, Oracle 8.1.7.0and no problems here. Welcome back to the Unix world :) [EMAIL PROTECTED] 02/05/03 04:35PM Is this all live OLTP type data, or might some of the data be maderead-only? How much will the data be growing and changing (if not a greatdeal then look into incrementals). I can't begin to guess at the timerequired those numbers are all factors of:1. # of backup devices you will be backing up to (I'd suggest several,minimum of probably 6).2. Speed of backup devices.3. Speed of infrastructure from DB to the backup devices.Given a best case, lots of backup devices to backup to in parallel, fastfast infrastructure and really fast (and expensive) equipment, you couldbackup 1TB in an hour or two... Realisticly, much much longer, perhapsupwards of 10-12+ hours at a moderate price range. You could stagger thesebackups over the week, backup some tablespaces and all archived redo logs onday one, other tablespaces and archived redo logs on day two and so on. Thisstaggered approach will reduce the overhead associated with a large, longlasting backup.Recovery of a TB will take a while of course, be prepared for that whennegotiating your SLA's.A product like BMC's timefinder makes a good primary backup/recoverysolution.-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 2:16 PMI am considering doing an rman to disk backup and recovery solution fora500G-- grow to 1terabytedatabase. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrentusersThis rman would be the secondary recovery solution (Timefinder isthefirst).Anybody know time frames I might be able to restore/backup 500Gig to1terabyteof database from disk? I will perform it before it goes live but I would like get aball park idea of restore times before hand so we can determine if itcanfit in the SLA requirements. Any parameters to focus on to improve performance other thanallocating channels?Thanks for any helpBrian Spears-Original Message-Sent: Wednesday, February 05, 2003 9:53 AMTo: Multiple recipients of list ORACLE-LCheck out the doc's at tahiti.oracle.com and look up the parameternoprompt.Robert-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 5:48 AMHello List,I think my question is very simple...How to execute RMAN command DELETE OBSOLETE from script withoutconfirmation question to remove obsolete backupsautomatically?Many thanks for your help.-- Best regards,Alex mailto:[EMAIL PROTECTED]__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Alex Andriyashchenko 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Freeman Robert - IL 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Spears, Brian 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
RE: RMAN - questions.. Rob Freeman?
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder works for quick disk backups from experience. However, EMC is not an option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say flashcopy works the same if not better than EMC BCVs. Question, is this pure marketing slop or does flashcopy work as advertised? I have seen many mentions and experience w/ EMC but have never seen flashcopy mentioned here. Thanks for any insight to flashcopy you can provide. Lisa - I am using timed statistics, AIX 4.3.3 ML 8, Oracle 8.1.7.0and no problems here. Welcome back to the Unix world :) [EMAIL PROTECTED] 02/05/03 04:35PM Is this all live OLTP type data, or might some of the data be maderead-only? How much will the data be growing and changing (if not a greatdeal then look into incrementals). I can't begin to guess at the timerequired those numbers are all factors of:1. # of backup devices you will be backing up to (I'd suggest several,minimum of probably 6).2. Speed of backup devices.3. Speed of infrastructure from DB to the backup devices.Given a best case, lots of backup devices to backup to in parallel, fastfast infrastructure and really fast (and expensive) equipment, you couldbackup 1TB in an hour or two... Realisticly, much much longer, perhapsupwards of 10-12+ hours at a moderate price range. You could stagger thesebackups over the week, backup some tablespaces and all archived redo logs onday one, other tablespaces and archived redo logs on day two and so on. Thisstaggered approach will reduce the overhead associated with a large, longlasting backup.Recovery of a TB will take a while of course, be prepared for that whennegotiating your SLA's.A product like BMC's timefinder makes a good primary backup/recoverysolution.-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 2:16 PMI am considering doing an rman to disk backup and recovery solution fora500G-- grow to 1terabytedatabase. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrentusersThis rman would be the secondary recovery solution (Timefinder isthefirst).Anybody know time frames I might be able to restore/backup 500Gig to1terabyteof database from disk? I will perform it before it goes live but I would like get aball park idea of restore times before hand so we can determine if itcanfit in the SLA requirements. Any parameters to focus on to improve performance other thanallocating channels?Thanks for any helpBrian Spears-Original Message-Sent: Wednesday, February 05, 2003 9:53 AMTo: Multiple recipients of list ORACLE-LCheck out the doc's at tahiti.oracle.com and look up the parameternoprompt.Robert-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 5:48 AMHello List,I think my question is very simple...How to execute RMAN command DELETE OBSOLETE from script withoutconfirmation question to remove obsolete backupsautomatically?Many thanks for your help.-- Best regards,Alex mailto:[EMAIL PROTECTED]__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Alex Andriyashchenko 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Freeman Robert - IL 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 removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Spears, Brian 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
Re: Borderline OT - Unix for Oracle at home
I agree w/ Ron. Intel Linux is the least cost alternative. I just dumped an old Sparc 5 and bought a PIII 450 128mb ram for $139 + shipping. You can't beat the cost of old intel machines, plus I can get hardware/software anywhere. Gene [EMAIL PROTECTED] 01/30/03 11:30AM Dan,I have an intel 850mz with 512 Ram 4 disks, 1-20g 2-40g and 1 80g anda SCSI Cdrom and SCSI 4mm tape drive Loaded with RedHat 7.2 and Oracle8.1.7.It contains the same data as the production server and is faster by 3fold. The production is Dell 6300 450 mz 1 Gig and 2 Raid1 and 5 Raid5drives. I use the Linux box to practice and play and learn the features of 8ifor implimentation on to the production servers. I think Linux is theway to go. The initial cost and upgrade costs are really in-expensive.Ron [EMAIL PROTECTED] 01/30/03 10:14AM I am looking to add a unix box to my collection of wintel machines athome.It will be used solely for running/testing Oracle, so I don't needbells whistles. My thoughts are either Linux/intel or Sun Ultra workstation.Whileit would be convenient to be able to network it into a DSLconfiguration, itis not essential. My original thought was a Linux desktop, but I canalsoget Ultra 5 or 10 workstations on ebay for less than $500.Anyone having experience good/bad/ugly for this type of task? Alltips,challenges, things to consider are greatly appreciated.Dan Fink-- 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.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).
RE: Debate on rc commands Solaris and Oracle
I used to see the shutdown immediate hang on OpenVMS (Oracle 7.x) platforms, never did happen on my Unix machines, and I never did have to support Oracle on Windoze :). I did notice if I stopped the developers from submitting jobs via dbms_jobs and forced them to use VMS batch jobsthen everything worked fine. Guess, one of the reasons I still use cron, b/c it always worked and it still does :). Gene [EMAIL PROTECTED] 01/30/03 10:21AM I guess I'll go with this method since I have a couple of cold backups that hang on the SHUTDOWN IMMEDIATE and will remain hung until I rectify the situation. I have had TAR's on this but this could not be resolved. I'm just more confident to see others doing this. Does anyone have this problem on a non-windoze platform?? It seems like I only see windoze users having this problem.Thanks,Dave-Original Message-Sent: Thursday, January 30, 2003 7:15 AMTo: Multiple recipients of list ORACLE-LI'll echo that sentiment.'shutdown abort', 'startup restrict' was a regular part of myshutdown scripts beginning in 1994 with 7.0.16, as 'shutdown immediate' wasn't all that reliable, even in situationswhere it should have worked.JaredOn Wednesday 29 January 2003 15:53, John Kanagaraj wrote: Rao, And where did you read that 'shutdown abort' is not recommended? This is another myth that has been busted a while ago. A shutdown abort followed by a startup restrict and a normal shutdown is the way to go when dealing with rogue sessions that open a connection and never shutdown. In such cases, a shutdown immediate will _never_ return (certainly not within your 5 to 10 minutes). I have been using this method for more than 8 years now - starting at 7.0.16 fyi. The trick in this case is to script it into the rc commands. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, January 29, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Paula, Shutdown abort is not recommended as the file checkpointing is not done during shutdown abort. If you need to perform shutdown abort, then, it is preferred to bring up the db with startup restrict (so that the users wouldn't connect) and then, cleanly shutdown the db and bring it up again. Tell to your sys admins. that shutdown immediate would take some time (about 5 to 10 minutes) depending on the activity on your db. They would have to wait for that much time before calling a DBA during system boots. Rao -Original Message- Sent: Wednesday, January 29, 2003 11:30 AM To: Multiple recipients of list ORACLE-L System Administrator says he doesn't trust that the rc commands will stop if the database doesn't want to shutdown and even if it does would want to shutdown with scripts beforehand so that a DBA could connect and resolve the issue. Other DBA says this is all wrong and rc commands should include shutdown immediate of database. In the past I had setup 2 processes in the system scripts for the sys admin - shutdown immediate - wait shutdown abort - on a read-only DSS system which of course allows some room for this type of activity. I kind of would want to know if a database was going to be shutdown with an abort esp. in OLTP system and do it myself. - any ideas-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).-- 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.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).
Re: dbms_job - running jobs every 15 minutes
If a job takes longer than the next scheduled time to execute then I see a problem. Suppose a job runs every 15 mins but runtime is 30 mins, the number ofjobs will increase andcompete for the same resources. I always use cron (80's kinda of control), and the 1st thing I do is check if the job is running and if it is, I exit and issue a warning email. Gene [EMAIL PROTECTED] 01/22/03 02:34PM [EMAIL PROTECTED] wrote:Now as discussed, if the job is scheduled to start at 9:00 AM andrunbs for 5 minutes it's next_date for run #2 will be 9:20, not 9:15, and it will creep 5 minutes every time. No, as written, my jobs start on every quarter hour, regardless of runtime. e.g. 09:00, 09:15, 09:30, 09:45 ...Jared, I wanted to ask this question before but just provideda solution w/o talking too much :)If it's regardless of runtime (it means potentially one jobcan consume more than 15 minutes to get things done) is itallowed to run jobs concurrently?In case of positive asnwer, you need 4 jobs. Otherwise in caseof more than 15mins runtime you'll face slipped jobs.Regards,-- Vladimir BegunThe statements and opinions expressed here are my own anddo not necessarily represent those of Oracle Corporation.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Vladimir Begun 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 removed from). You mayalso send the HELP command for other information (like subscribing).
RE: More RMAN Questions
Thanks Stephan. It looks like I will be using RMAN 8.1.6 8.1.7 to interface w/ the Legato Module for Oracle. Gene [EMAIL PROTECTED] 01/16/03 09:59AM For question 1.(920)/oracle/app/oracle/admin rman nocatalogRecovery Manager: Release 9.2.0.2.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.RMAN connect target sys/password@sid (NOTE: sid is 8.1.7)Recovery Manager incompatible with TARGET database: RMAN 8.0.4 to 8.1.6requiredRMAN-00571: ===RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===RMAN-00571: ===RMAN-06429: TARGET database is not compatible with this version of RMANFor question 2.I suppose you could write your own API to talk to legato, but it seems likeit would be a lot of extra work. One scenario that I have found works well-- IF your databases aren't too big and you have plenty of fault-tolerantdisk space -- is to back up to disk; then use OS to copy backup sets totape. If space permits, keep two or three days worth of stuff on disk (harddrives are cheap). Handy Handy!Here is a driver script I use to rotate directories for storing more thanone day's worth of backups on disk.- go.ksh --#!/bin/kshBASEDIR='/u05/oracle/admin'SIDLIST=''cd "$BASEDIR"for SID in `ls -1`;do RESULT='' BACKDIR="${BASEDIR}/${SID}/backup" if [ -d "$BACKDIR" ]; then SIDLIST="${SIDLIST} ${SID}" else continue fi cd "$BACKDIR" if [ ! -d "${BACKDIR}/DIR1" ]; then mkdir -m 750 "${BACKDIR}/DIR1" fi if [ ! -d "${BACKDIR}/DIR2" ]; then mkdir -m 750 "${BACKDIR}/DIR2" fi ls -1dt DIR[12] 2 /dev/null | while read LINE; do if [ -n "$LINE" ]; then RESULT="$LINE"; fi done STASH="${BACKDIR}/${RESULT}" find "$STASH" \( -type f -a -ctime +2 \) -exec rm {} \; for i in `find . -type f -print -o \( ! -name . -a -type d -prune \)`; do mv "$i" "${STASH}/${i}" donedone/oracle/app/oracle/admin/dbascripts/rman/disk_backup.ksh $SIDLIST /oracle/app/oracle/admin/dbascripts/rman/debug 21- End go.ksh --Original Message-Oracle environment: 3 x 8.1.6 databases + 23 x 8.1.7 databases on 3 serversrunning AIX 4.3.3.My plan is to use RMAN 9i, Legato Module for Oracle without a catalog andhave all databases in archivelog mode. Databases will be backed upincrementally and full.Questions below:1) Will RMAN 9iR2 support 8.1.6 8.1.7 databases w/out using a catalog?From the documentation, it appears the RMAN executable must match the targetdatabase.2) Is RMAN even required for use w/ the Legato Module for Oracle? I knowthe MML is not required for RMAN, hence RMAN disk backups.My prior plan was to upgrade the databases to 9iR2 then implement RMAN, notime to do both. Can I use RMAN 9i w/ older database versions?-- 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.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).
More RMAN Questions
I am starting to plan my RMAN/Legato Networker implementation. I purchased Robert's book and have read Appendix C 8i Differences... I am now persuaded to use RMAN 9i. However, the da'management wants RMAN Legato Oracle module implemented ASAP. I looked at the compatibility matrix and it doesn't answer one of my questions. I listed my questions below: Oracle environment: 3 x 8.1.6 databases + 23 x 8.1.7 databases on 3 servers running AIX 4.3.3. My plan is to use RMAN 9i, Legato Module for Oracle without a catalog and have all databases in archivelog mode. Databases will be backed up incrementally and full. Questions below: 1) Will RMAN 9iR2 support 8.1.6 8.1.7 databases w/out using a catalog? From the documentation, it appears the RMAN executable must match the target database. 2) Is RMAN even required for use w/ the Legato Module for Oracle? I know the MML is not required for RMAN, hence RMAN disk backups. My prior plan was to upgrade the databases to 9iR2 then implement RMAN, no time to do both. Can I use RMAN 9i w/ older database versions? Thanks, Gene
Re: RE : RMAN Repository
Interesting thread, since I am just embarking on using RMAN. If the repository is to go away then why bother learning the intricacies of it. Has anyone else heard the RMAN repository was going away? It appears much simpler to setup w/out the repository. Besides reporting advantages, what are the real benefits to using a repository? Thanks, Gene PS. Now reading Robert's book. [EMAIL PROTECTED] 01/08/03 05:19PM its a pain in the arse but you have to pull out the backed up controlfile(you did backup the controlfile, eh?) out of the rman backup piece(i've got a script that will do it automagically based on the filename pieces you pass it).then once the backed up controlfile is restored, then you can do normal recovery procedure.joe[EMAIL PROTECTED] wrote:And how does one go about restoring a database when all control filesare lost, and the only recovery data is stored in the control file?This doesn't sound very reasonable.Jared"Deshpande, Kirti" [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED] 01/08/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE : RMAN RepositoryJoe, That's what I have heard (from 2 Oracle University Professors/Lecturers/Demonstrators). But no one would tell me when it may happen. We do not use RMAN (yet) so I did not pursue it further. - Kirti -Original Message-Sent: Wednesday, January 08, 2003 1:08 PMTo: Multiple recipients of list ORACLE-Lsnip Obilgatory oracle statement/question: rumor has it by some instructors that RMAN repository is going away and only control file recoveries will be possible, truth or fiction?joe -- 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.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).
RE: RE : RMAN Repository
Dennis - I am now running 8.1.6 8.1.7 w/out RMAN, soon to upgrade to 9.2 then implement RMAN. I have 25 db instances. I am thinking of using RMAN w/out a repository unless there aregreat reasons not to :) Gene [EMAIL PROTECTED] 01/09/03 11:24AM Gene - Which Oracle version(s)? How many instances will you be backing up?Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Thursday, January 09, 2003 9:50 AMTo: Multiple recipients of list ORACLE-LInteresting thread, since I am just embarking on using RMAN. If therepository is to go away then why bother learning the intricacies of it.Has anyone else heard the RMAN repository was going away? It appears muchsimpler to setup w/out the repository. Besides reporting advantages, whatare the real benefits to using a repository?Thanks,GenePS. Now reading Robert's book. [EMAIL PROTECTED] 01/08/03 05:19PM its a pain in the arse but you have to pull out the backed up controlfile(you did backup the controlfile, eh?) out of the rman backup piece(i've got a script that will do it automagically based on the filename pieces you pass it).then once the backed up controlfile is restored, then you can do normal recovery procedure.joe[EMAIL PROTECTED] wrote:And how does one go about restoring a database when all control filesare lost, and the only recovery data is stored in the control file?This doesn't sound very reasonable.Jared"Deshpande, Kirti" [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED] 01/08/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE : RMAN RepositoryJoe, That's what I have heard (from 2 Oracle University Professors/Lecturers/Demonstrators). But no one would tell me when it may happen. We do not use RMAN (yet) so I did not pursue it further. - Kirti -Original Message-Sent: Wednesday, January 08, 2003 1:08 PMTo: Multiple recipients of list ORACLE-Lsnip Obilgatory oracle statement/question: rumor has it by some instructors that RMAN repository is going away and only control file recoveries will be possible, truth or fiction?joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.nethttp://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comhttp://www.fatcity.com San 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).-- 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.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).
RE: RE : RMAN Repository
Robert - Thank you! I will go with the KISS principle anytime. Gene [EMAIL PROTECTED] 01/09/03 11:45AM I actually find the repository of little use. If I have an enterprise with many databases then I will use it for reporting but that's about it. It just seems to complicate the overall administrative costs and thus, the burden/benefit ratio is not all that good. RF Robert G. FreemanTechnical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can find on Amazon.com! -Original Message-From: Gene Sais [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: Re: RE : RMAN Repository Interesting thread, since I am just embarking on using RMAN. If the repository is to go away then why bother learning the intricacies of it. Has anyone else heard the RMAN repository was going away? It appears much simpler to setup w/out the repository. Besides reporting advantages, what are the real benefits to using a repository? Thanks, Gene PS. Now reading Robert's book. [EMAIL PROTECTED] 01/08/03 05:19PM its a pain in the arse but you have to pull out the backed up controlfile(you did backup the controlfile, eh?) out of the rman backup piece(i've got a script that will do it automagically based on the filename pieces you pass it).then once the backed up controlfile is restored, then you can do normal recovery procedure.joe[EMAIL PROTECTED] wrote:And how does one go about restoring a database when all control filesare lost, and the only recovery data is stored in the control file?This doesn't sound very reasonable.Jared"Deshpande, Kirti" [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED] 01/08/2003 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE : RMAN RepositoryJoe, That's what I have heard (from 2 Oracle University Professors/Lecturers/Demonstrators). But no one would tell me when it may happen. We do not use RMAN (yet) so I did not pursue it further. - Kirti -Original Message-Sent: Wednesday, January 08, 2003 1:08 PMTo: Multiple recipients of list ORACLE-Lsnip Obilgatory oracle statement/question: rumor has it by some instructors that RMAN repository is going away and only control file recoveries will be possible, truth or fiction?joe -- 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.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).
OT: Informix backups
The SysAdmin is backing up the filesystems/raw partitions where the informix db resides w/out putting the db in hot backup mode. He was told by a consultant, all you have to do is backup the informix logs and db files for full recovery. As an Oracle DBA and not familiar w/ informix, is this informix db backup recoverable? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Backup DB files to the Tape
I am using home grown scripts and they work. I have Legato use savepnpc (pre/post proc) command call this script: //begin snippet comment section #!/bin/ksh ### # $ORABIN/db_hot_backup.ksh ### # # Common script used to alter one database or all databases # on this server for hot backup mode (begin/end). # This script does NOT actually copy database files to disk # or to tape. # # Hot Backup Algorithm listed below: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Alter system archive log current ; # 8) Backup controlfile. # 9) Alter system archive log current ; # # Date Author Note # -- # 04/26/02 Gene Sais Original Creation # 08/02/02 Gene Sais Copied trace file to Hot Backup Location ### # Parameter Description # - --- sid=$1 # Database sid or all begend=$2 # Begin or End Hot Backup //end snippet comment section hth, Gene PS. I have tested recoveries and they worked, but soon my scripts will succumb to RMAN :). [EMAIL PROTECTED] 12/18/02 12:04PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh 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: dilmohan 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
Re: Backup DB files to the Tape
Not true Ruth. I use Legato's savepnpc command to call pre/post proc scripts. Their media manager Oracle Business Suite requires RMAN and I am not switching just yet :) [EMAIL PROTECTED] 12/18/02 02:56PM If you are using Legato, you are using a third party media manager. I am not sure you can do backup to tape directly without such a product. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:15 PM I am using home grown scripts and they work. I have Legato use savepnpc (pre/post proc) command call this script: //begin snippet comment section #!/bin/ksh ### # $ORABIN/db_hot_backup.ksh ### # # Common script used to alter one database or all databases # on this server for hot backup mode (begin/end). # This script does NOT actually copy database files to disk # or to tape. # # Hot Backup Algorithm listed below: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Alter system archive log current ; # 8) Backup controlfile. # 9) Alter system archive log current ; # # Date Author Note # -- # 04/26/02 Gene Sais Original Creation # 08/02/02 Gene Sais Copied trace file to Hot Backup Location ### # Parameter Description # - --- sid=$1 # Database sid or all begend=$2 # Begin or End Hot Backup //end snippet comment section hth, Gene PS. I have tested recoveries and they worked, but soon my scripts will succumb to RMAN :). [EMAIL PROTECTED] 12/18/02 12:04PM I was thinking of simply copying the datafiles using the OS facilities. If you are putting hot backups to tape directly I am not sure that they will be usable for recovery. RMAN requires a third party media manager to handle backups to tape. If rman can't do it, I am not sure that homegrown scripts can either. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 10:24 AM Ruth, Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp, cpio, ufsdump or any other method of copying the disk file from location a to location b should be ok, shouldn't it? John -Original Message- Sent: Wednesday, December 18, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Just remember, I you don't have the database shutdown while you back them up the backups will be unusable. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:29 AM Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . Regards Dilmohan Ashraf Salaymeh wrote: Dear List, We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh 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
Re:RE: New development in Cobol or PL/SQL - please help
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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: Gene Sais 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).
OT: Informix Training for Oracle DBAs
I just inherited responsibility for a set of informix databases. Has anyone taken the Informix Training for Oracle DBAs, 4 day crash course given by IBM Informix and was it worth it? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: dumping microsoft desktop?
Not here but looking into http://www.lindows.com on a personal nature. Also read MS is suing them, not sure how much longer they will be around. [EMAIL PROTECTED] 11/12/02 02:03PM Has anyone ever gone with linux desktop support? I don't mean for geeks, I mean at an enterprise level? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Gene Sais 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: RAID5+
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: BLOB Storage
I have a 1tb db w/ 95% of it inline blobs, same tbs as data. No performance degradation. However, if I were to do it again, I would have separated the blobs out as B/R is a nightmare, soon to be better w/ RMAN. I haven't received my RF RMAN book yet, amazon must be backfilling orders. hth, Gene [EMAIL PROTECTED] 10/28/02 09:18PM We've got a table with a BLOB column that is currently at 3+ Gig (400,000 records). The max value in the BLOB column is 3k (average (1.5 K). We are currently storing the BLOB out of line (in a separate tablespace). The cache size for the BLOB is 8k (also the block size). Each BLOB is taking up 8K (at the least twice the space required by the BLOB). This table is expected to grow to 10+ million records in the next year. First of all, we're trying to convince the vendor to agree to partition the table. In addition (FINALLY the question :-) !!!), we're trying to decide whether we would gain anything (space being a constraint right now), from a storage standpoint in making the BLOB in line. Obviously we're not going to going to risk performance in order to save space :-) !!! I'm hoping someone in this list would have had some goog or bad experience in this regard. Would there be a major performance hit if I change the BLOB to be in line Thanks, Sunny - Do you Yahoo!? Y! Web Hosting - Let the expert host your web site -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Installing iAS 9.0.2.0.1
Thanks for all the replies. It makes me rethink going to iAS 9.0.2.0.1. Does iAS 1.0.2 require all the same dependencies, i.e. infrastructure install? Gene [EMAIL PROTECTED] 10/29/02 07:53AM made the same experiences with iAS 92 and ended up using 9iAS 1.0.2.2 for various reasons. but we will try again, when oracle - hopefully - does provide a more comfortable way of installation. we use portal, single sign on in connection with novel ldap. was quite a toil to get it up and running but now it works fine. did the same with iAS 9.2.0 but response time and performance were horrible so we removed it again and ...see above. good luck [EMAIL PROTECTED] 10/28/02 16:42 PM If you only want it to do web apps it's not a problem. We installed the OC4J and web cache portion on Solaris in an hour. Very easy. Needed it for version 1.3 of Java. Next we will tackle the full install with the infrastructure which will allow the use of Portal, Reports and Discoverer. Expecting big time headaches based on the documentation and the fact that we want to use iPlanet not the OID for our LDAP. Ben -Original Message- [EMAIL PROTECTED] Sent: October 25, 2002 3:56 PM To: Multiple recipients of list ORACLE-L Gene, We tried it on HPUX and it was not pretty. We ended up going back to 9iAS 1.0.2.2 for various reasons. Good luck. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 25, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Subject: Installing iAS 9.0.2.0.1 Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ port 1521 free for iAS, etc. So many dependencies for iAS and I haven't even looked at deploying forms yet :). I can't wait til 10i when DBA's are no longer required, *HA!* Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Ben 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: Markus Reger 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: Gene Sais 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).
Installing iAS 9.0.2.0.1
Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ port 1521 free for iAS, etc. So many dependencies for iAS and I haven't even looked at deploying forms yet :). I can't wait til 10i when DBA's are no longer required, *HA!* Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Port usage?
the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. [EMAIL PROTECTED] 10/24/02 05:44AM we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don 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: Yechiel Adar 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: Gene Sais 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: Multiple Listeners
1st thing i do when upgrading db's on a server is to start using the new listener. just have your 816 db's use the 817 listener. hth, gene [EMAIL PROTECTED] 10/16/02 02:12PM DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Gene Sais 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: Controlling Users Logons
Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Gene Sais 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: Standard Edition and Enterprise Edition on same box?
No problem. I always use a different OH for each version. [EMAIL PROTECTED] 10/10/02 06:18PM Environment: HP_UX 11 This is a Development environment only. Can one safely run Oracle DB Standard Edition and Enterprise Edition on the same machine? I know this sounds odd. We have two packages, Application (A) which still runs Oracle 8i for the db, and for that we purchased 10 named users and x processors. Application (B) uses Oracle 9i AS Enterprise Edition with 10 named users. From purely a technical standpoint, can you run both on the same box and not have it break or cause really bad performance. As we move forward into production, we'll need to buy more and different licensing, because Application (B) is web-based. And it would be split over different host computers in production, not both on the same, calm down. 8*) Thanks. Don Malzahn, IT/AS, Harper Community Collegeáá Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED]ááá Web page: http://www.harper.cc.il.us The only limit to our realization of tomorrow will be our doubts of today. - FDR ááá Yahoo! Groups Sponsor ADVERTISEMENT [IMAGE][IMAGE] width Replies to this message will be sent to ALL members of the group. If your response is personal, please send it directly to the person who posted. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Malzahn 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle 9i desupport dates
Is that a new requirement for the OraStaff DBA position? [EMAIL PROTECTED] 10/08/02 04:33PM Good. Is anybody here ORacle12i certified? -Original Message- Sent: Tuesday, October 08, 2002 3:59 PM To: Multiple recipients of list ORACLE-L 9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003. -- yes in like 8 months 9.2, aka9ir2, ECS ends sep 30, 2005. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Backups
lol, OK my reasons for occasional cold backups. As a prior sysadmin, I prefer single user mode full filesystem backups (i.e. databases shut down) prior to any upgrade whether its an application, database, or operating system. There are benefits of cold over hot backups (of course this assumes you have the luxury to take a database offline): 1) Archive logs not needed. 2) No need to be concerned which databases are in archivelog mode. 3) Easier to backup and restore, even the sysadmin can do it :), i.e. no DBA required, no database recovery. OS utilities can be used for backup/restore. 4) Old habits are hard to break :). Gene [EMAIL PROTECTED] 10/04/02 01:38AM OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands 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
Re: Backups
Oracle 6 and prior releases required cold backups. Hot backups became available in version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's new book :). Gene [EMAIL PROTECTED] 10/04/02 10:03AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands 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
Re: Backups
I stand corrected. Guess I shouldn't rely on memory, it keeps failing on those DBA sessions :) Just don't remember anyone doing hot backups during Oracle 6. Thanks, Gene PS. (DBA=DrinkBeerAgain) [EMAIL PROTECTED] 10/04/02 16:23 PM gentle correction: oracle6 had hot backup capability... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 9:48 AM Oracle 6 and prior releases required cold backups. Hot backups became available in version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's new book :). Gene [EMAIL PROTECTED] 10/04/02 10:03AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups ae a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed wen you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http
Re: Backups
I stand corrected. Guess I shouldn't rely on memory, it keeps failing on those DBA sessions :) Just don't remember anyone doing hot backups during Oracle 6. Thanks, Gene PS. (DBA=DrinkBeerAgain) [EMAIL PROTECTED] 10/04/02 16:23 PM gentle correction: oracle6 had hot backup capability... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 9:48 AM Oracle 6 and prior releases required cold backups. Hot backups became available in version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's new book :). Gene [EMAIL PROTECTED] 10/04/02 10:03AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups ae a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed wen you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http
RE: Utl_file and OPENVMS
On unix, multiple entries in the init.ora file results in the last entry being the only valid value (i.e. last time variable is set). I tested below and only dir3 is listed as a utl_file_dir parameter. But if you comma delimit them w/ 1 instance of the variable then all dir's are listed. Maybe NT is different, fortunately never had to support Oracle on NT :). Gene [EMAIL PROTECTED] 10/02/02 07:13PM Gene, utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 The multiple lines shown are actually the documented method for doing this. The single line with comma delimited entries may also work, though I'm not sure about it. Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/01/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Utl_file and OPENVMS i believe its utl_file_dir=dir1,dir2,dir3,... in your example, dir 3 would be the only valid dir. hth, gene [EMAIL PROTECTED] 10/01/02 12:53PM Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_DateIn Date, P_Load_Userid In Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir In Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir In Varchar2 ) as Begin Declare L_Par_File_Hand Utl_FIle.File_Type; -- Local variable to hold the File Pointer for the parameter file. Begin I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT EN TO. -- Open a new parameter file L_Par_File_Hand := Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); -- Print the following lines into the parameter file. Utl_File.Put (L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load _Service_Name); Utl_File.New_Line(L_Par_File_Hand); If Not P_Current_Table_Name = 'GLCRET' Then Utl_File.Put (L_Par_File_Hand,'Errors=1'); Else
RE: Utl_file and OPENVMS
What does your utl_file_dir parameter look like in your init.ora? I am using AIX. [EMAIL PROTECTED] 10/03/02 11:43AM What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no problem with separate entries as mentioned by Jared. However, don't keep gap between these entries...and define it the way it was explained by Jared. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 05:28:22 -0800 On unix, multiple entries in the init.ora file results in the last entry being the only valid value (i.e. last time variable is set). I tested below and only dir3 is listed as a utl_file_dir parameter. But if you comma delimit them w/ 1 instance of the variable then all dir's are listed. Maybe NT is different, fortunately never had to support Oracle on NT :). Gene [EMAIL PROTECTED] 10/02/02 07:13PM Gene, utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 The multiple lines shown are actually the documented method for doing this. The single line with comma delimited entries may also work, though I'm not sure about it. Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/01/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Utl_file and OPENVMS i believe its utl_file_dir=dir1,dir2,dir3,... in your example, dir 3 would be the only valid dir. hth, gene [EMAIL PROTECTED] 10/01/02 12:53PM Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_DateIn Date, P_Load_Userid In Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir In Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir In Varchar2 ) as Begin Declare L_Par_File_Hand Utl_FIle.File_Type; -- Local variable to hold the File Pointer for the parameter file. Begin I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT EN TO. -- Open a new parameter file L_Par_File_Hand := Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); -- Print
Re: 8.1.7 patch it up?
IMHO, If it ain't broke don't fix it! I know some of the patch releases introduced new problems. I am at 8.1.7.0 and all is fine for 21 databases. Soon, I wil upgrade to 9iR2 using RMAN. I believe RMAN has improved some for 9iR2. Gene [EMAIL PROTECTED] 10/03/02 10:03AM I'm administering a number of production databases (mixture of standard and enterprise editions) most of which are version 8.1.7.0.0 on Windows NT and 2000. All are functioning fine and I have no issues. I'm considering patching (to 8.1.7.4) some if not all databases and just want to know if this is an absolute must if all systems are currently running fine. In other words does if its not broken, don't fix it apply? Also, I'm considering implementing RMAN in the near future and am wondering if there are significant issues with this on the unpatched 8.1.7 database. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Gene Sais 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: Backups
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Utl_file and OPENVMS
hmm, when you go into svrmgrl connect internal and show parameters, do both show up or just the last one? on my system, i only see the last. [EMAIL PROTECTED] 10/03/02 01:13PM Like these utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data utl_file_dir=/u327/applmgr/10_7/har/1.0.0/mm_cbdata and these are the last entries in initSID.ora file. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 07:58:38 -0800 What does your utl_file_dir parameter look like in your init.ora? I am using AIX. [EMAIL PROTECTED] 10/03/02 11:43AM What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no problem with separate entries as mentioned by Jared. However, don't keep gap between these entries...and define it the way it was explained by Jared. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 05:28:22 -0800 On unix, multiple entries in the init.ora file results in the last entry being the only valid value (i.e. last time variable is set). I tested below and only dir3 is listed as a utl_file_dir parameter. But if you comma delimit them w/ 1 instance of the variable then all dir's are listed. Maybe NT is different, fortunately never had to support Oracle on NT :). Gene [EMAIL PROTECTED] 10/02/02 07:13PM Gene, utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 The multiple lines shown are actually the documented method for doing this. The single line with comma delimited entries may also work, though I'm not sure about it. Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/01/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Utl_file and OPENVMS i believe its utl_file_dir=dir1,dir2,dir3,... in your example, dir 3 would be the only valid dir. hth, gene [EMAIL PROTECTED] 10/01/02 12:53PM Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_DateIn Date, P_Load_Userid In Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir In Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir
Re: * Production Oracle DBA Needed in Hartford, CT...
Remaining 10% on normal Oracle DBA function. Platforms used are oracle/unix, oracle/wintowe, sybase/unix, etc. Person will be trained on other databases/platforms in 'slack time'. hmm, sounds like 90% developer + 10% dba still = dba. lets not forget slack time for learning sybase *rofl* [EMAIL PROTECTED] 10/03/02 02:53PM Position: Oracle DBA Location: Hartford, Connecticut Salary Range: 60-80K-depends on experience plus excellent benefits and wonderful work environment. Candidates already in the Greater Hartford, CT area will be given first priority.. this company strongly prefers not to relocate. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. *Description: The DBA will spend 50% on 'release management'(vendor term) implementing fixes and new releases into test and production.(tandem/comaq/HP environment.) 40% of time will be doing development and writing SQL for updates and data retrieval. STRONG SQL IS REQUIRED. Remaining 10% on normal Oracle DBA funtions. Platforms used are oracle/unix, oracle/wintowe, sybase/unix, etc. Person will be trained on other databases/platforms in 'slack time'. Requirements: -4+ years Production Oracle DBA experience. -Strong SQL background. -Unix -Multi industry background is preferred. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Hartford/Oracle DBA/Stan D. ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Gene Sais 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: Utl_file and OPENVMS
so right you are! i just tested in sqlplus and it shows both. thanks. one thing noticed, is that if you include another file w/ utl_file_dir setting to something, it ignores the original setting, i.e. part of my problem. all my initsid.ora files include a common 8i init.ora. in the common init.ora file i have this set, but it gets reset not appended to when i set utl_file_dir it in the initsid.ora file. thanks again. [EMAIL PROTECTED] 10/03/02 04:03PM Here you are right. You will see here only one because of width. Please don't rely on svrmgrl for such info. Instead use sqlplus and check it from v$parameter result is PARAMETER -- VALUE utl_file_dir /u327/applmgr/10_7/finprod_output/hfs_data, /u327/applmgr/10_7/har/1.0.0/mm_cbda ta Both entries are appearing here, HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 11:13:42 -0800 hmm, when you go into svrmgrl connect internal and show parameters, do both show up or just the last one? on my system, i only see the last. [EMAIL PROTECTED] 10/03/02 01:13PM Like these utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data utl_file_dir=/u327/applmgr/10_7/har/1.0.0/mm_cbdata and these are the last entries in initSID.ora file. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 07:58:38 -0800 What does your utl_file_dir parameter look like in your init.ora? I am using AIX. [EMAIL PROTECTED] 10/03/02 11:43AM What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no problem with separate entries as mentioned by Jared. However, don't keep gap between these entries...and define it the way it was explained by Jared. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 05:28:22 -0800 On unix, multiple entries in the init.ora file results in the last entry being the only valid value (i.e. last time variable is set). I tested below and only dir3 is listed as a utl_file_dir parameter. But if you comma delimit them w/ 1 instance of the variable then all dir's are listed. Maybe NT is different, fortunately never had to support Oracle on NT :). Gene [EMAIL PROTECTED] 10/02/02 07:13PM Gene, utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 The multiple lines shown are actually the documented method for doing this. The single line with comma delimited entries may also work, though I'm not sure about it. Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/01/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Utl_file and OPENVMS i believe its utl_file_dir=dir1,dir2,dir3,... in your example, dir 3 would be the only valid dir. hth, gene [EMAIL PROTECTED] 10/01/02 12:53PM Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR
Re: Backups
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Weatherman 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: Ruth Gramolini 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Gene Sais 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 D.B.A. required in M.A.
lol, i love #1 #2, developer but not a development dba. good luck in your search, quite a few requirements :) gene [EMAIL PROTECTED] 10/02/02 11:50AM In my company, we require Oracle D.B.A. to maintain development and production Oracle databases. This is a permanent position. Our compnay is 24 yrs. old company. Our company is situated on Route 128 in M.A. We require the candidate urgently. If interested, please send your resumes within the next two days to the following e-mail: [EMAIL PROTECTED] Following are the details for the job: Our environment: Solaris 7 and solaris 8. Databases versions: 804, 8.1.6.1, 8.1.7.3 OLTP databases and datawarehouse. Veritas File System. Middleware: Tuxedo and MQ series Quest, DataMirror - Replication products Apps: WebLogic Following is the skill set for the candidate: Following are essential requirements for an Oracle DBA. 1. Must have worked as Oracle developer at least 3 years. 2. Must have been working as Oracle DBA at least for the last 3 years in a PRODUCTION environment in 8i. (We don't want development DBA's). 3. Must have excellent knowledge in installing Oracle software and its products. Must have installed patches in his earlier job. 4. Thorough knowledge in Backup and Recovery procedures. Must be able to solve scenarios during the interview. 5. Good knowlege in Oracle tuning process. Must be able to solve scenarios during the interview. 4. Must have good knowledge in running various statistical packages like STATSPACK. 5. Excellent knowledge in shell programming and understanding of awk and sed usage. 6. Must be very familiar with Solaris 7 and higher versions. Must have general understanding of tuning/performance processes involved on Unix level. Should be able to give us various scenarious he/she faced during his career in tuning. 7. Must have good understanding of PL/SQL, SQL. 8. Must be familiar with OMS and its tools. 9. Must have thorough understanding of RAID concepts and its use in Oracle. And good knowledge on Oracle OFA methodology - -- This is must. 10. Must have good knowledge on normalization techniques. 11. Must be familiar with Oracle Standby databases and their running. -- This is essential. 12. Good communication skills and team work. Optional but would have weightage: 1. Oracle 9i knowledge 2. Oracle RAC environment experience. 3. Datawarehous knowledge and issues involved in setting up production datawarehouses 4. Understanding of Veritas 5. Knowledge about design tools like Oracle Designer/ERwin 6. Knowledge about Quest 7. Knowledge about DataMirror 8. General understanding of WebLogic 9. Understanding Tuxedo or MQM 10. Knowledge in C programing. Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Gene Sais 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: Utl_file and OPENVMS
' Then Utl_File.Put (L_Par_File_Hand,'Errors=1'); Else Utl_File.Put (L_Par_File_Hand,'Errors=50'); End If; Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Control='||P_Load_Control_File_Dir||'/'||P_Current_Table_Name||'.CTL'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Log='||P_Load_Log_File_Dir||'/'||P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.LOG'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Bad='||P_Load_Bad_File_Dir||'/'||P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.BAD'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Discard='||P_Load_Discard_File_Dir||'/'||P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.DSC'); as Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Data='||P_Load_Data_File_Dir||'/'||P_Current_Table_Name||'/'|| P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.DAT'); -- Close the file after printing. Utl_File.Fclose(L_Par_File_Hand); Exception When Others then Dbms_Output.Put_line(to_char(sqlcode)||'-'||SQLERRM); End; Thanks, Any assistance would be appreciated. I am just getting in to the OPENVMS OS. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Utl_file and OPENVMS
the following lines into the parameter file. Utl_File.Put (L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load _Service_Name); Utl_File.New_Line(L_Par_File_Hand); If Not P_Current_Table_Name = 'GLCRET' Then Utl_File.Put (L_Par_File_Hand,'Errors=1'); Else Utl_File.Put (L_Par_File_Hand,'Errors=50'); End If; Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Control='||P_Load_Control_File_Dir||'/'||P_Current_Table_N ame||'.CTL'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Log='||P_Load_Log_File_Dir||'/'||P_Current_Table_Name||to_ char(P_Run_Date,'mmdd')||'.LOG'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Bad='||P_Load_Bad_File_Dir||'/'||P_Current_Table_Name||to_ char(P_Run_Date,'mmdd')||'.BAD'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Discard='||P_Load_Discard_File_Dir||'/'||P_Current_Table_N ame||to_char(P_Run_Date,'mmdd')||'.DSC'); as Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Data='||P_Load_Data_File_Dir||'/'||P_Current_Table_Name||' /'|| P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.DAT'); -- Close the file after printing. Utl_File.Fclose(L_Par_File_Hand); Exception When Others then Dbms_Output.Put_line(to_char(sqlcode)||'-'||SQLERRM); End; Thanks, Any assistance would be appreciated. I am just getting in to the OPENVMS OS. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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
Re: Should I post a preview of Oracle9i RMAN Backup and
I agree, post it. If someone doesn't want it, they can hit the ol delete key. But it is truly up to the list-owner. Gene [EMAIL PROTECTED] 09/26/02 05:33PM I say post it. We are the benefactors. If the list owner says go for it then post it anyway regardless as I know many folks would be very grateful. Rick Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: Should I post a preview of Oracle9i RMAN Backup and Recovery Sent by: Hand [EMAIL PROTECTED] om 09/26/2002 04:30 PM Please respond to ORACLE-L I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: 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: Gene Sais 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 work load
I totally agree! The more development support required the more DBAs needed and you should always have a backup in case you hit lotto :-). [EMAIL PROTECTED] 09/24/02 10:58AM just to add into the mix. it also depends on how much development is going on and if you are involved in that as well. I have 3 new applications going live next month, all brand-new databases and one project lead who doesn't understand the concept of a design spec and who keeps handing me major changes in email. If you have that, in addition to production, in a 24x7 shop, then you need help There should be at leat 2 DBAs -- what if you get sick or (as one of my bosses used to say) what if you get hit by a truck? --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Tony - I agree with Tim. This reminds me of the practice years ago of measuring the productivity of COBOL programmers by measuring their LOC (lines of code) production. Number of instances, how large, the number of developers or end users all have an effect. But how this all works out depends on many factors that are hard to quantify. Take 24x7 for example. All my instances are 24x7. I support production plants that are running 3 shifts at times. But, knock on wood, Oracle is pretty reliable and I usually don't get called. Some of our Unix servers have been up over a year. But I wouldn't classify my 24x7 alongside some eCommerce sites where the company's revenue depends on that site being up every minute. There is a lot of difference between developers. An experienced developer you've worked with for many years won't need the detailed assistance that a new developer will. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 8:43 PM To: Multiple recipients of list ORACLE-L I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want Industry Standards, like how many Databases can one DBA manage. Or how many GB/DBA or endusers/DBA? Does anyone keep these kind of stats? thanks __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tony ynot 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: 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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: Gene Sais 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
Re:Backup Strategy - Informal Survey
Robert - My info: Oracle 8.1.7 E.E. Largest DB is 900gb Hot Backups 2x week Cold Backups 1x month Export Backups 1x week on selective schemas I do export backups for creation of test db's, recover data validation blunders, i.e. single object restores. Future plans are RMAN, RMAN, RMAN on 9i. I need incremental backups fast :) Gene [EMAIL PROTECTED] 09/20/02 10:53AM Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week are the norm around here we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or mass changed so that we have a point in time to go back to if all hell breaks loose. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: 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: Gene Sais 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.
ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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: 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). -- 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: Gene Sais 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.
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais 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: Authentication with Active Directory
[EMAIL PROTECTED] 09/18/02 05:58PM We have several databases spread out over Unix and NT Servers. I have been given the task to find out what it will take for our users to log in to the databases with their AD Id/password. Has anybody out there done this? Here are some questions I have: 1) Do I need to have Advanced Security Option? No, its an extra option. 2) Does Enterprise Login Asst. factor into this? Not sure. 3) Does Oracle internet directory factor into this? OID is similar to LDAP. Keith H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry, Keith 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: Gene Sais 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:mixed case text
IMHO, I prefer to use both, mixed case text for reports, etc. and upper case text for searches, etc. What's a few more characters in the db when it keeps everyone happy :) Gene [EMAIL PROTECTED] 09/12/02 10:18AM Steve, From one dinosaur to another, let them have mixed case. Dick Goulet Reply Separator Author: Steve McClure [EMAIL PROTECTED] Date: 9/11/2002 5:38 PM I just had a heated, well perhaps not heated, but certainly adversarial discussion with my manager regarding mixed case text. My position...Keep it out of the database. His position ...same case text looks amateurish when output, and the database should readilly accomodate it. He almost seems to think my objection is related to a shortcoming in Oracle...I used to do that in Clipper 12 years ago. It is my opinion that if you want to output mixed case data you should use functions to beautify text like names and addresses. My biggest objection is that by allowing mixed case text in a table, you are setting up developers (and me) to write queries that don't work. In order to get proper results from a query you have to upper() every single query involving the columns in question. To me this is far more annoying/complicated than calling functions when writing the relatively few reports that require Proper text. So am I a dinosaur? Maybe it is because I am not writing the reports that are complicated by my decision to upper() everything while loading. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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: Gene Sais 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: ctrl c on PCs
try ctrl-y on VMS, it interrupts the session. [EMAIL PROTECTED] 09/06/02 09:58AM In sql*plus, if do a ctrl-c from within sqlplus I am returned to the dos prompt. However, from OpenVMS, I am kept in sql*plus. We have some scripts that do a pause in them so can terminate if a problem. However, if hit ctrl-c during the pause sql*plus ends commiting the updates. Shouldn't sql*plus just return to a prompt or is this normal on windows. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Hot Backup using EMC /BCV splits
rofl! it should be 1, 4, 5, 2. [EMAIL PROTECTED] 08/15/02 10:58AM Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Gene Sais 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 examples scripts
I just pre-ordered your book, says it wil be ready Nov. Is the realistic date? :) Gene [EMAIL PROTECTED] 08/14/02 12:13PM Pretty good scripts. Just looking at them, they appear to be more of the 8i variety. There are some improvements in 9i and 9iR2 that could be considered, such as the restore of the control file without a recovery catalog, and controlfile and SPFILE autobackups. Also, I'd remove the manual channel allocations and configure defaults where possible. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Wednesday, August 14, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Jack and list, I've got them, am writing up the web page for it and will post them to http://www.oracle-dba.com http://www.oracle-dba.com joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Gene Sais 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: Auditing logons
another suggestion: disable default roles. grant create session to all users. use application to enable roles with password. hth, gene [EMAIL PROTECTED] 08/09/02 01:58PM Why to find who and when. the best thing is to restrict the access. -Original Message- Sent: Friday, August 09, 2002 10:44 PM To: Multiple recipients of list ORACLE-L Use a logon trigger to capture everything from v$session and you can look at program name etc...it will be pretty easy to figure out who and when. Something like this in the trigger... select distinct sid into l_sid from v$mystat; insert into session_log (select * from v$session where sid = l_sid; Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Friday, August 09, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Folks, Before I go off re-inventing the wheel once again I'll ask the group is anyone has tried this before. What I have is a request from damanagement to tell them when someone connects to our PeopleSoft database using the schema username, but outside of PeopleTools. The reason is that there have been some unexplained changes to data that have occurred over the last month that is causing a pile of concern. It is believed that someone who has the schema password is using SQL*Plus or Toad to update the data when they should not be doing so. Now auditing connects for the schema account is not a problem, but determining which are suspicious and which are due to the damned PeopleSoft panel processor I can't see a way around easily from sys.aud$. Anyone else been there, done that?? Dick Goulet -- 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: Post, Ethan 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: Naveen Nahata 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: Gene Sais 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: SOLVED: IFILE in node-specific init file in VMS
Interesting find. In my VMS env, I do not have blank lines but I do in Unix init.ora's. It must be a VMS thing, since it doesn't like blank lines in DCL scripts either :) Gene [EMAIL PROTECTED] 08/02/02 12:53AM Mark, I'm glad you got it solved. Maybe it is platform specific? We don't have OPS but do use ifile notation We have lots of blank lines in addition to a number of comment lines beginning with # and we haven't had any problems, that I know of :-). We're running 81714 under NT4 SP6a. Did support give a reference to a Metalink note describing issues with blank lines in init files? Thanks, Bruce Reardon -Original Message- Sent: Friday, 2 August 2002 10:33 Blank lines in your init.ora are a very bad thing. Oracle support and Metalink get beat up quite often on this list but I must say they solved this problem very quickly. Thanks to everyone who replied. Mark -Original Message- Sent: Thursday, August 01, 2002 9:38 AM Is the logical defined as /system/exec? If so and doesn't work, I would open a tar b/c it must be something in your env. I am running Oracle 8.1.7.3 OpenVMS 7.2 and have no problem. I do put the ifile stmt 1st line in initSID.ora file so I can easily override any parameter. Gene [EMAIL PROTECTED] 07/31/02 06:30PM Hi Gene, I've tried using both a logical (ora_system) and the full path. It doesn't work either way. Tom - I'm tempted but I would like the simplicity of maintaining a single init.ora. Mark -Original Message- Sent: Wednesday, July 31, 2002 3:34 PM I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical? I don't like using init...ora and config...ora. I use an instance specific initSID.ora that ifile's a common init.ora file into each db. Its nice to put a change in 1 file and its applied to all dbs. Gene [EMAIL PROTECTED] 07/31/02 05:04PM Mark, throw away the IFILE thingy. it is not worth the trouble! create instance specific init.ora files. solves your problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 31, 2002 4:49 PM Greetings elitist *nix bigots, I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and I've run into a problem with the IFILE parameter in the node specific init file. It appears Oracle is not reading the generic init.ora specified in the IFILE parameter in the node specific init file. Only parameters defined in the node specific init file are effective. Has anyone been there, done that? Thanks, Mark Stahlke Elitist VMS Bigot Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Gene Sais 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: IFILE in node-specific init file in VMS
Is the logical defined as /system/exec? If so and doesn't work, I would open a tar b/c it must be something in your env. I am running Oracle 8.1.7.3 OpenVMS 7.2 and have no problem. I do put the ifile stmt 1st line in initSID.ora file so I can easily override any parameter. Gene [EMAIL PROTECTED] 07/31/02 06:30PM Hi Gene, I've tried using both a logical (ora_system) and the full path. It doesn't work either way. Tom - I'm tempted but I would like the simplicity of maintaining a single init.ora. Mark -Original Message- Sent: Wednesday, July 31, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject:RE: IFILE in node-specific init file in VMS I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical? I don't like using init...ora and config...ora. I use an instance specific initSID.ora that ifile's a common init.ora file into each db. Its nice to put a change in 1 file and its applied to all dbs. Gene [EMAIL PROTECTED] 07/31/02 05:04PM Mark, throw away the IFILE thingy. it is not worth the trouble! create instance specific init.ora files. solves your problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 31, 2002 4:49 PM To: Multiple recipients of list ORACLE-L Greetings elitist *nix bigots, I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and I've run into a problem with the IFILE parameter in the node specific init file. It appears Oracle is not reading the generic init.ora specified in the IFILE parameter in the node specific init file. Only parameters defined in the node specific init file are effective. Has anyone been there, done that? Thanks, Mark Stahlke Elitist VMS Bigot Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stahlke, Mark 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Stahlke, Mark 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: Gene Sais 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
Re: Oracle Corp. move to India
Lets not forget Latin America, oh I mean Florida where wages and expenses are lower than North America. :) [EMAIL PROTECTED] 08/01/02 11:53AM Don't forget the Minnesota Iron Range. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 9:38 AM One of these days large multi-national software companies will discover that exotic, far-off place with lower pay scales, an eager work force, a strong work ethic and lot's of talent... The Great American Midwest. You know, places like Iowa. Of course language and cultural barriers will be a challenge. :-) Steve Orr Silicon Valley Refugee in Montana -Original Message- Sent: Wednesday, July 31, 2002 2:56 PM To: Multiple recipients of list ORACLE-L I would not treat this snip of news in such a light-hearted manner. Comparing to couple of years ago, the IT job market has slumped completely from a sellers market to a buyer's market. I am not a greedy person by any means and all I asking for is a decent salary and some job security. But if this trend of massive exports of IT jobs overseas continues, I am not sure how many of us will be able to have that. BTW, before firing the slingshots at this E-mail, please note that I am pro-globalization and have heard the arguments about fair market/competition etc. But bear in mind that we are standing on uneven grounds when competing with third world programmers because of the huge housing and living expense differences. Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: KENNETH 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: Gene Sais 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: Ids and passwords for application users
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: Gene Sais 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: IFILE in node-specific init file in VMS
I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical? I don't like using init...ora and config...ora. I use an instance specific initSID.ora that ifile's a common init.ora file into each db. Its nice to put a change in 1 file and its applied to all dbs. Gene [EMAIL PROTECTED] 07/31/02 05:04PM Mark, throw away the IFILE thingy. it is not worth the trouble! create instance specific init.ora files. solves your problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 31, 2002 4:49 PM To: Multiple recipients of list ORACLE-L Greetings elitist *nix bigots, I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and I've run into a problem with the IFILE parameter in the node specific init file. It appears Oracle is not reading the generic init.ora specified in the IFILE parameter in the node specific init file. Only parameters defined in the node specific init file are effective. Has anyone been there, done that? Thanks, Mark Stahlke Elitist VMS Bigot Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stahlke, Mark 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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 Corp. move to India
The good thing is that you can only work 1 corner at a time. I got to pick up a used wheelchair and go for the sympathy work :) *so many corners so little time* [EMAIL PROTECTED] 07/31/02 05:50PM Guess I'll make out a sign now which reads, Will code for food and hang out at a busy intersection. -Original Message- Sent: Wednesday, July 31, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Anybody read Bob Lewis' Survival Guide column in InfoWorld? A few weeks ago he talked about programming jobs in the U.S. going the way of manufacturing jobs, with more and more going overseas to developing countries. He claimed that programmers/developers will be going the way of textile workers soon. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, July 31, 2002 1:40 PM To: Multiple recipients of list ORACLE-L Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Gene Sais 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 DB_Name 4 chars only.
My std. also, 4 chars for db with last char denoting db use (Production, Test, Development, Training, etc.). I started on VMS Oracle 6, seemed to be the case back then, still hold to it. I used to have dns aliases for db names, VMS node name limit was 6 chars. For example: Payroll DB Names --- payp=Prod payt=Test payd=Development ... Payroll DB Server Names --- paypdb=Prod DB Server DNS Alias paytdb=Test DB Server DNS Alias payddb=Development DB Server DNS Alias ... This worked well before oracle names. Move a db, make a DNS change, done. Old habits are hard to break, never had a need to :) fwiw, Gene [EMAIL PROTECTED] 07/30/02 04:22PM We have SIDs 9 chars long! Ron SMith -Original Message- Sent: Tuesday, July 30, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Hi, What is the reason behind DB_Name/SID usually 4 chars length only. I have a customer who is asking us to create instance/db with 6 chars length. We usually keep instance name and db_name parameters same in .ora file. Can someone please explain the reason behind db_name 4 chars only. Is it a common practice to keep SID/db_name/instance name parameters same (for example PBDS). thanks Srinivas __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinivas 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: Smith, Ron L. 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: Gene Sais 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).