Oracle Linux 6.3 Installs Oracle 11g R2 (11.2.0.3)

This article mainly describes the installation of Oracle 11gR2 (11.2.0.3) under Oracle Linux 6.3. Starting from Oracle 11g, the official website of Oracle no longer provides a download link for its patch, and requires a Meatlink account to download. Don't worry about children's shoes, if you do n’t have a Metalink account, you can do it yourself. Oracle 11.2.0.3 is integrated into 7 zip archives. If you just install Oracle Database, you can download 1 to 2.zip packages. Here are the installation steps.

 

First, prepare the installation environment
1.Install rpm package and modify kernel parameters
  In order to simplify package installation and kernel parameter setting, please refer to: Using yum to quickly deploy Oracle installation environment (11g)
 

2, modify the host file
[[email protected] ~] # cat / etc / hosts | grep -v \ #
127.0.0.1 localhost.ycdata.net localhost
192.168.7.28 oel63.ycdata.net oel63

 

3.Create the corresponding directory
[[email protected] ~] # mkdir -p / u01 / ora11g / db_1
[[email protected] ~] # chown -R oracle: oinstall / u01
[[email protected] ~] # chmod -R 775 / u01

 

4. Prepare to install source files
[[email protected] 11g_src] # pwd
/ usr / local / src / 11g_src
[[email protected] 11g_src] # ls
p10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip
[[email protected] 11g_src] # unzip p10404530_112030_Linux-x86-64_1of7.zip
[[email protected] 11g_src] # unzip p10404530_112030_Linux-x86-64_2of7.zip

 

5.Modify the 90-nproc.conf configuration file
#Modified Blog: http://blog.csdn.net/leshami
[[email protected] ~] # more /etc/security/limits.d/90-nproc.conf | grep -v \ #
* soft nproc 1024

#Modified Auhtor: Leshami
[[email protected] ~] # more /etc/security/limits.d/90-nproc.conf | grep -v \ #
*-nproc 16384

 

Edit the oracle .bash_profile file
[[email protected] ~] # su-oracle
[[email protected] ~] $ vi ~ / .bash_profile

# Add below item for Oracle Settings
TMP = / tmp; export TMP
TMPDIR = $ TMP; export TMPDIR

ORACLE_HOSTNAME = oel63.ycdata.net; export ORACLE_HOSTNAME
ORACLE_UNQNAME = ora11g; export ORACLE_UNQNAME
ORACLE_BASE = / u01 / ora11g; export ORACLE_BASE
ORACLE_HOME = $ ORACLE_BASE / db_1; export ORACLE_HOME
ORACLE_SID = ora11g; export ORACLE_SID

PATH = / usr / sbin: $ PATH; export PATH
PATH = $ ORACLE_HOME / bin: $ PATH; export PATH

LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib; export LD_LIBRARY_PATH
CLASSPATH = $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib; export CLASSPATH
[[email protected] ~] $. ~ / .bash_profile
#The creation of the Oracle user has been completed through yum install oracle-rdbms-server-11gR2-preinstall
#But not completely, if you need asmadmin, asmdba and other groups, you need to create them separately

 

Install Oracle 11g R2
[[email protected] ~] $ export DISPLAY = 192.168.7.133: 0.0 #If you do not use the Xmanger tool, use xhost + directly
[[email protected] ~] $ / usr / local / src / 11g_src / database / runInstaller
Starting Oracle Universal Installer ...

1. Configure Security Updates if there is no MOS account or whether to skip the MOS account input as required
2.Select Skip software updates
3. Select Install Option, select Install database software only to speed up the installation progress
4.Select Single instance database installation
5. Language selection. The default is English. You can choose Simplied Chinese as required.
6.Select Enterprise Edition
7, installation location and path selection
  Oracle Base: / u01 / ora11g
  Software Location: / u01 / ora11g / db_1
