Oracle linux installation and oraclelinux Installation

Oracle linux installation and oraclelinux Installation

Vi/etc/sysconfig/network change the host name to orcale

 

Vi/etc/hosts modify ing

IP + Host Name

Configure YUM

 

Install
Yum install binutils compat-libcap1 compat-libstdc ++-33 compat-libstdc ++-33 gcc-c ++ glibc-devel ksh libgcc libstdc ++ + libstdc ++-devel libaio-devel make sysstat unixODBC-devel elfutils-libelf-devel

Upload and decompress
OracleDepends_redhator cents (rpm)

And install (11 packages in total)
Rpm-ivh compat-libstdc +-33-3.2.3-61.i386.rpm elfutils-libelf-devel-0.125-3.el5.x86_64.rpm libgcc-3.4.6-8.i386.rpm unixODBC-2.2.11-7.1.i386.rpm libstdc +-3.4.6-3.1.i386.rpm unixODBC-devel-2.2.11-7.1.i386.rpm pdksh-5.2.14-1.i386.rpm pdksh-5.2.14-30.x86_64.rpm libaio-0.3.105-2.i386.rpm libaio-devel-0.3.105-2.i386.rpm glibc-2.12-1.25.el6.i686.rpm -- nodeps -- force

Create a group and set the User Password
Groupadd oinstall
Groupadd dba
Useradd-g oinstall-G dba oracle (add user to group)
Passwd oracle

 

Id oracle (view User)

Vi/etc/oraInst. loc
Inventory_loc =/soft/app/oraInventory
Inst_group = oinstall

 

Vi/etc/sysctl. conf (modify system information)

Fs. aio-max-nr = 1048576

Fs. file-max = 6815744 indicates the maximum number of handles that can be opened by a process at the same time. This parameter directly limits the maximum number of concurrent connections.

# Kernel. shmall = 2097152 all memory size (unit: Page, 1 page = 4 KB), calculation formula 16G * 1024*1024*1024/4 KB (page)

# Kernel. shmmax = 536870912 size of a single shared memory segment (unit: bytes). The formula is 64 GB * 1024*1024*1024 (bytes)

Kernel. shmmni = 4096

Kernel. sem = 250 32000 100 128 is the definition of semaphore. We recommend that you set sem to 250 32000 100 128 or higher. in a database with a high concurrency, this value can be set to PROCESSES + 10, and SEMMNI needs to be increased accordingly. the purpose is to reduce the competition for semaphore during IPC communication. SEMOPM defines the semaphore affected by each IPC call. We recommend that you set SEMOPM = SEMMSL and SEMMNS to (SEMMSL * SEMMNI ).

 

Net. ipv4.ip _ local_port_range = 9000 65500 external connection port range

Net. core. rmem_default = 262144 is the default memory reserved for TCP socket for receiving buffering (unit: byte

Net. core. rmem_max = 4194304 is the maximum memory reserved for TCP socket for receiving buffering (unit: byte

Net. core. wmem_default = 262144 is the default memory reserved for TCP socket for sending buffering (unit: bytes)

Net. core. wmem_max = 1048576 is the maximum memory reserved for the TCP socket for sending buffer (unit: bytes)

 

Sysctl-p to make the above configuration take effect

 

Vi/etc/security/limits. conf
Oracle soft nproc 2047
Oracle hard nproc 16384 | maximum number of nproc Processes
Oracle soft nofile 1024 | maximum number of files opened by nofile
Oracle hard nofile 65536 |
Oracle soft stack 10240 | maximum stack size

Create directory

Mkdir-p/soft/app/
Chown-R oracle: oinstall/soft/app/modify File Ownership
Chmod-R 755/soft/app/permission

 

Upload linux.x64_11gr2_database_1of2.zipand linux.x64_11gr2_database5of2.zip to/tmp.

Extract
Unzip linux.x64_11gr2_database5of2.zip
Unzip linux.x64_11gR2_database_1of2.zip

Decompress the package to obtain the database.
Chown-R oracle: oinstall/tmp/database/
Back Up Files under database/response/

Modify db_install.rsp
Oracle. install. option = INSTALL_DB_SWONLY
ORACLE_HOSTNAME = oracle
UNIX_GROUP_NAME = oinstall
INVENTORY_LOCATION =/soft/app/oraInventory
ORACLE_HOME =/soft/app/oracle/product/11.2.0/db_1
ORACLE_BASE =/soft/app/oracle
Oracle. install. db. InstallEdition = EE
Oracle. install. db. DBA_GROUP = dba
Oracle. install. db. OPER_GROUP = oinstall
DECLINE_SECURITY_UPDATES = true

Go to su-l oracle

Cd/tmp/database/

Run
./RunInstaller-silent-noconfig-responseFile/tmp/database/response/db_install.rsp-ignoreSysPrereqs
Note that the storage space is larger than 4.6 GB
The swap space is larger than 12.8 GB.

How to Increase swap space
Add a hard drive 60 GB
Fdisk/dev/sdb
N
P
1
7804
W

Get sdb1
Mkswap/sdb1
Swapon/sdb1

Write/etc/fstab
/Dev/sdb1 swap defaults 0 0

Dd if =/dev/zero of =/swapfile1 bs = 1024 k count = 12000

Mkswap/swapfile1
Swapon/swapfile1

Write/etc/fstab
/Swapfile1 swap defaults 0 0

 

Under an oracle user
Vi. bash_profile
PATH = $ PATH: $ HOME/bin:/soft/app/oracle/product/11.2.0/db_1/bin/

Export PATH

Export DISPLAY = "192.168.6.1: 0.0" # The address is the address managed by Xmanger. # // IP

Export ORACLE_HOME =/soft/app/oracle/product/11.2.0/db_1/

Run source. bash_profile

Netca-silent-responseFile/tmp/database/response/netca. rsp

Lsnrctl status restart
Lsnrctl reload
Lsnrctl status
Export ORACLE_SID = orcl11g
Sqlplus/as sysdba
Log on to SQL
Run
/Soft/app/oracle/product/11.2.0/db_1/bin/dbca-silent-responseFile/tmp/database/response/dbca. rsp

 

Under the root user
Run
/Soft/app/oracle/product/11.2.0/db_1/root. sh

Vi/soft/app/oracle/product/11.2.0/db_1/network/admin/listener. ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl11g)
(ORACLE_HOME =/soft/app/oracle/product/11.2.0/db_1 /)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl11.us.oracle.com)
(ORACLE_HOME =/soft/app/oracle/product/11.2.0/db_1 /)
(SID_NAME = orcl11g)
)
)

 

 

 

Modify
/Tmp/database/response/dbca. rsp
GDBNAME = "orcl11g.tzvtc.com"
SID = "orcl11g"
SYSPASSWORD = "as sysdba"
SYSTEMPASSWORD = "manager"
GDBNAME = "orcl11.tzvtc.com"
DB_UNIQUE_NAME = "orcl11g.tzvtc.com"
DB_UNIQUE_NAME = "orcl11g.tzvtc.com"