访问程序包DBMS_APPLICATION_INFO时出错

来源:互联网 发布:350模板和淘宝什么区别 编辑:程序博客网 时间:2024/04/30 14:44
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></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:内存用尽
AdditionalINFOrmation:24039532
AdditionalINFOrmation:171918168
访问程序包DBMS_APPLICATION_INFO时出错

资料说明:tryrerun$ORACLE_HOME/rDBMS/admin/Catalog.sql,catproc.sqlassysdba

问题解决
SQL>connsys/sys@pgjtassysdba
SQL>@d:/oracle/ora92/rDBMS/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"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
原创粉丝点击