Installing Oracle-11.2.0.4 in CentOS-6.4-DVD Systems

/*** Install Oracle-11.2.0.4 * CentOS-6.4-DVD in a CentOS-6.4-minimal-64bit system * 'was originally installed in a Oracle-11.2.0.4.0-Linux-x86_64 system, as a result, the installation was unsuccessful for two days. * The installation was always in the last step [. /runInstaller] After executing the command, print the following prompt * Checking monitor: must be configured to display at least 256 colors * >>> cocould not execute auto check for display colors using command/usr/bin/xdpyinfo. * Check if the DISPLAY variable is set. failed <* later, even if the graphical interface is installed (for the installation method, see http://blog.csdn.net/jadyer /Article/details/18324297). The result is still printed with this prompt. * Various Google products have made a lot of things. One of them has printed the following prompt * ls: inaccessible/usr/sbin/smartctl: No file or directory/usr/sbin/smartctl not found * according to a DBA: If smartctl cannot be found, install smartmontools first, then install cvuqdisk, the smartmontools package is the * [root @ CentOS64 sbin] # yum install-y smartmontools * [root @ CentOS64 sbin] # cd/app * [root @ CentOS64 app] # rpm-ivh cvuqdisk-1.0.9-1.rpm * finally found "runcluvfy. sh and cvuqdisk-1.0.9-1.rpm files, install and then execute [. /runInstaller] * check whether to print the Checking monitor: must be configured to display at least 256 colors prompt * then change CentOS's "id: 3: initdefault:" to 5, start the graphic interface and execute [. /runInstaller] (previously operated in xshell) * Whether to print the Checking monitor: must be configured to display at least 256 colors prompt, but you have to switch back to the DVD system * I heard the DBA say before: oracle has implemented many methods and strategies, one of which is to add many small part restrictions for database installation. * This allows Oracle to be installed on its own Linux system, very convenient and unobstructed * but when you install different versions of Oracle on other Linux systems, you will be prompted to lack this missing one, no experience is not necessarily set * prepare * [prepare] * This article describes the installation of CentOS-6.4-DVD in the Oracle-11.2.0.4.0-Linux-x86_64 system inside VirtualBox * The installation configuration of VirtualBox and CentOS is omitted, here we mainly talk about the download of the Oracle-11.2.0.4.0-Linux-x86-64 installation package * The current Oracle 11g version has stopped updating, later will only update 12c version * Because 12c just came out soon, considering the application of 11g is more in enterprises, this article demonstrates the installation method of 11g *, and the last version of 11g is 11.2.0.4.0, however, we can only find the download address for 11.2.0.1.0 on the Oracle official website. * http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html * Isn't it strange? Don't worry. The following section also describes * 7/13: Patch Set 11.2.0.4 for Linux and Solaris is now available on support.oracle.com. * Note: it is a full installation (you do not need to download 11.2.0.1 first) * Translation: you can download 11.2.0.4 from support.oracle.com, the downloaded package is a complete installation package, and you do not need to install 11.2.0.1 * in advance. If you have an Oracle account, you can download it from support.oracle.com, I shared it with Baidu online storage: http://pan.baidu.com/s/1dDpC14P * The Oracle-11.2.0.4.0-Linux-x86_64 installation package has a total of 7 files, of which 1of7 and 2of7 are the complete installation file of the database, here we only need 1 and 2, which is enough. * Documentation * Oracle provides a very detailed installation and usage documentation, as follows * http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html * Its online browsing address is http://www.oracle.com/pls/db112/homepage * Next let's look for the installation-related content * click "Installing and Upgrading" on the left side ", click the HTML link next to "Database Installation Guide for Linux" on the right. * You will see many Installation instructions, here we only look at the "Oracle Database Preinstallation Tasks" section, which is enough * required * @ create May 17,201 4 10:16:21 * @ author Xuan Yu < http://blog.csdn.net/jadyer > */

