Install Oracle 11g R2 (11.2.0.3) in Oracle Linux 6.3)

This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not worry about the kids shoes. If you do not have a Metalink account, you can Baidu. There are many download links on the Internet, so Thunder can do it. Oracle 11.2.0.3 is integrated into seven zip packages. If you only install Oracle database, download 1 to 2.zip packages. The installation steps are as follows.

 

1. Prepare the installation environment
1. Install the rpm package and modify Kernel Parameters
For more information about how to simplify package installation and Kernel Parameter settings, see: Using yum to quickly deploy the Oracle installation environment (11 GB)
 

2. Modify the host file
[Root @ oel63 ~] # Cat/etc/hosts | grep-v \#
127.0.0.1 localhost.ycdata.net localhost
192.168.7.28 oel63.ycdata.net oel63

 

3. Create a directory
[Root @ oel63 ~] # Mkdir-p/u01/ora11g/db_1
[Root @ oel63 ~] # Chown-R oracle: oinstall/u01
[Root @ oel63 ~] # Chmod-R 775/u01

 

4. Prepare the installation source file
[Root @ oel63 11g_src] # pwd
/Usr/local/src/11g_src
[Root @ oel63 11g_src] # ls
P10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip
[Root @ oel63 11g_src] # unzip p10404530_112030_Linux-x86-64_1of7.zip
[Root @ oel63 11g_src] # unzip p10404530_112030_Linux-x86-64_2of7.zip

 

5. Modify the 90-nproc.conf configuration file.
# Pre-modified Blog: http://blog.csdn.net/leshami
[Root @ oel63 ~] # More/etc/security/limits. d/90-nproc.conf | grep-v \#
* Soft nproc 1024

# Modified Auhtor: Leshami
[Root @ oel63 ~] # More/etc/security/limits. d/90-nproc.conf | grep-v \#
*-Nproc 16384

 

6. Edit the oracle. bash_profile File
[Root @ oel63 ~] # Su-oracle
[Oracle @ oel63 ~] $ 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:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH = $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib; export CLASSPATH
[Oracle @ oel63 ~] $ .~ /. Bash_profile
# Oracle user creation has been completed in yum install oracle-rdbms-server-11gR2-preinstall Mode
# But not completely. If you need asmadmin, asmdba, and other groups, you must create them separately.

 

Ii. Install Oracle 11g R2
[Oracle @ oel63 ~] $ Export DISPLAY = 192.168.7.20.: 0.0 # Use xhost + directly if Xmanger is not used
[Oracle @ oel63 ~] $/Usr/local/src/11g_src/database/runInstaller
Starting Oracle Universal Installer...

1. If Configure Security Updates does not have an MOS account or does it skip the input of the MOS account as needed
2. Select Skip software updates.
3. Select Install Option and Select Install database software only to speed up the installation process.
4. Select Single instance database installation.
5. language selection. The default value is English. You can select Simplied Chinese as needed.
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 Group Name: oinstall
9. Select OSDBA group: dba OSOPER Group (Optional): Can be retained as NULL
10. Prerequisite Checks
11. Summary
12. Install product, and click Install
13. Execute the script
[Root @ oel63 ~] #/U01/oraInventory/orainstRoot. sh
[Root @ oel63 ~] #/U01/ora11g/db_1/root. sh

Click OK and click Close to complete the installation.

 

3. Create a database
[Oracle @ oel63 ~] $ Export DISPLAY = 192.168.7.20.: 0.0
[Oracle @ oel63 ~] $ Dbca
1. Select create a database;
2. Select the database creation type as needed. Select General purpose or transaction processing here.
3. Global database name: ora11g.ycdata.net SID: ora11g
4. Select Configure Enterprise Manager as needed and select automatic maintentance tasks
5. Security: Select Use the Same Administrative Password for All Accounts and enter the Password.
6. Storage Type: Because ASM is not configured, File System is used here, and the storage location is: Use database File Locations from Template.
7. Specify the flash back area and archive. We recommend that you check all and whether to install Sample schemas. We recommend that you select
8. modify Memory and Character Set settings as needed.
9. Click Next to adjust the database file as needed and control the file and Log File Location
10. Click Finish to create a database.
11. After the creation is successful, relevant prompts are displayed, such as the data name, spfile location, and OEM path port number.
12. Verification results
[Oracle @ oel63 ~] $ 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

For more information about Oracle RAC, see
Use crs_setperm to modify the resource owner and permissions of RAC.
Use crs_profile to manage RAC resource configuration files
RAC database startup and Shutdown
Oracle RAC services
Services in Oracle Database 10g
Migrate datbase from single instance to Oracle RAC
Connect Oracle RAC to a specified instance
Oracle RAC load balancing test (combined with server and client)
Oracle RAC server connection Load Balance)
Load Balance)
Non-Default port listening configuration in oracle rac (listener. ora tnsnames. ora)
Oracle rac listener Configuration (listener. ora tnsnames. ora)
Configure RAC load balancing and Failover
CRS-1006, CRS-0215 fault case
Installing Oracle 10g RAC Based on Linux (RHEL 5.5)
Use runcluvfy to verify the Oracle RAC installation environment

For more information about the basics and concepts of Oracle network configuration, see:
Configure dynamic service registration for non-default ports
Configure sqlnet. ora to restrict IP Access to Oracle
Configure and manage Oracle listener logs
Set the Oracle LISTENER password (LISTENER)
Configure the ORACLE client to connect to the database

For more information about user-managed backup and recovery, see
Oracle cold backup
Oracle Hot Backup
Concept of Oracle backup recovery
Oracle instance recovery
Oracle recovery based on user management
SYSTEM tablespace management and Backup Recovery
SYSAUX tablespace management and recovery
Oracle backup control file recovery (unsing backup controlfile)

For information on RMAN backup recovery and management, see
RMAN overview and architecture
RMAN configuration, Monitoring and Management
Detailed description of RMAN backup
RMAN restoration and recovery
Create and use RMAN catalog
Create RMAN storage script based on catalog
Catalog-based RMAN backup and recovery
RMAN backup path confusion
Use RMAN for recovery from different machine backups (WIN platform)
Use RMAN to migrate a file system database to ASM
Linux RMAN backup shell script
Use RMAN to migrate the database to a different machine

For the ORACLE architecture, see
Oracle tablespace and data files
Oracle Password File
Oracle parameter file
Oracle ONLINE redo LOG FILE)
Oracle Control File)
Oracle archiving logs
Oracle ROLLBACK and UNDO)
Oracle database instance startup and Shutdown Process
Automated Management of Oracle 10g SGA
Oracle instances and Oracle databases (Oracle Architecture)