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

Install oracle softwar

1 > create user groups, users, and directories

Under the bjdb node:

[root@node1 /] # groupadd-g 200 oinstall

[root@node1 /] # groupadd-g 201 dba

[root@node1 /] # useradd-u 200-g oinstall-G dba oracle

Creating mailbox file: File exists

[root@node1 /] # passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is based ona dictionary word

Retype new UNIX password:

Passwd: all authentication tokens updated successfully.

[root@node1 /] # mkdir-p / top/app/oracle

[root@node1 /] # chown-R oracle:oinstall / eb_db

Create the same user group and user under the shdb node, the script is the same

Shut down the mail server

[root@node1 /] # chkconfig sendmail off

2 > modify kernel parameters

/ etc/sysctl.conf file add:

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

[root@node1 /] # sysctl-p / / Parameter file takes effect

Add under / etc/security/limits.conf file:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

Add under / etc/pam.d/login file:

Session required / lib/security/pam_limits.so

Add under / etc/profile file:

If [$USER = "oracle"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

Modify .bash _ profile file under oracle user

[oracle@beijing ~] $vi .bash _ profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

Export EDITOR=vi

Export ORACLE_SID=prod

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin

Umask 022

Create monitor: operate under oracle user

Bash-3.00$ netca / / then opens a graphical interface for creating listeners. For subsequent configuration.

Bash-3.00$ lsnrctl status / / View listening status

3 > install the software and create a database using dbca on bjdb

Install oracle software on bjdb and shdb respectively

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.