linux系统 oracle 11g字符界面详细安装过程

oracle 11g字符界面详细安装过程

1. 修改主机名 

sed -i "s/HOSTNAME=localhost.localdomain/HOSTNAME=oracledb/"

 

2./etc/sysconfig/network //注意替换主机名

hostname oracledb

3.添加主机名与IP对应记录

vi /etc/hosts

172.16.210.224 oracledb

4. 关闭Selinux

sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config

setenforce 0

5. 创建用户和组(root用户：创建Oracle安装组oinstall,数据库管理员组dba，及oracle用户)

\#

groupadd -g 200 oinstall

groupadd -g 201 dba

useradd -u 440 -g oinstall -G dba oracle （主组oinstall，其它组：dba）

passwd oracle \#(P)

6. 修改内核参数(root用户：修改 /etc/sysctl.conf 文件，加上如下参数)

    vi /etc/sysctl.conf


    net.ipv4.ip_local_port_range= 9000 65500
    fs.file-max = 6815744
    kernel.shmall = 10523004
    kernel.shmmax = 6465333657
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100128
    net.core.rmem_default=262144
    net.core.wmem_default=262144
    net.core.rmem_max=4194304
    net.core.wmem_max=1048576
    fs.aio-max-nr = 1048576


    \# sysctl -p \#使配置生效

7. 修改系统资源限制（root用户：修改 /etc/security/limits.conf
文件，加上下面的参数）

vi /etc/security/limits.conf

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

8.修改用户验证选项（root用户下：修改/etc/pam.d/login文件加上如下参数）

vi /etc/pam.d/login

\#\#session required pam_namespace.so \#下面添加一条pam_limits.so
session required pam_limits.so

9.创建安装目录及设置权限

mkdir -p /opt/app/oracle/

chmod 755 /opt/app/oracle/

chown oracle.oinstall -R /opt/app/oracle/

10.设置oracle环境变量

使用oracle账户

su - oracle

vi \~/.bash_profile

\#设置oracle

export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1
export PATH=\$PATH:\$ORACLE_HOME/bin
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/usr/lib:/usr/lib64

11.在/opt目录下 解压oracle软件

上传包至/opt目录，并且修改相应权限

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

chown oracle.oinstall -R /opt/database/

12.检查安装依赖包

Linux 7
https://download.csdn.net/download/ukakasu/10490472

binutils-2.23.52.0.1-12.el7.x86_64

compat-libcap1-1.10-3.el7.x86_64

compat-libstdc++-33-3.2.3-71.el7.i686

compat-libstdc++-33-3.2.3-71.el7.x86_64

gcc-4.8.2-3.el7.x86_64

gcc-c++-4.8.2-3.el7.x86_64

glibc-2.17-36.el7.i686

glibc-2.17-36.el7.x86_64

glibc-devel-2.17-36.el7.i686

glibc-devel-2.17-36.el7.x86_64

ksh

libaio-0.3.109-9.el7.i686

libaio-0.3.109-9.el7.x86_64

libaio-devel-0.3.109-9.el7.i686

libaio-devel-0.3.109-9.el7.x86_64

libgcc-4.8.2-3.el7.i686

libgcc-4.8.2-3.el7.x86_64

libstdc++-4.8.2-3.el7.i686

libstdc++-4.8.2-3.el7.x86_64

libstdc++-devel-4.8.2-3.el7.i686

libstdc++-devel-4.8.2-3.el7.x86_64

libXi-1.7.2-1.el7.i686

libXi-1.7.2-1.el7.x86_64

libXtst-1.2.2-1.el7.i686

libXtst-1.2.2-1.el7.x86_64

make-3.82-19.el7.x86_64

sysstat-10.1.5-1.el7.x86_64

linux 7

binutils-2.20.51.0.2-5.11.el6 (x86_64)

compat-libcap1-1.10-1 (x86_64)

compat-libstdc++-33-3.2.3-69.el6 (x86_64)

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.4-13.el6 (x86_64)

gcc-c++-4.4.4-13.el6 (x86_64)

