Re: Oracle on NT

2002-06-05 Thread Jared . Still

1.  Does the Oracle service on Win2K run in the security domain of its
login user (LocalSys)?

A: It runs as SYSTEM by default.

2.  If so, would that explain why RMAN can't write to a network drive
that's mapped by a different user who is logged in to the domain rather
than the local machine?

A: Services running as the SYSTEM user cannot access network drives.

Side question:  Am I correct in my belief that the Oracle service must
be running before an Oracle instance can start, and that it keeps
running even when the instance is shut down?

A: The service must be running to start Oracle.  The service is actually
the VOS portion of Oracle. ( Virtual Operating System - see James
Morle's book ) 

When the instance is shutdown, the service may be stopped, but that
is not required.

Jared

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



RE: Oracle on NT

2002-06-04 Thread Seefelt, Beth


Hi Paul,

I believe you are correct on all counts.  I have not used RMAN on NT, but if it will 
handle UNCs that might be the way to go. 

I believe that the local system account runs with the profile of the .Default user.  
If you could get the drive map into that profile that might work for you also.

Beth

-Original Message-
Sent: Tuesday, June 04, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L


A couple of basic questions, if you'll indulge me:

1.  Does the Oracle service on Win2K run in the security domain of its
login user (LocalSys)?
2.  If so, would that explain why RMAN can't write to a network drive
that's mapped by a different user who is logged in to the domain rather
than the local machine?

Side question:  Am I correct in my belief that the Oracle service must
be running before an Oracle instance can start, and that it keeps
running even when the instance is shut down?

Many TIA.

Paul Baumgartel


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: Seefelt, Beth
  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: Oracle on NT

2002-06-04 Thread Michael P Sale

Your assumption is correct. You can change this user as well, but you
need to make sure that this user has the proper permissions. To make
your life simpler you can just make sure that you make sure that this
user is a member of the local administrators group.

Side Question: Your assumption is again correct. If you try and start
the database without the service running from a command line you will
get an ora-12560. Very common mistake.

Regards,

Michael Sale
Consulting Technical Specialist
PLBDE 
Oracle Corporation
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Baumgartel
Sent: Tuesday, June 04, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L


A couple of basic questions, if you'll indulge me:

1.  Does the Oracle service on Win2K run in the security domain of its
login user (LocalSys)? 2.  If so, would that explain why RMAN can't
write to a network drive that's mapped by a different user who is logged
in to the domain rather than the local machine?

Side question:  Am I correct in my belief that the Oracle service must
be running before an Oracle instance can start, and that it keeps
running even when the instance is shut down?

Many TIA.

Paul Baumgartel


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: Michael P Sale
  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: Oracle on NT

2002-06-04 Thread Michael P Sale

Although Oracle _usually_ works fine with UNCs throughout, but I suggest
that you map a drive to avoid potential problems. The local system
account should NOT be used if you are attempting to perform some type of
priveleged activity that would require adding privs (e.g. accessing
anything via the network). 

If you do change the user running the Oracle service make sure that you
also change the listener(s) for that service to run under the same
account because the listener spawns the user thread in the oracle.exe
process. Thus if you leave it as the low priv local system account it
will fail to connect to you to the database.

This is also an issue you will run into with OEM activities that work
with mounted drives as the agent runs with the local system account.  

Shameless plug: All of this is covered in my book.

Regards,

Michael Sale
Consulting Technical Specialist
PLBDE 
Oracle Corporation
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Beth
Sent: Tuesday, June 04, 2002 5:17 PM
To: Multiple recipients of list ORACLE-L



Hi Paul,

I believe you are correct on all counts.  I have not used RMAN on NT,
but if it will handle UNCs that might be the way to go. 

I believe that the local system account runs with the profile of the
.Default user.  If you could get the drive map into that profile that
might work for you also.

Beth

-Original Message-
Sent: Tuesday, June 04, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L


A couple of basic questions, if you'll indulge me:

1.  Does the Oracle service on Win2K run in the security domain of its
login user (LocalSys)? 2.  If so, would that explain why RMAN can't
write to a network drive that's mapped by a different user who is logged
in to the domain rather than the local machine?

Side question:  Am I correct in my belief that the Oracle service must
be running before an Oracle instance can start, and that it keeps
running even when the instance is shut down?

Many TIA.

Paul Baumgartel


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: Seefelt, Beth
  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: Michael P Sale
  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: Oracle on NT

2002-04-02 Thread tday6


I think that he has a much more serious problem than setting the SID.  If I
understand the situation the Oracle Service (the instance) is not starting
because the ORACLE_HOME parameter in the registry is messed up (probably as
part of the upgrade).

Try clicking START, PROGRAMS, ORACLE FOR WIN2K (or something like that),
and see if you have 'Oracle Home Selector'.  After you set the ORACLE_HOME,
click START, PROGRAMS, ACCESSORIES (or ADMINISTRATIVE TOOLS - I forget
which {MS changed it in Win2K}) and SERVICES.  Scroll down until you see
the ORACLE. services and start the automatic start ones that haven't
started.

If the ORACLE_HOME is still messed up, then you'll have to dig into the
registry.  Look under HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE, ALL_HOMES.
There should be a parameter called HOME_COUNTER that will tell you how many
ORACLE_HOMES are set up on your machine.  Further branches will be IDn
where 0 is the first Oracle home, 1 is the second, etc.  Under those are
parameters NAME and PATH.  Find the one with the NAME DEFAULT_HOME and
set it's PATH to what you want the ORACLE_HOME to be (maybe something like
C:\ORACLE\ORACLE8I {include the quotes}).

