Shulou(Shulou.com)06/01 Report--

Oracle 10g cluster installation address: http://tongcheng.blog.51cto.com/6214144/1872157

Oracle rac Professional Group: 476687362

Oracle dba Professional Group: 581851278

1. Install oracle database softwar

[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 node:

[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 node:

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

two。 Create a database

[oracle@rac10g01 database] $dbca

3. Check whether cluster and database are successful

Rac10g01 node:

[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 node:

[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. Log in to database

Rac10g01 node:

[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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.