启动Oracle时提示“ORA-00600: internal error code, argume

2019独角兽企业重金招聘Python工程师标准>>>

启动Oracle时提示“ORA-00600: internal error code, arguments”错误？

SQL> startup

ORA-00600: internal error code, arguments: [ksunfy : too few sessions], [9504], [75040], [], [], [], [], [], [], [], [], []”

解决办法：这里的错误说明Oracle的processes和sessions的值调的太大了。

（1）修改processes和sessions的值

*.processes=10000

*.sessions=10000

保存

（2）SQL> create spfile from pfile='/home/oracle/pfile20151225.ora';   

File created.

SQL> startup

ORACLE instance started.

Total System Global Area 8.5516E+10 bytes

Fixed Size                  2237776 bytes

Variable Size            8858372784 bytes

Database Buffers         7.6504E+10 bytes

Redo Buffers              151142400 bytes

Database mounted.

Database opened.

问题解决

转载于:https://my.oschina.net/lionel45/blog/551233