RE: Logitech Give Away
Title: OT: Logitech Give Away They're giving away UP TO 20,000. A round number somewhere UP TO 20,000 is 0... I'm off to NASA to check on their givaway of UP TO two space shuttles :) Happy Holidays! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Logitech Give Away LOL glad I'm not a Canadian "Canadian winners are required under Canadian law to correctly answer a time-limited mathematical question in order to receive the prize. " -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 1:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Logitech Give Away too late! I read the rules. they were giving away 62 units in NY State. -Original Message-From: david hill [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: OT: Logitech Give Away Just to let everybody know to try and visit www.logitech.com They are giving away 20,000 mice and keyboards today Hopefully it'll make somebody's holiday's Merry Christmas David Hill Oracle DBA Le Chateau
RE: Configuring 734 and 817 on same machine.
Title: Configuring 734 and 817 on same machine. Note that 7.3.4 was never supported on Windows 2000. -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 05, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Configuring 734 and 817 on same machine. We have 7.3.4 and 8.1.6 working on the same machine with no problems. 7.3.4 was installed first and then 8.1.6. Listener is 8.1.6. Do not forget to shut down ALL 7.3.4 services and processes before installing 8.1.6. Yechiel AdarMehish - Original Message - From: Denham Eva To: Multiple recipients of list ORACLE-L Sent: Friday, August 30, 2002 10:28 AM Subject: Configuring 734 and 817 on same machine. Hello Gurus, Does anyone have a link to a resource which describes the Installation and configuration of Oracle 734 and Oracle 817 on the same Windows 2000 machine. The configuration of the listeners is my main concern. Any help on this is very much appreciated. Regards Denham Eva DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Contract Forwarding, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Free Unused User Memory
Has anyone used dbms_session.free_unused_user_memory; in a production environment? Comments and experiences? Thanks. Saul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Senior DBA position - Dublin, Ireland
Roy Keane is free at the moment. -Original Message- Sent: Tuesday, May 28, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for most members of this list. (but maybe some other Irish based folk are here too!) My company, location North County Dublin, Ireland, has a vacancy for a full time permanent position for a Senior DBA. If anyone is interested check out Recruitment section of www.organon.ie No applications to me please, use directions from web site! - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: hotbackup script for NT OR WIN2000
Brian, I probably should have been, but as Lisa mentions, you have to understand what you are doing and simply running another person's scripts isn't going to help him. I'll try and be a bit more constructive next time! Saul -Original Message- Sent: Wednesday, March 27, 2002 6:09 PM To: Multiple recipients of list ORACLE-L Ya know, I enjoy a good RTFM as much as the next guy, when done properly and for the right reasons. But the number of them that I have seen in the last few weeks is just not justified. Can we all be just a bit more constructive ... Hm Brian P. MacLean Oracle DBA, OCP8i "Solomon, Saul M." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: hotbackup script for NT OR WIN2000 Sent by: [EMAIL PROTECTED] om 03/27/02 01:33 PM Please respond to ORACLE-L c:\winnt\system32\rtfm perhaps? -Original Message- Sent: Wednesday, March 27, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Hi Can some one send me hotback scripts for NT OR WIN'2000? With regards Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET:
RE: hotbackup script for NT OR WIN2000
c:\winnt\system32\rtfm perhaps? -Original Message- Sent: Wednesday, March 27, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Hi Can some one send me hotback scripts for NT OR WIN'2000? With regards Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Transportable tablespace problem in 817
No, this bug is one where the export hangs forever as per Kumanan's description. It's fixed by patching 8.1.7 or by putting event = "10297 trace name context forever, level 1" in the init.ora. I think the note is 144794.1 on Metalink. Saul Solomon Senior Database Administrator PPG Industries [EMAIL PROTECTED] 412 434-3504 -Original Message- Sent: Thursday, June 21, 2001 11:33 AM To: Multiple recipients of list ORACLE-L Kevin, I believe the bug to which he was referring is bug 970640 documented in Note: 76670.1 "ALERT: Transportable Tablespaces can Corrupt Target Database" This bug is specific to 8.1.5 and is fixed in 8.1.6+ The bug is in the way export creates the dmp file of the transportable tablespace metadata and does not always happen. If you attempt to import an 8.1.5 export file that would cause the corruption into an 8.1.6+ db it will fail with ORA-29336 "Internal error from DBMS_PLUGTS" thereby preventing the corruption. HTH, -- Anita --- Kevin Lange <[EMAIL PROTECTED]> wrote: > There is definitely a bug. At an IOUGA conference a > while back I sat thru a > session where he was talking about all the things to > do with Transportable > Tablespaces . and at the end of the talk he said > "But dont use > it unless you are up on the upcoming 8.1.7... there > is a bug that can > destroy your tablespace." > > So much for a well spent 30 minutes. > > -Original Message- > Sent: Wednesday, June 20, 2001 6:37 AM > To: Multiple recipients of list ORACLE-L > > > Thanks. > I'll also try it with 816 and see if it works fine > there. > > Kumanan > > > -Original Message- > > From: Solomon, Saul M. [SMTP:[EMAIL PROTECTED]] > > Sent: 19 June 2001 21:41 > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Transportable tablespace problem in > 817 > > > > This is a bug. You've probably got an ORA-600 too > in your alert log. I had > > the same problem and upgraded to 8.1.7.1 to fix > it. > > > > Saul Solomon > > Senior Database Administrator > > PPG Industries > > [EMAIL PROTECTED] > > 412 434-3504 > > > > > > > > -Original Message- > > Sent: Tuesday, June 19, 2001 4:22 PM > > To: Multiple recipients of list ORACLE-L > > > > > > I'm trying to a transportable but the export > session is hanging. > > The v$session says the session is actually active. > > > > Anybody here has any such experience? > > > > Any ideas to resolve this? > > > > > > Thanks > > Kumanan > > > > SQL> set autoprint on serveroutput on > > SQL> exec dbms_tts.transport_set_check > ('DATA',TRUE); > > PL/SQL procedure successfully completed. > > SQL> select * from sys.transport_set_violations; > > VIOLATIONS > > > -- > > -- > > > > Index KBALASUN.PK_USERS_USERID in tablespace > INDEXTS enforces primary > > constriant > > s of table KBALASUN.USERS in tablespace DAT > > SQL> exec dbms_tts.transport_set_check > ('DATA,INDEXTS',TRUE); > > PL/SQL procedure successfully completed. > > SQL> select * from sys.transport_set_violations; > > no rows selected > > > > alter tablespace data read only; > > alter tablespace data read only; > > > > /tmp $ env > > NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 > > ORACLE_SID=KBDB > > > ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data > > ORACLE_HOME=/export/home/oracle/product/8.1.7 > > > > > > /tmp $ exp transport_tablespace=y > tablespaces=DATA,INDEXTS > > file=testtrans.dmp > > > > Export: Release 8.1.7.0.0 - Production on Tue Jun > 19 19:30:37 2001 > > > > (c) Copyright 2000 Oracle Corporation. All rights > reserved. > > > > > > Username: sys as sysdba > > Password: > > > > Connected to: Oracle8i Enterprise Edition Release > 8.1.7.0.0 - Production > > JServer Release 8.1.7.0.0 - Production > > Export done in WE8ISO8859P1 character set and > WE8ISO8859P1 NCHAR character > > set > > Note: table data (rows) will not be exported > > About to export transportable tablespace > metadata... > > > > > > > > > ** > > This email and any files transmitted with it are > confidential and &g
RE: Transportable tablespace problem in 817
This is a bug. You've probably got an ORA-600 too in your alert log. I had the same problem and upgraded to 8.1.7.1 to fix it. Saul Solomon Senior Database Administrator PPG Industries [EMAIL PROTECTED] 412 434-3504 -Original Message- Sent: Tuesday, June 19, 2001 4:22 PM To: Multiple recipients of list ORACLE-L I'm trying to a transportable but the export session is hanging. The v$session says the session is actually active. Anybody here has any such experience? Any ideas to resolve this? Thanks Kumanan SQL> set autoprint on serveroutput on SQL> exec dbms_tts.transport_set_check ('DATA',TRUE); PL/SQL procedure successfully completed. SQL> select * from sys.transport_set_violations; VIOLATIONS Index KBALASUN.PK_USERS_USERID in tablespace INDEXTS enforces primary constriant s of table KBALASUN.USERS in tablespace DAT SQL> exec dbms_tts.transport_set_check ('DATA,INDEXTS',TRUE); PL/SQL procedure successfully completed. SQL> select * from sys.transport_set_violations; no rows selected alter tablespace data read only; alter tablespace data read only; /tmp $ env NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ORACLE_SID=KBDB ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data ORACLE_HOME=/export/home/oracle/product/8.1.7 /tmp $ exp transport_tablespace=y tablespaces=DATA,INDEXTS file=testtrans.dmp Export: Release 8.1.7.0.0 - Production on Tue Jun 19 19:30:37 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Username: sys as sysdba Password: Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set Note: table data (rows) will not be exported About to export transportable tablespace metadata... ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumanan Balasundaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB shutdown - NT
Michael, Thanks. I hadn't noticed that they changed Metalink so that you click on a different area to get the newest patches. Saul Solomon PPG Industries [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 14, 2001 2:43 PM To: Multiple recipients of list ORACLE-L Try patch 1711240 for getting from 8.1.7.0 to 8.1.7.1 and then patch 1797438 to get from 8.1.7.1 to 8.1.7.1.3. I know I found them on MetaLink, so if I recall the navigation I'll let you know. HTH, Mike "Solomon, Saul M." wrote: > Paul, > > But where is this patchset. It's not on Metalink or the ftp sites. > > Saul Solomon > PPG Industries > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, June 13, 2001 10:06 AM > To: Multiple recipients of list ORACLE-L > > "O'Neill, Sean" wrote: > > > > I'm trying to configure systems to shutdown immediate Oracle when NT server > > is shutdown. I've followed instructions in Admin manual for registry > > settings and being trying it on Oracle PE 8.1.7.0.0 but it don't appear to > > work. Oracle does crash recovery when PC [NT4-SP6a] is bounced. Current > > registry settings are: > > ora_DBATest_shutdown = TRUE > > ora_DBATest_shutdowntype = i > > ora_DBATest_shutdown_timeout = 30 > > > > I'd like to get this working for the following versions of Oracle on our > > production NT servers. Maybe a patch set is required, is so I'd appreciate > > patch set ID. If it can't be done for particular version please let me > > know. > > 7.3.3.0.0 > > 8.0.5.0.0 > > 8.1.7.0.0 > > > > I could spend a "while" trying to look all this up on MetaLink but if anyone > > has "been there" would appreciate your input! > > > > Sean :) > > > > Sean, > > this is for 8.1.7.1.2 > > HKLM\Software\Oracle\Home0 > > Value 3 > Name:ORA_DEV_AUTOSTART > Type:REG_EXPAND_SZ > Data:TRUE > > Value 4 > Name:ORA_DEV_PFILE > Type:REG_EXPAND_SZ > Data:D:\Oracle\admin\DEV\pfile\initDEV.ora > > Value 5 > Name:ORA_DEV_SHUTDOWN > Type:REG_EXPAND_SZ > Data:TRUE > > Value 6 > Name:ORA_DEV_SHUTDOWN_TIMEOUT > Type:REG_EXPAND_SZ > Data:180 << 30 seconds is not >sufficient > > Value 7 > Name:ORA_DEV_SHUTDOWNTYPE > Type:REG_EXPAND_SZ > Data:i > > Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2 > for 6 weeks. > > Paul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Drake > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Solomon, Saul M. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Solutions Consulting, LLC a Perot Systems Company http://www.SolutionsConsulting.com http://www.PerotSystems.com phone: 513.891.3423 ext. 7010 fax: 513.891.3775 email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael S. Siebert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
RE: DB shutdown - NT
Paul, But where is this patchset. It's not on Metalink or the ftp sites. Saul Solomon PPG Industries [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 13, 2001 10:06 AM To: Multiple recipients of list ORACLE-L "O'Neill, Sean" wrote: > > I'm trying to configure systems to shutdown immediate Oracle when NT server > is shutdown. I've followed instructions in Admin manual for registry > settings and being trying it on Oracle PE 8.1.7.0.0 but it don't appear to > work. Oracle does crash recovery when PC [NT4-SP6a] is bounced. Current > registry settings are: > ora_DBATest_shutdown = TRUE > ora_DBATest_shutdowntype = i > ora_DBATest_shutdown_timeout = 30 > > I'd like to get this working for the following versions of Oracle on our > production NT servers. Maybe a patch set is required, is so I'd appreciate > patch set ID. If it can't be done for particular version please let me > know. > 7.3.3.0.0 > 8.0.5.0.0 > 8.1.7.0.0 > > I could spend a "while" trying to look all this up on MetaLink but if anyone > has "been there" would appreciate your input! > > Sean :) > Sean, this is for 8.1.7.1.2 HKLM\Software\Oracle\Home0 Value 3 Name:ORA_DEV_AUTOSTART Type:REG_EXPAND_SZ Data:TRUE Value 4 Name:ORA_DEV_PFILE Type:REG_EXPAND_SZ Data:D:\Oracle\admin\DEV\pfile\initDEV.ora Value 5 Name:ORA_DEV_SHUTDOWN Type:REG_EXPAND_SZ Data:TRUE Value 6 Name:ORA_DEV_SHUTDOWN_TIMEOUT Type:REG_EXPAND_SZ Data:180 << 30 seconds is not sufficient Value 7 Name:ORA_DEV_SHUTDOWNTYPE Type:REG_EXPAND_SZ Data:i Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2 for 6 weeks. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Solomon, Saul M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).