docker下安装数据库

docker下安装 Oracle11gR2

这是第二次安装,在第一次安装过程部分内容参考自如下:

http://blog.sina.com.cn/s/blog_d840ff330102v4j0.html docker下oracle11g安装

http://blog.csdn.net/yangyinbo/article/details/6221220 HP-UX静默安装oracle11g过程

http://www.linuxidc.com/Linux/2012-03/56606p4.htm  CentOS 6.2 X64上64位Oracle 11gR2 静默安装

但是并没一次成功,中途遇到好多问题,一个一个逐步解决,最终安装成功。在这里只是做一个总结,欢迎指点和纠正。

这次是在安装的过程中同时记录,以备后续参考。

系统环境:

虚拟机Centos7 64位

docker:1.13.1

oracle:11gR2

容器:centos:6.6

第一次安装时最后能够保证连网,如不能连网需要提前准备好相应的包。

保证虚拟机ok,docker已经安装好,同时将oracle包拷贝至centos6.6的容器中的 /oracle_package目录下。

[root@bogon install_package]# docker cp linux.x64_11gR2_database_1of2.zip 22edf28f349d:/oracle_package
[root@bogon install_package]# docker cp linux.x64_11gR2_database_2of2.zip 22edf28f349d:/oracle_package
[root@22edf28f349d oracle_package]# ls
linux.x64_11gR2_database_1of2.zip  linux.x64_11gR2_database_2of2.zip

 

开始安装

1.安装oracle所需要的 gcc* 、glibc*相关的包 

gcc*在装的时候看到有很多个,每个都不是很大,只要网速不是特别差还是很快的。

[root@22edf28f349d oracle_package]# yum -y install gcc*
[root@22edf28f349d oracle_package]# yum -y install glibc*

也可以指安装所需的包,并且要注意顺序:

Oracle 对GCC的顺序:

复制代码
glibc-common-2.12-1.80.el6.x86_64.rpm
kernel-headers-2.6.32-279.el6.x86_64.rpm
libgcc-4.4.6-4.el6.x86_64.rpm
glibc-2.12-1.80.el6.x86_64.rpm
libgomp-4.4.6-4.el6.x86_64.rpm
nscd-2.12-1.80.el6.x86_64.rpm
glibc-headers-2.12-1.80.el6.x86_64.rpm
glibc-devel-2.12-1.80.el6.x86_64.rpm
mpfr-2.4.1-6.el6.x86_64.rpm
ppl-0.10.2-11.el6.x86_64.rpm
cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
cpp-4.4.6-4.el6.x86_64.rpm
gcc-4.4.6-4.el6.x86_64.rpm
注:以上是安装gcc,软件安装顺序不能错
libstdc++-4.4.6-4.el6.x86_64.rpm
libstdc++-devel-4.4.6-4.el6.x86_64.rpm
gcc-c++-4.4.6-4.el6.x86_64.rpm
注:以上是安装gcc-c++
复制代码

也可以使用yum的方式进行安装

复制代码
 #yum -y install gcc
 #yum -y install make
 #yum -y install binutils
 #yum -y install gcc-c++
 #yum -y install compat-libstdc++-33
 #yum -y install elfutils-libelf-devel
 #yum -y install elfutils-libelf-devel-static
 #yum -y install ksh
 #yum -y install libaio
 #yum -y install libaio-devel
 #yum -y install numactl-devel
 #yum -y install sysstat
 #yum -y install unixODBC
 #yum -y install unixODBC-devel
 #yum -y install pcre-devel
复制代码

 

注意:  

在使用yum安装时如果出现如下错误:

复制代码
[root@d0361c82ec77 oracle_package]# yum -y install gcc*
Loaded plugins: fastestmirror
Setting up Install Process
Examining gcc-4.4.7-4.el6.x86_64.rpm: gcc-4.4.7-4.el6.x86_64
Marking gcc-4.4.7-4.el6.x86_64.rpm to be installed
base                                                     | 3.7 kB     00:00     
base/primary_db                                          | 4.7 MB     00:05     
epel                                                     | 4.3 kB     00:00     
epel/primary_db                                          | 4.6 MB     00:10     
Error: xz compression not available
[root@d0361c82ec77 oracle_package]# 
复制代码

这个错误主要意思是没有epel或者存在错误的epel,可以这样来解决:

  1.remove 错误的epel

有可能会出现如下:说明系统还没有epel

复制代码
[root@d0361c82ec77 oracle_package]# yum remove epel-release
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: epel-release
Determining fastest mirrors
Error: xz compression not available
[root@d0361c82ec77 oracle_package]# 
复制代码

或者:移除epel成功

复制代码
[root@d0361c82ec77 yum]# yum remove epel-release
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package epel-release.noarch 0:6-8 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package               Arch            Version         Repository          Size
================================================================================
Removing:
 epel-release          noarch          6-8             installed           22 k

Transaction Summary
================================================================================
Remove        1 Package(s)

Installed size: 22 k
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Erasing    : epel-release-6-8.noarch                                      1/1 
warning: /etc/yum.repos.d/epel.repo saved as /etc/yum.repos.d/epel.repo.rpmsave
  Verifying  : epel-release-6-8.noarch                                      1/1 

Removed:
  epel-release.noarch 0:6-8                                                     

Complete!
复制代码

这两种情况都没有问题,接着执行下面步骤

  2.清理epel 缓存

