RedHat 7 靜默安裝Oracle11g

甲骨文技術支援發表於2018-01-29
安裝環境:

主機:浪潮NF5270M4 CPU2; MEM128G

作業系統Red Hat Enterprise Linux Server release 7.2 (Maipo)
安裝介質:

p13390677_112040_LINUX_1of7.zip

資料庫基礎包

p13390677_112040_LINUX_2of7.zip

資料庫基礎包

IP分配:

主機名

主機IP

crm_db

192.168.2.36

安裝目錄:

oracle軟體

/home/app/oracle/11.2.0/db_1

修改/etc/hosts 檔案:

[root@crm_db home]# vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.2.36 crm_db

新增組和使用者:

[root@crm_db home]#  groupadd -g 1001 oinstall

[root@crm_db home]# groupadd -g 1100 dba

[root@crm_db home]# useradd -m -g oinstall -G dba -u 1200 oracle

[root@crm_db home]# passwd oracle

zh;92YjrC

建立目錄:


[root@crm_db home]# mkdir -p /home/app/oracle/product/11.2.0/db_1

[root@crm_db home]# chown -R oracle:oinstall /app

修改系統引數:

[root@crm_db home]#  vi /etc/security/limits.conf

#ORACLE SETTING

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft memlock -1

oracle hard memlock -1


[root@crm_db home]# vi /etc/pam.d/login

#%PAM-1.0

auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so

auth       include      system-auth

account    required     pam_nologin.so

account    include      system-auth

password   include      system-auth

# pam_selinux.so close should be the first session rule

session    required     pam_selinux.so close

session    required     pam_loginuid.so

session    optional     pam_console.so

# pam_selinux.so open should only be followed by sessions to be executed in the user context

session    required     pam_selinux.so open

session    required     pam_namespace.so

session    optional     pam_keyinit.so force revoke

session    include      system-auth

-session   optional     pam_ck_connector.so

#ORACLE SETTING

session    required     pam_limits.so


[root@crm_db home]# vi /usr/lib/sysctl.d/00-system.conf

#ORACLE SETTING

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 33554432

kernel.shmmax = 89060441849

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

vm.nr_hugepages = 3876


[root@crm_db home]#  vi /etc/selinux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

#     enforcing - SELinux security policy is enforced.

#     permissive - SELinux prints warnings instead of enforcing.

#     disabled - No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:

#     targeted - Targeted processes are protected,

#     mls - Multi Level Security protection.

SELINUXTYPE=targeted

關閉防火牆:

systemctl stop firewalld.service
systemctl disable firewalld

檢查安裝包:

[root@crm_db home]#rpm -q binutils compat-libcap1 compat-libstdc++ gcc gcc-c++  glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

安裝缺少的安裝包:

mount /dev/cdrom /mnt

[root@oracleserver1 u01]# cd /mnt

[root@oracleserver1 mnt]# cd Packages/

rpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpm

配置使用者環境變數:

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

ORACLE_SID=oracrm; export ORACLE_SID

ORACLE_BASE=/home/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME

ORACLE_UNQNAME=oracleserver; export ORACLE_UNQNAME

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG

ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

THREADS_FLAG=native; export THREADS_FLAG

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

if [ $USER = "oracle" ] || [ $USER = "grid" ]; then

        if [ $SHELL = "/bin/ksh" ]; then

         ulimit -p 16384

              ulimit -n 65536

        else

              ulimit -u 16384 -n 65536

        fi

        umask 022

fi

重啟作業系統


shutdown -r now

安裝資料庫軟體,不建庫

1.編輯db_install.rsp檔案,可以複製一份出來,把原來的清理掉,然後輸入以下內容:

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

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=crm_db

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/home/app/oraInventory

SELECTED_LANGUAGES=en

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

ORACLE_BASE=/home/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.EEOptionsSelection=false

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

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

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

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

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

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

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

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

oracle.installer.autoupdates.option=SKIP_UPDATES

#iSECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

2,看到讓用root使用者執行兩個指令碼的提示後,把指令碼執行完,軟體就安裝完成了。

建立資料庫:

編輯

dbca.rsp

指令碼:

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "oracrm"

SID = "oracrm"

TEMPLATENAME = "General_Purpose.dbc"

CHARACTERSET = "AL32UTF8"


建立監聽:

netca /silent /responseFile /home/oraclesoftware/netca.rsp



以上資料庫就建立完成了,可以進去修改oracle引數了。











來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20893244/viewspace-2150625/,如需轉載,請註明出處,否則將追究法律責任。

相關文章