Re: starting Oracle service automatically

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • s.kapitza

    Re: starting Oracle service automatically

    Hi,

    try M$S servicebug 3

    regards

    s.kapitza

    alghaden@alumni .fdu.edu (Ahmad) wrote in message news:<4a75f4b7. 0308080649.4910 5373@posting.go ogle.com>...
    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 OracleServiceMY DB service
    then reboot the machine and recreate the password file and
    OracleServiceMY DB.
    >
    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\ini tMYDB.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 OracleServiceMY DB service” now
    every thing is ok, but when I reboot the machine, I got
    OracleServiceMY DB 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_MACH INE\SOFTWARE\OR ACLE\HOME0
    >
    ORACLE_SID"="MY DB
    ORA_mydb_AUTOST ART= TRUE
    ORA_mydb_PFILE= C:\Oracle\admin \MYDB\pfile\ini tMYDB.ora
    ORA_mydb_SHUTDO WN= TRUE
    ORA_mydb_SHUTDO WNTYPE=i
    ORA_mydb_SHUTDO WN_TIMEOUT=30
    >
    >
    >
    By default OracleServiceMY DB 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 OracleOraHome81 TNSListener and other services the localsystem is
    working very well.
    why this happened ?
    TIA
    >
    Ahmad A Alghaden
    alghaden@alumni .fdu.edu
    KSA
Working...