oracle linux 4.8安装oracle 10g rac环境之database安装

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>