RE: Service startup on Windows 2000 fails
I cannot trust my network admins. They do crap without any notification. They will make a change and then I will spend the next day trying to figure out what happened. Their typical response is Oh, we didn't know that the databases would be affected. DO NOT TRUST NETWORK ADMINS. And from my time working in IS I have found that network admins have no communication skills. These are NT guys. I had better luck with unix network admins though. Go figure. Dave -Original Message- Sent: Wednesday, February 19, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Lyndon, I wish I knew what caused the problem. And I have no idea how the monkey that broke it solved the problem. I think it had something to do with removing folder shares, but I'm not sure. I am so busy whipping out volumes of pl/sql code that I can't stop to understand why. I have to figure out how to smooth over the fact that we lost one day in our already tight schedule that is making it necessary for me to work from home at night (DSL + VPN = FUN! Sometimes.) Cut, Paste, Test, Kill. Lather, rinse, repeat. Wish I could just leave work and get pissed out of my tree. Mrs. Monkey. -Original Message- Sent: Wednesday, February 19, 2003 2:30 PM To: [EMAIL PROTECTED]; Koivu, Lisa Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting Koivu, Lisa [EMAIL PROTECTED]: Hi Wayne, Thanks so much for responding. I guess my lack of knowledge of Windows 2000 administration has just bit me in the ass. A description of a paintbrush-style change applied to our servers by the network support people in another office is what completely and totally HOSED services on two development boxes. Of course, a communication went out to a list of people that *didn't* include me or my boss, or the people who actually support my servers here in Ft. Lauderdale. GR I screamed at the guy ( what? me? NO! ) and it will not happen again. The really sad part is that I wouldn't know what permissions need to be where and why. Add that to the very long list of things to investigate between whipping out stupid pl/sql code and changing diapers. Anyway everything is back and I am happy again. I hope everyone has a better day than me. Mrs. Monkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Lisa, I'm using Windows 2000 with Oracle DataBase 9i. And I had a similar problem with you afer install the database. The Listener service does not show in the list of Windows services. Try stop the listener and restart it. Use the application LSNRCTL at Commaand Prompt Type STOP and them START. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, February 19, 2003, 11:08:53 AM, you wrote: KL Service startup on Windows 2000 failsGood morning everyone, KL Windows 2000 sp3, ver 8.1.7.2 KL I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, KL nothing. KL Here's what I've tried: KL Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. KL All logons are part of the administrator and the ORA_DBA group. KL I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. KL Local system account also fails with same error. KL Here's the error I receive when I try to manually start the listener service: KL Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the KL problem persists, contact your system administrator. KL I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. KL Any suggestions would be helpful. Thanks KL Lisa Koivu KL Oracle Database Administrator KL Fairfield Resorts, Inc. KL 5259 Coconut Creek Parkway KL Ft. Lauderdale, FL, USA 33063 KL Office: 954-935-4117 KL Fax: 954-935-3639 KL Cell: 954-683-4459 KL -- KL Please see the official ORACLE-L FAQ: http://www.orafaq.net KL -- KL Author: Koivu, Lisa KL INET: [EMAIL PROTECTED] KL Fat City Network Services-- 858-538-5051 http://www.fatcity.com KL San Diego, California-- Mailing list and web hosting services KL - KL To REMOVE yourself from this mailing list, send an E-Mail message KL to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in KL the message BODY, include a line containing: UNSUB ORACLE-L KL (or the name of mailing list you want to be removed from). You may KL also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
OURs keeps telling me what a piece of crap Oracle Apps is, not nice and simple like an OS install or an Office migration and WHAT would they need to test what THEY do for... they blanket install everything the same time... it IS after all, only an OS patch..but when apps pukes because no one told anyone about the OS patch, and I have to spend a week playing chase the itar only to find out what they did and all it will take to fix it... Who knew Piece of Crap software grrr April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Thursday, February 20, 2003 4:59 AM To: Multiple recipients of list ORACLE-L I cannot trust my network admins. They do crap without any notification. They will make a change and then I will spend the next day trying to figure out what happened. Their typical response is Oh, we didn't know that the databases would be affected. DO NOT TRUST NETWORK ADMINS. And from my time working in IS I have found that network admins have no communication skills. These are NT guys. I had better luck with unix network admins though. Go figure. Dave -Original Message- Sent: Wednesday, February 19, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Lyndon, I wish I knew what caused the problem. And I have no idea how the monkey that broke it solved the problem. I think it had something to do with removing folder shares, but I'm not sure. I am so busy whipping out volumes of pl/sql code that I can't stop to understand why. I have to figure out how to smooth over the fact that we lost one day in our already tight schedule that is making it necessary for me to work from home at night (DSL + VPN = FUN! Sometimes.) Cut, Paste, Test, Kill. Lather, rinse, repeat. Wish I could just leave work and get pissed out of my tree. Mrs. Monkey. -Original Message- Sent: Wednesday, February 19, 2003 2:30 PM To: [EMAIL PROTECTED]; Koivu, Lisa Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting Koivu, Lisa [EMAIL PROTECTED]: Hi Wayne, Thanks so much for responding. I guess my lack of knowledge of Windows 2000 administration has just bit me in the ass. A description of a paintbrush-style change applied to our servers by the network support people in another office is what completely and totally HOSED services on two development boxes. Of course, a communication went out to a list of people that *didn't* include me or my boss, or the people who actually support my servers here in Ft. Lauderdale. GR I screamed at the guy ( what? me? NO! ) and it will not happen again. The really sad part is that I wouldn't know what permissions need to be where and why. Add that to the very long list of things to investigate between whipping out stupid pl/sql code and changing diapers. Anyway everything is back and I am happy again. I hope everyone has a better day than me. Mrs. Monkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has
RE: Service startup on Windows 2000 fails
April - One thing I've discovered is everyone is frustrated with their ERP, whether it is Oracle Apps, SAP, Peoplesoft, etc. I think the ERP systems are vastly more complex than a mere OS, or maybe not so self-contained. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 6:44 AM To: Multiple recipients of list ORACLE-L OURs keeps telling me what a piece of crap Oracle Apps is, not nice and simple like an OS install or an Office migration and WHAT would they need to test what THEY do for... they blanket install everything the same time... it IS after all, only an OS patch..but when apps pukes because no one told anyone about the OS patch, and I have to spend a week playing chase the itar only to find out what they did and all it will take to fix it... Who knew Piece of Crap software grrr April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Thursday, February 20, 2003 4:59 AM To: Multiple recipients of list ORACLE-L I cannot trust my network admins. They do crap without any notification. They will make a change and then I will spend the next day trying to figure out what happened. Their typical response is Oh, we didn't know that the databases would be affected. DO NOT TRUST NETWORK ADMINS. And from my time working in IS I have found that network admins have no communication skills. These are NT guys. I had better luck with unix network admins though. Go figure. Dave -Original Message- Sent: Wednesday, February 19, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Lyndon, I wish I knew what caused the problem. And I have no idea how the monkey that broke it solved the problem. I think it had something to do with removing folder shares, but I'm not sure. I am so busy whipping out volumes of pl/sql code that I can't stop to understand why. I have to figure out how to smooth over the fact that we lost one day in our already tight schedule that is making it necessary for me to work from home at night (DSL + VPN = FUN! Sometimes.) Cut, Paste, Test, Kill. Lather, rinse, repeat. Wish I could just leave work and get pissed out of my tree. Mrs. Monkey. -Original Message- Sent: Wednesday, February 19, 2003 2:30 PM To: [EMAIL PROTECTED]; Koivu, Lisa Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting Koivu, Lisa [EMAIL PROTECTED]: Hi Wayne, Thanks so much for responding. I guess my lack of knowledge of Windows 2000 administration has just bit me in the ass. A description of a paintbrush-style change applied to our servers by the network support people in another office is what completely and totally HOSED services on two development boxes. Of course, a communication went out to a list of people that *didn't* include me or my boss, or the people who actually support my servers here in Ft. Lauderdale. GR I screamed at the guy ( what? me? NO! ) and it will not happen again. The really sad part is that I wouldn't know what permissions need to be where and why. Add that to the very long list of things to investigate between whipping out stupid pl/sql code and changing diapers. Anyway everything is back and I am happy again. I hope everyone has a better day than me. Mrs. Monkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally
RE: Service startup on Windows 2000 fails
Title: Message Can you start the service via oradim? CMD oradim C:\oradim -STARTUP -SID -USRPWD -STARTTYPE srvc,inst -PFILE C:\your_path\ can you start the db via svrmgrl? CMDset oracle_sid=mysid svrmgrl connect internal/* startup pfile=. have you tried rebooting and logging on as the administrator? here are known bugs on w2k and autosatarting 136214.1 Oracle8i Startup, Shutdown Related Registry Entries on WindowsNT Windows2000 135375.1 Database Autostart Fails Even When OracleServiceSID is Started Automatic 1022458.6 AUTOSTART OF INSTANCE AT OS BOOT TIME IS NOT WORKING 62006.1 Troubleshooting Tips Database Not Autostarting the one that fixed my problem (thanks Jared) was Patch 1522966 This patch is very easy to apply and replaces the orannts8.dll see the read me for that patch hth bob Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Try looking in the Event Viewer. For Win 2K that's under START - SETTINGS - CONTROL PANEL - ADMINISTRATIVE TOOLS. Hopefully it will tell you something. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @efairfield.com cc: Sent by: rootSubject: Service startup on Windows 2000 fails 02/19/2003 09:08 AM Please respond to ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Title: Service startup on Windows 2000 fails Lisa, Just a thought - did you try starting the listener from the command line - lsnrctl start? Arup - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 19, 2003 9:08 AM Subject: Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Title: Service startup on Windows 2000 fails Lisa, Just re-read your note and realized that you are not able tostart anyOracle service. Is the server a Pentium IV (just a thought)? Is this a new install? Or did it juststart happening?Does a re-boot of the server make any difference? Could well be a permissions/access issue. Trying to runLSNRCTL from the command line may still giveyou some more meaningful clues.. Vikram. -Original Message-From: Khushalani, Vikram Sent: Wednesday, February 19, 2003 11:18 AMTo: '[EMAIL PROTECTED]'Subject: RE: Service startup on Windows 2000 fails Lisa, To start with - try to run the LSNRCTL command from a 'command line' prompt (you get the command line prompt bytyping 'CMD' from the 'START'--- then --- 'RUN' box) on the server where the Listenerought tobe running. Once you get the LSNRCTL prompt you can type the 'START' command, which will try to start the Listener. This will, hopefully, give you more meaningful messages so that you then try to resolve the issue. Note down and follow-up on any TNS-X errors, etc. You can also issue the 'STATUS' command to show the current status of the Listener or the 'HELP' command to list the various commands you can issue. Once you are done you can exit by issuing the 'Exit' (or Quit) command. You might also find these two notesuseful: 33589.1 and 126074.1on Metalink. HTH, Vikram. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 9:09 AMTo: Multiple recipients of list ORACLE-LSubject: Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Lisa, What error do you get when you try lsnrctl start from the command line? Have you tried oradim from the command line to start the DB service? Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Koivu, Lisa Lisa.Koivu@efairTo: Multiple recipients of list ORACLE-L field.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Service startup on Windows 2000 fails 02/19/2003 08:08 AM Please respond to ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
On Wed, Feb 19, 2003 at 06:08:54AM -0800, Koivu, Lisa wrote: -- tell the sysadmin to look in the event log for system, apps, and security. Probably some hints in there. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Lisa, Pick your favorite sid on that server ex. lisa delete the password file associated with sid lisa. It will be in your oracle_home\database directory. At the command prompt delete that instance. This will not delete the database oradim -delete -sid lisa Recreate service using oradim -new -sid lisa -intpwd newpwd -maxusers 30 -startmode auto -pfile fullpath\initlisa.ora Alway review the oradim.log in your oracle_home\database directory after running each oradim Try connecting to database Rick Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by:Subject: Service startup on Windows 2000 fails [EMAIL PROTECTED] 02/19/2003 09:08 AM Please respond to ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Lisa, Have you checked the .log files in %ORACLE_HOME%/network/log ? From my experience, I get this error every time there's an Oracle config problem with the service, instead of a Windows config problem. HTH! GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, February 19, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Title: Service startup on Windows 2000 fails lsnrctl80 start might need to prefix it with the listener name, too... April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Service startup on Windows 2000 fails Lisa, Just a thought - did you try starting the listener from the command line - lsnrctl start? Arup - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 19, 2003 9:08 AM Subject: Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Service startup on Windows 2000 fails
Lisa, I'd suggest checking the application log in Windows event viewer - usually contains something even if the on-screen response suggests no error returned. You should see things like Audit trail: ACTION : 'SHUTDOWN' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: SYSTEM CLIENT TERMINAL: STUPIDMACHINE STATUS: 0 . and a bunch of PGA instantiation events for SMON, PMON, etc (e.g. Initializing PGA for process RECO in instance stupid1) Given your services are failing, you should see a bunch of errors (whether they're useful is another story ...) If that fails to shed any light, also try the listener log / alert log, and see if there are any tell tale errors there. Ciao Fuzzy :-) (and yes, my windoze box is called STUPIDMACHINE ... that way it knows when I'm talking to it :-) ) -Original Message- Sent: Wednesday, February 19, 2003 14:09 To: Multiple recipients of list ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
what happens if try starting the listener from the command line. [EMAIL PROTECTED] 2/19/03 9:08:53 AM Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried:Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Koivu, Lisa INET: [EMAIL PROTECTED] City Network Services-- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Check to make sure Oracle is not using NT PDC authentication. Maybe you do not have a PDC in the network and Oracle would not start becauise of this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Title: Message Lisa Sorry, I misread your message, I had theimpression the db would notstart... not that the listener would not start. Is it possible you/someone installed oracle that was not an administrator, at the time of install. Sounds like a permissions problem. possible solution to uninstall/ clean the registry (remove all referenced to oracle in the registry with the exceptions of legacy apps) and reinstall as administrator have you tried running other services ? like lsnrctl? Im running Windows 2000 sp3, ver 8.1.7.2 here without any issue at all (other than the autostart patch problem I posted earlier patch 1522966) bob Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Title: Service startup on Windows 2000 fails Hi Wayne, Thanks so much for responding. I guess my lack of knowledge of Windows 2000 administration has just bit me in the ass. A description of a paintbrush-style change applied to our servers by the network support people in another office is what completely and totally HOSED services on two development boxes. Of course, a communication went out to a list of people that *didn't* include me or my boss, or the people who actually support my servers here in Ft. Lauderdale. GR I screamed at the guy ( what? me?NO! ) and it will not happen again. The really sad part is that I wouldn't know what permissions need to be where and why. Add that to the very long list of things to investigate between whipping out stupid pl/sql code and changing diapers. Anyway everything is back and I am happy again. I hope everyone has a better day than me. Mrs. Monkey -Original Message-From: Wayne Straughn [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 11:04 AMTo: Koivu, LisaSubject: RE: Service startup on Windows 2000 failsImportance: High Ok I see that you have rebooted already, sorry... well my first comments stil stand.. what's the recent history on this box? -Original Message-From: Wayne Straughn Sent: Wednesday, February 19, 2003 12:00 PMTo: '[EMAIL PROTECTED]'Subject: RE: Service startup on Windows 2000 failsImportance: High Hi Lisa A question Did you recently make any changes to that machine? , ie upgrade or install anything? it's possible another application may have caused this sudden problem. Also have you tried rebooting the server and then trying to start the services? I would trya reboot first before looking at other things. Could you try that and then tell us how it goes? Wayne Straughn Database Administrator Barbados Light Power Co Ltd -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 10:09 AMTo: Multiple recipients of list ORACLE-LSubject: Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
On Wed, Feb 19, 2003 at 08:14:13AM -0800, Thomas Day wrote: Try looking in the Event Viewer. For Win 2K that's under START - SETTINGS When you are forced into using a toy operating system (read: unix bigot) like this you need to have tools that show you what the toy is doing to you. Kind of like stdout on a unix box. One of the greatest little utils I have found to open the win pandora's box is regmon and filemon. These help you find out what the system is choking on sometimes: www.sysinternals.com/ntw2k/utilities.shtml Hope it helps, it has for me at times. - CONTROL PANEL - ADMINISTRATIVE TOOLS. Hopefully it will tell you something. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @efairfield.com cc: Sent by: rootSubject: Service startup on Windows 2000 fails 02/19/2003 09:08 AM Please respond to ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Service startup on Windows 2000 fails
Lyndon, I wish I knew what caused the problem. And I have no idea how the monkey that broke it solved the problem. I think it had something to do with removing folder shares, but I'm not sure. I am so busy whipping out volumes of pl/sql code that I can't stop to understand why. I have to figure out how to smooth over the fact that we lost one day in our already tight schedule that is making it necessary for me to work from home at night (DSL + VPN = FUN! Sometimes.) Cut, Paste, Test, Kill. Lather, rinse, repeat. Wish I could just leave work and get pissed out of my tree. Mrs. Monkey. -Original Message- Sent: Wednesday, February 19, 2003 2:30 PM To: [EMAIL PROTECTED]; Koivu, Lisa Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting Koivu, Lisa [EMAIL PROTECTED]: Hi Wayne, Thanks so much for responding. I guess my lack of knowledge of Windows 2000 administration has just bit me in the ass. A description of a paintbrush-style change applied to our servers by the network support people in another office is what completely and totally HOSED services on two development boxes. Of course, a communication went out to a list of people that *didn't* include me or my boss, or the people who actually support my servers here in Ft. Lauderdale. GR I screamed at the guy ( what? me? NO! ) and it will not happen again. The really sad part is that I wouldn't know what permissions need to be where and why. Add that to the very long list of things to investigate between whipping out stupid pl/sql code and changing diapers. Anyway everything is back and I am happy again. I hope everyone has a better day than me. Mrs. Monkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting Koivu, Lisa [EMAIL PROTECTED]: Hi Wayne, Thanks so much for responding. I guess my lack of knowledge of Windows 2000 administration has just bit me in the ass. A description of a paintbrush-style change applied to our servers by the network support people in another office is what completely and totally HOSED services on two development boxes. Of course, a communication went out to a list of people that *didn't* include me or my boss, or the people who actually support my servers here in Ft. Lauderdale. GR I screamed at the guy ( what? me? NO! ) and it will not happen again. The really sad part is that I wouldn't know what permissions need to be where and why. Add that to the very long list of things to investigate between whipping out stupid pl/sql code and changing diapers. Anyway everything is back and I am happy again. I hope everyone has a better day than me. Mrs. Monkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Service startup on Windows 2000 fails
Thanks, I might have to go there. We had a Win2K box today with SYSTEM using 100% of the CPU. I tracked the problem to a single system thread (using Performance monitor ProgramsAdministrative ToolsPerformance), but I have no idea how to tell what that thread is doing. Maybe I'll give sysinternals a try. (our sysadm wants to reapply an already applied service pack and reboot. Don't know if I'll get to more digging before that, but I'm sure the problem will resurface again later:) Henry -Original Message- Sent: Wednesday, February 19, 2003 2:14 PM To: Multiple recipients of list ORACLE-L On Wed, Feb 19, 2003 at 08:14:13AM -0800, Thomas Day wrote: Try looking in the Event Viewer. For Win 2K that's under START - SETTINGS When you are forced into using a toy operating system (read: unix bigot) like this you need to have tools that show you what the toy is doing to you. Kind of like stdout on a unix box. One of the greatest little utils I have found to open the win pandora's box is regmon and filemon. These help you find out what the system is choking on sometimes: www.sysinternals.com/ntw2k/utilities.shtml Hope it helps, it has for me at times. - CONTROL PANEL - ADMINISTRATIVE TOOLS. Hopefully it will tell you something. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @efairfield.com cc: Sent by: rootSubject: Service startup on Windows 2000 fails 02/19/2003 09:08 AM Please respond to ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Service startup on Windows 2000 fails
Good morning, too, I wonder if you can't start your listener service, as far as I know listener service is automaticaly run when Windows 2000 starts. I just can give you an advice to talk with your System Administrator and ask for him to check what is going on. HTH, Sony -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 9:09 PM To: Multiple recipients of list ORACLE-L Subject: Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: * Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. * All logons are part of the administrator and the ORA_DBA group. * I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. * Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).