系統環境:
客戶端:WINXP+ORACLE9.2.0.1客戶端
服務端:WIN2003+ORACLE9.2.0.5
錯誤描述:
非sys用戶連接全部報錯
c:/>sqlplus scott/tiger@pgjt
ERROR:
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>