千家信息网

oracle linux 5.8安装oracle 11g rac环境之oracle安装

发表于:2024-09-22 作者:千家信息网编辑
千家信息网最后更新 2024年09月22日,上续的系统配置,环境变量添加和grid安装在上一篇博客中,这篇主要是继上篇剩余的安装,上篇博客地址:http://tongcheng.blog.51cto.com/6214144/18520741.检
千家信息网最后更新 2024年09月22日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>

0