操作规范(三)——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]$
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22085031/viewspace-1050487/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22085031/viewspace-1050487/