[root@d0361c82ec77 yum]# rm -rf /var/cache/yum/x86_64/6/epel

  3.重新安装正确的epel:

[root@d0361c82ec77 yum]# rpm -ivh http://mirrors.ustc.edu.cn/epel/6/x86_64/epel-release-6-8.noarch.rpm
Retrieving http://mirrors.ustc.edu.cn/epel/6/x86_64/epel-release-6-8.noarch.rpm
warning: /var/tmp/rpm-tmp.M6IbHz: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
Preparing...                ########################################### [100%]
   1:epel-release           ########################################### [100%]

  4.使用 yum search munin 检测是否安装正确

复制代码
[root@d0361c82ec77 yum]# yum search munin
Loaded plugins: fastestmirror base
| 3.7 kB 00:00 base/primary_db | 4.7 MB 00:14 epel/metalink | 5.4 kB 00:00 epel | 4.3 kB 00:00 epel/primary_db | 5.9 MB 00:27 extras | 3.4 kB 00:00 extras/primary_db | 37 kB 00:00 updates | 3.4 kB 00:00 updates/primary_db | 5.4 MB 00:09 ============================== N/S Matched: munin ============================== PyMunin.noarch : Python Module for developing Munin Multigraph Monitoring : Plugins munin-java-plugins.noarch : java-plugins for munin munin-ruby-plugins.noarch : ruby-plugins for munin munin.noarch : Network-wide graphing framework (grapher/gatherer) munin-async.noarch : Network-wide graphing framework (asynchronous client tools) munin-cgi.noarch : Network-wide graphing framework (cgi files for apache) munin-common.noarch : Network-wide graphing framework (common files) munin-netip-plugins.noarch : Network-wide graphing framework (dhcpd3 and ntp : plugins) munin-nginx.noarch : Network-wide graphing framework (cgi files for nginx) munin-node.noarch : Network-wide graphing framework (node) Name and summary matches only, use "search all" for everything.
复制代码

到此这个问题就已经解决了,如果还有问题可以重复上述1.2.3.4步骤。

再次运行:

复制代码
[root@d0361c82ec77 yum]# yum -y install gcc*
Loaded plugins: fastestmirror
Setting up Install Process
Determining fastest mirrors
 * epel: mirrors.neusoft.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package gcc.x86_64 0:4.4.7-17.el6 will be installed
--> Processing Dependency: libgomp = 4.4.7-17.el6 for package: gcc-4.4.7-17.el6.x86_64
--> Processing Dependency: cpp = 4.4.7-17.el6 for package: gcc-4.4.7-17.el6.x86_64
--> Processing Dependency: libgcc >= 4.4.7-17.el6 for package: gcc-4.4.7-17.el6.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.4.7-17.el6.x86_64
...
复制代码

在安装过程中如果提示:

Public key for gcc-objc-4.4.7-17.el6.x86_64.rpm is not installed

在网上找到了解决方法:
此时要导入rpm的签名信息即可
以root登录,执行下面命令
# rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

根据我的Linux版本是CentOS 6.6
于是我执行下面命令
#rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

 

 


 

安装 unzip指令 vim指令,因为centos6.6容器中没有这两个指令的,后边需要用到,容器中自带了vi,看个人习惯了

[root@22edf28f349d oracle_package]# yum -y install unzip
[root@22edf28f349d oracle_package]# yum -y install vim

 

2.修改主机名

这里主要将容器id 加入hostname中,如果hostname不正确后边启动监听可能会出现问题。

[root@22edf28f349d oracle_package]# vim /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=hadoop

 

3.修改host文件

先用hostname查看当前的主机名为:

[root@22edf28f349d oracle_package]# hostname
22edf28f349d

 

内容如下:

复制代码
[root@22edf28f349d oracle_package]# vim /etc/hosts
127.0.0.1       hadoop
::1     localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
#172.17.0.2     1c0d06324543

复制代码

 

4. 创建用户oracle及组dba

复制代码
[root@22edf28f349d oracle_package]# vim /etc/hosts
[root@22edf28f349d oracle_package]# groupadd dba
[root@22edf28f349d oracle_package]# useradd -g dba oracle
[root@22edf28f349d oracle_package]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@22edf28f349d oracle_package]# 
复制代码

 

5.创建oracle目录和设置权限

复制代码
[root@22edf28f349d oracle_package]# mkdir -p /u01/app/oracle
[root@22edf28f349d oracle_package]# mkdir -p /u01/app/product/11.2.0/db_1  //数据库系统安装目录
[root@22edf28f349d oracle]# mkdir /u01/app/oracle/oraInventory  //清单目录
[root@22edf28f349d oracle_package]# chown -R oracle:dba /u01
[root@22edf28f349d oracle_package]# chmod -R 775 /u01
[root@22edf28f349d oracle]# mkdir /opt/oradata  //数据存放目录
[root@22edf28f349d oracle]# mkdir /opt/oradata_back  //数据备份目录
复制代码

 

 记录一下:

mkdir -p 中-p 的作用,如果递归创建目录没有-p会报错,同时-p有如下作用:

-p, --parents     no error if existing, make parent directories as needed

 

chown 用户名:组名 文件路径(可以是就对路径也可以是相对路径)

例1:chown oracle:dba /tmp/tmp1
就是把tmp下的tmp1的用户名和用户组改成oracle和dba(只修改了tmp1的属组).
例2:chown -R oracle:dba /tmp/tmp1
就是把tmp下的tmp1下的所有文件的属组都改成oracle和oracle。

