ora-00604和ora-04031问题。
由于我在连接的时候出现上面两个错误,无法连接。
在修改:
SHARED_ POOL_SIZE和db_block_buffers
增大后,在关闭数据库时还是遇到如下错误,请问要如何处理:
[oracle@rh73 bin]$ svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SVRMGR> connect internal
Connected.
SVRMGR> shutdown immediate
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGE
R$","sga heap","state objects")
SVRMGR>
请问要如何处理?
谢谢!