Shulou(Shulou.com)06/01 Report--

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 package is installed successfully. If not, 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 user

groupadd dbagroupadd oinstalluseradd -g oinstall -G dba -m oraclemkdir -pv /u01/oracle/oradatamkdir -pv /u01/oracle/oraInventorymkdir -pv /u01/oracle/oracle/product/11.2.0/dbhome_1chown -R oracle:oinstall /u01/oracle

3. Modify kernel parameters,

Add the following content at the end of the file (where the shmmax parameter may need to be adjusted according to the configuration of the server. If it does not pass the pre-check later, it needs to be configured according to the prompt value. )：

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

For the/etc/sysctl.conf changes to 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 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536 Save and exit;2) Modify the/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 and exit;

5. Oracle environment variable settings (modified according to actual situation, especially SID)

oracle@linux-unvz:~> 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 check the log to see if there is an error.

7. Modify the response file and install the database software

db_install.rsp needs to be modified, see the attachment for details, the attached file can be used directly, just modify the host name, oracle installation directory.

For example:

ORACLE_HOSTNAME=CSDB #hostname

ORACLE_HOME=

ORACLE_BASE

Install database software.

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

#-responseFile is 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 and verify whether the installation is successful.

oracle@CSDB02:~> sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 20 11:21:23 2017Copyright (c) 1982, 2011, 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, check the monitor:

oracle@CSDB02:~> 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)))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 successfullyoracle@CSDB02:~>

Attachment: down.51cto.com/data/2366602

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.