Re: starting Oracle service automatically

Hi,

try M$S servicebug 3

regards

s.kapitza

alghaden_at_alumni.fdu.edu (Ahmad) wrote in message news:<4a75f4b7.0308080649.49105373_at_posting.google.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 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 &#8220;The status in service
> panel is indicating started for OracleServiceMYDB service&#8221; 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_at_alumni.fdu.edu
> KSA
Received on Fri Aug 08 2003 - 20:52:01 CEST