oracle 12c for linux 6.6 installation

1、查看RHEL操作系统版本，本次安装所选操作系统是oracle linux server 6.6

[root@oradb oracle]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.6 (Santiago)

[root@oradb oracle]#

2、编辑并查看hosts文件主机名解析

vi /etc/hosts

192.168.56.10 oradb

[root@oradb oracle]# cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.56.10 oradb

[root@oradb oracle]#

3、创建并查看执行安装oracle12c的操作系统用户

[root@oradb ~]# groupadd -g 1000 oinstall

[root@oradb ~]# groupadd -g 1001 dba

[root@oradb ~]# useradd -u 888 -g oinstall -G dba oracle

[root@oradb ~]# id ora12c

uid=888(ora12c) gid=1000(oinstall) groups=1000(oinstall),1001(dba)

[root@oradb oracle]#

4、编辑并查看执行安装oracle12c操作系统用户的环境变量

vi /home/ora12c/.bash_profile

export PATH

export ORACLE_BASE=/oradata/oracle/ora12c

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.1/db

export ORACLE_SID=ora12c

export PATH=$PATH:$ORACLE_HOME/bin

[root@oradb oracle]# cat /home/ora12c/.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/oradata/oracle/ora12c

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.1/db

export ORACLE_SID=ora12c

export PATH=$PATH:$ORACLE_HOME/bin

[root@oradb oracle]#

5、编辑并查看内核参数

[root@oradb oracle]#vi /etc/sysctl.conf

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

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@oradb oracle]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

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@oradb oracle]#

6、编辑Oracle12c安装用户的软硬限制

[root@oradb oracle]# cat /etc/security/limits.conf

ora12c soft nproc 2047

ora12c hard nproc 16386

ora12c soft nofile 1024

ora12c hard nofile 65536

7、查看并安装oracle12c依赖的操作系统RPM包

[root@oradb ~]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \

> compat-libcap \

> compat-libstdc++ \

> gcc \

> gcc-c++ \

> glibc- \

> glibc \

> ksh \

> libgcc\

> libstdc++ \

> libstdc++-devel \

> libaio-0.3.107 \

> libaio-devel \

> libXext \

> libXtst \

> libX11 \

> libXau \

> libxcb \

> libXi \

> make \

> sysstat

binutils-2.20.51.0.2-5.42.el6 (x86_64)

package compat-libcap is not installed

package compat-libstdc++ is not installed

gcc-4.4.7-11.el6 (x86_64)

gcc-c++-4.4.7-11.el6 (x86_64)

glibc-2.12-1.149.el6 (x86_64)

glibc-2.12-1.149.el6 (i686)

glibc-2.12-1.149.el6 (x86_64)

glibc-2.12-1.149.el6 (i686)

ksh-20120801-21.el6 (x86_64)

package libgcclibstdc++ is not installed

libstdc++-devel-4.4.7-11.el6 (x86_64)

libaio-0.3.107-10.el6 (x86_64)

libaio-devel-0.3.107-10.el6 (x86_64)

libXext-1.3.2-2.1.el6 (x86_64)

libXtst-1.2.2-2.1.el6 (x86_64)

libX11-1.6.0-2.2.el6 (x86_64)

libXau-1.0.6-4.el6 (x86_64)

libxcb-1.9.1-2.el6 (x86_64)

libXi-1.7.2-2.2.el6 (x86_64)

make-3.81-20.el6 (x86_64)

sysstat-9.0.4-27.el6 (x86_64)

7-1、缺包安装

[root@oradb ~]# rpm –ivh ksh-20120801-21.el6.x86_64.rpm

warning: ksh-20120801-21.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing... ########################################### [100%]

1:ksh ########################################### [100%]

[root@oradb Packages]#

8、同一操作系统多版本并存时，直接运行runInstaller报错，需要手动指定oraInventory目录

[ora12c@oradb database]$ ./runInstaller