chmod -R 775 /u01

chmod用法
用来修改某个目录或文件的访问权限

复制代码
语法:chmod [who] [+ | - | =] [mode] 文件名
 命令中各选项的含义为: 
操作对象who可是下述字母中的任一个或者它们的组合:
   u 表示“用户(user)”,即文件或目录的所有者。
   g 表示“同组(group)用户”,即与文件属主有相同组ID的所有用户。
   o 表示“其他(others)用户”。
   a 表示“所有(all)用户”。它是系统默认值。
 操作符号可以是:
   + 添加某个权限。
   - 取消某个权限。
   = 赋予给定权限并取消其他所有权限(如果有的话)。
 设置 mode 所表示的权限可用下述字母的任意组合:
   r 可读。
   w 可写。
    x 可执行。
   X 只有目标文件对某些用户是可执行的或该目标文件是目录时才追加x 属性。
   s 在文件执行时把进程的属主或组ID置为该文件的文件属主。
       方式“u+s”设置文件的用户ID位,“g+s”设置组ID位。
   t 保存程序的文本到交换设备上。
   u 与文件属主拥有一样的权限。
   g 与和文件属主同组的用户拥有一样的权限。
   o 与其他用户拥有一样的权限。
 文件名:以空格分开的要改变权限的文件列表,支持通配符。
复制代码

 

复制代码
在Unix和Linux的各种操作系统下,每个文件(文件夹也被看作是文件)都按读、写、运行设定权限。
例如我用ls -l命令列文件表时,得到如下输出:
-rw-r--r--  1 bu users  2254 2006-05-20 13:47 tt.htm
从第二个字符起rw-是说用户bu有读、写权,没有运行权,接着的r--表示用户组users只有读权限,没有运行权,最后的r--指其他人(others)只有读权限,没有写权和运行权。
这是系统默认设置,我可以改写tt.htm,同组的人和其他人只有权读,没人有权运行,因为只是一个html文件,不必运行。这在Novell的directory services之前很先进。 读、写、运行三项权限可以用数字表示,就是r
=4,w=2,x=1。所以,上面的例子中的rw-r--r--用数字表示成644。 反过来说777就是rwxrwxrwx,意思是该登录用户(可以用命令id查看)、他所在的组和其他人都有最高权限。 再多说一句。我用chmod o-r tt.htm命令改权限,o-r是others的权限中减掉读。结果是 -rw-r----- 1 bu users 2254 2006-05-20 13:47 tt.htm 如果用命令chmod 777 tt.htm,结果是 -rwxrwxrwx 1 bu users 2254 2006-05-20 13:47
tt.htm 任何人都有读、写、运行三项权限。
理论上就是这样,但实际运用上往往需要加上1执行权,否则执行不了读或写
复制代码

 

6.设置环境变量,修改oracle用户的 .bash_profile 文件

复制代码
[oracle@22edf28f349d ~]# vim .bash_profile 

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
复制代码

 

使环境变量生效 

[root@22edf28f349d ~]# source .bash_profile

 

7.将oracle的两个安装包解压到同一个目录下,如果不是同一个目录后边会报错

[root@22edf28f349d oracle_package]# unzip linux.x64_11gR2_database_1of2.zip -d ./oracle
[root@22edf28f349d oracle_package]# unzip linux.x64_11gR2_database_2of2.zip -d ./oracle

 

8.将刚解压后的rsp文件复制到 /home/oracle目录下

[root@22edf28f349d oracle_package]# cp ./oracle/database/response/* /home/oracle/

 

查看 /home/oracle目录下的rsp文件

[root@22edf28f349d oracle]# ls
dbca.rsp  db_install.rsp  netca.rsp

 

9.修改db_install.rsp文件的内容:

详细解释来自:http://blog.chinaunix.net/uid-23886490-id-3565908.html

复制代码
[root@22edf28f349d oracle]# vim db_install.rsp 
####################################################################
## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.##
##                                                                ##
## Specify values for the variables listed below to customize     ##
## your installation.                                             ##
##                                                                ##
## Each variable is associated with a comment. The comment        ##
## can help to populate the variables with the appropriate        ##
## values.                              ##
##                                                                ##
## IMPORTANT NOTE: This file contains plain text passwords and    ##
## should be secured to have read permission only by oracle user  ##
## or db administrator who owns this installation.                ##
##                                                                ##
####################################################################

#------------------------------------------------------------------------------
# Do not change the following system generated value. 
#------------------------------------------------------------------------------
#标注响应文件版本,这个版本必须和要#安装的数据库版本相同,安装检验无法通过,不能更改
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 

#------------------------------------------------------------------------------
# Specify the installation option.#选择安装类型:1.只装数据库软件 2.安装数据库软件并建库 3.升级数据库
# It can be one of the following:
# 1. INSTALL_DB_SWONLY
# 2. INSTALL_DB_AND_CONFIG
# 3. UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY

#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames 
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=hadoop  #指定操作系统主机名,通过hostname命令获得

#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.  
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=dba   #指定oracle inventory目录的所有者,通常会是oinstall或者dba

#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oracle/oraInventory  #指定产品清单oracle inventory目录的路径,如果是Win平台下可以省略

