linux 安装 oracle 11g

文章列表

linux 安装 oracle 11g

1、下载oracle 11g (11.2.0.1.0)
- 1.1、Oracle Database 11.2.0.1.0
- 1.2、Oracle Database Grid Infrastructure 11.2.0.1.0
- 1.3、客户端
2、安装文档
3、安装前准备
- 3.1、建立用户和用户组
- 3.2、sysctl
- 3.3、security limits
- 3.4、其他设置
- 3.5、创建安装目录
- 3.6、依赖包安装
- 3.7、解压安装包
- 3.8、环境变量
4、安装
- 4.1、直接使用oracle用户进行ssh登录
- 4.2、执行安装程序
- - 4.2.1、runInstaller
  - 4.2.2、选择安装类型
  - 4.2.3、选择服务器安装还是桌面安装
  - 4.2.4、选择单实例数据库安装或者 Real Application Clusters数据库安装
  - 4.2.5、选择自定义安装类型
  - 4.2.6、选择语言
  - 4.2.7、选择Enterprise Edition
  - 4.2.8、选择安装目录和数据库目录
  - 4.2.9、选择inventory目录
  - 4.2.10、选择数据库用途
  - 4.2.11、数据库名和实例名
  - 4.2.12、内存、字符集、secure、samples
  - 4.2.13、选择database control for database management
  - 4.2.14、Database Storage 默认选择FileSystem
  - 4.2.15、自动备份
  - 4.2.16、设置数据库用户密码
  - 4.2.17、选择OperatingSystemGroup
  - 4.2.18、先决依赖项检查
  - 4.2.19、安装概览
  - 4.2.20、等待安装完成

1、下载oracle 11g (11.2.0.1.0)

1.1、Oracle Database 11.2.0.1.0

https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

V17530-01_1of2.zip		Oracle Database 11.2.0.1.0 for Linux x86-64, 1.2 GBSHA-1		8C0236EDA14D12CA1127418815F027A92D8B407ESHA-256		FF46188AEA66967FFBE1E46A52AC85670A10BC8ACEA78536540C3B00C6D3B5DCV17530-01_2of2.zip		Oracle Database 11.2.0.1.0 for Linux x86-64, 1.0 GBSHA-1		1DB316053728E4A668B96E00ED771A3E40100021SHA-256		008DD2F9D45075CEA9CC745FED8A2CE9E42D53AFC91BB8C75E1620BA4B95F33AV20610-01_1of2.zip		Oracle Database 11.2.0.1.0 for Microsoft Windows x64 (64-bit), 1.1 GBSHA-1		DC3ADE4EB73A2BFDFFAFBC2DED6FB305C33ADF64SHA-256		6B762AF9825EE84565073322E11E941C61A5B3682DA0B990E76C1C5C918CB347V20610-01_2of2.zip		Oracle Database 11.2.0.1.0 for Microsoft Windows x64 (64-bit), 961.3 MBSHA-1		A32056B6645AD4E4C9C9E610827D33D60A0DBBF5SHA-256		7A5C131E48DE5D14FB73E9E89A38A53418777E9359F7930308C256746BA11E2B

linux 安装 oracle 11g

1.2、Oracle Database Grid Infrastructure 11.2.0.1.0

V17531-01.zip		Oracle Database Grid Infrastructure 11.2.0.1.0 for Linux x86-64, 1004.1 MBSHA-1		6DE61906675F1ADA3FB43406E021E8D63185137BSHA-256		698CA21CAA94D58D36F731F235DF06C6BCDF52E6FD32710CD34AEAD6F3404655V20612-01.zip		Oracle Database Grid Infrastructure 11.2.0.1.0 for Microsoft Windows x64 (64-bit), 682.0 MBSHA-1		088EB893AF91F2CC8E09E4AB381AF8850242B416SHA-256		187CA19413E638ADA013525B8F4BA9AA6E80B14D59BF3DDB88B2C8C302E91BDF

linux 安装 oracle 11g

1.3、客户端

