Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Location
    Guwahati, India
    Posts
    33

    Arrow Unanswered: Oracle 8i does not start automatically in Windows Server 2003

    Dear Friends,

    Machine Type: Intel P4 with 845g Motherboard
    OS Type: Windows Server 2003.
    Database: Oracle 8i for Windows NT and 2000 .

    I am trying to start the Oracle 8i server automatically with the machine boot up. As machines will be handled by users only in remote locations , Its important to start the database automatically . But not happening.

    TNS Listners start automatically , <Database SID > status showed in the Services Applet as starting .

    If we start database by going to svrmgrl , connect internal , then startup , it works fine .

    How to start database automatically . Please help .
    G J Shankar Nath
    IT Consultant, Vedswasti Services Pvt. Ltd
    Guwahati-781007
    India

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    did you build a service with oradim utility??

    call oradim from the cmd shell for options and parameters

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >If we start database by going to svrmgrl , connect internal , then startup , it works fine .
    Create a small *bat file with the commands above & place it in the STARTUP folder
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    if you have this line in the sqlnet.ora file,comment it out:

    SQLNET.AUTHENTICATION_SERVICES = (NTS)


    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    For what it's worth ... Here's a Post that we had earlier...
    http://www.dbforums.com/t1001145.html

    For the heck of it ... I've have a couple of clients that I found lately with problems with their service not starting ... I tracked it down to AUTO updates of Windows ... Patch 835732 was the culpret. Once they removed that patch, everything was ok... Check to see if you have this Microsoft patch loaded...

    HTH
    Gregg

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you do have the patch and it is causing the problem, see the following work around

    http://support.microsoft.com/default.aspx?kbid=841180
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •