RE: Logitech Give Away

2002-12-20 Thread Solomon, Saul M.
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.

2002-09-05 Thread Solomon, Saul M.
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

2002-06-24 Thread Solomon, Saul M.

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

2002-05-30 Thread Solomon, Saul M.

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

2002-03-28 Thread Solomon, Saul M.

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

2002-03-27 Thread Solomon, Saul M.

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

2001-06-21 Thread Solomon, Saul M.

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

2001-06-19 Thread Solomon, Saul M.

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

2001-06-15 Thread Solomon, Saul M.

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

2001-06-14 Thread Solomon, Saul M.

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).