- 浏览: 958763 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
升级刷新数据字典过程如下
期间出现如下问题,
alert日志显示:
经诊断,由Oracle 10.2.0.1 SGA自动分配内存bug所致,解决办法为设置sga_target=0,java_pool_size=300M。
引用
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
期间出现如下问题,
引用
SQL> alter session set current_schema="SYS";
Session altered.
SQL>
SQL> REM recompile invalid ORDSYS types
SQL> execute DBMS_SESSION.reset_package;
PL/SQL procedure successfully completed.
SQL> execute utl_recomp.recomp_serial('ORDSYS');
BEGIN utl_recomp.recomp_serial('ORDSYS'); END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL>
SQL> select o.name, o.status, o.type# from sys.obj$ o, sys.user$ u
2 WHERE o.status > 1
3 AND (u.name = 'ORDSYS'
4 OR u.name = 'ORDPLUGINS'
5 OR u.name = 'SI_INFORMTN_SCHEMA')
6 AND u.user# = o.owner#
7 AND rownum < 50;
ERROR:
ORA-03114: not connected to ORACLE
Session altered.
SQL>
SQL> REM recompile invalid ORDSYS types
SQL> execute DBMS_SESSION.reset_package;
PL/SQL procedure successfully completed.
SQL> execute utl_recomp.recomp_serial('ORDSYS');
BEGIN utl_recomp.recomp_serial('ORDSYS'); END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL>
SQL> select o.name, o.status, o.type# from sys.obj$ o, sys.user$ u
2 WHERE o.status > 1
3 AND (u.name = 'ORDSYS'
4 OR u.name = 'ORDPLUGINS'
5 OR u.name = 'SI_INFORMTN_SCHEMA')
6 AND u.user# = o.owner#
7 AND rownum < 50;
ERROR:
ORA-03114: not connected to ORACLE
alert日志显示:
引用
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/OracleStringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:06 2010
Trace dumping is performing id=[cdmp_20100314020906]
Sun Mar 14 02:09:13 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:14 2010
Trace dumping is performing id=[cdmp_20100314020914]
Sun Mar 14 02:09:27 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:29 2010
SERVER COMPONENT id=JAVAVM: status=LOADING, version=10.2.0.1.0, timestamp=2010-03-14 02:09:29
Sun Mar 14 02:09:29 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:29 2010
Trace dumping is performing id=[cdmp_20100314020929]
Sun Mar 14 02:09:30 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:32 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:33 2010
Trace dumping is performing id=[cdmp_20100314020933]
Sun Mar 14 02:09:33 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:35 2010
SERVER COMPONENT id=XML: status=VALID, version=10.2.0.4.0, timestamp=2010-03-14 02:09:35
SERVER COMPONENT id=CATJAVA: status=LOADING, version=10.2.0.1.0, timestamp=2010-03-14 02:09:35
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:15 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:17 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:20 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:22 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:24 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:27 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:29 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:32 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/OracleStringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:06 2010
Trace dumping is performing id=[cdmp_20100314020906]
Sun Mar 14 02:09:13 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:14 2010
Trace dumping is performing id=[cdmp_20100314020914]
Sun Mar 14 02:09:27 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:29 2010
SERVER COMPONENT id=JAVAVM: status=LOADING, version=10.2.0.1.0, timestamp=2010-03-14 02:09:29
Sun Mar 14 02:09:29 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:29 2010
Trace dumping is performing id=[cdmp_20100314020929]
Sun Mar 14 02:09:30 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:32 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:33 2010
Trace dumping is performing id=[cdmp_20100314020933]
Sun Mar 14 02:09:33 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/StringSYS","joxlod exec hp","SGAClass")
Sun Mar 14 02:09:35 2010
SERVER COMPONENT id=XML: status=VALID, version=10.2.0.4.0, timestamp=2010-03-14 02:09:35
SERVER COMPONENT id=CATJAVA: status=LOADING, version=10.2.0.1.0, timestamp=2010-03-14 02:09:35
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:15 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:17 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:20 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:22 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:24 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:27 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:29 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
Sun Mar 14 02:15:32 2010
Errors in file /oracle/admin/orcl/udump/orcl1_ora_790752.trc:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], []
经诊断,由Oracle 10.2.0.1 SGA自动分配内存bug所致,解决办法为设置sga_target=0,java_pool_size=300M。
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 511BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 434Oracle管理云服务(OMC)的大数据平台,自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 4132019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 781某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1342性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 463从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 1894数据库的启动是一个相当复杂的过程。比如,Oracle在启动之前 ... -
怎么样彻底删除数据库?
2018-09-18 11:10 544Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 799LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1189“一朝被蛇咬,十年怕井绳”。在没被“蛇”咬之前,很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1081在DTCC 2018发表《如何落地智能化运维》演讲,主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 525问题一:ping不通问题 在虚拟机上安装好linux系统后, ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 885即日起,不定期更新《OracleDBA实战攻略》一书电子版,请 ... -
Oracle 12c新特性
2018-05-11 10:33 847查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3919操作系统:RHEL6.5 数据库版本:11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 62811g rac安装在二节点跑脚本一般会报此错误: 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 749故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2463由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1675数据库中的log file sync等待事件指的是,当user ...
相关推荐
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
客户端进行连接的时候,系统不定期出现ora-12520,ora-12516的连接问题, 问题解决方案建议: 1、增加process和session的连接数。 2、检查连接的应用,是不是有没有释放的连接。 3、将修改参数local_listener中的vip为...
用oracle数据库新建连接时遇到ora-12505,此问题解决后又出现ora-12519错误,郁闷的半天,经过一番折腾问题解决,下面小编把我的两种解决方案分享给大家,仅供参考。 解决方案一: 今天工作时在新建连接的时候遇到...
前几天升级Oracle数据库,从11.2.0.1升级至11.2.0.4,安装完成后,打开PL/SQL,显示ORA-12514,如图: 问题阐述 ORA-12514:监听程序当前无法识别链接描述符中请求的服务,简单的来说就是Oracle数据库的监听器配置有...
Oracle RAC环境修改字符集遇到ORA-00205解决方法.rar
oracle故障处理ora-03113
ORA-00001: 违反唯一约束条件 (.) ORA-00017: 请求会话以设置跟踪事件 ORA-00018: 超出最大会话数 ORA-00019: 超出最大会话许可数 ORA-00020: 超出最大进程数 () ORA-00021: 会话附属于其它某些进程;无法转换会话 ...
问题处理过程
最近在工作中遇到了一个问题,错误是Oracle dbca时报错:ORA-12547: TNS:lost contact,通过查找相关的资料终于找到了解决的方法,下面分享给大家,话不多说了,来一起看看详细的介绍吧。 环境: OS:RHEL6.5 x86-...
ORA-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[] TueAug1209:20:17CST2014 Errorsinfile/u01/app/oracle/admin/orcl/udump/orcl_ora_29974.trc: ORA-00600:internalerrorcode,arguments...
今天有朋友问到如下一则案例,ORA-01114,ORA-27067以及OSD-04026错误同时出现: *** ACTION NAME:() 2009-04-01 09:31:00.762*** MODULE NAME:(JDBC Thin Client) 2009-04-01 09:31:00.762*** SERVICE NAME:(SYS$...
官网中关于ORA-12560的解释: ORA-12560: TNS:protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting ...
1、首先排查oci.dll不一致(navicat for oracle与oracle版本不一致)问题,这个操作必须进行。 将OCI library(oci.dll)目录填写成已安装的oracle目录下的地址(例如我的:C:\app\luohaiyuan\product\11.2.0\dbhome_1...
错误写法: create user zhaojiedi identified by oracle; 正确写法: create user c##zhaojiedi identified by oracle; 注: 如果你不纠结为啥的,上面的解决方案就可以满足你的要求了,下面的内容可以不用看了。 ...
相信使用过Oracle数据库的人一定碰到过“ORA-12154: TNS: 无法解析指定的连接标识符”错误,我在此做一个小小的总结。 在程序中连接Oracle数据库的方式与其他常用数据库,如:MySql,Sql Server不同,这些数据库可以...
Oracle中的【ORA-01536表空间限额不够】的解决方法 错误场景: 今天在SMS短信数据库一个功能运行时候遇到了ORA-01536错误,具体如下: --执行一条插入语句 INSERT INTO SMS_MASTER (CREATE_DATE, TYPE_NAME, SMS_...
oracleRAC监听文件详解
在使用ORACLE的过程中,会出现各种各样的问题,各种各样的错误,其中ORA-12899就是前段时间我在将数据导入到我本地机器上的时候一直出现的问题.不过还好已经解决了这个问题,现在分享一下,解决方案; 出现ORA-12899,是...
在用PL/SQL Developer等客户端工具连接oracle服务器时出现ORA-12541:TNS:无监听程序的错误,如下图: 发现原来是oracle的监听没有启动,重启监听后就连接成功了,下面跟大家分享一下如何启动oracle的监听。 1.在安装...