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]

1. 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"