Then scroll down to ORACLE_HOMES.  Under that will be folders named
ORACLEn, again where 0 is the first Oracle Home, 1 is the second, etc.
Here the parameter ORACLE_HOME should be the path, ie., what you set PATH
to be above.  One of the folders should have the parameter ORACLE_HOME_NAME
set to  DEFAULT_HOME.  This is the one that you want to set the
ORACLE_HOME to your chosen Oracle Home.  It can also have a
SHARED_ORACLE_HOME parameter that you should set to your Oracle Home.

Then reboot the machine for the registry changes to take effect and see if
the services have started.

You can check out the NSL_LANGUAGE parameters while you're there but my
experience is that that's a bogus error message.  Oracle can't find the
correct Oracle Home, tries to send you an error message, realizes that it
doesn't have the NSL_LANGUAGE parameter set, and settles for sending you an
error message to that effect.

BTW - save a copy of your registry before you try this!!!  From the
Registry Editor (regedit) click on 'registry' and 'export registry file' to
save a copy.   To change registry values right click on the parameter name.
You'll get a little pop-up.  Click 'Modify' and you'll get a little edit
window to edit the value.

Good luck - HTH



   

Boivin,   

Patrice J   To: Multiple recipients of list ORACLE-L  

BoivinP [EMAIL PROTECTED]

@mar.dfo-mpo.cc:   

gc.ca   Subject: RE: Oracle on NT 

Sent by: root  

   

   

04/01/2002 

07:08 PM   

Please 

respond to 

ORACLE-L   

   

   





Blake,

When you open a command line window (aka DOS session I like to call them),
remember to issue the following statement before you try to use sqlplus:

Set oracle_sid=put_your_SID_here

e.g.
set oracle_sid=ORCL
sqlplus

Then connect internal if you can.