You do not have sufficient permissions to access the inventory '/home/oracle/oraInventory'. Installation cannot continue. It is required that the primary group of the install user is same as the inventory owner group. Make sure that the install user is part of the inventory owner group and restart the installer.: Permission denied

[ora12c@oradb database]$ ./runInstaller -invPtrLoc /oradata/oracle/ora12c/

Starting Oracle Universal Installer...

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

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

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-13_05-43-06PM. Please wait ...[ora12c@oradb database]$

8-1、Configure Security Updates

8-1、My Oracle Support

8-2、Software Updates -->Skip software updates

8-3、Installation Option -->Install database software only

8-4 Grid Installation Options -->Single instance database installation

8-5、Product Languages -->English

8-6 、Database Edition -->Enterprise Edition

8-7、 Installation Location

8-8、Create Inventory

8-9、 Operation System Groups

8-11、 Summary

8-12、安装完成时弹出运行脚本窗口

/oradata/oracle/oraInventory/orainstRoot.sh

/oradata/oracle/ora12c/product/12.1.0.1/db/root.sh

[root@oradb Packages]# /oradata/oracle/oraInventory/orainstRoot.sh

Changing permissions of /oradata/oracle/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /oradata/oracle/oraInventory to oinstall.

The execution of the script is complete.

[root@oradb Packages]# /oradata/oracle/ora12c/product/12.1.0.1/db/root.sh

Performing root user operation for Oracle 12c

The following environment variables are set as:

ORACLE_OWNER= ora12c

ORACLE_HOME= /oradata/oracle/ora12c/product/12.1.0.1/db

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

[root@oradb Packages]#

8-13、Finish

9、查看操作系统版本

[ora12c@oradb ~]$ sqlplus -v

SQL*Plus: Release 12.1.0.1.0 Production

[ora12c@oradb ~]$

10、netca创建监听程序

[ora12c@oradb ~]$ netca

10-1 、Listener configuration

10-2 Add

10-3 Listener name

10-4 、 Select Protocols

10-5、TCP/IP Protocol

10-6、 More Listeners -->No

10-7、Done -->Next

10-8 Welcome -->Finish

Oracle Net Services Configuration:

Configuring Listener:LISTENER

Listener configuration complete.

Oracle Net Listener Startup:

Running Listener Control:

/oradata/oracle/ora12c/product/12.1.0.1/db/bin/lsnrctl start LISTENER

Listener Control complete.

Listener started successfully.

Oracle Net Services configuration successful. The exit code is 0

[ora12c@oradb ~]$

11、查看监听状态

