ORACLERAC实施报告

1、xxxxx 有限公司 oracle rac 安装报告1 查看系统所需的包rpm-qbinutilscompat-libstdc+-33elfutils-libelfelfutils-libelf-develglibcglibc-common glibc-devel gcc gcc-c+ libaio-devel libaio libgcc libstdc+ libstdc+-devel make sysstat unixodbc unixodbc-devel pdksh2 ip 规划vi /etc/hosts 173.1.1.224ygssun1173.1.1.225 ygssun2173.1

2、.1.226 ygssun1-vip173.1.1.227 ygssun2 -vip192.168.234.224 ygssun1-priv192.168.234.225 ygssun2-privscan ip173.1.1.228 order1-173.1.1.229 order1-173.1.1.230 order1-3 创建组及用户创建组/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/groupadd -g 503 oper/usr/sbin/groupadd -g 504 asmadmin

3、/usr/sbin/groupadd -g 505 asmoper/usr/sbin/groupadd -g 506 asmdba创建用户/usr/sbin/useradd -g oinstall -g dba,asmdba,oper oradb/usr/sbin/useradd -g oinstall -g asmadmin,asmdba,asmoper,oper,dba oracrs修改用户密码passwdoracrs passwdoradb31修改文件夹权限、属主mkdir /oracle/app/chown -r oracrs:oinstall /oracle/app/ chmod -

4、r 775 /oracle/app/mkdir -p /oracle/app/orainventorychown -r oracrs:oinstall /oracle/app/orainventory chmod -r 775 /oracle/app/orainventorymkdir -p /oracle/app/grid mkdir -p /oracle/app/oraclechown -r oracrs:oinstall /oracle/app/grid chown -r oradb:oinstall /oracle/app/oracle chmod -r 775 /oracle/app

5、/oraclechmod -r 775 /oracle/app/grid4 修改用户变量oracrs 用户环境变量：su - gridvi .bash_profileif -f /.bashrc ; then. /.bashrcfi# user specific environment and startup programs path=$path:$home/binexport path tmp=/tmp; export tmptmpdir=$tmp; export tmpdir oracle_sid=+asm1; export oracle_sidoracle_base=/oracle/a

6、pp/oracle; export oracle_base oracle_home=/oracle/app/grid/product/11.2.0; export oracle_home nls_date_format=“yyyy-mm-dd hh24:mi:ss“; export nls_date_format threads_flag=native; export threads_flag path=$oracle_home/bin:$path; export paththreads_flag=native; export threads_flag path=$oracle_home/bi

7、n:$path; export pathoradb 用户环境变量：su - oradbif -f /.bashrc ; then. /.bashrcfi# user specific environment and startup programs path=$path:$home/binexport path tmp=/tmp; export tmptmpdir=$tmp; export tmpdiroracle_base=/oracle/app/oracle; export oracle_base oracle_home=$oracle_base/product/11.2.0; expor

8、t oracle_home oracle_sid=order1; export oracle_sidoracle_term=xterm; export oracle_term path=/usr/sbin:$path; export path path=$oracle_home/bin:$path; export pathld_library_path=$oracle_home/lib:/lib:/usr/lib; export ld_library_path classpath=$oracle_home/jre:$oracle_home/jlib:$oracle_home/rdbms/jli

9、b; classpathnls_date_format=“yyyy-mm-dd hh24:mi:ss“; export nls_date_format nls_lang=american_america.zhs16gbk;export nls_langoracle_unqname=order export oracle_unqname5 修改系统参数vi /etc/security/limits.confexportoracrssoftnproc2047oracrshardnproc16384oracrssoftnofile4096oracrshardnofile65536oradbsoftn

10、proc2047oradbhardnproc16384oradbsoftnofile4096oradbvi /etc/pam.d/loginhardnofile65536sessionrequiredpam_limits.sovi /etc/sysctl.conf kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 41943

