RE: Kind of urgent database not autostarting after upgrade

Download the kill utility from www.sysinternals.com - that'll let you kill almost anything. I agree with previous posts in that you should try to kill off the services/shutdown the db, and remove them using ORADIM. If this doesn't remove the services then remove them using INSTSRV -REMOVE [1] from the resource kit (that will get rid of them), then recreate using ORADIM.

Make sure you use the correct ORADIM binaries (right version) for the removal and recreation of the services.

[1] Be aware though that once the services are gone, if you can't recreate them then you could be facing a more serious error than you currently have.  

Lewis Bishop

---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : lewis.bishop_at_woolwich.co.uk
"Enabling Competitive Advantage for Barclays in IT and Business Processing"
 

-----Original Message-----
Sent: 16 October 2002 16:40
To: Multiple recipients of list ORACLE-L


 


> I'm not sure about the upgrade from WinNT to Win2K, but the 

> easiest remedy for the DB not auto-starting is to delete and 

> re-create the service.

> 

> You can use ORADIM, and then while re-creating the service, 

> you can use option of autostart.

> 

> Regards

> Naveen

> 


Hi 

Yes, that's part of the problem/original bug where oradim could not
recreate the service after deleting it. You need to reboot. Here is the
bug 1266248

"
Problem is with the call that is made to ORADIM.EXE by the service when
the  registry entry ora_sid_autostart=true.  Oradim hangs, the service
is shown to  be in status 'starting' and the service oracleservicesid
cannot be stopped.

ORACLE.EXE must be killed from Task Manager, and ORADIM.EXE cannot be
killed.    Setting reg entry ora_sid_autostart=false, and rebooting,
resolves the issue,  leaving us, of course, without an aotostart option.


 It is worth noting that dispite the status of the service, the database
can be  started and stopped manually from Server Manager.  The error is
only on the  service attempting to autostart the database. We removed
and rebuilt oracleservicesid using Oradim, and this fixed the  problem
temporarily. 

We were able to use the service to start/stop, until a  reboot, after
which the same problem occurs. 
"

I was just off the phone with Oracle, and was advised to start another
tar...

Thanks
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bishop Lewis
  INET: Lewis.Bishop_at_woolwich.co.uk

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