上续的系统配置,环境变量添加和grid安装在上一篇博客中,这篇主要是继上篇剩余的安装,上篇博客地址:http://tongcheng.blog.51cto.com/6214144/1852074
1.检查oracle database安装的先决条件(用grid软件包中的runcluvfy.sh脚本)
[grid@rac1 grid]$ ./runcluvfy.sh stage -pre dbinst -n rac1,rac2 -osdba dba
.................................
Pre-check for database installation was successful. --必须条件成功才能安装
[grid@rac1 grid]$ ./runcluvfy.sh stage -pre dbcfg -n rac1,rac2 -d
2.orale数据库安装
[oracle@rac1 database]$ ./runInstaller
rac1节点1执行root.sh脚本
rac2节点2执行root.sh脚本
3.创建asm磁盘组
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ asmca
4.创建数据库
[root@rac1 ~]# xhost +
access control disabled, clients can connect from any host
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ dbca
5.登陆数据库
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Sep 18 13:10:57 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show release;
release 1102000400
SQL> select file#,ts#,name,status from v$datafile;
FILE# TS# NAME STATUS
---------------------------------------------------------------------------------
1 0 +DATA/racdb/datafile/system.256.922882375 SYSTEM
2 1 +DATA/racdb/datafile/sysaux.257.922882383 ONLINE
3 2 +DATA/racdb/datafile/undotbs1.258.922882385 ONLINE
4 4 +DATA/racdb/datafile/users.259.922882385 ONLINE
5 5 +DATA/racdb/datafile/undotbs2.264.922882991 ONLINE
SQL>
