Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Saudi Arabia
    Posts
    1

    Unanswered: starting Oracle service automatically

    Hi

    I am using Oracle8i Enterprise Edition Release 8.1.6.0.0. with windows2000 professional. The problem is that the database does not start automatically when I reboot the machine. The status in service panel is indicating "starting" instead of started.

    I delete the password file , and drop the OracleServiceMYDB service then reboot the machine and recreate the password file and OracleServiceMYDB.

    C:\>orapwd file=C:\Oracle\Ora81\DATABASE\pwdMYDB.ora password=mydb entries=5
    C:\>ORADIM -NEW -SID MYDB -INTPWD mydb -STARTMODE a -PFILE C:\Oracle\admin\MYDB\pfile\initMYDB.ora

    The instance is started and connected to mydb database. now I am able to connect and work with the database "The status in service panel is indicating started for OracleServiceMYDB service" now every thing is ok, but when I reboot the machine, I got OracleServiceMYDB starting but never started and got my old problem.


    The following parameter is introduced into my windows registry as I drop and recreate the service using ORADIM utility

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

    ORACLE_SID"="MYDB
    ORA_mydb_AUTOSTART= TRUE
    ORA_mydb_PFILE= C:\Oracle\admin\MYDB\pfile\initMYDB.ora
    ORA_mydb_SHUTDOWN= TRUE
    ORA_mydb_SHUTDOWNTYPE=i
    ORA_mydb_SHUTDOWN_TIMEOUT=30



    By default OracleServiceMYDB service use LOCALSYSTEM account to login as a service.
    When I change the service to login as administrator the service is started when I reboot the machine and the problem is solved. but not as localsystem account.
    For OracleOraHome81TNSListener and other services the localsystem is working very well.
    why this happened ?
    TIA

    Ahmad A Alghaden
    alghaden@alumni.fdu.edu
    KSA

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Talking

    Just creat a shortcut and drag it to the windows startup menu.

Posting Permissions

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