glibc-2.12-1.7.el6 (i686)

glibc-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6.i686

ksh

libgcc-4.4.4-13.el6 (i686)

libgcc-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6 (x86_64)

libstdc++-devel-4.4.4-13.el6.i686

libaio-0.3.107-10.el6 (x86_64)

libaio-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6 (x86_64)

libaio-devel-0.3.107-10.el6.i686

make-3.81-19.el6

sysstat-9.0.4-11.el6 (x86_64)

rpm -q binutils compat-libstdc++-33 elfutils elfutils-libelf-devel gcc gcc-c++
glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc
libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel |grep “is not
installed”

yum install binutils compat-libstdc++-33 elfutils elfutils-libelf-devel gcc
gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc
libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

______________________________________________________________________________________________________________________________________________

13.修改配置文件 su - oracle

备份/opt/database/response目录

修改/opt/database/response/db_install.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=pcs6.ambari

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/opt/app/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1

ORACLE_BASE=/opt/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=false

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

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

oracle.install.db.CLUSTER_NODES=

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

oracle.install.db.config.starterdb.globalDBName=orcl

oracle.install.db.config.starterdb.SID=orcl

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

oracle.install.db.config.starterdb.memoryOption=true

oracle.install.db.config.starterdb.memoryLimit=1500

oracle.install.db.config.starterdb.installExampleSchemas=false

oracle.install.db.config.starterdb.enableSecuritySettings=true

oracle.install.db.config.starterdb.password.ALL=oracle

oracle.install.db.config.starterdb.password.SYS=

oracle.install.db.config.starterdb.password.SYSTEM=

oracle.install.db.config.starterdb.password.SYSMAN=

oracle.install.db.config.starterdb.password.DBSNMP=

oracle.install.db.config.starterdb.control=DB_CONTROL

oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

oracle.install.db.config.starterdb.dbcontrol.emailAddress=

oracle.install.db.config.starterdb.dbcontrol.SMTPServer=

oracle.install.db.config.starterdb.automatedBackup.enable=false

oracle.install.db.config.starterdb.automatedBackup.osuid=

oracle.install.db.config.starterdb.automatedBackup.ospwd=

oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

oracle.install.db.config.asm.diskGroup=

oracle.install.db.config.asm.ASMSNMPPassword=

MYORACLESUPPORT_USERNAME=

MYORACLESUPPORT_PASSWORD=

SECURITY_UPDATES_VIA_MYORACLESUPPORT=

DECLINE_SECURITY_UPDATES=true

PROXY_HOST=

PROXY_PORT=

PROXY_USER=

PROXY_PWD=

____________________________________________________________________________________________________________________________

14.修改/opt/database/response/dbca.rsp

GDBNAME = “orcl”   全局数据库的名字=SID

SID=”orcl” 149行 SID

CHARACTERSET=”AL32UTF8” //  编码 修改并去掉注释

NATIONALCHARACTERSET=”UTF8” //  编码 修改并去掉注释

____________________________________________________________________________________________________________________________

15.安装数据库服务

/opt/database/runInstaller -silent -force -ignorePrereq -responseFile
/opt/database/response/db_install.rsp

如果报错添加 -ignorePrereq //忽略错误

$ORACLE_HOME/bin/netca /silent /responseFile /opt/database/response/netca.rsp

$ORACLE_HOME/bin/dbca -silent -responseFile /opt/database/response/dbca.rsp
-sysPassword oracle -systemPassword oracle

16.创建表空间及用户

sqlplus sys/oracle as sysdba

CREATE TABLESPACE suanfa LOGGING DATAFILE
‘/opt/app/oracle/oradata/ora11g/suanfa1.dbf’ SIZE 10240M AUTOEXTEND ON NEXT 32M
EXTENT MANAGEMENT LOCAL;

CREATE USER taizhou IDENTIFIED BY taizhou DEFAULT TABLESPACE suanfa TEMPORARY
TABLESPACE TEMP;

grant connect,resource,dba to taizhou;

grant create session to taizhou;