#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.             
#
# en   : English                  ja   : Japanese                  
# fr   : French                   ko   : Korean                    
# ar   : Arabic                   es   : Latin American Spanish    
# bn   : Bengali                  lv   : Latvian                   
# pt_BR: Brazilian Portuguese     lt   : Lithuanian                
# bg   : Bulgarian                ms   : Malay                     
# fr_CA: Canadian French          es_MX: Mexican Spanish           
# ca   : Catalan                  no   : Norwegian                 
# hr   : Croatian                 pl   : Polish                    
# cs   : Czech                    pt   : Portuguese                
# da   : Danish                   ro   : Romanian                  
# nl   : Dutch                    ru   : Russian                   
# ar_EG: Egyptian                 zh_CN: Simplified Chinese        
# en_GB: English (Great Britain)  sk   : Slovak                    
# et   : Estonian                 sl   : Slovenian                 
# fi   : Finnish                  es_ES: Spanish                   
# de   : German                   sv   : Swedish                   
# el   : Greek                    th   : Thai                      
# iw   : Hebrew                   zh_TW: Traditional Chinese       
# hu   : Hungarian                tr   : Turkish                   
# is   : Icelandic                uk   : Ukrainian                 
# in   : Indonesian               vi   : Vietnamese                
# it   : Italian                                                   
#
# Example : SELECTED_LANGUAGES=en,fr,ja
#------------------------------------------------------------------------------
SELECTED_LANGUAGES=en,zh_CN #指定数据库语言,可以选择多个,用逗号隔开。选择en, zh_CN(英文和简体中文)

#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/u01/app/product/11.2.0/db_1  #设置ORALCE_HOME的路径

#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base. 
#------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/oracle  #设置ORALCE_BASE的路径

#------------------------------------------------------------------------------
# Specify the installation edition of the component.                        
#                                                             
# The value should contain only one of these choices.        
# EE     : Enterprise Edition                                
# SE     : Standard Edition                                  
# SEONE  : Standard Edition One
# PE     : Personal Edition (WINDOWS ONLY) #选择Oracle安装数据库软件的版本(企业版,标准版,标准版1),不同的版本功能不同
#------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE

#------------------------------------------------------------------------------
# This variable is used to enable or disable custom install.
#
# true  : Components mentioned as part of 'customComponents' property
#         are considered for install.
# false : Value for 'customComponents' is not considered.
#------------------------------------------------------------------------------

  #是否自定义Oracle的组件,如果选择false,则会使用默认的组件

  #如果选择true否则需要自己在下面一条参数将要安装的组件一一列出。

  #安装相应版权后会安装所有的组件,后期如果缺乏某个组件,再次安装会非常的麻烦。

oracle.install.db.isCustomInstall=true

#------------------------------------------------------------------------------
# This variable is considered only if 'IsCustomInstall' is set to true. 
#
# Description: List of Enterprise Edition Options you would like to install.
#
#              The following choices are available. You may specify any
#              combination of these choices.  The components you choose should
#              be specified in the form "internal-component-name:version"
#              Below is a list of components you may specify to install.
#        
#              oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning
#              oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining
#              oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault 
#              oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security
#              oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing 
#              oracle.oraolap:11.2.0.1.0 - Oracle OLAP
#------------------------------------------------------------------------------
oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,
oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,
oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,
oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0 ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DBA_GROUP=dba #指定拥有OSDBA、OSOPER权限的用户组,通常会是dba组 #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=dba #------------------------------------------------------------------------------ # Specify the cluster node names selected during the installation. #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES= #如果是RAC的安装,在这里指定所有的节点 #------------------------------------------------------------------------------ # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #选择数据库的用途,一般用途/事物处理,数据仓库 #------------------------------------------------------------------------------ # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.globalDBName=orcl #指定GlobalName #------------------------------------------------------------------------------ # Specify the Starter Database SID. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.SID=orcl #------------------------------------------------------------------------------ # Specify the Starter Database character set. # # It can be one of the following: # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------

 #选择字符集。不正确的字符集会给数据显示和存储带来麻烦无数。

 #通常中文选择的有ZHS16GBK简体中文库,建议选择unicode的AL32UTF8国际字符集

oracle.install.db.config.starterdb.characterSet=AL32UTF8

#------------------------------------------------------------------------------
# This variable should be set to true if Automatic Memory Management 
# in Database is desired.
# If Automatic Memory Management is not desired, and memory allocation
# is to be done manually, then set it to false.
#------------------------------------------------------------------------------
#11g的新特性自动内存管理,也就是SGA_TARGET和PAG_AGGREGATE_TARGET都#不用设置了,Oracle会自动调配两部分大小
oracle.install.db.config.starterdb.memoryOption=true #------------------------------------------------------------------------------ # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------
#指定Oracle自动管理内存的大小,最小是256MB
oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------ # This variable controls whether to load Example Schemas onto the starter # database or not. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.installExampleSchemas=false #是否载入模板示例 #------------------------------------------------------------------------------ # This variable includes enabling audit settings, configuring password profiles # and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.enableSecuritySettings=true #是否启用安全设置 ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # SYSMAN (used by Enterprise Manager) # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL=oracle #设定所有数据库用户使用同一个密码,其它数据库用户就不用单独设置了。 #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the SYSMAN password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the management option to be selected for the starter database. # It can be one of the following: # 1. GRID_CONTROL # 2. DB_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.control=DB_CONTROL #数据库本地管理工具DB_CONTROL,远程集中管理工具GRID_CONTROL #------------------------------------------------------------------------------- # Specify the Management Service to use if Grid Control is selected to manage # the database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= #GRID_CONTROL需要设定grid control的远程路径URL #------------------------------------------------------------------------------- # This variable indicates whether to receive email notification for critical # alerts when using DB control. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false #是否启用Email通知, 启用后会将告警等信息发送到指定邮箱 #------------------------------------------------------------------------------- # Specify the email address to which the notifications are to be sent. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.emailAddress= #设置通知EMAIL地址 #------------------------------------------------------------------------------- # Specify the SMTP server used for email notifications. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.SMTPServer= ############################################################################### # # # SPECIFY BACKUP AND RECOVERY OPTIONS # # ------------------------------------ # # Out-of-box backup and recovery options for the database can be mentioned # # using the entries below. # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if automated backup is not required. Else # this can be set to true. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.enable=false #设置自动备份,和OUI里的自动备份一样。 #------------------------------------------------------------------------------ # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system # user that is specified in this variable. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.osuid= #自动备份会启动一个job,指定启动JOB的系统用户ID #------------------------------------------------------------------------------- # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system user # specified by the above entry. The following entry stores the password for the # above operating system user. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.ospwd= #自动备份会开启一个job,需要指定OSUser的密码 #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.storageType= #自动备份,要求指定使用的文件系统存放数据库文件还是ASM #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #-------------------------------------------------------------------------------
##使用文件系统存放数据库文件才需要指定数据文件、控制文件、Redo log的存放目录
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the backup and recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #-------------------------------------------------------------------------------
##使用文件系统存放数据库文件才需要指定备份恢复目录
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM #-------------------------------------------------------------------------------
##使用ASM存放数据库文件才需要指定存放的磁盘组
oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM #-------------------------------------------------------------------------------
##使用ASM存放数据库文件才需要指定ASM实例密码
oracle.install.db.config.asm.ASMSNMPPassword= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : MYORACLESUPPORT_USERNAME=metalink #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME= ##指定metalink账户用户名 #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD= ## 指定metalink账户密码 #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT= ## 用户是否可以设置metalink密码 #------------------------------------------------------------------------------ # Specify whether user wants to give any proxy details for connection. # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------

False表示不需要设置安全更新,注意,在11.2的静默安装中疑似有一个BUG

Response File中必须指定为true,否则会提示错误,不管是否正确填写了邮件地址

# 这里必须为 true 否则会失败

DECLINE_SECURITY_UPDATES=true

#------------------------------------------------------------------------------
# Specify the Proxy server name. Length should be greater than zero.
#
# Example    : PROXY_HOST=proxy.domain.com 
#------------------------------------------------------------------------------
PROXY_HOST=  ##代理服务器名

#------------------------------------------------------------------------------
# Specify the proxy port number. Should be Numeric and atleast 2 chars.
#
# Example    : PROXY_PORT=25 
#------------------------------------------------------------------------------
PROXY_PORT=  ##代理服务器端口

#------------------------------------------------------------------------------
# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD 
# blank if your proxy server requires no authentication.
#
# Example    : PROXY_USER=username 
#------------------------------------------------------------------------------
PROXY_USER=  ##代理服务器用户名

#------------------------------------------------------------------------------
# Specify the proxy password. Leave PROXY_USER and PROXY_PWD  
# blank if your proxy server requires no authentication.
#
# Example    : PROXY_PWD=password 
#------------------------------------------------------------------------------
PROXY_PWD=  ##代理服务器密码
复制代码

 

 

10.开始安装oracle11g 容器中没有图形界面,只能静默安装(silent),所以需要配置以上文件

切换到oracle用户下

[root@22edf28f349d oracle]# su oracle
[oracle@22edf28f349d ~]$ cd /

 

进去刚才解压oracle两个zip包的目标目录,并且进入database目录下 执行安装:

[oracle@22edf28f349d database]$ ls
doc  install  response  rpm  runInstaller  sshsetup  stage  welcome.html
[oracle@22edf28f349d database]$ ./runInstaller -ignoreSysPrereqs -ignorePrereq -silent -responseFile /home/oracle/db_install.rsp

 

安装过程中,如果提示[WARNING]不必理会,此时安装程序仍在进行,如果出现[FATAL],则安装程序已经停止了。

打开另一个终端,执行
 #tail -100f /home/oracle/inventory/logs/installActions......log
 可以实时跟踪查看安装日志,了解安装的进度。

[root@22edf28f349d /]# tail -100f /tmp/OraInstall2017-03-08_06-02-45PM/installActions2017-03-08_06-02-45PM.log

 

安装过程比较花时间,慢慢等待吧。

当出现如下语句就表示安装成功了:

复制代码
[oracle@22edf28f349d database]$ The following configuration scripts need to be executed as the "root" user. 
 #!/bin/sh 
 #Root scripts to run

/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/product/11.2.0/db_1/root.sh
To execute the configuration scripts:
     1. Open a terminal window 
     2. Log in as "root" 
     3. Run the scripts 
     4. Return to this window and hit "Enter" key to continue 

Successfully Setup Software.
复制代码

 

11.按照提示在root用户下执行两个脚本

[root@22edf28f349d /]# /u01/app/product/11.2.0/db_1/root.sh
Check /u01/app/product/11.2.0/db_1/install/root_22edf28f349d_2017-03-08_18-45-38.log for the output of root script

 

