Oracle Silent Installation 11gr2 has been verified and can be installed directly

Operating System and Oracle Version

linux version: SUSE Linux Enterprise Server 11 (x86_64)

Oracle version: Release 11.2.0.3.0  

1. Check whether the dependency packages are installed successfully. If the installation is not successful, please install it.

rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio  libaio-devel libgcc libgomp libstdc++ libstdc++-devel make numactl-devel sysstat unixODBC unixODBC-devel

2. Create installation directory and database users

groupadd dba
groupadd oinstall
useradd -g oinstall -G dba -m oracle
mkdir -pv  /u01/oracle/oradata
mkdir -pv  /u01/oracle/oraInventory
mkdir -pv /u01/oracle/oracle/product/11.2.0/dbhome_1
chown -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 if it does not pass, it needs to be configured according to the value prompted). ):

vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 4194304
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576


To make the / etc/sysctl.conf change take effect immediately, execute the command 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 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
 Save and 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.so
session required pam_limits.so
 Save and exit;


5. The setting of oracle environment variables (need to be modified according to the actual situation, especially SID)

oracle@linux-unvz:~> vi .bashrc
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=csdb
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib


6. Check whether oracle meets the installation conditions.

./runInstaller -silent -executePrereqs

Then see if there is an error in the log. 

7. Modify response files and install database software

It is necessary to modify db_install.rsp. See the attachment for details. The attachment file can be used directly. Just modify the host name and oracle installation directory.

Such as:

ORACLE_HOSTNAME=CSDB Host Name            

ORACLE_HOME=

ORACLE_BASE

Install database software. 

oracle@CSDB02:~/ora11gR2_x64/database> ./runInstaller -silent -responseFile /home/oracle/etc/new/db_install.rsp

  #- The absolute path of the file is followed by the responseFile.

8. Install the library and modify the character set and the instance and 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 and verify whether the installation is successful.

oracle@CSDB02:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 20 11:21:23 2017
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system register
  2  ;
System altered.
SQL> /
/
System altered.

Then, look at the listener:

oracle@CSDB02:~> lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-APR-2017 11:22:14
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                20-APR-2017 10:31:20
Uptime                    0 days 0 hr. 50 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/oracle/diag/tnslsnr/CSDB02/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
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
oracle@CSDB02:~>


Tags: Oracle Database Linux glibc

Posted on Sat, 06 Jul 2019 19:55:35 -0700 by LuckyLucy