ITPub博客

查看ASM_DISKGROUPselect * from v$asm_diskgroup 查看 asm_disk 查看asm_diskSQL> select group_number, disk_number, mount_status, header_status, name, path from v$asm_disk;GROUP_NUMBER DISK...

[oracle@rac1 init.d]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event...

说明grid 安装以后，有21个进程GSD,OC4J这两个进程是OFFLINE的，新手安装后，看到进程OFFLINE，会很纳闷。其实这两个进程就是OFFLINE [oracle@rac1 ~]$ crs_stat -tName     &nbs...

rac 可以采用其中一个节点作为server,另外一个作为clientserver:1:service ntpd stop 2:rm -rf /etc/ntp.conf 3:vi /etc/ntp.confrestrict default kod nomodify  nopeer noqueryrestrict 192...

安装RAC2 root.sh 成功，但是报错吴20802[INS-20802] Oracle Cluster Verification Utility failed

[root@rac1 ~]# service iptables statusTable: natChain PREROUTING (policy ACCEPT)num  target     prot opt source          &nbs...

节点1 rac1执行两个脚本都是success,节点2rac2执行最后一个脚本root.sh 出现错误。错误的原因是因为节点1 和节点2 防火墙没有关闭，关闭防火墙安装成功节点1:[oracle@rac1 grid]$ /u01/app/oraInventory/orainst...

Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2This article describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise Linux 5 64-bit) ...

http://wenku.baidu.com/view/a734003567ec102de2bd896d.html[@more@]

需要在图形化界面安装linux DISPLAY配置vi /home/oracle/.bash_profile *添加EXPORT DISPLAY=:0.0[@more@]

http://blog.csdn.net/xiaoxu0123/article/details/5026960[@more@]

http://space.itpub.net/7607759/viewspace-616379[@more@]

grep MemTotal /proc/meminfogrep SwapTotal /proc/meminfo/etc/sysctl.conf中编辑kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144/sbin/sysctl –p在/etc/rc.local中加入（数值以具体情况而定，以下是默认值）modprobe hangcheck-timer hangcheck_tick=30 hangcheck_margin=180# /usr/sbin/user

2.3.7.1 Configuring SSH on Cluster Member NodesTo configure SSH, you must first create RSA and DSA keys on each cluster node, and then copy the keys from all cluster node members into an authorized keys file on each node. To do this task, complete the following steps:Create RSA and DSA keys on each node: Complete the following steps on each node:Log in as the oracle user.If necessary, create the .ssh directory in the oracle user's home directory and set the correct permissions on it:$ mkdir ~/.s

Linux 时间同步配置 收藏 一. 使用ntpdate 命令1.1 服务器可链接外网时 # crontab -e 加入一行： */1 * * * * ntpdate 210.72.145.44 210.72.145.44 为中国国家授时中心服务器地址，这样该机每隔1分重就可以与国家授时中心进行同步了。 注意： 在使用ntpdate 命令时， ntpd 服务必须是关闭的， 否则会报the NTP socket is in use, exiting 错误。关闭 ntpd 服务命令如下：[root@node2 init.d]# /etc/init.d/ntpd stopShutting down ntpd: [ OK ]1.2. 架设本地时间服务器需要修

1.修改第一个节点：alter system set sga_max_size=2G 　sid="rac1 "scope=spfile；alter system set sga_target=2G sid="rac1 "scope=spfile;shutdown immediatestartup2.当第一个节点启动后，修改第2个节点：alter system set sga_max_size=2G sid = "rac2 "scope=spfile；alter system set sga_target=2G sid = "rac2 "scope=spfile;shutdown immediatestartup[@more@]rac

rac的典型的listener.ora and tnsnames.ora设置(双实例)rac 2010-11-05 15:08:43 阅读104 评论0 字号：大中小 订阅 [root@node1 admin]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost192.168.0.11 node1192.168.0.22 node2192.168.0.201 node1-vip192.168.0.202 node2-vip10.10.10.11 node1-priv10.10.10.22 node2-priv[root@node1 admin]# [root@node1 admin]# cat listener.ora # listener.ora.

http://space.itpub.net/7607759/viewspace-429388[@more@]

ORACLE RAC工作原理 　 在一个应用环境当中，所有的服务器使用和管理同一个数据库，目的是为了分散每一台服务器的工作量，硬件上至少需要两台以上的服务器，而且还需要一个共享存储设备。同时还需要两类软件，一个是集群软件，另外一个就是Oracle数据库中的RAC组件。同时所有服务器上的OS都应该是同一类OS,根据负载均衡的配置策略，当一个客户端发送请求到某一台服务的listener后，这台服务器根据我们的负载均衡策略，会把请求发送给本机的RAC组件处理也可能会发送给另外一台服务器的RAC组件处理，处理完请求后，RAC会通过集群软件