查看日志:

复制代码
[root@22edf28f349d /]# tail -100f /u01/app/product/11.2.0/db_1/install/root_22edf28f349d_2017-03-08_18-45-38.log

Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/product/11.2.0/db_1

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@22edf28f349d /]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oracle/oraInventory to dba.
The execution of the script is complete.
[root@22edf28f349d /]# 
复制代码

 

到此oracle11g软件已经安装成功了。。。

12.安装listener

复制代码
[oracle@22edf28f349d database]$ netca /silent /responsefile /home/oracle/netca.rsp
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: /u01/app/product/11.2.0/db_1/lib/libnjni11.so: libaio.so.1: cannot open shared object file: No such file or directory
java.lang.UnsatisfiedLinkError: jniGetOracleHome
    at oracle.net.common.NetGetEnv.jniGetOracleHome(Native Method)
    at oracle.net.common.NetGetEnv.getOracleHome(Unknown Source)
    at oracle.net.ca.NetCALogger.getOracleHome(NetCALogger.java:230)
    at oracle.net.ca.NetCALogger.initOracleParameters(NetCALogger.java:215)
    at oracle.net.ca.NetCALogger.initLogger(NetCALogger.java:130)
    at oracle.net.ca.NetCA.main(NetCA.java:404)

Error: jniGetOracleHome
Oracle Net Services configuration failed.  The exit code is 1
复制代码

 

安装时报错,按照网上的解决办法:

安装 libaio.so.1 并将 libaio.so.1拷贝到$ORACLE_HOME/lib目录下

[root@22edf28f349d /]# yum -y install libaio*
[oracle@22edf28f349d lib64]$ cp /lib64/libaio.so.1 $ORACLE_HOME/lib

 

重现安装listener:

复制代码
[oracle@22edf28f349d lib64]$ netca /silent /responsefile /home/oracle/netca.rsp

Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /home/oracle/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control: 
      /u01/app/product/11.2.0/db_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@22edf28f349d lib64]$ 
复制代码

 

显示listener安装成功。

查看listener的状态:

复制代码
[oracle@22edf28f349d lib64]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-MAR-2017 18:55:11

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                08-MAR-2017 18:54:17
Uptime                    0 days 0 hr. 0 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/22edf28f349d/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@22edf28f349d lib64]$ 
复制代码

 

13.使用dbca 静默建库(创建数据库实例)

由于我们在安装数据库的时候在db_install.rsp配置了:

复制代码
#------------------------------------------------------------------------------
# Specify the installation option.#选择安装类型:1.只装数据库软件 2.安装数据库软件并建库 3.升级数据库
# It can be one of the following:
# 1. INSTALL_DB_SWONLY
# 2. INSTALL_DB_AND_CONFIG
# 3. UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
复制代码

 

此时还没有数据库和实例,可以通过dbca.rsp 来创建数据库和实例

编辑dbca.rsp文件:

复制代码
RESPONSEFILE_VERSION = "11.2.0"  //不能更改
 OPERATION_TYPE = "createDatabase"
 GDBNAME = "orcl"  //数据库的名字
 SID = "orcl"    //对应的实例名字
 TEMPLATENAME = "General_Purpose.dbc" //建库用的模板文件
 SYSPASSWORD = "oracle"   //SYS管理员密码
 SYSTEMPASSWORD = "oracle"  //SYSTEM管理员密码
 DATAFILEDESTINATION =  //数据文件存放目录 默认为 $ORACLE_BASE/oradata
 RECOVERYAREADESTINATION= //恢复数据存放目录 默认为$ORACLE_BASE/flash_recovery_area
 CHARACTERSET = "UTF8"   //字符集,重要!!! 建库后一般不能更改,所以建库前要确定清楚。
 TOTALMEMORY = "5120"    //oracle内存5120MB
复制代码
复制代码
[oracle@22edf28f349d lib64]$ dbca -silent -responseFile /home/oracle/dbca.rsp 
sh: /bin/ksh: No such file or directory
sh: /bin/ksh: No such file or directory
/bin/cat: /proc/sys/net/core/wmem_default: No such file or directory
sh: /bin/ksh: No such file or directory
sh: /bin/ksh: No such file or directory
/bin/cat: /proc/sys/net/core/wmem_default: No such file or directory
sh: /bin/ksh: No such file or directory
sh: /bin/ksh: No such file or directory
/bin/cat: /proc/sys/net/core/wmem_default: No such file or directory
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
复制代码

 

14.再次查看监听:

复制代码
[oracle@22edf28f349d lib64]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-MAR-2017 19:27:33

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                08-MAR-2017 18:54:17
Uptime                    0 days 0 hr. 33 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/22edf28f349d/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@22edf28f349d lib64]$ 
复制代码

 

15.连接sqlplus

复制代码
[oracle@22edf28f349d lib64]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 8 19:28:08 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION       STARTUP_T STATUS     PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS       SHU DATABASE_STATUS     INSTANCE_ROLE        ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
          1 orcl
22edf28f349d
11.2.0.1.0      08-MAR-17 OPEN     NO          1 STOPPED
ALLOWED    NO  ACTIVE         PRIMARY_INSTANCE   NORMAL    NO


SQL> 
复制代码

到此docker下成功完成oracle11g实例的安装完成。

 

16.建立表空间和用户
在创建之前需要目标目录需要存在即:

