Install Oracle 11g in Oracle Enterprise Linux

Source: Internet
Author: User


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 +

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.