ITPub博客

记录一下ORACLE 10gR2的软件下载地址，备用。下载OTN上的这些软件，你需要一个OTN免费帐号，不过如果通过迅雷进行下载，就不用登陆OTN了：Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)http://download.oracle.com/otn/nt/oracle10g/1020...

Cluster nodes maintain their heartbeat via private network and voting disk. When there is a private network disruption, cluster nodes can not communicate to each other via private network for the time period of misscount setting, split brain will happen. In such case, voting disk will be used to...

[oracle@bcc1 ~]$ srvctl add service -hAdds a service configuration to the Oracle Clusterware.Usage: srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <pool_name> [-c {UNIFORM | SINGLETON}] } [-k  ...

11g R2 RAC: SERVER POOLSJanuary 11, 201311g R2 RAC, Uncategorized                                         In this post, I will explain about Server P...

waring 1： WARNINGASM CheckLinux Disk I/O Scheduler should be configured to [Deadline]All ASM InstancesView做了如下修改：[root@bcc1 ~]# echo 'deadline' > /sys/block/sda/queue/scheduler[root@bcc1 ~]# cat...

[grid@bcc2 ~]$ sqlSQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:26:21 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SQL> exitDisconnected[grid@bcc2 ~]$ vi .bash_profile # .bash_profile# Get the aliases and functionsi...

LL@dbfs1>set autotraceUsage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] 有些朋友喜欢用set autotrace 来查看执行计划可是却不知道它的假象，有些朋友认为，set autotrace traceonly explain只是出现执行计划，却不知道其实它已经在后台默默的执行了。例：1....

 As the purpose of the user is essentially to allow database users to execute external jobs, you should not use the oracle user. The oracle user is a pow...

在导出过程中遇到：ORA-01691: unable to extend lob segment SYS.SYS_LOB0001625349C00044$$ by 61446 in tablespace SYSTEM  很明显是表空间空间不够了，无法导出对象。随后扩展了表空间大小alter tablespace system add datafile '/../../rlv1_system12' size 10g;顺利导出总结：      ...

MAN> restore database from tag "TAG20141120T184440";Starting restore at 26-NOV-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=316 device type=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: SID=315 device type=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: SID=317 device ...

今天在客户现场做健康检查时出现这个问题[root@el01cn01 exachk]# ./exachk Unable to determine rack type. Please set RAT_ELRACKTYPE and try again在Oracle MOS中发现了解决方法Error 1:Unable to determine rack type. Please set RAT_ELRACKTYPE and try again.Error 2:Could not open d...

发现告警信息Wed Nov 19 07:16:18 2014Dumping diagnostic data indirectory=[cdmp_20141119071618], requested by (instance=1, osid=125680 (J000)),summary=[abnormal process termination].Non critical errorORA-48913 caught while writing to trace file"/u01/app/oracle/diag/rdbms/ed...

发现Exadata的dcli是个十分好用的工具。今天将该工具get出来，做个一个配置互信的实验。编辑文件，将需要配置互信的节点全部写入[root@db1 ~]# vi all_group 192.168.204.5192.168.204.10使用配置文件执行ssh配置[root@db1 ~]# ./dcli -k -g all_group -l rootError: Neither RSA nor DSA keys have been gen...

1、今天在测试库做实验时遇到了一个关于listener报错。问题如下Oracle Restart enable database creation requries Default listener configured and running in Grid Infrastructure home，Use NETCA in Grid Infra...

错误描述,在DBCA创建ASM单实例数据库到86%进度时，报错PRCR-1079 : Failed to start resource .testdb.dbORA-12547: TNS:lost contact在网上查了一下多是grid用户下$ORACLE_HOME/bin/oracle 和 oracle用户下 $OR...

在DBCA 单实例 创建过程中报错如下由于我是ASM单实例数据库创建，所以我使用grid用户创建的 listener 结果导致如上报错 在EM创建资料库的时候，需要记录listener的home 目录对于oracle用户来说，listener的home...

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...