smallwei
2:47 pm on October 16, 2009 |
Answers: 1
Tags: database (51), microsoft (50), microsoft windows (52), oracle (136), oracle database (11), service (7), troubleshoot (4), windows (150) 
(1 votes)
Loading ...Troubleshoot Oracle “DB service running, but database is actually idle issue.
In Microsoft Windows, Oracle database “DB service” seems to be running, but database is actually idle. Also restarting Windows does not start up database completely. What could be the reason?
Performance Issue with Oracle Database in Windows Server when Running SQL QueryOracle OEM Issue on Windows Server 2003 After Windows .NET Security PatchTroubleshoot ORA-01722: Invalid Number Error in Oracle Database
Resolving Oracle Database ORA-12638 Error in WindowsHow to Enable/start Log Trace/tracing in Oracle Database
smallwei 2:51 pm on October 16, 2009
It is possible the auto restart registry key is set to FALSE.
Check the following registry key: (Go to Start -> Run and run “regedit”)
HKEY_LOCAL_MACHINE/software/oracle/ora_[SID]_autostart- Make sure this key is set to TRUE.