RE: Form question
gracias Ofer -Original Message- Sent: Monday, June 09, 2003 7:50 PM To: Multiple recipients of list ORACLE-L bell ; Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Saturday, June 07, 2003 11:44 PM To: Multiple recipients of list ORACLE-L Good morning, This a question for Oracle form and report I want to add a beep or sound to a form when a certain action occurs, e.g., result of a query. How can I make a beep (or sound) from within an Oracle Form. thanking you in advance Ofer Harel DBA team Barak ITC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ofer Harel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ofer Harel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ORA600 [2103] [0] [0] [1] [900] -- Wrapping up
Dear All, ThAnks for all your comments and advise. We have found what was the cause of this. Just before we put tablespaces in hot backup mode we mount some nfs drives. Then having placed the tbs in hot backup we use a cp command to copy the *.dbf files to nfs. Also the copy of the controlfile binary is also put to nfs. As you might have guessed the NFS drive caused the error due to some delays. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Sunday, June 15, 2003 7:19 PM To: Multiple recipients of list ORACLE-L So, did you get the same error when writing the backup to /tmp as well ? And also if you delete the previous backup and create a backup without the REUSE ? If the problem is really a Control File Enqueue timeout, is the server really that busy ? How about trying the controlfile backup at a time when the server is less busy --- to verify the busyness being the cause of the Control File Enqueue Hemant At 11:44 PM 12-06-03 -0800, you wrote: It is a local filesystem Kind Regards, Hatzistavrou Yannis -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA600 [2103] [0] [0] [1] [900] 1. Try writing the backup to another location alter database backup controlfile to '/tmp/cntrlfilebk.dbf' 2. Try it again with the reuse clause 3. Is the file system '/hot_backup/siebelp1' local or NFS mounted ? Hemant At 02:45 AM 12-06-03 -0800, you wrote: Dear All, I have encountered the following message during alter database backup controlfile to reuse after a hot backup. We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which according to what I have read resolved this problem. Another strange fact is that this happened concurrently on three clusters of Sun Solaris 8. Attached please find extracts from alert and trace files a) alert hread 1 advanced to log sequence 41062 Thu Jun 12 02:33:43 2003 ARC1: Beginning to archive log# 1 seq# 41061 Thu Jun 12 02:33:43 2003 Current log# 2 seq# 41062 mem# 0: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2A.log Current log# 2 seq# 41062 mem# 1: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2B.log Thu Jun 12 02:33:44 2003 Completed: alter database backup controlfile to trace Thu Jun 12 02:33:44 2003 alter database backup controlfile to '/hot_backup/siebelp1/control01.bak' reuse Thu Jun 12 02:49:10 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 ARC1: terminating instance due to error 600 Instance terminated by ARC1, pid = 16563 Thu Jun 12 02:49:47 2003 Starting ORACLE instance (normal) b) trace Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production ORACLE_HOME = /oracle_home/product/8.1.7 System name:SunOS Node name: apps01-n01 Release:5.8 Version:Generic_108528-21 Machine:sun4u Instance name: siebelp1 Redo thread mounted by this instance: 1 Oracle process number: 21 Unix process pid: 16563, image: [EMAIL PROTECTED] (ARC1) *** 2003-06-12 02:49:08.500 *** SESSION ID:(137.947) 2003-06-12 02:49:08.463 TIMEOUT ON CONTROL FILE ENQUEUE mode=X, type=0, wait=1, eqt=900 === SYSTEM STATE System global information: Number of NUMA instances : 1 processes: base 9010fe44, size 250, cleanup 90110864 allocation: free sessions(0) 90174724, free calls(0) 1 control alloc errors: 0 (process), 0 (session), 0 (call) system statistics: 0 47997 logons cumulative 0 1052 logons current 01649040 opened cursors cumulative 0 41528 opened cursors current 01311839 user commits 0 7201 user rollbacks 0 30519546 user calls 0 22909587 recursive calls 01827715 recursive cpu usage 0 1553098488 session logical reads 0 0 session stored procedure space 06209740 CPU used when call started 0 143359357 CPU used by this session 8236 791247589 session connect time 8236 791247589 process last non-idle time 1020 304666384 session uga memory Has anybody encountered such problem before? How can it be resolved? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema
WG: RedHat AS Dev edition
-Ursprüngliche Nachricht- Von: Kulev, Milen Gesendet: Dienstag, 17. Juni 2003 00:39 An: Multiple recipients of list ORACLE-L Betreff: AW: RedHat AS Dev edition Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to stop script
Hi Chen, My solution will be about the same with previous DBA guru I assume u r using Window (if is unix you just need to change a little bit here and there) I write this script for you. +save as imp.sql++ SET HEAD OFF SET FEEBACK OFF SET PAUSE OFF SET VERIFY OFF SET LINESIZE 250 SPOOL 'C:\temp\~dynamic_imp.bat' SELECT 'imp username/password@' || name || ' full=y file=bla bla other parameter=bla bla bla log=mypath\log' from v$database where name = 'TEST'; SPOOL OFF -- host chmod u+x C:\temp\~dynamic_imp.bat (if you using unix this will prevent you from bug cause by your umask) -- host C:\temp\~dynamic_imp.bat-- uncomment this if you ready to do the import -- host del C:\temp\~dynamic_imp.bat-- uncomment this if your C:\temp\~dynamic_imp.bat is look ok ++= +save as imp.bat*** sqlplus -s someone_can_do_select_v$database/[EMAIL PROTECTED] +++ You can add alot of fancy stuffs but the concept is about like that Sinardy -Original Message- Sent: 17 June 2003 12:39 To: Multiple recipients of list ORACLE-L I have a script and can be run on commandline like: sqlplus usrname/password@TEST @import.sql However, I want to check database name at the beginning of import.sql. I knew select name from v$database can obtain database name. But how can I stop the script if I found it is not TEST database? In import.sql, it is like: drop user A cascade; create user A ; host imp A/[EMAIL PROTECTED] file=a.dmp full=yes; // some PL/SQL ... Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDBC and MTS
On 2003.06.17 01:04, Richard Ji wrote: I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Yes it is. Application server is a Solaris8 box (SUN 450). -- Mladen Gogala Oracle DBA -- 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).
RE: JDBC and MTS
Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDBC and MTS
OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
RE: RedHat AS Dev edition
I ordered a copy 4 weeks ago, never received it. Red Hat, USPS, or Canada Post? I'll wait a couple more weeks... Patrice (Canada) -Original Message- Sent: Monday, June 16, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Boivin, Patrice 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).
Re: AW: RedHat AS Dev edition still available today
Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron [EMAIL PROTECTED] 06/16/03 06:39PM Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: JDBC and MTS
Mladen - I'll add what I know, but it won't add much. When the Java people say they are doing connection pooling, that almost certainly means they are using an application server. This is the beast on which to focus your attention. Start by finding out which species it is. There are in my experience, a variety of settings related to AS connection pooling. It is easy to get those settings wrong, which can produce a variety of bad effects on the database end. They can create too many sessions, or too few. In my simple view, MTS and connection pooling do the same thing. I don't use MTS, so I'm assuming here. But I can see that using both MTS and connection pooling at the same time might produce bad effects. The other thing to remember about the thin client is that it does not use Net8. It does not rely on a tnsnames.ora file on the client (application server in this case). It connects directly to the listener. One possibility to test would be to switch to the thick client. That may be better in your situation. Good luck and keep us posted. We DBAs are all facing this webbified/Javafied/.netified world and we've got to stick together. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 7:25 AM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
recreating a create database file
Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: JDBC and MTS
Mladen, I've found MTS to be a blessing and a curse at the same time no matter what language (C, ASP, JAVA, etc...) is being used. The biggest problem with MTS is the number of idle shared servers that you have at any point in time. When you connection request is processed by the database server any statements that need execution land in the shared pool's request queue. If you have say 100 connections on the database with 10 shared servers it only takes a 10% population of active users to exhaust your pool. Yes Oracle will start additional servers up to MTS_MAX_SERVERS but don't expect it to respond rapidly. More like a snail that a rocket. You've got two options that I can safely recommend: 1) configure MTS_MAX_SERVERS = MTS_MIN_SERVERS = the maximum number of anticipated connections. 2) configure MTS_MAX_SERVERS = 2X MTS_MIN_SERVERS = 75% of the maximum number of anticipated connections Option 3 is more fluid, but also takes more effort to maintain the desired performance. It means programming a process or job that will occasionally wake up, evaluate the load on the database's shared server population alter the mts_servers setting of the database dynamically. It can be done, I do it, and is very successful. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Retreiving data from SQL Server
Can anyone give me an example of an SQL statement that will retrieve data from SQL Server. What is the best way to do this? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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: JDBC and MTS
We add: 1. Application (Java) Using a JDBC Connection Pooling (CP)feature... 2. Database Oracle in MTS, pooling or not pooling enabled This was not good for us...so we kept the Java pooling side of the app and Oracle configured to run in dedicated mode. We'got a XML policy file which disables JDBC connection pooling for our application and gives the DBA a choice to configure a MTS... So in our case we two scenarios: 1. DB(MTS) and app(without CP) this is OK 2. DB(dedicated) and app(with CP) Regis -Original Message- Sent: Tuesday, June 17, 2003 1:25 PM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as
RE: asking your opinion
With a standby database, either physical or logical (Oracle 9i) you get a failower machine, typically much smaller then the original one. The problem is that there isn't much else you can do on that machine. In case of a logical standby, you can use it as a report server, but then again, you are duplicating your disks and storing the same database in two different places. It is much easier to administer then RAC because you don't have DLM to contend with and hardwarewise, it is cheaper (no clustering software, no high speed interconnects no RAC licenses). With RAC, you get much more. You get several nodes accessing the same database, thus providing you with the transparent failover and much greater survivability of the database. Also, you can use all nodes of a RAC configuration for transactions. With RAC, nodes ship to each other the current version of a block as well as the read consistent images of a block (constructed from rollback segments) so partitioning the application functionally is no longer necessary. Also, your database is not stored in two different places, so there is no problem with the consistency. As for one or more databases, it depends on your budget and your business needs. The most survivable configuration would include a central RAC database and smaller departmental RAC databases which would deliver the data to the central database by using multimastering replication.That would also include something like BCV database to have up as a readonly copy during maintenance times. Now we're talking eight figures. The business has to take a good look at itself and decide which data absolutely must survive and which data can be temporarily offline in order for the business to survive. There is a known story about the WTC branch office of Chase Manhattan, which was switched to a remote copy and which didn't lose a single transaction despite the fact that the branch office itself was completely destroyed. That kind of survivability costs money and business must decide whether it needs it or not. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 12:15 AM To: Multiple recipients of list ORACLE-L Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more unit as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? I am new to this area, I would appreciate any input informantion. Thanks again, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: JDBC and MTS
Refer to Note:139775.1 - see if this helps out - basically it says to configure the jdbc driver so that it has to use dedicated server - using MTS is the problem. [EMAIL PROTECTED] 6/17/2003 7:24:50 AM OK. Let me get some things straight:a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone.b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection.c) What was the issue that you faced? That was my original question.On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string "SRVR=DEDICATED" has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
IOUG Live 2003
Title: IOUG Live 2003 Does anyone know when we (we-couldn't-go-to-conference types) get access to conference papers or download them? I had sent an email to address on homepage, but it has been only 2+ weeks of no reply. TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: recreating a create database file
Do you need the CREATE DATABASE ... script or the scripts to create all the database objects. If it's the latter and you have an export, import that into an IFILE and remove all the REMs. That should give you the tablespaces, tables, and indexes. You'll have to do some manual formatting. Ruth Gramolini rgramolini To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tax.state.vt.us cc: Subject: recreating a create database file Sent by: ml-errors 06/17/2003 10:09 AM Please respond to ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Retreiving data from SQL Server
You must put double quotes around column names in select and where clauses and it is VERY case sensitive. Note the following query; select concontainer from [EMAIL PROTECTED] where conID = 1; if you tried this with the field of conid it would fail. It's a pain in the butt that is how it works. Be sure to look at the table structures on SQL Server to get the proper case of the field names. Hope this helps. Dave -Original Message- Sent: Tuesday, June 17, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Can anyone give me an example of an SQL statement that will retrieve data from SQL Server. What is the best way to do this? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AQ, RAC and delay
Title: AQ, RAC and delay A colleague casually mentioned that in RAC, the test to de-queue an AQ set-up from BOTH instances didn't succeed. The side where we were enqueuing was able to see queued messages faster than the 'other' side. About 7-8 seconds ... that got me thinking ... is this an effect of MCPD which defaults to like 7 seconds? Do you use AQ in RAC and enqueue/dequeue on both nodes? What is your experience? ps: mcpd - max commit propagation delay TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: exchange partition in 9.2
Arup and Jacques: thanks for your help. The command we are executing is alter table exchange partition ... with table .. include indexes. We have also a PK on each of the tables (local index on a partitioned table). Go global indices. We have tried the same command with novalidate and the results were the same. Any thougths? --- Jacques Kilchoer [EMAIL PROTECTED] wrote: Did you say alter table exchange partition ... validate or alter table exchange partition ... novalidate? If you say novalidate then Oracle will sort the exchange table to make sure that you are not creating duplicate rows for the PK constraint. There is a Metalink note on that. Does the table have a PK enforced by a locally partitioned unique index? Any global indexes? What options did you have on the exchange partition statement? -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] We are having an interesting issue with the exchange partition command in our shop. We are running oracle 9202 on AIX 5l. The exchange partition command used to take about 1 sec (or less) in our old environmen (oracle 81 Dynix 4.3.3). Now the same operation takes about a minute and creates a ton of IO. an Oracle rep said that this has to do something with the way exchange partition now treats primary and unique keys. Recently however a DBA on my team did 4 exchanges in a row between the same two tables. First one took about 45s and did a lot of IO. next one took almost no time and no IO (and it did move the data), the next one - again 45s and IOs, the fourth one - no time again. Does any one has any experience with this issue and may be can shed some light on it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: asking your opinion
See comments below RF Robert G. Freeman Consultant - TUSC www.tusc.com One browser to rule them all, one browser to find them, One browser to bring them all and into the darkness bind them In the land of Redmond where the shadows lie. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/16/2003 11:14 PM Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more unit as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? You are asking the question without yet really providing the requirements. The standby database (logical or physical) is there to meet disaster recovery requirements, *NOT* HA requirements. It's need is defined by your SLA's with regards to how much down time can I have, do I need a remote site, do I need to be able to revert to a previous image of my database, etc...etc... For some environments, offsite backups are perfectly satisfactory in this regard, at other sites, you have a hot offsite location, where you run dataguard (standby). So, you need to define your needs before you ask the question. Specifically regarding logical standby databases, they are a great idea but in my mind they are still new enough (and I've seen a bugs enough) that I don't trust them yet for mission critical application failover. I might consent to using one in combination with at least one physical standby if needs and resources allowed. Still, for right now, if my requirements dictated a standby database, I'd go physical. RAC, OTOH, is there to meet HA requirements, not DR requirements (unless you can configure a long distance RAC cluster which I have yet to see work really well yet). RAC is an added cost option to Oracle, with it's own set of headaches that may or may not be worth your time and money. Again, it depends on your needs, budget and SLA's. If you need four 9's uptime, then RAC may well be the way to go. If you have a rather stable system, and your users can stand an outage, then perhaps you do not need RAC. Again, you must define the requirements first, then look for the solutions. question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? My personal rule about this is that if a given application is going to largely share data with another existing application, and there are no good reasons to separate them into their own databases (for example wildly different SLA's with regards to HA or DR), then I will simply use the same database. This avoids problems with disparate data issues (and saves a bit of memory and CPU). However if the application is self-contained, or if it uses data feeds from several systems (which is much more frequent in my experience) then it goes into it's own database and we have to decide how we are going to feed it data. HTH!!! Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone successfully installed 9ias on AIX 4.3.3 ?
Hi list, Is there someone out there who successfully installed 9ias (9.0.2.0.1) on AIX 4.3.3 ? If yes, were you able to meet all the pre-requisites (OS patches, java version, ...) ? My installation fails in the configuration tools (dbca). I always get a Lost contact message. My sys admin could not get his hands on some OS patches (vacpp.dax.adt, vacpp.vb.adt) and our java version is newer than the one listed in the pre-requisites (we have build ca131-20021102 instead of cal131-20020821). Any ideas ??? Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Retreiving data from SQL Server
Dave, You also need to put double quotes around table names as they conform to the same rules as columns. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 17, 2003 10:55 AM To: Multiple recipients of list ORACLE-L You must put double quotes around column names in select and where clauses and it is VERY case sensitive. Note the following query; select concontainer from [EMAIL PROTECTED] where conID = 1; if you tried this with the field of conid it would fail. It's a pain in the butt that is how it works. Be sure to look at the table structures on SQL Server to get the proper case of the field names. Hope this helps. Dave -Original Message- Sent: Tuesday, June 17, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Can anyone give me an example of an SQL statement that will retrieve data from SQL Server. What is the best way to do this? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to stop script
Hi
You can stop the script by using the line
whenever sqlerror exit rollback
and then generating an error by using an exception in a PL/SQL block as
follows:
oracle:jupiter cat imp.sql
whenever sqlerror exit rollback
declare
cursor c_db is
select name from v$database;
lv_db c_db%rowtype;
no_database exception;
wrong_database exception;
pragma exception_init(no_database,-5101);
pragma exception_init(wrong_database,-5102);
begin
open c_db;
fetch c_db into lv_db;
if c_db%notfound then
close c_db;
raise no_database;
else
if lv_db.name'TEST' then
close c_db;
raise wrong_database;
end if;
end if;
close c_db;
dbms_output.put_line('Running on database : '||lv_db.name);
exception
when no_database then
dbms_output.put_line('ERROR: could not find database');
raise_application_error(-20100,'ERROR - no database');
when wrong_database then
dbms_output.put_line('ERROR: wrong database');
raise_application_error(-20101,'ERROR - wrong
database');
when others then
dbms_output.put_line('ERROR: unknown error');
raise_application_error(-20101,'ERROR - unknown error');
end;
/
select user from sys.dual;
-- end of script imp.sql
then run it as follows
SQL @imp
declare
*
ERROR at line 1:
ORA-20101: ERROR - wrong database
ORA-06512: at line 29
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 -
Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
oracle:jupiter
i added the select user from sys.dual to show the script stops
processing.
hope this helps
kind regards
Pete
However, I want to check database name at the beginning of import.sql. I knew
select name from v$database can obtain database name. But how can I stop the
script if I found it is not TEST database? In import.sql, it is like:
drop user A cascade;
create user A ;
host imp A/[EMAIL PROTECTED] file=a.dmp full=yes;
// some PL/SQL ...
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: recreating a create database file
Maybe not exactly what you are looking for, but Start the GUI DBCA (NO don't shoot), go through the all the motions and at the end choose generate scripts only. Jack -Original Message- Sent: Tuesday, June 17, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: recreating a create database file
I got the answer, thanks anyway. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:09 AM Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: recreating a create database file
Ruth, If you have the DataBee tool (available free ) http://www.cool-tools.co.uk You can take an export and then the commands are available to recreate your tables and tablespaces. Ron [EMAIL PROTECTED] 06/17/03 10:59AM Do you need the CREATE DATABASE ... script or the scripts to create all the database objects. If it's the latter and you have an export, import that into an IFILE and remove all the REMs. That should give you the tablespaces, tables, and indexes. You'll have to do some manual formatting. Ruth Gramolini rgramolini To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tax.state.vt.us cc: Subject: recreating a create database file Sent by: ml-errors 06/17/2003 10:09 AM Please respond to ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recreating a create database file
Well ... here is some generic stuff for you to edit. This is from 8.1.x,
but I think it will still (with an edit or two) get you a running database
in 9.2.x
connect / as sysdba
startup nomount
create database CRCT2
maxinstances 8
maxlogfiles 32
character set US7ASCII
datafile
'/u09/oradata/CRCT2/system_01.dbf' size 200M
logfile
GROUP 1
('/z01/oradata/CRCT2/redo_01a.log'
,'/z02/oradata/CRCT2/redo_01b.log') size 50M
, GROUP 2
('/z01/oradata/CRCT2/redo_02a.log'
,'/z02/oradata/CRCT2/redo_02b.log') size 50M
, GROUP 3
('/z01/oradata/CRCT2/redo_03a.log'
,'/z02/oradata/CRCT2/redo_03b.log') size 50M
, GROUP 4
('/z01/oradata/CRCT2/redo_04a.log'
,'/z02/oradata/CRCT2/redo_04b.log') size 50M
;
--
connect / as sysdba
REM * add or subtract to the following as desired
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catparr.sql
@?/rdbms/admin/catrep.sql
@?/rdbms/admin/utlrp.sql
REM * Create additional rollback segment in SYSTEM before creating
tablespace.
REM *
connect / as sysdba
REM * Need a non-system rollback segment for a while.
create rollback segment r0 tablespace system
storage (initial 16k next 16k minextents 2 maxextents 20);
alter rollback segment r0 online;
REM * Create a tablespace for rollback segments.
create tablespace RBS datafile
'/u09/oradata/CRCT2/rbs_01.dbf' size 1000M
default storage (
initial 1M
next 1M
pctincrease0
minextents 20
maxextents unlimited
);
REM * Create a tablespace for temporary segments.
create tablespace TEMP datafile
'/u09/oradata/CRCT2/temp_01.dbf' size 1000M
default storage (
initial 1M
next1M
pctincrease 0
minextents 1
maxextents unlimited
)
TEMPORARY;
REM * Create a tablespace for database tools.
create tablespace TOOLS datafile
'/u09/oradata/CRCT2/tools_01.dbf' size 200M
default storage (
initial 16k
next 16k
pctincrease 0
minextents 1
maxextents unlimited
);
REM * Create a tablespace for miscellaneous database user activity.
create tablespace USERS datafile
'/u09/oradata/CRCT2/user_01.dbf' size 100M
default storage (
initial 16k
next 16k
pctincrease 0
minextents 1
maxextents unlimited
);
REM * Create rollback segments.
create rollback segment r01 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
create rollback segment r02 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
create rollback segment r03 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
create rollback segment r04 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
REM * Since we've created and brought online more rollback segments,
REM * we no longer need the rollback segment in the SYSTEM tablespace.
alter rollback segment r0 offline;
drop rollback segment r0;
alter user sys identified by yeehaa;
alter user system identified by yeehaa;
REM
--
REM Run the following from SQLPLUS
REM connect system/yeehaa
REM @/oracle/app/oracle/product/8.1.7/sqlplus/admin/pupbld.sql
REM alter user sys temporary tablespace temp;
REM alter user system default tablespace tools temporary tablespace temp;
REM alter user dbsnmp default tablespace tools temporary tablespace temp;
REM alter user outln default tablespace tools temporary tablespace temp;
REM grant sysoper,sysdba to system;
REM grant sysoper,sysdba to sys;
REM alter user dbsnmp identified by yeehaa;
REM alter user outln identified by yeehaa;
REM
--
-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Subject: recreating a create database file
Good morning all,
Somehow all of my scripts to create the databases on my 9i
sandbox have
disappeared. Does anyone have a script or trick or something
to recreate
these files? I could recreate them manually but I am
somewhat of a time
crunch.
Thanks in advance,
Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Re: AW: RedHat AS Dev edition
Just musing but... Are'nt Oracle and Red Hat missing a great opportunity here on building more momentum for Oracle on Linux especially RAC? Why charge anything for the Dev of AS edtition? Missed opportunities... mohammed --- Kulev, Milen [EMAIL PROTECTED] wrote: Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? 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: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN FILESPERSET
You have the maxpiecesize set to 2048. It will fill the backup piece and
then start another. Have the datafile sized changed alot from one day to
the next?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 6:25 PM
I'm a bit confused by the default for filesperset. I ran the following
yesterday
run
{
allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup database;
backup current controlfile;
release channel c1;
}
There were 245 datafiles in the database. RMAN made the following backup
sets
BS_KEY COUNT(B.FILE#)
-- --
9623 63
9727 64
9810 64
9892 35
9893 4
9894 4
9895 6
9896 5
--
sum 245
As I understand it the default for filesperset is the lesser of 64 or the
number of input files / the number of channels.
As there was only one channel I would have expected 3 backup sets of 64
files and one of 53 channels.
Today I ran against the same target database
run
{
allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
allocate channel c2 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup database skip readonly;
backup current controlfile;
release channel c1;
release channel c2;
}
There are 92 read write datafiles. I would have expected the job to be
divided into two backup sets with 46 files each.
Instead I got
BS_KEY COUNT(B.FILE#)
-- --
10704 2
10705 2
10721 2
10722 2
10723 2
10724 2
10725 2
10726 2
10727 2
10728 2
10765 33
10766 4
10767 2
10768 1
10769 1
10770 1
10771 1
10772 1
10773 1
10774 1
10775 1
10776 1
10777 1
10778 1
10779 1
10780 2
10781 1
10782 18
--
sum92
--
---
Any guesses as to why so many backup sets are being created.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
AW: JDBC and MTS
Hi Mladen We started evaluating MTS and JDBC Thin Driver (newest version for JDK 1.4, running on Win2k against a test db on win2k, test db is oracle 9.2.0.3.0). I never used SRVR=DEDICATED. I have a dispatcher running on port 5000 and a listener on port 1521. The only thing I do to direct the connection to either use MTS or dedicated server is setting the port it connects to to either 1521 or 5000. That works just fine. Stefan -Ursprüngliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 14:25 An: Multiple recipients of list ORACLE-L Betreff: Re: JDBC and MTS OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender
RE: recreating a create database file
Thanks Ron :) Mark Cool-Tools -Original Message- Ron Rogers Sent: 17 June 2003 17:10 To: Multiple recipients of list ORACLE-L Ruth, If you have the DataBee tool (available free ) http://www.cool-tools.co.uk You can take an export and then the commands are available to recreate your tables and tablespaces. Ron [EMAIL PROTECTED] 06/17/03 10:59AM Do you need the CREATE DATABASE ... script or the scripts to create all the database objects. If it's the latter and you have an export, import that into an IFILE and remove all the REMs. That should give you the tablespaces, tables, and indexes. You'll have to do some manual formatting. Ruth Gramolini rgramolini To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @tax.state.vt.us cc: Subject: recreating a create database file Sent by: ml-errors 06/17/2003 10:09 AM Please respond to ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
RE: JDBC and MTS
b) I use server=dedicated, is srvr=dedicate a short hand version of it? -Original Message- Sent: Tuesday, June 17, 2003 8:25 AM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
AW: JDBC and MTS
Hi Regis That's basically right. As I just posted, we use MTS for development, so that not every developer starts up a local connection pool on their workstation and we also don't end up with too many dedicated server processes. But I think you're right saying that MTS and application side connection pooling is pretty much redundant, if not even the source for trouble. a) the app server should start and monitor the connection pool. b) the client sessions (or app threads within the app server or whatever) request connections from that pool. c) important aspect here is the fact that the app server thinks that it maintains a pool of readily available, permanent connections. The clients (or whoever) will just be passed a reference to a certain connection. After they are finished with what they want to do, they put the connection back into the pool (plus some connection re-aquiring mechanism for dead clients and the like). d) That means, that with MTS, a new player shows up, as in the connections held in the connection pool are not permanent (or dedicated in oracle terms). That might lead to some latency while fetching a valid connection from the pool and using it, because when you actually start using it, you end up with some overhead since the dispatcher has to give you a connection. e) I don't know for sure, but has anybody ever testet some of the new features like sharing prepared statements between connections (and the possibility to tag a name to a statement for further information / statement fetching) with MTS ? So, I think it's either MTS OR Java Connection Pooling, not BOTH. Open for bashing, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Regis Biassala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 16:15 An: Multiple recipients of list ORACLE-L Betreff: RE: JDBC and MTS We add: 1. Application (Java) Using a JDBC Connection Pooling (CP)feature... 2. Database Oracle in MTS, pooling or not pooling enabled This was not good for us...so we kept the Java pooling side of the app and Oracle configured to run in dedicated mode. We'got a XML policy file which disables JDBC connection pooling for our application and gives the DBA a choice to configure a MTS... So in our case we two scenarios: 1. DB(MTS) and app(without CP) this is OK 2. DB(dedicated) and app(with CP) Regis -Original Message- Sent: Tuesday, June 17, 2003 1:25 PM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so
RE: recreating a create database file
I have it at home. It's a modified version of the script in Orac_Dba, concocted by Jared Still and Andy Duncan. You can get the script from CPAN and I'll send you my version when I get home. I've even sent it to Jared and Andy, but I don't have time to maintain Orac_Dba right now. May be Jared has it somewhere at hand. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recreating a create database file
Not sure if this was already mentioned. You can hack up the result of this: alter database backup controlfile to trace; into an exact replica of the create database statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 17 Jun 2003, Jack van Zanen wrote: Maybe not exactly what you are looking for, but Start the GUI DBCA (NO don't shoot), go through the all the motions and at the end choose generate scripts only. Jack -Original Message- Sent: Tuesday, June 17, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: RedHat AS Dev edition still available today THANK YOU Ron !
To Ron: Ron, your last link works !!! RH AS Dev Edition is already by me. Thank you very, VERY much for the help! BTW, according to one of the official RedHat resellers in Germany, Dev Edition was not avialable anymore (?! I haven't posted them the link yet;) ), because there were too many requests for updates ...NO comment. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 14:30 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition still available today Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron [EMAIL PROTECTED] 06/16/03 06:39PM Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: asking your opinion
If this is to be a web server kind of application then another possibility to consider: Transparent Application Failover (TAF) I think this works well with web applications where the data in the database(s) isn't constantly changing at a high rate. You have two or more independent databases that you keep in sync with replication. If one becomes unavailable, sqlnet will send the app to the other database. This is handled entirely by sqlnet and requires no specific coding in the application. One handy thing about this setup is that if one of the departments turns out to be a real database pig and needs to be put on its own machine(s), you can setup the database(s), make a change to the tnsnames.ora that the app is using, and it will magically start using the new database(s) without ever taking down the app. If you need to do some maintenance on one box, then you just shut it down, and the app will go to other. If you have multiple web servers hitting the databases, you can get some sort of load balancing by fiddling with the tnsnames.ora on each of the web servers; for example, web server #1 hits database #1 and fails over to database #2, and web server #2 is just the opposite. The disadvantages of TAF (that I can think of at the moment) are: The syntax for the network files for TAF is a little obscure and touchy. If you fail over -- usually because you want to do some maintenance on one of the database servers -- then you might have to do some restart this and restart that to get the web servers pointed back to the database they are supposed to be using. But often, this can be done without taking down the web front ends And a comment about this whole It can never go down philosophy. The Unix stuff from Sun and IBM is actually very reliable. If your storage is fault tolerant (i.e. 0+1 ... or ... RAID5 Oh YESS!), and as long as you don't do something inherently unreliable such as putting critical stuff on NFS mounts, these systems should stay up for a long time. Most of the time your outages will be caused by human error or network outages (caused by human error -- Those damned humans!). -Original Message- Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more unit as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? I am new to this area, I would appreciate any input informantion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone using EMC Clarion Cx400 in a RAC environment?
Looking at purchasing an EMCClarion Cx400 for our 2 Sun Fire 280R Solaris 9 machines. Wondering if anyone is currently using this Storage system and how it performs. Any outstanding issues/concerns we should know about. Did your system admin attend a class on taking care of this storage solution? We will be running Veritas Database Edition for Oracle 9i R2 RAC. I am gonna attend the Oracle RAC class offered by Oracle and the system administrator will attend the Veritas class. Any help would be greatly appreciated. Many Thanks, -Lizz Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
Re: AW: RedHat AS Dev edition still available today
Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron [EMAIL PROTECTED] 06/16/03 06:39PM Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Compare Schema with data
List, Is any body know any tools for comparing two schema for only data comparison create script for the result, I have two schema want to find out what's the difference exists as data point of view, I know TOAD can generate comparison script BUT I am interesting In data comparison, any URL or help would be appreciate Thanks in advance. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDBC and MTS
I recall an old bug where MTS would sleep for a bit - don't recall the bug anymore. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 [EMAIL PROTECTED] 6/17/03 12:35:20 PM b) I use server=dedicated, is srvr=dedicate a short hand version ofit?-Original Message-Sent: Tuesday, June 17, 2003 8:25 AMTo: Multiple recipients of list ORACLE-LOK. Let me get some things straight:a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone.b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection.c) What was the issue that you faced? That was my original question.On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string "SRVR=DEDICATED" has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with listeners on all 4 nodes for load balancing purposes. I found surprisingly little material on the Metalink. No network collisions, no retransmits, no timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Oracle releases by the different platforms...
Title: IOUG Live 2003 does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Greg
Re: asking your opinion
This application will need to tie into Sun one portal, the key items are web central to provide unit to create content, change pages..etc undergrades site for class registration, staff pages do other stuff. Joan Stephen Lee wrote: If this is to be a web server kind of application then another possibility to consider: Transparent Application Failover (TAF) I think this works well with web applications where the data in the database(s) isn't constantly changing at a high rate. You have two or more independent databases that you keep in sync with replication. If one becomes unavailable, sqlnet will send the app to the other database. This is handled entirely by sqlnet and requires no specific coding in the application. One handy thing about this setup is that if one of the departments turns out to be a real database pig and needs to be put on its own machine(s), you can setup the database(s), make a change to the tnsnames.ora that the app is using, and it will magically start using the new database(s) without ever taking down the app. If you need to do some maintenance on one box, then you just shut it down, and the app will go to other. If you have multiple web servers hitting the databases, you can get some sort of load balancing by fiddling with the tnsnames.ora on each of the web servers; for example, web server #1 hits database #1 and fails over to database #2, and web server #2 is just the opposite. The disadvantages of TAF (that I can think of at the moment) are: The syntax for the network files for TAF is a little obscure and touchy. If you fail over -- usually because you want to do some maintenance on one of the database servers -- then you might have to do some restart this and restart that to get the web servers pointed back to the database they are supposed to be using. But often, this can be done without taking down the web front ends And a comment about this whole It can never go down philosophy. The Unix stuff from Sun and IBM is actually very reliable. If your storage is fault tolerant (i.e. 0+1 ... or ... RAID5 Oh YESS!), and as long as you don't do something inherently unreliable such as putting critical stuff on NFS mounts, these systems should stay up for a long time. Most of the time your outages will be caused by human error or network outages (caused by human error -- Those damned humans!). -Original Message- Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more unit as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? I am new to this area, I would appreciate any input informantion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare Schema with data
I think DB Artisan Change Manager will do it. -Original Message- Is any body know any tools for comparing two schema for only data comparison create script for the result -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MySQL in the future?
WILL OPEN-SOURCE THREATEN ORACLE, IBM AND MS? | Internet News How big of a threat are open-source databases to software giants like Oracle, who hold most of the market and revenue share today? MySQL could be the biggest challenger to Oracle, and even Microsoft and IBM in the database market. MySQL is making inroads as a database alternative for small businesses or departmentally inside larger enterprises. Ultimately, the groundswell of support for MySQL could propel it on a Linux-like course to stardom as companies look to reduce TCO for databases. For the full details, click: http://www.internetnews.com/ent-news/article.php/2221901 Interesting article Is this the wave of the future for the small consultant?? If the CEO is smart he will start a certification program and release upgrades every 18 months. It keeps the revenue comming it. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Compare Schema with data
Is any body know any tools for comparing two schema for only data comparison create script for the result Isn't Change Mangement Pack in OEM able to do this? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: recreating a create database file
Tom, Yes the trace file is a good idea for scripting the database ut it does not create any of the tables and other options available in Oracle. You will still need all of your scripts or other package to completely recreate your database. That is if the interpretation of a database is more than just datafiles. Ron [EMAIL PROTECTED] 06/17/03 01:44PM Golly, this is the best answer!!! Great idea Jeremiah Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Not sure if this was already mentioned. You can hack up the result of this: alter database backup controlfile to trace; into an exact replica of the create database statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 17 Jun 2003, Jack van Zanen wrote: Maybe not exactly what you are looking for, but Start the GUI DBCA (NO don't shoot), go through the all the motions and at the end choose generate scripts only. Jack -Original Message- Sent: Tuesday, June 17, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OEM question
Lisa, Congrats on the flawless upgrade. As I understand your statement about OEM you are correct. But you can place the OEM repository on any old server, like the development one or Linux and then run the OEM using it. Of course there is the issues of licensing if you use your play station database as the repository. When I was looking at OEM I used on of the dev servers to work on the prod servers. The oem was in a small instance that was easy to full export as a backup policy. Ron [EMAIL PROTECTED] 06/17/03 01:49PM Hello all, I'm configuring OEM for the first time. I see it needs a repository to operate. So for the db-up functionality, if the database that contains your repository goes down, your db-up function is dead, right? Sounds like the rman catalog quandry. YOu have a catalog to backup your database, but then you have to backup your catalog... And just as a fyi: I completed the upgrade from 8.1.7.4-9.2.0.3 on Windows 2000 without incident last night. It actually went pretty quickly. Thanks in advance for any comments about OEM. Lisa Koivu Oracle Database Stressmonkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: asking your opinion
The TAF thing was just another option to consider. I think it works best when you have a web app over here and databases over there and over there etc. Sqlnet handles the dirty work of connection and failover management. And *YOU* handle the dirty work of data management between the multiple databases. But if the data is easy to manage, TAF becomes a reasonable option. -Original Message- This application will need to tie into Sun one portal, the key items are web central to provide unit to create content, change pages..etc undergrades site for class registration, staff pages do other stuff. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Compare Schema with data
TOAD v7.5 will allow you to export INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run sdiff -s between the files in order to get the differences. Yes, it's a bit manual, but the price is right (ours was $350/copy back in the 1900s). You can evaluate TOAD by filling out the contact form at: http://www.quest.com/toad/ ...and click on the Download Trial link on the left. HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare Schema with data I think DB Artisan Change Manager will do it. -Original Message- Is any body know any tools for comparing two schema for only data comparison create script for the result -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8i OCP Question
Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare Schema with data
Potentially (I've only tested it for meta data changes and it had a few issues), if you're up to paying $1000s for it. It's list is $3K/CPU or $60/named user of the DBs you'll be monitoring. What a joke! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gudmundur Bjarni Josepsson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Compare Schema with data Is any body know any tools for comparing two schema for only data comparison create script for the result Isn't Change Mangement Pack in OEM able to do this? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone using IBM's FastT900 SAN for Oracle DBs?
Rich, There are two big issues with backup of an OLTP VLDB such as an ERP database: Backup window, and redo generation during hot backup mode. Disk I/O and network degradation during backup are also issues, albeit to a lesser extent. While RMAN would obviate the redo generation part, your backup window can still stretch out quite a bit depending on the backup architecture(dedicated backup server, tape libraries, drive speed and streaming, network segregation, disk staging capability, etc.) One of the best ways of performing backup of an OLTP VLDB is by the use of mirroring technologies - Hitachi ShadowImage, EMC BCV, IBMs whatever-it-is - is by breaking off a mirror copy when the *whole* database is in Hot backup mode. The backup can then be read off the mirror copy using a path that is different from the production path in the network fabric. Another option is presenting this copy to the server that performs the backup so the production box never suffers. This implies of course that you have a large enough SAN, and have configured the mirrors, _and_ the backup server is connected to the same SAN as the ERP and is thus able to mount the now-broken mirror. The issue with this is the resync that takes place when the mirror is brought back for resilvering. If the mirror copy is placed in the same server (i.e. not broken out) then resync takes much lesser time - and hour or two depending on the amount of writes as well as the efficiency of the SAN software. Some of the SANs are also able to perform a lazy catch-up where busy disks We have used this technique successfully [ not on IBM or EMC though, although there is no reason why this cannot be done ], but it costs $$. And I have _all_ RAID 1 volumes on the ERP SAN, after having successfully fought off a RAID5 'initiative' when we moved from a previous box :) [Mogens - Does this qualify me for an elevated status in the BAARF party?] -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:30 AM To: Multiple recipients of list ORACLE-L Subject: Anyone using IBM's FastT900 SAN for Oracle DBs? We're testing a FastT900 (http://www.storage.ibm.com/disk/fastt/fast900/index.html) to see how it will handle our IO thruput, but we've got one question as to how we're going to do our daily snapshot of our production DB. With our current RAID set (HP's AutoRAID -- that's why we're looking for a new solution. BAARF -- Battle Against Auto Raid Filesystems?), we do a simple hot backup and copy the production DB's datafiles tablespace-by-tablespace to a JBOD. Once that JBOD copy is put to tape, we recover it as a new database for our users to do what-if ERP scenarios. We're wondering how to accomplish this with the FastT900. Yes, we could do it the same way, but that seems to be a waste of Big SAN Power, doesn't it? The big difference between our current layout and the FastT900 layout is that the former-JBOD copy of the production DB will now reside on the FastT900 along with the production DB. I guess what I was thinking was to put all TSs into hot backup mode, perform some FastT900 magic in less than X minutes to copy the DB, then end backup mode on the TSs. No, I don't know what the X threshold is yet -- for the sake of argument, let's say 10. So, does anyone with experience on the FastTs have any ideas? Some of the terms thrown out are Business Continuous Volumes and Third Mirrors, although it doesn't seem like the FastT900 supports a third mirror, and I'm a bit skeptical (a DBA trait?) about the time it would take to resync the mirrors before we could do our snapshot. I'm contacting the Sales guys, too, but thought I'd see if anyone from an SA/DBA standpoint (hey, some of us do BOTH, OK?) would have any pertinent thoughts. Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA p.s. No disks were subjected to RAIDs outside of 10 and/or 0+1 in these tests. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: JDBC and MTS
The bug Jeffrey is referring to is supposedly fixed in 8.1.7 (but I've seen metalink posts that suggest otherwise). The bug numbers are 1304130 and 1309641 - the dispatcher goes to sleep occasionally for 60 seconds before waking up and servicing requests again... Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] Jeffrey Beckstrom To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .orgSubject: RE: JDBC and MTS Sent by: [EMAIL PROTECTED] .com 06/17/03 11:14 AM Please respond to ORACLE-L I recall an old bug where MTS would sleep for a bit - don't recall the bug anymore. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 [EMAIL PROTECTED] 6/17/03 12:35:20 PM b) I use server=dedicated, is srvr=dedicate a short hand version of it? -Original Message- Sent: Tuesday, June 17, 2003 8:25 AM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated servers if there's noway you can disable the application connection pooling... Regis -Original Message- Sent: Tuesday, June 17, 2003 6:05 AM To: Multiple recipients of list ORACLE-L I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 minutes later, users proceed normally but with the elevated blood pressure and serious lack of patience. I was told that JDBC has it's own connection pooling mechanism and that it will start it's own dedicated server connection. It seems though that the string SRVR=DEDICATED has been ignored and that users are acquiring a shared server connection. Does anybody in this group have any experience with JDBC and MTS? Version is 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with
RE: 8i OCP Question
Jay, the answer is B is the funny word there really is supports. C is the the predecessor to Rman - and it only works in Oracle version 7. A and D are just plain false. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare Schema with data
I think that's a good way to do it but I would use the Compare files of TOAD which is much nicer to look at than sdiff. At 11:04 2003-06-17 -0800, you wrote: TOAD v7.5 will allow you to export INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run sdiff -s between the files in order to get the differences. Yes, it's a bit manual, but the price is right (ours was $350/copy back in the 1900s). You can evaluate TOAD by filling out the contact form at: http://www.quest.com/toad/ ...and click on the Download Trial link on the left. HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare Schema with data I think DB Artisan Change Manager will do it. -Original Message- Is any body know any tools for comparing two schema for only data comparison create script for the result -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle releases by the different platforms...
Greg, The pattern with 9i was Solaris and HP-UX first, Windows next (seemed to be delayed several months), then Linux. Dan Fink Loughmiller, Greg wrote: does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Gregbegin:vcard n:Fink;Daniel x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;0 fn:Daniel Fink end:vcard
Resend: Anyone using IBM's FastT900 SAN for Oracle DBs?
/** Resending, as I fat-fingered the previous one :( **/ Rich, There are two big issues with backup of an OLTP VLDB such as an ERP database: Backup window, and redo generation during hot backup mode. Disk I/O and network degradation during backup are also issues, albeit to a lesser extent. While RMAN would obviate the redo generation part, your backup window when using RMAN can still stretch out quite a bit depending on the backup architecture and capacity (dedicated backup server, tape libraries, drive speed and streaming, network segregation, disk staging capability, etc.) One of the best ways of performing backup of an OLTP VLDB is by the use of mirroring technologies - Hitachi ShadowImage, EMC BCV, IBMs whatever-it-is - and breaking off a mirror copy when the *whole* database is in Hot backup mode. The backup can then be read off the mirror copy using a path that is different from the production path in the network fabric. Another option is presenting this copy to the server that performs the backup so the production box never suffers. This implies of course that you have a large enough SAN, and have configured the mirrors, _and_ the backup server is connected to the same SAN as the ERP and is thus able to mount the now-broken mirror in the latter option. The issue with this approach is the resync that takes place when the mirror is brought back for resilvering. If the mirror copy is placed in the same server (i.e. not broken out) then resync takes much lesser time - and hour or two depending on the amount of writes as well as the efficiency of the SAN software. Some of the SANs are also able to perform a lazy catch-up where busy disks are left for later catchup, etc. We have used this technique successfully [ not on IBM or EMC though, although there is no reason why this cannot be done ], but it costs $$. And I have an _all_ RAID 1 volumes on the ERP SAN, after having successfully fought off a RAID5 'initiative' when we moved from a previous box :) [Mogens - Does this qualify me for an elevated status in the BAARF party?] John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Great, positive uplifting Christian music - http://www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:30 AM To: Multiple recipients of list ORACLE-L Subject: Anyone using IBM's FastT900 SAN for Oracle DBs? We're testing a FastT900 (http://www.storage.ibm.com/disk/fastt/fast900/index.html) to see how it will handle our IO thruput, but we've got one question as to how we're going to do our daily snapshot of our production DB. With our current RAID set (HP's AutoRAID -- that's why we're looking for a new solution. BAARF -- Battle Against Auto Raid Filesystems?), we do a simple hot backup and copy the production DB's datafiles tablespace-by-tablespace to a JBOD. Once that JBOD copy is put to tape, we recover it as a new database for our users to do what-if ERP scenarios. We're wondering how to accomplish this with the FastT900. Yes, we could do it the same way, but that seems to be a waste of Big SAN Power, doesn't it? The big difference between our current layout and the FastT900 layout is that the former-JBOD copy of the production DB will now reside on the FastT900 along with the production DB. I guess what I was thinking was to put all TSs into hot backup mode, perform some FastT900 magic in less than X minutes to copy the DB, then end backup mode on the TSs. No, I don't know what the X threshold is yet -- for the sake of argument, let's say 10. So, does anyone with experience on the FastTs have any ideas? Some of the terms thrown out are Business Continuous Volumes and Third Mirrors, although it doesn't seem like the FastT900 supports a third mirror, and I'm a bit skeptical (a DBA trait?) about the time it would take to resync the mirrors before we could do our snapshot. I'm contacting the Sales guys, too, but thought I'd see if anyone from an SA/DBA standpoint (hey, some of us do BOTH, OK?) would have any pertinent thoughts. Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA p.s. No disks were subjected to RAIDs outside of 10 and/or 0+1 in these tests. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: asking your opinion
Thanks Robert, Malden and stephen. I am just wondering does master replication is an option too? As I mentioned earlier, the application is sun one portal, content based. Joan Freeman Robert - IL wrote: See comments below RF Robert G. Freeman Consultant - TUSC www.tusc.com One browser to rule them all, one browser to find them, One browser to bring them all and into the darkness bind them In the land of Redmond where the shadows lie. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/16/2003 11:14 PM Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more unit as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? You are asking the question without yet really providing the requirements. The standby database (logical or physical) is there to meet disaster recovery requirements, *NOT* HA requirements. It's need is defined by your SLA's with regards to how much down time can I have, do I need a remote site, do I need to be able to revert to a previous image of my database, etc...etc... For some environments, offsite backups are perfectly satisfactory in this regard, at other sites, you have a hot offsite location, where you run dataguard (standby). So, you need to define your needs before you ask the question. Specifically regarding logical standby databases, they are a great idea but in my mind they are still new enough (and I've seen a bugs enough) that I don't trust them yet for mission critical application failover. I might consent to using one in combination with at least one physical standby if needs and resources allowed. Still, for right now, if my requirements dictated a standby database, I'd go physical. RAC, OTOH, is there to meet HA requirements, not DR requirements (unless you can configure a long distance RAC cluster which I have yet to see work really well yet). RAC is an added cost option to Oracle, with it's own set of headaches that may or may not be worth your time and money. Again, it depends on your needs, budget and SLA's. If you need four 9's uptime, then RAC may well be the way to go. If you have a rather stable system, and your users can stand an outage, then perhaps you do not need RAC. Again, you must define the requirements first, then look for the solutions. question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? My personal rule about this is that if a given application is going to largely share data with another existing application, and there are no good reasons to separate them into their own databases (for example wildly different SLA's with regards to HA or DR), then I will simply use the same database. This avoids problems with disparate data issues (and saves a bit of memory and CPU). However if the application is self-contained, or if it uses data feeds from several systems (which is much more frequent in my experience) then it goes into it's own database and we have to decide how we are going to feed it data. HTH!!! Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8i OCP Question
The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: recreating a create database file
Ron, I read Ruth's original message meaning that she had to re-create the database structures. Of course you are correct if she meant the schema objects also. I just liked Jeremiah's thinking - this is an excellent quick way of creating the create database script to re-create all of the physical structure. Much easier than trying to create a sql-script to generate the same. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Tom, Yes the trace file is a good idea for scripting the database ut it does not create any of the tables and other options available in Oracle. You will still need all of your scripts or other package to completely recreate your database. That is if the interpretation of a database is more than just datafiles. Ron [EMAIL PROTECTED] 06/17/03 01:44PM Golly, this is the best answer!!! Great idea Jeremiah Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Not sure if this was already mentioned. You can hack up the result of this: alter database backup controlfile to trace; into an exact replica of the create database statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 17 Jun 2003, Jack van Zanen wrote: Maybe not exactly what you are looking for, but Start the GUI DBCA (NO don't shoot), go through the all the motions and at the end choose generate scripts only. Jack -Original Message- Sent: Tuesday, June 17, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this
Re: 8i OCP Question
B ). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:44 PM Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Passing array as input to procedure from sqlplus-HELP
Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How can I pass array value from sql*plus Procedure testproc(iarrPID IN PID_VArray). I want to test it this way SQLExec testproc(?) Tried this was SQLEXEC testproc(33); ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'testproc' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Pls help Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: 8i OCP Question
are these the questions you buy from oracle corporation? or from some outside vendor? if so who? I wont get those. If its from oracle, that is troubling... since the test might be wrong also. From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/06/17 Tue PM 04:20:10 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 8i OCP Question Jay, the answer is B is the funny word there really is supports. C is the the predecessor to Rman - and it only works in Oracle version 7. A and D are just plain false. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8i OCP Question
Hi And answer D is not correct since Rman works fine without a tape subsystem, by writing to Disk :-) Gary W. Parker wrote: The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-1031
I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can create about 50 triggers just like this before I get the error. The 3 triggers are delete triggers, I don't know if that is something to keep in mind. Why would I get an ora-1031? CREATE OR REPLACE TRIGGER DIAMOND.trg_audit_aai_delete /*__ __ */ /* ___ */ AFTER DELETE ON AUTH_ADDTL_INFO FOR EACH ROW DECLARE l_seq_audit_id NUMBER; l_number NUMBER (1); l_active_trigger hsd_navgrp_kw.audit_trail%TYPE; l_old_data VARCHAR2 (32750); iINTEGER; l_done CHAR:= 'F'; l_found_splitCHAR:= 'F'; l_segment_cntINTEGER := 1; 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: 8i OCP Question
Title: RE: 8i OCP Question Jay, I disagree. Go to (you may have to paste the link back together) http://www.znow.com/sales/oracle/server.816/a76990/rmanconc.htm#424437 And scroll down to the first NOTE: It tells you right there that RMAN is not compatible with EBU. I'm assuming your answer B) is supposed to say Recovery Manager SUPPORTS multi-level incremental backups. So I would go with that one. -Scott Stefick -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Subject: 8i OCP Question Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8i OCP Question
B is the correct answer. Incremental backups are supported in archivelog and noarchivelog mode. Rman does not require a recovery catalog. RMAN is not compatible with EBU RMAN works just fine to disk. Robert Oracle9i RMAN Backup and Recovery Freeman -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/17/2003 3:25 PM The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: asking your opinion
CAVEAT: With all the banging around Oracle has done with replication, I think my knowledge of replication is quickly getting outdated. Keeping that in mind: In my limited experience with simple snapshot replication, about the only time you run into difficulties is when you need to replicate at frequent intervals -- like every 15 seconds or something like that. Then the overhead gets nasty. For something like every five minutes or greater, simple snapshots are easy to setup and maintain, and the overhead ain't bad then. I've found it to be reliable as long as you don't screw with it after you set it up. By simple snapshot replication I mean the old style of replication where you create snapshot logs on the master; snapshots on the client(s); a refresh group in a refresh boss guy schema on the client(s); add the snapshots to the refresh group; then set up a job in the refresh boss's schema that refreshes the refresh group. Then you periodically monitor the refresh job to make sure that it isn't broken. I think the New! Improved! replication stuff has you putting the refresh times directly in the create snapshot (E-X-C-U-S-E M-E ... Materialized View) statement. I don't do that; at least not until they incorporate the word Existential into the process. -Original Message- Thanks Robert, Malden and stephen. I am just wondering does master replication is an option too? As I mentioned earlier, the application is sun one portal, content based. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Compare Schema with data
Hi Louis, That sounds cool, but where can you compare table data in TOAD? The only options I see (TOAD 7.5 registered and TOAD 7.5.3.28 BETA w/DBA module) are for the object definitions of schemas and not the data itself. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Louis BROUILLETTE [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare Schema with data I think that's a good way to do it but I would use the Compare files of TOAD which is much nicer to look at than sdiff. At 11:04 2003-06-17 -0800, you wrote: TOAD v7.5 will allow you to export INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run sdiff -s between the files in order to get the differences. Yes, it's a bit manual, but the price is right (ours was $350/copy back in the 1900s). You can evaluate TOAD by filling out the contact form at: http://www.quest.com/toad/ ...and click on the Download Trial link on the left. HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare Schema with data I think DB Artisan Change Manager will do it. -Original Message- Is any body know any tools for comparing two schema for only data comparison create script for the result -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Passing array as input to procedure from sqlplus-HELP
Title: RE: Passing array as input to procedure from sqlplus-HELP exec testproc(pid_varray(1,2,3,4,5)); Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 17, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Subject: Passing array as input to procedure from sqlplus-HELP Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How can I pass array value from sql*plus Procedure testproc(iarrPID IN PID_VArray). I want to test it this way SQLExec testproc(?) Tried this was SQLEXEC testproc(33); ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'testproc' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Pls help Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: MySQL in the future?
I haven't really used either in-depth, but the features of PostrgeSQL http://advocacy.postgresql.org/advantages/ seem to be a lot closer to Enterprise than MySQL 4.x, IMHO. Then again, I'm an Oracle bigot -- for now. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:10 PM To: Multiple recipients of list ORACLE-L Subject: MySQL in the future? WILL OPEN-SOURCE THREATEN ORACLE, IBM AND MS? | Internet News How big of a threat are open-source databases to software giants like Oracle, who hold most of the market and revenue share today? MySQL could be the biggest challenger to Oracle, and even Microsoft and IBM in the database market. MySQL is making inroads as a database alternative for small businesses or departmentally inside larger enterprises. Ultimately, the groundswell of support for MySQL could propel it on a Linux-like course to stardom as companies look to reduce TCO for databases. For the full details, click: http://www.internetnews.com/ent-news/article.php/2221901 Interesting article Is this the wave of the future for the small consultant?? If the CEO is smart he will start a certification program and release upgrades every 18 months. It keeps the revenue comming it. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recreating a create database file
popping my head out the window...
Here is the create script I just did for 9i
[createdb.sql]
spool DB_DESTINATION\admin\INSTANCE\create\CreateDB.log
set echo on
connect SYS/PASSWORD as SYSDBA
startup nomount
pfile=DB_DESTINATION\admin\INSTANCE\pfile\initINSTANCE.ora;
-- build the db
CREATE DATABASE INSTANCE
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 64
MAXLOGMEMBERS 3
MAXDATAFILES 100
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'DB_DESTINATION\oradata\INSTANCE\INSTANCE_system.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGFILE GROUP 1
('DB_DESTINATION\oradata\INSTANCE\INSTANCE_redo01.log') SIZE 2M,
GROUP 2 ('DB_DESTINATION\oradata\INSTANCE\INSTANCE_redo02.log')
SIZE 2M,
GROUP 3 ('DB_DESTINATION\oradata\INSTANCE\INSTANCE_redo03.log')
SIZE 2M;
spool off
-- create db files
spool DB_DESTINATION\admin\INSTANCE\create\CreateDBFiles.log
CREATE ROLLBACK SEGMENT BLD TABLESPACE SYSTEM
STORAGE(INITIAL 128K NEXT 128K MINEXTENTS 2 MAXEXTENTS 32);
ALTER ROLLBACK SEGMENT BLD ONLINE;
commit ;
-- NOTE-- SET THE SIZES OF THE
TABLESPACES BELOW TO MATCH YOUR DESIRED DATABASE
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_TEMP01.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
-- NOTE using the undo tablespace is a new feature of 9i and can
replace rollback segments.
-- The corresponding setting in the initINSTANCE.ora file
undo_management=manual or auto must be used. For the time being we are
using conventional rollback segments
-- UNDO TABLESPACE UNDOTBS1 DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_undotbs01.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
-- NOTE the commented CREATE TABLESPACE sections below are the 8i
conventional method of size management.
-- The uncommented sections use the new feature of 9i EXTENT MANAGEMENT
LOCAL SEGMENT SPACE MANAGEMENT AUTO
-- more info
http://www.asia.cnet.com/builder/architect/db/0,39009328,39106483,00.htm
-- and http://otn.oracle.com/products/oracle9i/daily/Aug01.html
-- CREATE TABLESPACE USERS LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_users01.dbf' SIZE 25M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED ;
CREATE TABLESPACE USERS LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_USERS01.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
ALTER TABLESPACE USERS ONLINE;
--CREATE TABLESPACE TABLES LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_tables1.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED ;
--ALTER TABLESPACE TABLES ONLINE;
CREATE TABLESPACE TABLES LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_TABLES01.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
ALTER TABLESPACE TABLES ONLINE;
--CREATE TABLESPACE INDXS LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_indx01.dbf' SIZE 25M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED ;
--ALTER TABLESPACE INDXS ONLINE;
CREATE TABLESPACE INDXS LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_INDXS01.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
ALTER TABLESPACE INDXS ONLINE;
--CREATE TABLESPACE REPORT LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_REPORT01.dbf' SIZE 10M
REUSE AUTOEXTEND ON NEXT 320K -MAXSIZE UNLIMITED ;
--ALTER TABLESPACE REPORT ONLINE;
CREATE TABLESPACE REPORT LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_REPORT01.dbf' SIZE 1M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
ALTER TABLESPACE REPORT ONLINE;
--CREATE TABLESPACE XMLDB LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_XMLdb01.dbf' SIZE 20M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED ;
--ALTER TABLESPACE XMLDB ONLINE;
CREATE TABLESPACE XMLDB LOGGING DATAFILE
'DB_DESTINATION\oradata\INSTANCE\INSTANCE_XMLDB01.dbf' SIZE 5M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
ALTER TABLESPACE XMLDB ONLINE;
CREATE TABLESPACE ROLLBACK_SEGS DATAFILE
'DB_DESTINATION\Oradata\INSTANCE\INSTANCE_ROLLBACK.DBF' SIZE 25M
REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED ;
ALTER TABLESPACE ROLLBACK_SEGS ONLINE;
spool off
-- create users
spool DB_DESTINATION\admin\INSTANCE\create\createUsers.log
alter user system temporary tablespace temp;
alter user system default tablespace users;
alter user system identified by PASSWORD;
alter user sys identified by PASSWORD;
Create users and add permissions here...
-- Create 8 rollback segments. Allows about 32 concurrent users with
open
-- transactions updating the database.
spool DB_DESTINATION\admin\INSTANCE\create\CreateRBSegs.log
CREATE ROLLBACK SEGMENT RS_01A
TABLESPACE ROLLBACK_SEGS
STORAGE(
INITIAL 128K
Re: RE: 8i OCP Question
This is from an outside vendor, usually they are good but I can't seem to figure this one out. I know that you can allocate a channel to disk on a NoArchiveLog mode database through Rman. Also, only full backups (offline) can be taken if the db is in NoArchiveLog mode. The only thing that I thought might work is that in OEM backup manager only full backups are allowed on NoArchivelog db's at least that is my understanding. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: RE: 8i OCP Question Date: Tue, 17 Jun 2003 12:59:20 -0800 are these the questions you buy from oracle corporation? or from some outside vendor? if so who? I wont get those. If its from oracle, that is troubling... since the test might be wrong also. From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/06/17 Tue PM 04:20:10 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 8i OCP Question Jay, the answer is B is the funny word there really is supports. C is the the predecessor to Rman - and it only works in Oracle version 7. A and D are just plain false. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-1031
Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that out for an explicitly specified datatype for l_active_trigger, does it make any difference? Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, June 17, 2003 2:10 PM To: Multiple recipients of list ORACLE-L I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can create about 50 triggers just like this before I get the error. The 3 triggers are delete triggers, I don't know if that is something to keep in mind. Why would I get an ora-1031? CREATE OR REPLACE TRIGGER DIAMOND.trg_audit_aai_delete /*__ __ */ /* ___ */ AFTER DELETE ON AUTH_ADDTL_INFO FOR EACH ROW DECLARE l_seq_audit_id NUMBER; l_number NUMBER (1); l_active_trigger hsd_navgrp_kw.audit_trail%TYPE; l_old_data VARCHAR2 (32750); iINTEGER; l_done CHAR:= 'F'; l_found_splitCHAR:= 'F'; l_segment_cntINTEGER := 1; 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 8i OCP Question
Does that apply to 8i databases as well? From: Freeman Robert - IL [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 8i OCP Question Date: Tue, 17 Jun 2003 13:24:41 -0800 B is the correct answer. Incremental backups are supported in archivelog and noarchivelog mode. Rman does not require a recovery catalog. RMAN is not compatible with EBU RMAN works just fine to disk. Robert Oracle9i RMAN Backup and Recovery Freeman -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/17/2003 3:25 PM The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle releases by the different platforms...
And then OpenVMS. sigh And MTS *still* doesn't work there... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle releases by the different platforms... Greg, The pattern with 9i was Solaris and HP-UX first, Windows next (seemed to be delayed several months), then Linux. Dan Fink Loughmiller, Greg wrote: does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RedHat AS Dev edition still available today THANK YOU Ron !
Maybe Redhat was overwhelmed by the demand? Patrice. -Original Message- Sent: Tuesday, June 17, 2003 1:59 PM To: Multiple recipients of list ORACLE-L To Ron: Ron, your last link works !!! RH AS Dev Edition is already by me. Thank you very, VERY much for the help! BTW, according to one of the official RedHat resellers in Germany, Dev Edition was not avialable anymore (?! I haven't posted them the link yet;) ), because there were too many requests for updates ...NO comment. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 14:30 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition still available today Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron [EMAIL PROTECTED] 06/16/03 06:39PM Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the buy it page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron [EMAIL PROTECTED] 06/13/03 05:09PM Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this promotion (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: Anyone using IBM's FastT900 SAN for Oracle DBs?
Thanks John, but I already know the generic issues with Oracle DB backup on SAN. That's why I was asking specifically about the FastT900. After some research, I've found out that there is an option called FlashCopy, which appears to be different than the third mirror approach, but am having a difficult time relating that to our scenario. Specifically, how long the DB would be in backup mode (for reasons you mentioned), what overhead is involved on the production DB before and after the copy (i.e. if it's a PIT snap, do only changed blocks from the source get copied to the target or what about changes to the target itself, since we're firing that up as a separate DB?), and what does a logical subsystem (LSS) consist of, since the source and target of the FlashCopy must exist on the same LSS? Perhaps it's time to call a FastT Tech Sales Guru... :) BTW, are you RAID 0ing along with your RAID 1 or are you relying on the SAN cache for performance? Whole DB or just data? BAARFingly, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Subject: Resend: Anyone using IBM's FastT900 SAN for Oracle DBs? /** Resending, as I fat-fingered the previous one :( **/ Rich, There are two big issues with backup of an OLTP VLDB such as an ERP database: Backup window, and redo generation during hot backup mode. Disk I/O and network degradation during backup are also issues, albeit to a lesser extent. While RMAN would obviate the redo generation part, your backup window when using RMAN can still stretch out quite a bit depending on the backup architecture and capacity (dedicated backup server, tape libraries, drive speed and streaming, network segregation, disk staging capability, etc.) One of the best ways of performing backup of an OLTP VLDB is by the use of mirroring technologies - Hitachi ShadowImage, EMC BCV, IBMs whatever-it-is - and breaking off a mirror copy when the *whole* database is in Hot backup mode. The backup can then be read off the mirror copy using a path that is different from the production path in the network fabric. Another option is presenting this copy to the server that performs the backup so the production box never suffers. This implies of course that you have a large enough SAN, and have configured the mirrors, _and_ the backup server is connected to the same SAN as the ERP and is thus able to mount the now-broken mirror in the latter option. The issue with this approach is the resync that takes place when the mirror is brought back for resilvering. If the mirror copy is placed in the same server (i.e. not broken out) then resync takes much lesser time - and hour or two depending on the amount of writes as well as the efficiency of the SAN software. Some of the SANs are also able to perform a lazy catch-up where busy disks are left for later catchup, etc. We have used this technique successfully [ not on IBM or EMC though, although there is no reason why this cannot be done ], but it costs $$. And I have an _all_ RAID 1 volumes on the ERP SAN, after having successfully fought off a RAID5 'initiative' when we moved from a previous box :) [Mogens - Does this qualify me for an elevated status in the BAARF party?] John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Great, positive uplifting Christian music - http://www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:30 AM To: Multiple recipients of list ORACLE-L Subject: Anyone using IBM's FastT900 SAN for Oracle DBs? We're testing a FastT900 (http://www.storage.ibm.com/disk/fastt/fast900/index.html) to see how it will handle our IO thruput, but we've got one question as to how we're going to do our daily snapshot of our production DB. With our current RAID set (HP's AutoRAID -- that's why we're looking for a new solution. BAARF -- Battle Against Auto Raid Filesystems?), we do a simple hot backup and copy the production DB's datafiles tablespace-by-tablespace to a JBOD. Once that JBOD copy is put to tape, we recover it as a new database for our users to do what-if ERP scenarios. We're wondering how to accomplish this with the FastT900. Yes, we could do it the same way, but that seems to be a waste of Big SAN Power, doesn't it? The big difference between our current layout and the FastT900 layout is that the former-JBOD copy of the production DB will now reside on the FastT900 along with the production DB. I guess what I was thinking was to put
RE: ora-1031
Yes, it does. I just double checked that. David Ehresmann. -Original Message- Sent: Tuesday, June 17, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that out for an explicitly specified datatype for l_active_trigger, does it make any difference? Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, June 17, 2003 2:10 PM To: Multiple recipients of list ORACLE-L I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can create about 50 triggers just like this before I get the error. The 3 triggers are delete triggers, I don't know if that is something to keep in mind. Why would I get an ora-1031? CREATE OR REPLACE TRIGGER DIAMOND.trg_audit_aai_delete /*__ __ */ /* ___ */ AFTER DELETE ON AUTH_ADDTL_INFO FOR EACH ROW DECLARE l_seq_audit_id NUMBER; l_number NUMBER (1); l_active_trigger hsd_navgrp_kw.audit_trail%TYPE; l_old_data VARCHAR2 (32750); iINTEGER; l_done CHAR:= 'F'; l_found_splitCHAR:= 'F'; l_segment_cntINTEGER := 1; 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
Passing array as input to procedure from sqlplus-HELP
Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How can I pass array value from sql*plus Procedure testproc(iarrPID IN PID_VArray). I want to test it this way SQLExec testproc(?) Tried this was SQLEXEC testproc(33); ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'testproc' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Pls help Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sequential waits -- how to proceed
Hello ALL,
Oracle ver is 9.2 running on EMC array. I am executing a pl/sql
procedure which does an update on a fact table. There is an unique
index on the fact, with clearly shows up in the explain plan for
udapte.
I ran 10046 event for a 18 min duration during this update process and
then killed it.
On doing a tkprof on the trace file with waits set to Y, i get
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse1 0.00 0.00 0 0 0
0
Execute 470509238.311091.93 1178541413284 479488
470508
Fetch0 0.00 0.00 0 0 0
0
--- -- -- -- -- --
--
total 470510238.311091.94 1178541413284 479488
470508
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 36 (NEVADMIN) (recursive depth: 1)
Rows Row Source Operation
--- ---
470508 UPDATE (cr=1413396 r=117854 w=0 time=1049454599 us)
470509 INDEX UNIQUE SCAN DM_ACTUAL_CASHFLOW_HIST_UK (cr=1411527 r=3916
w=0 time=49102823 us)(object id 31693)
Rows Execution Plan
--- ---
0 UPDATE STATEMENT GOAL: CHOOSE
470508 UPDATE OF 'DM_ACTUAL_CASHFLOW_HIST'
470509INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'DM_ACTUAL_CASHFLOW_HIST_UK' (UNIQUE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total
Waited
Waited --
db file sequential read1178542.81
935.80
log file switch completion 191.00
2.23
log file switch (checkpoint incomplete)211.00
17.45
log buffer space20.07
0.07
As you can see the wait on db file sequential read is 935 ...i am
thinking it is in sec or is it centisec ??
i can see a degradation of perf as time continues. After 10 min , the
number of rows updated stays at 150 rows/sec which is pretty bad.
I have figured out the db file, table and block by looking into p1,p2.
That table is partioned and all the partitions are present on the same
tbs. It has 2 -- 8 gb files and p1 consistently points to either of the 2
data files.
I would like your help in trying to find out how to proceed from here ?.
I am stuck.
Ohter than moving the data files aound to different file systems ans
spreading them around, is there anything else thaty i can do to figure
out this problem.
Thanks,
Sathish.
--
http://www.fastmail.fm - Same, same, but different
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Passing array as input to procedure from sqlplus-HELP
You will have to write an anonymous block that declares the array variable, and passes that array to your procedure under test. --- Basavaraja, Ravindra [EMAIL PROTECTED] wrote: Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How can I pass array value from sql*plus Procedure testproc(iarrPIDIN PID_VArray). I want to test it this way SQLExec testproc(?) Tried this was SQLEXEC testproc(33); ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'testproc' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Pls help Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? 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: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone using EMC Clarion Cx400 in a RAC environment?
I can't speak for Clariion on Sun, but I support Win2K/Oracle 8.1.7on aClariion fc4700 and Sym 8530. The sym has been great. The Clariion is pretty good, but is a bit slower than the sym. It's much easier to manage though. It hasn't quite lived up the promise of being able to upgrade it without shuttingdown.there were2 instances where something that should be a hot upgrade crashed our system. Another time a flare upgrade required me to update all the clients which requiredme to reboot them. Even with these issues, I'm very happy with our EMC hardware. One last story. I ran into an interesting issue with the Clariion last Wednesday. I just setup a new QA server andneeded to test thesnap start command that runs on all of our servers attached to the Clariion. To my surprise, and everyone in the Dev and QA, it caused the Clariion to reboot and pulling the drives out from all attached systems. I have dual paths setup on it, but Powerpath won't help you when both processors get rebooted. EMC couldn't believe it, so when their engineer got there, I ran the script on another server and all was well. I then ran it onthe newserver and sure enough -it rebooted. After getting no answer from them, I uninstalled and reinstalled the ADMsnap software and it worked without rebooting. go figure. MS jabbing I'm more inclined to blame MS and not EMC for the problems ;) /MS jabbing Steve - Original Message - From: laura pena To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 17, 2003 12:09 PM Subject: Anyone using EMC Clarion Cx400 in a RAC environment? Looking at purchasing an EMCClarion Cx400 for our 2 Sun Fire 280R Solaris 9 machines. Wondering if anyone is currently using this Storage system and how it performs. Any outstanding issues/concerns we should know about. Did your system admin attend a class on taking care of this storage solution? We will be running Veritas Database Edition for Oracle 9i R2 RAC. I am gonna attend the Oracle RAC class offered by Oracle and the system administrator will attend the Veritas class. Any help would be greatly appreciated. Many Thanks, -Lizz Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
RE: MySQL in the future? (OT)
In that article, unless I missed it, they didn't mention the deal between SAP and MySQL. SAP, MySQL Sign Open-Source Database Deal (By MARC L. SONGINI, JUNE 02, 2003, Computerworld) SAP AG last week said it plans to hand off lead development of its SAP DB database software to MySQL AB and work with MySQL to deliver an enterprise-class version of that company's namesake open-source database. http://www.computerworld.com/softwaretopics/erp/story/0,10801,81711,00.html I think MySQL is definitely worth learning. You can find it for a whole bunch of different platforms here: http://www.mysql.com/downloads/mysql-4.0.html -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] WILL OPEN-SOURCE THREATEN ORACLE, IBM AND MS? | Internet News How big of a threat are open-source databases to software giants like Oracle, who hold most of the market and revenue share today? MySQL could be the biggest challenger to Oracle, and even Microsoft and IBM in the database market. MySQL is making inroads as a database alternative for small businesses or departmentally inside larger enterprises. Ultimately, the groundswell of support for MySQL could propel it on a Linux-like course to stardom as companies look to reduce TCO for databases. For the full details, click: http://www.internetnews.com/ent-news/article.php/2221901 Interesting article Is this the wave of the future for the small consultant?? If the CEO is smart he will start a certification program and release upgrades every 18 months. It keeps the revenue comming it. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone using EMC Clarion Cx400 in a RAC environment?
Hi, One incident (first year or usage) the fiber card driver crash and zombie processes occur. IO hang, database down. DB cannot fail over to standby server, primary server cannot shutdown, shutdown abort can't help, physically power off server is require. I don't think is the EMC problem but the fiber card. Sinardy -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: 18 June 2003 01:10To: Multiple recipients of list ORACLE-LSubject: Anyone using EMC Clarion Cx400 in a RAC environment? Looking at purchasing an EMCClarion Cx400 for our 2 Sun Fire 280R Solaris 9 machines. Wondering if anyone is currently using this Storage system and how it performs. Any outstanding issues/concerns we should know about. Did your system admin attend a class on taking care of this storage solution? We will be running Veritas Database Edition for Oracle 9i R2 RAC. I am gonna attend the Oracle RAC class offered by Oracle and the system administrator will attend the Veritas class. Any help would be greatly appreciated. Many Thanks, -Lizz Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
is it SP2 or SP3 -- 9iR2 on Win2K ?
Dear All, I need to install 9iR2 on Win2K Server. Is it SP2 or SP3 ? metalink docs say that SP1 or higher is OK. but still found some queries posted on metalink regarding SP3 9iR2. #$##$ ...confused :-| !*#$$ any serious issues known already ?! TIA. 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).
Re: Compare Schema with data
The below links are pretty good for compare tools. I recommend dbdiff, it seems to be pretty complete. http://www.torry.net/tools_dbcompare.htm http://www.dkgadvancedsolutions.com/dbdiff.htm - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:24 PM Rich, I meant that I would compare the 2 insert statements files with the files compare of TOAD instead of comparing with sdiff. It's a lot easier to see the differences between the files. At 13:55 2003-06-17 -0800, you wrote: Hi Louis, That sounds cool, but where can you compare table data in TOAD? The only options I see (TOAD 7.5 registered and TOAD 7.5.3.28 BETA w/DBA module) are for the object definitions of schemas and not the data itself. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Louis BROUILLETTE [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare Schema with data I think that's a good way to do it but I would use the Compare files of TOAD which is much nicer to look at than sdiff. At 11:04 2003-06-17 -0800, you wrote: TOAD v7.5 will allow you to export INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run sdiff -s between the files in order to get the differences. Yes, it's a bit manual, but the price is right (ours was $350/copy back in the 1900s). You can evaluate TOAD by filling out the contact form at: http://www.quest.com/toad/ ...and click on the Download Trial link on the left. HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare Schema with data I think DB Artisan Change Manager will do it. -Original Message- Is any body know any tools for comparing two schema for only data comparison create script for the result -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sequential waits -- how to proceed
Your pl/sql procedure is obviously doing a sql per row updated rather than
a set update. Unless you change the procedure you can expect only marginal
improvement from any other measure.
At 03:29 PM 6/17/2003 -0800, you wrote:
Hello ALL,
Oracle ver is 9.2 running on EMC array. I am executing a pl/sql
procedure which does an update on a fact table. There is an unique
index on the fact, with clearly shows up in the explain plan for
udapte.
I ran 10046 event for a 18 min duration during this update process and
then killed it.
On doing a tkprof on the trace file with waits set to Y, i get
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse1 0.00 0.00 0 0 0
0
Execute 470509238.311091.93 1178541413284 479488
470508
Fetch0 0.00 0.00 0 0 0
0
--- -- -- -- -- --
--
total 470510238.311091.94 1178541413284 479488
470508
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 36 (NEVADMIN) (recursive depth: 1)
Rows Row Source Operation
--- ---
470508 UPDATE (cr=1413396 r=117854 w=0 time=1049454599 us)
470509 INDEX UNIQUE SCAN DM_ACTUAL_CASHFLOW_HIST_UK (cr=1411527 r=3916
w=0 time=49102823 us)(object id 31693)
Rows Execution Plan
--- ---
0 UPDATE STATEMENT GOAL: CHOOSE
470508 UPDATE OF 'DM_ACTUAL_CASHFLOW_HIST'
470509INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'DM_ACTUAL_CASHFLOW_HIST_UK' (UNIQUE)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total
Waited
Waited --
db file sequential read1178542.81
935.80
log file switch completion 191.00
2.23
log file switch (checkpoint incomplete)211.00
17.45
log buffer space20.07
0.07
As you can see the wait on db file sequential read is 935 ...i am
thinking it is in sec or is it centisec ??
i can see a degradation of perf as time continues. After 10 min , the
number of rows updated stays at 150 rows/sec which is pretty bad.
I have figured out the db file, table and block by looking into p1,p2.
That table is partioned and all the partitions are present on the same
tbs. It has 2 -- 8 gb files and p1 consistently points to either of the 2
data files.
I would like your help in trying to find out how to proceed from here ?.
I am stuck.
Ohter than moving the data files aound to different file systems ans
spreading them around, is there anything else thaty i can do to figure
out this problem.
Thanks,
Sathish.
--
http://www.fastmail.fm - Same, same, but different
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Wolfgang Breitling
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).
system_call
Hello list, I was wondering if someone out there can help me. I'm trying to use the system_call external procedure. It's running fine on my development box, but it was there before my time. What do I need to do to get it running on my test server? or any server for that matter. TIA, M. Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bryan, Miriam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: exchange partition in 9.2
Are you using UPDATE GLOBAL INDEXES clause in the ALTER TABLE EXCHANGE PARTITION? This causes significant IO. Try tracing the session using 10046 trace and see exactly what statements are being issued. ALTER SESSION SET EVENTS '10046 trace name context forever, level 8'; ALTER TABLE EXCHANGE ALTER SESSION SET EVENTS '10046 trace name context off'; See the trace file generated in udump; this should tell you the p1 and p2 values of the db file ... reads, which you use to get the segment information from dba_extents. Another option, and much better one, is using Oracle Trace, which lets you see these p1 and p2 values in the database. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:59 AM Arup and Jacques: thanks for your help. The command we are executing is alter table exchange partition ... with table .. include indexes. We have also a PK on each of the tables (local index on a partitioned table). Go global indices. We have tried the same command with novalidate and the results were the same. Any thougths? --- Jacques Kilchoer [EMAIL PROTECTED] wrote: Did you say alter table exchange partition ... validate or alter table exchange partition ... novalidate? If you say novalidate then Oracle will sort the exchange table to make sure that you are not creating duplicate rows for the PK constraint. There is a Metalink note on that. Does the table have a PK enforced by a locally partitioned unique index? Any global indexes? What options did you have on the exchange partition statement? -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] We are having an interesting issue with the exchange partition command in our shop. We are running oracle 9202 on AIX 5l. The exchange partition command used to take about 1 sec (or less) in our old environmen (oracle 81 Dynix 4.3.3). Now the same operation takes about a minute and creates a ton of IO. an Oracle rep said that this has to do something with the way exchange partition now treats primary and unique keys. Recently however a DBA on my team did 4 exchanges in a row between the same two tables. First one took about 45s and did a lot of IO. next one took almost no time and no IO (and it did move the data), the next one - again 45s and IOs, the fourth one - no time again. Does any one has any experience with this issue and may be can shed some light on it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? 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: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to stop script
Thanks! That's exactly what I need!
Jin
Quoting Pete Finnigan [EMAIL PROTECTED]:
Hi
You can stop the script by using the line
whenever sqlerror exit rollback
and then generating an error by using an exception in a PL/SQL block as
follows:
oracle:jupiter cat imp.sql
whenever sqlerror exit rollback
declare
cursor c_db is
select name from v$database;
lv_db c_db%rowtype;
no_database exception;
wrong_database exception;
pragma exception_init(no_database,-5101);
pragma exception_init(wrong_database,-5102);
begin
open c_db;
fetch c_db into lv_db;
if c_db%notfound then
close c_db;
raise no_database;
else
if lv_db.name'TEST' then
close c_db;
raise wrong_database;
end if;
end if;
close c_db;
dbms_output.put_line('Running on database : '||lv_db.name);
exception
when no_database then
dbms_output.put_line('ERROR: could not find database');
raise_application_error(-20100,'ERROR - no database');
when wrong_database then
dbms_output.put_line('ERROR: wrong database');
raise_application_error(-20101,'ERROR - wrong
database');
when others then
dbms_output.put_line('ERROR: unknown error');
raise_application_error(-20101,'ERROR - unknown error');
end;
/
select user from sys.dual;
-- end of script imp.sql
then run it as follows
SQL @imp
declare
*
ERROR at line 1:
ORA-20101: ERROR - wrong database
ORA-06512: at line 29
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 -
Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
oracle:jupiter
i added the select user from sys.dual to show the script stops
processing.
hope this helps
kind regards
Pete
However, I want to check database name at the beginning of import.sql. I
knew
select name from v$database can obtain database name. But how can I stop
the
script if I found it is not TEST database? In import.sql, it is like:
drop user A cascade;
create user A ;
host imp A/[EMAIL PROTECTED] file=a.dmp full=yes;
// some PL/SQL ...
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: sequential waits -- how to proceed
Thanks for your reply ... I understand that it is a sql per row update but the same update on UAT environment works at a rate of about 2000 rows per sec. Though the data volume is definetly less compared to PROD, still there is night and day difference between prod and uat..In terms of the tables themselves, they are analyzed and the explain plan for update also looks exactly the same bet the environments. Both the instances are off the same SAN. Sathish. On Tue, 17 Jun 2003 19:00:00 -0800, Wolfgang Breitling [EMAIL PROTECTED] said: Your pl/sql procedure is obviously doing a sql per row updated rather than a set update. Unless you change the procedure you can expect only marginal improvement from any other measure. At 03:29 PM 6/17/2003 -0800, you wrote: Hello ALL, Oracle ver is 9.2 running on EMC array. I am executing a pl/sql procedure which does an update on a fact table. There is an unique index on the fact, with clearly shows up in the explain plan for udapte. I ran 10046 event for a 18 min duration during this update process and then killed it. On doing a tkprof on the trace file with waits set to Y, i get call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 470509238.311091.93 1178541413284 479488 470508 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 470510238.311091.94 1178541413284 479488 470508 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 36 (NEVADMIN) (recursive depth: 1) Rows Row Source Operation --- --- 470508 UPDATE (cr=1413396 r=117854 w=0 time=1049454599 us) 470509 INDEX UNIQUE SCAN DM_ACTUAL_CASHFLOW_HIST_UK (cr=1411527 r=3916 w=0 time=49102823 us)(object id 31693) Rows Execution Plan --- --- 0 UPDATE STATEMENT GOAL: CHOOSE 470508 UPDATE OF 'DM_ACTUAL_CASHFLOW_HIST' 470509INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'DM_ACTUAL_CASHFLOW_HIST_UK' (UNIQUE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited Waited -- db file sequential read1178542.81 935.80 log file switch completion 191.00 2.23 log file switch (checkpoint incomplete)211.00 17.45 log buffer space20.07 0.07 As you can see the wait on db file sequential read is 935 ...i am thinking it is in sec or is it centisec ?? i can see a degradation of perf as time continues. After 10 min , the number of rows updated stays at 150 rows/sec which is pretty bad. I have figured out the db file, table and block by looking into p1,p2. That table is partioned and all the partitions are present on the same tbs. It has 2 -- 8 gb files and p1 consistently points to either of the 2 data files. I would like your help in trying to find out how to proceed from here ?. I am stuck. Ohter than moving the data files aound to different file systems ans spreading them around, is there anything else thaty i can do to figure out this problem. Thanks, Sathish. -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling 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
Re: sequential waits -- how to proceed
Does the UAT have the same data volume, same nr of rows and blocks in the table being updated? At 08:49 PM 6/17/2003 -0800, you wrote: Thanks for your reply ... I understand that it is a sql per row update but the same update on UAT environment works at a rate of about 2000 rows per sec. Though the data volume is definetly less compared to PROD, still there is night and day difference between prod and uat..In terms of the tables themselves, they are analyzed and the explain plan for update also looks exactly the same bet the environments. Both the instances are off the same SAN. Wolfgang Breitling 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).
Oracle RDBMS for Win XP
Hi all, Do you install Oracle RDBMS (maybe personal edition) with Win XP? Will that work? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