11、04net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr= 1048576使 /etc/sysctl.conf 更改马上生效sysctl p为 oracle 用户设置 shell 限制.oracle 建议对每个 linux 帐户可以使用的进程数和打开的文件数设置限制,root 登录.(/etc/profile (oracle11g )if $user = “oradb“ | $user = “oracrs“ ; then if $shell = “/bin/ksh“ ; thenulimit -p 1638

12、4ulimit -n 65536 elseulimit -u 16384 -n 65536 fiumask 022 fi时间同步所需要的设置(11gr2 新增检查项)/sbin/service ntpd start6 安装 asmliboracleasmlib-2.0.4-1.el5.i386.rpmoracleasm-2.6.18-308.el5xen-2.0.5-1.el5.x86_64.rpm oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpmrootyygssun23 oracleasm# rpm -uvh oracleasmlib-2.0.

13、4-1.el5.i386.rpmwarning: oracleasmlib-2.0.4-1.el5.i386.rpm: header v3 dsa signature: nokey, key id 1e5e0159 preparing.# 100%1:oracleasmlib# 100%rootyygssun23 oracleasm# rpm -uvh oracleasm-2.6.18-308.el5xen-2.0.5-1.el5.x86_64.rpm warning: oracleasm-2.6.18-308.el5xen-2.0.5-1.el5.x86_64.rpm: header v3

14、dsa signature: nokey, key id 1e5e0159preparing.# 100%1:oracleasm-2.6.18-308.el# 100%rootyygssun23 oracleasm# rpm -uvh oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpm warning: oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpm: header v3 dsa signature: nokey, keyid 1e5e0159preparing.# 100%1:oracleasm-2.

15、6.18-308.el# 100%7 磁盘分区rootyygssun23 rpm# fdisk -l /dev/emcpowerldisk /dev/emcpowerl: 2147 mb, 2147483648 bytes67 heads, 62 sectors/track, 1009 cylinders units = cylinders of 4154 * 512 = 2126848 bytesdisk /dev/emcpowerl doesn”t contain a valid partition table rootyygssun23 rpm# fdisk /dev/emcpowerl

16、device contains neither a valid dos partition table, nor sun, sgi or osf disklabel building a new dos disklabel. changes will remain in memory only,until you decide to write them. after that, of course, the previous content won”t be recoverable.warning: invalid flag 0x0000 of partition table 4 will

17、be corrected by w(rite) command (m for help): ncommand actioneextendedpprimary partition (1-4)1invalid partition number for type 1”command action eextendedpprimary partition (1-4)ppartition number (1-4): 1first cylinder (1-1009, default 1):using default value 1last cylinder or +size or +sizem or +si

18、zek (1-1009, default 1009): using default value 1009command (m for help): wthe partition table has been altered!partprobelinux 使用 partprobe 不重启系统添加新的磁盘分区8 配置 asm/etc/init.d/oracleasm configure configuring the oracle asm library driver.this will configure the on-boot properties of the oracle asm libr

19、ary driver.the following questions will determine whether the driver is loaded on boot and what permissions it will have.the current values will be shown in brackets (”).hitting <enter> without typing an answer will keep that current value.ctrl-c will abort.default user to own the driver inter

20、face :oracrs default group to own the driver interface : asmadmin start oracle asm library driver on boot (y/n) n: y scan for oracle asm disks on boot (y/n) y: ywriting oracle asm library driver configuration: done initializing the oracle asmlib driver: ok scanning the system for oracle asmlib disks

21、: ok 2 个节点都执一下创建 asm 磁盘/usr/sbin/oracleasm createdisk ocr_vote01 /dev/emcpowera1/usr/sbin/oracleasm createdisk ocr_vote02 /dev/emcpowerb1/usr/sbin/oracleasm createdisk ocr_vote03 /dev/emcpowerc1/usr/sbin/oracleasm createdisk ocr_vote04 /dev/emcpowerd1/usr/sbin/oracleasm createdisk ocr_vote05 /dev/em

22、cpowere1/usr/sbin/oracleasm createdisk asmdata01 /dev/emcpowerf1/usr/sbin/oracleasm createdisk asmdata02 /dev/emcpowerg1/usr/sbin/oracleasm createdisk asmdata03 /dev/emcpowerh1/usr/sbin/oracleasm createdisk asmdata04 /dev/emcpoweri1scandisk asm 磁盘/etc/init.d/oracleasm scandisksrootyygssun23 rpm# /us

23、r/sbin/oracleasm listdisks asmdata01asmdata02 asmdata03 asmdata04 ocr_vote01 ocr_vote02ocr_vote039 安装前的检查/runcluvfy.sh stage -post hwos -n yygssun23,yygssun24 -verbose10 安装 oracle 群集软件进入到软件介质名目./runinstaller配置 sshasm 密码：oracle分别在两个脚本运行 /oracle/app/grid/product/11.2.0/root.shrootyygssun23 orainventor

24、y# /oracle/app/grid/product/11.2.0/root.sh performing root user operation for oracle 11gthe following environment variables are set as: oracle_owner= oracrsoracle_home=/oracle/app/grid/product/11.2.0enter the full pathname of the local bin directory: /usr/local/bin: copying dbhome to /usr/local/bin

25、.copying oraenv to /usr/local/bin . copying coraenv to /usr/local/bin .creating /etc/oratab file.entries will be added to the /etc/oratab file as needed by database configuration assistant when a database is created finished running generic part of root script.now product-specific root actions will

26、be performed.using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/ crsconfig_paramscreating trace directoryuser ignored prerequisites during installation installing trace file analyzerolr initialization - successful root walletroot wallet cert root cert export peer walletp

27、rofile reader wallet pa walletpeer wallet keys pa wallet keys peer cert request pa cert request peer certpa certpeer root cert tpprofile reader root cert tp pa root cert tppeer pa cert tp pa peer cert tpprofile reader pa cert tpprofile reader peer cert tp peer user certpa user certadding clusterware

28、 entries to inittabcrs-2672: attempting to start ”ora.mdnsd” on ”yygssun23” crs-2676: start of ”ora.mdnsd” on ”yygssun23” succeeded crs-2672: attempting to start ”ora.gpnpd” on ”yygssun23” crs-2676: start of ”ora.gpnpd” on ”yygssun23” succeededcrs-2672: attempting to start ”ora.cssdmonitor” on ”yygs

29、sun23” crs-2672: attempting to start ”ora.gipcd” on ”yygssun23”crs-2676: start of ”ora.cssdmonitor” on ”yygssun23” succeeded crs-2676: start of ”ora.gipcd” on ”yygssun23” succeededcrs-2672: attempting to start ”ora.cssd” on ”yygssun23” crs-2672: attempting to start ”ora.diskmon” on ”yygssun23” crs-2

30、676: start of ”ora.diskmon” on ”yygssun23” succeeded crs-2676: start of ”ora.cssd” on ”yygssun23” succeededasm created and started successfully. disk group crsdata created successfully. clscfg: -install mode specifiedsuccessfully accumulated necessary ocr keys.creating ocr keys for user ”root”, priv

31、grp ”root”. operation successful.crs-4256: updating the profilesuccessful addition of voting disk aa770940a24d4fecbf12816a904b0363. successful addition of voting disk 96fa5d68ea504fbcbfa939fd440c229e. successful addition of voting disk 4e74574f24614f19bff4e6628d6ce48f. successful addition of voting

32、disk 2e7e1c38f50d4f82bfa64c38ea26609c. successful addition of voting disk 276f746c0d794fc2bfbfc249a5d11434. successfully replaced voting disk group with +crsdata.crs-4256: updating the profilecrs-4266: voting file(s) successfully replaced#statefile universal idfile name disk group1. onlineaa770940a2

33、4d4fecbf12816a904b0363 (/dev/oracleasm/disks/ocr_vote01) crsdata2. online96fa5d68ea504fbcbfa939fd440c229e (/dev/oracleasm/disks/ocr_vote03) crsdata3. online4e74574f24614f19bff4e6628d6ce48f (/dev/oracleasm/disks/ocr_vote02) crsdata4. online2e7e1c38f50d4f82bfa64c38ea26609c (/dev/oracleasm/disks/ocr_vo

34、te04) crsdata5. online276f746c0d794fc2bfbfc249a5d11434 (/dev/oracleasm/disks/ocr_vote05) crsdatalocated 5 voting disk(s).crs-2672: attempting to start ”ora.asm” on ”yygssun23” crs-2676: start of ”ora.asm” on ”yygssun23” succeededcrs-2672: attempting to start ”ora.crsdata.dg” on ”yygssun23” crs-2676:

35、 start of ”ora.crsdata.dg” on ”yygssun23” succeeded configure oracle grid infrastructure for a cluster . succeededrootyygssun24 disks# /oracle/app/grid/product/11.2.0/root.sh performing root user operation for oracle 11gthe following environment variables are set as: oracle_owner= oracrsoracle_home=/oracle/app/grid/product/11.2.0enter the full pathname of the local bin directory: /usr/local/bin: copying dbhome to /usr/local/bin .copy