V20609-01.zip		Oracle Database Client 11.2.0.1.0 for Microsoft Windows x64 (64-bit), 587.2 MB
SHA-1		6211CE847F39F833635509E5AF410A42501E090C
SHA-256		60063C214CF277A316CF20360F3DE4C7830DA7AA0CA02BC11386EFAA344383F3V20606-01.zip		Oracle Database Client 11.2.0.1.0 for Microsoft Windows (32-bit), 652.9 MB
SHA-1		2D8F8BCA5BC144750C0BFD423A2642FF81755C0B
SHA-256		E50AF6487B3A39E462F2E4D3775C75569665F2ECFFD7D2BF5A3C35C9DA16DC9FV17532-01.zip		Oracle Database Client 11.2.0.1.0 for Linux x86-64, 673.5 MB
SHA-1		0C6320934C79DD303C1CBB775FCD94BE15B9DBDB
SHA-256		6D03E05C0FA3A5F6A0FB6AA75F7B9DCE9E09A31D776516694F7FA6EBCE9BB775V17488-01.zip		Oracle Database Client 11.2.0.1.0 for Linux x86, 612.3 MB
SHA-1		2D41F76D241BBE95828DC7AD53007879BE3C22A8
SHA-256		7F5BC816EC4C6D272DBA2D165E9AA971C47781363954B7986D4634AB4F7653E2

linux 安装 oracle 11g

2、安装文档

在debian 上安装
https://wiki.debian.org/OracleDB

3、安装前准备

3.1、建立用户和用户组

addgroup --system oinstall
addgroup --system dba
adduser --system --ingroup oinstall --shell /bin/bash oracle
adduser oracle dba

linux 安装 oracle 11g

3.2、sysctl

vi /etc/sysctl.d/local-oracle.conf

插入如下内容

fs.file-max = 65536
fs.aio-max-nr = 1048576
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
# (Oracle recommends total machine Ram -1 byte)
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.shmmni = 4096
net.ipv4.ip_local_port_range = 1024 65000
vm.hugetlb_shm_group = 111
vm.nr_hugepages = 64

vm.hugetlb_shm_group 的值是dba的组号

cat /etc/group|grep dba

让配置生效

sysctl -p /etc/sysctl.d/local-oracle.conf

3.3、security limits

vi /etc/security/limits.d/local-oracle.conf

插入如下内容

oracle          soft    nproc           2047
oracle          hard    nproc           16384
oracle          soft    nofile          1024
oracle          hard    nofile          65536
oracle          soft    memlock         204800
oracle          hard    memlock         204800

重启系统让配置生效

3.4、其他设置

ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /usr/lib/x86_64-linux-gnu /usr/lib64
awk is used by the final scripts to parse username/groups and change permissions, it works without it, but better be safe than sorry. Do not remove this symbolic link after installation as several commonly used utilities require it.

basename and rpm are used during installation.

lib64 is needed by binaries from Oracle RPM packages in multiarch systems.

3.5、创建安装目录

mkdir -p /opt/oracle/product/11.2.0.1.0/dbhome
mkdir -p /opt/oraInventory
chown -R oracle:dba /opt/oracle/
chown -R oracle:dba /opt/oraInventory

3.6、依赖包安装

apt -y install build-essential binutils libcap-dev gcc g++ libc6-dev ksh libaio-dev make libxi-dev libxtst-dev libxau-dev libxcb1-dev sysstat rpm xauth unzip gcc-multilib

build-essential gcc-multilib ia32-libs libaio1 libstdc++5 rpm are dependencies of Oracle either direct or indirect because of 32-bit and 64-bit mess. And yes, I tried to install without any extra packages and only installed what was necessary to fix a given problem.xauth will make the X11 forwarding magic happen.

3.7、解压安装包

su - oracle

unzip V17530-01_1of2.zip
unzip V17530-01_2of2.zip

3.8、环境变量

su - oracle

export ORACLE_HOSTNAME=localhost
export ORACLE_OWNER=oracle
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/11.2.0.1.0/dbhome
export ORACLE_UNQNAME=orcl
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/x86_64-linux-gnu:/lib/x86_64-linux-gnu/:/usr/lib64

ORACLE_OWNER: User with permission on Oracle files.
ORACLE_BASE: Directory that will store the distinct Oracle Services.
ORACLE_HOME: Directory that will store the Oracle database.
ORACLE_UNQNAME: Unique name of database.
ORACLE_SID: Service Identifier of Listener.
PATH: Path to binary files.
LD_LIBRARY_PATH: Path to library.