SAP Tablespace Conventions (WAS: Convert to LMTs)
to reside in original tablespaces, otherwise I could have skipped this step) 6) drop and recreate index tablespaces 7) get index definitions out of exportfile and modify them to add parallel nologging (with big sort area size) 8) rebuild indexes 9) do a full backup It might help to recreate index tablespaces even before step 3, to speed up parallel table moving a bit.. Maybe you want to test this Jared, this approach is much faster than export/import, because everything can be done with direct path operations and nologging (import doesn't have direct path facility, so regular array inserts are used, which always require logging as well). Also, your tables/datablocks will be optimized after moving them (which is not the case with dbms_space_admin) and you don't have to have any space for reorg in case your cleared index tablespace can temporarily accommodate your data. IIRC one of the drawbacks of using dbms_space_admin to convert is that you won't be converting to nice uniform extent sizes for existing data. Yes, and if your tablespace is fragmented, the fragmentation will remain there, despite your conversions (of course, smaller extents might be able to use some of this fragmented space later on). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
FW: SAP Tablespace Conventions (WAS: Convert to LMTs)
Jared, SAP does use default tablespace names as you have stated, but will allow you to move them to alternate locations and recommends it under certain conditions. We separated 10 or 12 of the tables that we thought would grow the fastest into dedicated tablespaces when we originally installed R/3 40B several years ago and have added to that number over time. SAPDBA has options to perform a move between tablespaces via EXP/IMP or CTAS. As far as the impact on upgrades goes, we are migrating to SAP Enterprise 4.7 and I have found minimal impact from the nondefault layout. Only 1 or 2 tables reverted to their default tablespaces and no errors for tables that were elsewhere. (Nitty-gritty details if you want to read on) Now creating new tablespaces via SAPDBA (with the PSAP prefix) is recommended as it modifies the SAP internal data dictionary to include them. Also, the default tablespace can be changed by adding user- defined data classes associated with the new tablespaces, then assigning them to the table/s in question via SE11 and the Repair/ CorrectionTransport mechanism. We created our own data classes but never assigned them, leaving the original data classes in place. Figured it would be less of a problem than keeping track of 100 or so Repair/Transports. The discrepancy is only evident in the SE14 transaction under Storage parameters between the actual values in the database (DBS) and expected/calculated values (CMP). Hope this isn't more than you wanted or needed ;) Mike Hand Polaroid Corp. -Original Message- Sent: Tuesday, January 06, 2004 9:04 PM To: Multiple recipients of list ORACLE-L SAP expects tables to be in certain tablespaces: PSAPBTABD for instance. Same with indexes: PSAPBTABI The SAPDBA interactive tool is being phased out in favor of the command line tool brconnect. I don't know if brconnect allows some flexibility in tablespace names, but I doubt it. Just haven't got around to that particular topic yet. There are methods for doing fairly fast migrations should you need it, such as changing platforms. I would have preferred to do an exp/imp or something like it when we moved to new servers, but in the amount of time I had to work with, I could not come up with what I thought an acceptable method on windows. On *nix there would have been more leeway. There isn't any native named pipe functionality that is exposed to the shell on Win32. On top of that, Oracle compiles the utilities such as imp/exp with libs that prevent you from using stdin/stdout in the manner you would on unix. I found out too late about netcat: (http://dbasupport.com/oracle/ora9i/resolutions.shtml) So, it was the mig utility for us. Jared -- This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter tablespace offline
Jeroen, The errors look like its from the database open not the mount. As Rachel has already mentioned the file rename has to take place after the mount but before you open the database. Mike -Original Message- Sent: Tuesday, December 16, 2003 8:04 AM To: Multiple recipients of list ORACLE-L did you also rename the datafile within the database? the error message on the line starting with ORA-01110 tells you that the database thinks the file should be at /migratie_deca/DECA/DATA. If that is the original location, that should tell you that as far as Oracle is concerned the datafile is in the original location. You have to tell Oracle where you moved the file, the database is smart but not omniscient. in addition to the alter tablespace offline (and no, I've NEVER had to do this with the normal clause) you need to do an alter database rename file 'old file name including path' to 'new file name including path' before you do the mount --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi Sinardy, Instance was terminated when opening Errors in file /opt/oracle/product/admin/DECA/udump/deca_ora_28080.trc: ORA-00376: file 6 cannot be read at this time ORA-01110: data file 6: '/migratie_deca/DECA/DATA/tools01.dbf' Error 376 happened during db open, shutting down database USER: terminating instance due to error 376 Instance terminated by USER, pid = 28080 ORA-1092 signalled during: ALTER DATABASE OPEN... Regards, Jeroen -Oorspronkelijk bericht- Van: Sinardy Xing [mailto:[EMAIL PROTECTED] Verzonden: Tuesday, December 16, 2003 11:44 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: alter tablespace offline Hi Jeroen, What is problem? Error msg or something? Sinardy -Original Message- Sent: 16 December 2003 18:12 To: Multiple recipients of list ORACLE-L Hi, This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and we encountered a strange problem in issueing alter tablespace name offline. I had to reorganize tablespace and when testing this I did this manually and no problem at all. I put the statements in a script. Executing the script put the tablespace offlline with exactly : alter tablespace name offline Moving the file with os and then starting up the database in mount phase lead to the problem it would not do this. Backtracking this to a test environment and rereading the docs lead me to that I should have used alter tablespace name offline normal I cannot remember whether I did this ok in the first tests but I might have copied it wrong into my script. What is the problem in issueing a alter tablespace name offline so without the normal clause? Details: HP-UX11.11, Oracle 9.2.0.4 Regards, Jeroen __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: making me crazy
Title: RE: making me crazy Paula, Would putting both listeners in one listener.ora file help. You would, of course have to change one or bothto a non-default name. Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: making me crazy Dealing with 2 Oracle Homes - one if which I need to run the listener from and one in which I need to use the tnsnames.ora definitions from and no I can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set the oracle home from which to run lsnrctl it tries to use the listener.ora from the TNS_ADMIN home. How can I make sure to explicitly start the correct listener.ora? Thanks, Paula -- This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
RE: Change based recovery
Lisa, The 3rd option (besides shuting down source database and using a controlfile trace) is to "alter database backup controlfile to 'filename'; ", use this file, then proceed with the recovery as Venu suggests. I've used this method on a hot backup to roll the database forward. Also, don't bother restoring the redo logs as you will be overwriting / recreating them with the "alter database open resetlogs". One more thing I noticed. Your until change number looks to me like an archive sequence number rather than the SCN it needs to be. Hope this helps. Mike Hand -Original Message-From: Dobson, Lisa [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 8:21 AMTo: Multiple recipients of list ORACLE-LSubject: Change based recovery Hi Guys and Gals, We are currently doing some testing to enable us to move our production database from one unix box to another. We are running a 7.3.4 db in archivelog mode. The approach that management want to use is to restore the database on the new server from a backup and then roll it forward using the archived redo logs. I have a full cold back up from last Friday. I have restored the datafiles, controlfiles and redo logs onto our test server from the backup tape, and then ftp'd the archived logs over. I then do - SVRMGR startup mountORACLE instance started.Total System Global Area 258304260 bytesFixed Size 45092 bytesVariable Size 126925024 bytesDatabase Buffers 131072000 bytesRedo Buffers 262144 bytesDatabase mounted.SVRMGR recover database until change 10349;Media recovery complete.
RE: possible to set continuation prompt in sql*plus?
Roy, You got me thinking on a tangent. How can I cut and paste the whole multi-line SQL statement at once and have it useable. Now you can, of course, use sqlplus in silent mode (-s), but that's a little too silent for my tastes. So how 'bout set sqlnumber off sqlprompt ' '. That way you get: select blah, deblah from blahde where blah != deblah and ... Nicely cutable pasteable, just thought I'd share. Mike Hand -Original Message- Sent: Tuesday, July 22, 2003 6:19 PM To: Multiple recipients of list ORACLE-L Apologies--I wasn't clear in my original post. Right now I'm getting: [EMAIL PROTECTED] select username 2 from dba_users 3 where username like '%MC%' ; What I'd *really* like to have is: [EMAIL PROTECTED] select username 2 from dba_users 3 where username like '%MC%' ; That way I could copy/paste sql commands as easily as I could when my prompt was just SQL . Setting sqlnumber off gets me: [EMAIL PROTECTED] select username [EMAIL PROTECTED] from dba_users [EMAIL PROTECTED] where username like '%MC%' ; Which isn't horrible, although I do miss the numbers. But no matter--I'll just live with it... Many thanks! -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Managing Archived Redo Logs
To piggyback on John's reply, one of our 8173 test systems filled the archive destination over the weekend during a application upgrade. Now the Unix directory was fill for less than 90 minutes and the database was hung/halted for less than 45 minutes but 10s of thousands of line of the following were written to the alert log: ARC2: Beginning to archive log# 9 seq# 160 ARC2: Failed to archive log# 9 seq# 160 ARC2: Beginning to archive log# 10 seq# 161 ARC2: Failed to archive log# 10 seq# 161 As the database spawned 9 ARCn processes and continued to attempt to write out filled redo logs. If this goes on too long you are also at risk of filling the 'background_dump_dest' directory as well. Mike Hand -Original Message- Sent: Wednesday, July 23, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Just to add that you _can_ be informed of this if you monitor the alert log. The following errors are logged (from a live system, and way back from 7.3.4!) Thread 1 advanced to log sequence 69529 Current log# 1 seq# 69529 mem# 0: /u090/oradata//REDO0101.DBF Current log# 1 seq# 69529 mem# 1: /u091/oradata//REDO0102.DBF ..skipping... ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' ARCH: ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' Mon May 13 05:36:57 2002 Thread 1 cannot allocate new log, sequence 69618 Checkpoint not complete John Kanagaraj This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Production Database stays up; copies will not recover - Resol
Thanks Tanel, All of the resetlog_change#'s where the same. The problem has been resolved, with 2 likely sources. The disk mirror set on the affected mount points were completely rebuild, and (my mistake) we used a backup controlfile instead of a copy of an active one to recover. I could have sworn I implemented the use of a backup controlfile in this process years ago, but the code doesn't lie. Mike -Original Message- Sent: Tuesday, July 01, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Hi! Oracle can only guarantee database consistency and sanity when it's underlying layers like OS and disk controllers do not fail. Try: Startup mount; select distinct resetlogs_change# from v$datafile_header; Do you see only one distinct change#? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 8:34 PM Tru64 5.1 8.1.7.3 We had a disk controller fail last week, but redundant hardware let the system stay up until it could be replaced over the weekend. The production database restarted without any problems, trace files, or alert log errors. The problem is that the reporting copy of production, taken from a disk mirror break (hot backup, mounted on a seperate system) will not recover. I get an ORA-1190 'controlfile or data file 1 is from before the last RESETLOGS' but the last resetlogs was over a month ago. First attempt to solve was to use a slightly older copy of the SYSTEM datafile from an earlier backup disk mirror break (hot backup). Results were the same. I then assumed something was wrong with the controlfile, so I tried to rebuild that. No luck, the Create controlfile command returned a ORA1189 'file is from a different RESETLOGS than previous files' against file#2 (even though I replaced the file# 1's datafile with the original [neither copy of #1 was opened]). My worries are two-fold; 1) that there is a subtle error in the control file or SYSTEM datafile that only an attempted recovery exposes and 2) any backup taken after the hardware failure last week will not be viable. Any suggestions as how to proceed to either prove or disprove this. Thanks, Mike Hand Polaroid Corp P.S. I had hoped to go on vacation at the end of the week leaving a stable database behind (for a change). This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
Production Database stays up; copies will not recover
Tru64 5.1 8.1.7.3 We had a disk controller fail last week, but redundant hardware let the system stay up until it could be replaced over the weekend. The production database restarted without any problems, trace files, or alert log errors. The problem is that the reporting copy of production, taken from a disk mirror break (hot backup, mounted on a seperate system) will not recover. I get an ORA-1190 'controlfile or data file 1 is from before the last RESETLOGS' but the last resetlogs was over a month ago. First attempt to solve was to use a slightly older copy of the SYSTEM datafile from an earlier backup disk mirror break (hot backup). Results were the same. I then assumed something was wrong with the controlfile, so I tried to rebuild that. No luck, the Create controlfile command returned a ORA1189 'file is from a different RESETLOGS than previous files' against file#2 (even though I replaced the file# 1's datafile with the original [neither copy of #1 was opened]). My worries are two-fold; 1) that there is a subtle error in the control file or SYSTEM datafile that only an attempted recovery exposes and 2) any backup taken after the hardware failure last week will not be viable. Any suggestions as how to proceed to either prove or disprove this. Thanks, Mike Hand Polaroid Corp P.S. I had hoped to go on vacation at the end of the week leaving a stable database behind (for a change). This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Preparing for Performance test
Tru64 5.1A 8.1.7.3 I have a very short window of time tomorrow to try and determine why the runtime of one 2-table join takes ~4 time as long on a (SAN/Snapshot) database copy as the same statement on the source database. All other test selects have similar runtimes on each database. Both database are using copies of the same init.ora file with only directory specific parameters changed, CBO statistics are, of course, the same and one of these 2 database are the only thing running on the box during test time. I plan to run the SQL test scripts with event 10046 lvl 8 set. Should I have a look at anything else during the test to try and shed more light on this discrepency. Thanks, Mike Hand Polaroid Corp. This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dbms_stats broken
Lisa, I'm still using Analyze so I have no direct experience with this package. That being said, would the SET_TABLE_STATS work for the partitions that haven't been loaded yet? Mike Hand Polaroid Corp. -Original Message- Sent: Thursday, May 29, 2003 10:46 AM To: Multiple recipients of list ORACLE-L Hi Darrell Kirti - It was late last night when I was looking at this. It seems I should be using GATHER EMPTY instead of GATHER STALE. However this will put statistics on partitions with no rows. When I load new partitions tomorrow (they are empty prior to the daily load), the number of rows inserted wouldn't reach 10% change. It would take over a week to reach 10% change in order for GATHER STALE to pick up on this and re-analyze these partitions. I don't want statistics saying there are 0 records in a partition that is indeed loaded. I guess GATHER STALE would be much more useful if the 10% threshold could be modified, and/or the threshold could be partition specific. And Kirti, the bugs I have seen are 1192012, 1890016, 2157655. I thought I was running into 1890016. Looks like I'll have to code around this after all. Darn it all. I really am a monkey. Sheesh Lisa -Original Message- Sent: Thursday, May 29, 2003 12:30 AM To: Multiple recipients of list ORACLE-L Lisa, Wow, you might be saving me from peril right now. I have tested this with a small set of tables with no problems (in and 8.1.7.4 instance). I'm preparing to go 'schema' wide in the next week or so for further testing prior to implementing in production. I'd be very interested in more details of your problems in 8.1.7.4 and of course I'll post reports of testing to the list as well. For starters, here is the code I use to obtain a list of 'stale' qualified tables: ( For proper credit, I think I got this from asktom.oracle.com) set serverout on size 9 declare l_objList dbms_stats.objecttab; begin dbms_stats.gather_schema_stats ( ownname = '1', options = 'LIST STALE', objlist = l_objlist ); for i in 1 .. l_objlist.count loop --dbms_output.put_line( l_objlist(i).objtype ); dbms_output.put_line( l_objlist(i).objname ); end loop; end; / And the code to gather stats: set serverout on size 99000 begin dbms_stats.gather_schema_stats( ownname='1', options='GATHER STALE', cascade=TRUE, degree=8, granularity='ALL', method_opt='FOR ALL INDEXED COLUMNS SIZE 1' ); end; / Thanks, Darrell [EMAIL PROTECTED] 05/28/03 09:24PM Hello everyone, Is anyone using dbms_stats and gather stale or gather auto in 9.2? I'm trying to use dbms_stats gather schema stats with the stale option and it just isn't working in 8.1.7.4. This is documented on Metalink. I'd love to hear from someone else if this is fixed in 9.2 and if it can be reliably used. Thank you Lisa Monkey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Jeremiah, No, we don't use suspend since these split/hot backup scripts have been in use since V8.0 and I saw no advantage to using suspend. As you say, taking production out of action for no good reason. With regards to using a split controlfile, do you believe there is a difference between this and using a controlfile after a hard system crash? In both cases, consistency will depend on wheather a write to disk was ongoing or completed. I'll have to check with the guru to see if the split code would interrupt a write in progress. In the 4-5 years that we have been creating a reporting instance this way (on a daily basis), nearly all failures could be attributed to bad disks, and this instance is not critical. On the other hand production backups use the same method. I checked my scripts and while the comments say I backup the controlfile, the code does not. I will definitely correct this. Thanks for emphasizing the need for a binary controlfile as part of a complete hot backup. Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, March 26, 2003 7:24 PM To: Multiple recipients of list ORACLE-L Michael, Your split is no different from a very fast hot backup. So, it does not matter that the split is not atomic. Just use hot backup mode, and generate a binary controlfile using backup controlfile to 'file' and copy it to your destination. A the destination just recover the one or two logs generated while you did the split. Forget about suspend, it serves no purpose and is just decreasing your system's availability. BTW, your current hot-live copies of controlfiles are potentially invalid and totally unsupported. All that expensive equipment and you're suspending! Don't take the thing out of service unnecessarily! -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hand, Michael T wrote: Jeremiah, The only reason I could forsee is if the split is not atomic. This is the case in our (Non-SAN) environment. The split takes several minutes and the control files have been mis-matched when the DB copy was started on the reporting server. My solution under V8.0 was to use only one of the control files for reporting database. My $0.02 Mike Hand -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locking tables in Oracle
Rajesh, 2 -- ROW SHARE or SHARE UPDATE 3 -- ROW EXCLUSIVE 4 -- SHARE 5 -- SHARE ROW EXCLUSIVE 6 -- EXCLUSIVE Mike -Original Message- Sent: Thursday, March 27, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Hi All, Does anybody has any insight of dynamic view v$locked_object? It populates its locked_mode column with numbers what does those numbers mean? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: switch logfile vs. archive log current
I use switch logfile exclusively within my hot backups (because at the time I wrote the scripts I was unaware of the difference) but also check V$LOG to make sure the archive write is complete before proceeding with the backup. I has worked fine on my 8.x production database for the last 4+ years (including daily recoveries to build a Reporting instance). I do have a question though. What is the purpose of switching the logfile for each tablespace? I do it once, after all of the tablespaces have been backed up. Am I missing something? Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, March 19, 2003 11:49 AM To: Multiple recipients of list ORACLE-L A switch logfile isn't mandatory and an archive log current is highly recommended. The switch logfile command would return immdiately and would not wait for the archiver to complete archiving the log. The archive log current would return only after the archiver has completed it's job. You must backup the archivelogs from the first one generated after the first alter tablespace begin backup to the first one after the last alter tablespace end backup. You are also backing up the controlfile which is also highly recommended. I normally use a combination of multiple switch logfile, archive log commands and a Unix sleep command and then exclude the last archivelog from the backup just to be safe. Hemant -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Order of Redo log use
Jared, No they do not have to begin with 1 and in fact my 10 groups are currently 11 - 20. I too have rearranged/reorg'ed redo logs while the database was up. Mostly with success, but in one case linesize was too short when I built my script and production (V7.3) was briefly left with only one redo log. It also seems that my current conundrum is due to insufficient controls while adding new redo log groups to a live database in the past. Downtime is mostly for segment/tablespace reorg (no, not to compress extents ;-) ). Mike -Original Message- Sent: Thursday, February 20, 2003 4:02 PM To: Multiple recipients of list ORACLE-L Mike, Is there any reason your redo logs must begin with 1? You don't need to take the database down to do this, just start with a higher number. Or, if you insist on consecutive numbers starting with 1, just create a temp set of redo, drop the old ones, recreate them, then drop the temp set. I've done this a few times to resize/reorg redo on disk without taking the database down. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Order of Redo log use
Ok, I'm working on a 8.1.7 Tru64 system with 10 groups of redo logs with 2 members; 5 groups on each of 2 mount points. I've finally taken a close look at the order each group is used and I'm not happy. Four of the 10 switches are between redo logs on the same mount point. Now I'm not sure when this happened since this database has been around for many years and the number of groups and the size of the redos have increased, and the 2nd members were added. Now I have down time to correct this over the weekend. I know I can just leave the order the groups are used as is and move/rename the underlying redo logs, but I'd rather have all of the even-numbered groups on one mount point and the odd groups on the other. So is this as easy as dropping (except for the active one) and recreated in the order I want them used or is there other factors. For that matter, when new groups are added how are they merged into the order groups are used. Another few points I found is that the default order of group# in V$LOGFILE does not correspond to the order used, and RESETLOGS does not affect the order of group used either. If this is a RTMF let me know that too. Thanks, Mike Hand Polaroid Corp This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Order of Redo log use
Dennis, The redo log members as well as the controlfiles, are seperated as best at the environment allows, on different stripe sets. In general it is relatively robust using ADVfs LSM mirroring. Redo log size is OK in my view, currently ~40 switches daily with 2 or 3 switches at 3-4 minutes intervals. It appears that I must have added new groups on more than one occasion with the active group at different points. Should be straighted out this weekend. Mike Hand Polaroid Corp. -Original Message- Sent: Thursday, February 20, 2003 2:48 PM To: Multiple recipients of list ORACLE-L Michael The reason to use multiple members in each group is so each member can be on a different device (that is device, not just a separate mount point on the same device). Then if a terrorist sprays your computer room with automatic gunfire (or a drive crashes), maybe one of the devices will be spared. Remember that Oracle can easily rebuild data files. Redo logs and control files are the precious commodity. While you are at it, make sure you have two control files on separate devices. I am paranoid so I always configure three control files. So you need to relocate the second member of each redo log group so both aren't on the same device. Make sure they are all the same size. Evaluate whether you need to make them larger while you are at it. How often does log file switch occur during peak load? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bind variable values
Can the value used in bind variables be retrieved from V$ tables? The reason I am interested is I'm trying to get use a subset of the SQL from V$SQLTEXT from one 8.1.7 instance to run a comparative test on another instance. However, most of the SQL contains bind variables. I checked out V$SQL_BIND_DATA but a records had VALUE as NULL. Thanks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tru64 Direct I/O
Thanks, Stephen I'll pass this along to our SA's. We will be migrating to the Compaq SAN; upgrading our controllers to fiber (HSG80's ?) but we have 2 older 8400's as production primary failover, and yes, they both have access to the same disk farm, though not concurrently (currently). -Original Message- Sent: Thursday, January 09, 2003 5:06 PM To: [EMAIL PROTECTED] Mike, Compaq SAN and Tru64 and direct I/O have been nothing but trouble in my recent experience. I put in over 35 hours over Christmas and last weekend working on recoveries of system crashes. Our problem appears to have been relating to the fact that several machines had mount points on disks that were striped and accessed from different machines. According to vendor techs, this shouldn't be a problem, but told us to move all mount points around so that there were no splits where a disk was being used from more than one host. So far, we have not had a crash since we did that (uptime of 4 days -- a new record for the past 2-3 months). We've disabled direct I/O, but I don't know whether or not this was part of the problem. Our problems started getting worse after going to 5.1a and got severe when we started using multiple nodes of our cluster. Compaq said for awhile that the problem was with the GS160 so we bought 4 ES45's. Talk about a sales pitch Our big machine we sold you 12 months ago stinks, you should 'upgrade' to a bunch of our smaller ones. Good luck. Stephen [EMAIL PROTECTED] 01/09/03 01:54PM OK, everything I've read so far on using Direct I/O with an Oracle database says it's a bad idea. Either performance problems or block corruption may occur. The notes on metalink (132391.1) refer to Tru64 5.0A and 5.1 but not 5.1A (to which we've recently upgraded). So is anyone using Direct I/O on Tru64 successfully. Oracle V8.1.7.3 EE (non-OPS) Tru64 5.1A on Alpha Servers Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tru64 Direct I/O
Title: Message OK, everything I've read so far on using Direct I/O with an Oracle database says it's a bad idea. Either performance problems or block corruption may occur. The notes on metalink (132391.1)refer to Tru64 5.0A and 5.1 but not 5.1A (to which we've recently upgraded). So is anyone using Direct I/O on Tru64 successfully. OracleV8.1.7.3 EE (non-OPS) Tru64 5.1A on Alpha Servers Mike Hand Polaroid CorpThis transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
RE: Orawomen or Nursing? [OT]
Title: RE: Orawomen Lisa, Nursing is no place for a woman; if you thinkDBA'ing is stressful, you ain't seen nothingyet My wife is an RN and, while it may nobe scientific, I attribute our difficulty in conceiving and miscarriage to job stress working on an understaffed hospital floor. That was 7+ years ago and it has gotten worse with state and federal cutbacks. Currently, at some facilities, an 80% turnover is common. Unless working conditions improve drastically in the next 10 years, we will use all our influence to steer our two daughters away from nursing.And be glad you work where a gross error only results in a mangled database, not human tragedy. FWIW Mike -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Orawomen Well, it's been a while since I was in college (1999) but I always felt singled out in a class. Some teachers, that were as old as the hills, truly felt that women should not be in science and did not hesitate to say so. Other teachers could not keep their eyes off my legs - I had to leave work and go directly to school for years. Never mind complaining, the department didn't care. There was only one woman professor, but she taught advanced AI. I never got to take any of her classes. I never saw a female physics or math professor at the university. I had one (male) algebra teacher tell me that "maybe you just shouldn't study math." However it was a female teacher at a community college that finally got me through 3 quarters calculus. To this day I credit her with making me feel that I was capable of understanding higher math and pushing me and the whole class to do so. I didn't finish my bachelor's, I didn't need to and I didn't need the stress. But I can see how the declining IT market (no 22-year-old CIOs anymore) paired with this kind of treatment in school would push a detail-oriented young woman to study something else. Personally I wish I would have become a nurse. Just my 2 cents, for whatever it's worth. Lisa Koivu Oracle No-degree Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 6:11 PM To: Multiple recipients of list ORACLE-L Subject: Orawomen Recently this list had a discussion of female Oracle DBAs. The consensus was that the numbers were increasing, which I view as a good thing. Here is an article with industry statistics saying that the number of women in IT is decreasing. http://itmanagement.earthweb.com/career/article.php/1564501 Any theories? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with IMPort
To fine tune the suggestions aready made, you probably don't want to drop all the table but just tables both in production and development/test. I would create a list of tables exported from production via export / show and use this to create a drop table script. Mike -Original Message- Sent: Monday, January 06, 2003 4:29 AM To: Multiple recipients of list ORACLE-L The best method that I know is: 1) export from production. 2) drop user cascade in development or at least drop all tables. 3) create user in development. 4) import into development with indexes=n and constraint=n. 5) import again into development with rows = n and ignore = y. Step 4 will build all the tables with the data. Step 5 will build indexes and enable constraints. If the tables already exist in the target database then import will not recreate them. As for the data you may have constraints that reject the insert of records. Lets say you have a fact table and a lookup table that contain the branches names. On the fact table you have constraint: branch id must be in the branch table. When you import the fact table before the branch table all the records will be rejected because the branch table does not have the ids yet. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with IMPort
Dennis, Amar - My interpretation of the environment was that dev/test has a different set of tables, some of the tables match production table names but may not have the same columns or data. In this case, my first suggestion to drop matching table names from dev/test is insufficient. Maybe truncating those tables would be a better approach. Copying/cloning production would, of course, wipe out dev/test. If there is ongoing development there, that would be a problem ;) Mike -Original Message- Sent: Monday, January 06, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Amar - I was just thinking about suggesting. And as a bonus, you can test your backups, always a good idea. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 11:10 AM To: Multiple recipients of list ORACLE-L You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. --- [EMAIL PROTECTED] wrote: I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = cool amar The best way to express yourself is to be yourself. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Amar Kumar Padhi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays
Ah yes. . . there's nothing quite like home construction/renovation projects during the holidays to put the 'ell in jingle bells, aye. Or as I once put it: 'Twas the night before Christmas and all through our house not a creature was stirring, the wall was blown out. Lumber and plaster lay around in a heap, electric and plumbing supplies were hip deep. . . . [ Oracle instances were stuffed up the chimney with care. ] Happy Holidays, Mike -Original Message- Sent: Friday, December 20, 2002 4:54 AM To: Multiple recipients of list ORACLE-L But what you can start doing is painting, plastering, levelling concrete and laying floors. 2 months in and the race is on to finish for Christmas. When all of that's done I can start looking for my wife's Christmas present. Hell, maybe I'll tell her that IS her present. All the best for the holidays folks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Capacity Planning -- Expecting the DB growth !!!
One thing I don't think I've seen mentioned is the issue of storage configuration and uptime requirements impact on capacity planning. Is the planned system 7x24 or will there be maintenance windows to add storage? Can storage be added hot or is downtime required. These issues will require the fudge factor to be adjusted accordingly. Mike Hand Polaroid Corp. -Original Message- Sent: Tuesday, December 17, 2002 5:01 PM To: Multiple recipients of list ORACLE-L One problem I've run into when doing some rudimentary cap planning is that much of it is directly related to how much business our Sales force predicts we will generate next year. I've looked at the growth of our general ledger tables and our sales order tables and it's mostly driven by the amount of business we do (we manufacture printing controls). So, some insight into the business by Sales or other company execs may help, too. That, and a fudge factor. One of our larger audit tables had 300% more rows in 2000 than in 1999 because of planned inventory moves used in implementing lean manufacturing. No way I could have predicted that one, but a fudge factor softened the blow a bit. Just my $.02 (before taxes), Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
No, we've turned into a kinder, gentler listduring the Holidays ... (must control my typing fingers of Death..) -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002 9:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: uh-oh.. here they come.. Tom Mercadante Oracle Certified Professional This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
RE: LONG's
Thanks all for the suggestions. I think I'll take a look at COPY and the PL/SQL options since I've used them before, and C Perl are not in my repertoire, I'm ashamed to say ;) To shed a little more light on the requirement, I'm researching the best (subjective) way to convert dictionsry-managed TS's to locally-managed in an 8.1.7.3, Tru64 hosted DB running SAP R/3. The convert-in-place procedure [dbms_space_admin.tablespace_migrate_to_local] does not change extent management for the segment. Jared, I'd consider converting them, but SAP is a little posessive of their Clusters/Pools. Mike H. -Original Message- Sent: Monday, November 25, 2002 6:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Mike, Conner pointed out that you could use C. You can also use Perl with DBI and DBD::Oracle if you like, and have someone there that can use it. Why not just convert them to CLOB and LOB? Jared Hand, Michael T [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:LONG's OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. +**+ This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT - Who would you take with you...
And everything I've learned about single malts, I've learned from this list. And save in my Teetotaller folder ;) -Original Message- You're saving all my fly-fishing emails, right? Man, I wish I was popular. --Walt Weaver Bozeman, Montana +**+ This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LONG's
OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
RE: Problem doing RMAN backup of Clone?
Doug,
I have successfully tested this method for changing the the dbid {gleaned
from Ron Yount's procedure].
Changing the Dbid of copied database: Ron Yount from the Oracle-L provided
the following steps if it becomes necessary to change the Dbid of a copied
database to allow an RMAN catalog to backup both source and target database.
This should occur at the tail of the SAP Database Copy procedure. [Tested
successfully on GTS refresh 5/13/02]
Use sqlplus to connect internal (if using sqlplus comment # must be changed
to 'rem' or '--')
SQL startup nomount
SQL @c.sql /* create controlfile with set database resetlogs */
SQL select name,dbid from v$database; (There should be a new name, but same
dbid from step 3)
SQL shutdown normal
SQL startup mount
SQL exec dbms_backup_restore.zeroDbid(0);
SQL shutdown normal
Rename the control files from the new instance, so they will appear to be
missing.
SQL startup nomount
SQL @c.sql
SQL alter database open resetlogs;
SQL select name, dbid from v$database. (There should be the new name, and
new dbid)
HTH
Mike Hand
Polaroid Corp.
-Original Message-
Sent: Sunday, November 24, 2002 10:14 PM
To: Multiple recipients of list ORACLE-L
Someone has just told me you can't do an RMAN backup of a clone because it
has
the same database id as the original. Is this true or not? If so, how to
get
around it?
Thanks,
Doug
**
@@
This transmission is intended only for use by the addressee(s) named herein and may
contain information that is proprietary, confidential and/or legally privileged. If
you are not the intended recipient, you are hereby notified that any disclosure,
copying, distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error,
please immediately contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hand, Michael T
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Convert TEMP tablespace from datafiles to tempfiles
Jesse, I did the same thing last week on our sandbox system using the method others have prescribed. There is a note 140913.1 covering a LMT bug in 8.1.6. under OpenVMS. You might want to double check to make sure no equivalent problem exists on your platform. Ron, As Jared pointed out, it's the Temporary tablespace (not a tablespace with temporary contents) that permits local extent management. In 8.1.7 I'm sure you've already tried: create tablespace temp_contents datafile '/oracle/.../temp.data1' size 128M temporary extent management local uniform size 4M; or something similar and gotten a ORA-25144. Also be forwarned, 8.1.7 will let you assign a Permanent LMT as temporary_tablespace for a user, but won't let you create temporary segments there. Mike -Original Message- Sent: Wednesday, November 06, 2002 10:56 AM To: Multiple recipients of list ORACLE-L Hey all, I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to take the opportunity to convert the datafiles of the TEMP tablespace to tempfiles. My reason for this change is primarily to get the TEMP tablespace LMT, but also to shrink our hotbacks w/o modifying the working script. I've been trying to reason out this task in my head, as I can't find much on MetaLink, and here's what I've got so far: 1) Shutdown DB. 2) Backup DB. 3) Startup restricted. 4) Offline tablespace TEMP. 5) Drop tablespace TEMP. 6) Create new temporary TEMP LMT. 7) Bounce instance. I don't yet have an arena to try this in. Will users whose assigned TEMPORARY TABLESPACE is TEMP need to be ALTERed? Anyone have any comments on the procedure? TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Two Q's for SAP DBA's
Thank, Jared, Service.sap.com has a limited number of notes on Oracle partitioning (even though they went to great lengths to negotiate that option into their customer's Oracle licenses). And none that I've found that combine the topics of data archive partitioning. If I do find something, I'll pass it on. Mike -Original Message- Sent: Friday, September 27, 2002 10:57 AM To: [EMAIL PROTECTED]; Hand, Michael T On Wednesday 25 September 2002 12:33, Hand, Michael T wrote: Got a couple of questions for those of you dealing with SAP: 1) Has anyone heard of a timeline as to when (or if) SAP R3 will support Oracle 9.x? And, No, and I doubt it. 2) Has anyone implemented table partitions as a method of space management in conjunction SAP archiving? The table dependencies within SAP Archive objects would seem to make this difficult at best? Considered it, but haven't researched. Have you tried service.sap.com? Or whatever the support url is. Jared Thanks for any feedback. Mike Hand Polaroid Corp - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
I also have a just curious question. Do most interchange the values 1000K for 1M or 1000M for 1G? I try to be precise in my usage, but I guess that's just the AR size of my personality. OK, I'll go find my pills now. ;) By the way, we use a maximum size of 4Gb+8k file size but, I've never has a reason to doubt the DEC/Compaq 64bit file systems. Mike -Original Message- Sent: Thursday, September 26, 2002 5:03 AM To: Multiple recipients of list ORACLE-L We tend to use multiples of 1Gb and add 1 Mb to the file so that we get 2001, 10001 Mb etc Solaris 2.8 LMT uniform extents range from 64K to 20Mb John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Two Q's for SAP DBA's
Got a couple of questions for those of you dealing with SAP: 1) Has anyone heard of a timeline as to when (or if) SAP R3 will support Oracle 9.x? And, 2) Has anyone implemented table partitions as a method of space management in conjunction SAP archiving? The table dependencies within SAP Archive objects would seem to make this difficult at best? Thanks for any feedback. Mike Hand Polaroid Corp - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: View Locks
Naveen, Mladen, On almost any other day I could brush off these comments, but not TODAY. Let's think before we type. Mike -Original Message- Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SAP default tablespace (WAS: RE: Misinformation Ranting)
Steve, I've been an SAP DBA for many moons so I'll try to field your questions. As you have alluded to, using SAPDBA for tablespace creation is a good idea since it also update the TSORA table with the tablespace name. It may also do other subtle things. And SAPDBA does a reasonable job managing CBO stats. As far as the default tablespace goes. If you are controlling the deleting and recreating of the table, you can control the destination tablespace in Tx SE14 = Storage Parameters. If the tables are being automatically dropped and recreated in the wrong tablespace, the solution is more complicated but sound. 1) In development, modified the TAORA table to include a new record (data class) for each new tablespace, and dependent tables DDART DARTT; 2) transport these changes; 3) in development, change the data class for these tables via TX se11 = technical settings and transport. This should change the default tablespace to the home-grown one. If you need (or want) more details, let me know. Caveat: We never got past 2) as too few tables were affected to warrent changing SAP-owned objects. Mike Hand Polaroid Corp -Original Message- Jared, I recently started a job that uses SAP on Oracle 8.1.7 and the only word that describes my day is frustration. Are there any SAP do's and don'ts you can recommend? From my brief experience, I should use SAPDBA to add tablespaces or check stats. Other than that I use sqlplus/scripts for everything else. When the system does have performance problems, it's really tough to isolate the problem because there's 400 users sharing 100+ connections and they're all SAPR3. the other irritating problem is on the BW system, tables get dropped and recreated in the wrong tablespace. I know there has to be screen (or table) that maps objects to tablespaces, but haven't found it. Any tips you have would be appreciated. Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Privileges for other's table
zhu chao, Thanks for checking this out. I tried it again this morning and it worked like your example. At first I thought there might be a difference when creating a view on all rows (*) versus creating the view on a subset (x, y, z) but under both conditions a view was created successfully. Of course, attempting to grant select on the view failed with a ORA-1720. May be this is an hidden feature of 8.1.7.3 on Tru64. Unfortunately, I still have the screen dumps so I can't tell my boss that I'm going crazy and need a extended vacation ;) Mike -Original Message- Hand, Michael T, hi, what you tested is not the normal behavior of oracle, neither the document said like that nor in my database behavior like that.Maybe something is wrong with your database:) Look: SQL conn internal Connected. SQL create user t identified by t; User created. SQL grant connect to t; Grant succeeded. SQL conn t/t Connected. SQL select count(*) from sys.obj$; select count(*) from sys.obj$ * ERROR at line 1: ORA-00942: table or view does not exist SQL conn internal Connected. SQL grant select on obj$ to t; Grant succeeded. SQL conn t/t Connected. SQL select count(*) from sys.obj$; COUNT(*) -- 26011 SQL create or replace view sysobj as select * from sys.obj$; View created. SQL select * from v$version; BANNER Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE8.1.7.0.0 Production TNS for Linux: Version 8.1.7.0.0 - Development NLSRTL Version 3.4.1.0.0 - Production Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net === 2002-09-09 16:23:00 ,you wrote£º=== Ok, I haven't had to deal with privileges much lately but this one had be stumped for a while, V8.1.7 Tru64. This is from an account with minimal privileges: SQL select count(*) from sys.obj$; select count(*) from sys.obj$ * ERROR at line 1: ORA-00942: table or view does not exist SQL connect sys Enter password: Connected. SQL grant select on obj$ to utility; Grant succeeded. SQL connect utility/ Connected. SQL select count(*) from sys.obj$; COUNT(*) -- 37742 SQL create view o_by_vlo as select name, obj# from sys.obj$; create view o_by_vlo as select name, obj# from sys.obj$ * ERROR at line 1: ORA-00942: table or view does not exist SQL connect sys Enter password: Connected. SQL grant select on obj$ to utility with grant option; Grant succeeded. SQL connect utility/ Connected. SQL create view o_by_vlo as select name, obj# from sys.obj$; View created. . . . So it would seem that with grant option is needed to create a view on another schema's tables. It took a little thinking on my part to realize that this makes sense as the view owner would be able to grant privileges on the underlying tables. Incidentally, I also found out that you can't use the grant option within roles. I wonder why? Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
Privileges for other's table
Ok, I haven't had to deal with privileges much lately but this one had be stumped for a while, V8.1.7 Tru64. This is from an account with minimal privileges: SQL select count(*) from sys.obj$; select count(*) from sys.obj$ * ERROR at line 1: ORA-00942: table or view does not exist SQL connect sys Enter password: Connected. SQL grant select on obj$ to utility; Grant succeeded. SQL connect utility/ Connected. SQL select count(*) from sys.obj$; COUNT(*) -- 37742 SQL create view o_by_vlo as select name, obj# from sys.obj$; create view o_by_vlo as select name, obj# from sys.obj$ * ERROR at line 1: ORA-00942: table or view does not exist SQL connect sys Enter password: Connected. SQL grant select on obj$ to utility with grant option; Grant succeeded. SQL connect utility/ Connected. SQL create view o_by_vlo as select name, obj# from sys.obj$; View created. . . . So it would seem that with grant option is needed to create a view on another schema's tables. It took a little thinking on my part to realize that this makes sense as the view owner would be able to grant privileges on the underlying tables. Incidentally, I also found out that you can't use the grant option within roles. I wonder why? Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please need some help on imp
Bill Ignore=Y is that what you're looking for? Mike -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: drop tablespace including contents
Russ, You have my sympathies. I've been managing SAP databases for the last 7 years, and the last time I let SAPDBA control a reorg was 6.95 years ago. It performs some tasks reasonably well, like datafile additions and managing CBO statistics refreshes (especially since SAP wants certain tables to be left without statistics). But for reorgs, I prefer more direct control. Perhaps you can use this SNAFU to convince management to have sapdba generate the scripts, then allow you to modified them appropriately. Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, August 21, 2002 9:03 AM To: Multiple recipients of list ORACLE-L I fully agree. Unfortunately management insists on it. Russ -Original Message- Sent: Tuesday, August 20, 2002 9:13 PM To: Multiple recipients of list ORACLE-L Dick, There is absolutely *nothing* that SAPDBA does that a reasonably knowledgeable DBA can't do from his of her favorite toolset. ( vi, Perl and sqlplus for me :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot Backup using EMC /BCV splits
Nat, We have a similar backup strategy using a homegrown split procedure on Compaq Tru64. We split while all tablespaces are in backup mode as our's is a controller based split and takes 5-6 minutes. After all, if the split is going to take place after the tablespaces are taken out of backup mode, why put them in backup mode at all?!? I personally would not rely on the hardware to keep the database consistent during a split, but then again, I don't have any experience with EMC. HTH Mike -Original Message- Sent: Thursday, August 15, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Hot Backup using EMC /BCV splits
Bing, Ours is ~630Gb across 19 mountpoints using (Compaq) controller based split [for both backup reporting instance creation]. Mike -Original Message- Sent: Thursday, August 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Can you tell us what is the size of the database that is using EMC/BCV or other Hardware vendor splits mechanism? Thanks. Bing Wong Open Systems Database Administrator x25721 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cloning Problems
Ethan, Consider performing the clone in 2 distinct phases (my SOP). 1) Copying the source database to the target machine w/ recovery if necessary, and 2) Renaming/recreating the controlfile. The recovery can be against a hot backup copy or cold w/ a controlfile backup, and assures one of having a viable database for renaming. This method also gives you the option to apply post-copy archived redos from the source database if last minute changes are required on the clone. Please let me know if I've missed your point, as my short-term memory is not what it should be. What was I saying? ; Mike -Original Message- Sent: Monday, July 29, 2002 6:00 PM To: Multiple recipients of list ORACLE-L Michael, See previous post. It does appear that even during a shutdown immediate (which does checkpoint) that instance recovery could be required. Thus we need redo logs. Yes they will be recreated as you stated. However, there is no way to both rename the database and perform instance recovery on a clone from a cold backup. Thus the solution is going to be either shutdown normal or perform a few log switches and shutdown right away (and cross fingers). These both should work but a straight shutdown immediate seems to be risky. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 3:59 PM To: Multiple recipients of list ORACLE-L From my understanding you do not need the on-line redo logs unless you perform a shutdown abort. As a matter of fact the database will create the logs if they do not exist when you issue the alter database open resetlogs command. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BR solutions
I would guess: 1) in-house OS-dependent scripts 2) We don't need DB backups, we use x and it doesn't go down ;) Mike Hand -Original Message- Sent: Thursday, July 25, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Copy
Also, as the example points out, make sure you use the hyphen at the end of
line if your command spans more than 1 line.
-Original Message-
Sent: Sunday, July 07, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
copy has been around for a lng time
from the 8.1.7 docs
COPY {FROM database | TO database | FROM database TO database}
{APPEND|CREATE|INSERT|REPLACE} destination_table
[(column, column, column, ...)] USING query
and the example
SQL COPY FROM SCOTT/TIGER@HQ -
CREATE SALESMEN (EMPNO,SALESMAN) -
USING SELECT EMPNO, ENAME FROM EMP -
WHERE JOB='SALESMAN'
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hand, Michael T
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Unix - scheduling
Roland, crontab alone will not meet your needs. Hint: check the date command and MOD type fuctionality in a shell script. Good luck, Mike -Original Message- Sent: Tuesday, July 02, 2002 6:14 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland Roland, Please, just for once, couldn't you try to figure out things by yourself and type 'man crontab'? I am naively optimistic about human nature but you make me despair. I'd be really happy to read one day from one of your posts something you have picked up in a doc I have not had time to read myself. Really. Regards, Stephane Faroult Oriole -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent: Prodution database recovery
Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora-600 [12700] to be detected. Analyze table validate structure confirmed this error. We started a PITR to a time before the errors were detected. All datafiles were restored (file copy took ~7.5hrs [614Gb]), current control files redo logs (10 groups / 2 members). But when the alter database recover database until time 'xxx' is issued, a corrupt header is detected in one of the datafiles (ora1122/1251). Now this is a disk mirror split backup. We've used this process to create a reporting database copy for years and the reporting copy was build cleanly from the same source several hours after the backup copy. DBverify against the split backup copy and against the restored file (with the corrupt header) detect no errors but return diffent results for used/free/other blocks. Now, this first attempt at recovery opened about 1/3 of the datafiles. My thought was to restore these ~100 datafile again and retry the recovery. Right now I'm a little bleary-eyed so any suggestions would be welcome. Thanks, Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent: Prodution database recovery
Thanks David, You hit the nail on the head. Hardware problems are preventing the backup files from restoring normally. We've got several hardware experts on site this morning going over the disk/filesystem with a fine-tooth comb. File header dump shows file_id mismatch which disappeared in 2 instances when the files were re-restored. Mike -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/30/02 6:03 AM Don't know whether this is of any use, but could it be that you still have a hardware fault that is causing your restore to become corrupted? Regards David Lord -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 10:23 To: Multiple recipients of list ORACLE-L Subject: Urgent: Prodution database recovery Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora-600 [12700] to be detected. Analyze table validate structure confirmed this error. We started a PITR to a time before the errors were detected. All datafiles were restored (file copy took ~7.5hrs [614Gb]), current control files redo logs (10 groups / 2 members). But when the alter database recover database until time 'xxx' is issued, a corrupt header is detected in one of the datafiles (ora1122/1251). Now this is a disk mirror split backup. We've used this process to create a reporting database copy for years and the reporting copy was build cleanly from the same source several hours after the backup copy. DBverify against the split backup copy and against the restored file (with the corrupt header) detect no errors but return diffent results for used/free/other blocks. Now, this first attempt at recovery opened about 1/3 of the datafiles. My thought was to restore these ~100 datafile again and retry the recovery. Right now I'm a little bleary-eyed so any suggestions would be welcome. Thanks, Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SMON reports Dead Transactions - Not seen this before
Murali I have seen them occasionally in our 8.1.7 database, generated during a database recovery. The recoveries in question complete normally so I haven't researched the details. Mike Hand Polaroid Corp -Original Message- Sent: Wednesday, May 15, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Hello list I am for the first time seeing a message like this in the SMON trace file. --- Using 1 slaves for 1 dead transactions Recovered xid: 0x000e.00a.4971 in 20 milliseconds; nchk=0, size=2327 --- I have not seen this message before, any ideas ... Murali Vallath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 1 Table and its Indexes occupying 30% space of the Database.
What about max # of datafiles? If you're added them every 2 weeks what about making them larger? After all, not many systems are restricted by the 2Gb file size limit any more. Michael Hand Polaroid Corp -Original Message- Sent: Monday, May 13, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Hi All, I have a table in my database ( size 70GB ) with size of 7GB and it has 13 indexes on it. 5 Indexes are of the size 2 GB and rest are around 500-800Mb. Total size of the table and indexes in total is 21GB. The table size is increasing everyday and every 10-12 days I have to add a datafile for Index and data tablespace. I just want to know the precautions I need to take while maintaining this table. Is oracle 7.3 having restriction on the maximum size of the table. Kindly give your valuable suggestions. Thanks in advance, Deepender Gupta The New Power Company 1 Manhattanville Road Purchase, NY 10577 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would require another 25hr window ;) -Original Message- Sent: Thursday, April 11, 2002 3:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the new dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Loader
David, In the FIELD clause, shouldn't it be OPTIONALLY ENCLOSED BY ? -Original Message- Sent: Monday, April 08, 2002 12:16 PM To: Multiple recipients of list ORACLE-L I am trying to user SQL*Loader to load some tables in my 8i database. The data will not load. It seems to have to do with the format. In particular the date format. Can anybody help? I have messed with this for 2 days. Here is my data file (only 5 rows displayed): 80,3614,32,0,1,2,'12/20/2001 2:34:42 PM',1860,0,,0 81,3619,32,0,1,1,'12/20/2001 2:38:42 PM',1861,0,,0 82,3620,32,0,1,1,'12/20/2001 2:41:37 PM',1861,0,,0 83,3621,32,0,1,2,'12/20/2001 2:42:30 PM',1861,0,,0 84,3622,32,0,1,2,'12/20/2001 2:42:15 PM',1861,0,,0 Here is my control file: LOAD DATA INSERT INTO TABLE APP_DEV.TESTCASEUATSTATUS FIELDS TERMINATED BY , ENCLOSED BY '' TRAILING NULLCOLS (TESTCASESTATUSID INTEGER, TESTCASEID INTEGER, USERID INTEGER, CORDID INTEGER, UATASSIGNED INTEGER, PASSFAILSTATUSID INTEGER, DATETESTED char to_date(:DateTested,'mm/dd/ hh:mi:ss pm'), TASKID INTEGER, RETEST INTEGER, ASSID INTEGER, NONVALID INTEGER) I have also tried: DATETESTED date 'mm/dd/ hh:mi:ss pm' this string for the date field. David Ehresmann Oracle DBA 8i OCP MCI Worldcom [EMAIL PROTECTED] 972.656.1015 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Ehresmann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lite: Redo sequence# poll
Ok Jeremiah, I'll warrent that Redo sequence# is a uneven measuring stick. Longest since last restart - 6/22/01 Oldest - 7/24/96 Highest SCN- a pokey 366 802 309 What kind of environment gets you to a 13-digit SCN? Mike -Original Message- My stats: Longest time since last restart (uptime) - 08/30/2001 (v$instance - startup_time) Oldest database - 11/05/1999 (v$database - created) High SCN - 5551718526045 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lite: Redo sequence# poll
Well it looks like our production OLTP database will be breaking into the 6-digit range for redo sequence# this year, and I had a little idle time. This got me thinking about where some other folks are at, so here it goes: Redo sequence#: 89689 Cummulative Wr: 11.12Tb (assumes each Redo log is full at log switch) Uptime since database creation / resetlog: ~3.5yrs Michael Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lite: Redo sequence# poll
Jared, Sorry if the Uptime got you going. I didn't mean to imply 7x24 no db shutdown or crashes but operational time with out the need for a recovery w/ resetlogs. With that in mind it has been a stable platform over that 3.5 years. DEC/Compaq Alpha 8100; 6-12Gb RAM; 5 disk mirror sets (Storageworks); OSF/Tru64; V804 - 8063 -Original Message- Sent: Monday, March 11, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Details, Michael, details. 3.5 years uptime? Platform, versions, HW configuration, memory, etc. Inquiring minds want to know. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: # of datafiles per tablespace
FWIW, there is a strong case for keeping consistent datafile sizes, similar to the argument for extent sizes. This makes for easier file exchanges for hot to not-so-hot disks, or copying the database to a new system. And segment extent size should be kept in mind, i.e., you don't want to be adding 500Mb files to your tablespace with segment extent size of 128Mb. That gives you about 23% wasted space. Mike -Original Message- OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle 8.1.7 patch 2 or 3?
Lee, Be aware of bug 2220597. I believe metalink identifies other 64bit OS's, but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug fix available yet. Mike Hand Polaroid Corp -Original Message- Sent: Friday, March 01, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Anyone aware of 8.1.7.3 for Oracle on Tru64 ?? I haven't seen this available on OTN/Metalink and as we are upgrading our DBs at the moment I might as well go to that if its out there. TIA Lee -Original Message- Sent: 28 February 2002 17:19 To: Multiple recipients of list ORACLE-L Its surprising that a vendor goes down to the 4th digit in terms of support/nosupport. If its any help, we've been running 8.1.7.3 (solaris) since the patch came out and have not encountered any problems hth connor --- Xiaohong Yang (Sharon) [EMAIL PROTECTED] wrote: Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. platform: Sun Solaris 2.8 Oracle EE server 8.1.6.3.0 Any input is appreciated. Xiaohong Yang (Sharon) Center for Bioinfomatics UNC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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. -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: Import placing data into wrong tablespace
Bill, The default is to import objects back into the tablespace from which they were exported. Your surest bet is to create empty tables in the appropriate tablespace (by editing the imp/indexfile), then import the date. Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, February 27, 2002 1:20 PM To: Multiple recipients of list ORACLE-L I have a user ENVTST with a default tablespace ENVTST_DATA. I have a user ENVTPA with a default tablespace DATA. I export user ENVTPA as SYSTEM, and then try to import into ENVTST schema, also as SYSTEM. Data is going into DATA tablespace, not ENVTST_DATA tablespace. Any ideas? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade directly to 8.1.7.3?
Barq, ;) I've been bouncing up and down through the 8.1.7 patches on Tru64, and have just backed out the 8.1.7.3 patch (to 8172(1)) because of bug 2220597, so I have a suggestion to avoid an addtional code tree. Deinstall the 8172 code then reinstall 817, migrate the production database, then apply the patch of your choice. HTH Mike H Polaroid Corp. -Original Message- Solaris 2.6 Oracle 8.0.5 -- Oracle 8.1 -- Oracle 8.1.7.3 I have a Solaris box with a test and a production database. I have 2 code trees: 8.0.5, and 8.1.7 patched up to level 8.1.7.2. With Oracle's blessing (really, I opened a tar), I upgraded the test database directly from 8.0.5 to the 8.1.7.2 patch level. Did not pass go. Did not collect $200. OK, here's a surprise. I still have not had an opportunity to upgrade production, which is still at 8.0.5, and now I'd like to upgrade it to patch level 8.1.7.3. However, the 8.1.7.3 patch documentation states that When migrating a database from an earlier release, you must complete the database migration to the 8.1.7 release prior to applying this patch set. If I believe this note, then I believe I must install a new code tree with a vanilla 8.17, then upgrade production from 8.0.5 to 8.1.7, then immediately upgrade again to 8.1.7.3My problem: I don't have an extra gig of space to devote to another code tree. (And obviously I want to thoroughly test the test database with exactly the same version I'll be running in production, i.e., 8.1.7.3.) I don't see a good reason not to go immediately to 8.1.7.3, especially since I was able to go directly to 8.1.7.2 with the test database, which worked nicely. However, this is a critical database, and I'd just as soon not screw it up. Any words of widsom? Thanks for any help. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP-UX11(32 bit)/8.1.7/Install Question
Mike, You said you moved everything. Did that include redefining ORACLE_BASE. I thought that what the installer used as the default path for the oraInventory directory. I don't know if that's the case when you've got an existing oraInventory though. I'm slogging through Universal Installer install problems (on Compaq Tru64) as well. Mike -Original Message- Sent: Friday, February 15, 2002 3:14 PM To: Multiple recipients of list ORACLE-L Hi All: I am trying to install an upgrade to one of my HP servers and it's making me crazy. The previous DBA used /opt/oracle/ as his ORACLE_BASE. I have since moved everything to a more ofa-like structure and changed all the pointers and stuff. Now, though, when I run the 8.1.7 installer from the CD, it tells me... [oracle8 SD_CDROM]$ [oracle8 SD_CDROM]$ ./runInstaller [oracle8 SD_CDROM]$ You do not have permission to write to the inventory /opt/oracle/oraInventory. Installation cannot continue.: Permission denied [oracle8 SD_CDROM]$ [oracle8 SD_CDROM]$ I have looked and looked for something pointing to /opt/oracle. I cannot find a thing. I do not want to create a link there because that will just perpetuate the problem. Does anyone know where the installer looks for this stuff? TIA, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unorthodox 8i install/upgrade: FOLLOWUP
I did promise to report back, so here it is. The use of symbolic links to redirect storage from default directories worked fine. I was even able to do this midstream when the Universal Installer complained about insufficient disk space. $ORACLE_BASE/jre, $ORACLE_BASE/oui, $ORACLE_BASE/tmp, /tmp/OraInstall and /oracle/stage/817_64 were all redirected using symbolic links and the 8.1.7 upgrade completed successfully. Mike -Original Message- Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
Fred, I'll respond this way. The odma makes its selection on the database to upgrade based on those available from oratab (with the old database $ORACLE_HOME). Also the odma default execution will want to start that database before it upgrades the datafiles. On top of that, I would want my test upgrades to mimic the production upgrades as closely as possible. With that in mind, I would reinstall 8.0.5 under 5.8, and proceed from there. Mike Hand Polaroid Corp. -Original Message- Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unorthodox 8i install/upgrade
All, Thanks for the feedback. I'll give it a shot using symbolic links and let you know how it turns out. Mike -Original Message- Sent: Wednesday, February 06, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unorthodox 8i install/upgrade
Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Book Club ?
Steven, The only one I'm familiar with is http://lcis.booksonline.com . I was satisfied with there service membership deal. Mike -Original Message- Sent: Thursday, December 13, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi, I want to join a book club to get benefit from the memebership deal. Does any one know a book club which has most Oracle, Jave books? Thanks for the info. Steven __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steven wndy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wite paper link?
List, We will be upgrading from 806 to 8172 on Tru64 40g/51 next quarter. We did the upgrade on a sandbox system and the process went smoothly. However, my biggest concern is any changes in the CBO. Are these concerns warrented? I was planning on running a series of SQL statements with trace on to compare the CBO under both versions. Any other suggestions to make this upgrade as seamless as possible? Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade 8.0 to 8i - Was RE: Wite paper link?
Sorry for the subject SNAFU. That's what I get for cut pasting. Mike SNIP List, We will be upgrading from 806 to 8172 on Tru64 40g/51 next quarter. We did the upgrade on a sandbox system and the process went smoothly. However, my biggest concern is any changes in the CBO. Are these concerns warrented? I was planning on running a series of SQL statements with trace on to compare the CBO under both versions. Any other suggestions to make this upgrade as seamless as possible? Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0 to 8i
Dennis,
We are currently using 'choose' in 8.0.6.3. During our last upgrade from
8.0.4.x to 8.0.6.x our software vendor (SAP) recommended including event
10183 to disable CBO cost rounding. Although with this event it appeared to
be choosing the most efficient index, the response time was horrendous
compared to w/o this event. I was just hoping to avoid any similar problem
when we go to 8.1.7.
I am aware of the system-owned object corruption problem (I believe it's
note 96117.1
[couresy of some off-list help {thanks BL}]).
Mike
-Original Message-
Sent: Friday, December 14, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L
Michael - We did this upgrade on Compaq Tru64 and experienced no CBO hitches
(or other hitches). Is there something in particular that raises your CBO
concern? Are you on RBO now?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hand, Michael T
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: which view used ?
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spooling to a flat file via SQL*Plus
Cheri, What about INSERT INTO new_table SELECT a,SUBSTR(b,1,255),c,d,e FROM old_table; Just a thought. Mike -Original Message- Sent: Wednesday, December 12, 2001 10:00 AM To: Multiple recipients of list ORACLE-L I need to chang a column in an existing table from varchar2(2000) instead to varchar2(255). I'm to truncate any data that exists that is longer than 255. I renamed the original table to old_table. I created a new table with the same definitions as old_table except made the single column that was varchar2(2000) is now varchar2(255). I want to spool the data to a flat file in comma-delimited form. I only want to spool out 255 characters of the column in question. Then I'll just load it back in using SQL*Loader. I haven't done this for a long time and I can't remember all the sql*plus commands to set up the output properly so that the lines can wrap, etc. Also, I'm not sure how to tell it to only list 255 characters of the 2000 character column in the output file. I know I can spend some time looking this up in my docs but it's a terrible day today with a lot of fires burning in various directions. I'd appreciate it if some kind sole could help me out with the commands to spool this out properly. desc orig_cd_experience; Name Null?Type - KS_EXPERIENCEID NOT NULL NUMBER(38) EXP_NOTES VARCHAR2(2000) EXP_QA_STATE VARCHAR2(100) TEMP_RNCHAR(1) EXP_REVIEW_NEEDED NOT NULL CHAR(1) In everlasting gratitude, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password Changes
Jared, I may be out to lunch (and I haven't create too many users lately) but I though later versions of Oracle could be set to prevent repeating a password over time (and/or length, randomness restrictions). If this is the case, wouldn't the old password have to be kept somewhere? Mike -Original Message- Sent: Thursday, December 06, 2001 7:37 PM To: Multiple recipients of list ORACLE-L It can be seen in dba_users. The table is sys.user$. Once you've changed it, the old value is gone for good. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password Changes
Jared, All, The challenge has been accepted. In this episode of This Old Password we search for the lost password with the help of sql_trace and a new test profile. And voila, we discover the SYS table user_history$. The moral of the story is that if the aforementioned user is assigned a profile where Password_Reuse_Time or Password_Reuse_Max is not Unlimited (the default), then old passwords will be stored in user_history$.password until they are no longer required to enforce the profile constraints. If the user is not assigned this type of profile you are out of luck. And, of course, you would have to disable the profile to reset the password to an already-been-used value. You never know what you'll start with some questions ;-) Have a great weekend. Mike -Original Message- Sent: Friday, December 07, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Mike, Good point, I obviously was out to lunch on that one. Your mission, should you choose to accept it, is to search out and disseminate the knowledge regarding this old password. Should you choose not to accept this mission, I will disavow all knowledge of this email and claim it was spoofed by persons unknown. This message will not self destruct in 5 seconds, but will probably hang around in various archives for centuries, consuming valuable resources. Now where'd that coffee go to... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating a reporting DB
Step 3.1 Switch archive logs and copy to 2nd machine Rename the datafiles to new location and recover until cancel using the Old sid THEN Recreate the controlfile with the new SID Let me know if I missed anything, or I can give you or Henry (? no 2nd addressee in your post) more details. Mike Hand Polaroid Corp. -Original Message- Sent: Friday, December 07, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Folks, I'm sure that someone on the list has done this in the past or at least can see the forest through the trees. I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Message at the start of svrmgrl
Anand, I installed the same(? 8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this result. However, I do remember this kind of result with a earlier upgrade to 8.0.x in the distant past. I believe it is a verbose linking option with no negative impact. Is svrmgrl the only executable responding like this. If so, try relinking. Mike Hand Polaroid Corp. -Original Message- I have just done installation of 8.1.7.0 on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. When I start svrmgrl I see a line "inst emulated pid=175364...". --$ svrmgrlinst emulated pid=175364 svrmgrl va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028 Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
RE: Import Help
Sujatha, Yes it will try to create them, but John's point is that if you create the database/tablespaces before you import then the tablespaces will already exist. The import will generate errors on the tablespace create steps then move on to schema object import steps. Mike Hand -Original Message- Sent: Wednesday, November 14, 2001 7:56 PM To: Multiple recipients of list ORACLE-L Hi John, But wont this try and create the datafiles in the same location as the original database??? Regs Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
SNIP The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies SNIP I'm incredulous. Hand Technologies failed!? Why don't they ever tell the owner these things. Note to self, schedule meeting with senior staff . . . ;) Actually, it seems Boston and vicinity are also experiencing the same major slow down. We are now under Chapter 11 reorganization. I haven't decided if this is a good or a bad thing, but at least I'm still employed, and more importantly valued. Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup of large databases
Ed, We have a 550Gb database which we backup nightly via a disk mirror set split. The mirror set is then mounted on our failover/reporting hardward and written to tape. Archived redo logs are written to tape twice daily and kept on disk for 3 days. 8063 on Compaq Tru64 Mike Hand Polaroid Corp -Original Message-From: Ed Lewis [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: backup of large databases Hello, I'm curious how people handle the backups for large/very large databases; 200gb or greater.
RE: log file size change
srinivas, I would suggest that you look at this as 2 seperate tasks. 1) Relocating/rehosting the database, then 2) Resizing the redologs. So leave the create controlfile script as is, then alter database to drop the 25M log groups and add your new 5M log groups. Mike Hand Polaroid Corp -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi lists, I need to do a refresh of the database (different servers) in the source my logfile size is 25 Meg and I want to change it to 5 Meg in the target and recreate the db using controlfile. I copied all files to target server, what should I change in the trace dump of controlfile. should I use logfile 'file1','file2' size 5 M reuse. ( Note: I use reset logs) regards, srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Create user identified by externally
However if you actually created the user by using the command: create user OPS$ABC identified BY externally . . . [See Below] Oracle8 Enterprise Edition Release 8.0.6.3.0 - Production PL/SQL Release 8.0.6.3.0 - Production SQL create user test identified by externally; User created. SQL grant connect to test 2 ; Grant succeeded. SQL connect test/externally; Connected. -Original Message- Sent: Thursday, September 20, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Hi, If there is user created using identified by externally, could this user login to database remotely? If it could, could you please help us? Thanks, Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STOP THE PRESS!!
What we do know is thousands of Americans, military and civilian, men, women, and children have lost there lives today, and perhaps tens or hundreds of foreign visitors as well. What we don't know is who. There will be a time when an individual, group or government is sufficiently linked to these atrocious acts, and at that point the US should do everything necessary to punish and ensure it can never be repeated. But it is a waste of energy to give in to hate and rage as it is usually misdirected. Every man wants to protect his family and by extension his country. The macho image of unleashing a righteous wrath upon a deserving foe is alluring. But at 40+ and 14 years in civvies I know that combat is for the young and a last resort. And so I do what I can do stem the rage of impotence; go donate a pint of blood at the local Red Cross, and pray for the victims. Mike Hand Polaroid Corp. -Original Message- Sent: Tuesday, September 11, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Time to test all the weapons we have been buying. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Interesting News..
Interesting to say the least. We have a meeting with our Compaq reps tomorrow to discuss the Alpha processor move to Intel. I'll put money down that a discussion of the HP/Compaq merger will eclipse Alpha/Intel. If anything worthwhile comes up, I'll let you all know. Mike Hand Polaroid Corp. -Original Message- Sent: Tuesday, September 04, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Thought this would interest you guys.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !! *Very* important Oracle-L message !!
I will weigh in for a one-time contribution. Thumbs-down on the complexity of managing a subscription. Since there seems to be some concern confusion about the value of money (US$20) and exchange rates (with an undercurrent of the ability of all to pay), perhaps a different yard stick is in order. Maybe 1/400th of your monthly gross pay, or 1/5th of the weekly family grocery bill? I know to a staunch capitalist (like myself), this smacks of . . . from each according to his ability communism. But, as no assigned value has been placed on Bruce's services, and there is no requirement to pay, I look at it as a gift/investment, not a fee-for-service transaction. FWIW. Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: checkpoint message
These messages will show up in your 8.0.x database if you have set log_checkpoints_to_alert=TRUE. This gives you an easy way of seeing how long it takes to complete a checkpoint and if any are happening between log switches. Mike Hand Polaroid Corp -Original Message- Sent: Tuesday, August 21, 2001 10:01 PM To: Multiple recipients of list ORACLE-L I get the same kind of message, anyone knows what it means? Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -Mensaje original- De: mala singh [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m. Para: Multiple recipients of list ORACLE-L Asunto: checkpoint message Hi all I think there is some wait in our checkpointing.please correct me.I received the following message in alert.log file Beginning log switch checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1 Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1 Please advice me for correction. Thanks in advance. Mala DBA-USA _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database upgrade w/ standby
Rachel, The rebuild process is very painful. The database is 560Gb and getting the backup tapes to the DR site and getting the standby instance built before there are too many redo logs (for the I/O channel) to apply can be problematic. However, the more I think about it, the more a rebuild seems to be the only choice. Any other options out there? Mike -Original Message- Sent: Friday, August 17, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Michael, Why not just rebuild the standby database from a backup of the upgraded production database? Or am I missing something here? Rachel From: Hand, Michael T [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database upgrade w/ standby Date: Fri, 17 Aug 2001 07:15:35 -0800 I will be performing an upgrade this weekend of out production database from 8062 to 8063 (Alpha Tru64 40G machines). However we also have a standby instance which will obviously also have to be upgraded (my first). Are there any subtle things I have to look out for? One thing that comes to mind is that rerunning catalog.sql (or other scripts) on production can't be done on the standby instance, those changes would have to be brought over through the archived redo logs. Any others? Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Issue/question
What about generating statistics? Mike Hand Polaroid Corp -Original Message- Hi, What is the Import utility doing exactly after it says the rows of a table have been imported? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving tables to a different tablespace
Al, In order to assure the tables end up in a tablespace other than the one from which they originated, you'll have to create empty tables in the outln_ts tablespace prior to the import (between step 4 5). Easiest way is to to a import w/ indexfile=file_name, then edit and run this file. Mike Hand Polaroid Corp -Original Message- Sent: Thursday, July 26, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Hi Group, Please explain what I am doing wrong. 1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod 3) Created tablespace outln_ts on webprod 4) Altered user outln default tablespace outln_ts 5) imp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 6) SQL select table_name, tablespace_name from dba_tables where owner = 'OUTLN'; TABLE_NAME TABLESPACE_NAME -- -- OL$SYSTEM OL$HINTS SYSTEM XX OUTLN_TS WHY are the tables being re-imported back into SYSTEM tablespace Oracle 8.1.7 on Sun Solaris 5.7 TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: view contents of datafile
Joe, I am reading between the lines here, so bear with me. I think you will be disappointed with the results. Oracle (8.0.x at least) will assign extents in a round robin fashion across all online datafiles in a tablespace. All three files will have some extents in them. The only solution (well, there may be others) is to include a step to drop and recreate the tablespace after the export. And, assuming you export with compress=y, you can create empty tables in the rebuilt tablespace, and know before you import rows if the tablespace is large enough. Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, July 11, 2001 7:45 PM To: Multiple recipients of list ORACLE-L If my tablespace became so big that it had 3 datafiles and became so fragmented, then I export and import the whole databse, how can I tell if the REORG only used up one or two datafiles. OR is there a utility to see contents of a datafile? Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Backup Question
Dennis, This is the method we've been using for many years. There has never been a case where the open datafile has been required for any kind of restore. However, I can count on one hand the number of times where we had to go to tape for a database recovery. FWIW Michael Hand Polaroid Corp -Original Message- Sent: Wednesday, July 11, 2001 3:29 PM To: Multiple recipients of list ORACLE-L Hi all, We are running into tape capacity problems and unix admin came to me asking if we could skip backing up some drives. Right now we are doing hot backups on all production databases to disk and then the whole server get backed up to tape. Since the backups for open database files are not valid, the unix admin asked if we could only backup the drives that has the backup dumps. One side of me says this can be done but another nagging side of me is not sure about this. So I am posting this to the list and see what other folks think of this one. Thanks Dennis Meng Database Administrator Focal Communications 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT::Take a look.
Dick, McCain is what one should think of as a dyslexic Republican. He thinks he's on the right when he's really on the left. ;) [EMAIL PROTECTED] 06/28/01 04:26PM snip Dick Goulet PS: For those of you who feel I'm Republican bashing, I'm not. I'd have VERY happily voted for McCain, even if that meant having Bush as a VP. Now where's that independent counsel when you need him!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Prompt in Korn shell
Alex,
I just substituted a real CR for the \n and got the two line prompt you
are looking for.
Mike Hand
Polaroid Corp.
-Original Message-
Sent: Thursday, June 21, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Now I have another problem.
export PS1='$LOGNAME@$HOST:$PWD:${ORACLE_SID:-ORUNDEF}\n!-' - result is:
oracle8i@coin-app:/u01/app/psoft/PSTEST/appserv:PSTESTn133-
instead of
oracle8i@coin-app:/u01/app/psoft/PSTEST/appserv:PSTEST
133-
Looks like it does not understand \n as a new line character.
Any ideas please.
Alex Hillman
-Original Message-
Sent: Wednesday, June 20, 2001 4:26 PM
To: Multiple recipients of list ORACLE-L
Anybody knows how to show current working directory and in general shell
variable in Korn shell that prompt change when variable changes - for
current working directory and ORACLE_SID for example. I know how to do it in
bash but cannot do it right in Korn.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hand, Michael T
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OT: Working from home
Number of pages has absolutely no bearring on a good book. Does the number of pages have a bearing on how well the database is administered?? ;) Hey, it's Friday and I always say Weak humor is better than no humor at all. Mike If I wasn't laughing, I'd be crying Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor statistics request
Ross, Around 500 users, uptime 26days; OLTP system NAME minavgvar max --- -- -- opened cursors cumulative 0 10611282 1107346 opened cursors current 0161 11 250 -Original Message- SNIP When I run this on my troubled system, I get: NAME minavgvar max --- -- -- - opened cursors cumulative 0 46325561 3748748 opened cursors current 0 54 9 345 And this for a instance only up for about a week. Oh, speaking of which, please tell me how long your instance has been up, and a rough idea of average user load, during the core processing hours. Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RESOURCE role
Listers, 8.0.6 What privilege granted to the RESOURCE role allows a grantee to create a table in any tablespace? I didn't see any relevent system privilege in the view DBA_SYS_PRIVS nor in the various other view. Am I looking in the wrong place? Thanks, Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backup for VLDB
We have a ~500Gb database on Compaq/Alpha HW and we use the multiple-mirror break technique with a couple of varients. 1) We leave the database up but put all of the tablespaces in backup mode for the mirror break. The mirror set is then mounted on our failover system for the write to tape which takes ~4 hours. 2) We use two backup mirror sets, alternating so that one mirror set is always ready for a recovery from disk. This recovery technique proves itself daily as we have an additional mirror set which we break, mount, and recover to act as a reporting instance. Mike Hand Polaroid Corp. -Original Message- Sent: Friday, April 06, 2001 6:26 AM To: Multiple recipients of list ORACLE-L The 'normal' way of operation I have seen is either Use a 3 way mirror, shut down the database, start up then shutdown normal, then split one mirror. The database can then be restarted (total outage less than 20 minutes) The backup then takes place against the 3rd mirror and is a cold backup and can be written to tape. The 3rd mirror is then synced or re-silvered at your convenience after the backup is complete (5 hours later?). One advantage of using this method is that the 3rd mirror is kept un-synced all day until just before the backup ( we used EMC BCVs) and then merged. Therefore there is a good copy of the database almost immediately available that only needs 1 day's set of archive log applying in the event of a recovery. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: . . .Compaq Tru64 5.1 Cluster / SAN?
Thanks for the heads up. We are also planning upgrades from 40F to 5.1 nonclustered with Oracle 8.0.6. Has anyone considered or implemented Compaq's SAN architecture? Mike Hand Polaroid Corp -Original Message- Sent: Wednesday, March 28, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Crontab
Unfortunately the previous suggestion would run every Sunday AND on each day on the 22nd to the 28th. Your 2 choices are MM HH 22-28 * * (shell script checks for Sunday before proceeding) OR MM HH * * 0 (shell script checks for day of month between 22 and 28 before proceeding) Mike -Original Message- crontab -e insert a line with Mi HH24 22-28 * 0 comandline - Hitarth -Original Message- I want to schedule a script to run on the fourth sunday of the month. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Canada Rules! / Chocolate ...
Kathe, I thought every red-blooded American knew what Smarties where. And since I have become the newest OCP (Other Confection Professional), I will enlighten you. Smarties are a "penny" candy, sour in taste about the size of an MM vended in plastic wrap of 12-15 in a stack. I think Crispy Crunch is similar to our Cracker Jacks, but I'll let some of our northern neighbors confirm that. More importantly what was this War of 1812 I keep hearing about ;) Mike -Original Message- Sent: Tuesday, March 20, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Well, group- I have completely enjoyed the discussion on Canada, especially since I make my first trip to Toronto this April. But can someone tell me what Smarties are? And Crispy Crunch/Coffee Crisp? Thanks- Kathe -- Kathe C. Newsome Centenary College of Louisiana Sr. Software Manager/Database Administrator Email : [EMAIL PROTECTED] Telephone : 318.869.5213 Fax : 318.869.5004 Cols. 1:9 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathe Newsome INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
