IT技术互动交流平台

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

作者:一起走过的日子  来源:IT165收集  发布日期:2016-11-14 20:23:33

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

wKiom1gn9I2BtgE4AAMCjGP2zP0953.png-wh_50

wKioL1gn9I6QZA8iAAMUuYFwN-I074.png-wh_50

wKiom1gn9I-zqvymAAMDeWXS7z4186.png-wh_50

wKioL1gn9JHw3QgZAAKpUojyUN8946.png-wh_50

wKioL1gn9MaBxEnmAAI9kzI348w161.png-wh_50

wKiom1gn9MfQDaApAAMm_GVWwEc127.png-wh_50

wKioL1gn9MiCsLhYAAFWXQVvUhk606.png-wh_50

QTlwSkFBTUIwNXlzczhZMDIzLnBuZy13aF81MA==" />

wKiom1gn9Mnz8C3tAAAsxb5CAPo248.png-wh_50

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 ~]#

wKioL1gn9MrDkN75AAGLuksNQaI967.png-wh_50

2.创建数据库

[oracle@rac10g01 database]$ dbca

wKioL1gn9beQ3nynAADmyEakUOs934.png-wh_50

wKiom1gn9bfxHhGwAADdn0EGlYg778.png-wh_50

wKiom1gn9bjTsnGwAACsQb9zlx8442.png-wh_50

wKioL1gn9biSqHJBAAC_wHK5hzk537.png-wh_50

wKioL1gn9biSQoSvAADFGtfO1RY712.png-wh_50

wKiom1gn9bmwL0RZAADXnzPbwkg809.png-wh_50

wKiom1gn9bqwr-OxAADDnHeaDr0569.png-wh_50

wKioL1gn9buj6KcKAADTkMOnB8c408.png-wh_50

wKiom1gn9bySZ1V-AADXr1Gz9wA390.png-wh_50

wKioL1gn9b2StHCMAADeyyBESqU818.png-wh_50

wKioL1gn9b3R4OIjAADFvx3U_U8295.png-wh_50

QTRNYjdZMzFNMjk5LnBuZy13aF81MA==" />

wKioL1gn9b7RG8vaAADJrOMzS5M800.png-wh_50

wKiom1gn9b7B3kZpAADP2-CrOqM036.png-wh_50

wKioL1gn9b_ycyYDAADS0GmMjhs848.png-wh_50

wKiom1gn9cCDNeYtAACrH2m-YLU946.png-wh_50

wKiom1gn9cDzrYl5AABMt7ch9ow327.png-wh_50

wKioL1gn9cHig5ecAADxpQ0BeS4229.png-wh_50

wKioL1gn9cHxI5OeAABX3UveS8c429.png-wh_50

wKiom1gn9cKBQ-aMAADX_6YCKKI798.png-wh_50

wKioL1gn9cKi01bkAABCPBvG-Gg468.png-wh_50

wKiom1gn9cLyeroBAAC0NiNMsDo910.png-wh_50

wKiom1gn9cLjK-CnAAA5gGxYVaM032.png-wh_50


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>


Tag标签: 环境  
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规