I like to try something like select name from v$database to see if the
database is really up.  If it is, you will get the database name; if not...
Oracle will tell you.  You then probably should do a shutdown abort
followed
by startup (specify the pfile if Oracle doesn't know how to find it).

After rebooting, wait a couple of minutes before logging in.  Oracle
sometimes takes a while to get up and running on Windows NT 4, I strongly
suspect it's the same on Windows2000, since that is just NT 5 anyway.

You can always r-click on the bottom bar, where the minimized applications
appear.  Select Task Manager, and look at the Performance tab to see if the
memory has been allocated for your Oracle instance.

If you have more than one instance, you will need to set oracle_sid=xxx
before using the tools, or you need

RE: Oracle on NT

2002-04-01 Thread Boivin, Patrice J

Blake, 

When you open a command line window (aka DOS session I like to call them),
remember to issue the following statement before you try to use sqlplus:

Set oracle_sid=put_your_SID_here

e.g. 
set oracle_sid=ORCL
sqlplus

Then connect internal if you can.

I like to try something like select name from v$database to see if the
database is really up.  If it is, you will get the database name; if not...
Oracle will tell you.  You then probably should do a shutdown abort followed
by startup (specify the pfile if Oracle doesn't know how to find it).

After rebooting, wait a couple of minutes before logging in.  Oracle
sometimes takes a while to get up and running on Windows NT 4, I strongly
suspect it's the same on Windows2000, since that is just NT 5 anyway.

You can always r-click on the bottom bar, where the minimized applications
appear.  Select Task Manager, and look at the Performance tab to see if the
memory has been allocated for your Oracle instance.

If you have more than one instance, you will need to set oracle_sid=xxx
before using the tools, or you need to specify a connect string (e.g.
sqlplus [EMAIL PROTECTED])

The Oracle Agent is a separate issue, that can be started using lsnrctl
dbsnmp_start.  To check if it is up, try lsnrctl dbsnmp_status

Re. the Oracle Agent, it could be that the dbsnmp user does not yet exist in
your new database, if it doesn't, to create it you need to run catsnmp.sql
which is located in /oracle/ora81/rdbms/admin/.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Monday, April 01, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
Subject:Oracle on NT

  File: Card for Blake Wilson  I have the good fortune? of creating two
new databases on two Windows
2000 servers. I am familiar with Oracle on Solaris, but have no clue
about Windows 2000. I have installed Oracle release 8.1.7 and have
upgraded it to release 8.1.7.3. As part of the install I created the
demo database on both servers. All seemed fine.

I then created scripts to create a second database on one of the
servers. I have not run these scripts yet. I now cannot connect to the
demo database using sqlplus. I got an error message (I forgot to write
down the error number) saying that my NLS parameter was not set or
invalid. In HK_LOCAL_MACHINE the parameter is set to:
NLS_LANG:AMERICAN_AMERICA.WE8ISO8859P1. I could connect to this database
from my other server.

In my wisdom? I decided to reboot the server and see what happens. Now I
get the message on startup: 
Could not start ORACLEORAHOME81AGENT service on local computer
error 3221356553.

I cannot start the service manually. I cannot connect to the demo
database from either server. I get the message ORA-01033: ORACLE
initialization or shutdown in progress. I assume this has to do with the
oracle agent service not starting. 

What should my NLS parameter be? What can I do to start the oracle agent
service? Should there be a ORA_NLS33 parameter in the settings?

Thank you for any help.

Blake Wilson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  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: Oracle on NT startup question

2001-11-01 Thread tday6

I'm sorry.  I thought that you mounted a database and that the instance was
the area in memory (corresponding to the SGA and PGA) that Oracle used.  So
what is the instance?


   

Denham Eva 

EvaDTo: Multiple recipients of list ORACLE-L  

@TFMC.co.za [EMAIL PROTECTED]

Sent by: rootcc:   

 Subject: RE: Oracle on NT startup 
question
   

11/01/2001 

12:25 AM   

Please 

respond to 

ORACLE-L   

   

   







I am not sure I understand you correctly, but on NT Oracle runs as a
service and an instance(the mounted database). The service must be started
for the instance to be able to mount and connected to. However the service
can be started without having to mount the instance.

HTH
Denham

-Original Message-
Sent: Wednesday, October 31, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L

My understanding is that the instance is the service.  Can you start the
instance without a mounted database?

    Andrey
    Bronfin  To: Multiple recipients of
list ORACLE-L
    andreyb [EMAIL PROTECTED]
    @elrontelesof    cc:
    t.com   Subject: Oracle on NT startup
question
    Sent by: root
    10/31/2001
    04:35 AM
    Please
    respond to
    ORACLE-L




Dear list !

If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.

Thanks in advance.

DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
  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:
  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: Oracle on NT startup question

2001-11-01 Thread Denham Eva
Title: RE: Oracle on NT startup question





In UNIX there is not service process, but Win NT/2K requires it, something I discovered when I started to working on WIN env. Confusing if you do come from a UNIX env. Look at it this way the Service + the Database( Datafiles, redologs, controlfiles etc) are the instance. The Service is a process which is started in preparation for the mounting of the instance, in otherwords setting up the memory and so on. If you start up the service and not the instance(Database) you will get an error from the listener(also a service) stating that Oracle is not available. You will then be required to start the instance(Database) from svrmgrl/Sqlplus.

But as you have already discovered, the service can be setup to automatically start the instance(Database) once the service has started, making it almost UNIX like in that sense.

Come to think of it, if you open the services facility in the ControlPanel, right click on the oracle service, properties, you can change the startup mode from automatic to manual. Which will then not start the service or the instance at startup of the server. It will require you to start it manually very time.

HTH
Denham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle on NT startup question



I'm sorry. I thought that you mounted a database and that the instance was
the area in memory (corresponding to the SGA and PGA) that Oracle used. So
what is the instance?



 
 Denham Eva 
 EvaD To: Multiple recipients of list ORACLE-L 
 @TFMC.co.za [EMAIL PROTECTED] 
 Sent by: root cc: 
 Subject: RE: Oracle on NT startup question 
 
 11/01/2001 
 12:25 AM 
 Please 
 respond to 
 ORACLE-L 
 
 







I am not sure I understand you correctly, but on NT Oracle runs as a
service and an instance(the mounted database). The service must be started
for the instance to be able to mount and connected to. However the service
can be started without having to mount the instance.


HTH
Denham


-Original Message-
Sent: Wednesday, October 31, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


My understanding is that the instance is the service.  Can you start the
instance without a mounted database?


    Andrey
    Bronfin  To: Multiple recipients of
list ORACLE-L
    andreyb [EMAIL PROTECTED]
    @elrontelesof    cc:
    t.com   Subject: Oracle on NT startup
question
    Sent by: root
    10/31/2001
    04:35 AM
    Please
    respond to
    ORACLE-L





Dear list !


If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.


Thanks in advance.


DBAndrey


* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
  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: 
 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

RE: Oracle on NT startup question

2001-10-31 Thread Andrey Bronfin

Hi Zhangxiangli!
Thanks for your reply !
Tried what U've suggested , unfortunately it brings up the service and
therefore starts the instance.
I need something to start the service but not to startup the instance.
Thanks a lot !




-Original Message-
Sent: Wednesday, October 31, 2001 7:59 PM
To: Andrey Bronfin


try net start oracle service name command

good luck!

- Original Message - 
To: LazyDBA.com Discussion [EMAIL PROTECTED]
Sent: Wednesday, October 31, 2001 5:32 PM


 
 Dear list !
 
 If my NT server (which runs an Oracle instance) gets rebooted
accidentally,
 how can i bring up the Oracle services without starting up the instance ?
 I want to startup the instance with a script later .
 I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.
 
 Thanks in advance.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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: Oracle on NT startup question

2001-10-31 Thread Sinard Xing

Hi,

What kind of service you refering to Listeners ?

lsnrctl start

To start databse wihtout instance

startup nomount


Sinardy


-Original Message-
Sent: Wednesday, 31 October 2001 5:35 PM
To: Multiple recipients of list ORACLE-L



Dear list !

If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.

Thanks in advance.

DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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: Sinard Xing
  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: Oracle on NT startup question

2001-10-31 Thread Sinard Xing

the previous I think can be apply for both versions

-Original Message-
Sent: Wednesday, 31 October 2001 5:35 PM
To: Multiple recipients of list ORACLE-L



Dear list !

If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.

Thanks in advance.

DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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: Sinard Xing
  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: Oracle on NT startup question

2001-10-31 Thread Denham Eva
Title: RE: Oracle on NT startup question





Hi 


You will have to use the oradim utility to remove the current service.
Then recreate the service using the parameter -STARTTYPE SRVC. This then causes the system to start only the service and not the instance.

[-STARTTYPE SRVC | INST | SRVC, INST] 


HTH
Denham




-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle on NT startup question




Dear list !


If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.


Thanks in advance.


DBAndrey


* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
 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: Oracle on NT startup question

2001-10-31 Thread Igor Neyman

Try to set registry entry ORA_%SID%_AUTOSTART to FALSE
in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 31, 2001 4:35 AM



 Dear list !

 If my NT server (which runs an Oracle instance) gets rebooted
accidentally,
 how can i bring up the Oracle services without starting up the instance ?
 I want to startup the instance with a script later .
 I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.

 Thanks in advance.

 DBAndrey

 * 03-9254520
 * 053-464562
 * mailto:[EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrey Bronfin
   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: Igor Neyman
  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: Oracle on NT startup question

2001-10-31 Thread tday6

My understanding is that the instance is the service.  Can you start the
instance without a mounted database?


   

Andrey 

Bronfin  To: Multiple recipients of list ORACLE-L  

andreyb [EMAIL PROTECTED]

@elrontelesofcc:   

t.com   Subject: Oracle on NT startup question

Sent by: root  

   

   

10/31/2001 

04:35 AM   

Please 

respond to 

ORACLE-L   

   

   






Dear list !

If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.

Thanks in advance.

DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
  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).



RE: Oracle on NT startup question

2001-10-31 Thread Denham Eva
Title: RE: Oracle on NT startup question





I am not sure I understand you correctly, but on NT Oracle runs as a service and an instance(the mounted database). The service must be started for the instance to be able to mount and connected to. However the service can be started without having to mount the instance.

HTH
Denham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle on NT startup question



My understanding is that the instance is the service. Can you start the
instance without a mounted database?



 
 Andrey 
 Bronfin To: Multiple recipients of list ORACLE-L 
 andreyb [EMAIL PROTECTED] 
 @elrontelesof cc: 
 t.com Subject: Oracle on NT startup question 
 Sent by: root 
 
 
 10/31/2001 
 04:35 AM 
 Please 
 respond to 
 ORACLE-L 
 
 






Dear list !


If my NT server (which runs an Oracle instance) gets rebooted accidentally,
how can i bring up the Oracle services without starting up the instance ?
I want to startup the instance with a script later .
I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4.


Thanks in advance.


DBAndrey


* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
 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).





RE: Oracle on NT unattended installation

2001-07-12 Thread O'Neill, Sean

Andrey,

Oracle8i Installation Guide Rel 3 for Win NT, Part Number A85302-01,
Appendix C 'Advanced Installation Topics', should be of some use.


Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King


--

 From: Andrey Bronfin [EMAIL PROTECTED]
 Date: Wed, 11 Jul 2001 17:27:29 +0200
 Subject: Oracle on NT unattended installation

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C10A1D.FF199300
Content-Type: text/plain;
charset=windows-1255

Dear list !
Is there a possibility to do an unattended installation of Oracle server
(8.1.7) on NT (Win2000) ?
I mean an installation with a script or so without answering questions and
clicking 'Next' during the installation.
If there is such a possibility for NT , would You please point me to a
manual ?
I tried to RTFM and found nothing.
Thanks a lot in advance.
Andrey.
-- 
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).



RE: Oracle on NT unattended installation

2001-07-11 Thread JOE TESTA



Ed, you've gotten thats to work?, theory is nice, but r/l is 
what counts

joe

 [EMAIL PROTECTED] 07/11/01 02:05PM 

Audrey,

Yes, 
you can do a silent install. On a workstation / server that has Oracle 
installed (NT/2000), go to:

START 
| PROGRAMS | Oracle Installation Products | Universal Installed Concepts 
Guide

This 
is in HTML format and will show you how you can do a silent 
install.

Ed

  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on NT unattended installation
  Dear list ! Is 
  there a possibility to do an unattended installation of Oracle server (8.1.7) 
  on NT (Win2000) ? I mean an installation 
  with a script or so without answering questions and clicking 'Next' during the 
  installation. If there is such a 
  possibility for NT , would You please point me to a manual ? I tried to RTFM and found nothing. Thanks a lot in advance. Andrey. 


RE: Oracle on NT unattended installation

2001-07-11 Thread Haskins, Ed



Joe,

I've done it for the Oracle 
Client, successfully. This question was posted on LazyDBA, and a couple 
others responded that they were successful with it.

Ed

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 2:41 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle on NT unattended installation
  Ed, you've gotten thats to work?, theory is nice, but r/l is 
  what counts
  
  joe
  
   [EMAIL PROTECTED] 07/11/01 02:05PM 
  
  Audrey,
  
  Yes, 
  you can do a silent install. On a workstation / server that has Oracle 
  installed (NT/2000), go to:
  
  START | PROGRAMS | Oracle Installation Products | 
  Universal Installed Concepts Guide
  
  This 
  is in HTML format and will show you how you can do a silent 
  install.
  
  Ed
  
