操作規範（三）——Linux 5.4安裝Oracle 11gR1（2）

本文PDF版下載 http://www.itpub.net/viewthread.php?tid=1440726&extra=page%3D1&frombbs=1

作者：xunzhao【轉載時請以超連結形式標明文章出處和作者資訊】

連結：http://xunzhaoxz.itpub.net/post/40016/518534

操作規範（三）——Linux 5.4安裝Oracle 11gR1 （1）

[@more@]

3. 安裝並配置Oracle 11gR1

3.1. 開始安裝oracle 11.1.0.6.0

[oracle@ora11g database]$./runInstaller

預設情況下，Oracle 11gR1 INVENTORY_LOCATION預設路徑為/oraInventory，安裝程式會檢查這個路徑是否存在、屬主、許可權等，這裡我一般統一設定為/oracle/oraInventory，點選OK進入下一步進行修改。

截圖請見附件PDF文件

Checking operating system requirements ...

Expected result: One of enterprise-4,enterprise-5,redhat-4,redhat-5,SuSE-10,asianux-2,asianux-3

Actual Result: redhat-4

Check complete. The overall result of this check is: Passed

========================================================

Checking operating system package requirements ...

Checking for make-3.80; found make-1:3.81-3.el5-i386. Passed

Checking for binutils-2.15.92.0.2; found binutils-2.17.50.0.6-12.el5-i386. Passed

Checking for gcc-3.4.5; found gcc-4.1.2-46.el5-i386. Passed

Checking for libaio-0.3.105; found libaio-0.3.106-3.2-i386. Passed

Checking for libaio-devel-0.3.105; found libaio-devel-0.3.106-3.2-i386. Passed

Checking for libstdc++-3.4.5; found libstdc++-4.1.2-46.el5-i386. Passed

Checking for elfutils-libelf-devel-0.97; found elfutils-libelf-devel-0.137-3.el5-i386. Passed

Checking for sysstat-5.0.5; found sysstat-7.0.2-3.el5-i386. Passed

Checking for libgcc-3.4.5; found libgcc-4.1.2-46.el5-i386. Passed

Checking for libstdc++-devel-3.4.5; found libstdc++-devel-4.1.2-46.el5-i386. Passed

Checking for unixODBC-2.2.11; found unixODBC-2.2.11-7.1-i386. Passed

Checking for unixODBC-devel-2.2.11; found unixODBC-devel-2.2.11-7.1-i386. Passed

Check complete. The overall result of this check is: Passed

========================================================

Checking kernel parameters

Checking for semmsl=250; found semmsl=250. Passed

Checking for semmns=32000; found semmns=32000. Passed

Checking for semopm=100; found semopm=100. Passed

Checking for semmni=128; found semmni=128. Passed

Checking for shmmax=536870912; found shmmax=4294967295. Passed

Checking for shmmni=4096; found shmmni=4096. Passed

Checking for shmall=2097152; found shmall=268435456. Passed

Checking for file-max=65536; found file-max=101365. Passed

Checking for VERSION=2.6.9; found VERSION=2.6.18-164.el5. Passed

Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=1024 - 65000. Passed

Checking for rmem_default=4194304; found rmem_default=4194304. Passed

Checking for rmem_max=4194304; found rmem_max=4194304. Passed

Checking for wmem_default=262144; found wmem_default=262144. Passed

Checking for wmem_max=262144; found wmem_max=1048576. Passed

Check complete. The overall result of this check is: Passed

========================================================

Checking Recommended glibc version

Expected result: ATLEAST=2.3.4-2.19

Actual Result: 2.5-42

Check complete. The overall result of this check is: Passed

========================================================

Checking physical memory requirements ...

Expected result: 922MB

Actual Result: 1084MB

Check complete. The overall result of this check is: Passed

========================================================

Checking available swap space requirements ...

Expected result: 1626MB

Actual Result: 2047MB

Check complete. The overall result of this check is: Passed

========================================================

Checking Network Configuration requirements ...

Check complete. The overall result of this check is: Passed

========================================================

Checking PATH environment variable...

Check complete. The overall result of this check is: Passed

========================================================

Checking for sufficient diskspace in TEMP location...

Check complete. The overall result of this check is: Passed

========================================================

Checking LD_LIBRARY_PATH environment variable...

Check complete. The overall result of this check is: Passed

========================================================

Validating ORACLE_BASE location (if set) ...

Check complete. The overall result of this check is: Passed

========================================================

Checking Oracle Home path for spaces...

Check complete. The overall result of this check is: Passed

========================================================

Checking for proper system clean-up....

Check complete. The overall result of this check is: Passed

========================================================

Checking for Oracle Home incompatibilities ....

Actual Result: NEW_HOME

Check complete. The overall result of this check is: Passed

========================================================

[root@ora11g ~]# /oracle/oraInventory/orainstRoot.sh

Changing permissions of /oracle/oraInventory to 770.

Changing groupname of /oracle/oraInventory to oinstall.

The execution of the script is complete

[root@ora11g ~]# /oracle/app/oracle/product/11.1/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /oracle/app/oracle/product/11.1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

[root@ora11g ~]#

3.2. 配置監聽

以oracle使用者執行netca進行監聽配置。

截圖請見附件PDF文件

3.3. DBCA建立資料庫

截圖請見附件PDF文件

以下這步選擇資料庫字符集和國家字符集等，該項內容極為重要，請與上層應用方確認後選擇，中文環境下一般選擇如下：

截圖請見附件PDF文件

3.4. 客戶端配置（可直接修改tnsnames.ora檔案）

以oracle使用者執行netca命令

[oracle@ora11g admin]$ tnsping ora11g 5

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 20-MAY-2011 17:40:46

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora11g)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11g)))

OK (50 msec)

OK (0 msec)

OK (10 msec)

OK (0 msec)

OK (0 msec)

[oracle@ora11g admin]$