[root@7a0b6182a059 orcl]# pwd
/opt/oracle/oradata/orcl

并赋予权限:

[root@7a0b6182a059 ~]# chown -R oracle:dba /opt/oracle
[root@7a0b6182a059 ~]# chmod -R 775 /opt/oracle

创建临时表空间:

复制代码
SQL> create temporary tablespace user_temp tempfile '/opt/oracle/oradata/orcl/user_temp.dbf' size 50m
  2  autoextend on
  3  next 50m maxsize 20480m
  4  extent management local;

Tablespace created.

SQL> 
复制代码

 创建数据表空间

复制代码
SQL> create tablespace user_data
  2  logging
  3  datafile '/opt/oracle/oradata/orcl/user_data.dbf'
  4  size 50m
  5  autoextend on
  6  next 50m maxsize 20480m
  7  extent management local;

Tablespace created.

SQL> 
复制代码

 创建用户并指定表空间

SQL> create user jzptpub identified by jzptpub
   2  default tablespace user_data
  3  temporary tablespace user_temp;

User created.

 给用户授予权限

SQL> grant connect,resource to jzptpub;

Grant succeeded.


 此时在其他机器上可以远程登录这个用户,命令为:
 $sqlplus test/test@ip/orcl

17.用新建的用户连接数据库,并建立一个表

$ export NLS_LANG=American_America.AL32UTF8 

 注意:UTF8是为了使得sqlplus和linux终端环境一致起来,此时发往数据库的是UTF8,数据库存储前会转为ZHS16GBK.
 当读取时,Sqlplus会把收到的ZHS16GBK转换为UTF8发送到Linux终端。

$sqlplus test/test@ip/orcl

 SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 14 08:22:11 2012

 Copyright (c) 1982, 2009, Oracle.  All rights reserved.


 Connected to:
 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
 With the Partitioning, OLAP, Data Mining and Real Application Testing options

 SQL> create table STUDENT(ID int, NAME varchar(20));

 Table created.

 SQL> insert into STUDENT values(1, '张三');

 1 row created.

 SQL> select * from student;

   ID NAME
 ---------- ------------------------------------------------------------
    1 张三

 

需要注意的地方:

客户端连接配置tnsname.ora文件
docker =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.114.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracle11g)
    )
  )

用pl/sql连接

注1:192.168.114.130为宿主机IP,1521也是宿主机端口,而容器中oracle服务端口1521是映射到宿主机的1521端口
注2:在容器中启动listener,要主意$ORACLE_HOME/network/admin下的listener.ora和tnsname.ora文件中的host参数,这个参数不能写成IP,也不能写成/etc/sysconfig/network中的hostname,只能写成
容器启动时的容器ID号,也可在容器中使用命令查看主机信息uname -a
如:
[oracle@d2126eb6637e ~]$ uname -a
Linux d2126eb6637e 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux













rpm -ivh http://mirrors.ustc.edu.cn/epel/6/x86_64/epel-release-6-8.noarch.rpm

echo "export MD_THREAD_ID=0" >> /etc/profile


echo "export MD_THREAD_DIR=/mdnas/$MD_THREAD_ID" >> /etc/profile


echo "export PRE_ORACLE_INSTALL_DIR=/mdnas/software/database" >> /etc/profile


export MD_HOSTNAME=dba
 
export MD_THREAD_ID=0
export MD_THREAD_DIR=/mdnas/$MD_THREAD_ID


export PRE_ORACLE_INSTALL_DIR=/mdnas/software/database


export ORACLE_HOME=hadoop 


source /etc/profile

1) 添加Oracle用户信息 创建安装目录
groupadd dba


useradd -g dba oracle


echo "oracle:oracle" | chpasswd

mkdir -p /oracle


mkdir -p /oracle/product/11.2.0/db_1  /oracle/oraInventory


chown -R oracle:dba /oracle


chmod -R 775 /oracle


mkdir -p /oracle/oradata


2) 
touch /etc/oraInst.loc

echo "inventory_loc=/oracle/oraInventory" >> /etc/oraInst.loc


echo "inst_group=dba" >> /etc/oraInst.loc


chown oracle:dba /etc/oraInst.loc


chmod 664 /etc/oraInst.loc



echo "export PATH=$PATH:$HOME/bin" >> /home/oracle/.bash_profile


echo "export ORACLE_BASE=/oracle" >> /home/oracle/.bash_profile


echo "export export ORACLE_HOME=/oracle/product/11.2.0/db_1" >> /home/oracle/.bash_profile


echo "export PATH=$PATH:$ORACLE_HOME/bin" >> /home/oracle/.bash_profile


echo "export ORACLE_SID=orcl" >> /home/oracle/.bash_profile





四  修改用户资源限制
echo "oracle soft nproc 2047">>/etc/security/limits.conf


echo "oracle hard nproc 16384">>/etc/security/limits.conf


echo "oracle soft nofile 1024">>/etc/security/limits.conf


echo "oracle hard nofile 65536">>/etc/security/limits.conf


echo "oracle soft stack 10240">>/etc/security/limits.conf


echo "session required /lib64/security/pam_limits.so">>/etc/pam.d/login


echo "session required pam_limits.so">>/etc/pam.d/login




五 修改内核参数
echo "fs.file-max = 6815744 ">>/etc/sysctl.conf


echo "fs.aio-max-nr = 1048576 ">>/etc/sysctl.conf


