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

1. Check the hardware

Memory

# grep MemTotal / proc/meminfo

Swap space

# grep SwapTotal / proc/meminfo

Disk space

# df-ah

2. Download the software

Oracle Database 10g Release 2 (10.2.0.1) Software download location:

Http://otn.oracle.com/software/products/database/oracle10g/index.html

3. Modify host file

View / etc/hosts file must contain a fully qualified name for the server

4. Check the installation package

1. Check whether the following packages are installed. If not, install them first:

Binutils-2.17.50.0.6-2.el5

Compat-libstdc++-33-3.2.3-61

Elfutils-libelf-0.125-3.el5

Elfutils-libelf-devel-0.125

Glibc-2.5-12

Glibc-common-2.5-12

Glibc-devel-2.5-12

Gcc-4.1.1-52

Gcc-c++-4.1.1-52

Libaio-0.3.106

Libaio-devel-0.3.106

Libgcc-4.1.1-52

Libstdc++-4.1.1

Libstdc++-devel-4.1.1-52.e15

Make-3.81-1.1

Sysstat-7.0.0

UnixODBC-2.2.11

UnixODBC-devel-2.2.11

# rpm-qa | grep make gcc glibc compat openmotif21 setarch, etc.

5. Links to libstdc packages

(the old version is required, but do not set the new version of oracle11):

Ln-s / usr/lib/libstdc++.so.6.0.3 / usr/lib/libstdc++.so.5

# check that if you do not make this link and build the database during the installation, there will be a problem that you cannot link to the database.

three。 Parameter setting 1. Setting core parameters

Add the following line to the / etc/sysctl.conf file:

# kernel.core_uses_pid = 1

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648-(in bytes, the amount of physical memory is * 1024, 1024, which is 2 times the amount of memory)

Kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

Kernel.sem = 250 32000 100 128

Fs.file-max = 65536

Net.ipv4.ip_local_port_range = 1024 65000

Net.core.rmem_default=8388608

Net.core.rmem_max=8388608

Net.core.wmem_default=262144

Net.core.wmem_max=262144

Esc: wq!

# sysctl-p # run the following command to change the core parameters

2. Set Shell Limits (system resource limit) to improve the running efficiency of the software.

a. Add the following red lines to the / etc/security/limits.conf file:

Oracle soft nofile 65536

Oracle hard nofile 65536

Oracle soft nproc 16384

Oracle hard nproc 16384

b. Add the following line to the / etc/pam.d/login file, if it is not in it:

Session required / lib/security/pam_limits.so

Session required pam_limits.so

c. Add the following statement after / etc/profile:

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

3. Create users and groups and related directories

-- create a dba/oper/oinstall group

/ usr/sbin/groupadd dba

/ usr/sbin/groupadd oper

/ usr/sbin/groupadd oinstall

-- create an oracle user and set the group to which the user belongs

/ usr/sbin/usermod-g oinstall-G dba oracle

/ usr/sbin/useradd-g oinstall-G dba oracle

Passwd oracle

# id oracle

Uid=501 (oracle) gid=501 (oinstall) groups=501 (oinstall), 502 (dba)

-- create the relevant installation directory

Mkdir-p / opt/oracle/product

Mkdir-p / opt/oracle/product/OraHome

Mkdir-p / opt/oraInventory # (the default inventory folder)

Mkdir-p / opt/oracle/oradata # (change the right file owner)

Mkdir-p / var/opt/oracle

-- set directory owner and permissions

Chown-R oracle.oinstall / opt/oracle

Chown-R oracle.oinstall / opt/oracle/oradata

Chown-R oracle.oinstall / opt/oracle/product/OraHome

Chown-R oracle.dba / opt/oraInventory

Chown oracle.dba / var/opt/oracle

Chmod-R 775 / opt/oracle

Chmod-R 755 / var/opt/oracle

4. Set installation environment variables

# su-oracle-- su to oracle users

Change some of the user's configuration

$vi .bash _ profile

Add the following parameters, mainly to configure the operating environment parameters of oracle software

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

Export ORACLE_BASE=/opt/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/OraHome

Export ORACLE_SID=orcl

Export ORACLE_OWNER=oracle

Export ORACLE_TERM=vt100

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

Export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

Export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

Export CLASSPATH

Note:

11g:ORA_NLS33=$ORACLE_HOME/nls/admin/data

10g:ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

9i:ORA_NLS33=/oracle/app/ora92/ocommon/nls/admin/data

Save exit

-- execute the following command to make the configuration take effect immediately or log in as an oracle user to make the settings effective

$source $HOME/.bash_profile

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.