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

共计 3976 个字符，预计需要花费 10 分钟才能阅读完成。

自动写代码机器人，免费开通

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

向 AI 问一下细节

丸趣 TV 网 – 提供最优质的资源集合！