Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to silently install database oracle11gR2", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to silently install database oracle11gR2" this article.

Xhost hdp01.hammer-test-tpl-wh.com

Telnet hdp01.hammer-test-tpl-wh.com

Sudo sh

-originally

Yum-y install 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

Yum-y install 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

Yum-y install 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

Yum-y install 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

Yum-y install libXtst-1.2.2-1.el7.x86_64 make-3.82-19.el7.x86_64 sysstat-10.1.5-1.el7.x86_64

-practice adjusts to

Yum-y install binutils* compat-libcap1-* compat-libstdc++-* compat-libstdc++* gcc-*

Yum-y install gcc-c++-* glibc-* ksh* libaio-* libaio-* libgcc-* libstdc++-* libXi-* libXtst-* make-* sysstat-*

Yum-y install libaio* glibc* compat-libstdc* elfutils-libelf-devel* libgcc* libstdc* unixODBC* pdksh*

Echo inventory_loc=/u01/app/oraInventory > > / etc/oraInst.loc

Echo inst_group=oinstall > > / etc/oraInst.loc

/ usr/sbin/groupadd oinstall

/ usr/sbin/groupadd dba

/ usr/sbin/useradd-g oinstall-G dba oracle

-if you already have an oracle account, enter / usr/sbin/usermod-g oinstall-G dba oracle

Passwd oracle

-enter oracle_123 manually

-/ etc/sysctl.conf

-- 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.wmemax = 1048576

Echo kernel.shmmax=206158430208 > > / etc/sysctl.conf

Echo kernel.shmmni=4096 > > / etc/sysctl.conf

Echo kernel.shmall= 67108864 > > / etc/sysctl.conf

Echo kernel.sem = 250 32000 100 128 > > / etc/sysctl.conf

Echo net.ipv4.ip_local_port_range = 9000 65500 > > / etc/sysctl.conf

Echo net.core.rmem_default = 262144 > > / etc/sysctl.conf

Echo net.core.rmem_max = 4194304 > > / etc/sysctl.conf

Echo net.core.wmem_default = 262144 > > / etc/sysctl.conf

Echo net.core.wmem_max = 1048576 > > / etc/sysctl.conf

Echo fs.file-max = 6815744 > > / etc/sysctl.conf

Echo fs.aio-max-nr = 1048576 > > / etc/sysctl.conf

Sysctl-p

-setting of the SHMALL parameter. This value is recommended to be set to the physical memory size divided by the paging size

Getconf PAGE_SIZE

-- calculation method: for example, 256 GB of memory, when page_size is 4096, 256 "1024" 1024 "1024"

/ sbin/sysctl-p

Echo "* soft nofile 1024" > > / etc/security/limits.conf

Echo "* hard nofile 65536" > > / etc/security/limits.conf

Echo "* soft nproc 2047" > > / etc/security/limits.conf

Echo "* hard nproc 16384" > > / etc/security/limits.conf

Echo "* soft stack 10240" > > / etc/security/limits.conf

Echo "* hard stack 32768" > > / etc/security/limits.conf

Mkdir-p / tpdata/app/

Chown-R oracle:oinstall / tpdata/app/

Chmod-R 775 / tpdata/app/

Umask 022

Echo $SHELL

Su-oracle

. / .bash _ profile

-- export DISPLAY=local_host:0.0

Export DISPLAY=:0.0

Export DISPLAY=:1

Xhost + hdp01.hammer-test-tpl-wh.com

Mkdir / tpdata/tmp

Chmod a+wr / tpdata/tmp

Chown oracle:oinstall-R / tpdata

Echo umask 022 > >. / .bash _ profile

Echo TMP=/tpdata/tmp > >. / .bash _ profile

Echo TMPDIR=/tpdata/tmp > >. / .bash _ profile

Echo export TMP TMPDIR > >. / .bash _ profile

Echo ORACLE_BASE=/tpdata/app/oracle > >. / .bash _ profile

Echo ORACLE_SID=carthage > >. / .bash _ profile

Echo export ORACLE_BASE ORACLE_SID > >. / .bash _ profile

Unset ORACLE_HOME

Unset TNS_ADMIN

Vi / etc/sysconfig/selinux

SELINUX=disabled

Echo "session required / lib/security/pam_limits.so" > > / etc/pam.d/login

Echo "session required pam_limits.so" > > / etc/pam.d/login

Service iptables stop

-- the above is configured for the OS environment--

Reference article

Http://www.oracle.com/technetwork/cn/articles/wininst-otn-096093-zhs.html

Http://blog.itpub.net/27042095/viewspace-766965

10.2 create a response file

# su-oracle

Install only the response file UPRR_INSTALL_DB_SWONLY.rsp of the Oracle software

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

Oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=hdp01.hammer-test-tpl-wh.com

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/tpdata/app/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN,zh_TW

ORACLE_HOME=/tpdata/app/oracle/product/11.2.0/dbhome_1

ORACLE_BASE=/tpdata/app/oracle

Oracle.install.db.InstallEdition=EE

Oracle.install.db.isCustomInstall=false

Oracle.install.db.DBA_GROUP=dba

Oracle.install.db.OPER_GROUP=dba

DECLINE_SECURITY_UPDATES=false

Create a response file UPRR_DBCA.rsp for the database

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "hammer"

SID = "hammer"

TEMPLATENAME = "General_Purpose.dbc"

SYSPASSWORD = "oracle_123"

SYSTEMPASSWORD = "oracle_123"

DATAFILEDESTINATION = "/ tpdata/app/oracle/oradata"

RECOVERYAREADESTINATION= "/ tpdata/app/oracle/flash_recovery_area"

CHARACTERSET = "AL32UTF8"

NATIONALCHARACTERSET= "UTF8"

LISTENERS = "listener1"

The response file configured by NET can be configured using Oracle by default without modification. The file is located in the path of the Oracle installation package:

$cp database/response/netca.rsp / home/oracle/UPRR_NETCA.rsp

$su-root

# chmod 700 / home/oracle/UPRR_INSTALL_DB_SWONLY.rsp

10.3 install Oracle

Installation:

# su-oracle

$cd database

$mkdir-p / u01/app/oracle/oraInventory

-- $. / runInstaller-silent-debug-force-responseFile / home/oracle/UPRR_INSTALL_DB_SWONLY.rsp

$. / runInstaller-silent-responseFile / home/oracle/UPRR_INSTALL_DB_SWONLY.rsp

Remarks: (optional parameter-noconfig-IgnoreSysPreReqs)

A prompt similar to the following indicates that the installation is complete:

#-

...

/ tpdata/app/oracle/oraInventory/orainstRoot.sh

/ tpdata/app/oracle/product/11.2.0/dbhome_1/root.sh

To execute the configuration scripts:

1. Open a terminal window

2. Log in as "root"

3. Run the scripts

4. Return to this window and hit "Enter" key to continue

Successfully Setup Software.

#-

Check the installation log information during installation to understand the installation progress

$cd $ORACLE_BASE/oraInventory/logs

$tail-100f installActions*.log

Root executes root.sh under $ORACLE_HOME to create the oratab,dbhome,oraenv,coraenv file, and if prompted, press enter all the time:

$su-root

# / tpdata/app/oracle/product/11.2.0/dbhome_1/root.sh

# more / etc/oratab

Set environment variabl

Vi / home/oracle/.bash_profile

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

Export TNS_ADMIN=$ORACLE_HOME/network/admin

Export PATH=.:$ {PATH}: $HOME/bin:$ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/bin:/usr/bin/X11:/usr/local/bin

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: $ORACLE_HOME/lib

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: $ORACLE_HOME/oracm/lib

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: / lib:/usr/lib:/usr/local/lib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/JRE

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/JRE/lib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/jlib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/rdbms/jlib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/network/jlib

Export LIBPATH=$ {CLASSPATH}: $ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib

Export ORACLE_OWNER=oracle

Export SPFILE_PATH=$ORACLE_HOME/dbs

Export ORA_NLS10=$ORACLE_HOME/nls/data

Source / home/oracle/.bash_profile

Sqlplus test

$sqlplus / nolog

11 silently configure the network

$$ORACLE_HOME/bin/netca / silent / responseFile / home/oracle/UPRR_NETCA.rsp

/ tpdata/app/oracle/product/11.2.0/dbhome_6/srvm/admin/getcrshome does not have executable permissions?

12 silently install the database

# su-oracle

$ORACLE_HOME/bin/dbca-silent-responseFile / home/oracle/UPRR_DBCA.rsp

Check the log information during installation to understand the progress:

$tail-100f $ORACLE_BASE/cfgtoollogs/dbca/$ORACLE_SID/$ORACLE_SID.log

Check the instance after building the database

$ps-ef | grep ora_ | grep-v grep | wc-l

$ps-ef | grep ora_ | grep-v grep

Monitoring and checking after building the database

$lsnrctl status

If you use archive logs

$sqlplus / as sysdba

SQL > shutdown immediate

SQL > startup mount

SQL > alter database archivelog

SQL > alter database flashback on; (execute if you want to enable database flashback)

SQL > alter database open

SQL > execute utl_recomp.recomp_serial (); (recompile all objects that may fail)

SQL > alter system archive log current; (manually archived tests)

Default installed database user check

SQL > set lines 256 pages 500

SQL > select USER_ID,USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE from dba_users order by 1

The above is all the contents of the article "how to silently install database oracle11gR2". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.