rh9 ALREADY?
This is scary: We appreciate your support of Red Hat Network and wanted to alert you to a special service that we are extending to paying Red Hat Network customers such as yourself. For the past couple months we've gathered feedback and listened to our customers. We've heard that one of the things you want most is early access to Red Hat Linux ISOs. Well, we've responded. Starting March 31st at 9am Eastern, you can start downloading Red Hat Linux 9 ISOs -- a week before they will be generally available in retail stores or via Red Hat FTP. 8.1 is not even out, go figure. joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*LOADER question
Rick, am i missing something in the picture here??, why not use sqlloader(you'll need it on your local PC) and send it across sql*net? joe Hi All, I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a remote site (WAN connection) and another on my desk running the Oracle client software(no database). Can I, and if so how, use sqlldr on my desktop PC to load data into the remote database. The data file to be loaded and the control file are on my desktop. I do not want to use netmeeting or PC anywhere type programs which I know I can use. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN framework scripts, etc
A bunch of you asked for it, its not quite done but the majority of the stuff should work just fine, they were originally written for 8i database but latest development has been on 9.2.0.3, although I've tried to NOT use any 9i specific stuff in them. yes they are free and you can use to your hearts content just please give 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 you pay for, there is no guarantee whatsoever, if you blow up your database during a restore test, I'm not responsible. That being said: the .zip file(its got a password on it, which I'll tell you in a minute), is located(there is zip available for most if not all unix platforms as well as windoze). If you don't have access to zip on 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 ready for prime-time, the production version will not have a key). http://www.oracle-dba.com/rman_beta its the only file in that directory. These scripts were all written for unix(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 an email, after since the code is open and in the free domain(but I need some control over it while still in development mode), the key is: d42x21 I hope to have a new build every 2 weeks or so and the key can always be requested by sending an email to [EMAIL PROTECTED] . You'll see that there is some menu framework started and its included but is far from finished. Any questions feel free to email me here [EMAIL PROTECTED] or [EMAIL PROTECTED] Joe, happy backups and restores :) Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AW: Backup Strategy
-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kulev, Milen 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
They have been removed due to my rman framework scripts taking the disk space. Sorry. Joe I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? John Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN resync of catalog to controlfile
Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN resync of catalog to controlfile
the catalog has all of the current backup info, so if i lose the repository(before taking a backup after rebuilding the controlfile), I'm SOL. I logged a tar and oracle's response is, no way to push catalog info back into the controlfile. joe Joe - I'm confused. If you rebuild the controlfile, what good is the backup information stored in the catalog? Other than maybe deciding to revert to a time before the rebuild, and you're going to need the catalog for that anyway. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RedHat 8.0
I run that config pretty successfully but I dont believe in java(its a religious thing, bwahahaha) and really only use that config for backup/recovery RMAN testing. joe Anyone messing with RedHat 8.0 and Oracle 9.2..? I've got 9.2.0.2.0 database running on 8.0, most of the Java utilities don't work. (not that that is new) Oracle OMS crashes when discovering or refreshing nodes. (segmentation faults) I am wondering if it is JRE version related. I know Oracle is not supporting this version at all right now but if any one has any thoughts -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Basic RMAN question
Ceri, I know the problem, on RH, do a which rman, you're probably hitting the binary that does Reverse MANpage. do a $ORACLE_HOME/bin/rman instead and all should be well. joe Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic problem starting rman. I have oracle 9.2.0.1.0 installed on Redhat AS 2.1 When i issue the command: rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log=test.log rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Teradata baned from IOUG???
evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [new info] Redhat Advanced Server Dev Edition - RAC
I'm with Mike on this one, except I was just told earlier this morning that the current client I'm at wants to move the 11i apps to RAC. DO they need it, nope, do they want it, yep(and have basically already cut the check for the cost of RAC(since its on sale till end of month) :) So the experiment that I'll be starting next week will probably become a reality in the next 60 days. :) joe I don't know anyone who needs it but Oracle is behind it and that means that sooner or later they'll start to shift licenses. I'd be foolish to ignore the chance to experiment with RAC at home for £150 (I had a lot of the kit already) rather than pay Oracle £1158 for a 3 day RAC course (plus the loss of 3 days income). Add on to that the amount I've learned about the linux kernel and the fact that frankly a firewire disk is just generally useful to have around (backups/temporary storage for video or music) and I think I'd be a mug to do otherwise. So no, I don't work for a company that needs this but in the near future I may. Cheers, Mike -Original Message- Sent: 11 February 2003 16:30 To: Multiple recipients of list ORACLE-L This is all cool technology, and fun stuff to play with. It all begs the questions, How many of us work for a business that actually need this? Are they willing to pay $400/user $20k/CPU above the cost of Oracle 9i EE to use it? Are they willing to pay the extra overhead required to maintain it? I'm not sure the ROI is there for many of us. Though downtime at our business is somewhat expensive, I think that a failover system or even standby database will provide adequate coverage for us, which is indeed a hot topic here right now, after our Dell SAN put us out of business for 36 hours. RAC wouldn't have helped much there. Niether would a cluster for that matter. Standby DB would have been perfect. This whole push of RAC by Oracle reminds me very much of the mlife phone campaign by ATT. Do you really need to take pictures with your phone? And what is the point of sending text messages to someone elses phone when you could just call them? ATT needs you to buy this stuff, because they have it for sale. I see RAC in a similar light. Do you need RAC? Oracle needs you to 'need' it, because they need some reason for you to spend more money on their product. Jared ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [new info] Redhat Advanced Server Dev Edition - RAC
Well u still probably can't(for production purposes) but for testing(which is what i want to do), its possible. I'm downloading right now, 4 600M+ iso images. hopefully next week will start messing with it and let you all know how it works out. Joe This is great! So how can we get a RAC configuration running for less 1000 dollars? :) Waleed -Original Message- Sent: Sunday, February 09, 2003 12:24 AM To: Multiple recipients of list ORACLE-L To those who are interested in running RAC on Linux. I know we have been talking about RAC on linux lately. This is great news Redhat has made a special developer's edition for their Advanced Server which only costs $60! So we don't have to shell out $699 for a copy of RHAS 2.1 to play with RAC. http://www.redhat.com/software/advancedserver/developer/ Have fun. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji 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: Khedr, Waleed 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recall: Oracle 9.2.0.2 performance problem
Mario, no can do, its already been deleted. joe Broodbakker, Mario would like to recall the message, Oracle 9.2.0.2 performance problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Broodbakker, Mario 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
quest shareplex
I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is). Anyone enlighten me. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Silent Installs and Response files...
I'd have to agree w/Jared, its more like vaporware ;) joe I've heard rumors of people getting it to work. Some have claimed they have. When asked to share their response files, I received nothing. I once spent several hours attempting to setup a working response file. No joy. It's in the same class as bigfoot: several sightings, but the only photos are faked. Jared Loughmiller, Greg [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/17/2003 06:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] cc: Subject:Oracle Silent Installs and Response files... Hey guys- Have any of you all messed around with the silent install/response files? I'm looking for tips, advice, do's, don'ts,etc,etc TIA Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE : RMAN Repository
Gene, i consider it a good redundancy method for recovery. put the repository on a 24x7 machine, that way if you lose all of the controlfiles you can still easily restore/recover. my 2 cents worth. joe This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. 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 files are 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 ORACLE- [EMAIL PROTECTED] cc: Subject:RE : RMAN Repository Joe, 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 PM To: Multiple recipients of list ORACLE-L snip 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.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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE : RMAN Repository
Paula, i like it and the respository, cause its just my anal- retentiveness coming out about having 2 places to easily be able to recover(the repository and control file). joe This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. I find it useful for organizing and keeping track of my backups so that during recovery it is as simple as running pre-scripted queries to see what I have available - geez am I the only one who likes RMAN and doesn't think it makes things that difficult - really? Robert Freeman - what say you? -Original Message- Sent: Thursday, January 09, 2003 11:25 AM To: Multiple recipients of list ORACLE-L 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 AM To: Multiple recipients of list ORACLE-L 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 files are 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 ORACLE- [EMAIL PROTECTED] cc: Subject:RE : RMAN Repository Joe, 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 PM To: Multiple recipients of list ORACLE-L snip 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 http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8 DBA with SAP Tax Tools experience needed- New York
No aliens foreign or outer space kind. snip another job position Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Orawomen
PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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 know immediately 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.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Full table scan error
Yea same here, column names, table names all on separate lines :) joe Personally, I always format queries before working with them, otherwise it is too difficult to determine what is being done in the query. Jared Glad to see a fellow maniac :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
Vikas, you need to read the docs also, you can have the logs automatically shipped and applied to the standby database, it all depends on how you set it up. the docs are a wonderful thing. joe Vikas Khanna wrote: Original Message- *From:* Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] *Sent:* Friday, April 19, 2002 2:33 PM *To:* Multiple recipients of list ORACLE-L *Subject:* STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? [Vikas Khanna] You have do transfer them manually to the standy by server. OR you can write automated scripts to do the job for you. And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . [Vikas Khanna] Its the max limit for the size of the file which this OS support. Even if you might have 8 GB RAM what depends is your SGA Size. . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: hi i'm back amongst the living
Yes next year back to orlando. joe Ron Rogers wrote: Come On Walt... I thought you installed Windozz first to allow the Oracle to install without a hitch and then upgraded your pc to Linux. Nt first, SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch up to 8.1.7.3, and if your lucky migrate to 9.0.1. When all is said and done and the database is working flawless you install the Linux release you desire. This way you eliminate the glibc and JDK patch for oracle's GUI installers. Is it correct that next year the IOUG conference will be in Orlando again??? I can afford it again.. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/19/02 12:33AM Joe, Glad you had a good time. Sorry I didn't make it, my company pulled funding at the last minute. As far as Oracle and Linux is concerned, I have a lot of experience. You have to install Linux first. That makes everything else a lot easier. --Walt Weaver Bozeman, Montana -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/18/2002 6:38 PM Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STANDBY DATABASE QUESTION?
Arslan, not exactly managed mode applies the logs, you need to setup the primary init.ora to have the shipped from primary site to standby site. joe Arslan Bahar wrote: yes , if you put in maneged mode , archived logs are copied and appled to standby site from master site. - Original Message - *From:* Bunyamin K. Karadeniz mailto:[EMAIL PROTECTED] *To:* Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] *Sent:* Friday, April 19, 2002 12:03 PM *Subject:* STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i Application Server
go to technet.oracle.com and look for documentation, its time for you to start reading :) joe Gagandeep Singh wrote: Greetings Gurus Im new to Oracle. Could you please tell me what is the difference between Oracle 9i and Oracle Application Server ? Regards, Gagandeep Singh -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
hi i'm back amongst the living
Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
technet download problem
is anyone else able to download anythning from technet, all i get is unable to find server errors. i dont think its a firewall issue as we dont block any ports. thanks, joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing Oracle 9.0.1 on Red Hat Linux 7.2
first time you get the error, open a new window go to $ORACLE_HOME/bin look for genclntsh vi the file, looking for -z defs, remove that part, the -z defs ./genclntsh then hit retry, all should be good. joe [EMAIL PROTECTED] wrote: If you have successfully installed Oracle 9.0.1 on Red Hat 7.2, please let me know what steps you had to take to make it work. I've installed the compatibility libs and glibc stub patch for Oracle 8i, and have successfully installed 8.1.7. The 9i install consistently fails on the ins_plsql.mk makefile. I'll check on MetaLink some more. And yes, I know 7.2 is not yet certified, but it appears from the forums on MetaLink that others have done this. Thanks, Jared -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fav. Urban Legend...
init.ora parm: _MAKE_SQL_RUN_FASTER= valid values: 8.0 = true/false 8.1 = x where x is a number between 1 and 100 9.0 = x or unlimited -- this gives you the ultimate speed in queries joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Now: IOUG : Was: PocketDBA
But they're laptops with working batteries :) joe Deshpande, Kirti wrote: How about a seat near the power outlets ?? Then, it will be a fun experiment for Joe Susan ;) I will be doing my first ever presentation at IOUG-A.. Just a Quick Tips (Q31) - Wait Events in a Nutshell.. (bring your lunch with you, if they allow it :) All Quick Tips Sessions are during lunch period... - Kirti -Original Message- Sent: Thursday, March 07, 2002 7:13 AM To: Multiple recipients of list ORACLE-L and this one doesn't really conflict with anything I want to see. gotta get there early to get a seat in the front row so I can heckle better :) --- Joe Testa [EMAIL PROTECTED] wrote: yeppers i'll be there and (he crosses his fingers) if all goes well in our testing(Susan and I) for the data guard presentation, we hope to do a switchover and possibly a switch back in the demo part. We'll have 2 laptops each running linux and 9i connected by a hub. This should be a fun experiment if nothing else. :) joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT Help on tracking unauthorized login to Oracle Database
Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Call for Presenters(July/Oct 2001)
As a past President of Ohio Oracle Users Group, I still volunteer with our local user group and my current task if to ask you Oracle experts about presenting at our group. We are looking for presenters for out July 15th meeting. If you're interested in coming to Columbus OH for present, kindly let us know what your topic would be and the board will meet to choose and notify the people chosen. We are also looking for presenters for our Oct Meeting, if you're interested in that we'd like to see an abstract(50 words maximum). Please send all info to [EMAIL PROTECTED] or [EMAIL PROTECTED] Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Where does a DBA go from here?
Definitely #6. I've learned more from conferences that anywhere else. If nothing else you get to drink with the people from the list :), i' ll be at IOUG. joe Jesse, Rich wrote: OK, from the responses, here's The Plan: 1) Get beer. I prefer Guinness or Goose Island. Done. 2) Get Oracle Perf Tuning 101. Done. 3) Get more beer. 4) Beat up on some test DBs, and work on real live DBs to engrain that class material into the surviving brain cells (see Step 1). Sorta done with this one, but I need more. The 22 DBs here at work and 1 at home ought to help! 5) Get more beer. 6) Go to Oracle conferences. I need to go 7) Get more beer. 8) Hit the web, preferrably with beer in non-mouse hand. (Wisconsin twin-can beer hat optional) 9) Go to Internals class and actually understand and learn from it. Yay! 10)Get lots more beer. 11)Actually do some work here. Sounds good folks. I think I'm on the right track (sans beer at work, of course), with my Oracle course work completed over a year ago, and some DBA experiences under my belt. Time to plunk away at more DBs! Thanks! :) Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA President, Beer Ale Lager Lovers Society http://www.westbend.net/~legoman -Original Message- Sent: Friday, February 08, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Rich, The best Oracle training I've ever had by far is playing around with a small test DB on a laptop or PC. Stress it, hurt it, recover it, tune it, etc., etc. When done in conjunction with one of the fine books mentioned by others on this list - even better. I've only had one official Oracle training course - in the spring of 1989. It was 4-1/2 days of RDBMS v5, SQL*Forms and RPT/RPF. Since then I've attended some of the mini courses at IOUG, ODTUG, Open World, etc. - nice little hits of the latest technologies. I studied for my Oracle8 OCP exams by working through Jason Couchman's book and beating up an 8.0.5 DB on my PC - learned a hell of a lot. My on-going study plan for Oracle skills boils down to Beating, Browsing and Books. - Beat up a test database - Browse fine Web sites like Steve Adams' IXORA (and beat up the DB) - Buy and read good books (and beat up the DB) I think I've learned about as much as if I'd sat in a bunch of classes - and saved a pile of money. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cost based optimizer
explanation: what i've found is cost has absolutely no bearing on anything, a relatively useless number. joe Baylis, John wrote: I have a table of 500,000 records that is analyzed and contains several indexes that are analyzed. Can someone explain to me why the cost without a hint is much lower than the cost with a hint? Using a hint is 10 times faster than without a hint even though the cost is much higher. Since this is a third party app, I cannot add hints. What aoptions do I have? select /*+ Index(ICMSSHDR XSKSHDRS181M1) Use this index XSKSHDRS181M1 */ PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=213529 Card=228346 Bytes=12102338) 10 TABLE ACCESS (BY INDEX ROWID) OF 'ICMSSHDR' (Cost=213529 Card=228346 Bytes=12102338) 21 INDEX (RANGE SCAN) OF 'XSKSHDRS181M1' (NON-UNIQUE) (Cost=2346 Card=228346) select PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3526 Card=228346 Bytes=12102338) 10 TABLE ACCESS (FULL) OF 'ICMSSHDR' (Cost=3526 Card=228346 Bytes=12102338) Thanks *John Baylis* D atabase Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT Help on tracking unauthorized login to Oracle Database
I stand by my original statement, look at auditing unsuccessful connections. joe Mandal, Ashoke wrote: Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Call for Presenters(July/Oct 2001)
Doooh, who's a doofus and went thru a time/space continuum. July/Oct 2002. thanks, joe Deshpande, Kirti wrote: Just too darn late for July/Oct 2001 ;) - Kirti -Original Message- From: Joseph S Testa [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: Call for Presenters(July/Oct 2001) As a past President of Ohio Oracle Users Group, I still volunteer with our local user group and my current task if to ask you Oracle experts about presenting at our group. We are looking for presenters for out July 15th meeting. If you're interested in coming to Columbus OH for present, kindly let us know what your topic would be and the board will meet to choose and notify the people chosen. We are also looking for presenters for our Oct Meeting, if you're interested in that we'd like to see an abstract(50 words maximum). Please send all info to [EMAIL PROTECTED] or [EMAIL PROTECTED] Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Removing data form a table
truncate wont work? joe Lance Prais wrote: I want to create a procedure the drops all the data from a table. I was trying to drop table then create this proved to be extremely complicated in Oracle. I think the above route is much better. Does anyone know how to do this? Lance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Common Oracle RDBMS Misconceptions
Well i dont know about everyone else, but i knew thats how the hot backup worked, but then again, i've not attended oracle education classes either, just some hard core reading and have gotten all of my backup/recovery concepts from Rama Velpuri's book. An excellent book if you dont have it. joe On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained If this is true then I may be a victim of a disease called 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK style) Please help me. If some one has few more articles like this enlighten me -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Public synonyms
Audrey time to break out the oracle docs and start reading. look in sys.dba_synoyms. thats was your freebie ;) joe Andrey Bronfin wrote: Dear all ! I have an empty schema named AAA . select * from obj returns 0 rows . When i do select * from some_table , rows are returned . I guess that some_table is a public synonym . How can i verify it ? How can i see in which schema is it defined ? Thanks a lot ! Andrey. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i on redhat 7.0 --help me
you need to get rh 7.1 whic is kernel 2.4 and run theupgrade, its pretty easy anymore, it even tells you if u dont have enough space. email me at [EMAIL PROTECTED] a telephone number(assuming you're in the US) and we can talk if you want. making it happen on RH since its not certified was not plug in the cd and let it go, the redhat upgrade is easy making oracle work was not nearly as simple. joe novicedba wrote: Hi, install.pdf reads Operating System: Oracle9i is certified on SuSe 7.1, Kernel 2.4.4 and the operating system library GNU Lib C 2.2. I have Redhat 7.0 with kernel 2.2.16--22 I think I need to upgrade my kernel to 2.4.4 but don't know how to, redhat site doesn't give great info nor did google help. Can someone help me with step by step instructions. I am new to Linux, but thanks to http://jordan.fortwayne.com/oracle/8161.html site was able to install both 8.1.6 and 8.1.7 without much of a problem. I am new to Linux so please so not use heavy technical terms please help thanks in advance -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need help getting started
Viraj, hahahahah, it couldnt have been said any better :), i've been thinking that way for years as well as a few others on the list :) joe Viraj Luthra wrote: I dont want to sound rude here, and my comments are NOT directed at you personally. What is the standard of these OCP's, when a person who has not worked with oracle, can pass them, for the sake of discussion it does not matter which tests they were? It seems doing an OCP is a complete waste of time! -- -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i onlinux, the continuing saga
Ok most of last night putting it on laptop, be prepared for what seems like eternal swapping if you dont have the RAM, toshiba satellite 2545xcdt laptop, amd k6, 333Mhz, 192M of ram. It finally installed. Now to hack genclntsh, relink the binaries and build a database. :) joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT - interviewing your superior(fun question)
Ok i'll throw one in for fun: Are you willing to give me a 25% pay increase every year regardless of state of the company? Joe Daniel Curry wrote: I am in a position to interview candidates who will ultimately be my boss. I am the net admin in a mixed Unix/Win/Linux environment, with Oracle databases, but no DBA (very simple databases). My question is for 'example' questions to ask these guys to get a full grasp of their management styles, political abilities, technical competencies, etc. Any suggestions would be useful. Thanks. Daniel Curry Systems Administrator CGtime, Inc. 625 Second Street -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
status of oracle 9i install on red hat linux
machine: celeron 450Mhz, 256M of ram, 512M of swap. it installed, yea. Here are the problems: 1. do not even attempt to run the gui tools(dbca, netasst) with the install, it will bomb. 2. none of the binaries will link, just click ignore for all of the errors, we will deal with them later. 3. after you've got the binaries installed: $ORACLE_HOME/bin/genclntsh will need edited. follow instructions for installing 8.1.7 on rh 7.1. I've got the link book marked and for those of you w/o metalink let me know and i can paste the important parts. :) 4. run genclntsh according to the instructions. 5. then attempt relink all, mine errored out, i did a relink of each component, hint: if you type relink by itself it will show you the options. 6. run dbca to build skeleton scripts to build a database. thats as far as i got at 3AM when i went to bed(some 3.5 hours ago), building the database tonite, I'll keep everyone posted. if this all works, i'll be attempting on my 192M laptop :) joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i On Linux
because $61 doesnt do any good with a laptop that will only hold 192M :) joe Christopher Spence wrote: When you can buy 512Mb for $61 on the net, who cares :) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 15, 2001 6:00 PM To: Multiple recipients of list ORACLE-L A minimum of 128M on the client??!! Who do they think they are?? Microsoft? -Original Message- Sent: Friday, June 15, 2001 3:02 PM To: Multiple recipients of list ORACLE-L From Linux release notes: http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf The following requirements must be met to perform a typical Oracle9i software installation. Memory: A minimum of 512 MB of is required to install Oracle9i Server. A minimum of 512 MB is required to install Oracle9i Management and Integration. A minimum of 128 MB is required to install Oracle9i Client. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 15, 2001 4:20 PM Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? Thank, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: re-create Scott's schema
in 8.1.7 $ORACLE_HOME/rdbms/admin/utlsampl.sql joe David Jones wrote: Dear Listers: Does anyone know any SQL script to re-create Scott's schema ? Thanks for any insights and helps. --dj _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
yes, except that i'm one of those sick pups that reads the docs. joe Thater, William wrote: On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: -Well afetr reading the docs about logminer in version 9i, maybe i can get -one more year worth of presentation out of it. - -it tracks and displays DDL :) - - -useless trivia question(i know the answer) :) - - -So what do you get with the new datatype: timestamp bored?;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
good question about the logminer version, its probably logminer 9i :) bring the mining hat, batteries will be supplied :) joe Deshpande, Kirti wrote: Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti -Original Message- From: Joseph Testa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:52 PM To: Multiple recipients of list ORACLE-L Subject: logminer in the 9i world, etc Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
Paul, it didnt get picked up for the IOUG live 2001. I've bored the local user group to death with logminer(as well as alot of other people i'm sure). I'll make sure you get you a copy of it in jul. joe Paul Drake wrote: Joe, I didn't get to see the advanced logminer presentation at IOUG-A. - is that one 201? - any chance of seeing it at your user group meeting in July? - does it exist in print anywhere? Paul -Original Message- Sent: Tuesday, June 12, 2001 6:05 PM To: Multiple recipients of list ORACLE-L Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti -Original Message- From: Joseph Testa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:52 PM To: Multiple recipients of list ORACLE-L Subject: logminer in the 9i world, etc Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
Linda, yes list admin send her a prize :) joe Seley, Linda wrote: Oh oh, wild guess milliseconds? -Original Message- Sent: Tuesday, June 12, 2001 4:05 PM To: Multiple recipients of list ORACLE-L yes, except that i'm one of those sick pups that reads the docs. joe Thater, William wrote: On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: -Well afetr reading the docs about logminer in version 9i, maybe i can get -one more year worth of presentation out of it. - -it tracks and displays DDL :) - - -useless trivia question(i know the answer) :) - - -So what do you get with the new datatype: timestamp bored?;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT - SSN( Enforced Constraints (sic) ??
://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
yes according to the docs. joe Hillman, Alex wrote: Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
well i'm basing my statement on the docs(which isn't much i know) but as soon as its on a platform i can use, i'll tets it out and let everyone know for sure :) joe Nick Wagner wrote: Either way... I tried it with 9.0.0.0.0 beta 3 and I got the normal DML to work just fine. However I could not get the DDL to work.. I set the parameters just like the doc says, but all my DDL queries just seamed to go out to lunch on me... My log files were very small for the testing... 5 MB files, and I only did 3 DDL statements... anyone else have this problem. Nick -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: logminer in the 9i world, etc The question should be, Can it undo DDL? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 12, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: MacGregor, Ian A. 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rollout of DB changes to production...
Rich, i'm with you. dropping a column can be extremely time consuming depending on number of rows. just go ahead and add the cols to prod, if you need to back it out, mark them unused and then drop them during a slow time(i know you're 24x7 but look when its the slowest, 3AM?). joe Richard Huntley wrote: I'm just wondering if the best way to handle a rollback of added columns is to alter the table to mark the column as unused and then drop the unused columns via ALTER TABLE t1 DROP UNUSED COLUMNS; or would the ideal thing be to export the table(s) before adding the columns and then reimport, although that could get very sticky since I'd be dealing with the whole table and associated constraints instead of just the columns I'm trying to remove. I basically want to have both a rollout and a rollback script for an upcoming rather large move to production. Your input would be greatly appreciated. TIA, Richard Huntley E-mail: [EMAIL PROTECTED] -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trouble.. Standby Database. Urgent!!
has log 505 made it over to the standby yet, you should start reading the docs, if log 505 is not there yet, than that is the way its SUPPOSED to work. joe Saurabh Sharma wrote: hi all, I need ur help urgently. i've created a standby database with the below mentioned steps.. 1. copied consistent backup of datafiles folder to standby site. 2. created standby control file and sent to target location. 3. switch logfile current and copied to target. 4. copied init.ora and changed parameters for standby. at the standby site. 1. startup nomountok 2. alter database mount standby database. ok 3. recover standby database ... this last recovery statement is giving lot of msgs like..log applied.. then same logfile not needed for this recovery. can not open file..etc. I'm copying the archived log from primary to standby standby_archive_dest location. here are the actual errors.. SVRMGR recover standby database; ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for thread 1 ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 ORA-00280: change 708915 for thread 1 is in sequence #505 Specify log: {RET=suggested | filename | AUTO | CANCEL} auto ORA-00308: cannot open archived log 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating and Oracle 7 DB from an Oracle 8 DB
why not run version 7 export against the oracle 8 database(its been more than 4 years since i've played with a 7 database). or am i missing something here? joe Tim Allen wrote: Hi, Its a long and boring story but I have an Oracle 8 database and I need to create an Oracle 7 database from it to support one of our applications. The schema of the Oracle 8 db does not have any oo features and is, in theory, it functionally compatable with an Oracle 7 db. But I understand that there are issues with using export from oracle 8 and import to oracle 7, I.e it is incompatable. Has anyone had any experience in doing this or any suggestions on ways of doing it? And by the way the data in tables needs to be copied from 8 to 7 also. Cheers Tim Allen Designer Ramesys (Professional Services) Ltd ( Phone: 01788 822133 . Fax: 01788 822144 + Address: Eldon Way, Motorway Ind. Estate, Crick, Northants, NN6 7SL * E-mail : [mailto:[EMAIL PROTECTED]] [ The views and opinions expressed in the email are the sender's own ] [ and do not necessarily represent the views and opinions of Ramesys LTD ] -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Serious Question (believe it or not)...
Hey, i resemble that remark, damn, i wasnt supposed to tell anyone i was certified. I'm going to indulge in hostess snack cakes as a punishment. joe Mohan, Ross wrote: Alex, The answer to your question is: get several certifications and become a consultant! grin, duck, and run like hell Ross p.s. anyone certified (or certifiable) who is deeply wounded by this senseless attack is encouraged to contact me offlist, where I will supply a heartfelt apology, a few hugs, and an autographed picture of my Hannibal Lecter in a speedo with a ponytail impersonation. -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent regarding server manager..
1. upgrade to unix 2. start using sqlplus instead of server manager, its going away joe Saurabh Sharma wrote: hi all, i want help regarding automation of connecting to server manager through script file. i want when i run script, it automatically launch svrmgr program and simultaneously pass the connect string so that it gives me svrmgr connected. while passing the connect string along with svrmgr80 command at c prompt results in msg too many parameters.. can anyone help getting me started. thanks in advance. saurabh -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function index for like '%string%'
good question, i've not tried any intermedia/context stuff. any experts out there? Joe Thater, William wrote: On Fri, 1 Jun 2001,Joseph S. Testa scribbled on the wall in glitter crayon: -i spent about a week about 6 months ago looking for something to fill -that possibility to no avail. dumb question would a contex... oh excuse me InterMedia index work? - -joe -Rachel Carmichael wrote: - - she knows why it isn't being used. What Suzy wants to know (and I do too, - because I have a similar situation) is if there is a way to create an index - that will let you search with the like clause. - - Unfortunately my gut instinct is that you can't make Oracle do that - - From: Hillman, Alex [EMAIL PROTECTED] - Reply-To: [EMAIL PROTECTED] - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] - Subject: RE: function index for like '%string%' - Date: Fri, 01 Jun 2001 14:11:08 -0800 - - index is not used because you have leading % in the like predicate. - - Alex Hillman - - -Original Message- - Sent: Friday, June 01, 2001 5:09 PM - To: Multiple recipients of list ORACLE-L - - - - I've created a function index for lower(column_name). However the query - does - a like comparison rather than equality so the index isn't used. Is there a - way to create a function index for this? - - Here's the index and query: - - create index fx1_auth_users - on auth_users (lower(current_email) - tablespace app01_midx ; - - select current_email from auth_users - where lower(current_email) like '%datsit.com%' ; - - Thanks much, - Suzy - -- - Please see the official ORACLE-L FAQ: http://www.orafaq.com - -- - Author: Suzy Vordos -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 - - - - -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ MIPS: Meaningless Indicator of Processor Speed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Point in Time recovery required !!
Vikas, email me direct a number to call you and we can chat about logminer and whether it can help you or not. joe Vikas Kawatra wrote: Our developers need the dbs to be restored to 6 am today morning - as they deleted some important table. Now we have no EXPORTS , the dbs is in archive mode - so we though it would be easy to restore and do a point in time recovery - only to find that our backup guy had configured the tapes to be overwritten - so we have no HOT backup now ... We have no cold backups - I'm trying to figure out if we can use the LOGMINER - to do any recovery !! Any Suggestions /help would be welcome !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Point in Time recovery required !!
Vikas, re-reading your note, it appears you have tables that were dropped? logminer will not help you in that respect(at least not until 9i, when you have undo tablespaces and query flashback). joe Vikas Kawatra wrote: Our developers need the dbs to be restored to 6 am today morning - as they deleted some important table. Now we have no EXPORTS , the dbs is in archive mode - so we though it would be easy to restore and do a point in time recovery - only to find that our backup guy had configured the tapes to be overwritten - so we have no HOT backup now ... We have no cold backups - I'm trying to figure out if we can use the LOGMINER - to do any recovery !! Any Suggestions /help would be welcome !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: On the question of What is a Large Database Anyway ?
great hope you got it all. joe Vikas Kawatra wrote: Thanks for the offer to help ! I just completed log mining the data successfully - from the archive logs - I was able to generate the UNDO SQL and execute it on the dbs to bring it to a state prior to the updates/deletes etc on the table thanks vikas -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function index for like '%string%'
i spent about a week about 6 months ago looking for something to fill that possibility to no avail. joe Rachel Carmichael wrote: she knows why it isn't being used. What Suzy wants to know (and I do too, because I have a similar situation) is if there is a way to create an index that will let you search with the like clause. Unfortunately my gut instinct is that you can't make Oracle do that From: Hillman, Alex [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: function index for like '%string%' Date: Fri, 01 Jun 2001 14:11:08 -0800 index is not used because you have leading % in the like predicate. Alex Hillman -Original Message- Sent: Friday, June 01, 2001 5:09 PM To: Multiple recipients of list ORACLE-L I've created a function index for lower(column_name). However the query does a like comparison rather than equality so the index isn't used. Is there a way to create a function index for this? Here's the index and query: create index fx1_auth_users on auth_users (lower(current_email) tablespace app01_midx ; select current_email from auth_users where lower(current_email) like '%datsit.com%' ; Thanks much, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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 -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00904
dealt with that one this week on aix platform. a couple of things can cause it. 1. an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp. 2. using a version of export that is not compatible with the database(no one flame me for this, it was on metalink). if you want moer into on the error, let me know, i'll go and get the doc id from metalink so you can look it up. joe PHU,JULIA (HP-Sunnyvale,ex2) wrote: Greetings, I'm lost on the 'ORA-00904: invalid column name' error message. Can someone shed some light on it? It is 8i on NT box with sp6a. Regards, Julia Phu -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00904
I dont necessarily recommend it but thats whats in most release notes for patches sets, so I tend to follow the instructions oracle gives in most cases :) Joe PHU,JULIA (HP-Sunnyvale,ex2) wrote: Hi, Joe, 'an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp.' Do you recommend to run catalog, catproc, catrep, and utlirp? I looked up a doc in Metalink and couldn't resolve my problem. Perhaps I looked up the incorrect one. Please send me info if you will. Thank you. Julia -Original Message- Sent: Saturday, May 26, 2001 6:00 AM To: Multiple recipients of list ORACLE-L dealt with that one this week on aix platform. a couple of things can cause it. 1. an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp. 2. using a version of export that is not compatible with the database(no one flame me for this, it was on metalink). if you want moer into on the error, let me know, i'll go and get the doc id from metalink so you can look it up. joe PHU,JULIA (HP-Sunnyvale,ex2) wrote: Greetings, I'm lost on the 'ORA-00904: invalid column name' error message. Can someone shed some light on it? It is 8i on NT box with sp6a. Regards, Julia Phu -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: svrmgrl error
look at relinking the svrmgrl executable, ensure there is no 7.3 libraries in path BEFORE the 8.x libs(assuming an 8.x database). you got metalink, search for it, i'm 90% sure its on there. joe Leyden, Joseph wrote: Has anyone seen this error and found what the solution was? Hoping for a long shot here Joe $ svrmgrl exec(): 0509-036 Cannot load program svrmgrl because of the following errors: 0509-130 Symbol resolution failed for /usr/lib/libc_r.a(aio.o) because: 0509-136 Symbol kaio_rdwr (number 0) is not exported from dependent module /unix. 0509-136 Symbol listio (number 1) is not exported from dependent module /unix. 0509-136 Symbol acancel (number 2) is not exported from dependent module /unix. 0509-136 Symbol iosuspend (number 3) is not exported from dependent module /unix. 0509-136 Symbol aio_nwait (number 4) is not exported from dependent module /unix. 0509-192 Examine .loader section symbols with the 'dump -Tv' command. oracle@totspt: /home/oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cdump, bdump, udump
read the tuning guide and the administrators guide. nowadays this is a valid answer now that oracle docs are online, NO ONE HAS AN EXCUSE to not read the docs unlike back in the days when you had to pay thousands of dollars for paper docs. joe Venkat_Kalepalli wrote: Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meeting at IOUG
I'll be there. Joe Murali Vallath wrote: Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle DBA
kewl, a new person to add to my recruiter killfile :) joe "Richard T. Vander Laan" wrote: Des Moines, IA firm is looking for a strong Oracle DBA candidate with Discoverer, Express, SQL, SQL*Plus, PL/SQL, Portal, and other skills experience. Salary is open DOE. Excellent company with great benefits. Permanent position Send resumes to Richard Vander Laan at [EMAIL PROTECTED] -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery from noarchive db corrected
assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Re: Metalink Again, tandy computers
Anyone besides me remember the old tandy computers? my first computer: TRS-80 Model III, 16K of ram, used to program it using assembler, i think the package was called "edasm"?, no disk drive(too expensive), cassette tape player, 50 baud :) joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: RANT ABOUT OCP, Re: Small help
Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Exp Imp Overwirte posiible or not?
truncate is not an option? Joe [EMAIL PROTECTED] wrote: Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent objects. Is it possible with exp , imp utilities or i have to delete data first and then import using imp utility. Is there any other possibility... Environment Oracle8i, Windows NT4 TIA Azhar Siddiq -- 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: changing db_block_size
last i checked that was your only choice, anyone like to flame me for that statement :) joe Roy Ferguson wrote: all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: New born DBA.....
start by reading the administrators guide and welcome to the world(Dr DBA slaps the bottom side of the newborn) :) joe Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Conversion of man (unix) into Txt file
To get a plain text version of a man page, without backspaces and underscores, try # man foo | col -b foo.mantxt joe Gregory Conron wrote: On Sun, 18 Mar 2001, chandan wrote: Hi All, Does anyone know how to convert unix MAN into a text file ? -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: STARTING A HOLY WAR: about NT versus unix Re: Java pools and 8i --
thats cause NT sux joe "Shaw, John B" wrote: I dropped mine to 1M and had export problems - support had me raise to 20M and export started working again (NT) -Original Message- Sent: Thursday, March 15, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Hi, We've got an 8.1.6 DB running on HP/UX. I created a java pool because I didn't know if something in the 3rd party software would use Java code. Well, it doesn't. So, is there any reason to keep ANY java pool? It's at 30MB right now. I was gonna drop it to 5MB to be conservative, but if I don't need that, why take up the RAM. TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script to know the size of each table in a schema ?
cess / 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LONG: Re: Order of table_name resolution
My apologies to all by NOT denoting i ripped that entire piece out of the 817 docs. apps devleoper guide, chapter 2, schema maintenance. joe Jacques Kilchoer wrote: -Original Message- From: Joseph Testa [mailto:[EMAIL PROTECTED]] Due to the possibility of synonyms, the following rules are used to resolve a name in a context that requires an object in the table namespace: etc... That was an excellent post Mr. Testa. My chapeau goes off to you. Also it seems that Oracle keeps track of the names it goes through when doing synonym resolution, as the example below shows: SQL create synonym x for y ; Synonym created. SQL create synonym y for x ; Synonym created. SQL select * from x ; select * from x * ERROR at line 1: ORA-01775: looping chain of synonyms -- any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EE on NT problem (on and off network) ???
Leslie, this one messed with ALOT of people for a long time, my boss over New Years even figurd it out. check out you sqlnet.ora file, look at the(i think it was) sqlnet_authentication.services or something like that, he just commented it out and poof it worked. Rachel, since I told you about it, do you remember what it was? joe Leslie Lu wrote: Hi all, I installed 815 EE on NT 4.0 on a laptop and created a testing database (did both while I was on network.) I can connect to the database without problem, while remain on network. However when I'm off the network, I cannot connect to the database. I got: ora 12570: TNS: packet reader failure ora 12571: TNS: packet writer failure It's a demo project for marketing people, and most probably they might not be able to connect to the network (in the plan or on the beach). So I really need the db to run locally. Any idea, thanks a lot. Leslie __ -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Fwd: Re: EE on NT problem (on and off network) ???]
yeppers thats the one, and yes ur correct about the listener thing. :) Joe Paul Drake wrote: Joe, do you mean change the line in the sqlnet.ora file from SQLNET.AUTHENTICATION_SERVICES = (NTS) to SQLNET.AUTHENTICATION_SERVICES = (NONE) It still sounds like if the listener is configured with the machine's host name, and that host name was resolving to the IP address bound to the network adapter (not a loopback address, e.g. 127.0.0.1) when the network connection is severed, so is the sql*net connection. How about using a bequeath connection, instead? Paul Original Message Date: Tue, 13 Mar 2001 16:35:50 -0800 Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Leslie, this one messed with ALOT of people for a long time, my boss over New Years even figurd it out. check out you sqlnet.ora file, look at the(i think it was) sqlnet_authentication.services or something like that, he just commented it out and poof it worked. Rachel, since I told you about it, do you remember what it was? joe Leslie Lu wrote: Hi all, I installed 815 EE on NT 4.0 on a laptop and created a testing database (did both while I was on network.) I can connect to the database without problem, while remain on network. However when I'm off the network, I cannot connect to the database. I got: ora 12570: TNS: packet reader failure ora 12571: TNS: packet writer failure It's a demo project for marketing people, and most probably they might not be able to connect to the network (in the plan or on the beach). So I really need the db to run locally. Any idea, thanks a lot. Leslie __ -- -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ScanMail Message: To Sender, (OT)
Where do you let corporate draw the line, before long you'll see no email, cause you can take damn near anything out of context. joe "Hand, Michael T" wrote: Joe, Cohorts, Look at it from the other side. If I worked in a Corporate legal office and was aware of filtering technology, I would insist it be used. The current legal climate in the US where employers are sued at the drop of a hat over sexism, racism, ageism and any other -ism you can think of would require nothing less. And I don't have to get into who really owns the e-mail do I? I'd be harder on the sender (sorry Dick) than on the employer who rejects on content. Mike -Original Message- Sent: Thursday, March 08, 2001 5:16 PM To: Multiple recipients of list ORACLE-L I don't know but i vote for them to be removed from the list, when i work for a compnay that starts screening my email for me, i'll quit thats for sure. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re-claiming the space from Table after deleteion
sounds like a candidate for partitioning. joe [EMAIL PROTECTED] wrote: Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re-claiming the space from Table after deleteion
yea in the table but not the index, since unless you put the exact same value for the row the index leaf node will NOT be reused, hence my statement about the partitioning. Joe William Beilstein wrote: Also is this really a problem. In the next month you are going to import more rows which will use the deleted space anyway. "Joseph S. Testa" [EMAIL PROTECTED] 03/09/01 07:17AM sounds like a candidate for partitioning. joe [EMAIL PROTECTED] wrote: Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT, i'Messing with the scanner :Re: ScanMail Message: To Sender,
sex harrass bite F*$% etc. lets see if that gets screened -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ScanMail Message: To Sender, sensitive content found and
I don't know but i vote for them to be removed from the list, when i work for a compnay that starts screening my email for me, i'll quit thats for sure. the place i work for, i know the admins and they dont do that kind of garbage. joe [EMAIL PROTECTED] wrote: OK, who have we got who works at Ge Capital? Dick Goulet Reply Separator Author: System Attendant [EMAIL PROTECTED] Date: 3/8/2001 2:22 PM Trend SMEX Content Filter has detected sensitive content. Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED] Sender = [EMAIL PROTECTED] Subject = Re:RE: Life in New England Delivery Time = March 08, 2001 (Thursday) 12:22:24 Policy = Sexual Discrimination Action on this mail = Quarantine message Warning message from administrator: Notice: A message you sent appears to have violated GE Financial Assurance email policies for inappropriate language or content and may not have been received by the recipient. -- 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What or who is PUBLIC?
public, a role built when the create database statement is executed (its in sql.bsq). what else would u like to know about it? joe "Smith, Ron L." wrote: Can anyone point me to a paper or explanation of the Oracle role? called PUBLIC? How do you manage permissions for PUBLIC? Ron Smith Database Administration [EMAIL PROTECTED] -- 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script from heaven
start by reading the docs on dba_* views. joe [EMAIL PROTECTED] wrote: Hi guys, I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data dictionary view, do you have any scripts to share such as to display redologs, tablespaces, earlier potential problems detection? Thank you so much.. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Licensing
Oracle has been riding the concept of "we're oracle so you want to use our database" for a long while. I'll be one of the last to condone sql-server(as i've recently had to work with it for a client, and i talked up oracle for a while) but Mr Larry is losing market share, check out any of the financial stories about ORCL. The problem with M$ sql-server is its just not as scalable as oracle(yet). Think about it with the power unit concept its becoming too damn expensive except for the high-roller fortune 250 companies. I need a playgound to test new options, etc, if the whole technet thing did not exist, i'd never pay the price for the database just to experiment. my .02 is the whole power unit thing is a good concept but the $$ per unit is way outta whack. the only reason i say that is its been hard for oracle to denote when people were using more than the licenses they bought were being used. I had always setup the databases with the v$license parms setup in the database. But sometimes damagement "required" me to "uplift" the limits. We'll leave it at that. joe Tom Schruefer wrote: As luck would have it I was evaluating the prices of Oracle and then SQL Server today. My question at this point is, what kind of prices does Microsoft charge for support, I was pretending to purchase SQL Server and noticed that no mention is made about product support. Using the "Power Unit" method MS and Oracle come out within about $5k of each other, but when you get to their Enterprise editions, MS is just under $20k where as Oracle is way out there. The cheaoest I could get Oracle, with unlimited users (which is what I need). On a 1ghz Intel, single processor machine with a 2 yr lic, Oracle Enterprise costs $45,600 (thats if you want support with your DB). If it were my money $20k vs. $45k+, hummm. I'm no Friend-of-Bill, but one has to wonder how Oracle can compete with such a huge price difference. Is MS doing to Oracle what it did to Netscape and dozens of other companies? Tom Martin Kendall - [EMAIL PROTECTED] on 3/5/2001 4:45 PM writes us: I'm following this thread and a worrying thought has crossed my mind:- If Oracle carries on with this pricing model, soon we will all be looking for a new job..scary :-) Martin Kendall -Original Message- Sent: 02 March 2001 22:00 To: Multiple recipients of list ORACLE-L Last time I danced with our sales rep, power units were per server, not per user... so the power unit price would be 400*100 = 40,000 for an unlimited (Ha! at 200mhz?) number of users. If you ask nicely, yours may agree to convert any concurrent or named user licenses you have into power unit credits. Dennis Taylor wrote: At 06:25 AM 3/2/01 -0800, you wrote: the mire. At any rate, there are suppose to be two basic licensing schemes, and GOD only knows how many "allowed" permutations: 1) Power Units which equates to the number of processors times the speed of the processors in Megahertz. Oh, BTW: it matters if their Intel or Risc processors too. Risc processors are more expensive. In general this is the MOST expensive way to go. I went to the oracle site and did some calcs for adding users to Oracle Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of megahertz". Anyway, for a very behind-the-curve system (2x200mhz ppro's), it works out to $4000 per additional user. Or I can look at Interbase/Firebird, which is free. Today I will be assigning one of my staff the task of downloading, installing, and evaluating Firebird. The only way I can imagine that Oracle thinking can be going is: "Hey, revenues are dropping because of competition from free and less expensive dbms's". "No problem. Raise prices to make up the shortfall". Then I say to myself, "Naw, no-one can be that stupid". Then I check the per-user prices again Dennis Taylor Good we must love, and must hate ill, For ill is ill, and good good still. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACL
Re: Woohooo An ORA-600
As i sat around and read the kernel source code(hahaha just kidding, although some days it would be easier to do that than work with metalink), here is what metalblank came up with: Note:109595.1 ALERT: ORA-04045 and ORA-600 [4882]on startup after applying 8.1.6.1.x patch Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-MAY-2000 Last Revision Date: 31-OCT-2000 Language: USAENG ORA-04045 and ORA-600 [4882] on startup after applying 8.1.6.1.x patch to 8.1.6.x or upgrading from 8.1.5.X to 8.1.6.0.0 ~ Versions affected ~ Oracle 8i 8.1.6.0.0, patch 8.1.6.1.x Platforms Affected ~~ ALL Description ~~~ After upgrading to 8.1.6.0 or applying 8.1.6.1.x patch, ORA-600 errors may appear in the alert.log file. Likelihood of Occurrence This will occur everytime a database, with Java enabled, is upgraded from 8.1.5.X to 8.1.6.0.0 or patch 8.1.6.1.x is applied. Symptoms After the upgrade, every startup or shutdown of the database may report the following to the alert.log: ORA-04045: errors during recompilation/revalidation of SYS.AURORA$SERVER$STARTUP ORA-00600: internal error code, arguments: [4882], [52571764], [67355404], [52438196], [], [], [], [] (the arguments of the ora-600 after the 4882 may vary on your system) Workaround ~~ No current workaround known. Please note this is a non-blocking ORA-600 error that does not affect the database internals, nor does it affect data integrity. Patches ~~~ No patch available at the moment. Solution scheduled for 8.1.6.2 patchset NOT SURE IF THIS IS YOUR PROBLEM FOR SURE, if you want, send me the trace file. Joe Mark Leith wrote: Hi Guys gals, Today - I got my very first ORA-600 error - Who, I tell ya guys I'm so excited.. lol.. Now Because this is a test instance I don't really give a stuff whether I lose it or not, it seems to be up and running just fine, without any real problems. The only annoyance with having to rebuild it is having to set it all up again, as I don't back the damn thing up : Now I'm not even going to even try and log on to "Megablank" to look this up, and lowly little me couldn't get access anyway: so I thought I would field this one to the list to see if any of you guys have seen this version of the fabled error before, so here it is: Errors in file C:\Oracle\admin\SALES\udump\ORA00520.TRC: ORA-00600: internal error code, arguments: [4882], [48415556], [97653212], [48293020], [], [], [], [] Tue Mar 06 09:02:09 2001 Errors in file C:\Oracle\admin\SALES\udump\ORA00520.TRC: ORA-04045: errors during recompilation/revalidation of SYS.AURORA$SERVER$STARTUP ORA-00600: internal error code, arguments: [4882], [48415556], [97653212], [48293020], [], [], [], [] Pretty isn't it? Any "easy" way of fixing this before I send my database to that big recycle bin in the sky? Actually it may be a good thing, then I could try and get OEM 2.1 up and running again - But that's another thread :) All insight appreciated.. Regards Mark -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Drop a column in a 9 million records table
Ruth to drop a column, use truncate? Joe Ruth Gramolini wrote: Use truncate instead of drop. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, March 05, 2001 11:10 AM The database is Oracle8.1.7. I used the syntax: alter table foo drop column bar; Why it gives run out of RBS error? Is alter table a DDL? How does it use RBS? TIA Chris Harvest __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question - solved
read the documentatio on standby databases. it in the 8.1.7 docs(which nowadays are online), there is a whole book on standby databases. joe Anjan Thakuria wrote: can u please tell me how to monitor it . TIA Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Disabling Constraints in a Schema!..??
-- the FK select 'alter table '||table_name||' disable '||constraint_name||';' from user_constraints where constraint_type = 'R'; there is check constraints, primary key, and unique, but i'll not give you the entire answer. joe Arul kumar wrote: Hi DBAs, We r using Oracle 8.1.6 . db. I would like to disable all the constraints on the Tables available under one schema. Is there any single command to do this in 8i . Any DBMS package available? Any other suggestions for doing the same?? Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-12537 question
Ok anyone seen this error. here is the scenario: dev box - firewall - internet - prod db server on the prod db server, protocol.ora is enabled to screen only legit ip addys. connect from dev box w/sqlplus and get a 12537 error, solaris, 8.1.5 on both dev and prod. PC attempted also, 8.1.5 client. all get the same error. thanks, joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Revoke system privilege from user
revoke dba from user. and if you're daring grant all privileges to user revoke drop any table from user joe Chuan Zhang wrote: Hi, All, I have granted DBA role to an user. But I don't want him holding the "Drop Any Table" system privilege. I did as follows: 1. Connect as sysdba. 2. revoke drop any table from ABC-user; And I got the error:" ORA-01952: system privileges not granted to 'ABC-user'". Could anyone help me out? Thanks, Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle's generosity
yea i got 2 packages like that. joe Steve Adams wrote: Hi All, I am curious about the generosity of Club Oracle. I signed up as a Club Oracle Gold member for $50 prior to OpenWorld last year just to get the $135 discount on the OpenWorld registration fee. There was also a gift certificate at Amazon.com and a gift pack thrown in. I chose the "Kids pack" containing adult and child size Club Oracle T-shirts. I was a little surprised about a month after OpenWorld when a second such gift pack arrived. I was even more surprised today when the third identical gift pack arrived. I've now got 6 Club Oracle T-shirts! Anyone else? @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help - Tuning SQL
Since you insisted on no guessing the only true test is for you to do it. Since we dont have your database to test it out on, its time for you to bust out the documentation, look at explain plan, tkprof,. Happy testing. joe I've got some simple questions on tuning SQL. Please reply with references, I'm not looking for guesses. * If you have a SELECT statement with a WHERE clause and 2 AND clauses, which one is processed first, the WHERE clause, the first AND clause, or the second AND clause? * Is there any performance loss in using "" over "!="? Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Standby database question
So my standby is in managed recovery mode. i was curious internally how does oracle send the archive logs across from primary to standby machine(they are physically separate). i know it goes via net8, does it do some internal fopen to write it out and apply it, or am i way out in left field here. thanks, joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
standby database question - solved
never mind, i found it, the RFS(remote file server) process handles it. joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix Cron job help
in the cron job write out a file that tells success or not and have job b read it. joe David Jones wrote: Dear Lister: I have two cron jobs which run at 10:30 PM 2:00 AM, job A performed a DB hot backup and job B will put those backup files into tapes. The problem is job B is based on the success completion of job A. How can I write the unix script for job B to do this check ? Please help. T.I.A. David Jones ITResource _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).