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

1. Install the package

Yum install-y yum install

Yum install-y binutils

Yum install-y compat-libstdc++-33

Yum install-y elfutils-libelf

Yum install-y elfutils-libelf-devel

Yum install-y expat

Yum install-y gcc

Yum install-y gcc-c++

Yum install-y glibc

Yum install-y glibc-common

Yum install-y glibc-devel

Yum install-y glibc-headers

Yum install-y libaio

Yum install-y libaio-devel

Yum install-y libgcc

Yum install-y libstdc++

Yum install-y libstdc++-devel

Yum install-y make

Yum install-y pdksh

Yum install-y sysstat

Yum install-y unixODBC

Yum install-y unixODBC-devel

2. Add database groups and users

# id oracle (confirm whether the oracle user exists)

# / usr/sbin/groupadd oinstall (set up product list management group)

# / usr/sbin/groupadd dba (set up database installation group)

# / usr/sbin/groupadd asmadmin (set up ASM management group)

# / usr/sbin/groupadd asmdba (set up Grid management group)

# / usr/sbin/useradd-g oinstall-G dba,asmdba oracle-d / home/oracle (oinstall is the main group to ensure that / home/oracle does not exist)

3. Modify system parameters

Vi / 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.wmem_max = 1048586

Vi / etc/security/limits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Vi / etc/profile

If [$USER = "oracle"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

Create an installation directory (depending on the situation, select a directory with more space to create)

Mkdir-p / u01/app/

Chown-R oracle:oinstall / u01/app/

Chmod-R 775 / u01/app/

Create a / etc/oraInst.loc file with the following contents

Inventory_loc=/u01/app/oracle/oraInventory

Inst_group=oinstall

Change the permissions of a file

Chown oracle:oinstall / etc/oraInst.loc

Chmod 664 / etc/oraInst.loc

Set the oracle environment variable

Su-oracle

Vi / .bash_profile

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_SID=orcl

Note that except for ORACLE_BASE and ORACLE_SID, no oracle-related environment variables (ORACLE_HOME, PATH, LD_LIBRARY_PATH, etc.) are set (in / etc/profile and .bash _ profile).

Extract the oracle installation file

Unzip linux.x64_11gR2_database_1of2.zip

Unzip linux.x64_11gR2_database_2of2.zip

Copy response file template

Mkdir etc

Cp / home/oracle/database/response/* / home/oracle/etc/

Set response file permissions

Su-root

Chmod 700 / home/oracle/etc/*.rsp

Install Oracle software silently

Su-oracle

Modify the response file / home/oracle/etc/db_install.rsp for installing Oracle software

Oracle.install.option=INSTALL_DB_SWONLY / / 29 Line installation Type

ORACLE_HOSTNAME=oracledb//37 Line Host name

UNIX_GROUP_NAME=oinstall / / 42 Line installation Group

INVENTORY_LOCATION=/u01/app/oracle/oraInventory / / 47 line INVENTORY directory

SELECTED_LANGUAGES=en,zh_CN,zh_TW / / 78 Line selection language

ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 / / 83 Line oracle_home

ORACLE_BASE=/u01/app/oracle / / 88 line oracle_base

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

Oracle.install.db.isCustomInstall=true / / 108Line Custom installation

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

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

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

Oracle.install.db.config.starterdb.globalDBName=orcl / / 165Line globalDBName

Oracle.install.db.config.starterdb.SID=orcl / / 170line SID

Minimum memory of oracle.install.db.config.starterdb.memoryLimit=512 / / 200lines automatically managed memory (M)

Line oracle.install.db.config.starterdb.password.ALL=oracle / / 233sets all database users to use the same password

DECLINE_SECURITY_UPDATES=true / / 385line settings security update

Cd database

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

During installation, if you prompt [WARNING] to ignore it, the installer is still in progress, and if [FATAL] appears, the installer has stopped.

Check the installation log information to understand the installation progress

Cd $ORACLE_BASE/oraInventory/logs

Tail-100f installActions*.log

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

#-

...

/ u01/app/oracle/product/11.2.0/db_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.

#-

Use the root user to execute root.sh

Su root

/ u01/app/oracle/product/11.2.0/db_1/root.sh

Add oracle environment variable

Su-oracle

Vi / .bash_profile

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_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

Silently configure the network

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

Silently install the database

Modify the response file / home/oracle/etc/dbca.rsp that installs only the database

Name of GDBNAME= "orcl.java-linux-test" / / 78 line global database = SID+ host domain name

SID= "orcl" / / 149Line SID

CHARACTERSET= "AL32UTF8" / / 415 line code

NATIONALCHARACTERSET= "UTF8" / / 425th line code

Silently install the database

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

[oracle@segment2 ~] $ORACLE_HOME/bin/dbca-silent-responseFile / home/oracle/etc/dbca.rsp

Enter SYS user password:

Enter SYSTEM user password:

Copying database files

1% complete

3% complete

11% complete

18% complete

26% complete

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

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

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.