Look for Errors like: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool, ","PROCEDURE$","KQLS heap","KQLS MEM BLOCK") Create or Replace: * ORA-06553: PLS-213: package STANDARD not accessible grant execute on STANDARD to public ORA-04042: procedure, function, package, or package body does not exist In this case, you would need to increase the "SHARED_POOL_SIZE" in the "init<sid>.ora". Then re-execute CATALOG and CATPROC. Increasing "SHARED_POOL_SIZE" will allocate more resources and allow the scripts to run successfully.
编译standard.sql的时候出现“standard包找不到”的错误!
好着急呀!!help!!
然后,SQLPLUS下
SQL>@C:\ORACLE\RDBMS\ADMIN\standard.sql 需要输入全路径。
create or replace
*
ERROR 位于第 1 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-06553: PLS-213: STANDARD 包不可访问
编译了吗?
感觉standard包本身就是自我调用的,要不怎么会出现“ORA-00604: 递归 SQL 层 1 出现错误
”?
ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool, ","PROCEDURE$","KQLS heap","KQLS MEM BLOCK") Create or Replace:
*
ORA-06553: PLS-213: package STANDARD not accessible
grant execute on STANDARD to public ORA-04042: procedure, function, package, or package body does not exist In this case, you would need to increase the "SHARED_POOL_SIZE" in the
"init<sid>.ora". Then re-execute CATALOG and CATPROC. Increasing "SHARED_POOL_SIZE" will allocate more resources and
allow the scripts to run successfully.
我用的oracle 9i. 好像并没有报“ORA-04031”的错误,应该跟SHARED_POOL_SIZE无关。
我重新编译catalog.sql也会出现“standard包不可访问”的问题。
现在的心情就一个字: 急!!!!
alter package sys.standard compile
如果提示别的包无效,先编译别的失效的包再编译这个
问题已经解决!