操作规范（三）——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）

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]$