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

OS：RHEL7.2

ORACLE 12C

Step 1: Install the required rpm package

yum install binutils libX11 compat-libcap1 libXau compat-libstdc++-33 libaio gcc libaio-devel gcc-c++ libdmx glibc-devel glibc ksh make libgcc sysstat libstdc++ xorg-x11-utils libstdc++-devel xorg-x11-xauth libXext libXv libXtst libXi libxcb libXt libXmu libXxf86misc libXxf86dga libXxf86vm nfs-utils smartmontools

Step 2: Modify kernel parameters

vim /etc/sysctl.d/98-oracle-kernel.conf

vm.swappiness = 1

vm.dirty_background_ratio = 3

vm.dirty_ratio = 80

vm.dirty_expire_centisecs = 500

vm.dirty_writeback_centisecs = 100

kernel.sem = 250 32000 100 128

fs.aio-max-nr = 1048576

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 = 65536

kernel.shmmax = 8589934590 ==8G, larger than SGA

kernel.shmall = 2147483648 ==8G

kernel.shmmni = 4096

sysctl -p /etc/sysctl.d/98-oracle-kernel.conf

Step3: Set user limits

vim /etc/security/limits.d/99-grid-oracle-limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

Step4: Add users

groupadd --gid 54321 oinstall

groupadd --gid 54322 dba

groupadd --gid 54326 oper

groupadd --gid 54327 backupdba

groupadd --gid 54328 dgdba

groupadd --gid 54329 kmdba

useradd --uid 54321 --gid oinstall --groups dba,oper,backupdba,dgdba,kmdba oracle

echo "oracle"|passwd --stdin oracle

Step5: Set the directory

mkdir -p /u01/app/12.2.0/grid

chown -R oracle.oinstall /u01

chmod -R 755 /u01

Step6: Setting environmental variables

su - oracle

vim .bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1

export ORACLE_SID=orcl

export PATH=$ORACLE_HOME/bin:$PATH;

Step 7: Start the installation

su - root

xhost +

su - oracle

[oracle@oracle12c database]$ ./ runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 7211 MB Passed

Checking swap space: must be greater than 150 MB. Actual 1023 MB Passed

Checking monitor: must be configured to display at least 256 colors

>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed select host_name,version from v$instance;

HOST_NAME VERSION

---------------------------------------- -----------------

oracle12c 12.2.0.1.0

SYS@orcl> ! lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 14-AUG-2018 00:59:07

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date 14-AUG-2018 00:12:27

Uptime 0 days 0 hr. 46 min. 44 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/oracle12c/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle12c)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oracle12c)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "7351e8ae5372218ee0539b6ba8c08d05" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orcl" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclpdb" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

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.