Instance is not start when login to Window [message #60678] |
Wed, 25 February 2004 01:17 |
Ba-Ajaja
Messages: 4 Registered: January 2004
|
Junior Member |
|
|
I installed Oracle8i Personal Edition on Windows XP, and created the Database .. It is OK.
When I login to Windows the Oracle Instance is not available. I should start it manually.
|
|
|
Re: Instance is not start when login to Window [message #60679 is a reply to message #60678] |
Wed, 25 February 2004 02:47 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
The DB should start when the server starts, not when the first user login. Check the following:
From services, right click on the DB service (OracleServiceORCL), click on properties and set the startup type to "Automatic".
If the above doesn't help, try to re-create the service with oradim. Example:
oradim oradim -new -sid ORCL -intpwd oracle -maxusers 20 -startmode auto
Also, ensure the following properties are set in the registry:
Key: HKEY_LOCAL_MACHINESOFTWAREORACLEHOME<n>:
ORA_<SID>_AUTOSTART = TRUE
ORA_<SID>_PFILE = [your INIT.ORA file location]
ORACLE_HOME= [...]
ORACLE_SID = [...]
Also, check the %ORACLE_HOME%DatabaseOraDim.log file for possible startup errors.
Best regards.
Frank
|
|
|