echo "kernel.shmall = 2097152">>/etc/sysctl.conf


echo "kernel.shmmax = 2147483648 ">>/etc/sysctl.conf


echo "kernel.shmmni = 4096 ">>/etc/sysctl.conf


echo "kernel.sem = 250 32000 100 128">>/etc/sysctl.conf


echo "net.ipv4.ip_local_port_range = 9000 65500">>/etc/sysctl.conf


echo "net.core.rmem_default = 4194304">>/etc/sysctl.conf


echo "net.core.rmem_max = 4194304 ">>/etc/sysctl.conf


echo "net.core.wmem_default = 262144 ">>/etc/sysctl.conf


echo "net.core.wmem_max = 1048576">>/etc/sysctl.conf




准备oracle安装应答模板文件db_install.rsp文件


cp /mdnas/software/database/response/* /oracle/


六 // 安装类型
echo "oracle.install.option=INSTALL_DB_SWONLY" >> db_install.rsp
// 主机名称(hostname查询)
echo "ORACLE_HOSTNAME=hadoop">> db_install.rsp
 // 安装组
echo "UNIX_GROUP_NAME=dba">> db_install.rsp


echo "INVENTORY_LOCATION=/oracle/oraInventory">> db_install.rsp


echo "ORACLE_HOME=/oracle/product/11.2.0/db_1">> db_install.rsp


echo "ORACLE_BASE=/oracle">> db_install.rsp


echo "oracle.install.db.InstallEdition=EE">> db_install.rsp


echo "oracle.install.db.isCustomInstall=true">> db_install.rsp


echo "oracle.install.db.DBA_GROUP=dba">> db_install.rsp


echo "oracle.install.db.OPER_GROUP=dba">> db_install.rsp


echo "oracle.install.db.config.starterdb.type=GENERAL_PURPOSE">> db_install.rsp


echo "oracle.install.db.config.starterdb.globalDBName=orcl">> db_install.rsp


echo "oracle.install.db.config.starterdb.SID=orcl">> db_install.rsp


echo "oracle.install.db.config.starterdb.memoryLimit=3072">> db_install.rsp


echo "oracle.install.db.config.starterdb.password.ALL=oracle">> db_install.rsp


echo "oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false">> db_install.rsp


echo "SECURITY_UPDATES_VIA_MYORACLESUPPORT=false">> db_install.rsp


echo "DECLINE_SECURITY_UPDATES=true">> db_install.rsp







yum -y install unzip                     -----------

yum -y install vim                        -----------

yum -y install gcc*

yum -y install glibc*

yum -y install gcc ------

yum -y install make ----------


yum -y install binutils ----------


yum -y install gcc-c++


yum -y install compat-libstdc++-33


yum -y install elfutils-libelf-devel


yum -y install elfutils-libelf-devel-static


yum -y install ksh


yum -y install libaio

yum -y install libaio-devel


yum -y install numactl-devel


yum -y install sysstat

yum -y install unixODBC


yum -y install unixODBC-devel


su oracle -c "$PRE_ORACLE_INSTALL_DIR/runInstaller -silent -responseFile /root/db_install.rsp -ignorePrereq -showProgress"








//创建数据库
su - oracle
$ORACLE_HOME/dbca   -silent -responseFile /home/oracle/responseca.rsp





sed -i "s/oracle.install.option=/oracle.install.option=INSTALL_DB_SWONLY/g" /oracle/db_install.rsp
// 主机名称(hostname查询)
sed -i "s/ORACLE_HOSTNAME=/ORACLE_HOSTNAME=$hostname/g" /oracle/db_install.rsp
 // 安装组
sed -i "s/UNIX_GROUP_NAME=/UNIX_GROUP_NAME=dba/g" /oracle/db_install.rsp


sed -i "s/INVENTORY_LOCATION=/INVENTORY_LOCATION=\/oracle\/oraInventory/g" /oracle/db_install.rsp


sed -i "s/ORACLE_HOME=/ORACLE_HOME=\/oracle\/product\/11.2.0\_1/g" /oracle/db_install.rsp


sed -i "s/ORACLE_BASE=/ORACLE_BASE=\/oracle/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.InstallEdition=/oracle.install.db.InstallEdition=EE/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.isCustomInstall=/oracle.install.db.isCustomInstall=true/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.DBA_GROUP=/oracle.install.db.DBA_GROUP=dba/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.OPER_GROUP=/oracle.install.db.OPER_GROUP=dba/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.config.starterdb.type=/oracle.install.db.config.starterdb.type=GENERAL_PURPOSE/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.config.starterdb.globalDBName=/oracle.install.db.config.starterdb.globalDBName=orcl/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.config.starterdb.SID=/oracle.install.db.config.starterdb.SID=orcl/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.config.starterdb.memoryLimit=/oracle.install.db.config.starterdb.memoryLimit=3072/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.config.starterdb.password.ALL=/oracle.install.db.config.starterdb.password.ALL=oracle/g" /oracle/db_install.rsp


sed -i "s/oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=/oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false/g" /oracle/db_install.rsp


sed -i "s/SECURITY_UPDATES_VIA_MYORACLESUPPORT=/SECURITY_UPDATES_VIA_MYORACLESUPPORT=false/g" /oracle/db_install.rsp


sed -i "s/DECLINE_SECURITY_UPDATES=/DECLINE_SECURITY_UPDATES=true/g" /oracle/db_install.rsp








阅读更多
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