Use asm for a single Oracle 11g instance and test the migration of data files to other disk groups

Oracle 11G Single Instance uses asm, and test the migration of data files to other disk groups 1. configure/etc/hosts network vi/etc/hosts192.168.1.181 asm asm.oracle.com 1. disable FIREWALL 2. disable SElinux vi/etc/selinux/config => SELINUX = disabled 2. create a user and group groupadd-g 5000 asmadmingroupadd-g 5001 asmdbagroupadd-g 5002 asmopergroupadd-g 6000 oinstallgroupadd-g 6001 dbagroupadd-g 6002 login useradd-g oinstall-G asmadmin, asmdba, asmoper grid useradd-g oinstall-G dba, Asmdba oracle passwd grid mkdir/s01mkdir/g01 chown oracle: oinstall/s01 chown grid: oinstall/g01 III. install the required ORACLE package 1. configure YUM [root @ vmac6 ~] # Cd/etc/yum. repos. d [root @ vmac6 yum. repos. d] # mv public-yum-ol6.repo public-yum-ol6.repo.bak [root @ vmac6 yum. repos. d] # touch public-yum-ol6.repo [root @ vmac6 yum. repos. d] # vi public-yum-ol6.repo [oel6] name = Enterprise Linux 6.3 DVDbaseurl = file:///media/ "OL6.3 x86_64 Disc 1 20120626"/Servergpgcheck = 0 enabled = 1 2. Install the oracle package [root @ vmac1 ~] # Yum install oracle-rdbms-server-11gR2-preinstall-1.0-6.el6 3. add the grid parameter. When installing the installation package, oracle automatically adds vi/etc/security/limits. conf # grid-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024 grid soft nofile 1024 # grid-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536 grid hard nofile 65536 # grid-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047 grid soft nproc 2047 # grid-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384 grid hard nproc 16384 # grid-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240 KBgrid soft stack 10240 # grid-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768 KBgrid hard stack 32768 3. installation graphical interface: yum install xterm 5. configure shared storage for I in B c; doecho "KERNEL = \" sd * \ ", BUS = \" scsi \", PROGRAM = \ "/sbin/scsi_id -- whitelisted -- replace-whitespace -- device =/dev/\ $ name \", RESULT = \ "'/sbin/scsi_id -- whitelisted -- replace-whitespace -- device =/dev/sd $ I '\", NAME = \ "asm-disk $ I \", OWNER = \ "grid \", GROUP = \ "asmadmin \", MODE = \ "0660 \" ">/etc/udev/rules. d/99-oracle-asmdevices.rulesdone/sbin/start_udev cd/dev ll asm * 6. configure the grid user profile to decompress grip unzip-d grid_11r mkdir/g01/orabase export GRID_HOME =/g01/11.2.0/gridexport ORACLE_HOME =/g01/11.2.0/gridexport PATH = $ GRID_HOME/bin: $ GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin export ORACLE_SID = + ASMexport LD_LIBRARY_PATH = $ GRID_HOME/lib: $ GRID_HOME/lib32 export ORACLE_BASE =/g01/orabaseexport ORA_NLS10 = $ ORACLE_HOME/nls/dataexport NLS_LANG = "Simplified Chinese" _ China. AL32UTF8 root environment variable export GRID_HOME =/g01/11.2.0/gridexport ORACLE_HOME =/g01/11.2.0/gridexport PATH = $ GRID_HOME/bin: $ GRID_HOME/OPatch:/sbin: /bin:/usr/sbin: /usr/bin can be directly installed. No problem. The oracle user's environmental variable mkdir/s01/orabase export ORACLE_HOME =/s01/oracle/app/oracle/product/11.2.0/dbhome_1export PATH = $ ORACLE_HOME/bin: $ ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin export ORACLE_SID = SANSOMexport LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ ORACLE_HOME/lib32 export ORACLE_BASE =/s01/orabaseexport ORA_NLS10 = $ ORACLE_HOME/nls/dataexport NLS_LANG = "Simplified Chinese" _ China. AL32UTF8