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

Wolfram Roesler schrieb:
> 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

My experiences with W2k3 (german), 10g SEO 10.2.0.2, all Patches:

sqlnet.ora:

• with SQLNET.AUTHENTICATION_SERVICES=(NTS) :
  • at the commandline-interface:

  set ORACLE_SID=your_oracle_sid

  sqlplus / as sysdba

  works fine

• after reboot of the machine, the oracle-instance doesn't start, you must use:
• at the commandline-interface:

         set ORACLE_SID=your_oracle_sid

         sqlplus / as sysdba
         startup

• with SQLNET.AUTHENTICATION_SERVICES=(NONE) :
  • at the commandline-interface:

  set ORACLE_SID=your_oracle_sid

  sqlplus / as sysdba

  doesn't work

  you must use:

  sqlplus <username>/<password> as sysdba

• after restart of the machine, the oracle-instance starts correctly

But may be, dbconsole (OEM) doesn't work:

• at the commandline-interface:

  set ORACLE_SID=your_oracle_sid

  (emctl status|start|stop dbconsole)

  emctl status dbconsole
  emctl start dbconsole

In my mind, it's an oracle-bug.

HTH CW Received on Fri Jan 18 2008 - 05:59:28 CST