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
