Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: oracle 8.1.7 and w2k server

    We've got a server running w2k server. It is also a domain controller. The Oracle 8.1.7 database server is also running on this machine. After the machine is restarted, the db server doesn't start when the OS is loaded. The db server needs to be started manually through command line.
    Can anyone help me How and What to configure to start it automatically after restart?
    Thank You very much.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    under SERVICES there should be a service for the ORACLE_SID.
    Check and see if that is set to auto-start/automatic
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Also in addition to THE_DUCK's reply, check your registry entry ...

    HKEY_LOCAL_MACHINE
    SOFTWARE
    ORACLE
    HOME0

    for the entry ORA_XXX_AUTOSTART ... set it to TRUE

    xxx - is the instance name ...

    HTH
    Gregg

  4. #4
    Join Date
    Nov 2003
    Posts
    4

    it's set but the server's still not started

    the things are/was set as you told. If I look at the services list, the service's status is started.
    But I still need to do the following procedure:
    start the command prompt,
    cd\,
    svrmgrl,
    connect internal
    startup

  5. #5
    Join Date
    Nov 2003
    Posts
    4

    it's set but the server's still not started

    I still need to do the following procedure:
    start the command prompt,
    cd\,
    svrmgrl,
    connect internal
    startup

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296

    Re: it's set but the server's still not started

    Originally posted by zsolt
    the things are/was set as you told. If I look at the services list, the service's status is started.
    But I still need to do the following procedure:
    start the command prompt,
    cd\,
    svrmgrl,
    connect internal
    startup
    strange.
    my experience installing 817 on Win2k has been everything is preconfigured to restart automatically.

    Have you downloaded the install-guide and looked up settings on dbstart and dbstop for win2k?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Nov 2003
    Posts
    48

    Re: it's set but the server's still not started

    Originally posted by zsolt
    the things are/was set as you told. If I look at the services list, the service's status is started.
    But I still need to do the following procedure:
    start the command prompt,
    cd\,
    svrmgrl,
    connect internal
    startup
    I'm not sure you got the point.
    There are two columns in Services control panel, which are "Status" and "StartupType"

    The "Status" column shows current status of the service, while "Startup Type" is used to tell Windows if the service needs to start automatically when Windows start up.

    You didn't mention the "Startup Type" in your response.
    Shianmiin

  8. #8
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    In the registry, ensure the AUTOSTART is set as well as the location of the INITxxx.ORA file entry in the registry ...

    If these are set AND correct ... check your alter log to see if the database tries to start upon reboot ...

    Also look in the event viewer to see what it tells you ...

    Have you changed the INTERNAL password and did not change it for
    the INSTANCE startup ???

    Gregg

  9. #9
    Join Date
    Nov 2003
    Posts
    4

    Re: it's set but the server's still not started

    Originally posted by shianmiin
    I'm not sure you got the point.
    There are two columns in Services control panel, which are "Status" and "StartupType"

    The "Status" column shows current status of the service, while "Startup Type" is used to tell Windows if the service needs to start automatically when Windows start up.

    You didn't mention the "Startup Type" in your response.
    of course the startup type is set "Automatic".

  10. #10
    Join Date
    Nov 2003
    Posts
    3
    Just in case the service tried to start but couldn't due to some error, you can take a look at the Event Viewer . The Event Viewer may have some entry telling why the service failed to start ...

    Cheers,
    Parashar

Posting Permissions

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