Re: Oracle on NT
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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).