本文共 2260 字，大约阅读时间需要 7 分钟。

Oracle Grid Infrastructure?RDBMS????

????

1.1 ??????

• ???1GB ? 2GB ???
• ??????????????????????1GB??????

1.2 ????

• MEMORY_MAX_TARGET?MEMORY_TARGET??????????????????????
• /etc/security/limits.conf???oracle??????????oracle????????????

1.3 IP??

• /etc/hosts?????IP???????????????
• VIP???????IP???????????

??????

2.1 ??????

• ??????groupadd??????????oinstall?dba?oper?
• ???????useradd????oracle?grid?????????????

2.2 ????

• oracle?????passwd oracle????????su - oracle????
• grid?????????????su - grid????

??????

3.1 ????

• /u01/app?????????
• /u01/app/grid???grid??????
• /u01/app/oraInventory???Oracle?????
• /u01/app/oracle???Oracle?????

3.2 ????

• ???????chmod?chown?????????
• ???????chmod -R????????

Oracle??????

4.1 Oracle????

• /home/oracle/.profile???Oracle???????

  export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=sourcedbexport PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/sbin/:$PATH

4.2 Grid????

• /home/grid/.profile???grid???????

  export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/gridexport PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/sbin/:$PATH

?????

5.1 ????

• unzip??????
• ?????????./runInstaller???????

5.2 ????

• ORACLE_BASE?ORACLE_HOME???????
• CVU????????????

OPatch?PSU??

6.1 OPatch??

• OPatch???????OPatch?????
• OPatch?????opatch lsinventory??????

6.2 PSU??

• PSU?????opatch prereq CheckConflictAgainstOHWithDetail????
• PSU?????opatch apply??PSU??

?????

7.1 SGA??

• ??SGA?????SQL????SGA??

  SQL> alter system set sga_max_size = 50G scope=spfile;SQL> alter system set sga_target = 50G scope=spfile;

7.2 ????

• ????????SQL> shutdown immediate?SQL> startup mount??

??????

8.1 /etc/sysctl.conf??

• sysctl?????????

  fs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmax=4294967295kernel.shmmni=4096kernel.sem=250 32000 100 128net.ipv4.ip_local_port_range=9000 65500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048576

8.2 limits.conf??

• oracle???????oracle????????????

  oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768

????

• ??????????????????
• ??SGA???SQL> show parameter sga;??SGA??
• ??????????????

???????????Oracle Grid Infrastructure?RDBMS???????

转载地址：http://fapfk.baihongyu.com/