RE: Problem doing RMAN backup of Clone?
Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A way to restore a DB
How about doing the inserts in a seperate database and synch using replication or home cooked scripts into your warehouse. -Original Message- Sent: zondag 24 november 2002 18:24 To: Multiple recipients of list ORACLE-L Dear gurus! We are evaluating a strange way to recover a production DB. This is a 3.7 TB database, still growing, with LOTS of data inserted every 5 minutes (and several partitions belonging to several tables get dropped each day - we keep historical data for 90 days back), which we used to backup with RMAN to HP Omniback controlled tapes. We had a failure, and it took almost 48 hours to restore/recover the DB (in addition to backed DB files, I had to restore thousands of archived logs from tapes and apply them to the DB). We can not afford to have the DB down for 2 days. Now, we decided to give up RMAN hot backup, actually to give up backup (in it's classic meaning) at all. I'll explain why: It's very important for us to get the DB up running ASAP after a crash. We want the DB operating much more than we care about historical data that reside in our DB. Our goal is to enable the inserts (which run every 5 minutes, as I have stated) ASAP. So, we plan to do the following backup/recovery procedures: 1) We want to generate a script that will build the basics of the DB - create the DB and the instance, build tablespaces, users, grants, roles etc... 2) We want to create a daily export of small (but the most important) configuration tables, which can be imported very quickly after the crash and rebuild of DB. At this point the DB is operational. 3) We can now import the large data tables - partition by partition. And I don't care if THIS step will take 2 weeks. What do you say? Any reviews of my steps and the idea in general? And, do you have a script that can re-engineer a DB (as in my step 1)? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What makes Oracle DB shutdown automatically?
Dear all DBAs, I wonder what're the possible reasons that make Oracle DBshutdown automatically? Linux is running well. It first running very slow andsuddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance.
Command to prevent inactivity timeout in Sun Sol
Hi, is there any command to prevent Inactivity timeout expired in Sun Solaris. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Oracle DB shutdown automatically?
Hi, A good place to start is your alert log and see if there are any trace files from the time of crash. Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: maandag 25 november 2002 9:29To: Multiple recipients of list ORACLE-LSubject: What makes Oracle DB shutdown automatically? Dear all DBAs, I wonder what're the possible reasons that make Oracle DBshutdown automatically? Linux is running well. It first running very slow andsuddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance.
RE: What makes Oracle DB shutdown automatically?
The database normally doesn't shutdown automatically. If there are errors which inhibit DB operations oracle shuts down the instance and writes the error in the sidalert.log file. This file can be found at the location specified by background_dump_destination init.ora parameter. You can open the alert.log file in a text editor and scroll to see the error which resulted in the Shutdown. Then you can lookup the error in Oracle's Error Messages manual, which might give you the explanation of the error and a possible solution. If it doesn't you can search metalink/google for the error message or post it in this mailing list to get the solution. Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: What makes Oracle DB shutdown automatically? Dear all DBAs, I wonder what're the possible reasons that make Oracle DBshutdown automatically? Linux is running well. It first running very slow andsuddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance.
Re: 1M STRIPE SIZE BEST?
Just depends on your settings... eg max phys io = 1m, db mult read * blk size = 1m then - 64k stripe means 16 disks in the read - 128k means 8 - 512k means 2 - 1m means 1 etc Involving lots of disks in a single read tends be good for systems will small user populations (basically you're better at a given point in time there will only be 1 or 2 concurrent queries on the system and you still want to maximise IO bandwidth). As the user population gets larger, then involving lots of disks in a single read can often lead to IO thrashing Cheers Connor --- Jared Still [EMAIL PROTECTED] wrote: Maybe I've forgotten something fundamental about the way RAID 5 works, I dunno. But I'm having a hard time understanding how stripe size is going to determine the number of heads used in an IO. RAID 5 distributes the data across all spindles, with 1 or more of the spindles for any IO being used for the parity data. Someone care to enlighten me? Thanks, Jared On Thursday 21 November 2002 06:33, Thomas Day wrote: We had a discussion about a year ago here and if I remember correctly the best stripe size is a function of number of concurrent users. With a small number of users you want a small stripe size so that each read i/o will utilize the maximum number of heads. It will also tie up the RAID device for the duration of the read. With a large number of users you want a very large stripe size so that a minimum of heads will be used for each read and the RAID device can handle multiple requests at a time. I don't recall any specific numbers and, as you say, the technology is changing so quickly that a discussion from a year ago may not be pertinent to today's environment. Post, Ethan Ethan.Post To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @ps.net cc: Sent by: rootSubject: 1M STRIPE SIZE BEST? 11/20/2002 05:53 PM Please respond to ORACLE-L A number of papers recommend a stripe size of 1 M (even for EMC) for volumes containing data files. I also have the following email from Eyal Aronoff of Quest dated Nov 2000. A number of the white papers are more recent. The reasons for a larger stripe size on a non-RAID 5 device are: 1) Sequential reads are faster if you can take advantege of the read ahead built into the disk caching 2) If a 64K read does not start on the first block of the stripe, two spindled are locked for the duration of the read However, lately we have been testing some EMC gear and it looks like EMC have optimized both of those for smaller strip size too. The bottom line - I no longer have an opinion one way or another. The undelying technology just changes too rapidly. Eyal Your opinions/comments as far as a best practice in setting stripe sizes would be greatly appreciated. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please
Re: What makes Oracle DB shutdown automatically?
This is a multi-part message in MIME format. --=002_Dragon500403610468_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable shuan.tay\(PCI=BEG=B8R=B3=D4\)=A3=AC=C4=FA=BA=C3=A3=A1 =A1=A1=A1=A1Hi,i think you will have to check it from the oracle alert= log file and the trace file that is generated, find out which= make oracle down and search metalink/contact oracle support. If you need further help,you can post your trace file/alert= logfile here and maybe we can help. Good luck. =3D=3D=3D=3D=3D=3D=3D=3D 2002-11-25 00:28:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D Dear all DBAs, I wonder what're the possible reasons that make Oracle DB= shutdown automatically? Linux is running well. It first running very slow and suddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance. =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 =C0=F1=A3=A1 =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-11-25 --=002_Dragon500403610468_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaeaFONT size=3D2FONT= face=3D=CB=CE=CC=E5shuan.tay\(PCI=BEG=B8R=B3=D4\)=A3=AC=C4=FA=BA=C3=A3=A1/FONT /FONT DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1Hi,i think you will have to check= it from the oracle alert log file and the trace file that is generated, find out= which make oracle down and search metalink/contact oracle support./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; If you need= further help,you can post your trace file/alert logfile here and maybe we can= help./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Good= luck./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D= 2002-11-25nbsp;00:28:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 TABLE width=3D100% TBODY TR TD width=3D100% BLOCKQUOTE style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Dear all= DBAs,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2I wonder what're the= possible reasons that make Oracle DBnbsp;shutdown automatically?/FONT/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Linux is running= well./FONTFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2/FONT/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2It first running very slow= andnbsp;suddenly shutdown./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Running Oracle 8.0.5 on= Linux./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Can you guys please tell me= what should i check/FONTFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2? /FONT/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Would you mind to explain= in detail? 'Cos I'm just a junior DBA./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Thanks in= advance./FONT/DIV = DIVnbsp;/DIV/BLOCKQUOTE/TD/TR/TBODY/TABLE/FONT= /DIV DIV PFONT face=3D=CB=CE=CC=E5 size=3D2=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D= =3D =3D /FONT/P PFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2BR=C0=F1=A3=A1/FONT/P DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA href=3Dmailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/FO= NT/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-11-25/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon500403610468_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: What makes Oracle DB shutdown automatically?
This is the alert log file, and i try to search for error ORA-00313, it's: "ORA-00313 open failed for members of log group string of thread stringCause: The online log cannot be opened. The file may not be in the expected location.Action: Specify the correct redo log file or make the log available, if necessary." Is it correct? What's the online log mentioned here? Redo log? -alert_pcia.log-- LGWR: terminating instance due to error 313Instance terminated by LGWR, pid = 2025Mon Nov 25 15:07:56 2002Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0LICENSE_MAX_USERS = 0Starting up ORACLE RDBMS Version: 8.0.5.0.0.System parameters with non-default values: processes = 300 event = 10805 trace name context forever, level 1 shared_pool_size = 1900 control_files = $ORACLE_HOME/dbs/ctl1pcia.dbf, $ORACLE_HOME/dbs/ctl2pcia.dbf, $ORACLE_HOME/dbs/ctl3pcia.dbf, $ORACLE_HOME/dbs/ctl4pcia.dbf db_block_buffers = 550 db_block_size = 8192 compatible = 8.0.5.0.0 log_buffer = 163840 log_checkpoint_interval = 1 db_files = 500 db_file_multiblock_read_count= 16 dml_locks = 500 rollback_segments = rbs01, rbs06, rbs02, rbs07, rbs03, rbs08, rbs04, rbs09, rbs05, rbs10, rbs20, rbs15, rbs19, rbs14, rbs18, rbs13, rbs17, rbs12, rbs16, rbs11, rb30, rb21, rb29, rb22, rb27, rb23, rb26, rb24, rb25 sequence_cache_entries = 100 sequence_cache_hash_buckets= 23 remote_login_passwordfile= NONE global_names = FALSE db_name = pcia open_cursors = 10 os_authent_prefix = background_dump_dest = $ORACLE_HOME/rdbms/trace user_dump_dest = $ORACLE_HOME/rdbms/trace max_dump_file_size = 10240PMON started with pid=2DBW0 started with pid=3LGWR started with pid=4CKPT started with pid=5SMON started with pid=6RECO started with pid=7Mon Nov 25 15:07:56 2002alter database mountMon Nov 25 15:08:00 2002Successful mount of redo thread 1, with mount id 810458128.Mon Nov 25 15:08:00 2002Database mounted in Exclusive Mode.Completed: alter database mountMon Nov 25 15:08:00 2002alter database open Beginning crash recovery of 1 threadsRecovery of Online Redo Log: Thread 1 Group 1 Seq 16402 Reading mem 0 Mem# 0 errs 0: /home/oracle/app/oracle/product/8.0.5/dbs/log1pcia.log Mem# 1 errs 0: /home/oracle/app/oracle/product/8.0.5/dbs/log4pcia.logCrash recovery completed successfullyPicked broadcast on commit scheme to generate SCNs -
IMP-00098: Internal Error: impccr2
Hi all, I received quite interesting error during import. I am trying to put the dump from 8.1.6 database to 9i rel2 database on win2k server. The export dump was done with WE8ISO8859P1 character set and the target db is with UTF8 character set... Do you have any idea, or should I contact oracle support! Rgds, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
Re: instance shutdown problem ? (please help)
thanks to all who are helping with this problem. control file(s) are missing. since this is a new install it might have been that the control files were never created. the oracle docs (support) tell to use CREATE CONTROLFILE statement to create control file(s). but i need to know the complete procedure. would you know the complete statement and procedure to generate control files. do we have to change the db/sid name ? --- Arup Nanda [EMAIL PROTECTED] wrote: Yes, the poster clarified that it was a missing controlfile. I have a reply that catered to the missing controlfile issue. From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: instance shutdown problem ? (please help) Date: Sun, 24 Nov 2002 15:23:35 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc6-f42.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sun, 24 Nov 2002 16:13:22 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA10715;Sun, 24 Nov 2002 16:06:45 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A562; Sun, 24 Nov 2002 15:23:35 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Jeremiah Wilton [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 25 Nov 2002 00:13:22.0422 (UTC) FILETIME=[772A6160:01C29417] Hmm, I think the error is right there in a snippet fo the alert log in the poster's original message. ORA-205 Error in identifying controlfile. The database will not start because Oracle cannot find or access one or more of the controlfiles. Are all the postings today about controlfiles? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 23 Nov 2002, Arup Nanda wrote: Well, system does not do a shutdown abort. Oracle finds a problem and then instance aborts. A few things you can do here. (1) See if a trace file is generated around that time in user_dump_dest or background_dump_dest that might provide clues. If you see a core fiel in any directory named core_* in the core_dump_dest, it has cored dumped. (2) Start the database from command line. From NT services panel, make the services OracleServiceXXX manual, from automatic. Then reboot the box. Start the service manually and then see what happens in the process. (3) Start the instance and service in a command prompt window using oradim comamnd. I am not sure of the options; but the oradim command gives a help. At some point you would hit a problem that is decipherable. Please let us know what came out of it. From: john [EMAIL PROTECTED] ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle alert.log show that the instance being shutdown just after the box boots up. how do we rectify this problem ? below is from the alert.log ORA-205 signalled during: alter database mount exclusive.. Shutting down instance (abort) License high water mark = 5 Instance terminated by USER, pid = 144 --- please note: the shutdwon was not initiated by any admin or user but done by the system itself after the box boots up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
RE: Problem doing RMAN backup of Clone?
Title: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Doug C [SMTP: ] Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Subject: Problem doing RMAN backup of Clone? Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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: instance shutdown problem ? (please help)
John, If you ever had a running database, you did have a controlfile. This is a new install; but are you saying that there was never a database created, with datafiles, redo log files, etc. and you never stored data? If so then there is no problem. Just use Oracle Database Configuration Manager and delete the instance that is running. And then create a new instance with the same name. You don't have to remember or write the controlfiel creation command. However, if the database was created and you had data in that, then unless the database is is archivelog mode you can't just create a controlfile. Even if it's in archivelog mode, in order to create a controlfile, you need to know the exact location and names of datafiles and redo log files as well as block sizes, etc. I kind of assume that would be a little difficult to do. But if you can do it, just get the syntax from the manual. Here it is, just in case. CREATE CONTROLFILE DATABASE MYSID LOGFILE GROUP 1 ('c:\oradata\log1.log', 'd:\oradata\log1.log') SIZE 50K, GROUP 2 ('c:\oradata\log2.log', 'd:\oradata\log2.log') SIZE 50K NORESETLOGS DATAFILE 'c:\oradata\system.dat' SIZE 100M MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10 MAXINSTANCES 2 ARCHIVELOG CHARACTER SET F7DEC; Of course, this is an example. Please replace the necessary details with your environment.HTHArup Nandawww.proligence.com - Original Message - From: "john" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:48 AM Subject: Re: instance shutdown problem ? (please help) thanks to all who are helping with this problem. control file(s) are missing. since this is a new install it might have been that the control files were never created. the oracle docs (support) tell to use "CREATE CONTROLFILE" statement to create control file(s). but i need to know the complete procedure. would you know the complete statement and procedure to generate control files. do we have to change the db/sid name ? --- Arup Nanda [EMAIL PROTECTED] wrote: Yes, the poster clarified that it was a missing controlfile. I have a reply that catered to the missing controlfile issue. From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: instance shutdown problem ? (please help) Date: Sun, 24 Nov 2002 15:23:35 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc6-f42.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sun, 24 Nov 2002 16:13:22 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA10715;Sun, 24 Nov 2002 16:06:45 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A562; Sun, 24 Nov 2002 15:23:35 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Jeremiah Wilton [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 25 Nov 2002 00:13:22.0422 (UTC) FILETIME=[772A6160:01C29417]Hmm, I think the error is right there in a snippet fo the alert log in the poster's original message. ORA-205 "Error in identifying controlfile."The database will not start because Oracle cannot find or access one or more of the controlfiles.Are all the postings today about controlfiles?-- Jeremiah Wilton http://www.speakeasy.net/~jwiltonOn Sat, 23 Nov 2002, Arup Nanda wrote: Well, system does not do a shutdown abort. Oracle finds a problem and theninstance aborts. A few things you can do here. (1) See if a trace file is generated around that time in user_dump_dest or background_dump_dest that might provide clues. If you see a core fiel in anydirectory named core_* in the core_dump_dest, it has cored dumped. (2) Start the database from command line. >From NT services panel, make the services OracleServiceXXX manual, from automatic. Then reboot the box. Startthe service manually and then see what happens in the process. (3) Start the instance and service in a command prompt window using oradim comamnd. I am not sure of the options; but the oradim command gives a help. At some point you would hit a problem that is decipherable. Please let usknow what came out of it. From: john [EMAIL PROTECTED] ver 8i NT4.o all services have been set to automatic and start fine however the NT
how do I calculate the Oracle's usage
Hi. I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application running against it is taking. There are several databases on that server and I'm only interested in one so vmstat won't really help that much. Besides just running ps -ef | grep INSTANCE is there any other way for me to get a feeling of the load that puts on the CPU my database? thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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 is a time machine!!
Did you try it with different NLS_LANGUAGE and NLS_TERRITORY settings? [EMAIL PROTECTED] 11/22/02 03:49PM Yes. This is where it gets interesting. England and the colonies didn't adopt the Gregorian Calendar Reform until September, 1752. October, 1582 had its normal 31 days in the British Empire and September, 1752 had its normal 30 days outside the British Empire. So what does all this mean? Technically, Oracle's date routines are correct in some parts of the world but not others. Happy Friday, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -Original Message- Sent: Friday, November 22, 2002 11:40 AM To: Multiple recipients of list ORACLE-L Subject:Re: Oracle is a time machine!! Does it have any relation to year 1752 adjustment for leap year? Try following on unix .. cal 9 1752 September 1752 S M Tu W Th F S 1 2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 22, 2002 12:55 PM Don't believe me?? Try this: create table test(the_date date); insert into test values (to_date('10-05-1582','mm-dd-') ); select to_char(the_date, 'mm/dd/') from test; What do you get? :-)) **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem doing RMAN backup of Clone?
Unfortunately, this problem is with the DBID, not anything in the controlfile. Oracle 9.2 comes with a utility called 'nid' in $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK, there is no other way to change the DBID, and you just have to use another catalog. I think nid may work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? -Original Message- From: Doug C [SMTP: ] Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need to customize execution plan for a cross table.
I have a cross table that connects data in two base tables. If base table 1 is the driving table, query execution time is 0.02 seconds. If base table 2 is the driving table, query execution time is 0.5 seconds. But when this query is executed 10K times, it addes 1.5 hours to the processing time. Execution plan is simple when base table 1 is the driving table. It is based on nested loop. First select data from table 1. Based on data selected from table 1, select data from cross table using nested loop. Do the same for base table 2. Cross table allows very quick data selection from base table 2. Oracle does a good job at it. When base table 2 is the driving table, execution plan changes drastically. Now it uses sort-merge and merge join cartesian. Rather than cross table used to quickly get data from the next base table, it is used last. So first select the data from base table 2. Then get all the records from base table 1 and sort - merge it with table 1. Now do nested loop join between this data and cross table data. Since either of the two base tables can be a driving table, the only way I found is that I should create two separate queries, use ordered and nested_loop hints and this should work. However, the query is a view and therefore, I need to look into other possibilities. Any ideas? I am using oracle 8i(64 bits)(81.7.4) on Solaris(2.8). Also using cost based optimizer. = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: Problem doing RMAN backup of Clone?
Title: RE: Problem doing RMAN backup of Clone? Good to hear from you Lisa!! Welcome Back!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 7:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Doug C [SMTP: ] Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Subject: Problem doing RMAN backup of Clone? Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Get rid of your virus please -Original Message-From: sfaroult [mailto:[EMAIL PROTECTED]]Sent: maandag 25 november 2002 14:54To: Multiple recipients of list ORACLE-LSubject:
Virus message
FYI Just received a report that a message from the list has the W32/Klez.h@MM virus. It was apparently from Stephane Faroult. Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey 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: instance shutdown problem ? (please help)
John If this is a new install then why dont you just do the install again. Otherwise you can use following STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE WMPROD NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 10 MAXLOGHISTORY 3630 LOGFILE GROUP 1( '/ora/redo1/wmprod/redo1a.log', '/ora/redo2/wmprod/redo1b.log' ) SIZE 700M, .. DATAFILE '/ora/ts4/wmprod/system01.dbf', .. ; Justput in names of you all your redologs and data files. You may have to do a recovery afterwards. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 4:48 AM thanks to all who are helping with this problem. control file(s) are missing. since this is a new install it might have been that the control files were never created. the oracle docs (support) tell to use CREATE CONTROLFILE statement to create control file(s). but i need to know the complete procedure. would you know the complete statement and procedure to generate control files. do we have to change the db/sid name ? --- Arup Nanda [EMAIL PROTECTED] wrote: Yes, the poster clarified that it was a missing controlfile. I have a reply that catered to the missing controlfile issue. From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: instance shutdown problem ? (please help) Date: Sun, 24 Nov 2002 15:23:35 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc6-f42.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sun, 24 Nov 2002 16:13:22 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA10715;Sun, 24 Nov 2002 16:06:45 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A562; Sun, 24 Nov 2002 15:23:35 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Jeremiah Wilton [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 25 Nov 2002 00:13:22.0422 (UTC) FILETIME=[772A6160:01C29417] Hmm, I think the error is right there in a snippet fo the alert log in the poster's original message. ORA-205 Error in identifying controlfile. The database will not start because Oracle cannot find or access one or more of the controlfiles. Are all the postings today about controlfiles? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 23 Nov 2002, Arup Nanda wrote: Well, system does not do a shutdown abort. Oracle finds a problem and then instance aborts. A few things you can do here. (1) See if a trace file is generated around that time in user_dump_dest or background_dump_dest that might provide clues. If you see a core fiel in any directory named core_* in the core_dump_dest, it has cored dumped. (2) Start the database from command line. From NT services panel, make the services OracleServiceXXX manual, from automatic. Then reboot the box. Start the service manually and then see what happens in the process. (3) Start the instance and service in a command prompt window using oradim comamnd. I am not sure of the options; but the oradim command gives a help. At some point you would hit a problem that is decipherable. Please let us know what came out of it. From: john [EMAIL PROTECTED] ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle alert.log show that the instance being shutdown just after the box boots up. how do we rectify this problem ? below is from the alert.log ORA-205 signalled during: alter database mount exclusive.. Shutting down instance (abort) License high water mark = 5 Instance terminated by USER, pid = 144 --- please note: the shutdwon was not initiated by any admin or user but done by the system itself after the box boots up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
How are rollback segments assigned?
Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Optimizer tuning parameter not working?
I changed the optimizer_search_limit value to 1 in init.ora to minimize the cartesian product in my execution plans. But I do not see any change in my execution plans. Am I missing something? I modified init.ora and bounced the database. I have also tried to run the query after manually set it in my sql session without any change in results. I tried it on NT/Oracle 8.1.7.4.1 I noticed that my execution plans do not change for the following tuning parameters either. 1. Optimizer_index_cost_adj=50 2. Optimizer_max_permutations=7 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: how do I calculate the Oracle's usage
Title: RE: how do I calculate the Oracle's usage Hi Gene, Wouldn't top at least be a place to start? You could take snapshots of what's happening on top several times throughout the day and at least make a quick guesstimate from there. You could also look at sar - I forget which switch displayes cpu usage. This is a very simplistic approach and I'm sure there's probably tools and other more specific and detailed metrics available since you are so lucky to have a UNIX machine. Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Gurelei [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Subject: how do I calculate the Oracle's usage Hi. I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application running against it is taking. There are several databases on that server and I'm only interested in one so vmstat won't really help that much. Besides just running ps -ef | grep INSTANCE is there any other way for me to get a feeling of the load that puts on the CPU my database? thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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).
Usage error in your E-mail to mailing list 'ORACLE-L'
SET ORACLE-L NOMAIL -- Forwarded by Linda Miller-Coker/JPMCHASE on 11/25/2002 10:19 AM --- Mailing List Administrator [EMAIL PROTECTED] on 11/23/2002 02:18:44 PM Please respond to [EMAIL PROTECTED] To: Linda Miller-Coker/JPMCHASE@CHASE cc: *** IT IS IMPORTANT THAT YOU READ THIS MESSAGE *** Your message is being returned to you because of an error in your usage. The mailing list address you sent your message to was: Address: [EMAIL PROTECTED] Description: Oracle RDBMS Community Forum Subject: Ignore Previous NOte Your posting has been rejected and returned to you because it appeared to be a vacation auto-reply message. If you have received only one of these notices, then please consider this a courtesy notice. If you received more than one of these (perhaps many of these) notices, then your auto-reply program is not cognizent of proper mail ettiquette and you must heed these instructions in future situations like this. While you have an auto-reply responder turned on, all messages which are auto-replied to the mailing list are sent to your mailbox AGAIN, resulting in a quickly increasing endless-loop condition. This not only causes YOUR mailbox to fill up, but it fills the mailboxes of every person who is a subscriber to the list. This filter was put into place to avoid these types of endless-loop situations, and stop them before they get started. A more effective way of dealing with being on vacation is to TEMPORARILY turn off messages from the mailing list. This doesn't require you to unsubscribe -- it merely temporarily stops the flow of messages to your mailbox while you are gone. In order to stop mailing list messages temporarily, send an E-mail message to: [EMAIL PROTECTED] And in the message BODY, include the following command: SET mailing list name NOMAIL Where mailing list name is the name of the mailing list for which you are a subscriber. Note that you can use this at ANY time, and for any reason, not just for vacations. Once you have returned from vacation, issue the following command to resume mail service again: SET mailing list name MAIL If you use the two commands above, once before you leave, and then again after you return, everyone will appreciate your consideration and respect for the list. If you need to know which lists you are subscribed to, use the following command: WHICH And finally, any time you need assistance with ListGuru, send the HELP command in the message body for detailed help on using ListGuru. The body of your original message is being returned to you below. Thank you, [EMAIL PROTECTED] - begin returned message - Sorry guys and girls...going on vacation and sent the nomail to work spot. - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
virus
Somebody is using this list to send a virus, beware ! Jeroen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Verzonden: maandag 25 november 2002 15:22 Aan: [EMAIL PROTECTED] Onderwerp: De antivirus-scanner op de firewall van Thomas Cook heeft een bericht dat aan [EMAIL PROTECTED] gericht was onderschept omdat er een virus in zit. Het bericht is geweigerd en wordt dus niet doorgestuurd. De email was verstuurd door: [EMAIL PROTECTED] Subject: De viruswaarschuwing is: va025044 = infected: Exploit.IFrame.FileDownload va025044 = infected: I-Worm.Klez.h We adviseren je om contact op te nemen met de afzender van dit bericht. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam 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).
LONG's
OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
Re: Do user processes apply against shmmax limit?
... and we butt headlong into another fine myth, that is that the SGA must fit into one segment. On Sunday 24 November 2002 15:53, Richard Ji wrote: if that SGA + user processes shmmax the system will start swapping. That's not true. If your SGA is bigger than shmmax, it just means the SGA will be fit into multiple shared memory segments. Doesn't necessary mean the system will start swapping. Is the scan rate going up? Richard -Original Message- Sent: Saturday, November 23, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've started experiencing system slowdown and he says that increasing shmmax could resolve it. I'm skeptical (he also suggested increasing SGA to decrease swapping which I told him in no uncertain terms was nonsense). If anyone has a link to a note or white paper I'd appreciate that too. I've appended his email at the bottom. This slowdown seems to occur even when there's virtually on oracle activity so I'm suspecting some other cause. Thanks, Jay Miller nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This morning nycsun1 was very slow and I noticed that there was lots of swaping. see vmstst and iostat below in red: procs memorypagedisk faults cpu r b w swap free re mf pi po fr de sr s2 s4 s4 sd in sy cs us sy id 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 3330 974 11 8 81 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 847 416 3 1 96 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183 670 13 4 84 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065 607 12 6 82 0 0 23 4362384 96080 1 6 4 8 8 77376 0 0 0 0 0 975 465 457 2 1 97 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859 734 8 3 89 0 0 23 4360424 95480 4 41 36 40 100 77376 7 0 0 0 0 986 1250 542 6 0 94 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0 0 0 1037 942 665 5 3 92 0 0 23 4359680 95784 2 449 4 28 84 95520 8 0 0 0 0 922 1047 374 4 1 95 0 0 23 4359936 95464 2 544 4 20 332 95520 44 0 0 0 0 931 1095 384 2 2 96 /s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.00.00.0 0.0 0.00.00.0 0 0 c2t6d0 0.0 34.50.0 270.0 0.2 13.86.7 399.5 6 44 c5t12d0 -- swap disk 0.0 34.50.0 270.0 0.5 10.7 15.5 309.4 18 39 c5t13d0 -- swap disk This shows that the system is not effectively using memory. I suggest increasing the share memory to 4 GB so that DBAs can increase their memory usage. Also set priority paging on. Priority paging will give application first priority then free memory will be allocated to file cache( Solaris 2.6 and 7. Solaris 8 is set dynamically). * ORACLE CONFIGS set shmsys:shminfo_shmmax =204800 -- increase to 409600 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=30 set semsys:seminfo_semmap=500 set semsys:seminfo_semmni=200 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Modify Table restrictions
Hello; Somebody knows how to view the restrictions Of a table, and quit one of the restrictions? Thank you. Francisco Murillo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Francisco Murillo Montoya 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: LONG's
Its called the C compiler :-) If the LONG's are not so long (ie less than 32k) you can get away with just plain old static PLSQL to get at the data, otherwise you can look at dbms_sql hth connor --- Hand, Michael T [EMAIL PROTECTED] wrote: OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone else had a Virus alert for Stephane Faroult's email ?
My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin smime.p7s Description: application/pkcs7-signature
Re: Optimizer tuning parameter not working?
Generally you'll changes in the 'cost' figure when playing with Optimizer_index_cost_adj. If you change the permutations figure, you'd probably need to look at 10053 to see the differences going on... Oracle pretty rarely chooses a cartesian product (between tables of any siginificant size that is), so maybe you might want to look at the sql and/or the indexes on the schema before looking for a solution in the optimizer parms.. hth connor --- Mohammed Shakir [EMAIL PROTECTED] wrote: I changed the optimizer_search_limit value to 1 in init.ora to minimize the cartesian product in my execution plans. But I do not see any change in my execution plans. Am I missing something? I modified init.ora and bounced the database. I have also tried to run the query after manually set it in my sql session without any change in results. I tried it on NT/Oracle 8.1.7.4.1 I noticed that my execution plans do not change for the following tuning parameters either. 1. Optimizer_index_cost_adj=50 2. Optimizer_max_permutations=7 = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: instance shutdown problem ? (please help)
John If this is a new install then why dont you just do the install again. Otherwise you can use following STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE WMPROD NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 10 MAXLOGHISTORY 3630 LOGFILE GROUP 1( '/ora/redo1/wmprod/redo1a.log', '/ora/redo2/wmprod/redo1b.log' ) SIZE 700M, .. DATAFILE '/ora/ts4/wmprod/system01.dbf', .. ; Justput in names of you all your redologs and data files. You may have to do a recovery afterwards. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 4:48 AM thanks to all who are helping with this problem. control file(s) are missing. since this is a new install it might have been that the control files were never created. the oracle docs (support) tell to use CREATE CONTROLFILE statement to create control file(s). but i need to know the complete procedure. would you know the complete statement and procedure to generate control files. do we have to change the db/sid name ? --- Arup Nanda [EMAIL PROTECTED] wrote: Yes, the poster clarified that it was a missing controlfile. I have a reply that catered to the missing controlfile issue. From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: instance shutdown problem ? (please help) Date: Sun, 24 Nov 2002 15:23:35 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc6-f42.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sun, 24 Nov 2002 16:13:22 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA10715;Sun, 24 Nov 2002 16:06:45 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A562; Sun, 24 Nov 2002 15:23:35 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Jeremiah Wilton [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 25 Nov 2002 00:13:22.0422 (UTC) FILETIME=[772A6160:01C29417] Hmm, I think the error is right there in a snippet fo the alert log in the poster's original message. ORA-205 Error in identifying controlfile. The database will not start because Oracle cannot find or access one or more of the controlfiles. Are all the postings today about controlfiles? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 23 Nov 2002, Arup Nanda wrote: Well, system does not do a shutdown abort. Oracle finds a problem and then instance aborts. A few things you can do here. (1) See if a trace file is generated around that time in user_dump_dest or background_dump_dest that might provide clues. If you see a core fiel in any directory named core_* in the core_dump_dest, it has cored dumped. (2) Start the database from command line. From NT services panel, make the services OracleServiceXXX manual, from automatic. Then reboot the box. Start the service manually and then see what happens in the process. (3) Start the instance and service in a command prompt window using oradim comamnd. I am not sure of the options; but the oradim command gives a help. At some point you would hit a problem that is decipherable. Please let us know what came out of it. From: john [EMAIL PROTECTED] ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle alert.log show that the instance being shutdown just after the box boots up. how do we rectify this problem ? below is from the alert.log ORA-205 signalled during: alter database mount exclusive.. Shutting down instance (abort) License high water mark = 5 Instance terminated by USER, pid = 144 --- please note: the shutdwon was not initiated by any admin or user but done by the system itself after the box boots up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: Problem doing RMAN backup of Clone?
Doug, I have successfully tested this method for changing the the dbid {gleaned from Ron Yount's procedure]. Changing the Dbid of copied database: Ron Yount from the Oracle-L provided the following steps if it becomes necessary to change the Dbid of a copied database to allow an RMAN catalog to backup both source and target database. This should occur at the tail of the SAP Database Copy procedure. [Tested successfully on GTS refresh 5/13/02] Use sqlplus to connect internal (if using sqlplus comment # must be changed to 'rem' or '--') SQL startup nomount SQL @c.sql /* create controlfile with set database resetlogs */ SQL select name,dbid from v$database; (There should be a new name, but same dbid from step 3) SQL shutdown normal SQL startup mount SQL exec dbms_backup_restore.zeroDbid(0); SQL shutdown normal Rename the control files from the new instance, so they will appear to be missing. SQL startup nomount SQL @c.sql SQL alter database open resetlogs; SQL select name, dbid from v$database. (There should be the new name, and new dbid) HTH Mike Hand Polaroid Corp. -Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug ** @@ This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Problem doing RMAN backup of Clone?
Use following command to generate new dbid. dbms_backup_restore.zeroDbid(0) Read Note:164870.1 on metalink for complete procedure. HTH -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:05 AM Unfortunately, this problem is with the DBID, not anything in the controlfile. Oracle 9.2 comes with a utility called 'nid' in $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK, there is no other way to change the DBID, and you just have to use another catalog. I think nid may work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? -Original Message- From: Doug C [SMTP: ] Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq 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: Problem doing RMAN backup of Clone?
You can change the DBID as mentioned in other messages. (see metalink doc id 174625.1) If you don't want to change the DBID, you can still backup the database using RMAN; you just can't use the same schema in the same rman catalog database as the original. You can: 1. Use a different catalog database. 2. Use a different schema in the same catalog database (for example rman_prod and rman_test schemas). 3. Don't use a catalog, and rely entirely on the control files as your catalog. -Original Message- Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
woohoo virus sent to the list
at least i got it(of course linux says: "you want me to save that .scr file?" bwaahhaahahha, linxu rulz. Jared, it slipped thru because it was a .scr? masked as a mime type .wav file? just curious since fatcity is pretty draned good about catching those things. joe
RE: Oracle 10i features
I'm not sure I'd go that far... Old habits (and prejudices) die hard... :-) -Original Message- Sent: Saturday, November 23, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Look for it to improve dramatically. I might even try to use it. Jared On Sunday 17 November 2002 06:13, J. Laurindo Chiappa wrote: Jared, just a thought : ** WHY ** Oracle experts charged in OEM developmentcan´t do anything close - fast, sweet simple , just to the point ?? Until now, OEM is just a pile of *hit, plain simple. Regards, Chiappa *** REPLY SEPARATOR *** On 13/11/02 at 05:23 Jared Still wrote: Check out OraC, written in Perl of course. :) http://www.tux.org/orac-dba/ Jared On Tuesday 12 November 2002 11:13, Jesse, Rich wrote: Good grief. Like I'm going to go through all of that overhead and hassle? And isn't 9iAS a separately licensable (read: cost) option, even if you're already licensed for EE? I think I'm reading the same PDF you were, Raj: The Console interacts with the Oracle Management Service, which, as a J2EE Web Application hosted by an Oracle9i application Server, leverages all of the reliability, scalability, and robustness of the Oracle9iAS instance. I wish I has time to work on the KISS-method OEM replacement I started... sigh Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 12, 2002 10:40 AM To: Multiple recipients of list ORACLE-L New EM4.0 (announced today) has a bunch of new features ... was just reading the PDF ... but it needs 9iAS ... that is a bummer ... more info on oracle website ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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: how do I calculate the Oracle's usage
How about you collect the following value from each instance on the host, wait a few hours, then collect the numbers again? You can then subtract the earlier values from the later values, and you'll have a good idea which instances are using more CPU relative to the others. SQL select value from v$sysstat where name = 'CPU used by this session'; -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Gurelei wrote: I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application running against it is taking. There are several databases on that server and I'm only interested in one so vmstat won't really help that much. Besides just running ps -ef | grep INSTANCE is there any other way for me to get a feeling of the load that puts on the CPU my database? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Two bugs in 9202 (that bit us)
Title: Two bugs in 9202 (that bit us) FYI, Oracle 9202 ... If you are using intermedia and have cursor_sharing to anything other than EXACT, oracle will start throwing ORA-600 errors. You can set it to EXACT (the only workaround) at session level if you want, but I recommend to set it in init. This is fixed in 10i. Also we ran into a problem with ora-600 [kclchkinteg_15] (you have two global cache buffers pointing to same data block buffer but in incompatible mode) ... this is in 9202, a patch is out, we will test it today tomorrow and see how that works. Then I ask myself ... isn't it fun to be on the cutting edge of the release? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Modify Table restrictions
Did you mean constraints? Check USER_CONSTRAINTS. To remove one: alter table table_name drop constraint... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 10:44 AM Hello; Somebody knows how to view the restrictions Of a table, and quit one of the restrictions? Thank you. Francisco Murillo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Francisco Murillo Montoya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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: A way to restore a DB
From the rest of you message, I would say there is something wrong with the hardware setup of your database. If the setup is such that you can lose an entire database of nearly 4 TB, then your backup/restore speed is the LEAST of your problems. You disk striping and mirroring should prevent the lose of the database in the vent of a disk failure; I would even consider mirroring across more than one storage array so that you can survive the loss of an entire storage array. If finances don't permit complete redundancy, the setup should be such that you never lose more than fraction of the database (i.e. a datafile or two ... or three). Then you only restore and recover the datafile(s) rather than the entire database. I can't imagine a setup where the loss of a disk, or even a controller, would cause the COMPLETE loss of a 4TB database. This whole thing looks very much like somebody screwed up and delete files. I suspect that a trip to Hell would reveal the rm -rf * command sitting at Satan's right hand. -Original Message- We are evaluating a strange way to recover a production DB. This is a 3.7 TB database, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i Lite
I wonder if there are any mailing lists out there for Oracle 9i Lite. Or for that matter, if any of you have used in the past or are using it now and would like to brainstorm once in a while on this topic. I struggle with its administration sometimes. If you can point me in a direction (other than the Oracle forums on their website), I would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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: Usage error in your E-mail to mailing list 'ORACLE-L'
HELP -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 10:29 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL -- Forwarded by Linda Miller-Coker/JPMCHASE on 11/25/2002 10:19 AM --- Mailing List Administrator [EMAIL PROTECTED] on 11/23/2002 02:18:44 PM Please respond to [EMAIL PROTECTED] To: Linda Miller-Coker/JPMCHASE@CHASE cc: *** IT IS IMPORTANT THAT YOU READ THIS MESSAGE *** Your message is being returned to you because of an error in your usage. The mailing list address you sent your message to was: Address: [EMAIL PROTECTED] Description: Oracle RDBMS Community Forum Subject: Ignore Previous NOte Your posting has been rejected and returned to you because it appeared to be a vacation auto-reply message. If you have received only one of these notices, then please consider this a courtesy notice. If you received more than one of these (perhaps many of these) notices, then your auto-reply program is not cognizent of proper mail ettiquette and you must heed these instructions in future situations like this. While you have an auto-reply responder turned on, all messages which are auto-replied to the mailing list are sent to your mailbox AGAIN, resulting in a quickly increasing endless-loop condition. This not only causes YOUR mailbox to fill up, but it fills the mailboxes of every person who is a subscriber to the list. This filter was put into place to avoid these types of endless-loop situations, and stop them before they get started. A more effective way of dealing with being on vacation is to TEMPORARILY turn off messages from the mailing list. This doesn't require you to unsubscribe -- it merely temporarily stops the flow of messages to your mailbox while you are gone. In order to stop mailing list messages temporarily, send an E-mail message to: [EMAIL PROTECTED] And in the message BODY, include the following command: SET mailing list name NOMAIL Where mailing list name is the name of the mailing list for which you are a subscriber. Note that you can use this at ANY time, and for any reason, not just for vacations. Once you have returned from vacation, issue the following command to resume mail service again: SET mailing list name MAIL If you use the two commands above, once before you leave, and then again after you return, everyone will appreciate your consideration and respect for the list. If you need to know which lists you are subscribed to, use the following command: WHICH And finally, any time you need assistance with ListGuru, send the HELP command in the message body for detailed help on using ListGuru. The body of your original message is being returned to you below. Thank you, [EMAIL PROTECTED] - begin returned message - Sorry guys and girls...going on vacation and sent the nomail to work spot. - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10i features
ah, but the people working on it have changed. Gaja Krishna Vaidyanatha John Beresniewicz James Morle to name just a few --- Johnston, Tim [EMAIL PROTECTED] wrote: I'm not sure I'd go that far... Old habits (and prejudices) die hard... :-) -Original Message- Sent: Saturday, November 23, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Look for it to improve dramatically. I might even try to use it. Jared On Sunday 17 November 2002 06:13, J. Laurindo Chiappa wrote: Jared, just a thought : ** WHY ** Oracle experts charged in OEM developmentcan´t do anything close - fast, sweet simple , just to the point ?? Until now, OEM is just a pile of *hit, plain simple. Regards, Chiappa *** REPLY SEPARATOR *** On 13/11/02 at 05:23 Jared Still wrote: Check out OraC, written in Perl of course. :) http://www.tux.org/orac-dba/ Jared On Tuesday 12 November 2002 11:13, Jesse, Rich wrote: Good grief. Like I'm going to go through all of that overhead and hassle? And isn't 9iAS a separately licensable (read: cost) option, even if you're already licensed for EE? I think I'm reading the same PDF you were, Raj: The Console interacts with the Oracle Management Service, which, as a J2EE Web Application hosted by an Oracle9i application Server, leverages all of the reliability, scalability, and robustness of the Oracle9iAS instance. I wish I has time to work on the KISS-method OEM replacement I started... sigh Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 12, 2002 10:40 AM To: Multiple recipients of list ORACLE-L New EM4.0 (announced today) has a bunch of new features ... was just reading the PDF ... but it needs 9iAS ... that is a bummer ... more info on oracle website ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication Manager
Has anyone used Replication Manager with success? Any feedback on issues you may have run into would be greatly appreciated. Does it come bundled with OEM or is it typically on a separate CD as a Management Pack? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle you have just received a card from .
http://www.hkg3.com/f.gif Oracle, recently sent you a postcard. Retrieve your postcard by using this URL. http://www.FriendGreetings.com/pickup.aspx?code=Oracle http://www.hkg3.com/pickup.html?code=Oracleid=2511021 id=2511021 Comment- Oracle, View the card just created. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) 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: Anyone else had a Virus alert for Stephane Faroult's email ?
no alert, but the spam filter on yahoo dumped a different message from him into bulk mail as it was 122K deleted without opening, just in case --- Martin Kendall [EMAIL PROTECTED] wrote: My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone else had a Virus alert for Stephane Faroult's email ?
Yes. At my end, it was detected and stripped. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, November 25, 2002 10:15 AM To: Multiple recipients of list ORACLE-L My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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).
Sr. Oracle DBA Position- Must be 8i and 9i Certified-
Great opportunity for a Sr. Oracle DBA with 8i AND 9i certification to join this software industry leader in Charlotte, North Carolina. Base salary is in the 90-120K range and depends on experience. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. Interested candidates will be required to complete a company questionnaire that must be submitted with the resume. *Description of duties: Production support of operations required to maintain 7x24 database/application availability. Logical Design and Physical Design in support of Production/Development Database operations and support in Solaris/Linux ORACLE 8i/9i environment. Essential Functions: Backup/recovery, RMAN, Performance tuning, Shell scripting in Korn and Bourne Shells. ORACLE Internet Directory, ORACLE Enterprise Manager, development/documentation of standards and procedures. ORACLE DBA duties to include user management data exports and imports, writing ORACLE scripts, general monitoring of system performance. Assisting users with SQL and PL/SQL needs in day-to-day operations and implementation of logical designs. * Requirements: -Oracle 8i and 9i Certification -7+Years in IT -5+ years of Production Oracle DBA experience..including 8i and 9i -Knowledge of OPS/RAC, OEM -Proficient with SQL, PL/SQL, unix shell scritping -Expert understanding of Oracle architecture -Full understanding of Database concepts -Knowledge of relational database design -Must be a Self-starter. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/Charlotte/Certified DBA/Carol We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone else had a Virus alert for Stephane Faroult's email ?
I did! Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Martin Kendall mkendall@oracle- rescue.comTo Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L [EMAIL PROTECTED] cc 11/25/2002 10:14 Subject AMAnyone else had a Virus alert for Stephane Faroult's email ? Please respond to ORACLE-L@fatcity. com My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ana Choto 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: HELP ORACLE TO INFORMIX
Title: RE: HELP ORACLE TO INFORMIX Want to quickly move Oracle table to Informix database using Oracle-INformix gateway. Getting error ORA-02047 when trying to commit every 1000 rows - do we really need to commit after each 1 row
Oracle-L you have received a greeting card emailed by .
http://www.hkg3.com/f.gif Oracle-L, just emailed you a postcard. Retrieve your greeting by clicking this link. http://www.Friend-Card.net/pickup.aspx?code=Oracle-L http://www.hkg3.com/pickup.html?code=Oracle-Lid=2511021 id=2511021 Note; Oracle-L, Go get the card just emailed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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:Anyone else had a Virus alert for Stephane Faroult's ema
YUP Dick Goulet Reply Separator Author: Martin Kendall [EMAIL PROTECTED] Date: 11/25/2002 7:14 AM My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin smime.p7s Description: Binary data
my messages are not getting to list. trying to testeom
instance shutdown problem ? (please help)
John, Off the top of my head. Is correc tinitsid.ora being used and are Control files in expected locations? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] From: john [EMAIL PROTECTED] Date: Sat, 23 Nov 2002 15:21:26 -0800 (PST) Subject: instance shutdown problem ? (please help) ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle alert.log show that the instance being shutdown just after the box boots up. how do we rectify this problem ? below is from the alert.log ORA-205 signalled during: alter database mount exclusive.. Shutting down instance (abort) License high water mark = 5 Instance terminated by USER, pid = 144 --- please note: the shutdwon was not initiated by any admin or user but done by the system itself after the box boots up. This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle you have just received a card from .
What is this, flippin' Virii Day or what? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Jay Earle (DBA) [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Subject: Oracle you have just received a card from . http://www.hkg3.com/f.gif Oracle, recently sent you a postcard. Retrieve your postcard by using this URL. http://www.FriendGreetings.com/pickup.aspx?code=Oracle http://www.hkg3.com/pickup.html?code=Oracleid=2511021 id=2511021 Comment- Oracle, View the card just created. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle-L you've received a greeting card emailed by .
http://207.21.232.104/f.gif Oracle-L, posted you an ecard greeting. Read your ecard by clicking here; http://www.Friend-Greetings.com/pickup.aspx?code=Oracle-L http://207.21.232.104/pickup.html?code=Oracle-Lid=2511024 id=2511024 Note: Oracle-L, Go get the ecard just emailed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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 NOT OPEN EMAIL I JUST SENT YOU!
It's a worm/virus - Do NOT try to view the ecard. JUST DELETE IT Sorry - hope you're well. bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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: how do I calculate the Oracle's usage
I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application You can try the following. Substitute the name of the database for ABCD in the awk command. On a multi-cpu box, the sum can be more than %100. ps -eo %cpu -o args | awk '$2 ~ /ABCD/ {sum = sum + $1}; END {print sum}' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
BackupExec Oracle
Title: BackupExec Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that effective immediately Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: Two bugs in 9202 (that bit us)
Well that's hardly acceptable for a current release. Is there a BUG filed for this to get the fix in 9.2.0.4 or a one-off patch? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, November 25, 2002 11:29 AM To: Multiple recipients of list ORACLE-L FYI, Oracle 9202 ... If you are using intermedia and have cursor_sharing to anything other than EXACT, oracle will start throwing ORA-600 errors. You can set it to EXACT (the only workaround) at session level if you want, but I recommend to set it in init. This is fixed in 10i. Also we ran into a problem with ora-600 [kclchkinteg_15] (you have two global cache buffers pointing to same data block buffer but in incompatible mode) ... this is in 9202, a patch is out, we will test it today tomorrow and see how that works. Then I ask myself ... isn't it fun to be on the cutting edge of the release? Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: my messages are not getting to list. trying to testeom
Your message was received by the list. At 10:41 AM 11/25/02 -0800, you wrote: ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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 you have just received a card from .
If the below link is what I think it is, its a sleasy form of spam (as if there is nice form of spam). I received something similar from a friend a few weeks ago. The web site wants you to download some software so that you can read a greeting card from your friend. If you read the End User Agreement, it says that they have the right to send an email greeting to everyone in your Outlook Address Book if you use their software. I didn't bother to install beyond that point. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 11/25/2002 1:51 PM, [EMAIL PROTECTED] wrote: What is this, flippin' Virii Day or what? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From:Jay Earle (DBA) [SMTP:[EMAIL PROTECTED]] Sent:Monday, November 25, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Subject: Oracle you have just received a card from . http://www.hkg3.com/f.gif Oracle, recently sent you a postcard. Retrieve your postcard by using this URL. http://www.FriendGreetings.com/pickup.aspx?code=Oracle http://www.hkg3.com/pickup.html?code=Oracleid=2511021 id=2511021 Comment- Oracle, View the card just created. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Earle (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey 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:Anyone else had a Virus alert for Stephane Faroult's ema
Yep, love NAV. At 10:51 AM 11/25/2002 -0800, you wrote: YUP Dick Goulet Reply Separator Author: Martin Kendall [EMAIL PROTECTED] Date: 11/25/2002 7:14 AM My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill CONNER 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: how do I calculate the Oracle's usage
Wouldn't this only give me the statistics for MY current session? I'm looking for the data on all the running sessions. Gene --- Jeremiah Wilton [EMAIL PROTECTED] wrote: How about you collect the following value from each instance on the host, wait a few hours, then collect the numbers again? You can then subtract the earlier values from the later values, and you'll have a good idea which instances are using more CPU relative to the others. SQL select value from v$sysstat where name = 'CPU used by this session'; -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Gurelei wrote: I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application running against it is taking. There are several databases on that server and I'm only interested in one so vmstat won't really help that much. Besides just running ps -ef | grep INSTANCE is there any other way for me to get a feeling of the load that puts on the CPU my database? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: Sr. Oracle DBA Position- Must be 8i and 9i Certified-
I guess the response wasn't overwhelming if he is re-posting this again so soon. I wonder if they missed the whole discussion awhile back about the people who never heard from them after sending resumes. I use the frequency of these messages and the quality of the job as a barometer for the condition of the job market. Stephen [EMAIL PROTECTED] 11/25/02 10:14AM Great opportunity for a Sr. Oracle DBA with 8i AND 9i certification to join this software industry leader in Charlotte, North Carolina. Base salary is in the 90-120K range and depends on experience. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. Interested candidates will be required to complete a company questionnaire that must be submitted with the resume. *Description of duties: Production support of operations required to maintain 7x24 database/application availability. Logical Design and Physical Design in support of Production/Development Database operations and support in Solaris/Linux ORACLE 8i/9i environment. Essential Functions: Backup/recovery, RMAN, Performance tuning, Shell scripting in Korn and Bourne Shells. ORACLE Internet Directory, ORACLE Enterprise Manager, development/documentation of standards and procedures. ORACLE DBA duties to include user management data exports and imports, writing ORACLE scripts, general monitoring of system performance. Assisting users with SQL and PL/SQL needs in day-to-day operations and implementation of logical designs. * Requirements: -Oracle 8i and 9i Certification -7+Years in IT -5+ years of Production Oracle DBA experience..including 8i and 9i -Knowledge of OPS/RAC, OEM -Proficient with SQL, PL/SQL, unix shell scritping -Expert understanding of Oracle architecture -Full understanding of Database concepts -Knowledge of relational database design -Must be a Self-starter. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/Charlotte/Certified DBA/Carol We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Problem doing RMAN backup of Clone?
Also, Oracle9iR2 has a new utility, DBNEWID, that allows you to change the DBID of a copied database safely. With it you can change: 1. The DBID 2. The DBNAME 3. A combination of 1 and 2. This utility is covered in pages 412-413 of my new RMAN book. Prior to 9iR2, you could also use (CAREFULLY) use the procedure sys.dbms_backup_restore.zerodbid. This is documented in page 395 of my RMAN Backup and Recovery book. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Monday, November 25, 2002 3:24 AM To: Multiple recipients of list ORACLE-L Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: virus
Since I joined this list I've noticed the number of virus's that my email virus scan picks up has grown quite a bit RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Monday, November 25, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Somebody is using this list to send a virus, beware ! Jeroen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Verzonden: maandag 25 november 2002 15:22 Aan: [EMAIL PROTECTED] Onderwerp: De antivirus-scanner op de firewall van Thomas Cook heeft een bericht dat aan [EMAIL PROTECTED] gericht was onderschept omdat er een virus in zit. Het bericht is geweigerd en wordt dus niet doorgestuurd. De email was verstuurd door: [EMAIL PROTECTED] Subject: De viruswaarschuwing is: va025044 = infected: Exploit.IFrame.FileDownload va025044 = infected: I-Worm.Klez.h We adviseren je om contact op te nemen met de afzender van dit bericht. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10i features
I am confident that we will see some good things out of OEM in the future Knowing who is working on it now, and knowing what they have done in the past, I've got a high degree of confidence ...AND expectation!! :-)) Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Monday, November 25, 2002 12:09 PM To: Multiple recipients of list ORACLE-L I'm not sure I'd go that far... Old habits (and prejudices) die hard... :-) -Original Message- Sent: Saturday, November 23, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Look for it to improve dramatically. I might even try to use it. Jared On Sunday 17 November 2002 06:13, J. Laurindo Chiappa wrote: Jared, just a thought : ** WHY ** Oracle experts charged in OEM developmentcan´t do anything close - fast, sweet simple , just to the point ?? Until now, OEM is just a pile of *hit, plain simple. Regards, Chiappa *** REPLY SEPARATOR *** On 13/11/02 at 05:23 Jared Still wrote: Check out OraC, written in Perl of course. :) http://www.tux.org/orac-dba/ Jared On Tuesday 12 November 2002 11:13, Jesse, Rich wrote: Good grief. Like I'm going to go through all of that overhead and hassle? And isn't 9iAS a separately licensable (read: cost) option, even if you're already licensed for EE? I think I'm reading the same PDF you were, Raj: The Console interacts with the Oracle Management Service, which, as a J2EE Web Application hosted by an Oracle9i application Server, leverages all of the reliability, scalability, and robustness of the Oracle9iAS instance. I wish I has time to work on the KISS-method OEM replacement I started... sigh Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 12, 2002 10:40 AM To: Multiple recipients of list ORACLE-L New EM4.0 (announced today) has a bunch of new features ... was just reading the PDF ... but it needs 9iAS ... that is a bummer ... more info on oracle website ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: BackupExec Oracle
Title: BackupExec & Oracle Lisa, One of our database servers is identical to your setup - Win2K/8.1.7.2/Veritas BackupExec. You'll need to create an Oracle user in each database for Veritas to connect to instances and know what tablespaces/datafiles there. Only gotcha is the fact that this new user will need to have some low level privs in order to be effective. You would then setup Veritas Oracle Agent to backup your databases, one by one. Then within Veritas Backup Manager you could create Oracle jobs (backup AND restores) manually, or rely on wizard. Either way has proven to work well for our two Win2K boxes. Not using RMAN though. Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC609-538-1000, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Monday, November 25, 2002 2:12 PMTo: Multiple recipients of list ORACLE-LSubject: BackupExec Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that "effective immediately" Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
Re: Anyone else had a Virus alert for Stephane Faroult's email ?
Martin Kendall wrote: My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin Name: smime.p7s smime.p7sType: PKCS7 Signature (application/x-pkcs7-signature) Encoding: 7bit Sorry for the trouble, folks, but I have trouble understanding. When I am answering the list, it is either from a Linux machine (and netscape) - not infected by W32.Klez.H@mm according to the Symantec site - or from a mail web interface. I sent the e-mail mentioned above on October 22nd or October 23rd (two answers to the same question) more than one month ago, and from Linux. I hope that somebody is not harvesting the list ... If anybody has any hint about how to check for viruses on a Linux machine, BTW ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Replication Manager
Replication Manager is a part of DBA Studio on OEM with 8i; On OEM with 9i, the DBA Studio is gone; so the replication manager is on OEM Console. I use it, for a quick and dirty look at things. I don't use it to create replication objects etc. However thjat's simply becuase I never used it earlier and am comfortable using the sql plus. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 12:39 PM Has anyone used Replication Manager with success? Any feedback on issues you may have run into would be greatly appreciated. Does it come bundled with OEM or is it typically on a separate CD as a Management Pack? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Anyone else had a Virus alert for Stephane Faroult's email ?
Stephane, Don't sweat it. Klez spoofs the sender in it's email, so it probably came from someone else's machine that had your email address somewhere on it. -rje S Sorry for the trouble, folks, but I have trouble understanding. When I S am answering the list, it is either from a Linux machine (and netscape) S - not infected by W32.Klez.H@mm according to the Symantec site - or from S a mail web interface. I sent the e-mail mentioned above on October 22nd S or October 23rd (two answers to the same question) more than one month S ago, and from Linux. I hope that somebody is not harvesting the list ... S If anybody has any hint about how to check for viruses on a Linux S machine, BTW ... S -- S Regards, S Stephane Faroult S Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: Anyone else had a Virus alert for Stephane Faroult's email ?
It's not from Stephane's computer (even if he were using a Windows machine). From Symantec's website: The subject line, message bodies, and attachment file names are random. The From address is randomly-chosen from email addresses that the worm finds on the infected computer. I've never gotten an e-mail with the Klez virus from the person who was listed in the From address. Very likely it's from someone else on the list who is infected. Since Fatcity doesn't pass on the original headers, Bruce is the only one who will be able to determine the original source. Stephane Faroult wrote: Martin Kendall wrote: My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin Name: smime.p7s smime.p7sType: PKCS7 Signature (application/x-pkcs7-signature) Encoding: 7bit Sorry for the trouble, folks, but I have trouble understanding. When I am answering the list, it is either from a Linux machine (and netscape) - not infected by W32.Klez.H@mm according to the Symantec site - or from a mail web interface. I sent the e-mail mentioned above on October 22nd or October 23rd (two answers to the same question) more than one month ago, and from Linux. I hope that somebody is not harvesting the list ... If anybody has any hint about how to check for viruses on a Linux machine, BTW ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler 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: BackupExec Oracle
If you're using BackupExec to backup the server's filesystems as well as the Oracle DB, make sure it does NOT hit your database files directly. Some Winders admins don't understand that it'll lock the datafiles, redos, controlfiles, etc from the instance, causing all sorts of icky recovery scenarios. At least a few years ago, it locked them under NT 4.0. I don't know if this behavior has changed (or is possible to change under NuTFutS) in newer versions. Good luck! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, November 25, 2002 2:12 PM To: Multiple recipients of list ORACLE-L Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that effective immediately Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Klez Worm Info
The Klez worm fakes its from address. Try checking the offending message's header to see whom it is actually from. Things are not always simple. A short time ago, I was asked if I had a virus as someone was receiving multiple copies of mail I sent to either this list or lazydba. I made the usual protestations of living a good life and having protected mail. The person replied they received six copies of my denial. That same day maintenance was being done and our mail gateway was temporarily closed. I received a message saying an outgoing mail message was blocked by this closure; the one saying, No way is it I. Before I apologized, many times over :), I queried our postmaster about the problem. She explained that the site which was receiving multiple copies was running a mail program with a bug. The bug kept the system from sending an acknowledgement of receipt to our system. Having received no receipt, our system was resending the message over and over again. She contacted their postmaster and I trust all is well. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, November 25, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Martin Kendall wrote: My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin Name: smime.p7s smime.p7sType: PKCS7 Signature (application/x-pkcs7-signature) Encoding: 7bit Sorry for the trouble, folks, but I have trouble understanding. When I am answering the list, it is either from a Linux machine (and netscape) - not infected by W32.Klez.H@mm according to the Symantec site - or from a mail web interface. I sent the e-mail mentioned above on October 22nd or October 23rd (two answers to the same question) more than one month ago, and from Linux. I hope that somebody is not harvesting the list ... If anybody has any hint about how to check for viruses on a Linux machine, BTW ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: Anyone else had a Virus alert for Stephane Faroult's email ?
It probably is not coming from where it appears. We have an alias for a group of us that field questions on a particular application. Every once in awhile we get a message that this virus has been found in a message that we have sent (supposedly from this alias). Since we are not sending under that alias we know that it is coming from somewhere else. Apparently when a machine is infected it sends out messages randomly using addresses from the addressbook for the to, from, and reply to. I'm guessing that if it is using an actual message for the basis of this it could also be using the from as well as the subject of that message. Pat Martin Kendall wrote: My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin Name: smime.p7s smime.p7sType: PKCS7 Signature (application/x-pkcs7-signature) Encoding: 7bit Sorry for the trouble, folks, but I have trouble understanding. When I am answering the list, it is either from a Linux machine (and netscape) - not infected by W32.Klez.H@mm according to the Symantec site - or from a mail web interface. I sent the e-mail mentioned above on October 22nd or October 23rd (two answers to the same question) more than one month ago, and from Linux. I hope that somebody is not harvesting the list ... If anybody has any hint about how to check for viruses on a Linux machine, BTW ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand 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).
Mass updates to production tables (NULL to non-NULL)
I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on three different columns. Each is a CHAR, so I shouldn't need to worry about chaining, since that column's full size has already been allocated in the block, right? But the first column has 1.2M NULLs out of 1.45M rows. My first test was to just UPDATE mytable SET mycol = ' ' WHERE mycol IS NULL, after removing the index on that column. Seeing as there were many more rows updated than I had anticipated, I was going to test the UPDATE using a cursor, and committing at every 10K rows (~120 total commits) to reduce rollback and locking issues. Thoughts? Since this table is used for time-and-attendance and directly affects payroll, downtime isn't possible. TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Two bugs in 9202 (that bit us)
Title: RE: Two bugs in 9202 (that bit us) For the intermedia you can request a one off patch for 9202 ... last I checked it wasn't part of 9203 yet ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 2:12 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two bugs in 9202 (that bit us) Well that's hardly acceptable for a current release. Is there a BUG filed for this to get the fix in 9.2.0.4 or a one-off patch? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, November 25, 2002 11:29 AM To: Multiple recipients of list ORACLE-L FYI, Oracle 9202 ... If you are using intermedia and have cursor_sharing to anything other than EXACT, oracle will start throwing ORA-600 errors. You can set it to EXACT (the only workaround) at session level if you want, but I recommend to set it in init. This is fixed in 10i. Also we ran into a problem with ora-600 [kclchkinteg_15] (you have two global cache buffers pointing to same data block buffer but in incompatible mode) ... this is in 9202, a patch is out, we will test it today tomorrow and see how that works. Then I ask myself ... isn't it fun to be on the cutting edge of the release? Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re[2]:Anyone else had a Virus alert for Stephane Faroult's
BTW: I just got a message from Steve. Seems tht he uses Linux Netscraper for mail so I doubt that it started from his end. So, anybody got an idea who the GD spammer on the list is??? Dick Goulet Reply Separator Author: Bill CONNER [EMAIL PROTECTED] Date: 11/25/2002 11:12 AM Yep, love NAV. At 10:51 AM 11/25/2002 -0800, you wrote: YUP Dick Goulet Reply Separator Author: Martin Kendall [EMAIL PROTECTED] Date: 11/25/2002 7:14 AM My Norton Antivirus reports that Stephane's email re. How to pass value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus in an item called stars-bkgrd. Anyone else had same alert ? Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill CONNER INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LONG's
Mike, You could look at the COPY command - provided you don't mind the table name changing or living in a different schema. I guess you could do a copy and then an alter table ... rename command. The syntax for the copy command is along the lines of: copy from user/pass@sid to user/pass@sid create tablename as sql - ie: select * from blah. I believe create can also be changed to insert, append, etc. You might also want to check the LONG buffer size. Unfortunately I'm working off my memory though, so you might have to refer to the manual. I think it's under SQL*Plus - I have a feeling the command only works within SQL*Plus. Regards, Mark. Hand, Michael T To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] HANDM@polaroi cc: d.com Subject: LONG's Sent by: [EMAIL PROTECTED] om 26/11/2002 02:59 Please respond to ORACLE-L OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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]
List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: BackupExec Oracle
Title: BackupExec & Oracle oh one more thing i failed to mention, recovery is a real pain. it will restore files with a very scre*** up names. it removes all backslashes and makes one whole big filename. u then need to do some surgery on it. it is not as simple as ebu/rman. i think they r doing this purposely bcos they would like us to purchase netbackup instead of the cheaper scaled down product backupexec. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 11:12 AMTo: Multiple recipients of list ORACLE-LSubject: BackupExec Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that "effective immediately" Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: Mass updates to production tables (NULL to non-NULL)
What about creating a view with nvl(column_name,chr(32)) for the columns involved? Greg -Original Message- Sent: Monday, November 25, 2002 4:04 PM To: Multiple recipients of list ORACLE-L I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on three different columns. Each is a CHAR, so I shouldn't need to worry about chaining, since that column's full size has already been allocated in the block, right? But the first column has 1.2M NULLs out of 1.45M rows. My first test was to just UPDATE mytable SET mycol = ' ' WHERE mycol IS NULL, after removing the index on that column. Seeing as there were many more rows updated than I had anticipated, I was going to test the UPDATE using a cursor, and committing at every 10K rows (~120 total commits) to reduce rollback and locking issues. Thoughts? Since this table is used for time-and-attendance and directly affects payroll, downtime isn't possible. TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mirsky, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BackupExec Oracle
we use backupexec 8.6 and it does not lock oracle files on NT4 or win2k. if u use the purge options and create a archivelog purge job and u hv some antivirus s/w like norton, then the access times get messed up and backupexec is not able to pick up files properly. netbackup uses rman/ebu. backupexec does not use rman/ebu. it has its own oracle agent which puts tablespaces in backup mode and takes them out. pretty reliable and i hv tested out the recoveries. a scheduled windows u just need to make sure that admins keep enough tapes in the dlt's. the only problems i face is that the backup job is waiting for more tapes. the only drawback is commandline and reporting aspect. in netbackup on unix i could use available_media script and find out how much is the tape used. i hv yet to figure this out in backupexec. -Mandar -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 12:52 PM To: Multiple recipients of list ORACLE-L Subject: RE: BackupExec Oracle If you're using BackupExec to backup the server's filesystems as well as the Oracle DB, make sure it does NOT hit your database files directly. Some Winders admins don't understand that it'll lock the datafiles, redos, controlfiles, etc from the instance, causing all sorts of icky recovery scenarios. At least a few years ago, it locked them under NT 4.0. I don't know if this behavior has changed (or is possible to change under NuTFutS) in newer versions. Good luck! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, November 25, 2002 2:12 PM To: Multiple recipients of list ORACLE-L Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that effective immediately Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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:
David; Try the parameter show=Y on the import command. This should show you whats in the export file. example parm file: FILE=('expdat.dmp') LOG=('temp.log') FULL=Y SHOW=Y -Original Message- Sent: Monday, November 25, 2002 3:41 PM To: Multiple recipients of list ORACLE-L List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
Do an imp show=y which simply shows the contents of the exp file without the rows. This way you can confirm that the table is not there. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 4:41 PM List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
You obviously know how to check it. Plain old egrep can parse the export file for CREATE TABLE too. It sounds like you might need to open up a commodity sized can of this stuff on the guy. http://www.squirtsplace.com/tackypics/wupass.html -Original Message- I can't convince this guy the table is not there. What else can I do? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Slightly OT - Who would you take with you...
Board - If you had to choose the 10 top posters here at Oracle-L who provided the biggest input and knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group? I'm asking because my mailbox is FULL, and I have to trash a large amount of the stored stuff thats here. I'm going to archive some of it to CD, but I have limited space, so I want to archive those people who are constantly offering the most insightful advice (I know it's available online, but I'm not always online and it's nice to be able to search these emails for targeted content). Anyone want to take a crack at a list? You are welcome to email me private if you are afraid you would hurt someone's feelings. I'd be happy to compile the lists and report back to the group the overall answers, but all email to me will be treated as strictly confidential. Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
David, Import with indexfile=filename and show=y should help. In message [EMAIL PROTECTED], Ehresmann, David [EMAIL PROTECTED] writes List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- John Thomas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Thomas 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: Mass updates to production tables (NULL to non-NULL)
It's actually being done for some sort of performance, since NULLs are not indexed. Although now it's suspect, since there are so many NULLs... Thx, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Mirsky, Greg [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Mass updates to production tables (NULL to non-NULL) What about creating a view with nvl(column_name,chr(32)) for the columns involved? Greg -Original Message- Sent: Monday, November 25, 2002 4:04 PM To: Multiple recipients of list ORACLE-L I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on three different columns. Each is a CHAR, so I shouldn't need to worry about chaining, since that column's full size has already been allocated in the block, right? But the first column has 1.2M NULLs out of 1.45M rows. My first test was to just UPDATE mytable SET mycol = ' ' WHERE mycol IS NULL, after removing the index on that column. Seeing as there were many more rows updated than I had anticipated, I was going to test the UPDATE using a cursor, and committing at every 10K rows (~120 total commits) to reduce rollback and locking issues. Thoughts? Since this table is used for time-and-attendance and directly affects payroll, downtime isn't possible. TIA! Rich Rich Jesse System/Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
important question about SID environment variable (NT)
for NT4.0 ver 8i does a typical oracle install create the environement variable SID ? i just checked, via set command on windows NT. the env variable for SID is not set. though there are other oracle related env variables like path, classpath that point to various files of oracle install etc so should i manually set the SID environment variable ?? if so how ? if set it manually then it is good for that shell only. what about programs like Database config assistant that are lauched via the StartProgramsOraHome. how would they read this or such an enviroment variable that is set via the command prompt. (env variable set via the command prompt with command like set variable1 = c:\ora\bin\. etc etc will only be vaild in that shell which created it. how to make it across the whole OS ? i am asking this because the Oracle DB Config Assistant requires the SID environment variable to be set. from where should i launch the GUI for oracle config assistant. if to be launched from shell ie command prompt, then what is the name of the executable for this GUI ? __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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).
basic question about db_name and sid
the SID is a string that identifies where to find the database. It is not necessarily the same as the database name. (here is the url from where i read this http://datavision.sourceforge.net/DataVision/create.html) first, is it true that sid need not be the same as the db name ? because in a typical oracle install you are asked to write sid and it actually becomes the db_name as well. right ? secondly what does this mean sid is a string that identifies where to find the database ? __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Slightly OT - Who would you take with you...
Robert Freeman Anjo Kolk Cary Millsap Connor McDonald Kirti Deshpande Jared Still Jeramiah Wilton John Kanagaraj Waleed Khedr Ian MacGregor Rachel Carmichael Tim Gorman Well that is more than 10, there are plenty of others that should be on this list. I have these posters highlighted then sort by subject or name. I can be pretty sure if I see a lot of red names that I am getting into something juicy and the other posters that are not mentioned will be right in there also. That way I can collect messages for a couple weeks and still get all the good stuff in an hour or so. Sorry if I got some lazy dba's mixed by in here. - Ethan -Original Message- Sent: Monday, November 25, 2002 4:05 PM To: Multiple recipients of list ORACLE-L Board - If you had to choose the 10 top posters here at Oracle-L who provided the biggest input and knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group? I'm asking because my mailbox is FULL, and I have to trash a large amount of the stored stuff thats here. I'm going to archive some of it to CD, but I have limited space, so I want to archive those people who are constantly offering the most insightful advice (I know it's available online, but I'm not always online and it's nice to be able to search these emails for targeted content). Anyone want to take a crack at a list? You are welcome to email me private if you are afraid you would hurt someone's feelings. I'd be happy to compile the lists and report back to the group the overall answers, but all email to me will be treated as strictly confidential. Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: how do I calculate the Oracle's usage
Even though the name of the statistic is CPU used by this session, the v$sysstat view contains aggregated data of the statistics of all sessions that have ever logged into your instance since it started. For consistency, they use the same statistic names as are used by the session-level statistics from v$sesstat, which is being aggregated in v$sysstat. The full list of statistics is in v$statname. So if you wanted your own statistics, you would have a query like this: select value from v$session s, v$sesstat ss, v$statname sn where s.audsid = userenv('sessionid') and s.sid = ss.sid and ss.statistic# = sn.statistic# and sn.name = 'CPU used by this session'; To get the total for everyone ever logged in up to now, just query v$sysstat. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Gurelei wrote: Wouldn't this only give me the statistics for MY current session? I'm looking for the data on all the running sessions. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: How about you collect the following value from each instance on the host, wait a few hours, then collect the numbers again? You can then subtract the earlier values from the later values, and you'll have a good idea which instances are using more CPU relative to the others. SQL select value from v$sysstat where name = 'CPU used by this session'; On Mon, 25 Nov 2002, Gurelei wrote: I'm trying to figure out how much of the srever's resources (CPU-wise) a database and the application running against it is taking. There are several databases on that server and I'm only interested in one so vmstat won't really help that much. Besides just running ps -ef | grep INSTANCE is there any other way for me to get a feeling of the load that puts on the CPU my database? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Slightly OT - Who would you take with you...
Robert, I think your own emails would have to count as one of the Top 10 people... Don't delete your sent folder! I've only been on this list for a short period of time (although I wish I had found it earlier) and I've noticed that there are several consistent posters of answers. I don't think it's fair to name ten people - different people have different niche's. If I wrote something about tuning it might be valid, if I wrote something about backup/recovery then you might as well trash it. Having said that I tend to listen to Cary, Rachel, Tim, Kirti, Jared and yourself especially closely. But there are many others who frequently have good input - that is what makes the list so powerful, you get the best bits of everyone. Regards, Mark. Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: Slightly OT - Who would you take with you... Sent by: [EMAIL PROTECTED] om 26/11/2002 09:04 Please respond to ORACLE-L Board - If you had to choose the 10 top posters here at Oracle-L who provided the biggest input and knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group? I'm asking because my mailbox is FULL, and I have to trash a large amount of the stored stuff thats here. I'm going to archive some of it to CD, but I have limited space, so I want to archive those people who are constantly offering the most insightful advice (I know it's available online, but I'm not always online and it's nice to be able to search these emails for targeted content). Anyone want to take a crack at a list? You are welcome to email me private if you are afraid you would hurt someone's feelings. I'd be happy to compile the lists and report back to the group the overall answers, but all email to me will be treated as strictly confidential. Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other
Re: LONG's
Mike, Conner pointed out that you could use C. You can also use Perl with DBI and DBD::Oracle if you like, and have someone there that can use it. Why not just convert them to CLOB and LOB? Jared Hand, Michael T [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:LONG's OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Mass updates to production tables (NULL to non-NULL)
You may have to worry about chaining. NULL columns use no space, even when they are CHAR() types. If you are planning a counted cursor loop, don't. You can update by rowid ranges (the slightly harder way) but one simple option is: update tableX set col_name = ' ' where col_name is null and rownum = 1; repeat until rows updated 10,000 Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) Denver___December 2/4 England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 25 November 2002 21:37 I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on three different columns. Each is a CHAR, so I shouldn't need to worry about chaining, since that column's full size has already been allocated in the block, right? But the first column has 1.2M NULLs out of 1.45M rows. My first test was to just UPDATE mytable SET mycol = ' ' WHERE mycol IS NULL, after removing the index on that column. Seeing as there were many more rows updated than I had anticipated, I was going to test the UPDATE using a cursor, and committing at every 10K rows (~120 total commits) to reduce rollback and locking issues. Thoughts? Since this table is used for time-and-attendance and directly affects payroll, downtime isn't possible. TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Have the other guy do the following: If on UNIX, strings dump_file_name | grep 'CREATE TABLE' table_names.lst else perform a dry imp run with indexfile= option. If the table existed then the generated file will have CREATE TABLE command (as a comment in the latter case). - Kirti -Original Message- Sent: Monday, November 25, 2002 3:41 PM To: Multiple recipients of list ORACLE-L List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_name from user_tables where table_name like '%BATCH_%'; all other tables are there like they should be, but not the 7th table. This is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in export file. When I test my imp statement against one of the other tables from the export file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).