/*** The following is the preparation before installation. * steps * [STEP] * 1) Create group (oinstall, dba)/user account (oracle) ----> Create group and user * 2) Configure environment variables for oracle ---------> Configure environment variable * 3) Check and add RPM package ------------------------> Check the RPM package required for installation * 4) modify kernel parameter ----------------------------> Modify kernel Parameters Number * 5) Change oracle limits -------------------------------> modify shell restrictions of oracle users (improves performance) * 6 ). /runInstaller -------------------------------------> install Oracle * Users * [Create group and user] * [root @ CentOS64 ~] # Groupadd oinstall (create a group named oinstall, you can also use another name, just habitually use oinstall) * [root @ CentOS64 ~] # Groupadd dba (create a group named dba) * [root @ CentOS64 ~] # Useradd-g oinstall-G dba oracle (create a user named oracle, its main group is oinstall, and its sub group is dba) * [root @ CentOS64 ~] # Passwd oracle (set the logon password of the user oracle to 22 here) * [root @ CentOS64 ~] # Chown-R oracle: oinstall/app (which is owned by the modification/app directory. Here the/app directory is created in advance) * [root @ CentOS64 ~] # Yum install-y unzip (the unzip package does not exist by default in the CentOS-6.4-minimal System) * [root @ CentOS64 ~] # Su-oracle (switch to oracle user) * [oracle @ CentOS64 ~] $ Cd/app/(switch to the/app directory and decompress the Oracle Installation Package) * [oracle @ CentOS64 app] # unzip/app/software/p13390677_112040_Linux-x86-64_1of7.zip * [oracle @ CentOS64 app] # unzip/app/software/p13390677_112040_Linux-x86-64_2of7.zip * Environment * [configure environment variables ]*[ root @ CentOS64 ~] # Hostname (view the host name and get "CentOS64") * [root @ CentOS64 ~] # Vi/etc/hosts (Add "192.168.0.103 CentOS64" ing to hosts, which is obtained by "ifconfig") * [root @ CentOS64 ~] # Vi/etc/selinux/config (set SELINUX = disabled to disable the security enhancement tool, and then restart reboot) * [root @ CentOS64 ~] # Su-oracle (switch to oracle user) * [oracle @ CentOS64 ~] $ Pwd (list the current directory, that is, "/home/oracle") * [oracle @ CentOS64 ~] $ Ls-la (-a indicates displaying hidden files. Here we will find a hidden file named ". bash_profile") * [oracle @ CentOS64 ~] $ Vi. bash_profile (edit. bash_profile file, so that the oracle user will follow the settings in this file when logging on )*#. 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 * ORACLE_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 * [oracle @ CentOS64 ~] $ Cat. bash_profile * [environment variable description] * stty: it is used to prevent garbled characters when an error character is entered in sqlplus and then deleted by pressing the Backspace key. if this parameter is not set, Ctrl + Backspace * DISPLAY: the IP address to which it points is my win7 IP address (the gateway address ), if a program running in Linux has a graphical interface, it will be displayed in Windows * here, you can select a graphical interface for installation when installing Oracle11g, however, when my CentOS is started, it reads "id: 3: initdefault:", that is, it is not started in the desktop environment * all functions of the graphic interface should be implemented through Xmanager-Passive, the IP address of the preceding DISPLAY parameter is actually directed to the Windows system where Xmanager is installed *. At last, Xmanager-Passive is started to DISPLAY the Oracle Installation graphical interface * The prerequisite is to execute [. /runInstaller] before running the command, start Xmanager-Passive in Windows (it is one of the Xmanager_Enterprise_4 components) * manual * [Check the RPM package required for installation] * The Oracle documentation has descriptions, the address is http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1085 * For details, see section 2.4.3 Package Requirements, here we use 64-bit CentOS * So look at this section on the line "Oracle Database Package Requirements for Linux x86-64" * next to a one-to-one comparison "Oracle Linux 6 and Red Hat Enterprise linux 6 The following packages ..... must be installed "can * [root @ CentOS64 database] # rpm-qa | grep binutils * And then view the console output on the line, I output here is the binutils-2.20.51.0.2-5.36.el6.x86_64, indicates that binutils has been installed * if no output is available, it indicates that binutils has not been installed (Be sure to search by the root user) * if not found, you can run [yum install-y binutils] to install the tool. * If the yum installation method is invalid, you can go http://pkgs.org/ Download the corresponding rpm file, and then run the [rpm-ivh ksh-20120801-10.el6.x86_64.rpm] command to install * In addition, If You Want To Use ODBC on linux, then also install the following packages (see "2.4.5.1 Oracle ODBC Drivers" Chapter description) * 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 * parameters * [modify kernel parameters ]* http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1188 * In section 2.13.1 of the previous page, Displaying and Changing Kernel Parameter Values describes the Kernel parameters to be modified. * [root @ CentOS64 ~] # Vi/etc/sysctl. conf (copy the following configuration to sysctl. at the end of the conf file) * fs. aio-max-nr = 1048576 * fs. file-max = 6815744 * kernel. shmall = 2097152 * kernel. shmmax = 4294967295 * kernel. shmmni = 4096 * kernel. sem = 250 32000 100 128 * net. ipv4.ip _ local_port_range = 9000 65500 * net. core. rmem_default = 262144 * net. core. rmem_max = 4194304 * net. core. wmem_default = 262144 * net. core. wmem_max = 1048576 * [root @ CentOS64 ~] # Sysctl-p * [root @ CentOS64 ~] # * In this way, the Kernel Parameter modified above takes effect. we can use "sysctl-a | grep net. core. run the "wmem_max" command to view * limits * [modify shell restrictions of oracle users ]* http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1188 * In Chapter 2.12 of the previous page, Checking Resource Limits for the Oracle Software Installation Users describes the Resource Restriction parameters to be modified * [root @ CentOS64 oracle] # vi/etc/security/limits. conf (copy the following configuration to sysctl. at the end of the conf file, save it) * oracle hard nofile 65536 * oracle hard nproc 16384 * oracle soft nproc 2047 * oracle hard stack 32768 * plugin * [install Oracle] * can be installed in either of the following ways, one is visual installation with a graphical interface, one is Silent Installation Without graphic interfaces * The installation with graphical interfaces * First, open the Xmanager-Passive tool in the Xmanager_Enterprise_4 component installed in Win7 (it will automatically be minimized to the taskbar in the lower right corner) * Then run [. /runInstaller] command (next, Xmanager-Passive automatically takes effect, and the Oracle Installation interface is automatically displayed) * optional * @ create May 18,201 4 10:06:30 AM * @ author Xuan Yu < http://blog.csdn.net/jadyer > */

