Oracle-L: RE: Service startup on Windows 2000 fails

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Wed, 19 Feb 2003 08:09:15 -0800
Message-ID: <F001.0055164E.20030219080915@fatcity.com>

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?

CMD
set 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: Lisa.Koivu_at_efairfield.com 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: ListGuru_at_fatcity.com (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: Bob Metelsky
  INET: bmetelsky_at_cps92.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Feb 19 2003 - 10:09:15 CST