auto start database...
I am facing a strange problem when i create the database MANUALLY. This problem is not appearing if i create the database using DBCA. The problem is ...
Database is not starting automatically
* The value in the windows registery ORA_SID_AUTOSTART is set to TRUE
* Windows service OracleServiceSID is set to Automatic start
* Startup / Shutdown options in 'Administration Assistent for Windows' is set to Automatic
* While using oradim i stated -STARTMODE auto
What else i have to look to make my database start automatically?
Can it be started manually to open state? Did you check the alert log?
It can be start to open stage manually. No errors were published in the alert log.
Did you also set up the listener and the listener service to start automatically? You will still be able to connect to the database without the listener but only directly from the server.
Infact, I am working on the same system in which DB server is running (my test system)
What error do you get when trying to connect to the db?
I am not getting any error. DB instance is not starting when i restart my system. I have to connect / as sysdba then issue the command startup. Then it is comming up.
anything in the windows event viewer?
No critical errors find in Windows event viewer (application log) but have some Information alerts. Any way I am clearing all the old messages and restarting my system now.
I will drop you another message once my system get restarted ...
Here is the information ...
When i restarted the system nothing was there in the windows event log related to my Oracle.
I connected the DB using sys/password as sysdba and it was connected to idle instance. At this time i find one information alert in my windows event viewer.
I issued the STARTUP command from SQL * PLUS to open the DB. Instance started / SGS allocated / DB mounted and opened.
The description for Event ID ( 34 ) in Source ( Oracle.mydb ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ACTION : 'CONNECT' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: ORCL\Administrator CLIENT TERMINAL: DBA STATUS: 0 .
At this point i find another 15 information alerts in windows event log. 3 of them are EventID: 34 (same as above message) and the others are EventID: 5 ...
-- one each for every background process.
The description for Event ID ( 5 ) in Source ( Oracle.mydb ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: SMON, mydb.
Thats all for now ....
Click Here to Expand Forum to Full Width