oracle 10g cluster安裝地址:http://tongcheng.blog.51cto.com/6214144/1872157
為企業(yè)提供成都網(wǎng)站制作、成都網(wǎng)站建設(shè)、網(wǎng)站優(yōu)化、營(yíng)銷(xiāo)型網(wǎng)站建設(shè)、競(jìng)價(jià)托管、品牌運(yùn)營(yíng)等營(yíng)銷(xiāo)獲客服務(wù)。成都創(chuàng)新互聯(lián)公司擁有網(wǎng)絡(luò)營(yíng)銷(xiāo)運(yùn)營(yíng)團(tuán)隊(duì),以豐富的互聯(lián)網(wǎng)營(yíng)銷(xiāo)經(jīng)驗(yàn)助力企業(yè)精準(zhǔn)獲客,真正落地解決中小企業(yè)營(yíng)銷(xiāo)獲客難題,做到“讓獲客更簡(jiǎn)單”。自創(chuàng)立至今,成功用技術(shù)實(shí)力解決了企業(yè)“網(wǎng)站建設(shè)、網(wǎng)絡(luò)品牌塑造、網(wǎng)絡(luò)營(yíng)銷(xiāo)”三大難題,同時(shí)降低了營(yíng)銷(xiāo)成本,提高了有效客戶轉(zhuǎn)化率,獲得了眾多企業(yè)客戶的高度認(rèn)可!
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>