共計 3976 個字符，預(yù)計需要花費 10 分鐘才能閱讀完成。
自動寫代碼機器人，免費開通
oracle 10g cluster 安裝地址:http://tongcheng.blog.51cto.com/6214144/1872157
oracle rac 專業(yè)群:476687362
oracle dba 專業(yè)群: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 節(jié)點:
[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 節(jié)點:
[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. 創(chuàng)建數(shù)據(jù)庫
[oracle@rac10g01 database]$ dbca
3. 檢查 cluster 和 database 是否成功
rac10g01 節(jié)點:
[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 節(jié)點:
[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. 登陸數(shù)據(jù)庫
rac10g01 節(jié)點:
[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 問一下細(xì)節(jié)丸趣 TV 網(wǎng) – 提供最優(yōu)質(zhì)的資源集合！
