共计 3976 个字符,预计需要花费 10 分钟才能阅读完成。
自动写代码机器人,免费开通
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
向 AI 问一下细节丸趣 TV 网 – 提供最优质的资源集合!