8.Inventory Directory: / u01 / oraInventory oraInventory Group Name: oinstall
9.Select OSDBA group: dba OSOPER Group (Optional): Can be left as NULL
10.Prerequisite Checks
11.Summary
12, Install product, click Install
13.Execute the script
[[email protected] ~] # /u01/oraInventory/orainstRoot.sh
[[email protected] ~] # /u01/ora11g/db_1/root.sh

Click Ok and click Close to complete the installation.

 

Third, create a database
[[email protected] ~] $ export DISPLAY = 192.168.7.133: 0.0
[[email protected] ~] $ dbca
1.Select create a database;
2. Select the type of DB creation according to your needs. Here you choose General purpose or transaction processing.
3.Global database name: ora11g.ycdata.net SID: ora11g
4.Select whether you need Configure Enterprise Manager and select automatic maintentance tasks according to your needs
5. Security: Choice here: Use the Same Administrative Password for All Accounts and enter the password
6. Storage type: Because ASM is not configured, here is File System, the storage location is selected as: Use database File Locations from Template.
7. Specify flashback area and archive. It is recommended to check all. Whether to install Sample schemas is recommended.
8, Memory and character set settings, adjust as needed
9, click Next, adjust the database file, control file and log file location as required
10.Click Finish to start creating the database
11. After the creation is successful, relevant prompt information will be given, such as the data name, the location of the spfile, the OEM path port number, etc.
12, verification results
[[email protected] ~] $ sqlplus / as sysdba
SQL> select * from v $ version where rownum <2;

BANNER
-------------------------------------------------- ------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

SQL> select open_mode from v $ database;

OPEN_MODE
--------------------
READ WRITE

 

   

More references

Please refer to Oracle RAC
     Use crs_setperm to modify the owner and permissions of RAC resources
     Use crs_profile to manage RAC resource profiles
     RAC database startup and shutdown
     Besides Oracle RAC services
     Services in Oracle Database 10g
     Migrate datbase from single instance to Oracle RAC
     Oracle RAC connected to the specified instance
     Oracle RAC load balancing test (combining server and client)
     Oracle RAC server-side connection load balancing
     Oracle RAC Client Connection Load Balance
     ORACLE RAC non-default port listening configuration (listener.ora tnsnames.ora)
     ORACLE RAC listening configuration (listener.ora tnsnames.ora)
     Configure RAC load balancing and failover
     CRS-1006, CRS-0215 An example of failure
     Install Oracle 10g RAC on Linux (RHEL 5.5)
     Use runcluvfy to verify the Oracle RAC installation environment

For basic and conceptual issues related to Oracle network configuration, please refer to:
     Configure non-default port for dynamic service registration
     Configure sqlnet.ora to restrict IP access to Oracle
     Oracle Listener Log Configuration and Management
     Setting Oracle Listener Password (LISTENER)
     Configure the ORACLE client to connect to the database

For user management-based backup and backup recovery concepts, please refer to
     Oracle cold backup
     Oracle Hot Backup
     Oracle backup and recovery concepts
     Oracle instance recovery
     Oracle User-Managed Recovery Processing
     SYSTEM table space management and backup and recovery
     SYSAUX table space management and recovery
     Oracle backup control file based restore (unsing backup controlfile)

Please refer to RMAN for backup recovery and management
     RMAN overview and its architecture
     RMAN configuration, monitoring and management
     Detailed RMAN backup
     RMAN restore and recovery
     RMAN catalog Creation and use
      Create RMAN storage script based on catalog
      Catalog-based RMAN backup and recovery
      RMAN backup path confused
      Realizing heterogeneous backup and recovery using RMAN (WIN platform)
      Use RMAN to migrate file system database to ASM
      RMAN backup shell script under linux
      Use RMAN to migrate the database to a different machine

Please refer to ORACLE architecture
      Oracle table spaces and data files
      Oracle password file
      Oracle parameter file
      Oracle online redo log file (ONLINE LOG FILE)
      Oracle Control File (CONTROLFILE)
      Oracle Archive Log
      Oracle rollback (ROLLBACK) and undo (UNDO)
      Oracle database instance start shutdown process
      Oracle 10g SGA Automation Management
      Oracle instance and Oracle database (Oracle architecture)