-
2011-09-16 11:12:02 / Oracle数据库管理
11gR2 linux 64 3节点，其中2个节点被CRS踢出去了[ctssd(14845)]CRS-2408:The clock on host ora2 has been updated by the Cluster Time Synchronization Service to be synchronous with the mean cluster time.2011-09-16 04:28:13.927[ctssd(14845)]CRS-2408:The clock on host ora2 has been updated by the Cluster Time Synchronization Service to be synchronous with the mean cluster time.2011-09-16 04:30:22.320[cssd(14761)]CRS-1612:Network communication with node ora3 (3) missing for 50% of timeou
查看(160)
评论(15)
-
2011-09-08 11:14:55 / Oracle数据库管理
11GR2 RAC的两个节点执行相同的SQL语句，执行时间不一样11.2.0.1 linux_x64 rhel 5.6节点一select to_char(c_s.d_date,'yymmdd')||decode(to_char(c_s.d_date,'d'),1,'星期日',2,'星期一',3,'星期二',4,'星期三',5,'星期四',6,'星期五',7,'星期六','') rq,ch.channel_name,sum( c_s.playlength * adtype.is_calc_time) as totallength,sum( decode(ad.ignoremoney,'Y',c_s.playlength * adtype.is_calc_time,0) ) as reallengthfrom contract c,contract_schedule c_s,adtype ad,channel ch,adplay a,
查看(533)
评论(16)
-
2011-08-05 10:05:45 / Oracle数据库管理
ASMCMD里面可以复制目录吗？[grid@ora4 ~]$ asmcmdASMCMD> lsASM_DATA/ASMCMD> cd asm_dataASMCMD> lsASM/ZJADMAIN/ASMCMD> cd zjadmainASMCMD> lsCONTROLFILE/DATAFILE/ONLINELOG/PARAMETERFILE/TEMPFILE/spfilezjadmain.oraASMCMD> cp onlinelog abcASMCMD-08012: can not determine file type for file->'+asm_data/zjadmain/onlinelog'ORA-15056: additional error messageORA-17501: logical block size 0 is invalidORA-06512: at "SYS.X$DBMS_DISKGROUP", line 304ORA-06512: at l
查看(200)
评论(6)
-
2011-08-04 11:27:50 / Oracle数据库管理
11gR2 RAC linux x64上，请问如何修改scan ip呢各位可以提供些参考文档吗？谢谢
查看(168)
评论(2)
-
2011-07-27 10:05:51 / Oracle数据库管理
11gR2 RAC linux x64，可以修改vote_disk的位置吗[root@ora1 ~]# crsctl query css votedisk##STATEFile Universal IdFile Name Disk group--------------------------------- ---------1. ONLINEa8e9b14e73774ffbbf2c81fa75743ef9 (/dev/oracleasm/disks/OCR_VOTE12) [OCR_VOTE]2. ONLINE1534cafa96824fafbf9648001135e474 (/dev/oracleasm/disks/OCR_VOTE11) [OCR_VOTE]3. ONLINEa86c71594b514f55bfd6cb1c8ac81676 (/dev/oracleasm/disks/OCR_VOTE13) [OCR_VOTE
查看(470)
评论(27)
-
2011-07-25 12:50:32 / Oracle数据库管理
11gR2 的 ocr可以做mirror吗？、[root@ora1 disks]# ocrcheckStatus of Oracle Cluster Registry is as follows :Version:3Total space (kbytes):262120Used space (kbytes):2752Available space (kbytes) :259368ID:327280727Device/File Name:+OCR_VOTEDevice/File integrity check succeeded
查看(483)
评论(20)
-
2011-07-19 22:05:45 / Oracle数据库管理
现在metalink网站速度怎么这么慢大家知道这是为什么吗?难道我要用vpn吗？
查看(213)
评论(3)
-
2011-06-20 10:33:29 / Oracle数据库管理
11gR2 RAC 透明应用程序故障切换 疑问linux 5.6 x64oracle 11.2.0.1(最新补丁)CRS ASM数据库正常启动，每个个实例也正常工作现在做了测试。我用sqlplus 连接到10g上，看了一下连接的instance。然后我在后台手工shutdown immediate 这个instance.再做查询时候，这个session终止，需要重连。SQL> select failed_over from v$session where rownum < 5;FAI---NONONONOSQL> select instance_number from v$instance;INSTANCE_NUMBER---------------3关闭第三个实例
查看(291)
评论(18)
-
2011-06-08 13:07:34 / Oracle数据库管理
11202 linux_x64 安装gird,第一个节点执行root.sh，ora.asm无法启动，求帮助[root@hisrac01 ~]# /oracle/11.2.0/grid/root.shRunning Oracle 11g root script...The following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME=/oracle/11.2.0/gridEnter the full pathname of the local bin directory: [/usr/local/bin]:The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "cor
查看(629)
评论(37)
-
2011-03-07 12:54:53 / Oracle数据库管理
AWR中 events in waitclass Other 的等待如何细查在AWR中Background Wait EventsEvent Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txnevents in waitclass Other 24,374 84.60 640 26 9.79events in waitclass Other 在10分钟内有640sFrom Oracle 10g Oracle has consolidated lots of the events into “events in waitclass Other”. This is because saving all 900+ wait event stats for every session (in V$SESSION_EVENT array) would waste too much memory with giving little benefit (no
查看(509)
评论(9)
