Re: Windows 2003: 10g doesn't start automatically after reboot

Wolfram Roesler wrote:
Hello,

I'm using 10gR2 on Windows 2003 Server, and my problem is that
the database doesn't start automatically after a system reboot.
I get ORA-01034 and ORA-27101 even half an hour after starting
up the machine. I can start the DB manually with no problem.

The OracleServiceORCL service is set to "automatic" and to
log in as LocalSystem. services.msc even reports it as
"started"!

Administrator is a member of the ora_dba group, and is the only
user on the machine.

ORA_ORCL_AUTOSTART is TRUE in HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1.

sqlnet.ora has these:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

There's nothing in the alert log: its last entry is "Completed:
ALTER DATABASE OPEN" but the date is way before the last reboot.
Nothing was written to the alert log, or any file in the bdump
or udump directories, since the last reboot.

There's nothing Oracle-specific in the event log.

Does anybody have an idea where else to look?

Thanks for your help
W. Rösler

Check the oradim.log. You can recreate the services, using oradim.
Make sure you are logged on as local administrator, else you rely
on networked authentication.
Oradim.log should be in %ORACLE_HOME%/dbs (or database).

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
.

Relevant Pages

  • Re: Windows 2003: 10g doesnt start automatically after reboot
    ... The OracleServiceORCL service is set to "automatic" and to ... There's nothing in the alert log: its last entry is "Completed: ... ALTER DATABASE OPEN" but the date is way before the last reboot. ...
    (comp.databases.oracle.server)
  • Windows 2003: 10g doesnt start automatically after reboot
    ... The OracleServiceORCL service is set to "automatic" and to ... There's nothing in the alert log: its last entry is "Completed: ... ALTER DATABASE OPEN" but the date is way before the last reboot. ...
    (comp.databases.oracle.server)
  • vfs_mountroot panic on tru64 v5.1A
    ... When I tried to reboot, bcheckrc hung, stating that there was a ... On contacting Compaq, they decided that the hardware database was the ... This is when the major problem kicked in - the machine hung, ...
    (comp.unix.tru64)
  • Reboot instead of debugger/dump from X11? (Re: an accidental way to pull the plug)
    ... when it took place with X11 ... running, I got an "instant reboot" -- no dump, etc. So something odd is ... I have been using FreeBSD as a fine platform for a Free database I ... using xv to grab the windows. ...
    (freebsd-current)
  • Problem after 49.71 Days
    ... We have a SQL Server 7 machine running under Windows 2000 on a HP Compaq ... couple of seconds) and continue until we reboot the database machine. ... we **MUST** reboot the actual SQL Server machine. ... steps to ensure that connections are not held open this long. ...
    (microsoft.public.sqlserver.server)