[ora12c@oradb ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 09-DEC-2016 11:00:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 09-DEC-2016 10:59:29

Uptime 0 days 0 hr. 0 min. 41 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oradata/oracle/ora12c/product/12.1.0.1/db/network/admin/listener.ora

Listener Log File /oradata/oracle/ora12c/diag/tnslsnr/oradb/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

[ora12c@oradb ~]$

13、dbca创建数据库

[ora12c@oradb ~]$ dbca

13-1 Database Operation -->Create Database

13-2、Creation Mode -->Advanced Mode

13-3、Database Template -->General Purpose or Transaction Processin

13-4 、Database Identification

13-5、Management Options -->Configure Enterprise Manager (EM) Database Express

13-6、 Database Credentials

13-7 Network Configuration

13-8、Storage Locations

13-9 、Database Options

13-10、Initallzation Parameters

13-10、Initalization Parameters --Character Sets -->ZHS16GBK

13-10、Initalization Parameters --Connection Mode

13-11 、Creation Options

13-12、Summary

13-14、Database Configuration Assistant

13-14、Database Configuration Assistant

13-14、Database Configuration Assistant

13-14、Database Configuration Assistant

13-14、Password Management

13-14、Database Configuration Assistant

13-14、Progress Page

14、查看监听状态

[ora12c@oradb ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 09-DEC-2016 11:24:46

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 09-DEC-2016 10:59:29

Uptime 0 days 0 hr. 25 min. 18 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oradata/oracle/ora12c/product/12.1.0.1/db/network/admin/listener.ora

Listener Log File /oradata/oracle/ora12c/diag/tnslsnr/oradb/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oradb)(PORT=5500))(Security=(my_wallet_directory=/oradata/oracle/ora12c/admin/ora12c/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "ora12c" has 1 instance(s).

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

Service "ora12cXDB" has 1 instance(s).

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

The command completed successfully

15、查看数据库进程

[ora12c@oradb ~]$ ps -ef|grep ora_

ora12c 9010 1 0 11:19 ? 00:00:00 ora_pmon_ora12c

ora12c 9012 1 0 11:19 ? 00:00:00 ora_psp0_ora12c

ora12c 9014 1 6 11:19 ? 00:00:23 ora_vktm_ora12c

ora12c 9018 1 0 11:19 ? 00:00:00 ora_gen0_ora12c

ora12c 9020 1 0 11:19 ? 00:00:00 ora_mman_ora12c

ora12c 9024 1 0 11:19 ? 00:00:00 ora_diag_ora12c

ora12c 9026 1 0 11:19 ? 00:00:00 ora_dbrm_ora12c

ora12c 9028 1 0 11:19 ? 00:00:00 ora_dia0_ora12c

ora12c 9030 1 0 11:19 ? 00:00:00 ora_dbw0_ora12c

ora12c 9032 1 0 11:19 ? 00:00:00 ora_lgwr_ora12c

ora12c 9034 1 0 11:19 ? 00:00:00 ora_ckpt_ora12c

ora12c 9036 1 0 11:19 ? 00:00:00 ora_smon_ora12c

ora12c 9038 1 0 11:19 ? 00:00:00 ora_reco_ora12c

ora12c 9040 1 0 11:19 ? 00:00:00 ora_lreg_ora12c

ora12c 9042 1 0 11:19 ? 00:00:00 ora_mmon_ora12c

ora12c 9044 1 0 11:19 ? 00:00:00 ora_mmnl_ora12c

ora12c 9046 1 0 11:19 ? 00:00:00 ora_d000_ora12c

ora12c 9048 1 0 11:19 ? 00:00:00 ora_s000_ora12c

ora12c 9060 1 0 11:19 ? 00:00:00 ora_tmon_ora12c

ora12c 9062 1 0 11:19 ? 00:00:00 ora_arc0_ora12c

ora12c 9064 1 0 11:19 ? 00:00:00 ora_arc1_ora12c

ora12c 9066 1 0 11:19 ? 00:00:00 ora_arc2_ora12c

ora12c 9068 1 0 11:19 ? 00:00:00 ora_arc3_ora12c

ora12c 9070 1 0 11:19 ? 00:00:00 ora_tt00_ora12c

ora12c 9072 1 0 11:19 ? 00:00:00 ora_smco_ora12c

ora12c 9074 1 0 11:19 ? 00:00:00 ora_fbda_ora12c

ora12c 9076 1 0 11:19 ? 00:00:00 ora_aqpc_ora12c

ora12c 9080 1 0 11:19 ? 00:00:00 ora_p000_ora12c

ora12c 9082 1 0 11:19 ? 00:00:00 ora_p001_ora12c

ora12c 9084 1 0 11:19 ? 00:00:00 ora_p002_ora12c

ora12c 9086 1 0 11:19 ? 00:00:00 ora_p003_ora12c

ora12c 9088 1 0 11:19 ? 00:00:00 ora_cjq0_ora12c

ora12c 9113 1 0 11:19 ? 00:00:00 ora_w000_ora12c

ora12c 9121 1 0 11:19 ? 00:00:00 ora_qm02_ora12c

ora12c 9125 1 0 11:19 ? 00:00:00 ora_q002_ora12c

ora12c 9127 1 0 11:19 ? 00:00:00 ora_q003_ora12c

ora12c 16115 3184 0 11:24 pts/2 00:00:00 grep ora_

[ora12c@oradb ~]$

16、登录数据库查看数据库版本

17-1、登录EM

17-2、登录EM

17-3、EM