重庆分公司,新征程启航
为企业提供网站建设、域名注册、服务器等服务
Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(5)
创新互联建站专注于元宝企业网站建设,响应式网站开发,购物商城网站建设。元宝网站建设公司,为元宝等地区提供建站服务。全流程按需求定制开发,专业设计,全程项目跟踪,创新互联建站专业和态度为您提供的服务
一、安装Oracle软件
以Oracle身份安装:
四、验证
[oracle@aix203 ~]$crs_stat -t
Name Type Target State Host ------------------------------------------------------------ ora....03.lsnr application ONLINE ONLINE aix203 ora.aix203.gsd application ONLINE ONLINE aix203 ora.aix203.ons application ONLINE ONLINE aix203 ora.aix203.vip application ONLINE ONLINE aix203 ora....04.lsnr application ONLINE ONLINE aix204 ora.aix204.gsd application ONLINE ONLINE aix204 ora.aix204.ons application ONLINE ONLINE aix204 ora.aix204.vip application ONLINE ONLINE aix204 ora.prod.db application ONLINE ONLINE aix204 ora....d1.inst application ONLINE ONLINE aix203 ora....d2.inst application ONLINE ONLINE aix204
连接和访问数据库:
[oracle@aix203 ~]$sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 16 18:12:43 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS ---------------- ------------ prod1 OPEN prod2 OPEN
SQL> select name from v$datafile;
NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/prod/system01.dbf /u01/app/oracle/oradata/prod/undotbs01.dbf /u01/app/oracle/oradata/prod/sysaux01.dbf /u01/app/oracle/oradata/prod/users01.dbf /u01/app/oracle/oradata/prod/example01.dbf /u01/app/oracle/oradata/prod/undotbs02.dbf 6 rows selected.