-Original Message-From: Andrey Bronfin 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle on NT unattended installation
Dear list ! Is 
there a possibility to do an unattended installation of Oracle server 
(8.1.7) on NT (Win2000) ? I mean an 
installation with a script or so without answering questions and clicking 
'Next' during the installation. If there 
is such a possibility for NT , would You please point me to a manual 
? I tried to RTFM and found 
nothing. Thanks a lot in advance. 
Andrey. 



RE: Oracle on NT unattended installation

2001-07-11 Thread JOE TESTA



Ed thats great no one here has been successful with it(or that 
will at least own up to it) ;)

joe

 [EMAIL PROTECTED] 07/11/01 03:01PM 

Joe,

I've done it for the Oracle 
Client, successfully. This question was posted on LazyDBA, and a couple 
others responded that they were successful with it.

Ed

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 2:41 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle on NT unattended installation
  Ed, you've gotten thats to work?, theory is nice, but r/l is 
  what counts
  
  joe
  
   [EMAIL PROTECTED] 07/11/01 02:05PM 
  
  Audrey,
  
  Yes, 
  you can do a silent install. On a workstation / server that has Oracle 
  installed (NT/2000), go to:
  
  START | PROGRAMS | Oracle Installation Products | 
  Universal Installed Concepts Guide
  
  This 
  is in HTML format and will show you how you can do a silent 
  install.
  
  Ed
  
