您好,登錄后才能下訂單哦!
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é)點(diǎn):
[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é)點(diǎn):
[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ù)庫(kù)
[oracle@rac10g01 database]$ dbca
3.檢查cluster和database是否成功
rac10g01節(jié)點(diǎn):
[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é)點(diǎn):
[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ù)庫(kù)
rac10g01節(jié)點(diǎn):
[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>
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。