Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i and Windows 2000 Server
Shum,
There is a registry entry in HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME<#> , named ORA_SID_AUTOSTART. When set to TRUE, each time the service is started, the database will be started. Then if your service OracleServiceSID is setup to start automatically upon server reboot then the instance will start as well. If this is set to FALSE or not set the database will not start with the service/instance.
After setup of ORA_<SID>_AUTOSTART=TRUE, then the primary thread spawns ORADIM which starts the database based on the pfile location used upon creation of the OracleServiceSID.
Check the latest Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
Hope that helps,
Trifon Anguelov
Senior Oracle DBA
Gina
Oracle Support Services
From: Mohammed Shahid 28-Sep-01 20:16
Subject: Re : Oracle start service
Ok fine, but where is the script that this registery entry called
like startup pfile=.....
I can disable it but would like to know the scripts.
Regrds
From: Oracle, Gina Thunder 02-Oct-01 20:37 Subject: Re : Oracle start service
From what I understand during startup of Oracle, if the ORA_<SID>_AUTOSTART=true then the primary thread spawns ORADIM which starts the database based on the pfile location used upon creation of the OracleServiceSID. If you are looking for more information you will want to file an iTAR as this would be a question for Oracle development.
Gina
Oracle Support Services
From: Firas Al Tamimi 09-Oct-01 15:01
Subject: Re : Oracle start service
At the same place where the Autostart registry key exists you will find another key (ORA_<sid>_PFILE) this key value points to the pfile you are looking for.
Regards,
Firas Al Tamimi
ADWEA
Firas Al Tamimi
Applications Team Leader - ADWEA
Abu Dhabi - UAE
From: Oracle, Gina Thunder 09-Oct-01 22:46 Subject: Re : Oracle start service
This is true, the ORA_SID_PFILE parameter is set based on the value of the path entered when creating the instance via ORADIM. Thank you for this contribution.
Gina
Oracle Support Services
"Shum" <shumnahal_at_telus.net> wrote in message
news:IhMw8.2202$sO1.340531_at_news1.telusplanet.net...
> I installed Oracle 8i on Windows 2000 server and everything was working
> fine. I later made the windows 2000 a domain controller and now Oracle 8i
> does not start automatically. I can manually start it, but would like it
> start automatically. How do I solve this problem.
>
> Thank you in advance.
>
>
Received on Mon Apr 22 2002 - 20:51:27 CDT