Install Oracle 11g in Oracle Enterprise Linux

Install Oracle 11g in Oracle Enterprise Linux. Prepare the server and operating system. 2. Check the redhat kernel version. [root @ redhat ~] # Uname-r 2.6.32-131.0.15.el6.i686 installation package check [root @ redhat sysconfig] # rpm-qa | grep binutils binutils-2.20.51.0.2-5.20.el6.i686 www.2cto.com binutils-devel-2.20.51.0.2-5.20.el6.i686 [root @ redhat sysconfig] # rpm-qa | grep compat- libstdc ++ compat-libstdc ++-33-3.2.3-69.el6.i686 [root @ redhat sysconfig] # rpm-qa | grep elfutils-libelf elfutils-libelf-0.152-1.el6.i686 elfutils-libelf-devel-0.152-1.el6. I 686 [root @ redhat sysconfig] # rpm-qa | grep glibc glibc-headers-2.12-1.25.el6.i686 glibc-devel-2.12-1.25.el6.i686 glibc-2.12-1.25.el6.i686 glibc-common-2.12-1.25.el6.i686 libaio-0.3.107-10.el6.i686 [root @ redhat sysconfig] # rpm-qa | grep libaio [root @ redhat sysconfig] # rpm -qa | grep libgcc libgcc-4.4.5-6.el6.i686 www.2cto.com [root @ redhat sysconfig] # rpm-qa | grep libstdc ++-4.4.5-6. el6. I686 libstdc ++-docs-4.4.5-6.el6.i686 libstdc ++-devel-4.4.5-6.el6.i686 [root @ redhat sysconfig] # rpm-qa | grep sysstat sysstat-9.0.4-18.el6.i686 [root @ redhat sysconfig] # rpm-qa | grep unixODBC unixODBC-devel-2.2.14-11.el6.i686 unixODBC-2.2.14-11.el6.i686 modify kernel parameters, run sysctl-p after modification to make the modification take effect [root @ redhat ~] # Vi/etc/sysctl. conf kernel. shmall = 268435456 kernel. shmmni = 4096 kernel. sem = 250 32000 100 128 net. ipv4.ip _ local_port_range = 1024 65000 net. core. rmem_default = 4194304. net. core. rmem_max = 4194304. net. core. wmem_default = 262144. net. core. wmem_max= 262144 fs. aio-max-nr = 1048576 fs. file-max = 6815744 create an oracle user and group [root @ redhat ~] # Groupadd oinstall [root @ redhat ~] # Groupadd dba [root @ redhat ~] # Useradd-g oinstall-G dba oracle [root @ redhat ~] # Passwd oracle Change the user's oracle password. New Password: www.2cto.com re-enter the new password: passwd: All authentication tokens have been successfully updated. Create a directory (1) Create an Oracle root directory, modify the owner of the directory, and modify the read permission [root @ redhat ~] # Mkdir-p/myoracle/app [root @ redhat ~] # Chown-R oracle: oinstall/myoracle/app [root @ redhat ~] # Chmod-R 775/myoracle/app (2) create an Oracle Home Directory, modify the owner of the directory, and modify the read permission [root @ redhat ~] # Mkdir-p/myoracle/app/product/11.2.0/db_1 [root @ redhat ~] # Chown oracle: oinstall/myoracle/app/product/11.2.0/db_1 [root @ redhat ~] # Chmod 775/myoracle/app/product/11.2.0/db_1 (3) create an Inventory directory, modify the owner of the directory, and modify the read permission [root @ redhat ~] # Mkdir-p/myoracle/oraInventory [root @ redhat ~] # Chown oracle: oinstall/myoracle/oraInventory [root @ redhat ~] # Chmod 775/myoracle/oraInventory (4) create a data file directory, modify the owner of the directory, and modify the read permission [root @ redhat ~] # Mkdir/myoracle/oradata [root @ redhat ~] # Chown oracle: oinstall/myoracle/oradata [root @ redhat ~] # Chmod 775/myoracle/oradata (5) create a flashback directory, modify the directory owner, and modify the read permission [root @ redhat ~] # Mkdir/myoracle/flash_recovery_area [root @ redhat ~] # Chown oracle: oinstall/myoracle/flash_recovery_area [root @ redhat ~] # Chmod 775/myoracle/flash_recovery_area set the environment variable for oracle users [root @ redhat ~] # Su-l oracle [oracle @ redhat ~] $ Vi. bash_profile www.2cto.com TMP =/tmp; export tmp tmpdir = $ TMP; export TMPDIR export ORACLE_BASE =/u01/oracle export ORACLE_HOME = $ ORACLE_BASE/product/OraHome export ORACLE_SID = test export ORACLE_OWNER = oracle export PATH =/usr/sbin: $ ORACLE_HOME/bin: $ PATH LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/local/lib export LD_LIBRARY_PATH CLASSPATH = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbm S/jlib CLASSPATH = $ CLASSPATH: $ ORACLE_HOME/network/jlib export CLASSPATH -- execute the following command to make the configuration take effect immediately or use oracle user login to make the configuration take effect $ source $ HOME /. bash_profile www.2cto.com set Shell Limits. in/etc/security/limits. add the following lines to the conf file: oracle soft nofile 65536 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 B. in/etc/pam. add the following lines to the d/login file: session required/lib/security/pam_limits.so session required pam _ Limits. so c. add the following statement after/etc/profile: vi/etc/profile if [$ USER = "oracle"]; then if [$ SHELL = "/bin/ksh"]; then ulimit-p 16384 ulimit-n 16384 else ulimit-u 16384-n 16384 fi www.2cto.com 3. Install the ORACLE software [root @ redhat ~] # Su-l oracle [oracle @ redhat ~] $ Cd database/[oracle @ redhat database] $./runInstaller select to install only the database software. During installation, run [root @ redhat ~] as the root user. #/Oracle/oraInventory/orainstRoot. sh [root @ redhat ~] #/Opt/oracle/product/OraHome/root. sh and then use netca and dbca to create listeners and databases. 4. Configure ORACLE11g database auto-start after installation modify the following two files:/etc/oratab and $ ORACLE_HOME/bin/dbstart [root @ redhat ~] # Vi/etc/oratab change test:/u01/oracle/product/OraHome: N to test:/u01/oracle/product/OraHome: Y www.2cto.com [root @ redhat ~] # Su-l oracle [oracle @ redhat ~] $ Cd $ ORACLE_HOME [oracle @ redhat OraHome] $ cd bin [oracle @ redhat bin] $ vi dbstart locate ORACLE_HOME_LISTNER = $1, change $1 to $ ORACLE_HOME to configure auto-start for oracle 11g [root @ redhat ~] # Vi/etc/rc. d/rc. add the following content to local: TMP =/tmp; export tmp tmpdir = $ TMP; export TMPDIR export ORACLE_BASE =/u01/oracle export ORACLE_HOME = $ ORACLE_BASE/product/OraHome export ORACLE_SID = test export ORACLE_OWNER = oracle export PATH =/usr/sbin: $ ORACLE_HOME/bin: $ PATH LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/local/lib export LD_LIBRARY_PATH CLASSPATH = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms /Jlib CLASSPATH = $ CLASSPATH: $ ORACLE_HOME/network/jlib export CLASSPATH www.2cto.com export NLS_LANG = "SIMPLIFIED restart" su oracle-c "$ ORACLE_HOME/bin/dbstart" su oracle-c "$ ORACLE_HOME/bin/emctl start dbconsole "5. Problems during installation 1. Running. in the/usr/lib/jvm/java-1.6.0/jre/lib/directory, create the following directory: fonts/fallback, copy a Chinese font to some directories and name it zysong. ttf. Install and add parameters. /runInstaller-jreLoc/usr/lib/jvm/jav A-1.6.0/jre can solve the problem of Chinese box. Run export LANG = en_US before installation to solve the installation error. 2. Copy zysong. ttf to the $ ORACLE_HOME/jdk/jre/lib/fonts/fallback directory to solve the garbled characters in the Chinese font box when running netca. 3. The error code "ORA-12532: TNS: invalid argument" is prompted when dbca is used to create the database, which is iptables does not open port 1521, in iptables, add the following entry-a input-p tcp -- dport 1521-j ACCEPT to solve the problem. Www.2cto.com 4. What is the Chinese character when running sqlplus? Set the corresponding environment variable NLS_LANG export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" and write it to The. bash_profile file in the oracle directory. 5. Unable to execute xhost in oracle on the GUI and then execute xhost +