Installing Oracle-11.2.0.4 in the CENTOS-6.4-DVD system

/** * CENTOS-6.4-DVD system installed Oracle-11.2.0.4 *------------------------------------------------------------------------ ----------------------------------------------* "Preface" * was originally installed in the centos-6.4-minimal-64bit system oracle-11.2.0.4.0-linux-x86_64, the results of a full toss two days did not install success * Always in the last step [./runinstaller] After executing the command, print the following prompt * Checking monitor:must be configured to display at least-colors * >>>could not execute auto CH Eck for display colors using Command/usr/bin/xdpyinfo. * Check If the DISPLAY variable is set. Failed <<<< * Later even if the graphical interface is installed (see http://blog.csdn.net/jadyer/article/details/18324297 in the installation method), the result is printed with this hint * So various Google, got a lot of things, one of which printed the following prompt * ls: Unable to access/usr/sbin/smartctl: No file or directory/usr/sbin/smartctl not found * Listen to a DBA said: If the smartctl can not find, you need to install Smartmontools, and then install the Cvuqdisk,smartmontools package is the Linux system CD-ROM * [[email protected] sbin]# Yum Install-y Smartmontools * [[email protected] sbin]# Cd/app * [[email protected] app]# RPM-IVH cvuqdisk-1.0.9- 1.RPM * Finally found "runcluvfy.sh" and "CVUQDISK-1.0.9-1.RP"M "Two files, install and then execute [./runinstaller] * Find or print this checking monitor:must be configured to display at least the colors hint * and then the CentOS "Id:3:initdefault:" Change to 5, start the graphical interface, in CentOS to execute [./runinstaller] (previously in Xshell operation) * result or print checking monitor:must be Configured-to-display at least-colors prompt, switch back to DVD system * Previously heard DBA said: Oracle has a lot of tools and strategies, one of which is to add a lot of small parts of the database installation restrictions * This makes it easy to install Oracle databases on Oracle's own Linux systems * But when you install different versions of Oracle on other Linux systems, you will be prompted for the missing one, and you may not have the experience to do so. *---------- ------------------------------------------------------------------------------------------------------------* "Prepare * This article describes the installation of oracle-11.2.0.4.0-linux-x86_64 in the CENTOS-6.4-DVD system inside the VirtualBox * on the installation configuration of VirtualBox and CentOS, The main point here is the download of the ORACLE-11.2.0.4.0-LINUX-X86-64 installation package * Currently the 11g version of Oracle has stopped updating and will only update the 12c version later * Because 12c just came out soon, considering the enterprise application 11g more, So this article demonstrates the installation of 11g * and the last version of 11g is 11.2.0.4.0, but we can only find 11.2.0.1.0 download * address for http://www.oracle.com/technetwork/on Oracle's website Database/enterprise-edition/downloads/index.html * is not a bit strange, don't worry, in this page will also see the following paragraph description * 7/13:patch Set 11.2.0.4 for Linux and Solaris are now available on support.oracle.com. * Note:it is a full installation (you don't need to download 11.2.0.1 first) * Translated is: can go to support.oracle.com download 11.2.0.4, and and download to the will be a complete installation package, do not need to pre-install 11.2.0.1 * have Oracle account friends can go to support.oracle.com download, no matter, I share in Baidu Network: http://pan.baidu.com/s/ 1DDPC14P * Oracle-11.2.0.4.0-linux-x86_64 installs a total of 7 files, of which 1OF7 and 2OF7 are the complete installation files of the database, we only need 1 and 2 is enough *---------------------- ------------------------------------------------------------------------------------------------* "Documentation" * Oracle provides a very detailed documentation of installation and use, as follows * http://www.oracle.com/technetwork/database/enterprise-edition/documentation/ index.html * Its online browse address is http://www.oracle.com/pls/db112/homepage * Next we look up and install about that part of the content * Click on the left "Installing and Upgrading", Then click on the HTML link to the right "Database Installation guide for Linux" * Next you will see a lot of installation instructions, here we only see "Oracle Database Preinstallation Tasks" Part is enough. *--------------------------------------------------------------------------------------------------------- -------------* @create May10:16:21 PM * @author Xuan Yu 
/** * Below is the pre-installation preparation work *----------------------------------------------------------------------------------------------- -----------------------* "Steps" * 1) Create group (OINSTALL,DBA)/USER account (Oracle)----> Create groups and Users * 2) Configure Environment variables for Oracle---------> Configure Environment Variables * 3) Check and add RPM package--------------------------> Check the RPM package required for installation * 4) Modify kernel parameter----------------------------> Modify kernel Parameters * 5) Change Oracle Limits-------------------------------> Modify shell Limits for Oracle users (can improve performance) * 6). Runinstaller-------------------------------------> Install Oracle *------------------------------------------------ ----------------------------------------------------------------------* "Create groups and users" * [[email protected] ~]#                      Groupadd Oinstall (Create a group named Oinstall, you can use a different name, just habitually use oinstall) * [[email protected] ~]# Groupadd dba (Create a group named DBA) * [[[email protected] ~]# useradd-g oinstall-g dba Oracle (Create a user named Oracle, whose primary group is Oi Nstall, whose sub-group is DBA) * [email protected] ~]# passwd Oracle (SET user Oracle login password, here is set to *) * [[email protected] ~]# chown-r ora Cle:oinstall/app (Modify/app directory owned, here/app directory is I created in advance) * [[email protected] ~]# yum install-y Unzip (Cent Os-6.4-minimal system default is no unzip package) * [[[email protected] ~]# su-oracle (switch to Oracle user) * [[Email&nbs P;protected] ~]$ cd/app/(switch to the/app directory and unzip the Oracle installation package) * [[email protected] app]# Unzip/app/soft Ware/p13390677_112040_linux-x86-64_1of7.zip * [[email protected] app]# unzip/app/software/p13390677_112040_ Linux-x86-64_2of7.zip *---------------------------------------------------------------------------------------- ------------------------------* "Configure Environment variables" * [[[email protected] ~]# hostname (view hostname, get "CentOS ") * [[[email protected] ~]# vi/etc/hosts (added" 192.168.0.103 CentOS64 "mapping in the hosts, the IP is" ifconfig "to get ) * [[email protected] ~]# vi/etc/seLinux/config (set selinux=disabled, that is, switch off the security Enhancement tool, and then the best reboot reboot) * [[email protected] ~]# su-oracle (Switch to Oracle user) * [[[email protected] ~]$ pwd (list current directory, i.e. "/home/oracle") * [email  protected] ~]$ Ls-la (-a means to show hidden files, here we will find a hidden file called ". Bash_profile") * [[email protected  ] ~]$ vi. bash_profile (Edit the. bash_profile file so that the Oracle user logs on will be executed according to this file setting) * #. Bash_profile * # Get the aliases and Functions * If [-f ~/.BASHRC]; Then *. ~/.BASHRC * fi * # User specific environment and startup programs * Oracle_base=/app * oracle_home= $ORACLE _base/oracle * O Racle_sid=xuanyu * display=192.168.0.102:0.0 * path= $ORACLE _home/bin: $PATH: $HOME/bin * ld_library_path= $ORACLE _home/ LIB: $LD _library_path * Stty Erase ^h * Export PATH ld_library_path DISPLAY oracle_base oracle_home oracle_sid *: x * [[EMA] Il protected] ~]$ cat. Bash_profile * "Part description of the environment variable" * Stty: It functions as a typo in Sqlplus and then press the BACKSPACE key back to delete, the garbled characters are not displayed. If this is not set, Ctrl+backspace * Display: It points to the IP is my win7 IP (specifically the address of the Gateway), the role is if the Linux running program has a graphical interface, then it will be displayed under Windows * Here, when installing oracle11g, you can choose to install the GUI, but my centos will read "Id:3:initdefault:" When it starts up, that is, the desktop environment is not started * all we have to use xmanager-passive to achieve the function of the graphical interface, The IP address of the display parameter above is actually pointing to the Windows system where Xmanager is installed * and will finally be displayed by launching xmanager-passive to display the Oracle's installation graphical interface * Of course, assuming that the [./runins Taller] command, start xmanager-passive under Windows (it is one of the xmanager_enterprise_4 components) *--------------------------------------- -------------------------------------------------------------------------------* "Check the RPM package required for installation" * described on the Oracle documentation, The address is http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1085 * See 2.4.3 Chapter Package Requirements, we're using a 64-bit CentOS * So look at this section. "Oracle Database Package Requirements for Linux x86-64" * Next one by one vs "Oracle Linu X 6 and Red Hat Enterprise Linux 6 The following packages ... must be installed "can * [[email protected] database]# Rpm-qa | grep binutils * And then look at the console output, I'm going to output the binutils-2.20.51.0.2.-5.36.el6.x86_64, indicating that the binutils is installed * If no output is not installed binutils (note to be found by the root user) * If not found, then the more convenient way is to execute [yum install-y binutils] Install * If the Yum mode installation is not valid, you can also download the corresponding RPM file to http://pkgs.org/and then perform the [RPM-IVH ksh-20120801-10.el6.x86_64.rpm] Command installation * Besides, If you want to use ODBC on Linux, please also pack the following packages (see "2.4.5.1 Oracle ODBC Drivers" section for descriptions) * UNIXODBC-2.2.14-11.EL6 (x86_64) or later * unixodbc-2.2.14-11.el6.i686 or later * UNIXODBC-DEVEL-2.2.14-11.EL6 (x86_64) or later * unixodbc-devel-2.2.14-11.el6.i686 or later *--------------------------------------------------------------------- -------------------------------------------------* "Modify kernel parameters" * http://docs.oracle.com/cd/E11882_01/install.112/ e47689/pre_install.htm#ladbi1188 * On the previous page of 2.13.1 chapters displaying and changing Kernel Parameter values describes the kernel parameters that need to be modified * [[email& Nbsp;protected] ~]# vi/etc/sysctl.conf (copy the following configuration to the end of the sysctl.conf file) * Fs.aio-max-nr = 1048576 * Fs.file-max = 6815744 * k Ernel.shmall = 2097152 * Kernel.shmmax = 4294967295 * Kernel.shmmni = 4096 * Kernel.sem = + 32000 * Net.Ipv4.ip_local_port_range = 9000 65500 * Net.core.rmem_default = 262144 * Net.core.rmem_max = 4194304 * Net.core.wmem_defau lt = 262144 * Net.core.wmem_max = 1048576 * [[email protected] ~]# sysctl-p * [[email protected] ~]# * In this way, the above modified The kernel parameters are in effect. We can use the Sysctl-a | grep net.core.wmem_max "Command View *----------------------------------------------------------------------------------- -----------------------------------* "Modify shell Limits for Oracle users" * http://docs.oracle.com/cd/E11882_01/install.112/ e47689/pre_install.htm#ladbi1188 * In section 2.12 of the previous page checking Resource Limits for the Oracle software installation Users describe the resource restriction parameters that need to be modified * [[email protected] oracle]# vi/etc/security/limits.conf (copy the following configuration to the end of the sysctl.conf file and save it) *    Oracle Hard nofile 65536 * Oracle Hard NPROC 16384 * Oracle Soft Nproc 2047 * Oracle Hard Stack 32768 *------------------------------------------------- ---------------------------------------------------------------------* "Install Oracle" * There are two ways to install, one is a visual installation of the graphical interface, one is a silent installation without a graphical interface * This is a demonstration of the installation of a graphical interface * First open the Xmanager-passive tool in the Xmanager_enterprise_4 component installed in the WIN7 system (it will automatically minimize to the lower right taskbar) * and execute the [./runinstaller] Command with the Oracle user ( The next xmanager-passive automatically works, and the Oracle installation interface is automatically rendered) *---------------------------------------------------------------- ------------------------------------------------------* @create May, 10:06:30 AM * @author Xuan Yu 
/** * Next describe each step in the installation interface and how to create and start a stop database *------------------------------------------------------------------------- ---------------------------------------------* "Installation Steps" * 1) Configure Security Updates * Uncheck I wish to receive Security U Pdates via My Oracle support * At this point "Next" will pop up a window you do not provided an email address, we click "Yes" on the line * 2) Download Softwar E Updates * Tick skip software udpates * 3) Installation Option * Tick install database software only * 4) Grid installation O Ptions * Tick Single Instance database installation * You cannot select RAC here because there is no way to install RAC on CentOS because Oracle will only need some special software to release RAC on its own Linux    and package * 5) Product Languages * Default 中文版 on line * 6) Database Edition * Tick Enterprise Edition (4.5GB) * 7) Installation location * Here the Oracle base and software location will automatically find the installation directory set by the environment variable setting * 8) Create Inventory * Inventory Directory Value modified to "/home/oracle/ora   Inventory "(Inventory directory refers to the profile directory of Oracle) * Orainventory Group name takes the default Oinstall on line * 9) Operating System Groups * Database Administrator (OSDBA) GRoup with the default DBA option * Database Operator (osoper) Group (Optional) also takes the default empty option on the line *) Prerequisite Checks * This step is the kernel parameter set before the check, Required packages and so on to meet Oracle's installation requirements * This step may prompt the missing "pdksh-5.2.14" package, for Pdksh, we can ignore (if the hint is missing other packages, but also take a closer look), click on the upper right corner of the Ingore all * and then will pop up a The box [ins-13016]you has chosen to ingore some of the prerequisite .... Is you sure want to continue?    * Here's the "Yes" on the line * All) Summary * This step will tell us which installation parameters are set, then click "Install" on the line (*) Install Product * This step is to start the installation, we watch it installed on the line * After a long wait, it pops up a dialog box with the following configuration scripts need to being executed as the "root" use * and will list two script paths to us/home/oracle/    Orainventory/orainstroot.sh and/app/oracle/root.sh * We go back to Xshell, log in as root, execute both scripts (execute orainstroot.sh First, then execute root.sh) * Two scripts executed, then go back to the Oracle installation interface, click "OK" in this pop-up dialog box (*) Finish * The installation of Oracle Database was successfull. * -------------------------------------------------------------------------------------------------------------- --------* "CREATE DATABASE" * 1) Create a listener * [[email protected] Oracle]$ NETCA (console will print Oracle Net Services Configuration, will automatically pop up the graphical interface later) * [[[email protected] oracle]$ Ps-ef | grep LSN (after the graphical interface creation listener is finished, you can see if the listener is started) * 2) CREATE DATABASE * [[email protected] oracle]$ dbca (This command will automatically pop up the database created by the  Graphical interface, Database Configuration Assistant, the creation process has a total of 12 steps) * 1OF12: Select Create a Database * 2of12: Select General Purpose or Transaction processing, the generic * 3OF12: The recommended input is the same as oracle_sid in the environment variables configured above, i.e. Xuanyu * 4OF12: Uncheck Configure Enterprise Manager * 5OF12: Setup Administrator Password, click "Next" when you may be prompted to set the password is not secure do you want to continue, we choose "Yes" on the line * 6of12:storage type on the default file system, Storage Locatio NS is also the default use Database File Locations the From template on line * 7OF12: Tick enable archiving (that is, set archive), and specify Fast Recovery area by default tick Optional * 8OF12: Tick the sample Schemas * 9of12:character sets tab under the Use Unicode (Al32utf8) character set, the remaining three tags will be * 10of12 by default *: Some explanatory text, direct "Nex T "on the line * 11OF12: Also according to its default check create database on the line, and then click" Finish "to start creating (this is it will pop up a summary report of the dialog box, click" OK ") * 12OF12: The next step is to see what we are familiar with to create the database interface, which is a long process and we wait for it * [email protected] oracle]$ Ps-ef | grep Ora_ (after the graphical interface has created the database, you can see if the Oracle instance is running) by this command *-------------------------------------------------------------     ---------------------------------------------------------* "Close Database" * [[email protected] oracle]$ Sqlplus/nolog (Start sqlplus) * sql> conn/as SYSDBA * Connected.                * sql> SELECT * from V$version; (View Oracle Version) * sql> shutdown immediate (Close database) * DB closed. * Database dismounted. * ORACLE instance shut down. * Sql> quit (exit sqlplus) * [[email protected] oracle]$ Ps-ef | grep Ora_ (you will find that there is no print, the database is stopped) *------------------------------------------------------------------------------ ----------------------------------------* "Start Database" * [[[email protected] oracle]$ Sqlplus/nolog (startup sqlplus) * SQL > Conn/as SYSDBA * Connected to an idle instance. * Sql> Startup (startup database) * ORACLE instance started. * TotAl System Global area 845348864 bytes * Fixed size 1367904 bytes * Variable size 549453984 b Ytes * Database buffers 289406976 bytes * Redo buffers 5120000 bytes * Database mounted. * Database opened.                                       * sql>! (Exit Sqlplus) * [[email protected] oracle]$ Ps-ef | grep Ora_ (at this point you'll find a bunch of things printed out that the database was started) *---------------------------------------------------------------------------- ------------------------------------------* @create May, 10:07:19 AM * @author Xuan Yu