Installation notes for Oracle11gR2 under 64-bit CentOS5.6

Installation notes for Oracle11gR2 under 64-bit CentOS5.6

Installation notes for Oracle 11gR2 under 64-bit CentOS 5.6

Basic Linux operations

Uname-r view kernel version

Df-m to view the space of each storage device

Du-sh: view the current directory space size

View processes and IO: top, mpstat-p all 1 100, iostat-x 1 10 (test IO performance)

Force Delete the rm-rf directory
Delete the empty directory rmdir

Set Linux vi/etc/sysctl. confg

Net. ipv4.ip _ forward = 0
Net. ipv4.conf. default. rp_filter = 1
Net. ipv4.conf. default. accept_source_route = 0
Net. ipv4.tcp _ syncookies = 1
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
Kernel. msgmnb = 65536
Kernel. msgmax = 655360
Kernel. shmmax = 68719476736
Kernel. shmall = 4294967296 (32-bit system, 1 page = 4 k)
Kernel. shmmni = 4096
Kernel. sysrq = 0
Kernel. core_uses_pid = 1
Kernel. sem = 250 32000 100 128
Fs. file-max = 6815744
Fs. aio-max-nr = 1048576

Application parameter sysctl-p

Set vi/etc/security/limits. conf

Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536

Set vi/etc/pam. d/login

Session required/lib/security/pam_limits.so
Session required pam_limits.so

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-g dba-m oracle

Passwd oracle

Next, create the Oralce root directory and installation directory.

Mkdir/data/ora11g

Mkdir/data/ora11g/product/11.2.0.1/dbhome_1

Set the Oracle directory. bash_profile

Export ORACLE_BASE =/data/ora11g
Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0.1/dbhome_1
Export ORACLE_SID = xxxx

Export ORACLE_TERM = xterm
Export PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64
# Export CLASSPATH = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib
Export LD_ASSUME_KERNEL = 2.6.18
Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
# Export NLS_LANG = "zh_CN.UTF-8"
Export LANG = zh_CN.UTF-8
Export LC_ALL = zh_CN.GB2312
Umask 022
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi

Run the xhost + command before switching from the root user to the oracle user for installation. Otherwise, the output cannot be found.

Note: all the files in the stage on the second disk are copied to the stage on the first disk. Otherwise, an error is reported during installation, indicating that the files on the second disk are not found (I wonder if there is any other method)

Install oracle software (do not create a database first)

Run the $ ORACLE_BASE/oraInventory/orainstRoot. sh and $ ORACLE_HOME/root. sh scripts.

Use dbca, netca, and netmgr to create data, configure local listeners, and manage connections

Start oracle listening lsnrctl start/stop/reload/status

Directory diag
Oracle's alert Log is ORACLE_BASE/diag/{product_type}/{product_id}/{instance_id} under ORACLE_BASE}
Alter is in the xml format log. xml
Trace is the text format alter _ {instance}. log

Directory admin
Currently, scripts for database creation are stored. The previous alertlog is no longer in this place.

After oracle is installed, an error is prompted when sqlplus is started.
Libclntsh. so.11.1: cannot restore segment prot after reloc: Permission deni

Solution:
Under root permission
Run
Semanage fcontext-a-t textrel_shlib_t path \ libclntsh. so.11.1

Execute restorecon-R-v path \ libclntsh. so.11.1

Add Environment Variables
Vi/etc/profile

Export
Export ORACLE_HOME = path

Export ORACLE_SID = orcl

Export PATH =: $ ORACLE_HOME

You can.

Dbca netca cannot be started

Set
HOSTNAME = resetting name in vi/etc/sysconfig/network

NETWORKING = yes

NETWORKING_IPV6 = no

HOSTNAME = mytest

GATEWAY = 127.0.0.1

Edit again
Vi/etc/hosts

In
127.0.0.1 localhost. localdomain localhost
Add the same name in the background

127.0.0.1 localhost. localdomain localhost mytest

Save

[Root @ localhost #] hostname mytest

You can.