ITPub博客

Oracle11g安装grid的时候。条件检查的时候出现了如下警告，Device Checks for ASM - This is a pre-check to verify if the specified devices meet the requirements for configuration through the Oracle Universal Storage  Manager Configuration Assistant.?解决方法如下：# groupadd oinstall# rpm -ivh...

1.Hardware check.  (1)machinfo | grep -i memory   # memory>2G  (2)swapinfo -a  (3)bdf                         #Disk Space Require2.Software Check.&nb...

Oracle RAC中local_listener指定instance1 : SQL>alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))' sid='instance1';instance2 : SQL>alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))' sid='instance2';  &nbsp...

Oracle 11.2.0.4 RAC 安装Linux系统安装之类，就不截图了. 1.在两个节点建立相同的group&user[root@racdb1 ~]# groupadd -g 1000 oinstall[root@racdb1 ~]# groupadd -g 1200 asmadmin[root@racdb1 ~]# groupadd -g 1201 asmdba[root@racdb1 ~]# groupadd -g 1202 asmoper[root@rac...

ORACLE 11.2.0.4 RAC Grid 安装提示 INS-30510: Insufficient number of ASM disks selected.错误的原因是由于磁盘数和冗余层级不匹配：如果创建用来存放OCR和VOTEDISK的ASM磁盘组，那么External、Normal、High三种冗余级别对应的Failgroup个数是1、3、5。也就是说，创建这三种冗余级别的磁盘组至少分别需要1、3、5个...

Vcenter中共享磁盘的建立有几个要注意的地方：1.SCSI 控制器1  是添加磁盘后显示出来的.2.SCSI 控制器类型选择 “LSI Logic并行”，SCSI总线共享 选择“物理”3.硬盘n(2~7)的类型选择“厚置备置零”，虚拟设备节点选择“SCSI(1:n)” 其中n是0,1,2,3,4,5,6.....具体显示可以参照下图....

[root@xxxxxdb2 ~]# crsctl stat res -t--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER       &nbsp...

oracle10g的时候查看resource用 crs_stat -t比较多.到了oracle11g后查看resource 用 crsctl stat res -t[root@xxxxxdb2 ~]# crsctl stat res -t--------------------------------------------------------------------------------NAME           TARGET  STA...

(oracle11gR2启动crs的时候也要执行这个命令。)oracle11g RAC安装grid 11.2.0.1的时候执行root.sh脚本的时候,当脚本执行到Adding daemon to inittab时:马上使用root用户在另一个窗口不停地执行/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1，这条dd命令执行后，会一直停在那里，当Grid...

装oracle11.2.0.3 RAC，执行root.sh的时候，出现了如下错误:[@more@]Failed to create keys in the OLR, rc = 127, Message: /opt/app/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory 执行如下操作，就可以在此执行root.sh了[root@rac1 ~]# cd /lib64[root@rac1 lib64]# ls libcap*libcap-ng.so.0 libcap-ng.so.0.0.0 libcap.so.2 libcap.so.2.16[root@rac1 lib64]# ln -s libcap.so.2.16 libcap.so.1 [root@rac2 lib64]# ln -s libcap

vmware workstation创建虚拟共享磁盘[@more@]c:Program FilesVMwarevmware workstation>vmware-vdiskmanager.exe -c -s 8000Mb-a lsilogic -t 2 "C:vmdatarac-sharediskdata01VixDiskLib: Invalid configuration file parameter. Failed to read configurationfile.Creating disk 'C:vmdatarac-sharediskdata01' Create: 100% done.Virtual disk creation successful.c:Program FilesVMwarevmware workstation>vmware-vdiskmanager.exe -c -s 6000Mb-a lsilogic -t 2 "C:vmdatarac-sharediskfra01VixDiskLib: Invalid c

单实例session可以直接通过v$session和v$locked_object两个视图就可以kill。[@more@]select distinct 'ALTER SYSTEM KILL SESSION '''||b.sid||', '||b.serial#||''';' from v$locked_object a,v$session b where a.session_id=b.sid 但是这个不能删除RAC中session alter system kill session 的语法： The KILL SESSION clause lets you mark a session as terminated, roll back ongoing transactions, release all session locks, and partially recover session resources. To use this clause, your instance must have the databa

linux安装oracle RAC的时候，挂载lun的时候，需要安装多路径软件RDAC，具体步骤如下：[@more@]下载package的地址为: http://support.netapp.com/NOW/public/apbu/oemcp/ 1,安装需要的package：tar -zxvf rdac-LINUX-09.03.0C05.0652-source.tar.gzcd linuxrdac-09.03.0C05.0652/2,之后需要make，make install，但是缺少package，所以需要使用yum 安装kernel-devel,gcc之类的包yum install kernel-develyum install gcc*3,需要在rdac解压目录中执行如下步骤makemake install4,make install之后根据提示修改/boot/efi/EFI/redhat/grub.conf中

vmserver2.0+rhel5.4+oracle10gRAC+asm+dataguardvmserver2.0+rhel5.4+oracle10gRAC+ocfs2+dataguard[@more@]

今天测试oracle11g 使用scan ip连接数据库时出现，如下错误:[@more@]C:UsersFounder>sqlplus sys/oracle@racdb_scan as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:22:36 2013Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-12545: 因目标主机或对象不存在, 连接失败tnsnames.ora:racdb_scan =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.155)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = racdb)))解决办法:C:UsersFounder>sq

http://www.itpub.net/thread-1775304-1-1.html[@more@]

Service nameSelect * from dba_servicesalter system set service_names=a,b,c,d;select service_name from v$session where sid=(select sid from v$mystat where rownum=1) àcheck the service nameselect * from v$servicemetric à查看业务情况一起负载。1.failovera).connect time failover àclient端实现的把地址列表加进去，连的时候选择实现。b).TAF(transparent application failover) àclient端实现的(FAILOVER_MODE =(TYPE = SELECT) --select/session(转移session)(METHOD = BASIC) (RETRIES = 180) --尝试180次 (DELAY =