-Original Message-From: Andrey Bronfin 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle on NT unattended installation
Dear list ! Is 
there a possibility to do an unattended installation of Oracle server 
(8.1.7) on NT (Win2000) ? I mean an 
installation with a script or so without answering questions and clicking 
'Next' during the installation. If there 
is such a possibility for NT , would You please point me to a manual 
? I tried to RTFM and found 
nothing. Thanks a lot in advance. 
Andrey. 



RE: Oracle on NT/2000 Service shutdown

2001-04-24 Thread Mark Leith

As a side note - I have noticed with 8.1.7 on Win2K that sometimes the
service literally shuts down as quick as the listener service! Never saw
this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody
else noticed this?

Mark

-Original Message-
Daiminger
Sent: Tuesday, April 24, 2001 12:55
To: Multiple recipients of list ORACLE-L


Hi!

I found something interesting on the Windows 2000 FAQ site:

Q. How can I increase the time that services have to shut down?

A. By default, the OS allows services 20 seconds to stop before it
forcefully halts them. For services that have a large amount of
information in memory (e.g., Internet Security and
Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To
increase the time the system allows, perform the following steps:
   1. Start regedit.exe.
   2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
   3. Double-click WaitToKillServiceTimeout.
   4. Set this value to the desired wait time in milliseconds--6 is
1 minute.
   5. Click OK.
   6. Close regedit.
   7. Reboot the machine.

Note that this value applies to ALL services, so setting it to a longer
interval might slow your computer's shut down: if a service doesn't shut
down correctly, it will have a longer time before the OS halts it.


This is certainly useful for all of us who use Oracle on Windows.

hth,
Helmut

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle on NT/2000 Service shutdown

2001-04-24 Thread Szecsy Tamas

Cann't it be that shutdown goes quickly and startup is slow? 
If I remember it well there is a possibility with Oracle 8.1.x(x=?) to set
startup time for a database. This is to garantee startup time.

Tamas Szecsy

-Original Message-
Sent: 2001.04.24. 12:40 PM
To: Multiple recipients of list ORACLE-L


As a side note - I have noticed with 8.1.7 on Win2K that sometimes the
service literally shuts down as quick as the listener service! Never saw
this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody
else noticed this?

Mark

-Original Message-
Daiminger
Sent: Tuesday, April 24, 2001 12:55
To: Multiple recipients of list ORACLE-L


Hi!

I found something interesting on the Windows 2000 FAQ site:

Q. How can I increase the time that services have to shut down?

A. By default, the OS allows services 20 seconds to stop before it
forcefully halts them. For services that have a large amount of
information in memory (e.g., Internet Security and
Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To
increase the time the system allows, perform the following steps:
   1. Start regedit.exe.
   2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
   3. Double-click WaitToKillServiceTimeout.
   4. Set this value to the desired wait time in milliseconds--6 is
1 minute.
   5. Click OK.
   6. Close regedit.
   7. Reboot the machine.

Note that this value applies to ALL services, so setting it to a longer
interval might slow your computer's shut down: if a service doesn't shut
down correctly, it will have a longer time before the OS halts it.


This is certainly useful for all of us who use Oracle on Windows.

hth,
Helmut

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Szecsy Tamas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle on NT/2000 Service shutdown

2001-04-24 Thread Kimberly Smith

I have not noticed this with Win 2000 but I have noticed it on HP.
Granted the machine we are running it on is quicker then the one 
with 8.0.6 but it was very quick to fail over to the other server.
Up and down quick.

-Original Message-
Sent: Tuesday, April 24, 2001 3:40 AM
To: Multiple recipients of list ORACLE-L


As a side note - I have noticed with 8.1.7 on Win2K that sometimes the
service literally shuts down as quick as the listener service! Never saw
this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody
else noticed this?

Mark

-Original Message-
Daiminger
Sent: Tuesday, April 24, 2001 12:55
To: Multiple recipients of list ORACLE-L


Hi!

I found something interesting on the Windows 2000 FAQ site:

Q. How can I increase the time that services have to shut down?

A. By default, the OS allows services 20 seconds to stop before it
forcefully halts them. For services that have a large amount of
information in memory (e.g., Internet Security and
Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To
increase the time the system allows, perform the following steps:
   1. Start regedit.exe.
   2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control.
   3. Double-click WaitToKillServiceTimeout.
   4. Set this value to the desired wait time in milliseconds--6 is
1 minute.
   5. Click OK.
   6. Close regedit.
   7. Reboot the machine.

Note that this value applies to ALL services, so setting it to a longer
interval might slow your computer's shut down: if a service doesn't shut
down correctly, it will have a longer time before the OS halts it.


This is certainly useful for all of us who use Oracle on Windows.

hth,
Helmut

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  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).