Oracle Silent installation 11GR2 has been verified and can be installed directly

Operating system and Oracle version

Linux version: SUSE Linux Enterprise Server One (x86_64)

Oracle version: Release 11.2.0.3.0

1. Check if the dependent package is installed successfully. If the installation is not successful, complete the installation.

Rpm-q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel GLib C-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make Numactl-devel sysstat Unix ODBC Unixodbc-devel

2, create the installation directory and database users

Groupadd dbagroupadd oinstalluseradd-g oinstall-g dba-m Oraclemkdir-pv/u01/oracle/oradatamkdir-pv/u01/oracle/orai Nventorymkdir-pv/u01/oracle/oracle/product/11.2.0/dbhome_1chown-r oracle:oinstall/u01/oracle

3, modify the kernel parameters,

Add the following at the end of the file (where the shmmax parameter may need to be adjusted according to the configuration of the server, and when it is pre-checked, it needs to be configured according to the value of the prompt.) )：

Vi/etc/sysctl.conffs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 4194304kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 32000 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_ Default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576

to make /etc/sysctl.conf changes take effect immediately, execute commands sysctl-p

4. Modify User Restrictions

1) Modify the user's shell settings, vi/etc/security/limits.conf, add the following four lines at the end of the file; Oracle soft Nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 65536 save exit; 2) modify/etc/pam.d/login file Vi/etc/pam.d/login, add the following two lines at the end of the file; session required/lib/ Security/pam_limits.sosession required pam_limits.so Save exit;

5, the Oracle environment variable settings (need to change according to the actual situation, especially SID)

[Email protected]:~> vi bashrcexport oracle_base=/u01/oracleexport oracle_home= $ORACLE _base/oracle/product/ 11.2.0/dbhome_1export oracle_sid=csdbexport path= $PATH: $HOME/bin: $ORACLE _home/binexport ld_library_path= $ORACLE _ Home/lib:/usr/lib

6, check whether Oracle meets the installation conditions.

./runinstaller-silent-executeprereqs

Then see if the log has an error.

7, modify the response file, install the database software

Need to modify DB_INSTALL.RSP, see the attachment, the attached file can be used directly, just modify the hostname, Oracle installation directory.

Such as:

Oracle_hostname=csdb #主机名

Oracle_home=

Oracle_base

Install the database software.

[Email protected]:~/ora11gr2_x64/database>./runinstaller-silent-responsefile/home/oracle/etc/new/db_ Install.rsp

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/> #-responsefile followed by the absolute path to the file.

8, install the library, modify the character set and instance with the password.

Dbca-silent-createdatabase-characterset al32utf8-templatename $ORACLE _home/assistants/dbca/templates/general_ Purpose.dbc-gdbname csdb-sid Csdb-syspassword Huawei123-systempassword huawei123

9, register the instance, verify whether the installation is successful.

[Email protected]:~> sqlplus/as sysdbasql*plus:release 11.2.0.3.0 Production on Thu Apr 11:21:23 2017Copyright (c  ) 1982, +, Oracle. All rights reserved.  Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit productionwith The partitioning, OLAP, Data Mining and Real application testing optionssql> alter system Register 2; System altered. Sql>//system altered.

Then, view the listener:

[email protected]:~> lsnrctl statuslsnrctl for linux: version 11.2.0.3.0  - Production on 20-APR-2017 11:22:14Copyright  (c)  1991, 2011,  Oracle.  all rights reserved. connecting to  (address= (protocol=tcp) (host=) (port=1521)) status of the  LISTENER------------------------alias                      LISTENERVersion                    tnslsnr for linux:  Version 11.2.0.3.0 - ProductionStart Date                 20-APR-2017 10:31:20Uptime                     0 days 0 hr. 50 min. 54 sectrace level                offSecurity                   ON: Local OS  authenticationsnmp                       OFFListener Log File          /u01/oracle/diag/tnslsnr/csdb02/listener/alert/log.xmllistening endpoints summary ...   (description= (address= (protocol=tcp) (host=localhost)) port=1521 ... service  "Csdb"  has 1 instance (s) .  instance  "Csdb",  status ready,  has 1 handler (s)  for this service ... service  "Csdbxdb"  has 1 instance (s) .  instance  "Csdb ",  status ready, has 1 handler (s)  for this service ... The command completed successfully[email protected]:~>

Oracle Silent installation 11GR2 has been verified and can be installed directly