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>