<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
系统环境:
客户端:WINXP+ORACLE9.2.0.1客户端
服务端:WIN2003+ORACLE9.2.0.5
错误描述:
非sys用户连接全部报错
c:/>sqlplusscott/tiger@pgjt
ERROR:
ORA-04045:在重新编译/重新验证SYS. DBMS_STANDARD 时出错
ORA-27102:内存用尽
Additional INFOrmation:24039532
Additional INFOrmation:171918168
访问程序包 DBMS_APPLICATION_ INFO 时出错
资料说明:tryrerun$ORACLE_HOME/r DBMS/admin/Catalog.sql,catproc.sqlassysdba
问题解决
SQL>connsys/sys@pgjtassysdba
SQL>@d:/oracle/ora92/r DBMS/admin/catalog.sql
居然还是假死状,执行下面操作,没问题了
SQL>shutdownabort;
ORACLEinstanceshutdown.
SQL>startup
ORACLEinstancestarted.
TotalSystemGlobalArea 542712360bytes
FixedSize 455208bytes
VariableSize 427819008bytes
DatabaseBuffers 109051904bytes
RedoBuffers 5386240bytes
Databasemounted.
Databaseopened.
SQL>connscott/tiger@pgjt
Connected.
SQL>
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
系统环境:
客户端:WINXP+ORACLE9.2.0.1客户端
服务端:WIN2003+ORACLE9.2.0.5
错误描述:
非sys用户连接全部报错
c:/>sqlplusscott/tiger@pgjt
ERROR:
ORA-04045:在重新编译/重新验证SYS. DBMS_STANDARD 时出错
ORA-27102:内存用尽
Additional INFOrmation:24039532
Additional INFOrmation:171918168
访问程序包 DBMS_APPLICATION_ INFO 时出错
资料说明:tryrerun$ORACLE_HOME/r DBMS/admin/Catalog.sql,catproc.sqlassysdba
问题解决
SQL>connsys/sys@pgjtassysdba
SQL>@d:/oracle/ora92/r DBMS/admin/catalog.sql
居然还是假死状,执行下面操作,没问题了
SQL>shutdownabort;
ORACLEinstanceshutdown.
SQL>startup
ORACLEinstancestarted.
TotalSystemGlobalArea 542712360bytes
FixedSize 455208bytes
VariableSize 427819008bytes
DatabaseBuffers 109051904bytes
RedoBuffers 5386240bytes
Databasemounted.
Databaseopened.
SQL>connscott/tiger@pgjt
Connected.
SQL>
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>