From: alghaden@alumni.fdu.edu (Ahmad) Newsgroups: comp.databases.oracle Subject: starting Oracle service automatically Date: 8 Aug 2003 07:49:14 -0700 Organization: http://groups.google.com/ Lines: 50 Message-ID: <4a75f4b7.0308080649.49105373@posting.google.com> NNTP-Posting-Host: 212.138.64.173 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1060354156 2907 127.0.0.1 (8 Aug 2003 14:49:16 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2003 14:49:16 GMT 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