Re: Teradata baned from IOUG???
Yeah, and I was at OAUG in Honolulu when Oracle pulled all support two weeks before the event. And I've seen Oracle Denmark trying to make sure a certain presentation about RAC didn't go wrong (just Oracle Denmark, mind you :) ), and all sorts of other things. Bullying shouldn't pay, no matter what. And why on Earth not have products presented that might broaden people's minds? If the user group thinks it would be cool to have someone present SQL Server, why not? If the DBA's are interested, the user group has provided value for its members. A few centuries ago, some Danish mercenaries employed by one of the kings in Europe became very unpopular with the opposing king (I think it was the French). So the French king put out a decree stating that these Danish guys should be hanged whenever they were captured. The mercenaries reacted by wearing a white string around their neck - so as to provide the necessary rope to hang them by. That's the reason for the white piece of rope going from the bearskin hats and around the neck worn by the Danish Royal Guards (where I spent some time many years ago :) ). If you're afraid of the competition, and are too scared to face it, you have already lost the battle. And if you're a user group and you're scared of the vendor your user group is helping - what value are you then providing to your members in the long run? You might be helping yourself, though, by becoming a well-known name because you're on the board of IOUG or OUG/DK or whatever. I co-founded the Danish user group back in '87, and I'm on the board again after leaving Oracle. We've seen Oracle react this way or that way, but in the end Oracle cannot live without the user groups - because they don't want to see it evolve into something different, and because users helping each other are good ambassadors for Oracle's products. The user groups can easily live without Oracle, but Oracle cannot live without the user groups. Think about it. And the rather funny attempt at replacing IOUG and OAUG and EOUG with the Oracle World official marketing stuff of course doesn't work in the long run. Nice try, though. Mogens MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. IOUG may cause the rare stink, but it always does as Oracle instructs. Michael Corey, erstwhile IOUG president, was going to force Oracle to change the date of its first OOW in the U.S. as it was scheduled at the same time as the IOUW. The latter had been scheduled for well over a year. The groundwork had not even started for OOW, but guess which one was moved. Teradata would not be the first product banned. Way back in olden-times the maker of SQR were banned, but I cannot remember why. The idea of the exhibit hall is for vendors to provide information on their products in respect to Oracle. Now a company wants to use the forum to convince people to stop using Oracle, or so Oracle apparently dreads. But, who goes to the conferences? Mainly DBA's and developers who have such a stake in Oracle that even if Teradata did everything that Oracle did, made breakfast, and washed the dishes, they would not recommend it. Oracle is risking bad public relations over nothing. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 12, 2003 4:34 PM To: Multiple recipients of list ORACLE-L I'm sorry but I thought that IOUG was independant from Oracle? If Larry is afraid of a little competition then perhaps he should get out of the market. If not then he should battle it out in every venue possible and show why Oracle is better. If Rich and the guys do this they will be setting a dangerous precedant. -Original Message- Sent: Wednesday, February 12, 2003 2:59 PM To: Multiple recipients of list ORACLE-L DBA's Check the article's comment on Oracle trying to ban Teradata from IOUG Teradata Steals Oracle's Data Mart Users ... Teradata pushes consolidation and woos away Oracle customers. But Oracle strikes back. Sort of. Will bean counters surf the Web with Excel? Will Steve Ballmer and Larry Ellison become immortal? http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hotsos Symposium in Dallas
And lots of it. One of the guys taking care of the bull walked behind it with a snow shovel and a bucket - and used both, so nothing got spilled. Very professional. Jonathan Lewis wrote: Sounds like you're talking Bulls**t Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 13 February 2003 11:43 I'd be more worried about the bull being nervous :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Features of Oracle 8i Standard Versus Enterprise
Looks correct to me. TSPITR is indeed EE only, according to the pdf-document I have titled Oracle9i - a family of database products. I'll be happy to send it to anyone who asks - I cannot attach stuff on this list, I think. It's a very detailed 12-page document. There are no options - as far as I know - available to SE. The following are EE options according to the Oracle price list, which can be found at http://www.oracle.com/corporate/pricing/index.html?pricelists.html . The % is the price you should add to the EE price... RAC - 50% Partitioning - 25% OLAP - 50% Data Mining - 50% Spatial - 25% Advanced Security - 25% Row-level Security - 25% Diagnostics Pack, Tuning Pack, Change Management Pack and the SAP R/3 Management Pack are each $3,000 per CPU or $80 per Named User Plus. Mogens DENNIS WILLIAMS wrote: Stephen - I think your list is correct. Yes, I have heard that TSPITR is not included. I think that if you looked back to the old Oracle 7 TSPITR methods you could probably succeed, just would be more difficult. And of course you can do a full database point in time recovery in SE. Also, additional-pay features like partitioning require EE. The performance packs for OEM require EE, and maybe OEM itself requires EE, but someone else on the list can clarify that. The criteria I heard was that Oracle wanted to keep the same features for programs so that any program written for EE would still run on SE. Of course I assume that features that MS SQL doesn't have were prime candidates for EE, but maybe that is just my cynical nature. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hi everyone: Need some help validating features in Standard versus Enterprise. Here is the List: 1. Online Index Build 2. Plan Stability 3. Materialized 4. Bitmap Indexes 5. Point-in-time tablespace recovery 6. Oracle Diagnostics Pack/Tuning Pack 7. Oracle Connection Manager From the Oracle8i Family document, these are listed as E/E options. I would have thought that PIT Tablespace recovery was a standard option. Please reply soon as some contracts depend on the answer. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Teradata baned from IOUG???
It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to make sql prompt like USER@DATABASE ?
hi how to make sql prompt like USER@DATABASE ? where USER: connected user DATABASE:database global name, or database local alias Regards,Salaheldin Aboali---Senior Software Developer Management Information Systemshttp://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65
Re: Upgrading Target Database in RMAN
without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to make sql prompt like USER@DATABASE ?
You can add following lines to your glogin.sql ($ORACLE_HOME/sqlplus/admin directory) file. set heading off set term off set feedback off spool myprompt.sql select 'set sqlprompt ' || SYS_CONTEXT ('USERENV', 'session_user') || '@' || SYS_CONTEXT ('USERENV', 'DB_NAME') || '' from dual / spool off @myprompt.sql set heading on set term on set feedback on Alternatively you can create a file with above lines, put that file in bin and call it anytime to make your prompt Cheers, Rajesh Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Salaheldin Aboali Sent: Saturday, February 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: how to make sql prompt like USER@DATABASE ? hi how to make sql prompt like USER@DATABASE ? where USER: connected user DATABASE:database global name, or database local alias Regards, Salaheldin Aboali --- Senior Software Developer Management Information Systems http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65
Re: Optimizer help, get query to run as good as with RULE hint
Did you check swap/paging activity when sort_area_size was at 5m? Gaining performance on sorts by reducing the amount of memory used sounds like your box is low on RAM. Jared On Friday 14 February 2003 08:44, Glenn Travis wrote: I changed my sort_area_size to 1M (down from 5M) and the query completed in 18 seconds. We had set sort_area_size to 5M at the suggestion of Oracle or other reasons. Looks like it's time to set it back. I ran the disk_sorts query and it returned this: DISK_SORTS AVERAGE_SIZE PEAK_CONCURRENT -- --- 47073 23815K 826 Doesn't this suggest setting sort_area_size larger? -Original Message- From: Glenn Travis Sent: Friday, February 14, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Optimizer help, get query to run as good as with RULE hint I have a problem query which will not complete. This query is part of a report run within Oracle Applications. Our versions are: Oracle Server 8.1.7.4, Apps 11.5.3, HP-UX 11.11 Listed below is the query and the explain plan. I ran full statistics on all the tables immediately before executing the query. Using the CBO, it never returns. I cancel the query, but it won't die until I kill the unix process. If I use the /*+ RULE */ hint, the query plan (also listed below) changes dramatically and the query executes in 30 seconds. What could cause the optimizer to behave so differently? We cannot change our instance to RBO, as it would adversely affect everything else and Apps requires CBO anyway. Any suggestions on what else I could do to improve the explain plan withou having to use the hint? (I've tried setting optimizer_index_cost_adj=10, and it changes the plan a little but still does not complete). 1 SELECT COUNT(*) 2 FROM HZ_CUST_ACCT_SITES ACCT_SITE,HZ_PARTY_SITES PARTY_SITE, 3 HZ_LOCATIONS LOC,HZ_LOC_ASSIGNMENTS LOC_ASSIGN 4 WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID 5 AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID 6 AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID 7 AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99) 8* ; Id Par Pos Ins Plan - -- 0 3218SELECT STATEMENT (choose) Cost,rows,bytes (3218,1,31) 10 1 SORT(aggregate) 21 1NESTED LOOPS Cost,rows,bytes (3218,1466,45446) 32 1 HASH JOIN Cost,rows,bytes (3218,617422807,16052992982) 43 1HASH JOIN Cost,rows,bytes (2681,4307,77526) 54 15 TABLE ACCESS (analyzed) AR HZ_CUST_ACCT_SITES_ALL (full) Cost,rows,bytes (1263,4307,34456) 64 22 TABLE ACCESS (analyzed) AR HZ_PARTY_SITES (full) Cost,rows,bytes (1414,493760,4937600) 73 24 TABLE ACCESS (analyzed) AR HZ_LOC_ASSIGNMENTS (full) Cost,rows,bytes (533,430060,3440480) 82 2 INDEX (analyzed) UNIQUE AR HZ_LOCATIONS_U1 (unique scan) Using the RULE hint (completes in 30 seconds): 1 SELECT /*+ RULE */ COUNT(*) 2 FROM HZ_CUST_ACCT_SITES ACCT_SITE,HZ_PARTY_SITES PARTY_SITE, 3 HZ_LOCATIONS LOC,HZ_LOC_ASSIGNMENTS LOC_ASSIGN 4 WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID 5 AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID 6 AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID 7 AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99) 8* ; Id Par Pos Ins Plan - -- 0 SELECT STATEMENT (hint: rule) 10 1 SORT(aggregate) 21 1NESTED LOOPS 32 1 NESTED LOOPS 43 1NESTED LOOPS 54 14 TABLE ACCESS (analyzed) AR HZ_LOC_ASSIGNMENTS (full) 64 2 INDEX (analyzed) UNIQUE AR HZ_LOCATIONS_U1 (unique scan) 73 22 TABLE ACCESS (analyzed) AR HZ_PARTY_SITES (by index rowid) 87 1 INDEX (analyzed) NON-UNIQUE AR HZ_PARTY_SITES_N2 (range scan) 92 25 TABLE ACCESS (analyzed) AR HZ_CUST_ACCT_SITES_ALL (by index rowid) 109 1INDEX (analyzed) NON-UNIQUE AR HZ_CUST_ACCT_SITES_N1 (range scan) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
Re: Upgrading Target Database in RMAN
Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Oracle events - #s names
From V9.2.0 ORA-1: controlfile debug event, name 'control_file' ORA-10001: controlfile crash event1 ORA-10002: controlfile crash event2 ORA-10003: controlfile crash event3 ORA-10004: controlfile crash event4 ORA-10005: trace latch operations for debugging ORA-10006: testing - block recovery forced ORA-10007: log switch debug crash after new log select, thread ORA-10008: log switch debug crash after new log header write, thread ORA-10009: log switch debug crash after old log header write, thread ORA-10010: Begin Transaction ORA-10011: End Transaction ORA-10012: Abort Transaction ORA-10013: Instance Recovery ORA-10014: Roll Back to Save Point ORA-10015: Undo Segment Recovery ORA-10016: Undo Segment extend ORA-10017: Undo Segment Wrap ORA-10018: Data Segment Create ORA-10019: Data Segment Recovery ORA-10020: partial link restored to linked list (KSG) ORA-10021: latch cleanup for state objects (KSS) ORA-10022: trace ktsgsp ORA-10023: Create Save Undo Segment ORA-10024: Write to Save Undo ORA-10025: Extend Save Undo Segment ORA-10026: Apply Save Undo ORA-10027: latch cleanup for enqueue locks (KSQ) ORA-10028: latch cleanup for enqueue resources (KSQ) ORA-10029: session logon (KSU) ORA-10030: session logoff (KSU) ORA-10031: sort debug event (S*) ORA-10032: sort statistics (SOR*) ORA-10033: sort run information (SRD*/SRS*) ORA-10035: parse SQL statement (OPIPRS) ORA-10036: create remote row source (QKANET) ORA-10037: allocate remote row source (QKARWS) ORA-10038: dump row source tree (QBADRV) ORA-10039: type checking (OPITCA) ORA-10040: dirty cache list ORA-10041: dump undo records skipped ORA-10042: trap error during undo application ORA-10043: check consistency of owner/waiter/converter lists in KSQ ORA-10044: free list undo operations ORA-10045: free list update operations - ktsrsp, ktsunl ORA-10046: enable SQL statement timing ORA-10047: trace switching of sessions ORA-10048: Undo segment shrink ORA-10049: protect library cache memory heaps ORA-10050: sniper trace ORA-10051: trace OPI calls ORA-10052: don't clean up obj$ ORA-10053: CBO Enable optimizer trace ORA-10054: trace UNDO handling in MLS ORA-10055: trace UNDO handing ORA-10056: dump analyze stats (kdg) ORA-10057: suppress file names in error messages ORA-10058: use table scan cost in tab$.spare1 ORA-10059: simulate error in logfile create/clear ORA-10060: CBO Enable predicate dump ORA-10061: disable SMON from cleaning temp segment ORA-10062: disable usage of OS Roles in osds ORA-10063: disable usage of DBA and OPER privileges in osds ORA-10064: thread enable debug crash level , thread ORA-10065: limit library cache dump information for state object dump ORA-10066: simulate failure to verify file ORA-10067: force redo log checksum errors - block number ORA-10068: force redo log checksum errors - file number ORA-10069: Trusted Oracle test event ORA-10070: force datafile checksum errors - block number ORA-10071: force datafile checksum errors - file number ORA-10072: protect latch recovery memory ORA-10073: have PMON dump info before latch cleanup ORA-10074: default trace function mask for kst ORA-10075: CBO Disable outer-join to regular join conversion ORA-10076: CBO Enable cartesian product join costing ORA-10077: CBO Disable view-merging optimization for outer-joins ORA-10078: CBO Disable constant predicate elimination optimization ORA-10079: trace data sent/received via SQL*Net ORA-10080: dump a block on a segment list which cannot be exchanged ORA-10081: segment High Water Mark has been advanced ORA-10082: free list head block is the same as the last block ORA-10083: a brand new block has been requested from space management ORA-10084: free list becomes empty ORA-10085: free lists have been merged ORA-10086: CBO Enable error if kko and qka disagree on oby sort ORA-10087: disable repair of media corrupt data blocks ORA-10088: CBO Disable new NOT IN optimization ORA-10089: CBO Disable index sorting ORA-10090: invoke other events before crash recovery ORA-10091: CBO Disable constant predicate merging ORA-10092: CBO Disable hash join ORA-10093: CBO Enable force hash joins ORA-10094: before resizing a data file ORA-10095: dump debugger commands to trace file ORA-10096: after the cross instance call when resizing a data file ORA-10097: after generating redo when resizing a data file ORA-10098: after the OS has increased the size of a data file ORA-10099: after updating the file header with the new file size ORA-10100: after the OS has decreased the size of a data file ORA-10101: atomic redo write recovery ORA-10102: switch off anti-joins ORA-10103: CBO Disable hash join swapping ORA-10104: dump hash join statistics to trace file ORA-10105: CBO Enable constant pred trans and MPs w WHERE-clause ORA-10106: CBO Disable evaluating correlation pred last for NOT IN ORA-10107: CBO Always use bitmap index ORA-10108: CBO Don't use bitmap index ORA-10109: CBO Disable move of negated predicates ORA-10110: CBO Try index rowid range scans ORA-10111: Bitmap
RE: Optimizer help, get query to run as good as with RULE hint
I've gathered statistics many different ways to get queries against the trading partner tables (i.e., HZ) to do something better to or equal a rule hint, and in the end a sort area of 1M or less and leaving hash_area_size unset (defaults to 2mb or less) works best. With hash_area_size 2Mb, hash joins on every table in the query fall out of favor w/ CBO, and in the case of the HZ tables on 11.5.x, NL joins seem to outperform Hash joins. Incidentally, in 11.5.7 and higher, many of the trading partner views seem better optimized. With 11.5.5 and lower, we've had to customize to get things working well. -Original Message- Still Sent: Saturday, February 15, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Did you check swap/paging activity when sort_area_size was at 5m? Gaining performance on sorts by reducing the amount of memory used sounds like your box is low on RAM. Jared On Friday 14 February 2003 08:44, Glenn Travis wrote: I changed my sort_area_size to 1M (down from 5M) and the query completed in 18 seconds. We had set sort_area_size to 5M at the suggestion of Oracle or other reasons. Looks like it's time to set it back. I ran the disk_sorts query and it returned this: DISK_SORTS AVERAGE_SIZE PEAK_CONCURRENT -- --- 47073 23815K 826 Doesn't this suggest setting sort_area_size larger? -Original Message- From: Glenn Travis Sent: Friday, February 14, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Optimizer help, get query to run as good as with RULE hint I have a problem query which will not complete. This query is part of a report run within Oracle Applications. Our versions are: Oracle Server 8.1.7.4, Apps 11.5.3, HP-UX 11.11 Listed below is the query and the explain plan. I ran full statistics on all the tables immediately before executing the query. Using the CBO, it never returns. I cancel the query, but it won't die until I kill the unix process. If I use the /*+ RULE */ hint, the query plan (also listed below) changes dramatically and the query executes in 30 seconds. What could cause the optimizer to behave so differently? We cannot change our instance to RBO, as it would adversely affect everything else and Apps requires CBO anyway. Any suggestions on what else I could do to improve the explain plan withou having to use the hint? (I've tried setting optimizer_index_cost_adj=10, and it changes the plan a little but still does not complete). 1 SELECT COUNT(*) 2 FROM HZ_CUST_ACCT_SITES ACCT_SITE,HZ_PARTY_SITES PARTY_SITE, 3 HZ_LOCATIONS LOC,HZ_LOC_ASSIGNMENTS LOC_ASSIGN 4 WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID 5 AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID 6 AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID 7 AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99) 8* ; Id Par Pos Ins Plan - -- 0 3218SELECT STATEMENT (choose) Cost,rows,bytes (3218,1,31) 10 1 SORT(aggregate) 21 1NESTED LOOPS Cost,rows,bytes (3218,1466,45446) 32 1 HASH JOIN Cost,rows,bytes (3218,617422807,16052992982) 43 1HASH JOIN Cost,rows,bytes (2681,4307,77526) 54 15 TABLE ACCESS (analyzed) AR HZ_CUST_ACCT_SITES_ALL (full) Cost,rows,bytes (1263,4307,34456) 64 22 TABLE ACCESS (analyzed) AR HZ_PARTY_SITES (full) Cost,rows,bytes (1414,493760,4937600) 73 24 TABLE ACCESS (analyzed) AR HZ_LOC_ASSIGNMENTS (full) Cost,rows,bytes (533,430060,3440480) 82 2 INDEX (analyzed) UNIQUE AR HZ_LOCATIONS_U1 (unique scan) Using the RULE hint (completes in 30 seconds): 1 SELECT /*+ RULE */ COUNT(*) 2 FROM HZ_CUST_ACCT_SITES ACCT_SITE,HZ_PARTY_SITES PARTY_SITE, 3 HZ_LOCATIONS LOC,HZ_LOC_ASSIGNMENTS LOC_ASSIGN 4 WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID 5 AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID 6 AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID 7 AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99) 8* ; Id Par Pos Ins Plan - -- 0 SELECT STATEMENT (hint: rule) 10 1 SORT(aggregate) 21 1NESTED LOOPS 32 1 NESTED LOOPS 43 1NESTED LOOPS 54 14 TABLE ACCESS (analyzed) AR HZ_LOC_ASSIGNMENTS (full) 64 2
RE: {SPAM?} RE: Teradata baned from IOUG???
Another advantage of SQR is multi-platform. We used to run SQR/MVS against DB2, now run it on Unix against Oracle and of course the SQR for Windows product against Oracle. It was simple to port our SQR code from DB2/MVS to Oracle. Now it might be tougher as we use a lot of Oracle specific stuff in our queries which makes it harder to port. But SQR is a decent product. We use it with PeopleSoft but another part of our business (Investment division) also uses the product for their systems. I wish I had it available for use with one of our finance systems. Having to program in PL/SQL. That's a real drag when it comes to doing file i/o for logs/reports. From: Jamadagni, Rajendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: {SPAM?} RE: Teradata baned from IOUG??? Date: Fri, 14 Feb 2003 07:29:29 -0800 Well, I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on incoming raw data. I wouldn't discount SQR right away, but after all it is almost glorified COBOL (IMHO). Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup tables and breaks make life simpler as well. It has usable array interface ... for data processing. We have couple of SQR reports that run in about 4000 lines of code (don't ask me why) My $0.01 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 14, 2003 10:09 AM To: Multiple recipients of list ORACLE-L We looked at SQR in 94. We didn't have need of controlling fonts and such, which I guess SQR is good at. The SQR rep could come up with no compelling reason to use SQR rather than Perl, so simple ( as in not much procedural processing needed ) reports were done in Sqlplus. Anything complex was done in Perl. We never regretted that decision. Jared ESPN_Disclaimer.txt _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 8i or 9i ?
Les, Something to consider on which to choose is the market pentration for 9i implementations. I work for a large insurance company which has zero 9i implementations. In fact as far as I know the key system I work on will probably be the first one (Oracle 7.3.4 - 9i) going in Q3/Q4. Most of our systems are 8 with some on 8i. Clients are funny in not wanting to part with money to perform database upgrades. If they don't see any benefit from it. On that basis, you might want to consider at least learning something about 8i as it would be very likely you would run into a client that is using it. Though going the 8i classes then upgrading to 9i does feel like a lot of work. Something I hate. :-) David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Fri, 14 Feb 2003 15:53:46 -0800 Thanks, that got me happy since I do have a couple years of windows experience ;) So now, i have 1 vote for oracle 8i and one for 9i. Any other opinions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:54 PM Les - Oh you wanted the hard questions answered as well. Given that you mentioned you were a MS sys admin, I'd say that would give you a leg up. A lot of shops have combined DBA/Sys admins for MS. That might be your easiest transition. I hate to say this, especially on this list, but you may want to look at adding MS SQL certification just to give you more options, like the target employer might have Oracle and MS SQL. Depending on your salary demands, your chances of getting on as a newbie DBA are probably okay. A lot depends on your networking ability, good resume, no criminal record that can be easily traced ;-), good personal hygiene, charm in interviews, persistence, and just plain luck. The ecommerce side has had a real dose of reality in the last couple of years, but is still there. Consider just getting some Oracle experience and then moving over to ecommerce. Most companies still have some type of ecommerce area. Otherwise, in your spare time, learn everything you can about ecommerce from the marketing drivel down to HTML. These are obviously not well-informed opinions, but worth every penny you paid ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Thanks for the replies guys, I really appreciate it. Can i get some input on these 2 questions: What chances am I looking at to getting hired as a newbie DBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!! THANKS, I'M STARTING TO LIKE THIS LIST ALREADY! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:35 PM Les - Here is an idea for you. Think up a trivial application for a database. Maybe your home albums or DVDs. Try to make it a little relational, like have an artist table. Force yourself to work with it. At the right time I was secretary of a bowling league, so each year I rewrote a league management program in a different language, whatever I needed to learn. I went through Oracle, COBOL, Perl, C, all in different years. The point is that by playing user you get a good feel for why the heck somebody would use a database to begin with. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:00 PM To: Multiple recipients of list ORACLE-L I'm more of a windoz SA and have been working with a little Unix here there for hte past 2yrs (RH, Mandrake, Solaris). What I really want to accomplish is to switch to Unix and Databases. My goal is to use my certifcation as a way to get my foot in the door of the DB world and after a couple of years, do some consulting. I downloaded oracle 9i for Solaris and have yet to install it because I wanted to read up on Oracle 1st. Will install it this weekend ;) I want to work with DBs because I think it's always going to be about managing information and the need is never going to die. I don't know of any midsize companies who would survive w/o some type of DB and after being laid off twice, I'm reconsidering going into a different IT career. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Friday, February 14, 2003 8:34 AM The $3000 is true if he takes them through 'oracle' university but not if the local community college offers the classes. What I did (and it seemed to work fine) for my
Re: RMAN BCV/Flashcopy Question?
Gene, The "Oracle9i RMAN User's Guide" provides instructions on this on page 9-18. I don't think that the steps mentioning ALTER SYSTEM SUSPEND/RESUME and ALTER TABLESPACE BEGIN/END BACKUP are necessary if IBM Flashcopy can support splits of non-quiesced volumes (ask your AIX SA). If it can, then only the steps involving CATALOG DATAFILECOPY and BACKUP/COPY DATAFILECOPY are relevant... Hope this helps... -Tim - Original Message - From: Gene Sais To: Multiple recipients of list ORACLE-L Sent: Friday, February 14, 2003 8:59 AM Subject: RMAN BCV/Flashcopy Question? I plan on using a product from IBM called Flashcopy, similar to EMC's BCV (third mirror). Typically, I put the tablespaces in hot backup via scripting before splitting the third mirror. How can RMAN be used in a similar fashion? Can RMAN put the db in a hot backup state so the third mirror can be split and then backed up to tape? Thanks, Gene
Re: Upgrading Target Database in RMAN
How about running in NOCATALOG mode for a while? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 11:38 AM Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i or 9i ?
Is 9i a lot more difficult to learn than 8i? Can i use what I learned on 8i on 9i? --pachanga - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 2:43 PM Les, Something to consider on which to choose is the market pentration for 9i implementations. I work for a large insurance company which has zero 9i implementations. In fact as far as I know the key system I work on will probably be the first one (Oracle 7.3.4 - 9i) going in Q3/Q4. Most of our systems are 8 with some on 8i. Clients are funny in not wanting to part with money to perform database upgrades. If they don't see any benefit from it. On that basis, you might want to consider at least learning something about 8i as it would be very likely you would run into a client that is using it. Though going the 8i classes then upgrading to 9i does feel like a lot of work. Something I hate. :-) David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Fri, 14 Feb 2003 15:53:46 -0800 Thanks, that got me happy since I do have a couple years of windows experience ;) So now, i have 1 vote for oracle 8i and one for 9i. Any other opinions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:54 PM Les - Oh you wanted the hard questions answered as well. Given that you mentioned you were a MS sys admin, I'd say that would give you a leg up. A lot of shops have combined DBA/Sys admins for MS. That might be your easiest transition. I hate to say this, especially on this list, but you may want to look at adding MS SQL certification just to give you more options, like the target employer might have Oracle and MS SQL. Depending on your salary demands, your chances of getting on as a newbie DBA are probably okay. A lot depends on your networking ability, good resume, no criminal record that can be easily traced ;-), good personal hygiene, charm in interviews, persistence, and just plain luck. The ecommerce side has had a real dose of reality in the last couple of years, but is still there. Consider just getting some Oracle experience and then moving over to ecommerce. Most companies still have some type of ecommerce area. Otherwise, in your spare time, learn everything you can about ecommerce from the marketing drivel down to HTML. These are obviously not well-informed opinions, but worth every penny you paid ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Thanks for the replies guys, I really appreciate it. Can i get some input on these 2 questions: What chances am I looking at to getting hired as a newbie DBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!! THANKS, I'M STARTING TO LIKE THIS LIST ALREADY! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:35 PM Les - Here is an idea for you. Think up a trivial application for a database. Maybe your home albums or DVDs. Try to make it a little relational, like have an artist table. Force yourself to work with it. At the right time I was secretary of a bowling league, so each year I rewrote a league management program in a different language, whatever I needed to learn. I went through Oracle, COBOL, Perl, C, all in different years. The point is that by playing user you get a good feel for why the heck somebody would use a database to begin with. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:00 PM To: Multiple recipients of list ORACLE-L I'm more of a windoz SA and have been working with a little Unix here there for hte past 2yrs (RH, Mandrake, Solaris). What I really want to accomplish is to switch to Unix and Databases. My goal is to use my certifcation as a way to get my foot in the door of the DB world and after a couple of years, do some consulting. I downloaded oracle 9i for Solaris and have yet to install it because I wanted to read up on Oracle 1st. Will install it this weekend ;) I want to work with DBs because I think it's always going to be about managing information and the need is never going to die. I don't know of any midsize companies who would survive w/o
Know 1 database, know them all?
I overheard one guy mention that once you learn one database, you know them all. Is this true? Or was he just talking about the theory behind the db? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Target Database in RMAN
Yeah, I guess that's an option also. Still seems like a workaround though. Jared On Saturday 15 February 2003 15:18, Tim Gorman wrote: How about running in NOCATALOG mode for a while? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 11:38 AM Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: {SPAM?} RE: Teradata baned from IOUG???
Try Perl. It's magnitudes better than PL/SQL for files and logs. Jared On Saturday 15 February 2003 14:23, david davis wrote: Another advantage of SQR is multi-platform. We used to run SQR/MVS against DB2, now run it on Unix against Oracle and of course the SQR for Windows product against Oracle. It was simple to port our SQR code from DB2/MVS to Oracle. Now it might be tougher as we use a lot of Oracle specific stuff in our queries which makes it harder to port. But SQR is a decent product. We use it with PeopleSoft but another part of our business (Investment division) also uses the product for their systems. I wish I had it available for use with one of our finance systems. Having to program in PL/SQL. That's a real drag when it comes to doing file i/o for logs/reports. From: Jamadagni, Rajendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: {SPAM?} RE: Teradata baned from IOUG??? Date: Fri, 14 Feb 2003 07:29:29 -0800 Well, I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on incoming raw data. I wouldn't discount SQR right away, but after all it is almost glorified COBOL (IMHO). Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup tables and breaks make life simpler as well. It has usable array interface ... for data processing. We have couple of SQR reports that run in about 4000 lines of code (don't ask me why) My $0.01 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 14, 2003 10:09 AM To: Multiple recipients of list ORACLE-L We looked at SQR in 94. We didn't have need of controlling fonts and such, which I guess SQR is good at. The SQR rep could come up with no compelling reason to use SQR rather than Perl, so simple ( as in not much procedural processing needed ) reports were done in Sqlplus. Anything complex was done in Perl. We never regretted that decision. Jared ESPN_Disclaimer.txt _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- 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).
Re: Upgrading Target Database in RMAN
A workaround that avoids the problem altogether with no loss of functionality and no loss of data seems more like a solution. :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 7:48 PM Yeah, I guess that's an option also. Still seems like a workaround though. Jared On Saturday 15 February 2003 15:18, Tim Gorman wrote: How about running in NOCATALOG mode for a while? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 11:38 AM Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
Re: Oracle 8i or 9i ?
If its just the basic's I think 9i is actually easier than the older versions. For example using Undo Management instead of trying to learn the use of Rollback segments. Of course with Oracle (like most vendors) you can get bogged down when the kitchen sink has been tossed at you on the install CD's. It can seem overwhelming. From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Sat, 15 Feb 2003 17:33:39 -0800 Is 9i a lot more difficult to learn than 8i? Can i use what I learned on 8i on 9i? --pachanga - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 2:43 PM Les, Something to consider on which to choose is the market pentration for 9i implementations. I work for a large insurance company which has zero 9i implementations. In fact as far as I know the key system I work on will probably be the first one (Oracle 7.3.4 - 9i) going in Q3/Q4. Most of our systems are 8 with some on 8i. Clients are funny in not wanting to part with money to perform database upgrades. If they don't see any benefit from it. On that basis, you might want to consider at least learning something about 8i as it would be very likely you would run into a client that is using it. Though going the 8i classes then upgrading to 9i does feel like a lot of work. Something I hate. :-) David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Fri, 14 Feb 2003 15:53:46 -0800 Thanks, that got me happy since I do have a couple years of windows experience ;) So now, i have 1 vote for oracle 8i and one for 9i. Any other opinions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:54 PM Les - Oh you wanted the hard questions answered as well. Given that you mentioned you were a MS sys admin, I'd say that would give you a leg up. A lot of shops have combined DBA/Sys admins for MS. That might be your easiest transition. I hate to say this, especially on this list, but you may want to look at adding MS SQL certification just to give you more options, like the target employer might have Oracle and MS SQL. Depending on your salary demands, your chances of getting on as a newbie DBA are probably okay. A lot depends on your networking ability, good resume, no criminal record that can be easily traced ;-), good personal hygiene, charm in interviews, persistence, and just plain luck. The ecommerce side has had a real dose of reality in the last couple of years, but is still there. Consider just getting some Oracle experience and then moving over to ecommerce. Most companies still have some type of ecommerce area. Otherwise, in your spare time, learn everything you can about ecommerce from the marketing drivel down to HTML. These are obviously not well-informed opinions, but worth every penny you paid ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Thanks for the replies guys, I really appreciate it. Can i get some input on these 2 questions: What chances am I looking at to getting hired as a newbie DBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!! THANKS, I'M STARTING TO LIKE THIS LIST ALREADY! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:35 PM Les - Here is an idea for you. Think up a trivial application for a database. Maybe your home albums or DVDs. Try to make it a little relational, like have an artist table. Force yourself to work with it. At the right time I was secretary of a bowling league, so each year I rewrote a league management program in a different language, whatever I needed to learn. I went through Oracle, COBOL, Perl, C, all in different years. The point is that by playing user you get a good feel for why the heck somebody would use a database to begin with. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:00 PM To: Multiple recipients of list ORACLE-L I'm more of a windoz SA and have been working with a little Unix here there for hte past 2yrs (RH, Mandrake, Solaris). What I really want to accomplish is to
Re: {SPAM?} RE: Teradata baned from IOUG???
Good Advice. But Alas, I have not yet had the time to learn Perl. Though I have all the material to learn it. Including a interesting little book Perl for Oracle DBAs. One of these days I will stop treading water and starting swimming for shore. From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED], david davis [EMAIL PROTECTED] Subject: Re: {SPAM?} RE: Teradata baned from IOUG??? Date: Sat, 15 Feb 2003 18:50:05 -0800 Try Perl. It's magnitudes better than PL/SQL for files and logs. Jared On Saturday 15 February 2003 14:23, david davis wrote: Another advantage of SQR is multi-platform. We used to run SQR/MVS against DB2, now run it on Unix against Oracle and of course the SQR for Windows product against Oracle. It was simple to port our SQR code from DB2/MVS to Oracle. Now it might be tougher as we use a lot of Oracle specific stuff in our queries which makes it harder to port. But SQR is a decent product. We use it with PeopleSoft but another part of our business (Investment division) also uses the product for their systems. I wish I had it available for use with one of our finance systems. Having to program in PL/SQL. That's a real drag when it comes to doing file i/o for logs/reports. From: Jamadagni, Rajendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: {SPAM?} RE: Teradata baned from IOUG??? Date: Fri, 14 Feb 2003 07:29:29 -0800 Well, I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on incoming raw data. I wouldn't discount SQR right away, but after all it is almost glorified COBOL (IMHO). Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup tables and breaks make life simpler as well. It has usable array interface ... for data processing. We have couple of SQR reports that run in about 4000 lines of code (don't ask me why) My $0.01 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 14, 2003 10:09 AM To: Multiple recipients of list ORACLE-L We looked at SQR in 94. We didn't have need of controlling fonts and such, which I guess SQR is good at. The SQR rep could come up with no compelling reason to use SQR rather than Perl, so simple ( as in not much procedural processing needed ) reports were done in Sqlplus. Anything complex was done in Perl. We never regretted that decision. Jared ESPN_Disclaimer.txt _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Know 1 database, know them all?
Must have been basic theory or perhaps they were referring to ANSI SQL which we all use. You will find substantial differences between UDB, DB2/MVS, Oracle and SQL Server and all the others. I have worked at one time or another with the above mentioned and moving from one to another was fairly easy as a developer but for a DBA it was more complicated due to architecture differences in implementation. Of course, maybe I am just a slow learner. btw This guy was he the same one that said in a couple of years programmers won't be needed anymore or perhaps that 640K is all that you will ever need. David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Know 1 database, know them all? Date: Sat, 15 Feb 2003 17:38:38 -0800 I overheard one guy mention that once you learn one database, you know them all. Is this true? Or was he just talking about the theory behind the db? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
os authentication
Hi DBA's Can somebody clarify the flwng: DB: 9.x OS: solaris 2.8 1. To setup OS authentication we need to grant either OSDBA or OSOPER to OS account( OS oracle a/c)? so that we can connect to DB as sqlplus / as sysdba and we dont require a password file for this. is this true ? or anything to be added this statement ? 2. If we are not using OS authentication , then we setup a password file (exclusive) and connect to database to do a startup, we issue sqlplus sys as sysdba passwd: My doubt is, whether the above entry (password: verifies the sys password ( if yes, from where it verifies ? ) I connected to DB successfully using sqlplus sys as sysdba without giving any password. (it also accepted anything like abc, xyz, 123 etc.,) I am not clear how this works ? Can somebody clarify the above. Thanks in advance, Srinivas __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Target Database in RMAN
I've done this ... now if I can just remember ... The repository version has to be at least as high as the database version. That much I know for sure. It's easy to do. I think you just execute the upgrade catalog command. If this condition is met, then you will find out real fast if you need to re-register the database when you run a backup. I don't recall needing to do this. But if you think about it, restoring a pre-upgrade backup would put you back to your old version of the database while your binaries are at the new version. H. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 15, 2003 8:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: Upgrading Target Database in RMAN Yeah, I guess that's an option also. Still seems like a workaround though. Jared On Saturday 15 February 2003 15:18, Tim Gorman wrote: How about running in NOCATALOG mode for a while? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 11:38 AM Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: 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:
Re: Upgrading Target Database in RMAN
Yeah, you're right. Still don't like it though. :) Jared On Saturday 15 February 2003 19:48, Tim Gorman wrote: A workaround that avoids the problem altogether with no loss of functionality and no loss of data seems more like a solution. :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 7:48 PM Yeah, I guess that's an option also. Still seems like a workaround though. Jared On Saturday 15 February 2003 15:18, Tim Gorman wrote: How about running in NOCATALOG mode for a while? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 11:38 AM Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: 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: 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
Re: Upgrading Target Database in RMAN
Thanks Stephen, but 'upgrade catalog' is used to upgrade the RMAN catalog when the repository database is upgraded. Jared On Saturday 15 February 2003 21:18, Stephen Lee wrote: I've done this ... now if I can just remember ... The repository version has to be at least as high as the database version. That much I know for sure. It's easy to do. I think you just execute the upgrade catalog command. If this condition is met, then you will find out real fast if you need to re-register the database when you run a backup. I don't recall needing to do this. But if you think about it, restoring a pre-upgrade backup would put you back to your old version of the database while your binaries are at the new version. H. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 15, 2003 8:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: Upgrading Target Database in RMAN Yeah, I guess that's an option also. Still seems like a workaround though. Jared On Saturday 15 February 2003 15:18, Tim Gorman wrote: How about running in NOCATALOG mode for a while? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 11:38 AM Yes, I've thought of doing that. It just makes it much harder to restore the old database from tape should the need arise. Maybe I'll export the repository and re-import it somewhere else for a few weeks safe keeping. Jared On Saturday 15 February 2003 03:38, Rachel Carmichael wrote: without knowing too much about RMAN, but from things I've gathered from the list can you unregister the current db (after a backup of course) and then register the new version once it's ready? --- [EMAIL PROTECTED] wrote: Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4 This database is currently being backed up via RMAN. It occurred to me a few minutes ago that I have no idea how to make RMAN aware of the new version of database. I'm relatively sure it will balk at seeing the database suddenly upgraded, without having received some sort of notification first. I've been checking MetaLink, Robert's book, and the docs, but have not yet determined how to care for this. Suggestions, advice and coffee gladly accepted. Pertinent platform info: Win2k Server SP 2 Oracle 8.1.6.3 EE - 8.1.7.4 target DB RMAN catalog on Win2k Server SP2 Oracle 8.1.7.4 Thanks, Jared -- 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: 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