English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية
Experimental Environment:
1Install the required software packages for oracle:
Oracle 12The following rpm packages are required for c:
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) libXext-1.1 (x86_64) libXext-1.1 (i686) libXtst-1.0.99.2 (x86_64) libXtst-1.0.99.2 (i686) libX11-1.3 (x86_64) libX11-1.3 (i686) libXau-1.0.5 (x86_64) libXau-1.0.5 (i686) libxcb-1.5 (x86_64) libxcb-1.5 (i686) libXi-1.3 (x86_64) libXi-1.3 (i686) make-3.81-19.el6 sysstat-9.0.4-11.el6 (x86_64)
[root@ser6-51 mongodb]# yum install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat
Loaded plugins: fastestmirror, security Determining fastest mirrors * base: mirrors.163.com * extras: mirrors.aliyun.com * updates: mirrors.163.com base | 3.7 kB 00:00 extras | 3.4 kB 00:00 updates | 3.4 kB 00:00 updates/primary_db | 3.9 MB 00:04 Setting up Install Process Package gcc-4.4.7-11.el6.x86_64 already installed and latest version Package gcc-c++-4.4.7-11.el6.x86_64 already installed and latest version Package libgcc-4.4.7-11.el6.x86_64 already installed and latest version Package libstdc++-4.4.7-11.el6.x86_64 already installed and latest version Package libstdc++-devel-4.4.7-11.el6.x86_64 already installed and latest version Package libaio-0.3.107-10.el6.x86_64 already installed and latest version Package libXau-1.0.6-4.el6.x86_64 already installed and latest version Package 1:make-3.81-20.el6.x86_64 already installed and latest version Resolving Dependencies --> Running transaction check ---> Package binutils.x86_64 0:2.20.51.0.2-5.36.el6 will be updated ---> Package binutils.x86_64 0:2.20.51.0.2-5.42.el6 will be an update ---> Package compat-libcap1.x86_64 0:1.10-1 will be installed ---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed ---> Package glibc.x86_64 0:2.12-1.132.el6 will be updated --> Processing Dependency: glibc = 2.12-1.132.el6 for package: glibc-headers-2.12-1.132.el6.x86_64 --> Processing Dependency: glibc = 2.12-1.132.el6 for package: glibc-common-2.12-1.132.el6.x86_64 ---> Package glibc.x86_64 0:2.12-1.149.el6_6.9 will be an update ---> Package glibc-devel.x86_64 0:2.12-1.132.el6 will be updated ---> Package glibc-devel.x86_64 0:2.12-1.149.el6_6.9 will be an update ---> Package ksh.x86_64 0:20120801-21.el6_6.3 will be installed ---> Package libX11.x86_64 0:1.5.0-4.el6 will be updated ---> Package libX11.x86_64 0:1.6.0-2.2.el6 will be an update --> Processing Dependency: libX11-common = 1.6.0-2.2.el6 for package: libX11-1.6.0-2.2.el6.x86_64 ---> Package libXext.x86_64 0:1.3.1-2.el6 will be updated ---> Package libXext.x86_64 0:1.3.2-2.1.el6 will be an update ---> Package libXi.x86_64 0:1.6.1-3.el6 will be updated ---> Package libXi.x86_64 0:1.7.2-2.2.el6 will be an update ---> Package libXtst.x86_64 0:1.2.1-2.el6 will be updated ---> Package libXtst.x86_64 0:1.2.2-2.1.el6 will be an update ---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed ---> Package libxcb.x86_64 0:1.8.1-1.el6 will be updated ---> Package libxcb.x86_64 0:1.9.1-2.el6 will be an update ---> Package sysstat.x86_64 0:9.0.4-22.el6 will be updated ---> Package sysstat.x86_64 0:9.0.4-27.el6 will be an update --> Running transaction check ---> Package glibc-common.x86_64 0:2.12-1.132.el6 will be updated ---> Package glibc-common.x86_64 0:2.12-1.149.el6_6.9 will be an update ---> Package glibc-headers.x86_64 0:2.12-1.132.el6 will be updated ---> Package glibc-headers.x86_64 0:2.12-1.149.el6_6.9 will be an update ---> Package libX11-common.noarch 0:1.5.0-4.el6 will be updated ---> Package libX11-common.noarch 0:1.6.0-2.2.el6 will be an update --> Finished Dependency Resolution Dependencies Resolved ========================================================================================================================================================================================================= Package Arch Version Repository Size ========================================================================================================================================================================================================= Installing: compat-libcap1 x86_64 1.10-1 base 17 k compat-libstdc++-33 x86_64 3.2.3-69.el6 base 183 k ksh x86_64 20120801-21.el6_6.3 updates 758 k libaio-devel x86_64 0.3.107-10.el6 base 13 k Updating: binutils x86_64 2.20.51.0.2-5.42.el6 base 2.8 M glibc x86_64 2.12-1.149.el6_6.9 updates 3.8 M glibc-devel x86_64 2.12-1.149.el6_6.9 updates 984 k libX11 x86_64 1.6.0-2.2.el6 base 586 k libXext x86_64 1.3.2-2.1.el6 base 35 k libXi x86_64 1.7.2-2.2.el6 base 37 k libXtst x86_64 1.2.2-2.1.el6 base 19 k libxcb x86_64 1.9.1-2.el6 base 110 k sysstat x86_64 9.0.4-27.el6 base 233 k Updating for dependencies: glibc-common x86_64 2.12-1.149.el6_6.9 updates 14 M glibc-headers x86_64 2.12-1.149.el6_6.9 updates 612 k libX11-common noarch 1.6.0-2.2.el6 base 192 k Transaction Summary ========================================================================================================================================================================================================= Install 4 Package(s) Upgrade 12 Package(s) Total download size: 24 M Is this ok [y/N]: y Downloading Packages: (1/16): binutils-2.20.51.0.2-5.42.el6.x86_64.rpm | 2.8 MB 00:02 (2/16): compat-libcap1-1.10-1.x86_64.rpm | 17 kB 00:00 (3/16): compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm | 183 kB 00:00 (4/16): glibc-2.12-1.149.el6_6.9.x86_64.rpm | 3.8 MB 00:05 (5/16): glibc-common-2.12-1.149.el6_6.9.x86_64.rpm | 14 MB 00:13 (6/16): glibc-devel-2.12-1.149.el6_6.9.x86_64.rpm | 984 kB 00:02 (7/16): glibc-headers-2.12-1.149.el6_6.9.x86_64.rpm | 612 kB 00:01 (8/16): ksh-20120801-21.el6_6.3.x86_64.rpm | 758 kB 00:01 (9/16): libX11-1.6.0-2.2.el6.x86_64.rpm | 586 kB 00:01 (10/16): libX11-common-1.6.0-2.2.el6.noarch.rpm | 192 kB 00:00 (11/16): libXext-1.3.2-2.1.el6.x86_64.rpm | 35 kB 00:00 (12/16): libXi-1.7.2-2.2.el6.x86_64.rpm | 37 kB 00:00 (13/16): libXtst-1.2.2-2.1.el6.x86_64.rpm | 19 kB 00:00 (14/16): libaio-devel-0.3.107-10.el6.x86_64.rpm | 13 kB 00:00 (15/16): libxcb-1.9.1-2.el6.x86_64.rpm | 110 kB 00:00 (16/16): sysstat-9.0.4-27.el6.x86_64.rpm | 233 kB 00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 712 kB/s | 24 MB 00:35 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Updating : glibc-common-2.12-1.149.el6_6.9.x86_64 1/28 Updating : glibc-2.12-1.149.el6_6.9.x86_64 2/28 Updating : glibc-headers-2.12-1.149.el6_6.9.x86_64 3/28 Updating : libxcb-1.9.1-2.el6.x86_64 4/28 Updating : libX11-common-1.6.0-2.2.el6.noarch 5/28 Updating : libX11-1.6.0-2.2.el6.x86_64 6/28 Updating : libXext-1.3.2-2.1.el6.x86_64 7/28 Updating : libXi-1.7.2-2.2.el6.x86_64 8/28 Updating : libXtst-1.2.2-2.1.el6.x86_64 9/28 Updating : glibc-devel-2.12-1.149.el6_6.9.x86_64 10/28 Installing : compat-libcap1-1.10-1.x86_64 11/28 Updating : sysstat-9.0.4-27.el6.x86_64 12/28 Installing : ksh-20120801-21.el6_6.3.x86_64 13/28 Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64 14/28 Updating : binutils-2.20.51.0.2-5.42.el6.x86_64 15/28 Installing : libaio-devel-0.3.107-10.el6.x86_64 16/28 Cleanup : glibc-devel-2.12-1.132.el6.x86_64 17/28 Cleanup : libXtst-1.2.1-2.el6.x86_64 18/28 Cleanup : glibc-headers-2.12-1.132.el6.x86_64 19/28 Cleanup : libXi-1.6.1-3.el6.x86_64 20/28 Cleanup : libXext-1.3.1-2.el6.x86_64 21/28 Cleanup : libX11-1.5.0-4.el6.x86_64 22/28 Cleanup : libxcb-1.8.1-1.el6.x86_64 23/28 Cleanup : binutils-2.20.51.0.2-5.36.el6.x86_64 24/28 Cleanup : sysstat-9.0.4-22.el6.x86_64 25/28 Cleanup : libX11-common-1.5.0-4.el6.noarch 26/28 Cleanup : glibc-common-2.12-1.132.el6.x86_64 27/28 Cleanup : glibc-2.12-1.132.el6.x86_64 28/28 Verifying : glibc-devel-2.12-1.149.el6_6.9.x86_64 1/28 Verifying : libaio-devel-0.3.107-10.el6.x86_64 2/28 Verifying : libX11-1.6.0-2.2.el6.x86_64 3/28 Verifying : compat-libcap1-1.10-1.x86_64 4/28 Verifying : libXext-1.3.2-2.1.el6.x86_64 5/28 Verifying : glibc-2.12-1.149.el6_6.9.x86_64 6/28 Verifying : sysstat-9.0.4-27.el6.x86_64 7/28 Verifying : ksh-20120801-21.el6_6.3.x86_64 8/28 Verifying : compat-libstdc++-33-3.2.3-69.el6.x86_64 9/28 Verifying : glibc-headers-2.12-1.149.el6_6.9.x86_64 10/28 Verifying : binutils-2.20.51.0.2-5.42.el6.x86_64 11/28 Verifying : libXtst-1.2.2-2.1.el6.x86_64 12/28 Verifying : libXi-1.7.2-2.2.el6.x86_64 13/28 Verifying : glibc-common-2.12-1.149.el6_6.9.x86_64 14/28 Verifying : libxcb-1.9.1-2.el6.x86_64 15/28 Verifying : libX11-common-1.6.0-2.2.el6.noarch 16/28 Verifying : glibc-2.12-1.132.el6.x86_64 17/28 Verifying : glibc-devel-2.12-1.132.el6.x86_64 18/28 Verifying : glibc-headers-2.12-1.132.el6.x86_64 19/28 Verifying : glibc-common-2.12-1.132.el6.x86_64 20/28 Verifying : binutils-2.20.51.0.2-5.36.el6.x86_64 21/28 Verifying : libXi-1.6.1-3.el6.x86_64 22/28 Verifying : libX11-common-1.5.0-4.el6.noarch 23/28 Verifying : sysstat-9.0.4-22.el6.x86_64 24/28 Verifying : libxcb-1.8.1-1.el6.x86_64 25/28 Verifying : libXtst-1.2.1-2.el6.x86_64 26/28 Verifying : libX11-1.5.0-4.el6.x86_64 27/28 Verifying : libXext-1.3.1-2.el6.x86_64 28/28 Installed: compat-libcap1.x86_64 0:1.10-1 compat-libstdc++-33.x86_64 0:3.2.3-69.el6 ksh.x86_64 0:20120801-21.el6_6.3 libaio-devel.x86_64 0:0.3.107-10.el6 Updated: binutils.x86_64 0:2.20.51.0.2-5.42.el6 glibc.x86_64 0:2.12-1.149.el6_6.9 glibc-devel.x86_64 0:2.12-1.149.el6_6.9 libX11.x86_64 0:1.6.0-2.2.el6 libXext.x86_64 0:1.3.2-2.1.el6 libXi.x86_64 0:1.7.2-2.2.el6 libXtst.x86_64 0:1.2.2-2.1.el6 libxcb.x86_64 0:1.9.1-2.el6 sysstat.x86_64 0:9.0.4-27.el6 Dependency Updated: glibc-common.x86_64 0:2.12-1.149.el6_6.9 glibc-headers.x86_64 0:2.12-1.149.el6_6.9 libX11-common.noarch 0:1.6.0-2.2.el6 Complete!
Verify that the system dependency packages required by Oracle are complete.
[root@ser6-51 mongodb]# rpm -qa binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat
libgcc-4.4.7-11.el6.x86_64 libstdc++-4.4.7-11.el6.x86_64 gcc-c++-4.4.7-11.el6.x86_64 glibc-2.12-1.149.el6_6.9.x86_64 libX11-1.6.0-2.2.el6.x86_64 glibc-devel-2.12-1.149.el6_6.9.x86_64 compat-libstdc++-33-3.2.3-69.el6.x86_64 make-3.81-20.el6.x86_64 libaio-0.3.107-10.el6.x86_64 libXau-1.0.6-4.el6.x86_64 libstdc++-devel-4.4.7-11.el6.x86_64 libXext-1.3.2-2.1.el6.x86_64 libXtst-1.2.2-2.1.el6.x86_64 compat-libcap1-1.10-1.x86_64 ksh-20120801-21.el6_6.3.x86_64 binutils-2.20.51.0.2-5.42.el6.x86_64 gcc-4.4.7-11.el6.x86_64 libxcb-1.9.1-2.el6.x86_64 libXi-1.7.2-2.2.el6.x86_64 sysstat-9.0.4-27.el6.x86_64 libaio-devel-0.3.107-10.el6.x86_64
2Configure OS
2.1 Create related users and user groups
groupadd oinstall
groupadd oper
groupadd dba
useradd -g oinstall -G dba,oper oracle
2.2 Modify the password of the oracle user
passwd oracle
2.3 Modify system parameters
vi /etc/sysctl.conf
Add:
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 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
Run sysctl -Apply the above parameters
/sbin/sysctl -p
2.4 Modify user Limits
vi /etc/security/limits.conf
Add the following content:
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle stack nproc 10240
oracle stack nproc 10240
2.5 Create related directories
mkdir -p /u01/app/oracle/product/12c/db_1
mkdir –p /u01/app/oracle/oradata
mkdir –p /u01/app/oracle/flash_recovery_area
mkdir -p /u01/app/oracle/archlog
chown -R oracle:oinstall /u01
2.6 Configure environment variables
su - oracle
vi .bash_profile
Add:
# Oracle Settings COLUMNS=132; export COLUMNS LINES=47; export LINES EDITOR=vi; export EDITOR TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12c/db_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID SHLIB_PATH=$LD_LIBRARY_PATH;export SHLIB_PATH NLS_LANG=American_America.zhs16gbk;export NLS_LANG ORA_NLS10=$ORACLE_HOME/nls/data;export ORA_NLS10 TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN 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 alias glance=/opt/perf/bin/glance:x alias gohome='cd /u01/app/oracle/product/10.2.0' alias cdb='cd /u01/app/oracle/admin/orcl/bdump' alias cdu='cd /u01/app/oracle/admin/orcl/udump'
--The content inside can be modified according to the actual situation, such as changing ORACLE_SID.
After modification, use: source .bash_profile to take effect.
2.7Modify/etc/hosts
[oracle@ser6-51 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
[oracle@ser6-51 ~]$ hostname
ser6-51
Modify127.0.0.1that line to:127.0.0.1 ser6-51
2.8Modify the operating system distribution version
Since Oracle has not yet released installation packages supported by CentOS, you need to modify the distribution version to pass the Oracle installation check.
vi /etc/redhat-release
Modify CentOS release 6.5 (Final) Comment out and add a line of redhat in front-4, modify it back after the Oracle installation is complete.
For example:
redhat-4
#CentOS release 6.5 (Final)
2.9 Disable SELINUX
vi /etc/selinux/config
Change the SELINUX line to:
SELINUX=disabled
3：Install
3.1 Unzip the installation package
[root@ser6-51 download]# ls -ltr
-rw-r--r-- 1 root root 1014530602 Jul 6 15:07 linuxamd64_12102_database_2of2.zip
-rw-r--r-- 1 root root 1673544724 Jul 6 15:12 linuxamd64_12102_database_1of2.zip
[root@ser6-51 download]# unzip linuxamd64_12102_database_1of2.zip
[root@ser6-51 download]# unzip linuxamd64_12102_database_2of2.zip
[root@ser6-51 download]# ls -ltr
drwxr-xr-x 7 root root 4096 Jul 7 2014 download
-rw-r--r-- 1 root root 1014530602 Jul 6 15:07 linuxamd64_12102_database_2of2.zip
-rw-r--r-- 1 root root 1673544724 Jul 6 15:12 linuxamd64_12102_database_1of2.zip
3.2 Install Oracle software
3.2.1 Create a silent installation response file
su - oracle
vi 12102runInstaller
Add:
###################################################################### ## Copyright(c) Oracle Corporation 1998,2013. All rights reserved. ## ## ## Specify values for the variables listed below to customize ## 适用于您的安装。 ## ## ## ## 每个变量都与一个注释相关联。注释 ## ## 可以帮助使用适当的值填充变量。 ## ## 值。 ## ## ## ## 重要提示：此文件包含纯文本密码和 ## ## 应仅由oracle用户拥有读取权限进行保护 ## ## 或拥有此安装的数据库管理员。## ## ## ###################################################################### #------------------------------------------------------------------------------- # 不要更改以下由系统生成的值。 #------------------------------------------------------------------------------- oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0 #------------------------------------------------------------------------------- # 指定安装选项。 # It can be one of the following: # - INSTALL_DB_SWONLY # - INSTALL_DB_AND_CONFIG # - UPGRADE_DB #------------------------------------------------------------------------------ oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # 指定系统主机名，该主机名在安装期间设置。它可以被用来 # 强制安装使用替代主机名而不是使用 # 首次在系统上找到的主机名。（例如，对于具有多个主机名的系统） # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=ser6-51 #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/u01/app/Execute two scripts: #------------------------------------------------------------------------------- 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 # # all_langs : All languages # # Specify value as follows to select any of the languages. # Example : SELECTED_LANGUAGES=en,fr,ja # # Specify value as follows to select all the languages. # Example : SELECTED_LANGUAGES=all_langs #------------------------------------------------------------------------------- SELECTED_LANGUAGES=en #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME=/u01/app/oracle/product/12c/db_1 #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/u01/app/oracle #------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these options. # - EE : Enterprise Edition # - SE : Standard Edition # - SEONE : Standard Edition One # - PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------- oracle.install.db.InstallEdition=EE ################################################################################# # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges are assigned # # 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 value to be specified for OSDBA and OSOPER group is only for UNIX based # # Operating System. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------- oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. # The value to be specified for OSOPER group is optional. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oper #------------------------------------------------------------------------------ # The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.BACKUPDBA_GROUP=dba #------------------------------------------------------------------------------ # The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DGDBA_GROUP=dba #------------------------------------------------------------------------------ # The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.KMDBA_GROUP=dba ################################################################################ # # # Database Configuration Options # # # ################################################################################ #------------------------------------------------------------------------------- # 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= #------------------------------------------------------------------------------- # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.globalDBName= #------------------------------------------------------------------------------- # Specify the Starter Database SID. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.SID= #------------------------------------------------------------------------------- # Specify whether the database should be configured as a Container database. #------------------------------------------------------------------------------- oracle.install.db.ConfigureAsContainerDB= #------------------------------------------------------------------------------- # Specify the Pluggable Database name for the pluggable database in Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.PDBName= #------------------------------------------------------------------------------- # Specify the Starter Database character set. # # One of the following # AL32UTF8, WE8HKSCS, WE8859ISO15, WE8, VN1252, EE8HKSCS, WE8859ISO2, # EE8, VN1250, NE8HKSCS, WE8859ISO10, NEE8HKSCS, WE8859ISO4, BLT8, VN1257, # BLT8HKSCS, WE8859ISO13, CL8HKSCS, WE8859ISO5, CL8, VN1251, AR8HKSCS, WE8859ISO6, # AR8, VN1256, EL8HKSCS, WE8859ISO7, EL8, VN1253, IW8HKSCS, WE8859ISO8, # IW8, VN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJIS, JA SJISTILDE,16, VN949# KO16, ZHS8GBK, TH32TISASCII, ZHT16, VN95EUC, ZHT 0,16# ZHT8HKSCS, WE8859ISO9P8, VN1254, TR8, VN1258 #------------------------------------------------------------------------------- MSWIN #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.characterSet= # 如果需要自动内存管理。 # 如果不希望使用自动内存管理，并且希望在数据库中分配内存。 # 需要手动完成，则将其设置为false。 #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption= #------------------------------------------------------------------------------- # 指定数据库的总内存分配。值（MB）应为 # 至少 256 MB，且不应超过可用的总物理内存 # 在系统上。 # 示例：oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.memoryLimit= ################################################################################# # # # 可以为以下四个模式提供密码： # # 启动数据库： # # SYS # # SYSTEM # # DBSNMP（由企业管理器使用） # # # # 同一密码可用于所有账户（不推荐） # # 或者可以为每个账户提供不同的密码（推荐） # # # ################################################################################# #------------------------------------------------------------------------------ # 此变量保存用于容器数据库中所有模式的密码。 # 启动数据库。 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL=oracle #------------------------------------------------------------------------------- # 指定启动数据库的SYS密码。 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # 指定启动数据库的SYSTEM密码。 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # 指定启动数据库的DBSNMP密码。 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # 指定在容器数据库中创建可插入数据库所需的PDBADMIN密码。 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.PDBADMIN= #------------------------------------------------------------------------------ # 指定用户是否不想配置安全更新。 # 如果您不想配置，此变量的值应为true。 # 安全更新，否则为false。 # # The value can be either true or false. If left blank it will be assumed # The value can be either true or false. If left blank it will be assumed # # to be false. #------------------------------------------------------------------------------ # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true-# Specify the auto # - updates option. It can be one of the following: # - MYORACLESUPPORT_DOWNLOAD # - OFFLINE_UPDATES #------------------------------------------------------------------------------ SKIP_UPDATES
3.2.2 oracle.installer.autoupdates.option=SKIP_UPDATES
[root@ser6-51 Silent installation of software - oracle
[oracle@ser6-51 install]# su /~]$ cd/download/
[oracle@ser6-51 database/database]$ . -silent -responseFile /home/oracle/12102runInstaller
/*
db_install.rsp/u01/app/If an error occurs during the installation process, it has already been reported in $ORACLE_HOME and
[oracle@ser6-52 Many files and directories were generated under oraInventory. If you want to install again, you need to delete these files first:
/u01/app
[oracle@ser6-52 app]$ pwd -rm /u01/app/Execute two scripts:
app]$ rm/
cd $ORACLE_HOME -rm *
*/
rf
[root@ser6-51 ~]# sh /u01/app/Execute two scripts:/oraInventory
orainstRoot.sh /u01/app/Changing permissions of
oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world. /u01/app/Changing the groupname of oraInventory to oinstall.
The script execution is complete.
root@ser6-51 ~]# sh /u01/app/oracle/product/12c/db_1/root.sh
Check /u01/app/oracle/product/12c/db_1/install/root_ser6-51_2015-07-06_19-00-11.log for the output of root script
3.3 Create database
3.3.1 Create response file
v i /home/oracle/dbca.rsp
Add:
[GENERAL] RESPONSEFILE_VERSION = ""12.1.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE] GDBNAME = "orcl" SID = "orcl" TEMPLATENAME = "New_Database.dbt" SYSPASSWORD = "orcl" SYSTEMPASSWORD = "orcl" SYSMANPASSWORD = "orcl" DBSNMPPASSWORD = "orcl" DATAFILEDESTINATION ="/u01/app/oracle/oradata" STORAGETYPE=FS CHARACTERSET = "ZHS"16GBK" DATABASETYPE = "MULTIPURPOSE" AUTOMATICMEMORYMANAGEMENT = "FALSE"
3.3.2 Execute command
dbca -silent -responseFile /home/oracle/dbca.rsp
Creating and starting Oracle instance 1% complete 4% complete Creating database files 5% complete 9% complete Creating data dictionary views 10% complete 13% complete 14% complete 15% complete 16% complete 17% complete 18% complete 21% complete 22% complete 23% complete 24% complete Adding Oracle JVM 30% complete 37% complete 44% complete 46% complete Adding Oracle Text 47% complete 48% complete 50% complete 51% complete Adding Oracle Multimedia 52% complete 65% complete Adding Oracle OLAP 66% complete 67% complete 68% complete 69% complete Adding Oracle Spatial 70% complete 78% complete Adding Oracle Application Express 83% complete 87% complete Completing Database Creation 89% complete 90% complete 91% complete 95% complete 100% complete
[oracle@ser6-51 dbs]$ export ORACLE_SID=orcl
[oracle@ser6-51 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 8 09:29:16 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select status from v$instance;
Status
------------
Open
3.4Configure listener
3.4.1 Create response file
vi 12102_netca.rsp
Add:
[GENERAL]
RESPONSEFILE_VERSION=""12.1"
CREATE_TYPE="CUSTOM"
#-------------------------------------------------------------------------------
# Name : SHOW_GUI
# Datatype : Boolean
# Description: This variable controls appearance/# suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/# silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#SHOW_GUI=false
#-------------------------------------------------------------------------------
# Name : LOG_FILE
# Datatype : String
# Description: If present, NetCA will log output to this file in addition to the
# standard out.
# Pre-req : N/A
# Default : NONE
# Note:
# This is a substitute of "/# log" in the NetCA command line.
# The command line argument has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#LOG_FILE=""/oracle12cHome/network/tools/log/netca.log"
[oracle.net.ca]
#INSTALLED_COMPONENTS;StringList;list of installed components
# The possible values for installed components are:
# "net"}8","server","client","aso", "cman", "javavm"
INSTALLED_COMPONENTS={"server","net8","javavm"
#INSTALL_TYPE;String;type of install
# The possible values for install type are:
# "typical","minimal" or "custom"
INSTALL_TYPE=""typical""
#LISTENER_NUMBER;Number;Number of Listeners
# A typical install sets one listener
LISTENER_NUMBER=1
#LISTENER_NAMES;StringList;list of listener names
# The values for listener are:
# "LISTENER","LISTENER"1","LISTENER"2","LISTENER"3", ...
# A typical install sets only "LISTENER"
LISTENER_NAMES="LISTENER"
#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)
# The possible values for listener protocols are:
# "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521"
# A typical install sets only "TCP;1521"
LISTENER_PROTOCOLS="TCP;1521"
#LISTENER_START;String;name of the listener to start, in double quotes
LISTENER_START=""LISTENER""
#NAMING_METHODS;StringList;list of naming methods
# The possible values for naming methods are:
# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE
# A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"
# or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes
# A typical install does not use this variable.
#NOVELL_NAMECONTEXT = ""NAMCONTEXT""
#SUN_METAMAP;String; SUN meta map, in double quotes
# A typical install does not use this variable.
#SUN_METAMAP = ""MAP""
#DCE_CELLNAME;String;DCE cell name, in double quotes
# A typical install does not use this variable.
#DCE_CELLNAME = ""CELL""
#NSN_NUMBER;Number;Number of NetService Names
# A typical install sets one net service name
NSN_NUMBER=1
#NSN_NAMES;StringList;list of Net Service names
# A typical install sets net service name to "EXTPROC_CONNECTION_DATA"
NSN_NAMES="EXTPROC_CONNECTION_DATA"
#NSN_SERVICE;StringList;Oracle12c database's service name
# A typical install sets Oracle12c database's service name to "PLSExtProc"
NSN_SERVICE="PLSExtProc"
3.4.2 Execute command
[oracle@ser6-51 ~]$ netca -silent -responseFile /home/oracle/12102_netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/12102_netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/12c/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
4: Set startup
4.1 Modify the dbstart file
If executed/u01/app/oracle/product/12c/db_1/bin/dbstart error message:
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/oracle/product/10.2.0/db_1/bin/dbstart ORACLE_HOME
Modify the dbstart file, set ORACLE_HOME_LISTNER=$1
Modify to ORACLE_HOME_LISTNER=$ORACLE_HOME
4.2Modify/etc/oratab
Add:
orcl:/u01/app/oracle/product/12c/db_1:Y
4.3Modify/etc/rc.d/rc.local
Add a line:
su oracle -lc /u01/app/oracle/product/12c/db_1/bin/dbstart
--Note:/u01/app/oracle/product/12c/dbhome_1For the oracle installation directory, it should be modified according to the actual situation.
check if it can automatically start up after reboot in the reboot test.
5: Open1521port
If the firewall is enabled, it needs to be opened1521port, allowing remote access.
vi /etc/sysconfig/iptables
Already existing in the configuration file-A INPUT under those commands
Add a line:
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521-j ACCEPT
Restart the firewall
[root@ser6-52 mongodb]# /etc/init.d/iptables restart
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Flushing firewall rules: [ OK ]
iptables: Unloading modules: [ OK ]
iptables: Applying firewall rules: [ OK ]
6: Subsequent configuration
# Change the operating system version back to the original configuration
[root@pc ~]# vi /etc/redhat-release
Red Hat Enterprise Linux Server release 5.8 (Tikanga)
After modification:
#redhat-4
CentOS release 6.5 (Final)
Corresponding Steps2.8.
--Refer to this article for silent database building.
Statement: The content of this article is from the Internet, and the copyright belongs to the original author. The content is contributed and uploaded by Internet users spontaneously. This website does not own the copyright, has not been manually edited, and does not assume any relevant legal liability. If you find any content suspected of copyright infringement, please send an email to: notice#oldtoolbag.com (Please replace # with @ when sending an email for reporting. Provide relevant evidence, and once verified, this site will immediately delete the infringing content.)