RE: Database is 32 or 64 Bit ?
I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment if 64 bit Sun isalist -v If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version To check Oracle version - 2 methods do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) -Original Message- Sent: 04 October 2002 07:53 To: Multiple recipients of list ORACLE-L Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: svrmgrl echo v$database in script
Heh heh, Just popped in for a quicky !!! Regards Lee -Original Message- Sent: 03 October 2002 19:29 To: Multiple recipients of list ORACLE-L Lee, you're alive. I'll let the OT list know! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:33 PM Hi, This works #!/bin/ksh export ORACLE_SID=ADW export ORACLE_HOME=/usr/app/oracle/product/8.0.5 export PATH=$ORACLE_HOME/bin:$PATH svrmgrl EOF connect internal select name from v_\$database; exit EOF Just escape the $ sign with a backslash. HTH Lee -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:43 To: Multiple recipients of list ORACLE-L echo $ORACLE_SID logfile Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere that shuts down the database. I REALLY want to echo the name of the database into my log file before I shut down.While select name from v$database works fine from svrmgrl interactively, it throws up in the script. I'd guess the $ sign is screwing it up. (I can get other commands to work within the script.) However, I don't know what to do about it. Any ideas? Thx!!! Barb $ svrmgrl SVRMGR connect internal Connected. SVRMGR select name from v$database; NAME - TADENT 1 row selected. #!/usr/bin/ksh # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $ # Name: stop_db.sh # Author: Barb Baker # Purpose: execute shutdown immediate on current database # (i.e., database pointed to by current value of ORACLE_SID) echo Stop oracle instance \${ORACLE_SID}\ at `date` ${ORACLE_HOME}/bin/svrmgrl EOF connect internal select name from v_$database; EOF $ ./stop_db.sh Stop oracle instance tadent at Wed Oct 2 16:24:59 MDT 2002 SVRMGR Connected. SVRMGRselect name from v_ * ORA-00942: table or view does not exist SVRMGR Server Manager complete. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE: auto start db???
Leslie, Did you check your oradim.log? What it says? Also, you may check that your ORA_instance name_PFILE parameter in registry points correctly to your pfile. Yulduz. -Original Message- Sent: Thursday, October 03, 2002 3:41 PM To: Multiple recipients of list ORACLE-L Thank you for the feedback! ORA_SID_AUTOSTART is already set to true in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\... Any other suggestion? --- Igor Neyman [EMAIL PROTECTED] wrote: Under Windows if you want to startup database automatically (along with OracleService), you should set ORA_SID_AUTOSTART to TRUE in Windows registry under your Oracle_home key (HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\...) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 5:38 PM Hi, I have a 817 db on Win2000. The service is configured to be started automatically. But the database is not start up automatically. Everyday I need to manually issue Startup command. Also my collegue has 2 db (one 817, one 9i) on Win2000. The 817 db was be able to startup autolly, but ever since he installed 9i, none of the db starts autolly, even though both services are configured to be auto start. So how do I let the db start automatically? Thank you. Leslie __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yulduz Akhmedzanova INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman fun :), nightmare and long
What follows might be all hogwash, you could have tried this: DECLARE devtype varchar2(256); doneboolean; BEGIN devtype := dbms_backup_restore.deviceallocate('', params=''); dbms_backup_restore.restoresetdatafile; dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); dbms_backup_restore.restorebackuppiece('wherever_my_backups_are',done=done); END; / which drags a copy of the control file that was included in the backup into /tmp/foo.bar. (Obviously this has to be run against a different ie up database). Then startup nomount the db to be recovered, rman the 'replicate controlfile' and then restore/recover in the normal way. I think this functionality came in when they allowed a no-catalog mechanism, so if you lost everything, you could still make use of a backup. hth connor --- JOE TESTA [EMAIL PROTECTED] wrote: Ok so the qa environment we've been fooling around with rman for testing backup/recovery. tonite they say we want a backup restored from rman from 2 incarnations ago(for those of u who dont know what an incarnation is, its a new version of the database that gets created when you do open resetlogs -- if thats wrong please RMAN gurus correct me. So I get out the book, the docs say in the event you have to do this, which should be rare, you must do the reset database to incarnation command. seems easy enough, fire up rman, startup nomount, reset incarnation and it finds the old backups, and starts the restore. so far so good, but then the catch, being a rman newbie(8.1.7), i forgot to make a controlfile backup, now if i'd had that, this should have been cake,restore the control file in nomount mode, mount and restore the datafiles, recover the datafiles and open resetlogs, did i forget to say, this is a NOARCHIVELOGMODE database. Well, for whatever reason, the database wouldnt open, due to using a newer controlfile. hmmm, i've done this before, i'll just dump the controlfile to trace(yes i did this BEFORE the restore, just in case of an actual emergency). rebuild the control file, try the recover again(did i say we're going to a particular SCN based on the info from list backup/list incarnation commands), no deal, damn database will not open. regroup, wait a minute, rman aint anything special, let's do this: restore the files from rman backup again. exit rman sqlplus: recover database until scn ###; alter database open resetlogs; rman: check resync catalog; CHOKE, but i expected that, rman: reset database; full catalog sync AND we're good to go. Where did go wrong in using RMAN to do the recover/restore ??? joe = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How much memory is an oracle shadow process using
I know this has been discussed before and I have monitored the discussions but I am not sure that I have seen a clear summary and set of conclusions. I am trying to identify how much memory is used by the instance and all connections. I can show sga to give a total memory of the base instance /usr/sbin/pmap -x pid gives a rather verbose output and I struggle to work out exactly which of the lines is the one I am most interested in I have also tried ps -eo vsz,pid |grep 5225 where 5225 is the pid of an oracle connection and that returns a value that includes the SGA and also bigger than the return from the sql script below I run the following script to show me how much pga memory has been used for each process select name,sid,value/1024/1024 Curr Mb from v$sesstat a, v$database c where statistic# = 20 # shows current session PGA However I am convinced that that query is not accurate as it seems to return some very small values on systems that are quite busy. Also statistic# =21 which is the maximum for each process does not vary much from current which disturbs me a little as we have a lot of constant connections Has anybody got a easier/more accurate method of determing memory usage Thanks in anticipation John -- 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).
Wait Event queue messages
Qs Is Wait Event queue messages any Cause for Concern ? Qs If so What is the Resolution for the Same ? Qs Any Links , Docs for the Same ? Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- queue messages 1,0631,066,954 58.16 db file scattered read 1,937,704 408,204 22.25 latch free 66,364 212,801 11.60 buffer busy waits 57,849 98,8345.39 db file sequential read 1,531,718 25,0791.37 - Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i DBA Needed in NYC- Locals Only..
Kirti, They won't pay relocation, and they don't want someone who is going to be commuting back home on weekends 'cause they might need that person on a weekend :) Rachel --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Rachel, I don't mind getting that experience first hand ;) But why locals only? They will easily figure it out that I am not a local. Because, speaking 'Noo Yok' accent will be difficult for an Indian-Texan :( But I will watch a lot of 'NYPD Blue' and will try my best ;) Shall I send my resume to you? or to Bill Law? :-) - Kirti -Original Message- Sent: Thursday, October 03, 2002 5:24 PM To: Multiple recipients of list ORACLE-L you people are so flattering. but you might want to ask my ex-junior DBA (no I didn't fire him, we both got laid off) what it's like to work with me before you volunteer so readily. --- Bob Metelsky [EMAIL PROTECTED] wrote: --- Rachel Carmichael [EMAIL PROTECTED] wrote: well, if it's what I think it is (although I didn't know it went to Orastaff), it's working with me :) Count me in ;- bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman fun :), nightmare and long
yea the last question was rhetorical, i'd forgotten to back up the control file, a hole in my backup strategy. joe DENNIS WILLIAMS wrote: Joe - You da man. An impressive tour de force in working around RMAN. Was your last statement rhetorical? I think you answered that question - that you didn't have the right control file. Impressive that you were able to creatively work around the obvious limitation. This is the reason we test recovery scenarios, so that before the real disaster you've figured out that you need to back the control file up separately. Congratulations. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 03, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Ok so the qa environment we've been fooling around with rman for testing backup/recovery. tonite they say we want a backup restored from rman from 2 incarnations ago(for those of u who dont know what an incarnation is, its a new version of the database that gets created when you do open resetlogs -- if thats wrong please RMAN gurus correct me. So I get out the book, the docs say in the event you have to do this, which should be rare, you must do the reset database to incarnation command. seems easy enough, fire up rman, startup nomount, reset incarnation and it finds the old backups, and starts the restore. so far so good, but then the catch, being a rman newbie(8.1.7), i forgot to make a controlfile backup, now if i'd had that, this should have been cake,restore the control file in nomount mode, mount and restore the datafiles, recover the datafiles and open resetlogs, did i forget to say, this is a NOARCHIVELOGMODE database. Well, for whatever reason, the database wouldnt open, due to using a newer controlfile. hmmm, i've done this before, i'll just dump the controlfile to trace(yes i did this BEFORE the restore, just in case of an actual emergency). rebuild the control file, try the recover again(did i say we're going to a particular SCN based on the info from list backup/list incarnation commands), no deal, damn database will not open. regroup, wait a minute, rman aint anything special, let's do this: restore the files from rman backup again. exit rman sqlplus: recover database until scn ###; alter database open resetlogs; rman: check resync catalog; CHOKE, but i expected that, rman: reset database; full catalog sync AND we're good to go. Where did go wrong in using RMAN to do the recover/restore ??? joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman fun :), nightmare and long
Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). I attempted to bring the db in nomount and restore the control file, rman reply no controlfile backup found. joe Connor McDonald wrote: What follows might be all hogwash, you could have tried this: DECLARE devtype varchar2(256); doneboolean; BEGIN devtype := dbms_backup_restore.deviceallocate('', params=''); dbms_backup_restore.restoresetdatafile; dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); dbms_backup_restore.restorebackuppiece('wherever_my_backups_are',done=done); END; / which drags a copy of the control file that was included in the backup into /tmp/foo.bar. (Obviously this has to be run against a different ie up database). Then startup nomount the db to be recovered, rman the 'replicate controlfile' and then restore/recover in the normal way. I think this functionality came in when they allowed a no-catalog mechanism, so if you lost everything, you could still make use of a backup. hth connor --- JOE TESTA [EMAIL PROTECTED] wrote: Ok so the qa environment we've been fooling around with rman for testing backup/recovery. tonite they say we want a backup restored from rman from 2 incarnations ago(for those of u who dont know what an incarnation is, its a new version of the database that gets created when you do open resetlogs -- if thats wrong please RMAN gurus correct me. So I get out the book, the docs say in the event you have to do this, which should be rare, you must do the reset database to incarnation command. seems easy enough, fire up rman, startup nomount, reset incarnation and it finds the old backups, and starts the restore. so far so good, but then the catch, being a rman newbie(8.1.7), i forgot to make a controlfile backup, now if i'd had that, this should have been cake,restore the control file in nomount mode, mount and restore the datafiles, recover the datafiles and open resetlogs, did i forget to say, this is a NOARCHIVELOGMODE database. Well, for whatever reason, the database wouldnt open, due to using a newer controlfile. hmmm, i've done this before, i'll just dump the controlfile to trace(yes i did this BEFORE the restore, just in case of an actual emergency). rebuild the control file, try the recover again(did i say we're going to a particular SCN based on the info from list backup/list incarnation commands), no deal, damn database will not open. regroup, wait a minute, rman aint anything special, let's do this: restore the files from rman backup again. exit rman sqlplus: recover database until scn ###; alter database open resetlogs; rman: check resync catalog; CHOKE, but i expected that, rman: reset database; full catalog sync AND we're good to go. Where did go wrong in using RMAN to do the recover/restore ??? joe = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database is 32 or 64 Bit ? - Clarification
Hi Qs What do you mean by raw(4) / raw(8) ? Does it mean Length of the Field Data Value ? From my Database :- SQL select saddr from v$session where rownum 2 2 / SADDR 313941C0 CASE - Assuming on receiving a Database from a 3rd party 1) My Existing Installed ORACLE_HOME software is 64 - Bit 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of ) Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still show raw(4) values ? Thanks -Original Message- Sent: Friday, October 04, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment if 64 bit Sun isalist -v If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version To check Oracle version - 2 methods do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) -Original Message- Sent: 04 October 2002 07:53 To: Multiple recipients of list ORACLE-L Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Why Multiple Parses in Trace ?
Qs Why is the Followign Query being parsed 3 Times ? SELECT ORDER_ACTION_ID FROM TASK_LOCATION_DETAILS WHERE ORDER_ACTION_ID='7118439A1' AND LOCATION_CD='B' AND LOCATION_ID='LOCALNSTRTT' AND KIND_OF_INFO='A' call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch3 2.92 7.50 7430 9252 12 0 --- -- -- -- -- -- -- total9 2.92 7.50 7430 9252 12 0 Misses in library cache during parse: 1 Optimizer goal: RULE Parsing user id: 29 (BELGADOE) Rows Row Source Operation --- --- 0 TABLE ACCESS FULL TASK_LOCATION_DETAILS Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups
Isn't the object point in time recovery called LogMiner? :) -Original Message- Sent: Thursday, October 03, 2002 5:11 PM To: Multiple recipients of list ORACLE-L You are lucky to have all your databases in archivelog mode. We have large datawarehouses here, where business is quite acceptable to a recovery from a cold backup taken 3 months earlier. RMAN is goood, but waiting for Oracle to come out with an object point in time recovery, before we can completely do away with exports. Not that it cannot be done using RMAN, but with limited resources at our disposal, a logical backup and restore is much easier. Having said that, we use RMAN for 90% of our databases, and HP omniback as the media manager. Raj Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ate.ny.us Subject: RE: Backups Sent by: [EMAIL PROTECTED] October 03, 2002 04:17 PM Please respond to ORACLE-L I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a
Re: Database is 32 or 64 Bit ?
Ask the person that sent it to you? On Thursday 03 October 2002 23:53, VIVEK_SHARMA wrote: Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- 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).
RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Whoever takes the job, make sure you use spell checker!! ;o) -Original Message- Sent: Thursday, October 03, 2002 3:45 PM To: Multiple recipients of list ORACLE-L well, if it's what I think it is (although I didn't know it went to Orastaff), it's working with me :) --- [EMAIL PROTECTED] wrote: Damn, I had a smart%% remark I could make on this one, but then Rachel would never forgive me. Reply Separator Author: OraStaff [EMAIL PROTECTED] Date: 10/3/2002 11:37 AM Position: Sr. Oracle 8i DBA Location: New York, New York Industry: Publishing, Ecommerce Salary Range: 90-110K-depends on experience plus excellent benefits and bonus plan. *PLEASE DO NOT send your resume for this position UNLESS you already live in the Greater New York City area and have the skills outlined below for this position. 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. *Description: This well-established, very successful New York City based Fortune 500 Company is looking for a Senior Oracle 8i Database DBA to assist in the design and development of a database supporting the implementation of an enterprise content management system that will support major new ecommerce initiatives. As a Sr. Oracle 8i Database Administrator, you will assist in the design, development, testing and support of the development and production databases for this brand new, rapidly expanding Ecommerce environment. - Work extensively with various Ecommerce development teams,as well as database developers to assist in the development of various Content Management databases. - Create stored procedures, triggers, and functions. Daily support includes: extensive replication, performance tuning and monitoring, optimization of the databases, patches, upgrades, backups, redo logs, etc. - Perform data modeling, logical and physical design. Build physical databases from logical data model. - Provide support to the production DBA group on an as-needed basis. *Requirements: -BSCS degree or related discipline. -Must have 5+ years Oracle 8i DBA (development and production support) experience. -Must have strong experience working with Unix (Solaris preferred). -Extensive shell scripting experience is required. -Must have experience working in an Ecommerce (Transaction Based) Environment. -Content Management experience is a plus. -Full project life cycle experience required. -MUST HAVE Excellent verbal and written communication skills. -Must possess strong problem solving / analytical skills. -Any 9i experience is a plus. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/New York City//Oracle 8i DBA/Corey (*NYC area candidates only- no exceptions) ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael
RE: 8.1.7 patch it up?
Probably arguments both ways however if you have existing support from Oracle I would be inclined to upgrade to the terminal release of 8i since it will lengthen your support window (8i desupports Dec 2003). We have had to patch up to 8.1.7.3 for a few applications although we are running on Unix, there is always the chance you could hit a problem in the future which is fixed in 8.1.7.[2,3,4] however it is difficult to argue with if its not broken, don't fix it, probably depends on any upgrade plans you have, 9i ? 10i ?? Not sure about RMAN just investigating it myself no doubt others can comment. HTH, Neil McBain Oracle DBA - OCP 8i/9i -Original Message- Sent: 03 October 2002 15:03 To: Multiple recipients of list ORACLE-L I'm administering a number of production databases (mixture of standard and enterprise editions) most of which are version 8.1.7.0.0 on Windows NT and 2000. All are functioning fine and I have no issues. I'm considering patching (to 8.1.7.4) some if not all databases and just want to know if this is an absolute must if all systems are currently running fine. In other words does if its not broken, don't fix it apply? Also, I'm considering implementing RMAN in the near future and am wondering if there are significant issues with this on the unpatched 8.1.7 database. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: McBain, Neil SITI-ITDSEL314 INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wait Event queue messages
This is related to the AQ mechanism and can be ignored. Oracle posts this wait while waiting to dequeue a message from AQ queue. To remove it from the 'Top 5' list in statspack report, you can add a row to perfstat.stats$idle_event table. And while at it, you may want to review what other waits statspack considers as idle waits and doesn't report in the Top 5 list. But, you may want to know about some of those... Check Oracle8i Reference Guide for this and all other wait events and more.. :) - Kirti -Original Message- Sent: Friday, October 04, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Qs Is Wait Event queue messages any Cause for Concern ? Qs If so What is the Resolution for the Same ? Qs Any Links , Docs for the Same ? Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- queue messages 1,0631,066,954 58.16 db file scattered read 1,937,704 408,204 22.25 latch free 66,364 212,801 11.60 buffer busy waits 57,849 98,834 5.39 db file sequential read 1,531,718 25,079 1.37 - Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Backups
Dennis, I guess you just gotta have faith after a complete test of various types of recovery that the software works. Once it passes all your tests, and you are comfortable that it orks as advertised, it's just a matter of going for it. I am also convinced that Oracle support is able to help with Rman recovery as long as you use the software in an approved manner. This is one reason that I always stress to people on this list to use Oracle as the documentation says to use it - like the discussion the other day about putting indexes on SYS objects. Stuff like this gets you in trouble sooner or later. Cold backups are a good thing for the installed software. Stuff like the OS system files, Oracle software etc. But, in my view, we (as DBA's) just don't have the luxury anymore of taking a database offline for a backup - the costs (both in real $$'s and politically) are just too high. Especially when we are provided tools that are reliable. And Rman has entered this category. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, October 04, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Ruth, Tom, or anyone So what is the final checklist before you take a deep breath and stop cold backups. I have successfully run a disaster recovery test, but after so many years of the comfort of a cold to go back to, it sorta takes you back. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 03, 2002 3:33 PM To: Multiple recipients of list ORACLE-L I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
How about aliens, of the extraterrestrial kind. -Original Message- Sent: Thursday, October 03, 2002 4:11 PM To: Multiple recipients of list ORACLE-L and if it's what I think it is.. the job spec is wrong and while there is no relocation package, we did NOT say locals only and we have a couple of candidates going into the next round of interviews, before you all inundate me with your resumes! --- Rachel Carmichael [EMAIL PROTECTED] wrote: well, if it's what I think it is (although I didn't know it went to Orastaff), it's working with me :) --- [EMAIL PROTECTED] wrote: Damn, I had a smart%% remark I could make on this one, but then Rachel would never forgive me. Reply Separator Author: OraStaff [EMAIL PROTECTED] Date: 10/3/2002 11:37 AM Position: Sr. Oracle 8i DBA Location: New York, New York Industry: Publishing, Ecommerce Salary Range: 90-110K-depends on experience plus excellent benefits and bonus plan. *PLEASE DO NOT send your resume for this position UNLESS you already live in the Greater New York City area and have the skills outlined below for this position. 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. *Description: This well-established, very successful New York City based Fortune 500 Company is looking for a Senior Oracle 8i Database DBA to assist in the design and development of a database supporting the implementation of an enterprise content management system that will support major new ecommerce initiatives. As a Sr. Oracle 8i Database Administrator, you will assist in the design, development, testing and support of the development and production databases for this brand new, rapidly expanding Ecommerce environment. - Work extensively with various Ecommerce development teams,as well as database developers to assist in the development of various Content Management databases. - Create stored procedures, triggers, and functions. Daily support includes: extensive replication, performance tuning and monitoring, optimization of the databases, patches, upgrades, backups, redo logs, etc. - Perform data modeling, logical and physical design. Build physical databases from logical data model. - Provide support to the production DBA group on an as-needed basis. *Requirements: -BSCS degree or related discipline. -Must have 5+ years Oracle 8i DBA (development and production support) experience. -Must have strong experience working with Unix (Solaris preferred). -Extensive shell scripting experience is required. -Must have experience working in an Ecommerce (Transaction Based) Environment. -Content Management experience is a plus. -Full project life cycle experience required. -MUST HAVE Excellent verbal and written communication skills. -Must possess strong problem solving / analytical skills. -Any 9i experience is a plus. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/New York City//Oracle 8i DBA/Corey (*NYC area candidates only- no exceptions) ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web 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: Database is 32 or 64 Bit ? - Clarification
RAW is a datatype in oracle. Do a describe which gives the details of an object. For a table/view it tells you about the columns.See the TYPE, which tells you about the datatype of the column. If it is RAW(4) it is 32-bit, if RAW(8) 64-bit.SQL desc v$session;Name Null? Type--- SADDR RAW(4)SID NUMBERSERIAL# NUMBERAUDSID NUMBERPADDR RAW(4)USER# NUMBERUSERNAME VARCHAR2(30)COMMAND NUMBEROWNERID NUMBERTADDR VARCHAR2(8)LOCKWAIT VARCHAR2(8)STATUS VARCHAR2(8)SERVER VARCHAR2(9)SCHEMA# NUMBERSCHEMANAME VARCHAR2(30)OSUSER VARCHAR2(15)PROCESS VARCHAR2(9)MACHINE VARCHAR2(64)TERMINAL VARCHAR2(16)PROGRAM VARCHAR2(64)TYPE VARCHAR2(10)SQL_ADDRESS RAW(4)SQL_HASH_VALUE NUMBERPREV_SQL_ADDR RAW(4)PREV_HASH_VALUE NUMBERMODULE VARCHAR2(48)MODULE_HASH NUMBERACTION VARCHAR2(32)ACTION_HASH NUMBERCLIENT_INFO VARCHAR2(64)FIXED_TABLE_SEQUENCE NUMBERROW_WAIT_OBJ# NUMBERROW_WAIT_FILE# NUMBERROW_WAIT_BLOCK# NUMBERROW_WAIT_ROW# NUMBERLOGON_TIME DATELAST_CALL_ET NUMBERPDML_ENABLED VARCHAR2(3)FAILOVER_TYPE VARCHAR2(13)FAILOVER_METHOD VARCHAR2(10)FAILED_OVER VARCHAR2(3)RegardsNaveen-Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]Sent: Friday, October 04, 2002 5:38 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database is 32 or 64 Bit ? - ClarificationHiQs What do you mean by raw(4) / raw(8) ?Does it mean Length of the Field Data Value ?From my Database :-SQL select saddr from v$session where rownum 2 2 /SADDR313941C0CASE - Assuming on receiving a Database from a 3rd party1) My Existing Installed ORACLE_HOME software is 64 - Bit2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of )Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Stillshow raw(4) values ?Thanks-Original Message-Sent: Friday, October 04, 2002 1:03 PMTo: Multiple recipients of list ORACLE-LI posted the note below a few weeks ago, hope it helpsJohnListers,Here is a little summary of commands to identify the bit version of an o/sand 2 methods of identifying whether a database is a 32 bit or 64 bitinstallationOperating SystemCompaq Tru 64 - will be 64 bitHP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit RuntimeEnvironment if 64 bitSun isalist -vIf the return contains the phrase 'sparcv9' then it is a 64 bit o/sOracle VersionTo check Oracle version - 2 methodsdo a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64executableWithin sqlplus desc v$session and look for the definition of saddr (ifraw(4) then 32 bit else if raw(8) 64 bit)-Original Message-Sent: 04 October 2002 07:53To: Multiple recipients of list ORACLE-LGiven a Database . It is 32 Bit or 64 Bit , how can it be found ?Assuming Cold Backup of Database Sent from Elsewhere--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: VIVEK_SHARMA INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: VIVEK_SHARMA INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Multiple Oracle Homes for Oracle
Hi All, I am not very clear on how the Multiple Oracle Homes' concept works. Does one need an ORALE_HOME and ORACLE_SID environment veriable with appropriate values ONLY when starting the DB instance, or launching an application that uses these variables? Are these environment variables not accessed after that? To make my question clear, say, I need to start a database having SID = 'db1'. I do a $ export ORACLE_SID=db1 and export ORACLE_HOME=/opt/oracle/product/9201 and then connect to sqlplus and start the database. (FYI: Oracle on Linux) after this, if I unset the 2 environment variables or set them to some other garbage value, will anything go wrong? Cheers, Shantanu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shantanu Datta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman fun :), nightmare and long
Here is an example from 8.1.7.4 oracle@loki:/orabak rman nocatalog Recovery Manager: Release 8.1.7.4.0 - Production RMAN connect target / RMAN-06005: connected to target database: LIVL (DBID=750735866) RMAN-06009: using target database controlfile instead of recovery catalog RMAN run { 2 allocate channel c1 type disk; 3 set limit channel c1 kbytes=200; 4 backup full (database format '/orabak/tmp/ORA_O_%d_%t_%s_%p_%u'); 5 sql ALTER SYSTEM ARCHIVE LOG CURRENT; 6 change archivelog all crosscheck; 7 backup (archivelog all format '/orabak/tmp/ORA_A_%d_%t_%s_%p_%u'); 8 } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: c1 RMAN-08500: channel c1: sid=22 devtype=DISK RMAN-03022: compiling command: set limit RMAN-03023: executing command: set limit RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08008: channel c1: starting full datafile backupset RMAN-08502: set_count=1 set_stamp=474386022 creation_time=04-OCT-02 RMAN-08010: channel c1: specifying datafile(s) in backupset RMAN-08522: input datafile fno=1 name=/oras1/livl/livlsystem01.dbf RMAN-08011: including current controlfile in backupset RMAN-08522: input datafile fno=2 name=/oras3/livl/livlrbs01.dbf RMAN-08522: input datafile fno=8 name=/ora03/livl/livlretest01.dbf RMAN-08522: input datafile fno=3 name=/ora01/livl/livllivlt01.dbf RMAN-08522: input datafile fno=4 name=/ora02/livl/livllivlt02.dbf RMAN-08522: input datafile fno=5 name=/ora03/livl/livllivlt03.dbf RMAN-08522: input datafile fno=6 name=/orai1/livl/livllivli01.dbf RMAN-08522: input datafile fno=7 name=/orai2/livl/livllivli02.dbf RMAN-08013: channel c1: piece 1 created RMAN-08503: piece handle=/orabak/tmp/ORA_O_LIVL_474386022_1_1_01e4d3j6 comment=NONE RMAN-08525: backup set complete, elapsed time: 00:03:28 RMAN-03022: compiling command: sql RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT RMAN-03023: executing command: sql RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08009: channel c1: starting archivelog backupset RMAN-08502: set_count=2 set_stamp=474386265 creation_time=04-OCT-02 RMAN-08014: channel c1: specifying archivelog(s) in backup set RMAN-08504: input archivelog thread=1 sequence=586 recid=543 stamp=474386235 RMAN-08013: channel c1: piece 1 created RMAN-08503: piece handle=/orabak/tmp/ORA_A_LIVL_474386265_2_1_02e4d3qp comment=NONE RMAN-08525: backup set complete, elapsed time: 00:00:08 RMAN-08031: released channel: c1 So I've taken a backup...now can I get the control file back? oracle@loki:/orabak/tmp sqlplus internal SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 4 13:58:56 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production sys@livl DECLARE 2devtype varchar2(256); 3doneboolean; 4 BEGIN 5devtype := dbms_backup_restore.deviceallocate('',params=''); 6dbms_backup_restore.restoresetdatafile; 7 dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); 8 dbms_backup_restore.restorebackuppiece('/orabak/tmp/ORA_O_LIVL_474386022_1_1_01e4d3j6',done=done); 9 END; 10 / PL/SQL procedure successfully completed. sys@livl exit Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production you have mail in /var/mail/oracle oracle@loki:/orabak/tmp ls -l /tmp/foo.bar -rw-rw 1 oracle dba1908736 Oct 4 14:00 /tmp/foo.bar hth connor --- Joe Testa [EMAIL PROTECTED] wrote: Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). I attempted to bring the db in nomount and restore the control file, rman reply no controlfile backup found. joe Connor McDonald wrote: What follows might be all hogwash, you could have tried this: DECLARE devtype varchar2(256); doneboolean; BEGIN devtype := dbms_backup_restore.deviceallocate('', params=''); dbms_backup_restore.restoresetdatafile; dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); dbms_backup_restore.restorebackuppiece('wherever_my_backups_are',done=done); END; / which drags a copy of the control file that was included in the backup into /tmp/foo.bar. (Obviously this has to be run against a different ie up database). Then startup nomount the db to be recovered, rman the 'replicate controlfile' and then restore/recover in the normal way. I think this functionality came in when they allowed a no-catalog mechanism, so if you lost everything, you could still make use of a backup. hth connor --- JOE TESTA [EMAIL PROTECTED] wrote: Ok so the qa environment we've been fooling around with rman for
RE: Database is 32 or 64 Bit ? - Clarification
you need to 'describe' v$session, not to 'select' from it SQL desc v$session -Original Message- Sent: Friday, October 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi Qs What do you mean by raw(4) / raw(8) ? Does it mean Length of the Field Data Value ? From my Database :- SQL select saddr from v$session where rownum 2 2 / SADDR 313941C0 CASE - Assuming on receiving a Database from a 3rd party 1) My Existing Installed ORACLE_HOME software is 64 - Bit 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of ) Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still show raw(4) values ? Thanks -Original Message- Sent: Friday, October 04, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment if 64 bit Sun isalist -v If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version To check Oracle version - 2 methods do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) -Original Message- Sent: 04 October 2002 07:53 To: Multiple recipients of list ORACLE-L Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups
One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
Re:RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Rachel, Well, I for one will not apply. First off I've no use for NYC. Been there once in my life have absolutely no desire to return. I thought people in Boston were rude, was I ever in for a shock! Second, two bull headed people like us could never work together and live. One of us would have to die, probably me. *-) Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 10/3/02 2:23 PM you people are so flattering. but you might want to ask my ex-junior DBA (no I didn't fire him, we both got laid off) what it's like to work with me before you volunteer so readily. --- Bob Metelsky [EMAIL PROTECTED] wrote: --- Rachel Carmichael [EMAIL PROTECTED] wrote: well, if it's what I think it is (although I didn't know it went to Orastaff), it's working with me :) Count me in ;- bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman fun :), nightmare and long
The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING controlfile. My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible). I am asured that if we had no controlfile available we could restore controlfile and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile) So Joe, you only needed a copy of the control file because of the scenario you were running and you would not need to take a specific copy in the normal run of events? Is my understanding correct?. I know that no recovery/DR scenario can be considered normal but I am particularly interested if any situation where we need to recover from the last backup either a full database to a SCN or point in time or recover a single datafile Thanks John -Original Message- Sent: 04 October 2002 12:58 To: Multiple recipients of list ORACLE-L Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). -- 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).
anydata datatype update help
the subject line pretty much describes it. 9.2.0.1, Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, coredump) when we try to update the ANYDATA column. Within a PL/SQL process, using aliased tablenames and bind variables for all values: UPDATE MI.T_IN03_ObjPrpty SET IN03_Value_AD = :b7 ,IN03_Seq_NO = :b6 ,RF01_Publisher_KY = :b5 ,IN03_Amend_DT = :b4 ,RF02_Status_KY = :b3 ,IN03_Status_DT = :b2 WHEREIN03_ObjPrpty_KY = :b1 IN03_Value_AD is the ANYDATA column. Statement works fine if we remove that column. Statement blows up if we remove all OTHER columns or if we run it as is. We've posted an iTAR and are waiting. I've searched MetaLink and the docs. Nothing useful. But the search of the docs left me with a suspicion that you can't update an ANYDATA column. Has anyone either successfully updated an ANYDATA column or found documentation somewhere that says you can't? this is stopping development on a critical system. I'm not the primary DBA on it, but the consultant DBA doesn't have access to MetaLink and isn't on this list so I'm helping out. Suggestions? Worst case I suppose we could delete the original row and insert the new one but that's kludgy and messy and an additional performance hit on a system that needs to fly like the wind. I'd rather fix this properly... of course Oracle is capable of saying that the delete and insert IS the workaround and/or standard procedure for this. Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TNS-00510: Internal limit restriction exceeded
HI all We had those messages yesterday in the listener.log file TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Also on the unix side, we had a message about the OS that can not fork a new process. This is on 8172 32bits/AIX 4.3.3 The sga is 1.7G, the server has 8G of ram. There is between 150 and 300 users connected. The init.ora process parameter is set to 425. The unix number of process allowed is set to 500. I've check on metalink, but found nothing that we do not already do. Any ideas ? Thanks = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql query
sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Friday, October 04, 2002 2:23 AM Subject: RE: Sql query Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen NahataSent: Thursday, October 03, 2002 9:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Sql query Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL edWrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_maxSQL / NAME--Naveen SQL I can run your query, then what's the problem?SQL Regards Naveen -Original Message-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 03, 2002 2:53 PMTo: Multiple recipients of list ORACLE-LSubject: Sql query cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this
Re: rman fun :), nightmare and long
I haven't really been following this thread closely but whenever you do a level 0 rman backup it will include the controlfile. If you need to recover to a point in time you can recover using backup controlfile to that point in time. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 10:08 AM Here is an example from 8.1.7.4 oracle@loki:/orabak rman nocatalog Recovery Manager: Release 8.1.7.4.0 - Production RMAN connect target / RMAN-06005: connected to target database: LIVL (DBID=750735866) RMAN-06009: using target database controlfile instead of recovery catalog RMAN run { 2 allocate channel c1 type disk; 3 set limit channel c1 kbytes=200; 4 backup full (database format '/orabak/tmp/ORA_O_%d_%t_%s_%p_%u'); 5 sql ALTER SYSTEM ARCHIVE LOG CURRENT; 6 change archivelog all crosscheck; 7 backup (archivelog all format '/orabak/tmp/ORA_A_%d_%t_%s_%p_%u'); 8 } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: c1 RMAN-08500: channel c1: sid=22 devtype=DISK RMAN-03022: compiling command: set limit RMAN-03023: executing command: set limit RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08008: channel c1: starting full datafile backupset RMAN-08502: set_count=1 set_stamp=474386022 creation_time=04-OCT-02 RMAN-08010: channel c1: specifying datafile(s) in backupset RMAN-08522: input datafile fno=1 name=/oras1/livl/livlsystem01.dbf RMAN-08011: including current controlfile in backupset RMAN-08522: input datafile fno=2 name=/oras3/livl/livlrbs01.dbf RMAN-08522: input datafile fno=8 name=/ora03/livl/livlretest01.dbf RMAN-08522: input datafile fno=3 name=/ora01/livl/livllivlt01.dbf RMAN-08522: input datafile fno=4 name=/ora02/livl/livllivlt02.dbf RMAN-08522: input datafile fno=5 name=/ora03/livl/livllivlt03.dbf RMAN-08522: input datafile fno=6 name=/orai1/livl/livllivli01.dbf RMAN-08522: input datafile fno=7 name=/orai2/livl/livllivli02.dbf RMAN-08013: channel c1: piece 1 created RMAN-08503: piece handle=/orabak/tmp/ORA_O_LIVL_474386022_1_1_01e4d3j6 comment=NONE RMAN-08525: backup set complete, elapsed time: 00:03:28 RMAN-03022: compiling command: sql RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT RMAN-03023: executing command: sql RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08009: channel c1: starting archivelog backupset RMAN-08502: set_count=2 set_stamp=474386265 creation_time=04-OCT-02 RMAN-08014: channel c1: specifying archivelog(s) in backup set RMAN-08504: input archivelog thread=1 sequence=586 recid=543 stamp=474386235 RMAN-08013: channel c1: piece 1 created RMAN-08503: piece handle=/orabak/tmp/ORA_A_LIVL_474386265_2_1_02e4d3qp comment=NONE RMAN-08525: backup set complete, elapsed time: 00:00:08 RMAN-08031: released channel: c1 So I've taken a backup...now can I get the control file back? oracle@loki:/orabak/tmp sqlplus internal SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 4 13:58:56 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production sys@livl DECLARE 2devtype varchar2(256); 3doneboolean; 4 BEGIN 5devtype := dbms_backup_restore.deviceallocate('',params=''); 6dbms_backup_restore.restoresetdatafile; 7 dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); 8 dbms_backup_restore.restorebackuppiece('/orabak/tmp/ORA_O_LIVL_474386022_1_1 _01e4d3j6',done=done); 9 END; 10 / PL/SQL procedure successfully completed. sys@livl exit Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production you have mail in /var/mail/oracle oracle@loki:/orabak/tmp ls -l /tmp/foo.bar -rw-rw 1 oracle dba1908736 Oct 4 14:00 /tmp/foo.bar hth connor --- Joe Testa [EMAIL PROTECTED] wrote: Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). I attempted to bring the db in nomount and restore the control file, rman reply no controlfile backup found. joe Connor McDonald wrote: What follows might be all hogwash, you could have tried this: DECLARE devtype varchar2(256); doneboolean; BEGIN devtype := dbms_backup_restore.deviceallocate('', params=''); dbms_backup_restore.restoresetdatafile; dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar'); dbms_backup_restore.restorebackuppiece('wherever_my_backups_are',done=done ); END; / which drags a copy of the control file that was included in
Re: Backups
lol, OK my reasons for occasional cold backups. As a prior sysadmin, I prefer single user mode full filesystem backups (i.e. databases shut down) prior to any upgrade whether its an application, database, or operating system. There are benefits of cold over hot backups (of course this assumes you have the luxury to take a database offline): 1) Archive logs not needed. 2) No need to be concerned which databases are in archivelog mode. 3) Easier to backup and restore, even the sysadmin can do it :), i.e. no DBA required, no database recovery. OS utilities can be used for backup/restore. 4) Old habits are hard to break :). Gene [EMAIL PROTECTED] 10/04/02 01:38AM OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Darn! Besides I won't be qualified based on this requirement: Must have 5+ years Oracle 8i DBA (development and production support) experience. :( -Original Message- Sent: Friday, October 04, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Kirti, They won't pay relocation, and they don't want someone who is going to be commuting back home on weekends 'cause they might need that person on a weekend :) Rachel -- -- 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).
RE: Multiple Oracle Homes for Oracle
If you try to run sqlplus or any other sql utility on the database without those environment variables set, it won't know where to look for the utilities or where to look for a database whose name it doesn't know. Your best bet to see exactly what it does is do what you are describing and try to run sqlplus to access the database and see what happens. But this isn't really the multiple homes concept. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Friday, October 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi All, I am not very clear on how the Multiple Oracle Homes' concept works. Does one need an ORALE_HOME and ORACLE_SID environment veriable with appropriate values ONLY when starting the DB instance, or launching an application that uses these variables? Are these environment variables not accessed after that? To make my question clear, say, I need to start a database having SID = 'db1'. I do a $ export ORACLE_SID=db1 and export ORACLE_HOME=/opt/oracle/product/9201 and then connect to sqlplus and start the database. (FYI: Oracle on Linux) after this, if I unset the 2 environment variables or set them to some other garbage value, will anything go wrong? Cheers, Shantanu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shantanu Datta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin 666 InterScan_Disclaimer.txt M0U-502 R,# R.B @26UA9VEN92!T:4@4]SVEB:6QI=EER$-D-OG!O MF%T92!37-T96US($%N;G5A;!5V5RR!!W-O8VEA=EO;B!#;VYF97)E M;F-E#0I7:5N.B!/8W1O8F5R(#(M-P@,C P,@T*5VAEF4Z($-AFEB92!2 M;WEA;4@4F5S;W)T( @3W)L86YD;RP@1DP@(%5300T*1F]R(UOF4@:6YF M;W)M871I;VX@9V\@=\@=W=W+F-S961G92YC;VT-@T*#0H-E1H92!I;F9O MFUA=EO;B!C;VYT86EN960@:6X@=AIR!E+6UA:6P@:7,@W1R:6-T;'D@ M8V]N9FED96YT:6%L(%N9!F;W(@=AE(EN=5N95D('5S92!O9B!T:4@ M861DF5SV5E(]N;'D[(ET(UA2!A;'-O()E(QE9V%L;'D@')I=FEL M96=E9!A;F0O;W(@')I8V4@V5NVET:79E+B @3F]T:6-E(ES(AEF5B M2!G:79E;B!T:%T(%N2!D:7-C;]S=7)E+!UV4@;W(@8V]P6EN9R!O M9B!T:4@:6YF;W)M871I;VX@8GD@86YY;VYE(]T:5R('1H86X@=AE(EN M=5N95D(')E8VEP:65N=!IR!PF]H:6)I=5D(%N9!M87D@8F4@:6QL M96=A;X@($EF('EO=2!H879E(')E8V5I=F5D('1H:7,@;65SV%G92!I;B!E MG)OBP@QE87-E(YO=EF2!T:4@V5N95R(EM;65D:6%T96QY()Y M(')E='5R;B!E+6UA:6PN@I#;W)P;W)A=4@4WES=5MRP@26YC+B!H87,@ M=%K96X@979EGD@F5AV]N86)L92!PF5C875T:6]N('1O(5NW5R92!T M:%T(%N2!A='1A8VAM96YT('1O('1H:7,@92UM86EL(AAR!B965N('-W M97!T(9OB!V:7)UV5S+B @5V4@86-C97!T(YO(QI86)I;ET2!F;W(@ M86YY(1A;6%G92!S=7-T86EN960@87,@82!R97-U;'0@;V8@V]F='=AF4@ M=FER=7-ER!A;F0@861V:7-E('EO=2!C87)R2!O=70@6]UB!O=VX@=FER M=7,@8VAE8VMS()E9F]R92!O5N:6YG(%N2!A='1A8VAM96YT+@T*#0H- #@T* end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman fun :), nightmare and long
When you are doing point-in-time recovery you have to use the backup controlfile anyway and start with a level 0 which has the backup controlfile and roll forward using incrementals or just the archivelogs. I don't know if this answers your question but I will be glad to try again with more info. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 9:53 AM The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING controlfile. My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible). I am asured that if we had no controlfile available we could restore controlfile and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile) So Joe, you only needed a copy of the control file because of the scenario you were running and you would not need to take a specific copy in the normal run of events? Is my understanding correct?. I know that no recovery/DR scenario can be considered normal but I am particularly interested if any situation where we need to recover from the last backup either a full database to a SCN or point in time or recover a single datafile Thanks John -Original Message- Sent: 04 October 2002 12:58 To: Multiple recipients of list ORACLE-L Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). -- 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql query
HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this
How to get rid of a column default value ?
Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups
I never heard that, and I never do them, except my recovery catalog database which I can shut down. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 10:03 AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Secretly recorded conversations by FBI between Rachel and her ex-junior DBAs What do you mean you don't have a version of this script for Oracle 5, 6, 7.1.6, 7.3.4, 8.0.5, 8.1.5, 8.1.7, 9.0.1, 9.2??? I have a version of every one one of my 1,831 scripts for Oracle 2.1 through pre-beta Oracle 10i. I thought you said you were a junior DBA? What?? You can't see that corrupted segment in the middle of this 10 terabyte hex dump of the database? Aren't you a DBA? What do you mean you fell asleep around 5:00 am this morning? You mean you can't whip out a 300 page presentation on Oracle tuning in one night? How do you ever expect to get promoted from a Database Operator to junior DBA? I am really disappointed in your lack of dedication to your Senior DBA. You know that I have a bet going with Richard (Niemiec) as to who will have the longest presentation.. What do you mean you've only written 139 of the 600 pages for my new Oracle DBA 101 for 10i book?? I got a schedule to keep... Your not going to get into trouble if you physically beat that DUH-veloper because his query didn't execute in under a second...Oh come on, they really don't tremble and shake when I talk to them. What do you mean that the DBCHR is only 99.9, that's not good enough... (this email was written with all my love and respect to Rachel, which is why I just couldn't help myself but tease her a little bit...) -Original Message- Sent: Thursday, October 03, 2002 6:24 PM To: Multiple recipients of list ORACLE-L you people are so flattering. but you might want to ask my ex-junior DBA (no I didn't fire him, we both got laid off) what it's like to work with me before you volunteer so readily. --- Bob Metelsky [EMAIL PROTECTED] wrote: --- Rachel Carmichael [EMAIL PROTECTED] wrote: well, if it's what I think it is (although I didn't know it went to Orastaff), it's working with me :) Count me in ;- bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups
Oracle 6 and prior releases required cold backups. Hot backups became available in version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's new book :). Gene [EMAIL PROTECTED] 10/04/02 10:03AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
RE: How to get rid of a column default value ?
My guess is to alter it DEFAULT NULL. Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -Original Message- From: Louis BROUILLETTE [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: How to get rid of a column default value ? Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael 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: Sql query
ARE YOU AN IDIOT -Original Message- Sent: 04 October 2002 16:13 To: Multiple recipients of list ORACLE-L HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
RE: Sql query
Obligatory... ARE YOU AN IDIOT? -Original Message- Sent: Friday, October 04, 2002 11:13 AM To: Multiple recipients of list ORACLE-L HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: Out of transaction slots
Raj, I've seen this problem when dblinks are used extensively. A transaction slot is allocated when a dblink is used, even if only selecting over the dblink. It remains allocated until the session commits or ends. However, if the session doesn't make any changes, it won't commit, and the user could stay connected all day, leading to problems. I've had developers put in a commit after selecting over a dblink in some such applications, and it solved the problem. Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Thursday, October 03, 2002 9:38 PM To: Multiple recipients of list ORACLE-L You can monitor the XACTS column in V$ROLLSTAT view to see how many active transactions are in each rollback segment. Alternatively, you can query as follows: select xidusn, status, count(*) from v$transaction group by xidusn, status; ...as you keep adding transactions... Should be fun! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 6:03 PM Thanks Tim for your response to this. I agree with you. For now, I have come up with this theory : I feel that the Unable to use system rollback tablespace errors were a result of the Out of transaction slots message. Transactions were assigned as they came in to different transaction slots in the rollback segments. Suppose, we had 21 transaction slots in each of the 20 rollback segments. This were utilized one by one by different transactions, and never released. So, the transactions never commited or rolled back, and they kept coming in. I think, as all the transaction slots in a rollback segment were utilized, that rollback segment was marked as not available for any more transactions. So, one by one, the rollback segments started going unavailable. No errors were reported anywhere in the logs when this was happening, because there were transaction slots available in other rollback segments. But finally when the last transaction slot in the last available rollback segment was utilized, the application log reported the Out of transaction slots in the error log to the next incoming transaction. This would also mark all the rollback segments as not available for transaction, whereby Oracle would then try to make use of the system rollback segment. Hence, all subsequent errors were for Unable to use system rollback segment for non system tables. This answers my questions, why did the Out of transaction slots error happen just once, whereas the Unable to use system rollback errors got reported for every subsequent transaction? Also, why was the Out of transaction slots reported first? Does it make sense? Anyways, I plan to conduct a test tomorrow where I keep just one rollback segment online, start more than 20 transactions, dont commit them, and then check the errors that should hopefully be reported after the 21st session. I wonder what the status of the rollback segment would be? Thanks Raj Tim Gorman Tim@SageLogiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] x.com cc: Sent by: Subject: Re: Out of transaction slots root@fatcity. com October 03, 2002 07:01 PM Please respond to ORACLE-L comments inline... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:34 PM Hi All, OPS 8.0.6.2 on Sun 2.6 nodes. The other day, the users reported that they were unable to complete transactions, and before we could take a proper look, the database was shutdown aborted, and started up. I am now trying to investigate possible reasons for these errors. Just before the shutdown at 00:15 AM, the alert log reported an error saying ORA-01595: error freeing extent (8) of rollback segment (2)) ORA-01554: out of transaction slots in transaction tables. Now, we have 20 rollback segments, 10 on each node, on a block size of 2k. So that would mean about approximately a total of (21*20) transaction slots. The total number of transaction slots is not relevant; only the number of slots per RBS. A new transaction is first assigned to an RBS; the algorithm which chooses is strictly LRU -- the number of available slots in the transaction table doesn't enter into it (though it easily could)... Later, we found that that application logs reported the ORA-01554 almost 2 hours before the alert log entry. Later, the logs had multiple errors saying ORA - Unable to use system rollback segment for non system tables. No one had taken the rollback segments offline. Also, there wasnt any large amount of transactions running as is reflected by the redo log
RE: anydata datatype update help
Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH - Original Message - From: Rachel Carmichael [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 04 Oct 2002 05:33:23 the subject line pretty much describes it. 9.2.0.1, Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, coredump) when we try to update the ANYDATA column. Within a PL/SQL process, using aliased tablenames and bind variables for all values: UPDATE MI.T_IN03_ObjPrpty SET IN03_Value_AD = :b7 ,IN03_Seq_NO = :b6 ,RF01_Publisher_KY = :b5 ,IN03_Amend_DT = :b4 ,RF02_Status_KY = :b3 ,IN03_Status_DT = :b2 WHEREIN03_ObjPrpty_KY = :b1 IN03_Value_AD is the ANYDATA column. Statement works fine if we remove that column. Statement blows up if we remove all OTHER columns or if we run it as is. We've posted an iTAR and are waiting. I've searched MetaLink and the docs. Nothing useful. But the search of the docs left me with a suspicion that you can't update an ANYDATA column. Has anyone either successfully updated an ANYDATA column or found documentation somewhere that says you can't? this is stopping development on a critical system. I'm not the primary DBA on it, but the consultant DBA doesn't have access to MetaLink and isn't on this list so I'm helping out. Suggestions? Worst case I suppose we could delete the original row and insert the new one but that's kludgy and messy and an additional performance hit on a system that needs to fly like the wind. I'd rather fix this properly... of course Oracle is capable of saying that the delete and insert IS the workaround and/or standard procedure for this. Rachel Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SqlServer - Oracle transfer issues
Hi gurus, I need to transfer a few tables from SqlServer to Oracle. I've installed Heteroegous Service between the SqlServer and our Oracle database according to the Metalink doc no : 109730.1 I began the transfer between those two databases with this kind of statement : create table TableA as select * from TableA@hsodbc; But now I have a problem with the tables on the SqlServer side that contain columns of the Text datatype. Oracle wants to handle it as a LONG datatype. I received this kind of errors : ORA-00997 : illegal use of LONG database What should I do ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql query
HELP! is this also sql server 7 command? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 11:13 AM HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
RE: fast tape drive for AIX
Hi Rahul; I tried to send you a file to your email, with diferents choices of tapes for your IBM server... but had no luck. We did kind of a survey to find the tape device that solved our problems of time during backup, and finally picked the IBM 7205 Model 345. Time during backup went down from 9 hours to 56 minutes. There is also the IBM 3580 Ultrium - Up to 200 GB compressed, 30MB/sec. The IBM 7208 Model 345 - supports three kinds of tapes; up to 50GB, 100 GB, or 150GB compressed, 30MB/sec. Check the info at the ibm page. Hope this helps! Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Rahul [mailto:[EMAIL PROTECTED]] Enviado el: Monday, September 30, 2002 1:23 AM Para: Multiple recipients of list ORACLE-L Asunto: OT: fast tape drive for AIX list, we are looking for a fast tape drive to backup all the volume groups on our IBM H70.. around 100GB+, our current backup takes around 5-6 hours !!! any ideas about a faster tape drive ? or an optical one ? regards -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups
Not mentioning that there is usually hot in Florida, so cold is good. Saying that, I wonder how many people would go into software upgrade or a major change without a full cold backup. -Original Message- Sent: Friday, October 04, 2002 10:28 AM To: Multiple recipients of list ORACLE-L lol, OK my reasons for occasional cold backups. As a prior sysadmin, I prefer single user mode full filesystem backups (i.e. databases shut down) prior to any upgrade whether its an application, database, or operating system. There are benefits of cold over hot backups (of course this assumes you have the luxury to take a database offline): 1) Archive logs not needed. 2) No need to be concerned which databases are in archivelog mode. 3) Easier to backup and restore, even the sysadmin can do it :), i.e. no DBA required, no database recovery. OS utilities can be used for backup/restore. 4) Old habits are hard to break :). Gene [EMAIL PROTECTED] 10/04/02 01:38AM OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands
Re: How to get rid of a column default value ?
Hi Louis Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Just set the default back to NULL. To apply the default: ALTER TABLE BONUS MODIFY (COMM DEFAULT 10 ); To remove the default: ALTER TABLE BONUS MODIFY (COMM DEFAULT NULL ); Regards Dale -- Check out the freeware DBATool: generate DDL recreation scripts and instant schema documentation via DDL to HTML conversion. http://www.DataBee.com/dt_home.htm -- 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: TNS-00510: Internal limit restriction exceeded
Get more cutlery! Increase the number of processes available both system-wide and per capita. -Original Message- From: paquette stephane [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: TNS-00510: Internal limit restriction exceeded HI all We had those messages yesterday in the listener.log file TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Also on the unix side, we had a message about the OS that can not fork a new process. This is on 8172 32bits/AIX 4.3.3 The sga is 1.7G, the server has 8G of ram. There is between 150 and 300 users connected. The init.ora process parameter is set to 425. The unix number of process allowed is set to 500. I've check on metalink, but found nothing that we do not already do. Any ideas ? Thanks = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to get rid of a column default value ?
Louis, I believe it is the ALTER TABLE command. ALTER TABLE name MODIFY ( column datatype); match the column name and the datatype but do not include the DEFAULT clause . Ron ROR mª¿ªm [EMAIL PROTECTED] 10/04/02 11:28AM Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql query
Are you an idiot? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 11:13 AM HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
Re: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Dick-- People in New York are actually very friendly and helpful. What you may have mistaken for rudeness is just the fact that they're always in a hurry! --- [EMAIL PROTECTED] wrote: Rachel, Well, I for one will not apply. First off I've no use for NYC. Been there once in my life have absolutely no desire to return. I thought people in Boston were rude, was I ever in for a shock! Second, two bull headed people like us could never work together and live. One of us would have to die, probably me. *-) Dick Goulet __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups
I agree with you Ruth. Ray, this may be something that your local DBA read in an older manual someplace. Have your DBA start reading about Rman. If he/she needs to see it in a book, it might change his/her mind. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, October 04, 2002 11:18 AM To: Multiple recipients of list ORACLE-L I never heard that, and I never do them, except my recovery catalog database which I can shut down. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 10:03 AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle
Shell scripting
Hi I wanted to select a column from a v$ table struggled with it and finally came with a workaround as follows archived_log='$archived_log' begin_seq=`sqlplus -s /nolog EOF connect / as sysdba set head off set echo off set feedback off set verify off select max(sequence#)-1 from v$archived_log ; exit EOF` echo $begin_seq --- However, the question is how to 'directly' take the output into a shell variable? there 'shud be' a better workaround than this ! Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help on creating this report (any method)
I have to create a tabular quarterly summary report, based on 4 different queries, but all are grouped by the same columns. Any suggestions on how to accomplish this - sql report etc. Thanks a lot. Type category Col1 Col2 Col3 Col4 Elec Fac 500 100 200 400 ElecRates300 200 50 450 Elec Fran 200 100 50 250 Gas Fac 700 300 200 800 Gas Rates 900 100 600 400 Gas Fran 400 100 300 100 Col1 is count of open cases at start of quarter grouped by type and category Col2 is count of new cases opened during quarter grouped by type and category Col3 is count of cases closed in the quarter grouped by type and category Col4 is count of open cases at end of quarter grouped by type and category Col1 query is: select type, category, count(*) form case where status='Open' and date_filed'01-Jul-02' group by type, category; Col2 query is: select type, category, count(*) from case where date_filed='01-Jul-02' group by type, category; Col3 query is select type, category, count(*) form case where status='Closed' and date_closed='01-Jul-02' and date_closed='03-Sep-02' group by type, category; Col4 query is select type, category, count(*) form case where status='Open' group by type, category; Chat with friends online, try MSN Messenger: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erma Fernando INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i DBA Needed in NYC- Locals Only..
that last comment was very very smart, I'd have had to send some of my enforcers to beat on you otherwise my presentations don't compete in number of slides with Mr Niemiec (all my respect to him, I don't know how he manages to get through all that in the alloted time!). In fact, I was questioned on whether or not I could fill an hour on just 17 slides (I did ) and no one but me (and my co-authors of course) write our books you are cruising for a bruising. conversations actually were more along these lines (our desks faced each other, so I could see his face as he worked) do you want to talk to me about this report? 10 minutes later, after seeing some interesting grimaces and facial contortions are you SURE you don't want to talk to me about this report? 20 minutes later, when he says help.. how about trying it this way? --- Grabowy, Chris [EMAIL PROTECTED] wrote: Secretly recorded conversations by FBI between Rachel and her ex-junior DBAs What do you mean you don't have a version of this script for Oracle 5, 6, 7.1.6, 7.3.4, 8.0.5, 8.1.5, 8.1.7, 9.0.1, 9.2??? I have a version of every one one of my 1,831 scripts for Oracle 2.1 through pre-beta Oracle 10i. I thought you said you were a junior DBA? What?? You can't see that corrupted segment in the middle of this 10 terabyte hex dump of the database? Aren't you a DBA? What do you mean you fell asleep around 5:00 am this morning? You mean you can't whip out a 300 page presentation on Oracle tuning in one night? How do you ever expect to get promoted from a Database Operator to junior DBA? I am really disappointed in your lack of dedication to your Senior DBA. You know that I have a bet going with Richard (Niemiec) as to who will have the longest presentation.. What do you mean you've only written 139 of the 600 pages for my new Oracle DBA 101 for 10i book?? I got a schedule to keep... Your not going to get into trouble if you physically beat that DUH-veloper because his query didn't execute in under a second...Oh come on, they really don't tremble and shake when I talk to them. What do you mean that the DBCHR is only 99.9, that's not good enough... (this email was written with all my love and respect to Rachel, which is why I just couldn't help myself but tease her a little bit...) -Original Message- Sent: Thursday, October 03, 2002 6:24 PM To: Multiple recipients of list ORACLE-L you people are so flattering. but you might want to ask my ex-junior DBA (no I didn't fire him, we both got laid off) what it's like to work with me before you volunteer so readily. --- Bob Metelsky [EMAIL PROTECTED] wrote: --- Rachel Carmichael [EMAIL PROTECTED] wrote: well, if it's what I think it is (although I didn't know it went to Orastaff), it's working with me :) Count me in ;- bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
RE: Sql query
ARE YOU AN IDIOT! ;o) -Original Message- Sent: Friday, October 04, 2002 10:13 AM To: Multiple recipients of list ORACLE-L HELP! -Original Message- Sent: 04 October 2002 14:53 To: Multiple recipients of list ORACLE-L sql server 7??? and you are trying to find an answer on Oracle board? Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:23 AM Hi naveen, cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. i am executing this query in sql server 7 santosh -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen Nahata Sent: Thursday, October 03, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Santosh, your query is working. See below SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10) 4 ); Table created. SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES CLIENT(CLIENTID) 5 ); Table created. SQL insert into client values(1, 'Naveen'); 1 row created. SQL insert into client values(2, 'Santosh'); 1 row created. SQL insert into project values(1, 'Oracle', 1); 1 row created. SQL insert into project values(2, 'Java', 1); 1 row created. SQL insert into project values(3, 'SQL', 2); 1 row created. SQL commit; Commit complete. SQL ed Wrote file afiedt.buf 1 SELECT name 2 FROM (SELECT c.name, COUNT(p.clientid) p_count 3 FROM client c, project p 4 WHERE c.clientid = p.clientid 5 GROUP BY c.name) a, 6 (SELECT MAX(COUNT(clientid)) p_max 7 FROM project 8 GROUP BY clientid) b 9* WHERE a.p_count = b.p_max SQL / NAME -- Naveen SQL I can run your query, then what's the problem? SQL Regards Naveen -Original Message- Sent: Thursday, October 03, 2002 2:53 PM To: Multiple recipients of list ORACLE-L cannot perform an aggregate function on an expression containing an aggregate or subquery is the error i am getting while i am executing the query. SELECT name FROM (SELECT c.name, COUNT(p.clientid) p_count FROM client c, project p WHERE c.clientid = p.clientid GROUP BY c.name) a, (SELECT MAX(COUNT(clientid)) p_max FROM project GROUP BY clientid) b WHERE a.p_count = b.p_max clientid and name are the columns in client table and projectid and clientid are the columns in project table. santosh -Original Message- Ignaszak Sent: Monday, September 30, 2002 6:09 PM To: Multiple recipients of list ORACLE-L try it: select name from (select c.name, count(p.id) p_count from clients c, projects p where c.id = p.cl_id group by c.name) a, (select max(count(id)) p_max from projects group by cl_id) b where a.p_count = b.p_max Regards, Leszek At 03:23 2002-09-30 -0800, you wrote: Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ?? like project 1 client 1 project 2 client 1 project 3 client 2 in the above case, the query should return client ( 1 ). Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leszek Ignaszak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: How to get rid of a column default value ?
update table set column = null -Original Message- Sent: Friday, October 04, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups
I believe it shows up in some upgrade documentation. I know our Oracle rep recommended it. And I'll admit that I did a cold backup before my upgrade rather than hot just because it's a little easier to recover from if a problem arises (I just padded the downtime for my upgrade to include the cold backup time). Jay Miller -Original Message- Sent: Friday, October 04, 2002 10:03 AM To: Multiple recipients of list ORACLE-L One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
Password is not case sensity and uncrypted
Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 HTTP Server with Jserv
Anyone using the subject matter above. I am getting complaints that suddenly the database going wrong. What the developers are saying is that the JSP stuff that they are creating are not being compiled automatically as before. Everything looks fine from my perspective processes etc. etc. smime.p7s Description: application/pkcs7-signature
Re: Backups
I would do a cold backup of the Oracle executables and application stuff but I would do an rman level 0 for the database(s). Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 12:18 PM Not mentioning that there is usually hot in Florida, so cold is good. Saying that, I wonder how many people would go into software upgrade or a major change without a full cold backup. -Original Message- Sent: Friday, October 04, 2002 10:28 AM To: Multiple recipients of list ORACLE-L lol, OK my reasons for occasional cold backups. As a prior sysadmin, I prefer single user mode full filesystem backups (i.e. databases shut down) prior to any upgrade whether its an application, database, or operating system. There are benefits of cold over hot backups (of course this assumes you have the luxury to take a database offline): 1) Archive logs not needed. 2) No need to be concerned which databases are in archivelog mode. 3) Easier to backup and restore, even the sysadmin can do it :), i.e. no DBA required, no database recovery. OS utilities can be used for backup/restore. 4) Old habits are hard to break :). Gene [EMAIL PROTECTED] 10/04/02 01:38AM OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use
Re: TNS-00510: Internal limit restriction exceeded
Funny you should mention... We had the same problem with an 8170 64bit db on AIX 4.3.3 yesterday at about 14:30. Paging space had become exhausted. In brief, I'm guessing the rash of memory leaks in 8170-8172 (or the temporary fix I did until I can patch to 8174) is the cause. Details below: The box is an M80 with 4GB main memory, 1GB paging space. Two dbs, db1 has sga of ~530M, db2 has sga of ~180M. When I looked at the server,paging space usagewas at 97%. Trying to run commands at the unix prompt generated the following: ksh: 0403-031 The fork function failed. There is not enough memory available. To protect itself, the opsys had aparently also killed a few processes as evidenced by a handful of PGSP_KILL errors in the system error log. As users and developers (don't ask) began to bail off, paging space usage dropped to 86% and we were able to maintain connectivity until a (previously scheduled) maintenance window yesterday evening. Here is how the paging space looked as we brought the dbs down: Before either dbis down:# lsps -a Page Space Physical Volume Volume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 1024MB 86 yes yes lvAfterdb2 is brought down (this indicates db2 with sga of 180M had 185M of paging space):# lsps -aPage Space Physical Volume Volume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 1024MB 68 yes yes lvAfter db1 is brought down (this indicates db1 with sga of 530M had 481M of paging space): # lsps -aPage Space Physical Volume Volume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 1024MB 21 yes yes lvAfter the reboot, before any dbs are up:# lsps -aPage Space Physical Volume Volume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 1024MB 1 yes yes lvAfter the two dbs are back up:# lsps -aPage Space Physical Volume Volume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 1024MB 1 yes yes lv I had kicked the shared pool up a good bit on db112 days earlier along with a couple of other init parm changes to deal with ORA-04031 errors due to the memory leaks. Here are the relevant init parm entries (the _db_handles_cached parm will impact performance): # ORA-04031 errors with BAMIMA upon login. Until# patched to 8.1.7.4, kick up shared_pool, make shared_pool_reserved_size =10-15%# and try to bounce the db on occasion. Add large_pool area for parallel query.# Finally, added _db_handles_cached=0 to keep from hitting one memory leaking bug.# Remove this parm after patched to 8.1.7.4_db_handles_cached=0shared_pool_size = 400M shared_pool_reserved_size = 60M # 10-15%ofshared_pool_size = 60M large_pool_size = 20M # start at 20, maybe go to 40 if ok I will probably cut back on the shared pool until I can get this patched to 8174 (and monitor paging space to bounce the dbswhen needed). HTH, Scott [EMAIL PROTECTED] 10/4/02 10:38:31 AM HI all We had those messages yesterday in the listener.logfile TNS-12500: TNS:listener failed to start a dedicatedserver processTNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceededAlso on the unix side, we had a message about the OSthat can not fork a new process.This is on 8172 32bits/AIX 4.3.3 The sga is 1.7G, the server has 8G of ram.There is between 150 and 300 users connected.The init.ora process parameter is set to 425. The unixnumber of process allowed is set to 500.I've check on metalink, but found nothing that we donot already do.Any ideas ?Thanks=Stéphane PaquetteDBA Oracle, consultant entrepôt de donnéesOracle DBA, datawarehouse consultant[EMAIL PROTECTED]
Difference between connect internal and connect / as sysdba in sqlplus
What is difference between connect internal and connect / as sysdba in sqlplus ? Michael Ivanov åy«±ç ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+2)!j)H½©è¼DNh¯jz/µ×«j» jТ·#^· +'«¾'³Î|ç9Óa¶Úÿ +0}«\Ü¢d8'è®x1¨¥x%ËZÜn,¶)à±êïǬND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×·'(z-xEÀ + ;)zYb .+-êîjwbØ^ë,j86Énuæ¥w¢{Zx§CRP Ä.í éÚꨥx%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*')²æìr¸x
RE: SqlServer - Oracle transfer issues
What's returned in SQL*Plus when you DESC TableA@hsodbc? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Luc Demanche [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: SqlServer - Oracle transfer issues Hi gurus, I need to transfer a few tables from SqlServer to Oracle. I've installed Heteroegous Service between the SqlServer and our Oracle database according to the Metalink doc no : 109730.1 I began the transfer between those two databases with this kind of statement : create table TableA as select * from TableA@hsodbc; But now I have a problem with the tables on the SqlServer side that contain columns of the Text datatype. Oracle wants to handle it as a LONG datatype. I received this kind of errors : ORA-00997 : illegal use of LONG database What should I do ? TIA Luc -- 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).
A really stupid question
How can I access the Oracle-L archives? There's something I remember reading a few months ago that I want to look up. Embarassedly yours, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: anydata datatype update help
I don't know squat about the ANYDATA type but I wonder if there is a restriction that you can only update an ANYDATA column with a new value of the same type. For example, if you initially put a '101' VARCHAR2 into the ANYDATA column and then attempted to update it to 102, where 102 is a NUMBER datatype it might fail whereas if you tried to update it to '102', where 102 is a VARCHAR2 then it might work. Could this be causing your dilemma? I notice there is a GETTYPENAME member function that will return the type name of AnyData: MEMBER FUNCTION GetTypeName( self IN AnyData) RETURN VARCHAR2; The function will return NUMBER, etc. (the type stored in the ANYDATA record) This would let you know what type is stored in the ANYDATA column for a particular row and you could Make sure your updating with the same type. Maybe do an explicit type conversion of the new value before using it with UPDATE. Just a shot in the dark. HTH Ed -Original Message- Sent: Friday, October 04, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH - Original Message - From: Rachel Carmichael [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 04 Oct 2002 05:33:23 the subject line pretty much describes it. 9.2.0.1, Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, coredump) when we try to update the ANYDATA column. Within a PL/SQL process, using aliased tablenames and bind variables for all values: UPDATE MI.T_IN03_ObjPrpty SET IN03_Value_AD = :b7 ,IN03_Seq_NO = :b6 ,RF01_Publisher_KY = :b5 ,IN03_Amend_DT = :b4 ,RF02_Status_KY = :b3 ,IN03_Status_DT = :b2 WHEREIN03_ObjPrpty_KY = :b1 IN03_Value_AD is the ANYDATA column. Statement works fine if we remove that column. Statement blows up if we remove all OTHER columns or if we run it as is. We've posted an iTAR and are waiting. I've searched MetaLink and the docs. Nothing useful. But the search of the docs left me with a suspicion that you can't update an ANYDATA column. Has anyone either successfully updated an ANYDATA column or found documentation somewhere that says you can't? this is stopping development on a critical system. I'm not the primary DBA on it, but the consultant DBA doesn't have access to MetaLink and isn't on this list so I'm helping out. Suggestions? Worst case I suppose we could delete the original row and insert the new one but that's kludgy and messy and an additional performance hit on a system that needs to fly like the wind. I'd rather fix this properly... of course Oracle is capable of saying that the delete and insert IS the workaround and/or standard procedure for this. Rachel Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: SqlServer - Oracle transfer issues
Possibilities: Prebuild the table with the datatype you want. i.e. varchar2, provided the text column from SQL server is = 4000 bytes. ( notice I said 'bytes', not 'characters' . No, it wasn't because most of this mail list is made up of characters. ) Prebuild the table with a LONG datatype, and use PL/SQL to do the selects and inserts. I can't recall at the moment which function to use to read chunks of LONGs. Maybe someone else can recall. I always manipulate LONGs from Perl, much easier. Jared Luc Demanche [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SqlServer - Oracle transfer issues Hi gurus, I need to transfer a few tables from SqlServer to Oracle. I've installed Heteroegous Service between the SqlServer and our Oracle database according to the Metalink doc no : 109730.1 I began the transfer between those two databases with this kind of statement : create table TableA as select * from TableA@hsodbc; But now I have a problem with the tables on the SqlServer side that contain columns of the Text datatype. Oracle wants to handle it as a LONG datatype. I received this kind of errors : ORA-00997 : illegal use of LONG database What should I do ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: anydata datatype update help
Rachel, The following worked for me: create or replace type person as object ( last_name varchar2(20) ,first_name varchar2(20) ); / create table rc ( id number , person_data sys.anydata ) / insert into rc ( id, person_data ) values (1, sys.anydata.ConvertObject(Person('Still','Jared'))) / commit; update rc set person_data = sys.anydata.ConvertObject(Person('Still','Carla')) where id = 1 / commit; There are examples in the Application Developers Guide. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 06:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:anydata datatype update help the subject line pretty much describes it. 9.2.0.1, Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, coredump) when we try to update the ANYDATA column. Within a PL/SQL process, using aliased tablenames and bind variables for all values: UPDATE MI.T_IN03_ObjPrpty SET IN03_Value_AD = :b7 ,IN03_Seq_NO = :b6 ,RF01_Publisher_KY = :b5 ,IN03_Amend_DT = :b4 ,RF02_Status_KY = :b3 ,IN03_Status_DT = :b2 WHEREIN03_ObjPrpty_KY = :b1 IN03_Value_AD is the ANYDATA column. Statement works fine if we remove that column. Statement blows up if we remove all OTHER columns or if we run it as is. We've posted an iTAR and are waiting. I've searched MetaLink and the docs. Nothing useful. But the search of the docs left me with a suspicion that you can't update an ANYDATA column. Has anyone either successfully updated an ANYDATA column or found documentation somewhere that says you can't? this is stopping development on a critical system. I'm not the primary DBA on it, but the consultant DBA doesn't have access to MetaLink and isn't on this list so I'm helping out. Suggestions? Worst case I suppose we could delete the original row and insert the new one but that's kludgy and messy and an additional performance hit on a system that needs to fly like the wind. I'd rather fix this properly... of course Oracle is capable of saying that the delete and insert IS the workaround and/or standard procedure for this. Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups
4) Old habits are hard to break :). Ah, there we have it. ;) Jared Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Backups lol, OK my reasons for occasional cold backups. As a prior sysadmin, I prefer single user mode full filesystem backups (i.e. databases shut down) prior to any upgrade whether its an application, database, or operating system. There are benefits of cold over hot backups (of course this assumes you have the luxury to take a database offline): 1) Archive logs not needed. 2) No need to be concerned which databases are in archivelog mode. 3) Easier to backup and restore, even the sysadmin can do it :), i.e. no DBA required, no database recovery. OS utilities can be used for backup/restore. 4) Old habits are hard to break :). Gene [EMAIL PROTECTED] 10/04/02 01:38AM OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn
RE: anydata datatype update help
Stephane, if there is a new function, then it is hidden so deeply in the docs that even I can't find it. And I'm pretty good and coming up with creative search patterns. ANYDATA is an object, a way of storing different types of data in a single column. You store the data type metadata with the column. More information on this... when the other DBA ran the PL/SQL routine in a different account which had resource instead of just connect privileges, it ran interesting! Rachel --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: A really stupid question
This was sent by someone recently: - ListGuru GENERAL Command HELP - This help file contains basic information about each command recognized by ListGuru. More detailed help is available through these commands: HELP command -- Gives detailed help about a given command (listed below) HELP DETAILED -- Complete and exhaustive help on ALL commands HELP USAGE -- A general primer on how to use your mailing list HELP FAQ-- A list of Frequently Asked Questions (FAQ) Interacting with ListGuru: -- ListGuru is a Mailing List Manager (MLM) which understands the commonly used commands of many other MLM's, including ListProc, listserv, Majordomo, SmartList, Mailbase and Listcaster, among others. All commands should be sent by E-mail to the following address: [EMAIL PROTECTED] -- Note spelling closely... The Subject: line is ignored, so do not place commands on it. Commands go in the message BODY, one command per line. You can send as many commands in a single message as you wish. Each command has a specific format, as outlined below. In the explanations below, replace any word enclosed by angle brackets, with an appropriate response. For example: INFO list would be replaced with: INFO GARDENING-L Other command replacements: list means the mailing list name (always suffixed with -L) real name means your given name or surname, not E-mail address password means a password given to you for closed lists search textmeans arbitrary text, not case sensitive option means a particular option, dependent on the command filename means a filename (no pathnames are allowed) commandmeans any ListGuru command descriptionmeans arbitrary text, case sensitive If you have any difficulties or questions regarding ListGuru, contact: [EMAIL PROTECTED] The following commands are recognized by ListGuru (in alphabetical order): -- ALLMAIL list Displays a short summary (who, when, what) of all messages received and sent out since the last time a digest was produced (generally midnight of the previous day, but could be longer on low-traffic lists). See Also: CONFIRM, LASTMAIL ARCHIVES Displays a list of all mailing lists which have file archives and which you are currently a subscriber to. See Also: GET, INDEX, SEARCH, SUBMIT, VIEW BIOGRAPHY list INDEX BIOGRAPHY list user BIOGRAPHY list ALL BIOGRAPHY list BIOGRAPHY list DELETE The general intent of the BIO command is to provide a way for list members to create a short biography for themselves, which is then available to all other members of the same list. BIOGRAPHY can be shortened to BIO if you prefer -- both spellings work equally well. *** NOTE *** This command is fairly detailed, so it is recommended that you either issue a HELP DETAILED or a HELP BIO command to get the full set of instructions for using this command. Form #1: BIO list INDEX Returns a complete list of whose bio is available for the given list. As an example, you could do a BIO GARDENING-L INDEX command and ListGuru would send back a list of all BIO's so far submitted for the GARDENING-L list. Form #2: BIO list user Sends back a BIO for a specific user. Usually it is the next command you issue after the INDEX form. You will be sent back the complete biography text as submitted by that specific user. Be sure to use the name listed in the INDEX form to get information on the right person. Form #3: BIO list ALL Similar to form #2, but sends ALL biographies that are available for the list you specify. A quick way to get familiar with everyone, instead of just individual users. Form #4: BIO list This is how you submit your OWN biography. When you use this form of the command, it should be the only command you send in that message, and the message MUST contain a uuencoded file containing your biography. At the current time, MIME attachments are not supported, so the attached file must first be uuencoded, then sent with your message. If you have problems with uuencode, contact [EMAIL PROTECTED] for assistance. Form #5: BIO list DELETE This form deletes any biography entry YOU have submitted for the list specified. Note you cannot delete anyone elses entry; only your own. See Also: INDEX, SUBMIT CONFIRM list Confirms whether you are a subscriber to a particular list or not. See Also: ALLMAIL, LASTMAIL, WHICH DIRECTORY/LIST See the LISTS command below. The DIRECTORY/LIST command can be abbreviated to DIR/LIST if desired. Synonyms: LISTS END Stops further processing by ListGuru. Useful if your messages
Re: Password is not case sensity and uncrypted
the password is not case-sensitive which table shows the password unencrypted? Not DBA_USERS, it's definitely encrypted in there, unless you created the account with quotes around the password, then it shows in plain text and the user won't be able to login in in any case. --- Nguyen, David M [EMAIL PROTECTED] wrote: Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password is not case sensity and uncrypted
Title: RE: Password is not case sensity and uncrypted AFAIK password is NOT case sensitive unless of course you enclose in double-quotes. Also dba_users shows encrypted password. What table are we taking here that shows plain text passwords? Is it an application table? 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: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Subject: Password is not case sensity and uncrypted Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.*1
Re: Difference between connect internal and connect / as sysdba in sqlplus
'connect internal' is no longer supported in 9i+ 'connect / as sysdba' is the replacement. --- Mikhail Ivanov [EMAIL PROTECTED] wrote: What is difference between connect internal and connect / as sysdba in sqlplus ? __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: anydata datatype update help
and in a different environment, it worked for us as well. We've narrowed it down to being due to some environment variable. We thought it might be the privs (the account that worked was created with resource, the one that died had connect only) but that's not it. I'm just glad I don't have to do the digging. All *I* have to do today is generate the scripts to create the new tablespaces, users, tables, indexes, constraints, grants, views, synonyms, stored procedures, fill out the documentation for the hosting company (for the first time ever, so this isn't a braindead operation, I have to figure out what they want and what they need), determine if what they are monitoring for in the database is what I want them to monitor, write the data load procedures and test them in other words, a typical afternoon's work and I should be able to get it done with one hand tied behind my back (makes typing interesting as I am a touch typist) :) At least it's Friday Rachel --- [EMAIL PROTECTED] wrote: Rachel, The following worked for me: create or replace type person as object ( last_name varchar2(20) ,first_name varchar2(20) ); / create table rc ( id number , person_data sys.anydata ) / insert into rc ( id, person_data ) values (1, sys.anydata.ConvertObject(Person('Still','Jared'))) / commit; update rc set person_data = sys.anydata.ConvertObject(Person('Still','Carla')) where id = 1 / commit; There are examples in the Application Developers Guide. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 06:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:anydata datatype update help the subject line pretty much describes it. 9.2.0.1, Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, coredump) when we try to update the ANYDATA column. Within a PL/SQL process, using aliased tablenames and bind variables for all values: UPDATE MI.T_IN03_ObjPrpty SET IN03_Value_AD = :b7 ,IN03_Seq_NO = :b6 ,RF01_Publisher_KY = :b5 ,IN03_Amend_DT = :b4 ,RF02_Status_KY = :b3 ,IN03_Status_DT = :b2 WHEREIN03_ObjPrpty_KY = :b1 IN03_Value_AD is the ANYDATA column. Statement works fine if we remove that column. Statement blows up if we remove all OTHER columns or if we run it as is. We've posted an iTAR and are waiting. I've searched MetaLink and the docs. Nothing useful. But the search of the docs left me with a suspicion that you can't update an ANYDATA column. Has anyone either successfully updated an ANYDATA column or found documentation somewhere that says you can't? this is stopping development on a critical system. I'm not the primary DBA on it, but the consultant DBA doesn't have access to MetaLink and isn't on this list so I'm helping out. Suggestions? Worst case I suppose we could delete the original row and insert the new one but that's kludgy and messy and an additional performance hit on a system that needs to fly like the wind. I'd rather fix this properly... of course Oracle is capable of saying that the delete and insert IS the workaround and/or standard procedure for this. Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Password is not case sensity and uncrypted
There are certain rules Oracle uses for its names, one of which is that names are case insensitive. Password falls under these rules. That said, you can override these rules by enclosing the password in quotation marks (just as you could do the same for a table). So SQL alter user myuser identified by CaseSenSitIve will store the password in a case-sensitive manner. But then you must use quotation marks when connecting as well, e.g., $ sqlplus myuser/CaseSenSitIve And I'm not sure this will work across platforms. A Metalink note (61424.999) on this topic indicates that UNIX seems to support case-sensitive passwords, while Windows does not. About encryption, typically Oracle stores passwords in an encrypted format by default. Adam -Original Message- Sent: Friday, October 04, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Goddess Abuse Time
Us are very pleased about that. :) Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, October 04, 2002 9:18 AM To: Multiple recipients of list ORACLE-L and no one but me (and my co-authors of course) write our books -- 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: Help on creating this report (any method)
Remember having done something similar some time ago...Check this out and see if this satisfies your requirement Query :=select type, category, sum(col1) col1, sum(col2) col2, sum(col3) col3, sum(col4) col4from(select type, category, count(*) col1, 0 col2, 0 col3, 0 col4 from agroup by type, categoryunionselect type, category, 0 col1, count(*) col2, 0 col3, 0 col4 from agroup by type, categoryunionselect type, category, 0 col1, 0 col2, count(*) col3, 0 col4 from agroup by type, categoryunionselect type, category, 0 col1, 0 col2, 0 col3, count(*) col4 from agroup by type, category)group by type, category/ Test Table aName Null? Type--- TYPE VARCHAR2(10)CATEGORY VARCHAR2(10) SQL select * from a; TYPE CATEGORY -- -- A A A B A C B A B B B C C A C B! ! sp; C C A A A B A C 12 rows selected. Query result= TYPE CATEGORY COL1 COL2 COL3 COL4-- -- -- -- -- --A A 2 2 2 2A B 2 2 2 2A! ! ; C 2 2 2 2B A 1 1 1 1B B 1 1 1! ! p; 1B C 1 1 1 1C A 1 1 1 1C B 1 1 1! ! bsp; 1C C 1 1 1 1 9 rows selected. Erma Fernando <[EMAIL PROTECTED]>wrote: I have to create a tabular quarterly summary report, based on 4 different queries, but all are grouped by the same columns. Any suggestions on how to accomplish this - sql report etc. Thanks a lot. Type category Col1 Col2 Col3 Col4 Elec Fac 500 100 200 400 ElecRates300 200 50 450 Elec Fran 200 100 50 250 Gas Fac 700 300 200 800 Gas Rates 900 100 600 400 Gas Fran 400 100 300 100 Col1 is count of open cases at start of quarter grouped by type and category Col2 is count of new cases opened during quarter grouped by type and category Col3 is count of cases closed in the quarter grouped by type and category Col4 is count of open cases at end of quarter grouped by type and category Col1 query is: select type, category, count(*) form case where status='Open' and date_filed'01-Jul-02' group by type, category; Col2 query is: select type, category, count(*) from case where date_filed='01-Jul-02' group by type, category; Col3 query is select type, category, count(*) form case where status='Closed' and date_closed='01-Jul-02' and date_closed='03-Sep-02' group by type, category; Col4 query is select type, category, count(*) form case where status='Open' group by type, category; Chat with friends online, try MSN Messenger: Click Here-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erma Fernando INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Do you Yahoo!? New DSL Internet Access from SBC & Yahoo!
BACKUP database question
List, With all of the recent discussion and the forth coming books and the upgrade here to 8i I have a question. Where do you build your RMAN repository database? If you build it in the same server as the one you are backing up then you risk the loss of everything in the event of a disk farm failure. If you created a separate server to hold the RMAN repository does it require a separate license for the oracle running on the server? We have a clustered environment with a disk farm and 2 Alpha boxes. One box will be Production and the other will be Development and they share the disk farm. If I use RMAN to backup the production box and keep it in the development database I still have all of my eggs in one disk farm. If I create a separate server on a Linux pc I need a license for the Oracle database on the pc. What methods have you used at your work location and I do not care about your licensing agreements. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A really stupid question
Also, I think an actual searchable list is on the orafaq site whickh is in the footer of each message For example http://www.orafaq.com/supsearc.htm I searched Goddess And came back with a ton of hits, so, I figgure it must be hitting archives from the fatcity list ;-) Try it Bob This was sent by someone recently: - ListGuru GENERAL Command HELP - This help file contains basic information about each command recognized by ListGuru. More detailed help is available through these commands: HELP command -- Gives detailed help about a given command (listed below) HELP DETAILED -- Complete and exhaustive help on ALL commands HELP USAGE -- A general primer on how to use your mailing list HELP FAQ-- A list of Frequently Asked Questions (FAQ) Interacting with ListGuru: -- ListGuru is a Mailing List Manager (MLM) which understands the commonly used commands of many other MLM's, including ListProc, listserv, Majordomo, SmartList, Mailbase and Listcaster, among others. All commands should be sent by E-mail to the following address: [EMAIL PROTECTED] -- Note spelling closely... The Subject: line is ignored, so do not place commands on it. Commands go in the message BODY, one command per line. You can send as many commands in a single message as you wish. Each command has a specific format, as outlined below. In the explanations below, replace any word enclosed by angle brackets, with an appropriate response. For example: INFO list would be replaced with: INFO GARDENING-L Other command replacements: list means the mailing list name (always suffixed with -L) real name means your given name or surname, not E-mail address password means a password given to you for closed lists search textmeans arbitrary text, not case sensitive option means a particular option, dependent on the command filename means a filename (no pathnames are allowed) commandmeans any ListGuru command descriptionmeans arbitrary text, case sensitive If you have any difficulties or questions regarding ListGuru, contact: [EMAIL PROTECTED] The following commands are recognized by ListGuru (in alphabetical order): -- ALLMAIL list Displays a short summary (who, when, what) of all messages received and sent out since the last time a digest was produced (generally midnight of the previous day, but could be longer on low-traffic lists). See Also: CONFIRM, LASTMAIL ARCHIVES Displays a list of all mailing lists which have file archives and which you are currently a subscriber to. See Also: GET, INDEX, SEARCH, SUBMIT, VIEW BIOGRAPHY list INDEX BIOGRAPHY list user BIOGRAPHY list ALL BIOGRAPHY list BIOGRAPHY list DELETE The general intent of the BIO command is to provide a way for list members to create a short biography for themselves, which is then available to all other members of the same list. BIOGRAPHY can be shortened to BIO if you prefer -- both spellings work equally well. *** NOTE *** This command is fairly detailed, so it is recommended that you either issue a HELP DETAILED or a HELP BIO command to get the full set of instructions for using this command. Form #1: BIO list INDEX Returns a complete list of whose bio is available for the given list. As an example, you could do a BIO GARDENING-L INDEX command and ListGuru would send back a list of all BIO's so far submitted for the GARDENING-L list. Form #2: BIO list user Sends back a BIO for a specific user. Usually it is the next command you issue after the INDEX form. You will be sent back the complete biography text as submitted by that specific user. Be sure to use the name listed in the INDEX form to get information on the right person. Form #3: BIO list ALL Similar to form #2, but sends ALL biographies that are available for the list you specify. A quick way to get familiar with everyone, instead of just individual users. Form #4: BIO list This is how you submit your OWN biography. When you use this form of the command, it should be the only command you send in that message, and the message MUST contain a uuencoded file containing your biography. At the current time, MIME attachments are not supported, so the attached file must first be uuencoded, then sent with your message. If you have problems with uuencode, contact [EMAIL PROTECTED] for assistance. Form #5: BIO list DELETE This form deletes any
http://orafaq.com/archive/oracle-l
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Password is not case sensity and uncrypted
Raj, I recently attended a conference where a very security obsessed individual was giving a presentation. He recommended in very strong terms taking all application usernames, where the tables etc... are housed, and doing an alter user username identified by values 'NOBODY';. Now this does place the value 'NOBODY' into the password field in DBA_USERS and afterwards nobody can loggin to that account. The fix is easy, just alter user username identified by nobody'; Dick Goulet Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 10/4/2002 10:03 AM AFAIK password is NOT case sensitive unless of course you enclose in double-quotes. Also dba_users shows encrypted password. What table are we taking here that shows plain text passwords? Is it an application table? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, October 04, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.19 TITLERE: Password is not case sensity and uncrypted/TITLE /HEAD BODY PFONT SIZE=2AFAIK password is NOT case sensitive unless of course you enclose in double-quotes. Also dba_users shows encrypted password. What table are we taking here that shows plain text passwords? Is it an application table?/FONT/P PFONT SIZE=2Raj/FONT BRFONT SIZE=2__/FONT BRFONT SIZE=2Rajendra Jamadagninbsp;nbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; MIS, ESPN Inc./FONT BRFONT SIZE=2Rajendra dot Jamadagni at ESPN dot com/FONT BRFONT SIZE=2Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. /FONT BRFONT SIZE=2QOTD: Any clod can have facts, but having an opinion is an art!/FONT /P BR PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: Nguyen, David M [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Friday, October 04, 2002 1:48 PM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: Password is not case sensity and uncrypted/FONT /P BR PFONT SIZE=2Is password case-sensity in oracle database?nbsp; And how do I encrypt it as it/FONT BRFONT SIZE=2shows unencrypted in password field?/FONT /P PFONT SIZE=2Thanks,/FONT BRFONT SIZE=2David/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: Nguyen, David M/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- 858-538-5051 A HREF=http://www.fatcity.com; TARGET=_blankhttp://www.fatcity.com/A/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Mailing list and web hosting services/FONT BRFONT SIZE=2-/FO NT BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML *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
Re: How to get rid of a column default value ?
Thanks Dale, Michael and Ron. The default null is what I thought about first and it almost does the job. It's just that it appears like there is a default value which is null. If I don't include the DEFAULT clause, it does nothing. I think I'll have to live with the default null. At 08:29 2002-10-04 -0800, you wrote: Louis, I believe it is the ALTER TABLE command. ALTER TABLE name MODIFY ( column datatype); match the column name and the datatype but do not include the DEFAULT clause . Ron ROR mª¿ªm [EMAIL PROTECTED] 10/04/02 11:28AM Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: anydata datatype update help
Rachel, do you know which system privilege of resource did the trick? inka -Original Message- Sent: Friday, October 04, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Stephane, if there is a new function, then it is hidden so deeply in the docs that even I can't find it. And I'm pretty good and coming up with creative search patterns. ANYDATA is an object, a way of storing different types of data in a single column. You store the data type metadata with the column. More information on this... when the other DBA ran the PL/SQL routine in a different account which had resource instead of just connect privileges, it ran interesting! Rachel --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman fun :), nightmare and long
On all of my 8.1.7 and below DB's I do a controlfile backup after the level backup and archivelog all delete input is finished. I had problems cloning a database because RMAN back's up the controlfile first and then does the level backup etc. ...JIM... [EMAIL PROTECTED] 10/4/02 8:53:27 AM The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING controlfile. My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible). I am asured that if we had no controlfile available we could restore controlfile and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile) So Joe, you only needed a copy of the control file because of the scenario you were running and you would not need to take a specific copy in the normal run of events? Is my understanding correct?. I know that no recovery/DR scenario can be considered normal but I am particularly interested if any situation where we need to recover from the last backup either a full database to a SCN or point in time or recover a single datafile Thanks John -Original Message- Sent: 04 October 2002 12:58 To: Multiple recipients of list ORACLE-L Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). -- 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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database is 32 or 64 Bit ? - Clarification
Query the v$sql table. If the 'address' field contains 8 hex characters, it's 32 bit. If there are 16 characters, it's 64 bit. select address from v$sql where rownum 2; Robyn Inka Bezdziecka wrote: you need to 'describe' v$session, not to 'select' from it SQL desc v$session -Original Message- Sent: Friday, October 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi Qs What do you mean by raw(4) / raw(8) ? Does it mean Length of the Field Data Value ? From my Database :- SQL select saddr from v$session where rownum 2 2 / SADDR 313941C0 CASE - Assuming on receiving a Database from a 3rd party 1) My Existing Installed ORACLE_HOME software is 64 - Bit 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of ) Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still show raw(4) values ? Thanks -Original Message- Sent: Friday, October 04, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment if 64 bit Sun isalist -v If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version To check Oracle version - 2 methods do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) -Original Message- Sent: 04 October 2002 07:53 To: Multiple recipients of list ORACLE-L Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- Robyn Anderson Sands iTeam Technologies, Inc. Office: 404.816.6920 Mobile: 404.234.4873 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on creating this report (any method)
Thank you very much Sunny. It works. MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erma Fernando INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: anydata datatype update help
Inka, I'm not even sure that that is the reason it works in the other account.. he's still digging into why and what. As soon as I have a real answer, I'll post it to the list Rachel --- Inka Bezdziecka [EMAIL PROTECTED] wrote: Rachel, do you know which system privilege of resource did the trick? inka -Original Message- Sent: Friday, October 04, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Stephane, if there is a new function, then it is hidden so deeply in the docs that even I can't find it. And I'm pretty good and coming up with creative search patterns. ANYDATA is an object, a way of storing different types of data in a single column. You store the data type metadata with the column. More information on this... when the other DBA ran the PL/SQL routine in a different account which had resource instead of just connect privileges, it ran interesting! Rachel --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BACKUP database question
I have a small database on a separate disk which holds my recovery catalog. I would like to have it on a separate server but that won't happen. I have used the same recovery catalog for 4 years and it is onlyu ~88MB. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:31 PM List, With all of the recent discussion and the forth coming books and the upgrade here to 8i I have a question. Where do you build your RMAN repository database? If you build it in the same server as the one you are backing up then you risk the loss of everything in the event of a disk farm failure. If you created a separate server to hold the RMAN repository does it require a separate license for the oracle running on the server? We have a clustered environment with a disk farm and 2 Alpha boxes. One box will be Production and the other will be Development and they share the disk farm. If I use RMAN to backup the production box and keep it in the development database I still have all of my eggs in one disk farm. If I create a separate server on a Linux pc I need a license for the Oracle database on the pc. What methods have you used at your work location and I do not care about your licensing agreements. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman fun :), nightmare and long
And wouldn't that be the place you wanted to start if you were doing a PITR? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 3:21 PM On all of my 8.1.7 and below DB's I do a controlfile backup after the level backup and archivelog all delete input is finished. I had problems cloning a database because RMAN back's up the controlfile first and then does the level backup etc. ...JIM... [EMAIL PROTECTED] 10/4/02 8:53:27 AM The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING controlfile. My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible). I am asured that if we had no controlfile available we could restore controlfile and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile) So Joe, you only needed a copy of the control file because of the scenario you were running and you would not need to take a specific copy in the normal run of events? Is my understanding correct?. I know that no recovery/DR scenario can be considered normal but I am particularly interested if any situation where we need to recover from the last backup either a full database to a SCN or point in time or recover a single datafile Thanks John -Original Message- Sent: 04 October 2002 12:58 To: Multiple recipients of list ORACLE-L Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). -- 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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-904 invalid column name
Hi All, Oracle 8.1.6, WinNT I have view TIMEVIEW. I can do select * from timeview with no errors. If I select a individual column I get 904 error. I am doing everything from the schema owner. Any hints SQLWKS desc timeview Column NameNull?Type -- NAS_IP_ADDRESS NOT NULL VARCHAR2(255) CALLED_STATION_ID VARCHAR2(255) CALLING_STATION_ID VARCHAR2(255) ACCT_INPUT_OCTETS NUMBER(38) ACCT_OUTPUT_OCTETS NUMBER(38) USER_NAME VARCHAR2(255) ST NUMBER MT VARCHAR2(3) SQLWKS select mt from timeview; select mt from timeview * ORA-00904: invalid column name Thanks Rick -- 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: ora-904 invalid column name
Title: RE: ora-904 invalid column name Taking a Deep Breath ... Are any columns in this view user defined functions ?? 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 4:06 PM To: Multiple recipients of list ORACLE-L Subject: ora-904 invalid column name Hi All, Oracle 8.1.6, WinNT I have view TIMEVIEW. I can do select * from timeview with no errors. If I select a individual column I get 904 error. I am doing everything from the schema owner. Any hints SQLWKS desc timeview Column Name Null? Type -- NAS_IP_ADDRESS NOT NULL VARCHAR2(255) CALLED_STATION_ID VARCHAR2(255) CALLING_STATION_ID VARCHAR2(255) ACCT_INPUT_OCTETS NUMBER(38) ACCT_OUTPUT_OCTETS NUMBER(38) USER_NAME VARCHAR2(255) ST NUMBER MT VARCHAR2(3) SQLWKS select mt from timeview; select mt from timeview * ORA-00904: invalid column name Thanks Rick -- 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). *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.*1
RE: ora-904 invalid column name
Rick, What is the underlying view statement? I have found that there is an object resolution difference between selecting individual columns and *. I'm exploring exactly what happens, but the same issue can be found in v$sort_usage, where there is a column USER (which is both a reserved word and a function). Dan Fink -Original Message- Sent: Friday, October 04, 2002 2:06 PM To: Multiple recipients of list ORACLE-L Hi All, Oracle 8.1.6, WinNT I have view TIMEVIEW. I can do select * from timeview with no errors. If I select a individual column I get 904 error. I am doing everything from the schema owner. Any hints SQLWKS desc timeview Column NameNull?Type -- NAS_IP_ADDRESS NOT NULL VARCHAR2(255) CALLED_STATION_ID VARCHAR2(255) CALLING_STATION_ID VARCHAR2(255) ACCT_INPUT_OCTETS NUMBER(38) ACCT_OUTPUT_OCTETS NUMBER(38) USER_NAME VARCHAR2(255) ST NUMBER MT VARCHAR2(3) SQLWKS select mt from timeview; select mt from timeview * ORA-00904: invalid column name Thanks Rick -- 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: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-904 invalid column name
Title: RE: ora-904 invalid column name try with quotes -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 04, 2002 4:06 PM To: Multiple recipients of list ORACLE-L Subject: ora-904 invalid column name Hi All, Oracle 8.1.6, WinNT I have view TIMEVIEW. I can do select * from timeview with no errors. If I select a individual column I get 904 error. I am doing everything from the schema owner. Any hints SQLWKS desc timeview Column Name Null? Type -- NAS_IP_ADDRESS NOT NULL VARCHAR2(255) CALLED_STATION_ID VARCHAR2(255) CALLING_STATION_ID VARCHAR2(255) ACCT_INPUT_OCTETS NUMBER(38) ACCT_OUTPUT_OCTETS NUMBER(38) USER_NAME VARCHAR2(255) ST NUMBER MT VARCHAR2(3) SQLWKS select mt from timeview; select mt from timeview * ORA-00904: invalid column name Thanks Rick -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 to get rid of a column default value ?
Louis, I still have not convinced myself that we have the proper answer. If you query the DBA_TAB_COLUMNS table DATA_DEFAULT column you will see that the original NON default created column has a null or blank as the value for the data_default column. If the default is set to NULL then the word NULL appears as the data_default value for the column. What if the column was a char(4) column then it would default to the valueNULL which is not the same as blank or nothing. Still digging for an answer. Ron ROR mô¿ôm [EMAIL PROTECTED] 10/04/02 03:21PM Thanks Dale, Michael and Ron. The default null is what I thought about first and it almost does the job. It's just that it appears like there is a default value which is null. If I don't include the DEFAULT clause, it does nothing. I think I'll have to live with the default null. At 08:29 2002-10-04 -0800, you wrote: Louis, I believe it is the ALTER TABLE command. ALTER TABLE name MODIFY ( column datatype); match the column name and the datatype but do not include the DEFAULT clause . Ron ROR mª¿ªm [EMAIL PROTECTED] 10/04/02 11:28AM Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
help!! smon
Hi gurus ,,, i need check what do you doing the smon proc!!! this process have 99% of CPU somebody help me!!! @lex Lic. Alexander Ordóñez Arroyo Soporte Tru64Unix BD Oracle Caja Costarricense del Seguro Social Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] Celular 397-0532 The truth is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BACKUP database question
Thanks, Tom and Ruth and others yet to reply, We to are a quasi-state agency but the Oracle licensing is under a state controlled agency and must be purchased from them. If I use my Linux/8i test platform for company business then I must purchase a license. Although a 10 named license is not that expensive, I still have to get it past the Sr.VP (also SR.VP of finance - a CPA) Like a snowball in hel*. There is some risk envolved with the disk farm concept for both boxes but I think that is the way I will have to go. I will create a rman test repository on my Linux box and get the bugs worked out before I deploy to the production environment. Of course I could use the non repository method with the controlfile entries and not have to worry about a database. Thanks, I'm still investigating. Ron [EMAIL PROTECTED] 10/04/02 03:58PM I have a small database on a separate disk which holds my recovery catalog. I would like to have it on a separate server but that won't happen. I have used the same recovery catalog for 4 years and it is onlyu ~88MB. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:31 PM List, With all of the recent discussion and the forth coming books and the upgrade here to 8i I have a question. Where do you build your RMAN repository database? If you build it in the same server as the one you are backing up then you risk the loss of everything in the event of a disk farm failure. If you created a separate server to hold the RMAN repository does it require a separate license for the oracle running on the server? We have a clustered environment with a disk farm and 2 Alpha boxes. One box will be Production and the other will be Development and they share the disk farm. If I use RMAN to backup the production box and keep it in the development database I still have all of my eggs in one disk farm. If I create a separate server on a Linux pc I need a license for the Oracle database on the pc. What methods have you used at your work location and I do not care about your licensing agreements. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-904 invalid column name
Title: RE: ora-904 invalid column name Rick, I ask because in 8161 there is an internal bug that sometimes communicates (with users) by displaying ora-904 error. This happens when you have a user defined function and you are selecting from that user defined function AND you have privileges to execute the function through a role. The workaround is to grant execute directly to user and not through role. That's why I asked the question. Your case seems to be little different. 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.*1
Re: Backups
gentle correction: oracle6 had hot backup capability... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 04, 2002 9:48 AM Oracle 6 and prior releases required cold backups. Hot backups became available in version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's new book :). Gene [EMAIL PROTECTED] 10/04/02 10:03AM One of the local dbas said to me recently that Oracle docs indicate that cold backups are required. I did a search and could not find what he was talking about. Anyone got such a reference? On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote: OK, Gene, you asked for it. :) The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one. I hate to resurrect an old flame war, but... No, I take it back. I don't hate it a bit. ;) There aren't many occasions that call for a cold backup. I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver. Jared On Thursday 03 October 2002 14:54, Gene Sais wrote: wow, never a cold backup for any os,oracle, application upgrades? i prefer to shutdown everything, backup the filesystems, let the vendor have his way. if he screws up, its much easier to restore a complete filesystem than a corrupted database. cold backups are a good thing. i sleep good at nite :) soon, rman will be another backup method in my toolbox. but when that happens, i can see hot backups going away but cold backups will still be needed on occassion. [EMAIL PROTECTED] 10/03/02 04:33PM I don't do them either, 4.5 years here. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 4:17 PM I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I still prefer cold backups when performing full OS backups. [EMAIL PROTECTED] 10/03/02 02:28PM Lest we not forget the archivelogs also during this backup procedure. Ron [EMAIL PROTECTED] 10/03/02 01:53PM I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman to do online backups. No problem with recovery! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:18 PM This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR m???m [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services