我在SYSTEM方案的基础上新建一个表,会出现以下的错误提示:
ORA-06553:PLS-213:STANDARD包不可访问
递归SQL层1出现错误;我在连接数据库时,总会出现"访问程序包DBMS_APPLICATION_INFO时出错?
请问这该怎么解决呀?
ORA-06553:PLS-213:STANDARD包不可访问
递归SQL层1出现错误;我在连接数据库时,总会出现"访问程序包DBMS_APPLICATION_INFO时出错?
请问这该怎么解决呀?
客户端:WINXP+ORACLE9.2.0.1客户端
服务端:WIN2003+ORACLE9.2.0.5错误描述:
非sys用户连接全部报错
c:/>sqlplus scott/tiger@pgjtERROR:
ORA-04045: 在重新编译/重新验证 SYS.DBMS_STANDARD 时出错
ORA-27102: 内存用尽
Additional information: 24039532
Additional information: 171918168
访问程序包 DBMS_APPLICATION_INFO 时出错资料说明:try rerun $ORACLE_HOME/rdbms/admin/Catalog.sql , catproc.sql as sysdba问题解决
SQL> conn sys/sys@pgjt as sysdba
SQL> @d:\oracle\ora92\rdbms\admin\catalog.sql
居然还是假死状,执行下面操作,没问题了
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 542712360 bytes
Fixed Size 455208 bytes
Variable Size 427819008 bytes
Database Buffers 109051904 bytes
Redo Buffers 5386240 bytes
Database mounted.
Database opened.
SQL> conn scott/tiger@pgjt
Connected.
SQL>