Oracle Silent Installation and oracle Silent Installation
The RHEL6 + oracle11.2 installation without interface commands is as follows:
1. Check the required installation package:
Yum install binutils-2. * compat-libcap1 * compat-libstdc ++-33-* gcc-4 .*
Gcc-c ++-4. * glibc-2. * glibc-devel-2. * libgcc-4. * libstdc ++-4 .*
Libstdc ++-devel-4. * libaio-. * libaio-devel-0. * make-3. * sysstat-9 .*
UnixODBC-2. * unixODBC-devel-2. * libXp * pdksh -*
Rpm-qa binutils compat-libstdc ++ elfutils-libelf-devel gcc-c ++ glibc
Rpm-qa glibc-common glibc-devel glibc-headers ksh libaio-devel libgcc libstdc ++-devel make numactl-devel sysstat
2.1 oracle and grid User Creation:
Groupadd oinstall
Groupadd dba
Useradd-m-g oinstall-G dba oracle
Echo oracle | passwd -- stdin oracle
3. User variable Configuration:
Oracle user environment variables:
Su-oracle
$ Vi. bash_profile
Umask 022
ORACLE_SID = testdb
ORACLE_BASE =/u01/app/oracle
ORACLE_HOME = $ ORACLE_BASE/product/11.2.0.4.0/dbhome_1
PATH = $ ORACLE_HOME/bin: $ PATH
Export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Export ORACLE_SID ORACLE_BASE ORACLE_HOME PATH
4. Set the user limit file:
/Etc/security/limits. conf
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Oracle soft stack 10240
5. login configuration:
/Etc/pam. d/login
Session required pam_limits.so
6. Set system global variables:
/Etc/profile
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
7. System Kernel Parameter Configuration:
/Etc/sysctl. conf
Fs. aio-max-nr = 1048576
Fs. file-max = 6815744
Kernel. shmall = 4194304
Kernel. shmmax = 536870912
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Net. ipv4.ip _ local_port_range = 9000 65500 #1024 65000
Net. core. rmem_default = 262144
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048586
# Sysctl-p
Net. ipv4.ip _ forward = 0
Net. ipv4.conf. default. rp_filter = 1
Net. ipv4.conf. all. rp_filter = 1
Net. ipv4.conf. all. arp_announce = 2
Net. ipv4.conf. all. arp_ignore = 1
Net. ipv4.conf. default. accept_source_route = 0
Kernel. sysrq = 0
Kernel. core_uses_pid = 1
Net. ipv4.tcp _ syncookies = 1
Kernel. msgmnb = 65536
Kernel. msgmax = 65536
Kernel. shmmax = 68719476736
Kernel. shmall = 12884901888
Net. ipv4.tcp _ max_tw_buckets = 1000
Net. ipv4.tcp _ sack = 1
Net. ipv4.tcp _ window_scaling = 1
Net. ipv4.tcp _ rmem = 4096 87380 4194304
Net. ipv4.tcp _ wmem = 4096 16384 4194304
Net. core. wmem_default = 8388608
Net. core. rmem_default = 8388608
Net. core. rmem_max = 16777216
Net. core. wmem_max = 16777216
Net. core. netdev_max_backlog = 262144
Net. core. somaxconn = 262144
Net. ipv4.tcp _ max_orphans = 3276800
Net. ipv4.tcp _ max_syn_backlog = 262144
Net. ipv4.tcp _ timestamps = 0
Net. ipv4.tcp _ synack_retries = 1
Net. ipv4.tcp _ syn_retries = 1
Net. ipv4.tcp _ retries2 = 5
Net. ipv4.tcp _ tw_recycle = 0
Net. ipv4.tcp _ tw_reuse = 0
Net. ipv4.tcp _ mem = 94500000 915000000 927000000
Net. ipv4.ip _ local_port_range = 1024 65535
Net. ipv4.ip _ local_reserved_ports = 8080-8081,11200-11611,6379-6389,10050-10051
Net. nf_conntrack_max = 409600
Net. netfilter. nf_conntrack_tcp_timeout_established = 600
Net. netfilter. nf_conntrack_max = 409600
Net. netfilter. nf_conntrack_buckets = 8192
Net. netfilter. nf_conntrack_tcp_timeout_time_wait = 1
8. Disable firewall and seliunx
Service iptables stop
Chkconfig iptables off
9. Create an oracle installation directory and permissions
Mkdir-p/u01/app/oracle
Chown-R oracle. oinstall/u01/app/oracle
Chmod 775/u01/app/oracle
Mkdir-p/u01/app/oracle/oradata
Chown-R oracle: oinstall/u01/app/oracle/oradata
Chmod 775/u01/app/oracle/oradata
Mkdir-p/u01/app/oraInventory
Chown-R oracle: oinstall/u01/app/oraInventory
Chmod 775/u01/app/oraInventory
Mkdir-p/u01/app/oracle/product/11.2.0.4.0/dbhome_1
Chown-R oracle: oinstall/u01/app/oracle/product/11.2.0.4.0/dbhome_1
Chmod 775/u01/app/oracle/product/11.2.0.4.0/dbhome_1
10. Silent Installation of database software:
Unzip the installation package:
Unzip p13390677_112040_Linux-x86-64_1of7.zip
Unzip p13390677_112040_Linux-x86-64_2of7.zip
Copy the decompressed Installation File database to/u01/app/, or directly use the rsp file in the directory for modification.
Cp 51db_install.rsp/u01/app/database/response/
Cp 51dbca. rsp/u01/app/database/response/
Modify 51db_install.rsp 51dbca. rsp to modify SID, DBNAME, path, and so on. The installation directory is/u01/app/oracle/oradata.
Start to install the oracle software through the rsp response file:
$./RunInstaller-silent-force-responseFile/u01/app/database/response/51db_install.rsp
Wait for a while and check the prompt.As prompted, two scripts will be executed with the root permission. After the successful appearance, you can.
Create a database using the rsp response file:
Vi 51dbca. rsp
Silent instance installation [Where to modify]
Configure dbca. rpt before installing the instance. The configuration items are as follows:
GDBNAME = "testdb" (Unique Identifier of the database)
SID = "testdb" (database instance name)
CHARACTERSET = "ZHS16GBK" (database character set) -- CHARACTERSET = "AL32UTF8" (updated, supports more characters, supports 9i and later) -- CHARACTERSET = "UTF8" (older, support 8i)
TOTALMEMORY = "10240" (database memory, currently 10 Gb, unit: MB)
If you want to use OEM, You need to modify
EMCONFIGURATION = "LOCAL ",
SYSMANPASSWORD = "oracle"
DBSNMPPASSWORD = "oracle"
Configure and perform Silent Installation
Start Database Installation
/U01/app/oracle/product/11.2.0.4.0/dbhome_1/bin/dbca-silent-responseFile/u01/app/database/response/51dbca. rsp
Enter the password twice as prompted. The installation progress is displayed.
The installation is complete.
========================================================== ========================================================== ==========
Create a listener:
Listener Configuration: [add all, server, client]
Server:
Cd/u01/app/oracle/product/11.2.0.4.0/dbhome_1/network/admin
Vi listener. ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cleardb)
(ORACLE_HOME =/u01/app/oracle/product/11.2/db_1)
(SID_NAME = testdb)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172. **) (PORT = 1521 ))
)
Client:
Vi tnsnames. ora
TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172. **) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)
LISTENER_CLEARDB =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172. **) (PORT = 1521 ))
Start listening lsnrdbms start
-Bash-4.1 $ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0-Production on 27-APR-2015 18:37:07
Copyright (c) 1991,201 3, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172. **) (PORT = 1521 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0-Production
Start Date 27-APR-2015 17:58:52
Uptime 0 days 0 hr. 38 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = localhost) (PORT = 1521 )))
Services Summary...
Service "autoa" has 1 instance (s ).
Instance "autoa", status READY, has 1 handler (s) for this service...
Service "autoaXDB" has 1 instance (s ).
Instance "autoa", status READY, has 1 handler (s) for this service...
The command completed successfully