大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
oracle 10g cluster安装地址:http://tongcheng.blog.51cto.com/6214144/1872157
为企业提供成都网站制作、成都网站建设、网站优化、营销型网站建设、竞价托管、品牌运营等营销获客服务。成都创新互联公司拥有网络营销运营团队,以丰富的互联网营销经验助力企业精准获客,真正落地解决中小企业营销获客难题,做到“让获客更简单”。自创立至今,成功用技术实力解决了企业“网站建设、网络品牌塑造、网络营销”三大难题,同时降低了营销成本,提高了有效客户转化率,获得了众多企业客户的高度认可!
oracle rac专业群:476687362
oracle dba专业群:581851278
1.安装oracle database软件
[root@rac10g01 ~]# xhost +
access control disabled, clients can connect from any host
[root@rac10g01 ~]# su - oracle
[oracle@rac10g01 ~]$ cd database/
[oracle@rac10g01 database]$ ./runInstaller
rac10g01节点:
[root@rac10g01 ~]# sh /u01/oracle/product/10.2.0.1/db_1/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/oracle/product/10.2.0.1/db_1
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.sh script.
Now product-specific root actions will be performed.
[root@rac10g01 ~]#
rac10g02节点:
[root@rac10g02 ~]# sh /u01/oracle/product/10.2.0.1/db_1/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/oracle/product/10.2.0.1/db_1
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.sh script.
Now product-specific root actions will be performed.
[root@rac10g02 ~]#
2.创建数据库
[oracle@rac10g01 database]$ dbca
3.检查cluster和database是否成功
rac10g01节点:
[oracle@rac10g01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.rac10g.db application ONLINE ONLINE rac10g02
ora....c10g.cs application ONLINE ONLINE rac10g02
ora....0g1.srv application ONLINE ONLINE rac10g01
ora....0g2.srv application ONLINE ONLINE rac10g02
ora....g1.inst application ONLINE ONLINE rac10g01
ora....g2.inst application ONLINE ONLINE rac10g02
ora....SM1.asm application ONLINE ONLINE rac10g01
ora....01.lsnr application ONLINE ONLINE rac10g01
ora....g01.gsd application ONLINE ONLINE rac10g01
ora....g01.ons application ONLINE ONLINE rac10g01
ora....g01.vip application ONLINE ONLINE rac10g01
ora....SM2.asm application ONLINE ONLINE rac10g02
ora....02.lsnr application ONLINE ONLINE rac10g02
ora....g02.gsd application ONLINE ONLINE rac10g02
ora....g02.ons application ONLINE ONLINE rac10g02
ora....g02.vip application ONLINE ONLINE rac10g02
[oracle@rac10g01 ~]$
rac10g02节点:
[oracle@rac10g02 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.rac10g.db application ONLINE ONLINE rac10g02
ora....c10g.cs application ONLINE ONLINE rac10g02
ora....0g1.srv application ONLINE ONLINE rac10g01
ora....0g2.srv application ONLINE ONLINE rac10g02
ora....g1.inst application ONLINE ONLINE rac10g01
ora....g2.inst application ONLINE ONLINE rac10g02
ora....SM1.asm application ONLINE ONLINE rac10g01
ora....01.lsnr application ONLINE ONLINE rac10g01
ora....g01.gsd application ONLINE ONLINE rac10g01
ora....g01.ons application ONLINE ONLINE rac10g01
ora....g01.vip application ONLINE ONLINE rac10g01
ora....SM2.asm application ONLINE ONLINE rac10g02
ora....02.lsnr application ONLINE ONLINE rac10g02
ora....g02.gsd application ONLINE ONLINE rac10g02
ora....g02.ons application ONLINE ONLINE rac10g02
ora....g02.vip application ONLINE ONLINE rac10g02
[oracle@rac10g02 ~]$
4.登陆数据库
rac10g01节点:
[oracle@rac10g01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 13 21:29:15 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 * from dual;
D
-
X
SQL> select inst_id,name from gv$database;
INST_ID NAME
---------- ---------
2 RAC10G
1 RAC10G
SQL>