提供综合数据库运维服务与优化方案(不限Oracle MySQL PG GaussDB GoldenDB OceanBase等), 微信/Tel:(+86)134-365-60330
weejar zhang a few days ago,My CRM DB face to a performance issue. DB is very slow. then I check DB wait event of active session ,Most sessions is waiting “DFS lock handel” , ‘DFS lock handle’ can cause massive performance issues in a busy RAC cluster. my db is 10R2 2NODE RAC ON AIX.
昨天一套开发库在开发人员修改了db_cache_size后instance crash了， 10.2.0.1 single instance on RHEL linux,是因为触发了一个bug, ORA-00600: internal error code, arguments: [kmgs_pre_process_request_6], [6], [895], [0], [3], [0x459C1F3D8]
今天一套 2节点的11.2.0.3 RAC 数据库计划在0点的维护窗口做一些参数优化，其中包括禁用DRM ，所以在下午提前修改了参数scope=spfile等晚上重启时生效，计划赶不上变化，就在大伙等待0点到来时，突然节点2主机重启，随后节点1跟随instance reboot(主机未重启),在Node1 DB alert.log 发现了ora-600 [kjdrisRMnovalid:msgRMno].
Mon Dec 22 09:43:39 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/udump/anbob1_ora_8183.trc:
ORA-07445: exception encountered: core dump [smboCkaGetPivot()+240] [SIGSEGV] [Invalid permissions for mapped object] [0x000000110] [] []
上周刚刚做了ASM Storage的一套13T 2 Nodes 11GR2 database RAC ON AIX 从老的SAN迁移到新的SAN , 迁移的磁盘组包含了DATAFILE 和所有Clusterware 的文件(OCR andvoting disk)， ORACLE ASM 的Rebalance特性使这件事情变的非常的容易，随着ASM的逐渐成熟，如果你计划做对已使用了ASM disggroup 做存储的迁移，ASM 的Rebalance 可以做为一套解决方案而且可以做到0 Downtime， 下面简单的分享这个过程。 迁移步骤 1.备份整个数据库和GI文件，并验证备份文件有效性 GI. # ocrcheck # crsctl query css votedisk DB. spfile,controlfile,datafile,logfile,tempfile,archivelog.. select d.name group_name,f.type,count(*) cnt from v$asm_file f join v$asm_diskgroup d on f.group_number=d.group_number group by rollup (d.name,f.type); A 迁移GI … Read more
今天有套rac 的一个节点主机重启，CRS没有启动， 10.2.0.5 2nodes rac on aix. 手动启动CRS依旧没有拽起来，下面整理一下错误过程… DUPLICATE IP ADDRESS DETECTED IN THE NET
A product database is 10205 2nodes rac ,our OS is HP-UNIX 11.31,There was a time unable establish new connections, then I check alert log found ORA-27544,ORA-27300,ORA-27301,ORA-27302,”HPUX-ia64 Error: 23: File table overflow” error. The problem seems to be OS related. #alert log Sun Nov 30 15:47:16 EAT 2014 Global Enqueue Services Deadlock detected. More info in … Read more
Yesterday I received a warning and a production db instance found many TX lock and wait event “transaction”, I check the TX lock model is 6, so we can make sure is caused by multiple sessions update the same data, and wait event “transaction” is relatively rare, Here the record about my diagnosis method.
My case is 2 nodes 10.2.0.5 RAC on aix,The previous we do move all objects on a tablespace to new tablespace For reasons of space Fragment, and alter the original tablespace offline. But ORA-01135 ORA-01110 error in the alert.log file I keep seeing the message every 10 minutes
1, Login in remote instance using sqlplus as sys when the target db instance password file not exists or file name is wrong.
2, If you try to execute DBMS_SESSION.SET_CONTEXT
有一些表数据发生了很大变化，但是统计信息从初次导入后从没有自动收集过统计信息，导致现在的有些执行计划不成确， 手动收集是可以成功的，如何开启自动收集？ oracle 11.2.0.4 RAC ON AIX
昨晚有个朋友说加班在IMPDP数据, 在导入中途突然没有了进展,挂在那里不动了,impdp 窗口也没有报错, 一直等了1个多小时,说是impdp使用了parallel,怀疑是parallel参数出了问题, 最终其实原因很简单。这里只是简单的描述遇到这类问题时的处理思路。
When an DB operation error occurred , and flashback technique can not be used, you can use this way do a database point in time recover on same db server, to clone a new db to recover, then drop.
Starting with Oracle 11g there are now two ways to clone a database:
1. Active Database Duplication
2. Backup-based Duplication
. 正在导出表 ANBOB_CREDIT导出了 6 行
EXP-00003: no storage definition found for segment (0, 0)
. . 正在导出表 ANBOB_MODEL导出了 1 行
. . 正在导出表 ANBOB_FILE
to chose sqlplus “drop diskgroup”. however,the diskgroup that dropped is still listed as a resource. , Actually, the DB is open still, check alert log
ora-00313,ora-00312 ora-17503, ora-15001
She had with installation of Oracle 11R2 on Windows 8 (64-bit). The issues I faced The errors can’t connect database using Listener Service.and can’t to add new listener.
. . exported “ANBOB”.”ANBOB_PROJECT_SCORE” 3.931 GB 46241981 rows
. . exported “ANBOB”.”T1″
EXP-00056 Oracle error 600 encountered
ORA-00600: internal error code, arguments: [ksuloget2], [0xFEBDD104], [0xFEBCEE54], [500], [0xFEBDD128], [], [], [], [], [], [], []
. . exported “ANBOB”.”T2″
节前有个网友向我咨询他们的生产库遇到了ora-8103,错误的block 是 SEGMENT HEADER BLOCK, 不可以简单通过rowid 跳过， 也不能像修改data block corruption 那样通过bbed 修改块为 corrupted 然后通过 dbms_repair.skip_corrupt_blocks 跳过该块， 该segment header block上都没有extent 信息(如extent map\HWM)…
A friend from QQ Group find me, he removed a online datafile from the his production database, but for as long as the database remains up. he re I take a demo to show recovery process. …