oracle升级后实例不能自动启动？
11.1.0.6 upto 11.1.0.7后数据库实例的服务设为自动的但是实例仍然必须手动STARTUP，请教高人如何让它自动开启。

------解决方案--------------------
I had the same problem of the database not mounting and opening after a reboot with Oracle 10g. I finally figured out the problem and solution. 

The startup of the database requires access to the pfile. I choose not to have the pfile in the default location under the Oracle Home. Therefore although the service OracleServiceSID started, it could not auto start the database. 

You can specify an alternate location for the pfile when creating the service. 

Oradim -new -sid SID -startmode auto -pfile C:\mypath\InitSID.ora 

To correct the problem I had to tell the service where my pfile is. That is done in the registry at LOCAL_MACHINE/Software/Oracle/KEY_OraDb10g_home1. I had to create a string registry value called ORA_SID_PFILE, where SID is my Oracle SID. The value of the registry setting is the full path of pfile. 

http://www.dbforums.com/oracle/773762-database-does-not-mount-automatically-startup.html

FYI

探讨

我用的是升级助手工具升级的，升级完就可以了，但是REBOOT以后就不行了。这是为什么？

------解决方案--------------------

探讨

I had the same problem of the database not mounting and opening after a reboot with Oracle 10g. I finally figured out the problem and solution.

The startup of the database requires access to the pfile. I choose not to have the pfile in the default location under the Oracle Home. Therefore although the service OracleServiceSID started, it could not auto start the database.

You can specify an alternate location for the pfile when creating the service.

Oradim -new -sid SID -startmode auto -pfile C:\mypath\InitSID.ora

To correct the problem I had to tell the service where my pfile is. That is done in the registry at LOCAL_MACHINE/Software/Oracle/KEY_OraDb10g_home1. I had to create a string registry value called ORA_SID_PFILE, where SID is my Oracle SID. The value of the registry setting is the full path of pfile.

http://www.dbforums.com/oracle/773762-database-does-not-mount-automatically-startup.html

FYI
引用:
我用的是升级助手工具升级的，升级完就可以了，但是REBOOT以后就不行了。这是为什么？

------解决方案--------------------
数据库升级后，数据库字典没有升级

需要运行Database Upgrade Assistant升级所有已安装的实例