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

Charles Hooper <hooperc2000_at_yahoo.com> wrote in news:66c9e70d-d895-437d- aa54-c92d5616d3f9_at_e23g2000prf.googlegroups.com:

> What is the specific command that you are using to manually start the
> database? Does it include the location of the pfile (init.ora)? The
> spfile or init.ora used by Oracle by default may include a depreciated
> setting, such as LOG_ARCHIVE_START.

I'm just using this, which works fine:

        echo startup | sqlplus "sys/secret as sysdba"

This is a freshly installed 10g database so I don't think there are any deprecated settings anywhere.

> Does it make a difference if you change the line in the SQLNET.ORA
> file to read:
> NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
Sorry, this didn't help.

> Have you verified that PATH environment variable contains Oracle's bin
> folder?

Yes, it does.

Thanks for your help
W. Rösler Received on Fri Jan 18 2008 - 06:27:14 CST