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

1.1 extract the installation package

Oracle11gR2 is installed into two installation packages. After all the packages are unzipped, you need to merge the contents of the two packages and install them.

Oracle version

Linux64_11gR2

Operating system

CentOS7.0-X86-64bit

2.1.1. Upload and decompress

Upload and decompress oracle users.

Unziplinux.x64_11gR2_database_1of2.zip

Unziplinux.x64_11gR2_database_2of2.zip

1.2 Oracle database installation

2.2.1. There are network installation dependent packages

Yum install binutilscompat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-commonglibc-devel gcc- gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-develmake sysstat unixODBC unixODBC-devel pdksh

2.2.2. No network installation dependency package

Upload rpm.zip first, and then decompress it.

Unzip rpm.zip

Then execute rpm-ivh * .rpm-- nodeps-force

2.2.3. Create Oracle installation user

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dbaoracle-d / home/oracle/

Passwd oracle

2.2.4. Modify kernel parameters

Open modify / etc/sysctl.conf and add the following at the end

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

Refresh with / sbin/sysctl-p after modification to make the settings take effect.

2.2.5. Change user limits

Modify / etc/security/limits.conf to add content

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

2.2.6. Change the system environment variable

Modify the environment variable / etc/profile by adding the following

If [$USER = "oracle"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

2.2.7. Set the Oracle environment variable

Export PATH

Export ORACLE_SID=orcl

ExportORACLE_BASE=/home/oracle/app

ExportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

ExportPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

ExportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

2.2.8. Configure db_install.rsp

It's already packed in db_install.zip.

Change the options:

Oracle.install.option=INSTALL_DB_SWONLY / / installation type

ORACLE_HOSTNAME=10.10.17.161 / / Host name (just change it to ip address)

UNIX_GROUP_NAME=oinstall / / installation group

INVENTORY_LOCATION=/ home/oracle/app / / INVENTORY directory (write BASE by default)

SELECTED_LANGUAGES=en,zh_CN,zh_TW// Select language

ORACLE_HOME=/ home/oracle/app/product/11.2.0/dbhome_1 / / oracle_home

ORACLE_BASE=/ home/oracle/app / / oracle_base

Oracle.install.db.InstallEdition=EE / / oracle version

Oracle.install.db.DBA_GROUP=dba/ / dba user group

Oracle.install.db.OPER_GROUP=oinstall// oper user group

Oracle.install.db.config.starterdb.type=GENERAL_PURPOSE// database type

Oracle.install.db.config.starterdb.globalDBName=orcl//globalDBName global database name

Oracle.install.db.config.starterdb.password.ALL=oracle// default password

2.2.9. Execute installation command

. / runInstaller-silent-force-ignorePrereq-responseFile / home/oracle/db_install.rsp

You need to wait, switch to your root account and execute two scripts.

2.2.10. Install the global database

Configure dbca.rsp

It's already packed in dbca.zip.

Execute the command to start installing dbca-silent-responseFile/home/oracle/dbca.rsp

Log: / home/oracle/app/cfgtoollogs/dbca/orcl/trace.log

After execution, start to clear the screen, and then directly enter the default password set earlier and hit enter, and the installation will begin automatically.

2.2.11. Configure the listening file

Two listening files have been packaged in jianting.zip. Modify the following configuration accordingly:

Listener:

HOST = 192.168.0.250 / / Server address

PORT = 1521 / / listening port

ORACLE_HOME=/home/oracle/app/product/11.2.0/dbhome_1 / / specify the home of the oracle

Tnsnames:

HOST = 192.168.0.250 / / Server address

PORT = 1521 / / listening port

After configuration, put it under / home / oracle/app/product/11.2.0/dbhome_1/network/admin/.

Lsnrctl start, start oracle snooping.

Attachment: http://down.51cto.com/data/2368572

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.