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.htmlFYI
试一下这个方法,如果你的可以手工open的话,如果手工也不能open的话,可能是数据库有问题了。那就先解决问题。
我就是用Database Upgrade Assistant升级的,升级完成后就好了;但是重启系统后实例就挂了,只能手动用 startup 启动。
而且每次从新启动系统都得手动启动实例,但是这样不合适,所以想让它自动启动。