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]
- 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"
shebao1
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