RE: Oracle Warehouse Builder Tutorial
Title: RE: Oracle Warehouse Builder Tutorial Mark, Take a look at OTN (http://otn.oracle.com/products/warehouse/index.html). There is a little information there. Unfortunately, there isn't much documentation on OWB. The online help docs with the product were all I found last year. There was no huge Oracle doc like with their other products. I took the OWB class in D.C. last year at Oracle in Reston. If you could get your hands on the class books it would provide a great tutorial for you, but I don't know how you'd do that without taking the class :-). It's very much like Informatica in the sense that you use a GUI interface to create ETL procedures. It generates a TON of code behind the scenes, and that code can have errors, which you'll have to go in and manually troubleshoot. The GUI interface complicates the code debugging. I haven't worked with the software in a few months, but I sure hope they've improved it in recent releases. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Stahlke, Mark [mailto:[EMAIL PROTECTED]] Sent: Friday, January 09, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Warehouse Builder Tutorial Greetings, Does anyone know of a good, readable tutorial on Oracle Warehouse Builder? I've been searching Google and even looking for books on Amazon.com and there seems to be a dearth of info on this product out there. I successfully installed it (9.2.0.3 Linux) and built the repository, run time repository, and target schema but I don't know where to go from here. Thanks, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: encrypt back-up data
Title: RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: encrypt back-up data Has anybody ever heard of encrypting backup data through Oracle? I have never heard of Oracle being able to do this. I am being asked this question by the account manager: Do you know if Oracle has the capability to encrypt back-up data, and then use a reverse encryption process when restoring the data? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: partitioning option licensing
Title: RE: partitioning option licensing As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year, depending on your support level. You'll have to confirm the exact numbers with your sales rep. You can estimate about 22%, as I recall. We just increased our licensing a few months ago. Get the fastest processors you can. Anyone know how 10g will be licensed? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Patricia Zhu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 03, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: partitioning option licensing Hi, We're looking into migrating from SQL server to Oracle. Does anyone know if Partitioning option is still licensed separately? Thanks. pat _ Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6 months @ $9.95/month now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patricia Zhu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PostgreSQL 7.4 release
One new feature that is not listed in the 7.4 release is Point In Time Recovery, which will hopefully make it into the 7.5 release. According to the PostgreSQL lists, it's in the works. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 18, 2003 6:44 PMTo: Multiple recipients of list ORACLE-LSubject: PostgreSQL 7.4 releaseHere's the presskit, which gives a decent hi level overview. http://www.postgresql.org/presskit/en/presskit74.html
RE: Stop using SYS, SYSTEM?
Title: RE: Stop using SYS, SYSTEM? Jared, I followed Robert Freeman's advice and created an RMAN user in all my DBs called backup_admin with SYSDBA privilege so that RMAN doesn't use SYS or SYSTEM. This allows you to change system passwords at will and not interfere with backups. Works just fine. Is this what you were talking about? Perhaps I misunderstood. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Stop using SYS, SYSTEM? We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Overhead Associated with Signon Audit in Financials 11.0
Victoria, Check out Tom Kyte's new book- he encourages the use of auditing, especially Oracle's built-in auditing rather than home-grown. He provides a nice bench-mark test example to compare the performance of loading 30,000 rows into both cases and native auditing won. DIY auditing had a 27% decrease in transactions/second and 146% of the CPU time. Of course, you are asking about auditing vs. no auditing performance, but you could use Tom's approach to measure performance numbers. Also, there is at least one document I've seen on MetaLink about moving the audit table SYS.AUD$from the SYS schema to avoid contention/fragmentation. Check out Note 72460.1. Keeping your audit data in the DB, versus in OS text files, is recommended so that you can use DB reporting features and not have to write your own text parsing code- unless you enjoy that sort of thing:-). Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003 2:54 PMTo: Multiple recipients of list ORACLE-LSubject: Overhead Associated with Signon Audit in Financials 11.0Does anyone have any statistics about overhead associated with using the Signon Audit in an 11.0.3/ 8.1.7.4/8.0.6.3 environment. We are using full installs of AP, GL, FA and CE. Size of the production database is 100G. Can't tell you exactly what we'd be auditing; we are under siege by Internal Audit at the moment - they've raised the "database audit" flag, but have not started dictating what they want audited. I am trying to get some real-world statistics to arm myself with when the day comes . I have heard that the overhead is significant - is this true, in your experience? Vicki PierceDatabase Administrationx2401
Query Tuning Help
Title: Query Tuning Help I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows). SELECT a2.class_config_id, a1.schedule_name FROM class_config a2, class_schedule a1 WHERE a2.class_config_id = a1.class_config_id AND to_date(a2.file_dts, 'mmddyyhh24miss') SYSDATE - 35 I created a function-based index on FILE_DTS, like this: CREATE INDEX CLASS_CONFIG_FILE_DTS_FX_IDX ON CLASS_CONFIG to_date(file_dts, 'mmddyyhh24miss') and analyzed the table, but the explain plan still shows a FTS. I can change the query to something simpler and get it to use the new index, but I assume the calculation ( SYSDATE - 35) is causing the problem. Any suggestions? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
RE: Query Tuning Help
Title: Query Tuning Help Tom, Thanks for the init.ora parameter tips, I consulted the docs and did that first :-). It just seems that the CBO would rather use an index, even though I know that's not always the case. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: David Wagoner Sent: Monday, October 27, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Query Tuning Help I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows). SELECT a2.class_config_id, a1.schedule_name FROM class_config a2, class_schedule a1 WHERE a2.class_config_id = a1.class_config_id AND to_date(a2.file_dts, 'mmddyyhh24miss') SYSDATE - 35 I created a function-based index on FILE_DTS, like this: CREATE INDEX CLASS_CONFIG_FILE_DTS_FX_IDX ON CLASS_CONFIG to_date(file_dts, 'mmddyyhh24miss') and analyzed the table, but the explain plan still shows a FTS. I can change the query to something simpler and get it to use the new index, but I assume the calculation ( SYSDATE - 35) is causing the problem. Any suggestions? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you.
RE: Query Tuning Help
Title: Query Tuning Help The FILE_DTS column is VARCHAR2(12) NOT NULL and has data in the following format: 07220301. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Phone: 919-466-6723 Cell: 919-412-8462 Pager: [EMAIL PROTECTED] Fax: 919-466-6783 E-Mail: [EMAIL PROTECTED] Web: http://www.arsenaldigital.com "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: David Wagoner Sent: Monday, October 27, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Query Tuning Help I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows). SELECT a2.class_config_id, a1.schedule_name FROM class_config a2, class_schedule a1 WHERE a2.class_config_id = a1.class_config_id AND to_date(a2.file_dts, 'mmddyyhh24miss') SYSDATE - 35 I created a function-based index on FILE_DTS, like this: CREATE INDEX CLASS_CONFIG_FILE_DTS_FX_IDX ON CLASS_CONFIG to_date(file_dts, 'mmddyyhh24miss') and analyzed the table, but the explain plan still shows a FTS. I can change the query to something simpler and get it to use the new index, but I assume the calculation ( SYSDATE - 35) is causing the problem. Any suggestions? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you.
RE: Query Tuning Help
Title: RE: Query Tuning Help Mladen, Thanks for your response. Comments are in-line. Do you have query rewrite privilege? Yes. What is the query_reqrite_inegrity set to? TRUSTED. How about optimizer parameters (optimizer_index_caching,optimizer_index_cost_adj)? optimizer_index_caching=0 Are these reasonable values? optimizer_index_cost_adj=100 Is everything analyzed? Yes, I used ANALYZE TABLE CLASS_CONFIG COMPUTE STATISTICS FOR ALL COLUMNS FOR ALL INDEXES after creating the function-based index. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Monday, October 27, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: Query Tuning Help Do you have query rewrite privilege? What is the query_reqrite_inegrity set to? How about optimizer parameters (optimizer_index_caching,optimizer_index_cost_adj)? Is everything analyzed? On 10/27/2003 10:34:26 AM, David Wagoner wrote: I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows). SELECT a2.class_config_id, a1.schedule_name FROM class_config a2, class_schedule a1 WHERE a2.class_config_id = a1.class_config_id AND to_date(a2.file_dts, 'mmddyyhh24miss') SYSDATE - 35 I created a function-based index on FILE_DTS, like this: CREATE INDEX CLASS_CONFIG_FILE_DTS_FX_IDX ON CLASS_CONFIG to_date(file_dts, 'mmddyyhh24miss') and analyzed the table, but the explain plan still shows a FTS. I can change the query to something simpler and get it to use the new index, but I assume the calculation ( SYSDATE - 35) is causing the problem. Any suggestions? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Share Data between PostgreSQL and Oracle
Title: Share Data between PostgreSQL and Oracle Anyone have experience doing this? I would like to hear your tips and experiences. Here's our situation. We have an Oracle DB on Sun Solaris 8 and a PostgreSQL DB on Linux (RH 7.3) that we need to share data between, specifically from PostgreSQL to Oracle. I want to experiment with Oracle's Generic Connectivity via ODBC connection. The advantage here seems to be DB-to-DB connection, ability to use Oracle SQL and tools, etc. Limitations might be network performance. An alternative is to produce flat files from PostgreSQL, FTP them to Oracle server, and SQL*Load them into Oracle. Not a real-time solution, but load performance is usually very good with SQL*Loader. Thoughts? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
Effect on Oracle of changing server time from EST to GMT
Title: Effect on Oracle of changing server time from EST to GMT To support internationalization, we may need to change our server time zone from US EST to GMT. What effect, if any, will this have on the Oracle databases? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com ...OLE_Obj... The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
RE: how to keep statistics up to date for CBO
Title: RE: how to keep statistics up to date for CBO I like to use a cron job that runs the following in SQL Plus: begin dbms_stats.gather_schema_stats(ownname= 'YOUR_SCHEMA_NAME', options= 'GATHER AUTO'); end; You should search the Oracle docs for your version of Oracle (you didn't specify version) to determine the best method for gathering statistics. You'll also see the different options there, like GATHER AUTO, which lets Oracle determine when it's time to compute new statistics for tables and indexes. For 9iR2, the best method for CBO is dbms_stats, rather than analyze table compute statistics, according to the Oracle docs. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 08, 2003 4:54 PM To: Multiple recipients of list ORACLE-L Subject: how to keep statistics up to date for CBO How does one keep CBO statistics for an applications base tables up to date? We are about to implement the CBO any must read documents. Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Oracle Performance Software from Veritas
Just got this email from Veritas...apparently they are getting into the database performance business for Oracle (and SQL Server too I think). Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: VERITAS Software [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 3:40 PMTo: David WagonerSubject: Trial Software for Oracle environment Do something about it. Download a free trial of VERITAS Indepth(tm) for Oracle. Easier said than done. Usually it's difficult, if not impossible, to pinpoint the root cause of performance slowdowns. Countless hours are spent troubleshooting and analyzing applications with few results to show for it. That's about to change. With VERITAS Indepth for Oracle, you can identify specific application bottlenecks, resolve them faster, and maintain promised service levels to users. Download VERITAS Indepth for Oracle to see how you can: Monitor the Oracle environment continuously and capture performance data for current, short term, and long-term performance analysis. Drill down and identify a performance problem caused by a resource bottleneck or a poorly written SQL statement. Resolve performance problems faster with detailed steps and displays statistics relevant to each step in the Oracle access path. Download Now Why we contacted you and how to opt-out: We know your time is valuable and that we (and others) are placing increasing demands on it. We contacted you about this news because we believe that the content of this message would be interesting and valuable to you. If you do not wish to receive future VERITAS notifications, please click on the link below, and send us the e-mail: mailto:[EMAIL PROTECTED] Please review our online Privacy Policy and Terms of Use. © Copyright 2003 VERITAS Software. All rights reserved. VERITAS Software, 350 Ellis Street, Mountain View, CA 94043, United States.We welcome your comments. Send email to [EMAIL PROTECTED]
RE: Physical I/O and databases other than oracle
Title: RE: Physical I/O and databases other than oracle According to one recently published source*, in a well-tuned database system, the server should be CPU-limited. The reasoning here is that in a perfectly tuned system, the other bottlenecks of I/O, network, etc. have been eliminated, so the system is then limited by the speed and number of CPUs. This is an ideal system, of course, and we all know that it is common to have less than ideal numbers of disks or I/O controllers to spread the load. * The Art and Science of Oracle Performance Tuning, Christopher Lawson, 2003, p.184. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
RE: Re: Cary's book -- Out of stock !
Title: RE: Re: Cary's book -- Out of stock ! Well after thumbing through Cary and Jeff'sbook yesterday, I decided to set aside the other 2 tuning books I was reading and plunge into this one. Here's why: Figure 9-14 shows an interesting situation in which a single fast CPU out-performs a system with 4 slower CPUs, for a certain condition; this is exactly the situation I am facing while testing themove of aDB (9.0.1.3.0) from a 2-processor (600 MHz) to a 4-processor (400 MHz) box and have been puzzling over reduced performance, even after playing with different degrees of parallel query and having twice as much memory for the DB on the 4-processor box I'm only into the book 100 pages and it's by far the most thorough treatment of SQL trace data I've ever seen- very deep stuff with thorough explanations and tables you can use the methods are logical and founded in the scientific method, something I have seen little of since I left a Ph.D. program in chemistry to work with databases 3 years ago- I can't wait to hit the queuing theory section the writing style is clear and confident I'm just a novice, but I can see that this book will change the way Oracle is tuned. I whole-heartedly believe that this book will help me solve my current performance issues, and many more to come. On another book note, have you seen the latest Oracle Magazine advertisement for books from Oracle Press? There is one entitled, "Oracle Wait Interface" from Gaja V., Kirti D., and R. Shee due out in March 2004. Can't wait! Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions-Original Message-----From: David Wagoner Sent: Monday, September 22, 2003 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Re: Cary's book -- Out of stock ! UPS just delivered my copy of Cary's book to the office! Can't wait to read it, but first I plan to finish the books I'm currently reading: - The Art and Science of Oracle Performance Tuning (Chris Lawson) - Oracle SQL High-Performance Tuning (Guy Harrison) No telling when I'll get to finish Tom Kyte's new book, which from the first couple dozen pages appears to be excellent. So many books, so little time... Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 22, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: Cary's book -- Out of stock ! what was the initial printing? congrats Cary. Hope I can get a copy soon. From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/09/22 Mon AM 09:09:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Cary's book -- Out of stock ! It's up to the publisher as to when they will print more, Cary has no control over that. However... it apparently never GOT to Amazon, as I had it on pre-order there, and it is still listed as "to be released" and not shipping :( --- Prem Khanna J [EMAIL PROTECTED] wrote: Hi List, I have placed an order for Cary's book @bookpool. Does someone know when it will be in stock ? Can Mr.Cary Millsap let me know that ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.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). -- Please see the official O
RE: Re: Cary's book -- Out of stock !
Title: RE: Re: Cary's book -- Out of stock ! UPS just delivered my copy of Cary's book to the office! Can't wait to read it, but first I plan to finish the books I'm currently reading: - The Art and Science of Oracle Performance Tuning (Chris Lawson) - Oracle SQL High-Performance Tuning (Guy Harrison) No telling when I'll get to finish Tom Kyte's new book, which from the first couple dozen pages appears to be excellent. So many books, so little time... Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 22, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: Cary's book -- Out of stock ! what was the initial printing? congrats Cary. Hope I can get a copy soon. From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/09/22 Mon AM 09:09:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Cary's book -- Out of stock ! It's up to the publisher as to when they will print more, Cary has no control over that. However... it apparently never GOT to Amazon, as I had it on pre-order there, and it is still listed as to be released and not shipping :( --- Prem Khanna J [EMAIL PROTECTED] wrote: Hi List, I have placed an order for Cary's book @bookpool. Does someone know when it will be in stock ? Can Mr.Cary Millsap let me know that ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the name from? You can see that other queries produce the correct name. SQL select instance_name from v$instance; INSTANCE_NAME dmedi01 SQL show parameter name; NAME TYPE VALUE --- -- db_file_name_convert string db_name string dmedi01 global_names boolean FALSE instance_name string dmedi01 lock_name_space string log_file_name_convert string oracle_trace_collection_name string oracle_trace_facility_name string oracled plsql_native_make_file_name string service_names string dmedi01.arsenaldigital.com SQL select ora_database_name from dual; ORA_DATABASE_NAME PMEDI01.ARSENALDIGITAL.COM Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message- From: GovindanK [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 10:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: how can I see which database I am logged into without How about SELECT ORA_DATABASE_NAME FROM DUAL; HTH GovindanK select sys_context('USERENV','DB_NAME') from anytable; At 10:49 AM 9/10/2003 -0800, you wrote: hi. I think there was a dbms package to get some of the environment variables for a session, but I can't remember anyhting specific. If someone know what I'm talking about and has any details, please Email me or post here thanks Gene Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without My point was that you can see different names by using different queries. But, you and Mike brought up a good point- I need to use the alter database rename global_name to XXX after cloning databases to avoid any such confusion. Thanks for that tip. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 11, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: how can I see which database I am logged into without What is your point? Mike Hately's statement is still correct. It returns the global_name which should be, but not necessarily IS, the same as db_name since it can be set to any arbitrary value. Of course, if you are using replication you better set it to the correct value or it will not work: stats.scott alter database rename global_name to something.world; Database altered. stats.scott select ora_database_name, sys_context('USERENV','DB_NAME') db_name from dual; ORA_DATABASE_NAME DB_NAME -- SOMETHING.WORLD stats 1 row selected. At 10:59 AM 9/11/2003 -0800, you wrote: /u005/oracle/product/rdbms/admin ls -l dbmstrig.sql -rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql /u005/oracle/product/9.2.0/rdbms/admin sed -n '76,85p' dbmstrig.sql Rem returns the current database name create or replace function database_name return varchar2 is begin return dbms_standard.database_name; end; / grant execute on database_name to public / create or replace public synonym ora_database_name for database_name / /u005/oracle/product/9.2.0/rdbms/admin HTH GovindanK On Thu, 11 Sep 2003 05:39 , Hately, Mike (LogicaCMG) [EMAIL PROTECTED] sent: Hi, this statement returns the GLOBAL_NAME value rather than the database name. Admittedly the 2 should usually be the same but often (following a database clone for instance) it is not correctly set. Regards, Mike Hately Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
International Language Support Experiences?
Title: International Language Support Experiences? We have a new requirement to support multiple languages in at least one of our databases. I'm reading the Oracle 9iR2 Globalization Support Guide (450 pages), but wonder if any of you can share real-life experiences regarding: 1. the conversion of existing DBs to broader character sets 2. using Unicode 3. implementing this with 9iAS Our databases currently use US7ASCII with the American character set, but we will likely need to support European, Southeast Asian, and South American languages. Thanks. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions
RE: RMAN Script Question
Title: RMAN Script Question Thanks Samir, but I already tried that one too and it didn't work either. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions-Original Message-From: SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 9:52 AMTo: '[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN Script Question David, Change the following line in ur script : backup database plus archivelog delete input to backupincremental level = 0plus archivelog delete input Hth, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: 06 August 2003 15:09To: Multiple recipients of list ORACLE-LSubject: RMAN Script Question I believe I have an RMAN script syntax error. The following script works fine: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } However, when I change the backup command to include archive logs and remove them after backup, I get an exit status of 1 in NetBackup and some RMAN errors. Here is the revised script: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete input skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } Here is the RMAN error: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "(": expecting one of: "channel, comma, delete, diskratio, filesperset, format, force, include, keep, maxsetsize, noexclude, nokeep, not, parms, pool, ;, skip, setsize, tag" RMAN-01007: at line 8 column 36 file: /usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv Anyone see the error? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions
RMAN Script Question
Title: RMAN Script Question I believe I have an RMAN script syntax error. The following script works fine: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } However, when I change the backup command to include archive logs and remove them after backup, I get an exit status of 1 in NetBackup and some RMAN errors. Here is the revised script: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete input skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } Here is the RMAN error: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found (: expecting one of: channel, comma, delete, diskratio, filesperset, format, force, include, keep, maxsetsize, noexclude, nokeep, not, parms, pool, ;, skip, setsize, tag RMAN-01007: at line 8 column 36 file: /usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv Anyone see the error? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions
RE: Consolidating Servers
Title: RE: Consolidating Servers This is exactly what I am working on right now! We have to consolidate down from about 5 servers to 2 (Prod. and Test/Dev.). My approach is to just move (clone) the DBs first. That's a job in itself, considering that the production DBs need to be moved during weekend hours. Leave original DB on original server just in case something fails. Take a cold backup, move files to new server, rebuild control file from trace to create clone. Point apps at clone and test. If all is well, archive original DB to tape for a month or two to be safe. By the way, this required me to install 4 versions of Oracle (8.1.7 to 9.2.0.3) in 4 Oracle Homes on the new Production server. Upgrading all to 9iR2 is another project. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message- From: Eberhard, Jeff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 06, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Consolidating Servers Just got out of a meeting with my manager. He had just finished meeting with our Oracle rep and has finally figured out that we don't have enough licenses (I've always asked him what we have and he's never shared it with me, always just I've gotten it taken care of). We have 80 and with our current/potential configuration we are going to need 300. Anyways, to save money he decides that we need to take our databases and consolidate them to two or three servers (from 7). Most of the database are fairly small (100-300Meg) so shouldn't be too bad. Actually it should be pretty fun (if I didn't already have 5 full-time jobs to do). Anyone had to do the same thing? What are some concerns? Should I shoot for the moon and upgrade them all to 9i at the same time or have several versions (7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly appreciated. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Capacity Planning Methods?
Title: Capacity Planning Methods? How do you guys collect capacity planning metrics, such as DB size? Do you use StatsPack, Oracle OEM, others? I'm interested in an efficient method to track DB growth in GB month over month. Best regards, David B. Wagoner Database Administrator
RE: PERL reference
Title: RE: PERL reference The Deitel and Deitel book PERL: How to Program is the top rated PERL book on Amazon. Just got it myself but can't offer an opinion yet. I know it's used by the local technical college for their PERL class. It's cheaper at www.bookpool.com. 1. Perl How to Program, Introducing CGI and Python (With CD-ROM) by H. M. Deitel, et al (Paperback) Avg. Customer Rating: Usually ships in 24 hours List Price: $85.00 Buy new: $85.00 Used new from $41.94 Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions
RE: What books recommended for Data Modeling ?
I took the advice of Dennis Williams and just read "The Data Modeling Handbook" (http://tinyurl.com/j5wr) and found it to be excellent for normalization of OLTP systems. The authors clearly have lots of experience and offer many "rules" and best practices. The book is expensive for it's size, but worth it. There is a new book that is not yet published called "Effective Oracle by Design", by Tom Kyte. You can preorder it at www.bookpool.com. If it's anything like his other book then it will be most excellent. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message-From: Salaheldin Aboali [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 6:19 AMTo: Multiple recipients of list ORACLE-LSubject: What books recommended for Data Modeling ? hi all, What books you recommend for Data Modeling ? including how to map business requirements to relational and Data warehouse date model Regards,Salaheldin Aboali_Senior Software Developer Management Information Systems_http://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_P.O. Box: 20126 Safat-13062 Kuwait_
RE: Capacity Planning Methods?
Title: RE: Capacity Planning Methods? Rich, I'd love to see the procedure and table that you use. Thanks for offering. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions
RE: Increase tablespace, which way is better?
Title: Message My first question is: Why are you adding a data file named "users" to your SYSTEM tablespace? Do you mean to add this to your USERS tablespace? Next, if you have an idea about the data growth or size of objects that you will place in the new datafile then you can better plan the initial size. It's better to create it with an initial size close to your target value so that it doesn't have to dynamically extend. At least that's what I would do with a data file that small (100 MB). For small DBs, I usually set my data file max size to 2 GB. Anything over that will mean adding another data file. David B. Wagoner Oracle DBA
Physical Design Question
Title: Physical Design Question Here's my situation: Damagement wants us to move 4 small production DBs to one server to save on licensing costs. Server is a Sun E4500, 4 CPUs, 8 GB RAM. There is a pair of internal disks that are mirrored with enough room for Solaris, swap, and 1 Oracle Home. There are 3 A1000 disk arrays (12 x 18 GB drives each), all set to RAID 1+0 using the S.A.M.E. approach. Questions: 1. Should I use a separate Oracle Home for each DB? Pros: --Allows upgrade/patching of 1 DB at a time without affecting others (some are home-grown, some are 3rd party). Cons: --Takes up more space, but space is not a major concern. --I'll have to put some Oracle Homes on the A1000s with the data files (i.e., concerns about disk contention). --Requires applying multiple upgrades/patches 2. Should I put 1 DB per A1000? (Actually, 1 A1000 would hold 2 of the least active DBs.) Pros: --Easier to determine performance problems b/c each DB is isolated on 1 A1000. --If one controller dies, it only affects 1 DB. Cons: --Only get throughput of 1 controller; could use 3 controllers if data files spread across 3 A1000s. Anyone with experience doing this, please share your tips, tricks, and gotchas! Best regards, David B. Wagoner Database Administrator
RE: Physical Design Question
Title: Physical Design Question Thomas, Thanks for the comments. The databases are all different versions (8.1.7.3 to 9.2.0.2.0), at least for the time-being. In your suggestion to use 1 Oracle Home for multiple databases, then maybe later split into multiple Oracle Homes, do you have to relink the database files or anything special, or do you just have to change the Oracle Home environment variable to point to a new Oracle Home? Best regards, David B. Wagoner Database Administrator
RE: SORT_AREA_SIZE question
You didn't specify which version of Oracle you are using, but if it's 9i then you should investigate the use of pga_aggregate_target instead of the older sort_area parameters. I've been using pga_aggregate_target in a hybrid OLTP/reporting database for about 8 months with great results. Mine is set to 100 MB. You'll get the benifit of the memory advice feature of 9i as well. Have a look at OEM if you're using it, otherwise you can look directly in the dictionary views to determine proper sizing of PGA, shared pool, and buffer cache. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message-From: Bart Kersteter [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 10:39 AMTo: Multiple recipients of list ORACLE-LSubject: SORT_AREA_SIZE question Hello, I joined this list last week, so I apologize in advance if I'm asking a question that has previously been answered. I am responsible for a reporting database/data mart that is approximately 175 GB. Our main fact table ranges from 1-14 GB depending upon how far along we are into our financial year. I have large reports that run full table scans on this table daily. In an effort to keep as much of the sorting in memory as possible I have specified SORT_AREA_SIZE to be 100MB. Some of the tuning books I am reading now are making me second-guess myself and I am wondering if this is overkill. Can anyone provide some advice on how large they are setting their SORT_AREA_SIZE values for their DSS systems? Thanks in advance, Bart Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you
RE: DBA Salary in California
Title: RE: DBA Salary in California Check out www.salary.com for an estimate. A quick check revealed a range of $68-90K with a median around $79K. Not sure how recent these numbers are. Best regards, David B. Wagoner Database Administrator -Original Message- From: Gabriel Aragon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 24, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Hanging 64 Bit Solaris 8 Oracle 9.2
We had this problem recently- running 8.1.7 (64-bit) and 9.0.1.3 (32-bit) on Sun Solaris 2.8. Both databases were registered in the same version 9.0.1.3.0 Listener. Oracle Support eventually told me that Listener versions below 9iR2 do not support mixed bit versions (64- and 32-bit). You would have to run a separate listener for each bit version. I upgraded the 9.0.1.3.0 to 9.2.0.2.0 and registered both on the new 9iR2 Listener (this week) and haven't seen a listener crash...yet (fingers crossed). See text below, copied from my TAR. David B. Wagoner Database Administrator Arsenal Digital Solutions Phone: 919-466-6723 Cell: 919-412-8462 Fax: 919-466-6783 E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web: http://www.arsenaldigital.com http://www.arsenaldigital.com/ === ANALYSIS === This is most likely the known issues with registration taking place accross bit versons and from a higher version of a database to a lower version of the listener. Cross Registration for 2 oracle instances with different BIT versions will not work until listener 9.2.0.2.0. The other possibility is that the 9.2.0 regular instance is registering using the default settings to the listener 8.1.7. This is not a supported functions. The supported method would be using the listener version that matches the highest version of the database you plan on using. Ill tell you the methods that you can use to determine if this is in fact your issue and how to resolve it. Some facts about the known issue. 1. Your running 32 and 64 bit software 2. The listener that is crashing is using port 1521. 3. Your listener shows a service handler twice for the instances. 4. Your not completely familiar with Automatic instance registration functionality. === ACTION PLAN === 1. Go to Oracle_home/bin and perform file oracle that should return Elf and some other text. if the return Text Says 64 then its running 64 bit oracle. 2. Perform the same in the other oracle home. 3. perform lsnrctl status and you will see that there is the two instances in the service list. 4. Go to metalink and read Article-ID: Note:76636.1 Circulation: PUBLISHED (EXTERNAL) Folder: network.TNSListener Topic: Service Registration Title: Service Registration in Net 8i So you understand the instance registration process. === SOLUTION/ANSWER === You have a few options. 1. Change the listener port to something other than 1521. That way registration to the default port wont take place which is why the issue is taking place. 2. Use a 9.2.0.2.0 listener...see bug 2187760 for full details. Cross Registration between BIT versions doesnt work until listener 9.2.0.2.0 3. Force Registration to fail by setting the LOCAL_LISTENER parameter to a value other than the current listener address. Again avoiding Registration by forcing it not to work properly. -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Subject: Listener Hanging 64 Bit Solaris 8 Oracle 9.2 Anyone had this issue? Oracle support has been helpless so far, even with mega trace files. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: US Travel for the DBA
Dave, I can see how frustrating the new regulations must be for you, and many others who are accustomed to very lax US regulations regarding foreign visitors. I'll be traveling to Italy soon, and I learned that I will have to leave my passport with any hotel receptionist for a couple of hours while my information is given to the local police. To my knowledge, this is standard protocol there- not a recent policy based on terrorism. A few years ago, I traveled to Holland and was very surprised to see military police looking guys in the Schipoll airport (Amsterdam) carrying machine guns. Before entering our departure gate seating area, everyone on my plane was thoroughly questioned about itinerary, personal belongings, where did we stay, what did we do, who did we visit, etc. My point is that the US is just now catching up to the rest of the world with respect to security, in many respects. Is it fair to be singled out because someone has Middle-Eastern heritage? Of course not, but until the US regains some sense of security there will no doubt be some growing pains in the development of new security practices. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 100 Cary, NC 27511-8582 Office (919) 466-6723 Mobile (919) 412-8462 Pager [EMAIL PROTECTED] Fax (919) 466-6783 AIM adswDWagoner http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Tuesday, February 04, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Hi All, The only reason I am posting this is because I have defended America on this list and elsewhere before. I wish this to be taken as one best friend speaking to another. Background I was born in Bahrain (Persian Gulf) and left there when I was six months old. I have two passports, Canadian and UK. 30-40% of my work is in the USA. Due to the new INS regulations I am photographed and fingerprinted when I cross the border I have to check in at an INS office when I arrive at my destination I have to check in at an INS office when I leave my destination Use of my other passport to enter the US will define me as suspicious Please note, this in no way prevents me from working in America, however, I can no longer go skiing in Whitefish. (The nearest INS office is 2 hours south in Missoula, I believe) Walt, Steve, whats the snow like in Bozeman this year? I'm allowed to go skiing there. :-) Sigh .. Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Take Care of your DBAs
Title: Take Care of your DBAs I love this article. I forwarded it to damagement too because they havent been showing enough love for the DBAs lately ;-). Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 100 Cary, NC 27511-8582 Office (919) 466-6723 Mobile (919) 412-8462 Pager [EMAIL PROTECTED] Fax (919) 466-6783 AIM adswDWagoner http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: Take Care of your DBAs http://careerlink.devx.com/articles/hc0199/hc0199.asp Interesting article I stumbled across. Best quote: Stay Out of your DBA's Face! WELL PUT! Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
Table Partitioning in a Hybrid-OLTP System
Ive been reading the 9iR2 docs on partitioning, along with Tom Kytes excellent chapter on the subject. It seems that a Global index or unique, local indexes could be used effectively in an OLTP system, but both have their caveats. This is a hybrid system- its part OLTP but is also used quite a bit for reporting. Would anyone out there care to share your good or bad experiences with these indexes on partitioned tables in such a system? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 100 Cary, NC 27511-8582 Office (919) 466-6723 Mobile (919) 412-8462 Pager [EMAIL PROTECTED] Fax (919) 466-6783 AIM adswDWagoner http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.
RE: Unix for oracle dba -- Suggest a book ?
This is the latest one that I've seen. I have it and the parts that I've read are good. http://www.amazon.com/exec/obidos/ASIN/0072223049/qid%3D1041862110/sr%3D11-1 /ref%3Dsr%5F11%5F1/103-3312873-7713423 Oracle 9i UNIX Administration Handbook, by Don Burleson (ISBN 0072223049), 2002 David Wagoner Oracle DBA -Original Message- Sent: Monday, January 06, 2003 5:14 AM To: Multiple recipients of list ORACLE-L Guys, i know a bit of Linux.and not completely a newbie to Unix. Can u suggest me a good/best book for Unix ? ..Unix for oracle DBA. i.e,tuning unix for good performance of oracle. any such book available ? kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: warehouse builder's dependance on oem job system.
Title: warehouse builder's dependance on oem job system. You may have implied this in your message, but are you using Oracle Workflow in conjunction with OEM? That is the scheduling method that is taught in the OWB class by Oracle. I am currently learning OWB but have not setup scheduling yet, so Id be interested to hear your solution once you find it. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 100 Cary, NC 27511-8582 Office (919) 466-6723 Mobile (919) 412-8462 Pager [EMAIL PROTECTED] Fax (919) 466-6783 AIM adswDavid http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 12:31 PM To: Multiple recipients of list ORACLE-L Subject: warehouse builder's dependance on oem job system. ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks
RE: Oracle SAN Experiences?
James, Thanks for the tips. Ive read your Sane SAN article several times and think its excellent. Ill check out the other article too. Best regards, David Wagoner Oracle DBA Cary, NC -Original Message- From: James Morle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 12, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle SAN Experiences? David, You might find one of my whitepapers interesting: Sane SAN is the title. You can get it at: www.scaleabilities.com/whitepapers.shtml www.oaktable.net Also, you will find a paper on integrating solid state disks into a SAN, and whether that makes any sense to real sites or not. Best regards James -- James Morle Author of Scaling Oracle8i: Building Highly Scalable OLTP System Architectures
Oracle SAN Experiences?
Title: The Sys The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and Id like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (its possible to use smaller disks in the SAN) -Prove it! After reading the Sane SAN article and a case study about Volvo implementing a SAN, I believe its possible to have a great Oracle/SAN implementation if its setup correctly and tuned. Other resources that you can Google are Using SVA SnapShot with Oracle, Performance Benchmark LSI Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA
RE: How to move 200 GB db from prod to dev?
Title: How to move 200 GB db from prod to dev? Search the Oracle-L archives- this question has been covered several times recently. Also, Oracle DBA Tips Techniques by Sumit Sarin (2000, Oracle Press) has detailed instructions for cloning a database in Chapter 1. Note the error in the script on page 43: create controlfile REUSE database should be create controlfile SET database. Otherwise, the procedure works wonderfully. Successful? Begun the clone wars have. Master Yoda HTH, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Pager [EMAIL PROTECTED] Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: How to move 200 GB db from prod to dev? Hi! We are supposed to clone our production database onto a new development box (both boxes are Sun Solaris). The db is about 200 GB in size. What would be the best way to achieve this? Simply copying over the files won't work, since the instance names are different: Production: SID=PCLDB1 = e.g. /u02/oradata/PCLDB1/system01.dbf Development: SID=ROLAND = e.g. /u02/oradata/ROLAND/system01.dbf So would export/import the entire db be the only way? (But writing out dump file that big should be a little disk space problem...) Renaming all the datafiles (approx. 100) would be kind of annoying... Any ideas? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Remove Duplicates
Here is an interesting script I found on Metalink (Note:1019920.6) for removing duplicates, but I have not tried it yet: == Title: == Script to Eliminate Non-unique Rows === Disclaimer: === This script is provided for educational purposes only. It is NOT supported by Oracle World Wide Technical Support. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. PROOFREAD THIS SCRIPT PRIOR TO USING IT! Due to differences in the way text editors, email packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected. = Abstract: = This script removes all but one row (all but the row with the highest rowid) from owner.table in each group of rows having identical values in column(s). Multiple columns must be separated with commas (without spaces). Script TFSUNIQU is intended primarily for use in deleting rows that prevent the creation of a unique index on the columns in column(s). It will happily delete rows that are not identical, as long as the rows are identical with respect to the values of the columns in column(s). = Requirements: = You must have DELETE privileges on the selected table. === Script: === --- cut -- cut -- cut -- SET ECHO off REM NAME: TFSUNIQU.SQL REM USAGE:@path/tfsuniqu schema_name table_name column_name(s) REM REM REQUIREMENTS: REM DELETE on selected table REM REM AUTHOR: REM Grant Franjione, Phil Joel, and Cary Millsap REM (c)1994 Oracle Corporation REM REM PURPOSE: REM Removes all but one row (all but the row with the highest rowid) REM from owner.table in each group of rows having identical values REM in colum(s). Multiple columns must be seperated with commas REM (without spaces). REM REM TFSUNIQU is intended primarily for use in deleting rows that REM prevent the creation of a unique index on the columns in REM column(s). It will happily delete rows that are not identical, REM as long as the rows are identical with respect to the values of REM the columns in column(s). REM REM EXAMPLE: REM N/A REM REM DISCLAIMER: REM This script is provided for educational purposes only. It is NOT REM supported by Oracle World Wide Technical Support. REM The script has been tested and appears to work as intended. REM You should always run new scripts on a test instance initially. REM REM Main text of script follows: def owner = 1 def table = 2 def uukey = 3 delete from owner..table where rowid in ( select rowid from owner..table minus select min(rowid) from owner..table group by uukey ) / undef owner undef table undef uukey --- cut -- cut -- cut -- David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Pager [EMAIL PROTECTED] Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- From: Terrian, Tom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: Remove Duplicates I know I have seen this posted before... We have a large range partitioned table that has duplicates in it. What is the fastest way to remove the dups.? I have the following scripts which do it but may be fast or slow. What do you guys use? DELETE FROM tablename WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM tablename GROUP BY fieldnames); Or alter table table_name add constraint duplicate_cons unique key (column_name) exceptions into exception table; How to find duplicates: select column_name, count(column_name) from table_name group by column_name having count(column_name) 1; Tom
RE: Oracle RAC and NAS
Here is an informative article entitled Sane SAN, by James Morle that describes the use of SAN and NAS from a database performance perspective. Good reading... http://miracleas.dk/DBF/Morle/Sane_SAN_WP.pdf HTH, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Pager [EMAIL PROTECTED] Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Thursday, May 23, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Stefan - By NAS, I assume you mean Network Attached Storage. We use a Net Appliance on our test server and it works well for the purpose. Basically we have about a dozen Oracle instances which are used infrequently, so it provides tons of cheap storage that isn't used that much. I found out the hard way that you can overwhelm it with too many simultaneous heavy batch jobs. My guess is that with both RAC and NAS the key is to configure the highest-speed dedicated connections possible. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 23, 2002 7:19 AM To: Multiple recipients of list ORACLE-L Hello everybody, I was wondering if anybody has real hands-on experience with either a combination of both RAC and NAS or just running 9i on an NAS. What are the pros and cons ? Does anybody have some input on this topic ? Maybe some helpful links besides technet ? TIA Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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: David Wagoner 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).
New Oracle 9.x Pre-Install Script from Oracle
Just saw this todayhavent tried it yet. Excerpt from MetaLink: News Notes New Script: Pre-Install script which checks your Unix environment to ensure successful installation of Oracle 9.x version of RDBMS The Data Server Support team is pleased to release a new script for Unix RDBMS users. Customers who plan to install Oracle 9.x RDBMS on an HP, Solaris, Tru64, AIX or Linux server can run this script to verify that the server is configured according to the Oracle RDBMS installation guides. The output will report the required tasks that need to be performed to ensure a successful installation of Oracle 9.x RDBMS. For more details on how to use and download the Unix InstallPrep Script, see document id 189256.1. Thank you for using MetaLink. Data Server Support Team Oracle Support Services David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Pager [EMAIL PROTECTED] Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.
RE: Installing oracle 9.0.1 on Sparc
Natalia, follow the 9i Installation Guide very carefully, especially the parts about setting up the DBA user and group accounts, permissions, etc. Also, on UNIX you have to set the kernel parameters in /etc/system, among other things. All of this is in the Installation Guide. HTH, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Pager [EMAIL PROTECTED] Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Thursday, May 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Hi, I am installing oracle 9.0.1 on Sun Sparc Solaris 5.6, I have the next error: make: Fatal error: Command failed for target `ntcontab.o' /usr/ccs/bin/make -f ins_net_client.mk nnfgt.o ORACLE_HOME =/u02/app/oracle/prod uct/9.0.1 (if [ -d /u02/app/oracle/product/9.0.1/lib32 ] ; then \ /usr/ccs/bin/make -f /u02/app/oracle/product/9.0.1/network/lib/ins_net_client. mk \ nnfgt.o-32bit; fi) (if [ assemble = assemble ] ; then \ /u02/app/oracle/product/9.0.1/bin/gennfgt nnfgt.s ;\ /usr/ccs/bin/as -P -o nnfgt.o nnfgt.s ;\ rm -f /u02/app/oracle/product/9.0.1/lib32/nnfgt.o ;\ mv nnfgt.o /u02/app/oracle/product/9.0.1/lib32 ;\ /usr/ccs/bin/ar rv /u02/app/oracle/product/9.0.1/lib32/libn9.a \ /u02/app/oracle/product/9.0.1/lib32/nnfgt.o ; fi) ar: writing /u02/app/oracle/product/9.0.1/lib32/libn9.a r - nnfgt.o (if [ assemble = compile ] ; then \ /u02/app/oracle/product/9.0.1/bin/gennfgt nnfgt.c ;\ cc -c nnfgt.c ;\ rm -f /u02/app/oracle/product/9.0.1/lib/nnfgt.o ;\ mv nnfgt.o /u02/app/oracle/product/9.0.1/lib ;\ /usr/ccs/bin/ar rv /u02/app/oracle/product/9.0.1/lib/libn9.a /u02/app/ oracle/product/9.0.1/lib/nnfgt.o ; fi) (if [ assemble = assemble ] ; then \ ... Some idea? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Natalia Laracca 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: David Wagoner 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: Remove an SID from sun solaris
You might try using DBCA to delete the old database/SID that is interfering with your current creation attempt. That should do the trick. If not, you will have to track down the occurrences of the SID in Oracle files like tnsnames.ora, listener.ora, oratab, etc. and remove them. HTH, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. -Original Message- Sent: Thursday, May 02, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Hi List, During the creation a new database, I just create an script but still oracle create an SID for me I want to use this SID again so How can I remove this SID and reuse it again. BTW still my ORA-03113: end-of-file on communication channel didn't solved. Thanks allot Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: David Wagoner 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 freezes ... no indications of any kind
Check MetaLink Doc ID: Note: 176129.1 ALERT: LATCH FREE And FREE_BUFFER_WAITS Cause Performance Degradation/Hang Problem affects 9.0.1.2 and sounds like what you're experiencing. HTH, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Monday, March 11, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Hi all, this is something new on our 9012 db. Once in two days, the DB will freeze up for up to 2-3 minutes ... and then everything becomes normal again. There are no trace files, no entries in alert log nothing but as production is hooked up to the db, they page, us, we get in but we don't see anything. Any ideas on where to start looking? It is 9012 on AIX (64 bit on 64 bit). Thanks in advance 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner 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: Excel's Oracle connectivity
It's called MS Query Add-in and ODBC Add-in for Excel. The add-in modules can be installed from the CDs, if not already installed. I've played around with this for end-user reporting and found that the data refresh was extremely slow compared to SQL*Plus, SQL Navigator, etc. Let me know if you find a way to use it successfully. Seems useful, especially for accountants who work extensively in Excel, if you can get response times you can live with. Best, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Mobile (919) 225-4962 Fax (919) 466-6783 http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Monday, March 11, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Hi, some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, so the user could refresh data any time he/she had Oracle connectivity and OLE connection. I forgot the link. Could some one please help me? (It was NOT Oraxcel!!) TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas 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: David Wagoner 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: alter index rebuild online
Works great on 9.0.1 david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Tuesday, March 05, 2002 11:43 AM To: Multiple recipients of list ORACLE-L I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online' I got corrupted indexes. I saw on metalink that it's supposed to be fixed by 8.1.7.1 - anybody using successfully now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 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: David Wagoner 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).
Automatic PGA Memory Management via PGA_AGGREGATE_TARGET paramete
I just stumbled upon the Automatic PGA Memory Management section of the 9i docs. Ive never heard of this before. Does anyone know how long its been around? Anyone using it found any bugs, concerns, etc.? Granted, this is intended for *dedicated* server mode, it seems like a good option for our Test databases and perhaps other databases that have only a handful of users and dont require MTS. By setting PGA_AGGREGATE_TARGET=X, where X can be a value in K, M, or G, Oracle will automatically distribute this memory allocation to dedicated sessions instead of using SORT_AREA_SIZE. Heres an excerpt from the docs: Oracle does not recommend using the SORT_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas by setting PGA_AGGREGATE_TARGET instead. SORT_AREA_SIZE is retained for backward compatibility. Learn something new every day in Oracle land david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.
RE: Automatic PGA Memory Management via PGA_AGGREGATE_TARGET para
I bet if you wowed us with a really good explanation of this new feature then some readers would be inclined to go check out your book :). david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Monday, March 04, 2002 2:53 PM To: Multiple recipients of list ORACLE-L I cover this topic and many others in my Oracle9i New Features book :-)) RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 1:58 PM To: Multiple recipients of list ORACLE-L I just stumbled upon the Automatic PGA Memory Management section of the 9i docs. I've never heard of this before. Does anyone know how long it's been around? Anyone using it found any bugs, concerns, etc.? Granted, this is intended for *dedicated* server mode, it seems like a good option for our Test databases and perhaps other databases that have only a handful of users and don't require MTS. By setting PGA_AGGREGATE_TARGET=X, where X can be a value in K, M, or G, Oracle will automatically distribute this memory allocation to dedicated sessions instead of using SORT_AREA_SIZE. Here's an excerpt from the docs: Oracle does not recommend using the SORT_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas by setting PGA_AGGREGATE_TARGET instead. SORT_AREA_SIZE is retained for backward compatibility. Learn something new every day in Oracle land... david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: David Wagoner 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).
Solaris Kernel Memory Parameters Recommendations?
Ive read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation. The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself. Would some of you more experienced UNIX/Oracle DBAs please provide a plain English explanation describing your strategy in setting the following 7 parameters in the /etc/system file: SEMMNI SEMMNS SEMMSL SHMMAX SHMMIN SHMMNI SHMSEG To use a simple example, lets say the server has 1 GB of RAM to work with. Thanks in advance for sharing, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.
Convert TEMP tablespace to LMT?
What is the best way to convert a dictionary-managed TEMP tablespace to locally managed? Heres my situation, I created an 8.1.7 database with all dictionary-managed tablespaces. Then, I converted all tablespaces to locally managed, except SYSTEM and TEMP. The conversion packaged refused to convert TEMP to LMT so it seems that I must drop the TEMP tablespace and re-create it as LMT. My question is, do I need to create an intermediate, like TEMP2, and point everything to it while Im dropping and re-creating TEMP? Thanks for your advice, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
Query to determine 32 or 64 bit?
Whats the query to determine if the Oracle version is 32 or 64 bit? I queried v$version but its not there. I know there is a query because Ive seen it before but dont remember it. david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: CREATE DATABASE scripts
I did something similar on 9i recently and I believe there was a check button in DBCA for Create Scripts, in addition to Create Template. Did you follow DBCA through to the last screen? I think it is there. I tried to use the 9i DBCA to create a custom database with rollback segments instead of the UNDO tablespace, 3 uniform extent sizes, custom tablespaces, locally managed tablespaces, etc. and it crashed burned every time. A couple weeks of Oracle support and they got nowhere! Moral of the story: you are correct to generate scripts! HTH, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Tuesday, December 11, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Hi, I am trying to generate some generic CREATE DATABASE scripts from the Oracle Database Configuration assistant and I cannot see the Generate Database Creation Scripts option that is mentioned in the HELP. It is not listed on the screen with the Create Database and Save as a Database Template options. Can someone let me know how it is done with the 9i configuration assistant or pass on some Oracle 9i CREATE DATABASE scripts. Thanks, Lindsay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stoddard, Lindsay 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: David Wagoner 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).
Virus Warning
Do not open messages with a Hi subject and a screensaver attachment. Its a virus circling around our company now. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: Some 9i Questions - Help!
How the CIO Stole Christmas ... The Grinch would be jealous! We upgraded a small-ish production database to 9i in August 2001 on Solaris 2.8. Took no more than 1.5 - 2 days as I recall. Much more time to read the manuals though. Look at this list's archive and MetaLink for bugs and gotchas. Overall, I've really enjoyed using 9i but I'm sure you can find some serious horror stories and gotchas to provide as evidence for waiting until after New Years to upgrade. Happy Holidays. david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Friday, November 30, 2001 12:52 PM To: Multiple recipients of list ORACLE-L An edict just came down from our CIO that we should upgrade all our databases to 9i by the end of the year (he's decided it's important that we always be on the latest release of all software). Aside from the fact that other than a small play database we haven't done any testing yet, aside from the fact that to do this I'd have to cancel all my holiday plans with friends and family to work every weekend in December (probably plus Christmas and New Years) to meet this arbitrary deadline, I'm still nervous about upgrading to such a relatively new release (I wasn't intending to consider it until late next year). So, one question and one request. 1. When was 9i first released for Solaris (I haven't been able to find this information after poking around the Oracle website)? 2. Could anyone please post any 9i horror stories you've had? I know about the Managed Rollback Segment problem, but since that feature is optional it doesn't give me a lot of ammunition. If this was a better job market I'd be contacting my headhunter right now. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: David Wagoner 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: Comments on RMAN
Did anyone else get an error while trying to open the RMAN pdf file? David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Thursday, November 29, 2001 9:46 AM To: Multiple recipients of list ORACLE-L I thought I had another one but I can't find it. It was done by Michael Abbey of Pythian Consulting of Ottawa, Canada. His presentaion was entitle something like 'If you don't use rman now you will' and explained how rman uses oracle internals to avoid problems. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:55 AM Ruth, I'd be interested in those articles if you don't mind? Cheers Mark -Original Message- Gramolini Sent: 29 November 2001 13:05 To: Multiple recipients of list ORACLE-L I have used rman exclusively for all backups since I started with Oracle. It was very buggy before 8.0.6 but after that it is very stable. It is well worth learning, I can send you some articles about is if you would like. You can't send attachments on the list. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 7:25 AM What is the general consensus from the list on using RMAN? Pros? Cons? Any previous experience with problems as a result of using RMAN versus cold and hot backups. I would appreciate your inputs. Thanks in advance. Belinda K. Taylor Database Analyst, Database Support Database Application Services, Technology Systems Division Information Technology Unit George Mason University Office: (703) 993-3346 Fax: (703) 993-3403 -- 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: Ruth Gramolini 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: Mark Leith 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: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script to Disable Constraint, Change Value, then Enable Const
I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed illegal data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Wagoner Sent: 27 November 2001 21:30 To: Multiple recipients of list ORACLE-L Subject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: Script to Disable Constraint, Change Value, then Enable Const
Rick, thanks for your input. When I test the deferred constraint in SQL*Plus I get an error. What am I doing wrong? I did not find much information in the docs about deferred constraints. SQL set constraints all deferred 2 update table1 set host_name = 'tigerz' where host_name = 'tiger' 3* update table2 set host_name = 'tigerz' where host_name = 'tiger'; SQL update host set host_name = 'tigerz' where host_name = 'tiger' * ERROR at line 2: ORA-00933: SQL command not properly ended TIA, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I have had the same type of requirement and decided to use deferrable constraints. Works great! Rick -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Script to Disable Constraint, Change Value, then Enable Const Not good approach. Instead, use 'deferrable constraints, should work in your situation. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed illegal data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Constrain How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards? Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. I struggle to see why you would want to do this - do you have any more info? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Wagoner Sent: 27 November 2001 21:30 To: Multiple recipients of list ORACLE-L Subject: Script to Disable Constraint, Change Value, then Enable Constrain Listers, Does anyone have a script that will do the following: 1. Accept user input for old data value 2. Accept user input for new data value 3. Disable table constraint 4. Update record with new data value 5. Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database
RE: Script to Disable Constraint, Change Value, then Enable Const
I know it looks like a semi-colon error, but its not. Please send me one of your examples that you know works and Ill modify and try here. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const David, You need a semi-colon after line2 i.e., update table1 ...; Rick -Original Message- From: David Wagoner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const Rick, thanks for your input. When I test the deferred constraint in SQL*Plus I get an error. What am I doing wrong? I did not find much information in the docs about deferred constraints. SQL set constraints all deferred 2 update table1 set host_name = 'tigerz' where host_name = 'tiger' 3* update table2 set host_name = 'tigerz' where host_name = 'tiger'; SQL update host set host_name = 'tigerz' where host_name = 'tiger' * ERROR at line 2: ORA-00933: SQL command not properly ended TIA, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I have had the same type of requirement and decided to use deferrable constraints. Works great! Rick -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Script to Disable Constraint, Change Value, then Enable Const Not good approach. Instead, use 'deferrable constraints, should work in your situation. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here. The point is not to let someone enter data that would violate the referential integrity. Let me explain with an example: 1. User wants to update a primary key record in parent table 2. Dependent data exists in a child table so the user gets an error while trying to perform step 1 3. It is necessary to disable the FK constraint in order to update both tables 4. Enable the FK constraint successfully Does that make sense? This is a process we have to do routinely and it has happened in the past that the FK was mistakenly not re-enabled, which allowed illegal data to be loaded later. Thus the need for a script. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Script
Script to Disable Constraint, Change Value, then Enable Constrain
Listers, Does anyone have a script that will do the following: Accept user input for old data value Accept user input for new data value Disable table constraint Update record with new data value Enable constraint A script like this would help ensure that constraints are not left off after updates, allowing illegal data into the tables. Good user-proof script I would think. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: RE: Oracle Browser 2
Wow. Thanks for your effort here Dick. Sounds like quite an ordeal. At least I'll know some problems to look for if my company decides to try Discoverer! David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Wednesday, October 31, 2001 9:55 AM To: Multiple recipients of list ORACLE-L David, OK, first off the Oracle sales droid and pre-sales droid came in to do the install of the product (9iAS Enterprise Edition which BTW, you HAVE to have the Enterprise edition or else you don't get the WEB based tool). The install manual said it would need 6GB of HP-UX disk to install properly, BULL it was much closer to 9GB (OK, 8.75 to be exact). You end up installing WEB forms, graphics, reports, and the cache DB even though your not going to use them. We were told the install and initial configuration would only take half a day, it took that long just to read in the CD's and in actually took the better part of 16 hours with configuration going on into a third 8 hour time period. What a pile of BLOATware, YUCK!! Next the locator process intermittently died for no apparent reason. There was no core dump, or other indication that something odd had happen the log file was less than helpful it turns out. Actually pointed us in the WRONG direction. According to the log we were having a semaphore problem when in truth it turned into a semaphore set problem. This thing LOVES doing IPC's. Next we had a problem with browsers. The company 'standard' is MicroSlop IE 5.0. Suppose to work, WRONG!! The only machine that would run Discoverer was a brand new one with ME and IE 5.51 or something like that, and then it wasn't exactly sure it wanted to go!! This one appears to be a JVM issue (MS does not like SUN on which Oracle's Java implementations is based), but MetaLink has a pointer to an article on 'How to use JInitiator with IE 5.x', but for some reason it has not been 'published' yet so you get an 'document is unavailable' message. The product did work with Netscape 4.61 and beyond but it was SLOW to startup. After that the interface being a 'navigation tree' was so foreign to our users that they were totally disenchanted. The 'last straw' was the admin edition where you had to map all of the tables, etc.. into the end user layer. Doing certain common tasks, although possible, was not intuitive (like sub queries). The great part was that it did use the referential integrity to self join tables, warned when you created a Cartesian query but let you run it anyway, and it has a damn good query predictor that gets smarter as time (read than as number of executions of the query) passes. What Oracle needs to do here is: 1) Support the MicroSlop browsers most likely by getting that article published. 2) Train their sales folks, they were going through the first install right along with us!! 3) Cut out the bloat. There is no reason for all the other stuff if all you want is Discoverer. 4) Figure out what the 'real' numbers are for disk and semaphore sets and publish them. 5) Put back that ability to use the native dictionary as well as the EUL. That was the way it was in Discoverer 2000, why the change? 6) Get rid of that 'navigation tree' in favor of the graphical table layout diagram. 7) Let end users edit their SQL. Easiest way to insert sub queries there ever was. 8) Improve the graphics capabilities, their a little primitive in the current version. In the end, when we told them we had decided against Discoverer 3000 they were not suprised. Dick Goulet Reply Separator Author: David Wagoner [EMAIL PROTECTED] Date: 10/29/2001 10:52 AM Dick, Can you elaborate a little on the instability of Oracle Discoverer 3000 with Oracle 9i database? I was planning to investigate Discoverer as an end-user reporting/query tool sometime soon. We have Oracle 8i and 9i databases. I just heard that Discoverer is an HTML-based data query tool for end-users. TIA, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may
RE: Instance Name in Sql Prompt
Add the following to your login.sql or glogin.sql file: set serveroutput on set termout off column instance new_value prompt_instance select substr(instance_name, 1, 10)instance from v$instance / set sqlprompt prompt_instance set termout on HTH, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: Ramon Estevez [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Subject: Instance Name in Sql Prompt Hi Friends, Excuse me for this dumb question, how do I display the instance name in the sql prompt. Have 3 DB and would like to know to which one I am connected. I mean something like that. DBA1 DBA2 DB01 Regards, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
RE: To Users of 9i
We've been using 9i in production since August 20, 2001 on *one* of our databases. So far, we are happy with it and haven't had any recurring problems. However, that database doesn't require many of the new 9i features that could be bug-prone, so we have the advantage of gradual implementation of new features as they are time-tested. Here are my recommendations based on our short experience: 1. Be prepared to read several pounds of documentation, most importantly the Migration Guide. 2. Research the known 9i bugs and issues on MetaLink and the Oracle-L list: a. Be sure to read the MetaLink doc on the upgrade/install bug. You have to set a parameter in init.ora before installation and then remove it afterwards. b. We decided not to use the new Undo Tablespace feature of 9i based on a posting on this list in which someone encountered a corrupted Undo tablespace and had serious problems. Still using Rollback Segments until the Undo TS is more robust. c. Someone reported corruption during export of a tablespace that used Label Security. 3. Say goodbye to Server Manager, say hello to logging in as USER as sysdba instead. 4. The 8.1.7 version of OEM that runs on Windows doesn't work with 9i databases, although the new OEM for Windows release is scheduled for today (25-SEP-01) according to Oracle. Apparently, this is not an issue for OEM running on Solaris. Anyone else have anything to contribute to this list of 9i problems? david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0755 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Monday, September 24, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Friends : Does anyone use the 9i database ? Are you happy using it ? Is it running ok ? What kind of problem does it have ? Bugs ? What do you think putting it in production environment ? Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: David Wagoner 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: Physical access to servers for maintenance
Our servers are located in a commercial IDC (Internet Data Center) that has tight security. The DBAs do not have access to the building, only a select few Sys. Admins. So, we just give the Oracle CDs to a Sys. Admin. and have him copy the contents of the multiple install CDs to the hard drive and then we can run the complete install without swapping CDs. There are instructions for doing this in the 9i documentation. david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Tuesday, September 25, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner 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).
Best Uses for Oracle Designer 2000?
Is anyone out there deriving much benefit from Oracle Designer 2000? My company has the product and I set it up but it looks like the initial investment in learning the product and creating everything in the repository will be extremely time-consuming. So, please tell me your favorite uses for Designer. Thanks, David David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
Scripts for Rebuilding Indexes Nightly on Solaris
Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that theyd be willing to share? Also, in your experience is it better to run this through UNIX cron jobs than using the Oracle OEM job scheduler? I suspect the cron job will be the favorable answer. Thanks in advance, David Wagoner Oracle DBA
RE: Scripts for Rebuilding Indexes Nightly on Solaris
Thanks for the tips and scripts! David Wagoner Oracle DBA -Original Message- Sent: Thursday, September 06, 2001 1:33 PM To: Multiple recipients of list ORACLE-L David - Use cron. Nightly might be excessive. Kick off a shell script (remember that cron executes as root, so you need to set your environment) and create your own script dynamically (following code is use for backups also) in a manner like: rebuild_index.sh #!/bin/ksh export PATH=$PATH:/u001/app/oracle/product/8.1.7/bin export ORACLE_SID=ifas export PATH=$PATH:/$ORACLE_HOME/bin export ORACLE_HOME=/u001/app/oracle/product/8.1.7 export ORACLE_BASE=/u001/app/oracle sqlplus either use a password protection scheme or hardcode your access here username/password @/usr/local/bin/rebuild_index exit rebuild_index.sql spool rebuild_index.sql Select 'Alter index ' || index_name || ' rebuild;' from dba_indexes; # add selection caveats if desired spool off !chmod 777 /u014/oradata/ifastrn/rebuild_index.sql @/u014/oradata/ifastrn/rebuild_index exit Lots of variations possible. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Kimberly Smith [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] jitsu.com cc: Sent by: Subject: RE: Scripts for Rebuilding Indexes Nightly on Solaris [EMAIL PROTECTED] 09/06/2001 11:57 AM Please respond to ORACLE-L Nightly? That is a lot. Are you really entering that much data on a daily basis? -Original Message- From: David Wagoner [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 8:57 AM To: Multiple recipients of list ORACLE-L Subject: Scripts for Rebuilding Indexes Nightly on Solaris Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that they'd be willing to share? Also, in your experience is it better to run this through UNIX cron jobs than using the Oracle OEM job scheduler? I suspect the cron job will be the favorable answer. Thanks in advance, David Wagoner Oracle DBA -- 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: David Wagoner 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 policy?
PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Miller, Jay 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: Kevin Kostyszyn 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: Paul Drake 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: Kevin Kostyszyn 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: David Wagoner 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 policy?
practise the recipient should ensure that they are actually virus free. ** ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Marsden 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: Ron Rogers 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: Miller, Jay 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: Kevin Kostyszyn 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: Paul Drake 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: Kevin Kostyszyn 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: David Wagoner 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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: database upgrade policy?
We were running 8.1.6.0.0 and just recently encountered the ORA-7445 errors, which caused core dumps and invalidated the referential integrity of our database. Oracle recommended the 8.1.6.3 patchset. We decided to skip that and go for 8.1.7 but for some reason Oracle mailed us the 9i CDs. I guess they are pushing it on everyone now. Anyway, we are in the process of upgrading our test databases to 9i (using Sun SPARC Solaris 8). If all is well we will upgrade production to 9i. David Wagoner Oracle DBA -Original Message- Sent: Wednesday, August 22, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi Listers I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) as I get the occasional ORA-600/ORA-7445. Do you upgrade to the latest subversion as a matter of policy (and not test very much) to prevent possible errors or only upgrade if you have problems? Do you upgrade to major versions (7 to 8.0 to 8.1) for increased functionality, cos Oracle are desupporting (the main reason we upgrade) or to improve the CV ;-) with the possible downside of instability. Mark. Hyde Housing Association - Email Disclaimer The information in this email is strictly confidential and may be legally privileged. It is intended solely for the addressee only. Access to this email by anyone else is unauthorised. If you are not the intended recipient and you have recieved this email in error you must take no action on its contents, nor must you copy or show them to anyone, or make use of the information therein. Please reply to the email immediately, or forward to [EMAIL PROTECTED], highlighting the error and confirming that it has been deleted from your system. SECURITY WARNING: Please note that this email has been created with the knowledge that the Internet is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. VIRUSES: Although we have taken steps to ensure that this email and attachments are free from any virus, we advise that in keeping with good computing practise the recipient should ensure that they are actually virus free. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Marsden 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: David Wagoner 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).
Simultaneously Patch Multiple DBs on same Server?
Hi, I plan to install an Oracle patchset (from 8.1.6.0.0 to 8.1.6.3.0) on a server that has four databases and Im wondering if I have to run the patch 4 times or is there a way to make it update all 4 SIDs simultaneously? Anyone have similar experiences? TIA, David Wagoner Oracle DBA
RE: Simultaneously Patch Multiple DBs on same Server?
Thanks to those of you who emailed me offline. Best, david -Original Message- From: David Wagoner Sent: Tuesday, August 14, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Subject: Simultaneously Patch Multiple DBs on same Server? Hi, I plan to install an Oracle patchset (from 8.1.6.0.0 to 8.1.6.3.0) on a server that has four databases and Im wondering if I have to run the patch 4 times or is there a way to make it update all 4 SIDs simultaneously? Anyone have similar experiences? TIA, David Wagoner Oracle DBA
RE: Designer 2000 install on Linux
Yeah, Oracle Designer runs on Win NT/98. Search Metalink for Oracle Designer install and you'll see some relevant docs. David B. Wagoner Database Administrator -Original Message- Sent: Wednesday, August 08, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Hello everyone. I am in need of some advise. I have a class that is requiring that I install Oracle Designer 2000. The class provides Designer 2000 for windows with the book Rapid Applications Development with Oracle Designer 2000 Billings, Chris / Billings, Maria / Tower, Julia. The problem is that I have Oracle 8i Enterprise Edition loaded on a Redhat 6.2 Linux box. I need to know where I can download designer 2000 for Linux and if anyone has done this install I would greatly appreciate any advice or direction anyone can give me. Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Hedger 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: David Wagoner 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: sqlloader stops
Just a stab here... Check the .bad files to see if you are getting any data rows kicked out due to errors. If so, you might be exceeding the ERRORS parameter by the time you finish the third file. HTH. David Wagoner DBA -Original Message- Sent: Tuesday, August 07, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- 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: David Wagoner 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).
SQL*Loader question- Transforming Data
Im using SQL*Loader to populate a database table with transaction records. The data file contains some transactions that I want to exclude from the load and they all contain the same text string, something like xxx,yyy,FLAG_TEXT,xxx,yyy. Can I use a SQL statement in the SQL*Loader control file to filter out those transactions? Something that functions like this pseudocode: if field like %FLAG_TEXT% then null; else load; Ive been reading the new Oracle SQL*Loader book by Gennick and Mishra which is a good book, but Im still uncertain about this. Thanks, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.
RE: SQL*Loader question- Transforming Data
Thanks for the tips on the 'when' clause. I guess my dilemma is that my FLAG_TEXT is not the only part of the field I want to filter on. For example, let's say I want to filter out all the transactions containing the word UNIX. aaa,bbb,UNIX45689-2,ccc,ddd In this case, I cannot use the 'when' clause like: when (field 'UNIX') I would need something equivalent to the SQL convention of not like 'UNIX%' with the % wildcard. It appears that the 'when' clause is very limited in this respect. Any suggestions on filtering out part of the text string? TIA, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Monday, July 30, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Hello David, You need to use the WHEN clause. Look at the example in the middle of page 147. If an input record doesn't match the conditions you specify following WHEN, it simply isn't loaded. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Monday, July 30, 2001, 2:56:22 PM, you wrote: DW I'm using SQL*Loader to populate a database table with transaction records. DW The data file contains some transactions that I want to exclude from the DW load and they all contain the same text string, something like DW xxx,yyy,FLAG_TEXT,xxx,yyy. Can I use a SQL statement in the SQL*Loader DW control file to filter out those transactions? Something that functions DW like this pseudocode: DW if field like '%FLAG_TEXT%' then null; DW else load; DW I've been reading the new Oracle SQL*Loader book by Gennick and Mishra which DW is a good book, but I'm still uncertain about this. DW Thanks, DW David B. Wagoner DW Database Administrator DW Arsenal Digital Solutions Worldwide Inc. DW 4815 Emperor Blvd., Suite 110 DW Durham, NC 27703 DW Tel. (919) 941-4645 DW Fax (919) 474-0695 DW Email mailto:[EMAIL PROTECTED] DW mailto:[EMAIL PROTECTED] DW Web http://www.arsenaldigital.com/ http://www.arsenaldigital.com/ DW *** NOTICE *** DW This e-mail message is confidential, intended only for the named DW recipient(s) above and may contain information that is privileged, work DW product or exempt from disclosure under applicable law. If you have DW received this message in error, or are not the named recipient(s), please DW immediately notify the sender at (919) 941-4645 and delete this e-mail DW message from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: David Wagoner 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: Data load options
You can use Materialized Views in Oracle 8i to load data from one database to another (via the DB link) either manually or at scheduled intervals. David David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- 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: David Wagoner 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: [Q] does Personal ORACLE 8.1.7 support Win98?
I had the same problem- my Personal Oracle 8.1.7 installation hung up during creation of the test database on Win98. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: ef 8454 [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 8:11 AM To: Multiple recipients of list ORACLE-L Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? the problem are: 1. it did not create DB. 2. no lsnrctl.exe Thanks. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? Date: Thu, 19 Jul 2001 05:40:43 -0800 Yes it is. I have it installed and it works fine. What problems are you havging Rick -- 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). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 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).