/*** Next we will describe the steps in the installation interface, and how to create and start and stop the database. * ---------------------------------------------------------------------------------------------------------------------- * [installation steps] * 1) configure Security Updates * uncheck I wish to receive security Updates via My Oracle Support * at this point, "Next" will pop up a window You have not provided an email address, click "Yes". * 2) Download Software Updates * Check Skip software udpates * 3) Install Ation Option * Check Install database software only * 4) Grid Installation Options * Check Single instance database installation *. RAC cannot be selected here, because RAC cannot be installed on CentOS, this is because Oracle will only release some special software and packages required for RAC in its own Linux. * 5) the default English version of Product editions * 6) database Edition * Check Enterprise Edition (4.5 GB) * 7) Installation Location * Here Oracle Base and Software Location will automatically find the Installation directory set for the previously set environment variables * 8) create Inventory * Inventory Direct Modify the ory value to "/home/oracle/oraInventory" (Inventory Directory refers to the configuration file Directory of Oracle) * oraInventory Group Name should use the default oinstall * 9) operating System Groups * Database Administrator (OSDBA) Group uses the default dba option. * Database Operator (OSOPER) Group (Optional) also uses the default null option. * 10) prerequisite Checks * this step is to check whether the previously set kernel parameters, the required packages, and so on Meet Oracle Installation Requirements * this step may prompt the lack of a "pdksh-5.2.14" package, for pdksh, we can ignore it (if it prompts that other packages are missing, please take a closer look) and click Ingore All * in the upper right corner * Then a dialog box [INS-13016] You have chosen to ingore some of the prerequisite... Are you sure you want to continue? * Click "Yes" here. * 11) the "Summary *" step will tell us which installation parameters have been set, and click "Install". * 12) install Product * this step is to start the installation. We can just watch it Install * after a long wait, it will pop up a dialog box The following configuration scripts need to be executed as the "root" use * and will list two script paths for US/home/oracle/oraInventory/orainstRoot. sh and/app/oracle/root. sh * Let's go back to Xshell and log on as the root user. Execute these two scripts respectively (first execute orainstRoot. sh, and then run root. sh) * after The two scripts are executed, go back to The Oracle Installation page and click "OK" in The displayed dialog box. * 13) Finish * Installation of Oracle Database was successfull. * optional * [Create Database] * 1) create a Listener * [oracle @ CentOS64 oracle] $ netca (the console prints the Oracle Net Services Configuration, and the graphic interface will pop up later) * [oracle @ CentOS64 oracle] $ ps-ef | grep lsn (after the Listener is created on the GUI, you can use this command to check whether the Listener is enabled) * 2) create a database * [oracle @ Cen TOS64 oracle] $ dbca (this command automatically pops up the graphic interface for creating a Database, Database Configuration Assistant, which consists of 12 steps) * 1of12: Select Create a Database * 2of12: select General Purpose or Transaction Processing, that is, General * 3of12. We recommend that you enter the same ORACLE_SID as the environment variable configured above, that is, xuanyu * 4of12: deselect Configure Enterprise Manager * 5of12: set the administrator password. When you click "Next", a prompt will pop up indicating that the password you set is not secure. Do you want to continue. Select "Yes". * 6of12: storage Type is the default File System, and Storage Locations are also the default Use D Atabase File Locations from Template: * 7of12: Check Enable Archiving (set Archiving). In addition, Specify Fast Recovery Area is selected by default. * 8of12: select Sample Schemas * 9of12: under the Character Sets tab, select the Use Unicode (AL32UTF8) Character Set. The other three labels are set to * 10of12 by default. For some instructions, just click "Next". * 11of12: you can also select "Create Database" by default, and then click "Finish" to start creation. (This will bring up a summary report dialog box and click "OK".) * 12of12: next we will see the familiar interface for creating databases. This process is a long one. We will wait for you to * [oracle @ CentOS64 oracle] $ ps-ef | grep o Ra _ (after creating a database, you can run this command to check whether the Oracle instance is running) * shut down * [close database] * [oracle @ CentOS64 oracle] $ sqlplus/nolog (start SQLPLUS) * SQL> conn/as sysdba * Connected. * SQL> SELECT * FROM v $ version; (view Oracle version) * SQL> shutdown immediate (close Database) * Database closed. * Database dismounted. * ORACLE ins Tance shut down. * SQL> quit (exit SQLPLUS) * [oracle @ CentOS64 oracle] $ ps-ef | grep ora _ (if no printing is found, the database is stopped) * ---------------------------------------------------------------------------------------------------------------------- * [start database] * [oracle @ CentOS64 oracle] $ sqlplus/nolog (start SQLPLUS) * SQL> conn/as sysdba * Connected to an idle instance. * SQL> startup (start database) * ORACLE instance start Ed. * Total System Global Area 845348864 bytes * Fixed Size 1367904 bytes * Variable Size 549453984 bytes * Database Buffers 289406976 bytes * Redo Buffers 5120000 bytes * Database mounted. * Database opened. * SQL>! (Exit SQLPLUS) * [oracle @ CentOS64 oracle] $ ps-ef | grep ora _ (when a lot of things are printed, it indicates that the database is started) * required * @ create May 18,201 4 10:07:19 AM * @ author Xuan Yu < http://blog.csdn.net/jadyer > */