1.ORA-01034: ORACLE not available
以前在真实机上安装也没发现这个错误，google查了一些发现在win上出现居多，我就奇怪
在solaris上怎么会出现这样的错误；没办法死马当活马医（毕竟也在x86平台上）；sync;sync;sync;
init 6
起后发现还真行。真正项目上还是不要这样做呵呵，偷懒而已。
在官网上查到以下信息：
| ORA-01034: ORACLE not available Cause: Oracle was not started up. Possible causes include the following: - The SGA requires more space than was allocated for it. - The operating-system variable pointing to the instance is improperly defined. Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation. |
|
2. ORA-01078: failure in processing system parameters
应该是pfile设置出问题了，我的初始库定义的是orcl，但这里提示是orac10g
我利用我以前启动成功的spfile重新创建pfile
3. ORA-00371 not enough shared pool memory
如果进行
alter system set processes=2000 scope=spfile;
shutdown immediate
startup
或在
pfile里面修改了processes 等控制数据库线程的参数有可能导致该错误的出现。
因为share_pool的需要的大小是跟进程数有关系；oracle会根据processes参数的值在共享池中分配一定数量的内存，参数值越大，分配的内存也越多。在处理过程中不能startup nomount，只能利用比较旧的pfile进行启动。