From: skapitza@volcanomail.com (s.kapitza)
Newsgroups: comp.databases.oracle
Subject: Re: starting Oracle service automatically
Date: 8 Aug 2003 11:52:01 -0700
Organization: http://groups.google.com/
Lines: 59
Message-ID: <26703915.0308081052.4e34292@posting.google.com>
References: <4a75f4b7.0308080649.49105373@posting.google.com>
NNTP-Posting-Host: 212.255.48.83
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060368722 14164 127.0.0.1 (8 Aug 2003 18:52:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2003 18:52:02 GMT


Hi,

try M$S servicebug 3

regards

s.kapitza

alghaden@alumni.fdu.edu (Ahmad) wrote in message news:<4a75f4b7.0308080649.49105373@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@alumni.fdu.edu
> KSA