Configure ASM on Oracle 11.2.0.3

The role, benefits, and disadvantages of ASM storage are not described here. There are many documents related to google! This article mainly records how to use the ASM storage in Oracle 11.2.0.3! Related software packages can be found inHttp://support.oracle.comDownload the patches on the website. You only need to download the first three patches in 11.2.0.3. In 10g, ASM is included in the database software package, within 11g, you need to install grid infrastructure separately to use ASM. Generally, we recommend that you create a grid user to manage the ASM instance! Before starting, install the required software package, adjust the kernel parameters, as well as the maximum number of processes and file handles opened by the grid and oracle users, for more information about this configuration, see oracle 11g online document.
 
1. Create users and related directories and set the user's environment variables and Directory Permissions

[Root @ dg63 ~] # Groupadd-g 501 oinstall [Root @ dg63 ~] # Groupadd-g 502 dba [Root @ dg63 ~] # Groupadd-g 503 running [Root @ dg63 ~] # Groupadd-g 504 asmadmin [Root @ dg63 ~] # Groupadd-g 506 asmdba [Root @ dg63 ~] # Groupadd-g 507 asmoper [Root @ dg63 ~] # Useradd-u 501-g oinstall-G asmadmin, asmdba, asmoper grid [Root @ dg63 ~] # Useradd-u 502-g oinstall-G dba, asmdba, external oracle [Root @ dg63 ~] # Mkdir-p/u01/app/11.2.0/grid [Root @ dg63 ~] # Mkdir-p/u01/app/oracle/product/11.2.0/db_1 [Root @ dg63 ~] # Mkdir-p/u01/app/grid [Root @ dg63 ~] # Mkdir-p/u01/app/oraInventory [Root @ dg63 ~] # Chown-R oracle. oinstall/u01 [Root @ dg63 ~] # Chown-R grid. oinstall/u01/app/11.2.0/grid/ [Root @ dg63 ~] # Chown-R grid. oinstall/u01/app/grid/ [Root @ dg63 ~] # Chown-R grid. oinstall/u01/app/oraInventory/ [Root @ dg63 ~] # Echo oracle | passwd -- stdin oracle Changing password for user oracle. Passwd: all authentication tokens updated successfully. [Root @ dg63 ~] # Echo oracle | passwd -- stdin grid Changing password for user grid. Passwd: all authentication tokens updated successfully. [Root @ dg63 ~] # Id oracle Uid = 502 (oracle) gid = 501 (oinstall) groups = 501 (oinstall), 502 (dba), 503 (region), 506 (asmdba) [Root @ dg63 ~] # Id grid Uid = 501 (grid) gid = 501 (oinstall) groups = 501 (oinstall), 504 (asmadmin), 506 (asmdba), 507 (asmoper) [Root @ dg63 ~] # Cat/home/grid/. bash_profile #. Bash_profile # Get the aliases and functions If [-f ~ /. Bashrc]; then .~ /. Bashrc Fi # User specific environment and startup programs PATH = $ PATH: $ HOME/bin Export PATH Export ORACLE_SID = + ASM Export ORACLE_BASE =/u01/app/grid Export ORACLE_HOME =/u01/app/11.2.0/grid Export ORACLE_TERM = xterm Export NLS_DATE_FORMAT = "DD-MON-YYYY HH24: MI: SS" Export TNS_ADMIN = $ ORACLE_HOME/network/admi Export PATH =.:/usr/sbin: $ ORACLE_HOME/bin: $ ORACLE_HOME/jdk/bin: $ PATH Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/X11R6/lib: $ LD_LIBRARY_PATH Export CLASSPATH = $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib: $ CLASSPATH Export NLS_LANG = "american_america.AL32UTF8" Export EDITOD = vim Export LANG = en_us.UTF-8 Export NLS_DATE_FORMAT = yyyy-mm-dd: hh24: mi: ss Export TEMP =/tmp Export TMPDIR =/tmp Umask 022 Alias sqlplus = '/usr/local/rlwrap/bin/rlwrap sqlplus' Alias rman = '/usr/local/rlwrap/bin/rlwrap rman' [Root @ dg63 ~] # Cat/home/oracle/. bash_profile #. Bash_profile # Get the aliases and functions If [-f ~ /. Bashrc]; then .~ /. Bashrc Fi # User specific environment and startup programs PATH = $ PATH: $ HOME/bin Export PATH Export ORACLE_SID = dg63 Export ORACLE_BASE =/u01/app/oracle Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1 Export ORACLE_TERM = xterm Export NLS_DATE_FORMAT = "DD-MON-YYYY HH24: MI: SS" Export TNS_ADMIN = $ ORACLE_HOME/network/admi Export PATH =.:/usr/sbin: $ ORACLE_HOME/bin: $ ORACLE_HOME/jdk/bin: $ PATH Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/X11R6/lib: $ LD_LIBRARY_PATH Export CLASSPATH = $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib: $ CLASSPATH Export NLS_LANG = "american_america.AL32UTF8" Export EDITOD = vim Export LANG = en_us.UTF-8 Export NLS_DATE_FORMAT = yyyy-mm-dd: hh24: mi: ss Export TEMP =/tmp Export TMPDIR =/tmp Umask 022 Alias sqlplus = '/usr/local/rlwrap/bin/rlwrap sqlplus' Alias rman = '/usr/local/rlwrap/bin/rlwrap rman'

 

1 2 3 Next Page