ORACLE 9i-23ai – Page 36

hpux psu 10.2.0.4.12 遇到的一些小问题

2015-01-13 by weejar zhang

XX电信就是一个急性子，上午决定升级晚上就要实施，下面记录一下HPUX IA64 10.2.0.4.0 PSU 到10.2.0.4.12时遇到的一些小问题, 那些非常归安装的人确实让人讨厌。 10.2.0.4..0 到 10.2.0.4.12 中间要先到10.2.0.4.4。 # 检查数据库的无效对象和组件状态，排除是因升级造成的 select comp_name,version,status,schema from dba_registry; select owner,object_type ,count(*) from dba_objects where status<>’VALID’ group by owner,object_type; # 检查当前版本 [oracle@hbodsdbb:/ora10g/app/oracle/product/db10g/OPatch]#opatch lsinventory # backup ORACLE software [oracle@hbodsdba:/bonc]#tar cvf oracle10204.tar -C /ora10g/app/oracle/product . #stop listener lsnrctl stop #stop session [oracle@hbodsdba:/ora10g]#ps -ef|grep NO|grep -v grep |awk ‘{print $2}’|xargs kill … Read more

Unable execute “@”(at) sql file in sqlplus on hp-ux issue

2015-01-05 by weejar zhang

I have a ORACLE db server on hp-ux, i want to execute a sql script file in sqlplus using “@” , get some error. but I use “start” sql file in sqlplus ,it work fine for me. now I have been resolved this error, just shared here. SQL> @uptime SP2-0042: unknown command “uptime” – … Read more

Troubleshooting ORA-31693 ORA-31617 ORA-19505 ORA-27037 when expdp with parallel on RAC 11G

2014-12-31 by weejar zhang

ORA-31617: unable to open dump file “/dsg/datapump/ocs02.dmp” for write
ORA-19505: failed to identify file “/dsg/datapump/ocs02.dmp”
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory

Troubleshooting ora-600 [18194] and ora-600 [1265] error

2014-12-27 by weejar zhang

Errors in file /opt/oracle/app/admin/anbob/udump/anbob1_ora_10082.trc:
ORA-00600: 内部错误代码, 参数: [opiodr: call 2], [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [18194], [0xC0000002EE1E77E8], [0x000000000], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [1265], [0xC0000002FF7EF3D8], [], [], [], [], [], []

Troubleshooting “DFS lock handle” wait event

2023-02-072014-12-25 by 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.

Troubleshooting Instance crash when modify db_cache_size, ora-600 [kmgs_pre_process_request_6]

2014-12-24 by weejar zhang

昨天一套开发库在开发人员修改了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]

Troubleshooting One RAC node reboot with ora-600 [kjdrisRMnovalid:msgRMno]

2014-12-24 by weejar zhang

今天一套 2节点的11.2.0.3 RAC 数据库计划在0点的维护窗口做一些参数优化，其中包括禁用DRM ，所以在下午提前修改了参数scope=spfile等晚上重启时生效，计划赶不上变化，就在大伙等待0点到来时，突然节点2主机重启，随后节点1跟随instance reboot(主机未重启),在Node1 DB alert.log 发现了ora-600 [kjdrisRMnovalid:msgRMno].

Troubleshooting ora-07445 [smboCkaGetPivot]

2014-12-22 by weejar zhang

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 DISKGROUP Migrate to Anotherr SAN (迁移ASM到新存储)

2023-01-302014-12-15 by weejar zhang

上周刚刚做了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

Troubleshooting RAC intrance crash caused by private network IP address conflict (IP冲突)

2014-12-08 by weejar zhang

今天有套rac 的一个节点主机重启，CRS没有启动， 10.2.0.5 2nodes rac on aix. 手动启动CRS依旧没有拽起来，下面整理一下错误过程… DUPLICATE IP ADDRESS DETECTED IN THE NET

Troubleshoot ORA-27544,ORA-27300,ORA-27301,ORA-27302,”HPUX-ia64 Error: 23: File table overflow” issue

2022-12-222014-12-06 by weejar zhang

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

Tuning “transaction” & TX lock wait event ,speeding up rollback dead transaction

2014-12-04 by weejar zhang

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.

ORA-01135 ORA-01110 check offline tablespace in alert.log

2014-12-02 by weejar zhang

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

ora-00313,ora-00312 ora-17503, ora-15001

hpux psu 10.2.0.4.12 遇到的一些小问题

Unable execute “@”(at) sql file in sqlplus on hp-ux issue

Troubleshooting ORA-31693 ORA-31617 ORA-19505 ORA-27037 when expdp with parallel on RAC 11G

Troubleshooting ora-600 [18194] and ora-600 [1265] error

Troubleshooting “DFS lock handle” wait event

Troubleshooting Instance crash when modify db_cache_size, ora-600 [kmgs_pre_process_request_6]

Troubleshooting One RAC node reboot with ora-600 [kjdrisRMnovalid:msgRMno]

Troubleshooting ora-07445 [smboCkaGetPivot]

ASM DISKGROUP Migrate to Anotherr SAN (迁移ASM到新存储)

Troubleshooting RAC intrance crash caused by private network IP address conflict (IP冲突)

Troubleshoot ORA-27544,ORA-27300,ORA-27301,ORA-27302,”HPUX-ia64 Error: 23: File table overflow” issue

Tuning “transaction” & TX lock wait event ,speeding up rollback dead transaction

ORA-01135 ORA-01110 check offline tablespace in alert.log

Troubleshooting ORA-01031: Insufficient Privileges issue

Autotask(Optimizer statistics gathering) not working in 11.2.0.4(未自动收集统计信息)

IMPDP hangs, session wait “wait for unread message on broadcast channel”

Duplicate (Clone) Oracle Database to the Same Machine (同一机器数据库还原)(二)

Duplicate (Clone) Oracle Database to the Same Machine (同一机器数据库还原)(一)

Exp-00003 no storage definition found issue in oracle 11g (未找到段 (0,0) 的存储定义)

How to drop ASM DiskGroup in RAC? (DISKGROUP删除后db资源显示OFFLINE)