- 博客(66)
- 资源 (5)
- 问答 (1)
- 收藏
- 关注
原创 现象:物化视图对update不更新
现象:物化视图对update不更新现象TESTCASE:SQL> create table b (id number,name char(20)); insert into b values(1,'A'); insert into b values(2,'B'); Table created.SQL> 1 row created.SQL> 1 row
2013-12-30 22:16:34 2607
原创 Ora-00600[KGHLKREM1]
Ora-00600[KGHLKREM1]现象:alert日志报错:Sat May 18 07:59:47 2013Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690630.trc:ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C
2013-12-30 21:40:51 1232
原创 参数use_stored_outlines
参数use_stored_outlinesSQL> alter system set use_stored_outlines=aaa;System altered.可以设置成功但是不能通过show parameter查看。SQL> show parameter create_stored_outlinesNAME TYPE VALUE------------------
2013-12-30 21:20:01 985
原创 SQLT安装及使用
note:215187.11). Install SQLT$ unzip sqlt.zip$ cd sqlt/install$ sqlplus / as sysdbaSQL> START sqcreate.sqlPassword for user SQLTXPLAIN: Default tablespace [UNKNOWN]:USERSTemporary ta
2013-12-30 21:04:26 1786
原创 KEEP CACHE和并行查询简单使用
KEEP CACHE和并行查询简单使用a)1.Check db keep cache size:show parameter db_keep_cache_sizeif it is 0,please set it:alter system set db_keep_cache_size=;2.keep table:alter table cache;b) 并行
2013-12-30 20:58:54 619
原创 Which one is the last archivelog we need for recover?
对事务量大的DB执行恢复时,recover一直要求next archivelog:recover database using backup controlfile until cancel;but it always ask us to apply the next archivelog.Specify log: {=suggested | filename | AUTO | C
2013-12-30 20:48:19 868
原创 ons无法启动,或者启动后异常
ons无法启动,或者启动后异常诊断思路:1.开启资源的trace:需设置好环境变量,以root执行crsctl debug log res ora..ons:5crsctl debug log res ora..ons:5 onsctl debug2.查看opmn/logs
2013-12-26 22:33:41 1434
原创 Oracle系统SQL消耗大量资源(bsa0wjtftg3uw)
Oracle系统SQL消耗大量资源(bsa0wjtftg3uw)top sql第一条是select file# from file$ where ts#=:1现象:客户反馈AWR中TOPSQL第一条为系统SQL:select file# from file$ where ts#=:1。客户的系统是比较繁忙的系统,AWR也是在高峰期做的。WORKLOAD REPOSITORY r
2013-12-26 22:15:05 1322
原创 监听重启之后的短时间会报错ORA-12516
监听刚刚重启之后的一段时间会报错:SQL> conn system/www@testracERROR:ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程序此时查看监听状态:[oracle@ractest4 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.1.0.6.0 - Production on
2013-12-26 19:37:41 675
原创 错误的TAF配置导致应用不能重连DB
错误的TAF配置导致应用不能重连DB:应用反馈DB连接断开之后,无法自动重连,应用报错:WARN JDBCExceptionReporter:77 - SQL Error: 17008, SQLState: nullERROR JDBCExceptionReporter:78 - 关闭的连接INFO DefaultLoadEventListener:111 - Error perf
2013-12-26 19:30:45 924
原创 Listener.log增长过快的处理
Listener.log增长过快的处理QUESTION:有个C/S模式的程序,会对DB频繁的连接(ODBC连接),造成每天listener.log生成量达到1G+。ANSWER:1)如果是24*7的环境,LSNRCTL>LSNRCTL>>LSNRCTL> set log_status on 2)取消生成监听日志:在listener.o
2013-12-25 23:50:39 1321
原创 关于TNSNAMES.ORA中SERVICE_NAME,SID的一点理解
关于TNSNAMES.ORA中SERVICE_NAME,SID的一点理解SID只指定一个实例,而SERVICE_NAME在RAC环境中指定多个实例。如下,该配置指定了一个节点的HOST:RAC1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.12.16)(PORT = 1
2013-12-25 23:31:45 3261 1
原创 内存参数设置不合理导致数据库HANG
内存参数设置不合理导致数据库HANG现象:2节点RAC,数据库忽然HANG住,重启一个实例后恢复正常。分析:故障时间段约为8:30-10:00,以下为alert报错:alert_crm2.log:Mon May 27 06:54:26 2013SUCCESS:>Mon May 27 07:32:24 2013Thread 2>ORA-07445: 出
2013-12-25 23:12:10 2037
原创 Unknown table engine 'InnoDB'
Unknown>#innodb_data_file_path = ibdata1:10M:autoextend#innodb_log_group_home_dir = /usr/local/mysql/data/# You>#innodb_additional_mem_pool_size = 2M# Set .._log_file_size>#innodb_log_buff
2013-12-25 19:42:04 757 1
原创 innodb tables doesn't exist?
innodb tables doesn't exist?现象:查询数据库中所有的innodb中的表都报错ERROR 1146 (42S02): Table 'x.xxx'>innodb_log_group_home_dir = /usr/local/mysql/data/导致innodb的表找不到ibdata*文件导致解决方法:设置innodb_data_home_di
2013-12-25 19:39:40 2124
原创 查询innodb表时报错:ERROR 1286 (42000): Unknown table engine 'InnoDB'
查询innodb表时报错:ERROR 1286 (42000): Unknown table engine 'InnoDB'mysql> select * from po_t limit 1;ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection
2013-12-25 19:37:53 5344
原创 mysql开启创建函数的功能
mysql开启创建函数的功能:mysql> >Query OK, 0 rows affected (0.00 sec)mysql>>lower_case_table_names=1
2013-12-25 19:27:44 922 1
转载 HugePages on Linux: What It Is... and What It Is Not...
Applies to: Linux OS - Version Enterprise Linux 3.0 to Oracle Linux 6.0 with Unbreakable Enterprise Kernel [2.6.32] [Release RHEL3 to OL6]Oracle Database - Enterprise Edition - Version 9.2.0.1 and
2013-12-25 00:14:17 1158
转载 HugePages on Oracle Linux 64-bit
IntroductionHugePages is a feature of the Linux kernel which allows larger pages to manage memory as the alternative to the small 4KB pagesize. For a detailed introduction, seeDocument 361323.1
2013-12-24 23:53:46 989
转载 How DRM works in RAC cluster
10g Real Application Clusters introduced a concept of resource remastering via Dynamic Resource Mastering (DRM). With DRM a resource can be re-mastered on another node in the cluster if it is found th
2013-12-24 23:00:13 1024 1
转载 How to generate Oracle Net tracing for a DBMS_JOB using a database link
Problem Description-------------------A job that is scheduled via the DBMS_JOB system fails with a general errorreturned from the network layer. The job makes use of distributed transactions(i
2013-12-24 19:15:24 641
原创 关于REMOTE_LISTENER
问题:remote_listener设置为LISTENERS_MDM,但是未在listener.ora中叨叨LISTENERS_MDM的配置。SQL> show parameter listNAME TYPE VALUE------------------------------------ ----------- ------------------------------
2013-12-23 23:49:44 2264
原创 查询dba_jobs视图hang住,等待事件enq: TX contention
现象:客户反馈执行select job,what from dba_jobs时session Hang住,等待事件为enq: TX contention。现象:因为没在现场,所以我要求客户执行如下SQL:a).生成10046trace:SQL> connect username/passwordSQL> alter session set tracefile_identif
2013-12-23 23:20:29 1507
原创 rebuild table online
The main steps of table redefinition are:1, Verify the source table is able to be online redefine:BEGIN Dbms_Redefinition.Can_Redef_Table('USER','SOURCE TABLE NAME'); END;2, Create your empty in
2013-12-23 22:46:10 1119
原创 Oracle BUG导致实例宕机:ORA-07445
现象:客户的数据库(RAC环境:11.1.0.6)发生了实例异常宕机现象,伴随有ORA-07445错误:Sun Jun 23 01:00:06 2013Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xF] [PC:0x755773D, kcbw_get_bh()+67]Errors in file /o
2013-12-23 21:22:26 3365
原创 IPS简单使用方法
IPS简单使用方法:IPS(incident packaging service)是11G的新特性,其目的是查看某个错误相关的所有dump文件和trace文件,并可以很方便的打成一个包,我认为这个特性极大的方便了DBA进行远程诊断。PRE:使用前首先设置好ORACLE_HOME和PATH环境变量。进入adrci控制台:$adrciadrci tool is started.
2013-12-23 21:07:45 3030
原创 veridata报错: ‘java.lang.UnsupportedClassVersionError’:Bad version number in class file
现象:当add connection的时候,veridata报错:Agent remote message (101): Unhandled exception ‘java.lang.UnsupportedClassVersionError’:Bad version number in class file.分析:veridata版本:11.2.1.0.0操作系统:
2013-12-23 20:38:51 658
原创 又遇BUG-ORA-01148:数据文件忽然变为recover状态
现象:RAC环境,数据文件状态变为recover,查看alert日志有如下报错:Wed Jun 26 02:31:03 2013Thread 1 advanced to log sequence 33187 Current log# 1 seq# 33187 mem# 0: +TJDISK/tj/onlinelog/group_1.257.757797483Wed Jun 26
2013-12-19 20:37:19 1828
原创 RAC ORA-12170 ora-12535/tns-12535
现象:开发人员抱怨RAC数据库出现了时连得上时连不上的情况,用SQLPLUS一试,果然有这样的情况:SQL> conn system/*******@bjyd已连接。SQL> conn system/*******@bjyd已连接。SQL> conn system/*******@bjyd已连接。SQL> conn system/*******@bjyd已连接。
2013-12-18 22:42:16 1854
原创 ASMB的BUG(ORA-04030 kfmditer)导致数据库宕机
ASMB的BUG(ORA-04030 kfmditer)导致数据库宕机现象:客户的一个重要生产系统RAC的实例1宕机,查看alert日志:Fri Jun 21 17:05:52 2013Errors in file /opt/app/diag/rdbms/jyj/jyj1/trace/jyj1_asmb_11391.trc (incident=31397):ORA-0403
2013-12-18 20:23:02 8805
原创 官方文档的准确性很重要
Oracle metalink文档《Real Application Testing Now Available for Earlier Releases (Doc ID 560977.1)》写得非常清楚,在实施RAT时,SOURCE端为11.1.0.6,TARGET端为11.2.0.2+时,需要打patch8712466,如下所示:但实际在打的时候,报错:[o
2013-12-18 19:37:20 833
原创 mysql忘记root密码怎么办
参考了网友文章,感谢。一.windows系统的解决方法1.首先以系统管理员身份登陆系统。2.停止MySQL的服务。3.进入命令窗口,然后进入MySQL的安装目录,比如我的安装目录是c:\mysql,进入C:\mysql\bin4.跳过权限检查启动MySQL,c:\mysql\bin>;mysqld-nt --skip-grant-tables(或者将--skip-gra
2013-12-18 19:05:57 1005
原创 节点2主机关停之后,VIP并没有failover到节点一
现象:节点2主机关停之后,VIP并没有failover到节点一如下所示,在节点一查看,VIP并没有FAILOVER过来。[root@MAA01 ~]# ifconfigeth0 Link encap:Ethernet HWaddr A4:BA:DB:13:E2:AB inet addr:10.8.32.111 Bcast:10.0.15.255 Mask:255.255.2
2013-12-17 22:42:52 1856 1
原创 从OS文件系统拷贝spfile文件报错ASMCMD-08012
现象:从OS文件系统拷贝spfile文件报错ASMCMD-08012ASMCMD> cp /tmp/spfilessss.ora .source /tmp/spfilessss.oratarget +TESTDG/rac/spfilessss.oraASMCMD-08012: can not determine file type for file->'/tmp/spfilesss
2013-12-17 20:36:14 1247
转载 Script - Check Current Undo Configuration and Advise Recommended Setup
This document is intended to check the current undo configuration and provides recommendation based on the previous workload.AUTIONFor database version 10g and above, use the following script. Ensur
2013-12-17 19:05:15 853
原创 Oracle启动报错:memory_target needs larger /dev/shm
Oracle启动报错:memory_target needs larger /dev/shm现象:Oracle启动不了,alert日志报下错:Thu Oct 10 11:10:39 2013Starting ORACLE instance (normal)WARNING: You are trying to use the MEMORY_TARGET feature. Th
2013-12-12 20:18:53 1527
原创 ORA-609:疑似MEMORY_TARGET设置过大导致的宕机
ORA-609:疑似MEMORY_TARGET设置过大导致的宕机现象:客户的数据库最近短时间内发生好几次忽然宕机事件,查看alert日志:Thu Oct 10 10:47:50 2013ORA-609 : opiodr aborting process unknown ospid (834_47932399713424)Thu Oct 10 10:47:50 2013O
2013-12-12 20:07:24 3304
原创 RAC节点1reboot之后,节点1的资源为何没有failover到节点2?
节点1reboot之后,节点1的资源为何没有failover到节点2?现象:客户咨询了一个问题,即在节点1的reboot过程中,通过监控,始终没有发现节点1的资源failover到了节点2,如下:When node1 is in reboot state,crs_stat shows the nodeapps,asm,instance didn't transport to node2
2013-12-11 23:59:34 1343
原创 RAC如何启动状态为UNKNOWN的资源&&PRKS-1009,CRS-1028,CRS-0223
RAC如何启动状态为UNKNOWN的资源&&PRKS-1009,CRS-1028,CRS-0223现象:RAC的一个节点起不来,crs_stat查看发现很多资源状态都为offline[oracle@rac1 ~]$ crs_stat -tName Type Target State Host ---------------------------------------
2013-12-11 22:19:51 1251
原创 ORA-01555超长的Query Duration时间
ORA-01555超长的Query Duration时间现象:Alert日志报ORA-01555错误,但让人感到不可思议的是超长的Query Duration(1382909202 sec)。Mon Oct 28 05:26:42 2013ORA-01555 caused by SQL statement below (Query Duration=1382909202 sec
2013-12-11 20:31:46 1151
JAVAWEB项目如何向外部程序提供接口
2008-10-30
TA创建的收藏夹 TA关注的收藏夹
TA关注的人