oracle linux 5.8安装oracle 11g rac环境之oracle安装
上续的系统配置,环境变量添加和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>
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341