Day3-Oracle数据库培训ppt课件.ppt

《Day3-Oracle数据库培训ppt课件.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle数据库高级培训内部威胁隐私合规性Day3内部威胁隐私合规性ORACLERAC的安装(linux为例)与管理Oracle10gRAC对操作系统与硬件的要求1.操作系统的版本要一致.2.建议采用HA或ASM做共享裸设备管理.3.物理机器的CPU不要求同样的主频，但要求型号一致，比如都是intel系列的，不能用intel+power+安腾.4.每台物理机器都至少要2个网卡（考虑可靠性2*2)，一个对外服务，一个给Oracle的RAC用，并接入网络交换机。5.连接共享的存储设备，每台物理机器还需要HBA卡.

2、接入SNA交换机RAC部署Node1Instance1CRShomeLocalstorageOraclehomeNodenInstancenCRShomeLocalstorageOraclehome…VotingfileOCRfileSharedstorageLinuxKernelParameters/proc/sys/net/ipv4/ip_local_port_range1024-65000ip_local_port_name/proc/sys/fs/file-max65536file-max/proc/s

3、ys/kernel/shmmni4096shmmni/proc/sys/kernel/shmmaxHalfthesizeofphysicalmemoryshmmax/proc/sys/kernel/shmall2097152shmall/proc/sys/kernel/sem128semmni/proc/sys/kernel/sem100semopm/proc/sys/kernel/sem32000semmns/proc/sys/kernel/sem250semmslFileParameterValueUsin

4、gRawPartitionsVolumeforOCR1001OracleCRSvotingdisk201Passwordfile51Serverparameterfile(SPFILE)51TEMPtablespace2501Firstandsecondcontrolfiles11022onlineredologsperinstance1202perinstanceUSERStablespace1201EXAMPLEtablespace1601UNDOTBSntablespace5001perinstanceS

5、YSAUXtablespace300+250perinstance1SYSTEMtablespace5001PurposePartitionSize(MB)NumberofPartitionsInstallingClusterReadyServices$/cdrom/crs/runInstallerClusterConfigurationPrivateInterconnectEnforcementOracleClusterRegistryFileVotingDiskFileInstalltheDatabaseS

6、oftware$idoracle$/cdrom/dbs/runInstallerSpecifyFileLocationsSpecifyClusterInstallationSelectInstallationTypeClientSideConnect-TimeLoadBalancingERP=(DESCRIPTION=(LOAD_BALANCE=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1vip)(PORT=1521))(ADDRESS=(PROTOCO

7、L=TCP)(HOST=node2vip)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ERP)))node1node2RandomaccessClientSideConnect-TimeFailoverERP=(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HO

8、ST=node2vip)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ERP)))node1vipnode2vip3412TAFBasicConfiguration:ExampleAP=(DESCRIPTION=(FAILOVER=ON)(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=N1VIP)(PORT