#acl merlyn:read,write All:read = Oracle RAC processes setting = {{{ SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 1536M sga_target big integer 1536M SQL> show parameter target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 pga_aggregate_target big integer 9651M sga_target big integer 1536M SQL> select name, value from v$parameter where name in ('sessions','processes','transactions'); NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- processes 150 sessions 170 transactions 187 }}} # processes=x sessions=x*1.1+5 transactions=sessions*1.1 {{{ 350 350*1.1+5 390.0 (350*1.1+5)*1.1 429.00 select name, value from v$parameter where name in ('sessions','processes','transactions'); alter system set processes=350 scope=spfile sid='*'; alter system set sessions=390 scope=spfile sid='*'; alter system set transactions=429 scope=spfile sid='*'; }}} = Troubleshooting = == OCR initialization failed accessing OCR device: PROC-26: Error while accessing the physical storage Operating System error [No such file or directory] == === shebao1 === {{{ # fdisk -l Disk /dev/sda: 298.9 GB, 298999349248 bytes 255 heads, 63 sectors/track, 36351 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 36351 291884985 8e Linux LVM Disk /dev/sdc: 2147 MB, 2147483648 bytes 67 heads, 62 sectors/track, 1009 cylinders Units = cylinders of 4154 * 512 = 2126848 bytes Device Boot Start End Blocks Id System /dev/sdc1 1 1009 2095662 83 Linux Disk /dev/sde: 737.6 GB, 737660633088 bytes 255 heads, 63 sectors/track, 89682 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sde1 1 89682 720370633+ 83 Linux Disk /dev/sdf: 21.4 GB, 21474836480 bytes 64 heads, 32 sectors/track, 20480 cylinders Units = cylinders of 2048 * 512 = 1048576 bytes Device Boot Start End Blocks Id System /dev/sdf1 1 20480 20971504 83 Linux Disk /dev/sdh: 536.8 GB, 536870912000 bytes 255 heads, 63 sectors/track, 65270 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdh1 1 65270 524281243+ 83 Linux [root@shebao1 ~]# /etc/init.d/oracleasm Usage: /etc/init.d/oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|querydisk|listdisks|scandisks|status} [root@shebao1 ~]# /etc/init.d/oracleasm querydisk vol1 Disk "VOL1" is a valid ASM disk [root@shebao1 ~]# /etc/init.d/oracleasm querydisk VOL1 Disk "VOL1" is a valid ASM disk [root@shebao1 ~]# /etc/init.d/oracleasm querydisk -d VOL1 Disk "VOL1" is a valid ASM disk on device [8, 65] [root@shebao1 ~]# ls -l /dev/ | grep 8 | grep 65 brw-r----- 1 root disk 8, 65 2013-12-10 sde1 [root@shebao1 ~]# /etc/init.d/oracleasm querydisk -d VOL2 Disk "VOL2" is a valid ASM disk on device [8, 113] [root@shebao1 ~]# ls -l /dev/ | grep 8 | grep 113 brw-r----- 1 root disk 8, 113 2013-12-10 sdh1 [root@shebao1 ~]# ls -l /dev/raw/ 总计 0 crw-r----- 1 oracle oinstall 162, 1 02-08 17:43 raw1 crw-r----- 1 oracle oinstall 162, 2 02-08 16:15 raw2 }}} I. Check OCR(votedisk) {{{ [root@shebao1 ~]# /oracle/app/product/10.2.0/db_1/bin/crsctl query css votedisk 0. 0 /dev/raw/raw1 located 1 votedisk(s). }}} [root@shebao1 ~]# cat /etc/udev/rules.d/60-raw.rules {{{ # Enter raw device bindings here. # # An example would be: # ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N" # to bind /dev/raw/raw1 to /dev/sda, or # ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m" # to bind /dev/raw/raw2 to the device with major 8, minor 1. ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N" ACTION=="add",KERNEL=="sdf1",RUN+="/bin/raw /dev/raw/raw2 %N" KERNEL=="raw[1-2]", OWNER="oracle", GROUP="oinstall", MODE="640" [root@shebao1 ~]# scsi_id -g -s /block/sdc/sdc1 360080e50002c3f640000048451a810f7 [root@shebao1 ~]# scsi_id -g -s /block/sdf/sdf1 360080e50002c2b1c0000048751a811b7 }}} == shebao2 == {{{ # # An example would be: # ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N" # to bind /dev/raw/raw1 to /dev/sda, or # ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m" # to bind /dev/raw/raw2 to the device with major 8, minor 1. #ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N" #ACTION=="add",KERNEL=="sdf1",RUN+="/bin/raw /dev/raw/raw2 %N" #KERNEL=="raw[1-2]", OWNER="oracle", GROUP="oinstall", MODE="640" # 20170207 replaced as below #KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -s %p", RESULT=="360080e50002c2b1c0000048751a811b7" , NAME="ocrdisk01", OWNER="oracle", GROUP="oinstall", MODE="0640" # KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -s %p", RESULT=="360080e50002c3f640000048451a810f7" , NAME="data01", OWNER="oracle", GROUP="oinstall", MODE="0640" [root@shebao2 ~]# fdisk -l WARNING: GPT (GUID Partition Table) detected on '/dev/sda'! The util fdisk doesn't support GPT. Use GNU Parted. Disk /dev/sda: 298.9 GB, 298999349248 bytes 255 heads, 63 sectors/track, 36351 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 36351 291884985 8e Linux LVM Disk /dev/sdb: 21.4 GB, 21474836480 bytes 64 heads, 32 sectors/track, 20480 cylinders Units = cylinders of 2048 * 512 = 1048576 bytes Device Boot Start End Blocks Id System /dev/sdb1 1 20480 20971504 83 Linux Disk /dev/sdd: 536.8 GB, 536870912000 bytes 255 heads, 63 sectors/track, 65270 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdd1 1 65270 524281243+ 83 Linux Disk /dev/sdg: 2147 MB, 2147483648 bytes 67 heads, 62 sectors/track, 1009 cylinders Units = cylinders of 4154 * 512 = 2126848 bytes Device Boot Start End Blocks Id System /dev/sdg1 1 1009 2095662 83 Linux Disk /dev/sdi: 737.6 GB, 737660633088 bytes 255 heads, 63 sectors/track, 89682 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdi1 1 89682 720370633+ 83 Linux [root@shebao2 ~]# /etc/init.d/oracleasm querydisk -d VOL1 Disk "VOL1" is a valid ASM disk on device [8, 129] [root@shebao2 ~]# /etc/init.d/oracleasm querydisk -d VOL2 Disk "VOL2" is a valid ASM disk on device [8, 49] [root@shebao2 ~]# ls -l /dev/ | grep 8 | grep 129 brw-r----- 1 root disk 8, 129 02-06 23:17 sdi1 [root@shebao2 ~]# ls -l /dev/ | grep 8 | grep 49 brw-r----- 1 root disk 8, 49 02-06 23:17 sdd1 [root@shebao2 ~]# [root@shebao2 ~]# scsi_id -g -s /block/sdg/sdg1 360080e50002c3f640000048451a810f7 [root@shebao2 ~]# scsi_id -g -s /block/sdb/sdb1 360080e50002c2b1c0000048751a811b7 [root@shebao2 ~]# udevcontrol reload_rules [root@shebao2 ~]# start_udev 启动 udev： [确定] [root@shebao2 ~]# ls /dev/raw raw/ rawctl [root@shebao2 ~]# ls /dev/raw/ -l 总计 0 crw-r----- 1 oracle oinstall 162, 1 02-08 18:39 raw1 crw-r----- 1 oracle oinstall 162, 2 02-08 18:39 raw2 }}} == jdbc thin == {{{ jdbc:oracle:thin:@(DESCRIPTION=(load_balance=on)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.101.6)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.101.22)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=sbora))) }}}