Oracle 10203 RAC Environment Add new node (iv) Add a database instance on a new node

Briefly describe the process of adding a node in the Oracle 10203 for Solaris SPARC Dual-node environment. Shared storage is already configured on a third node, which focuses on the configuration on the operating system and on Oracle.

This article adds a database instance on a new node.

First make sure that the database is in a startup state if the database is not started:

bash-2.03$ srvctl start inst-d testrac-i testrac1

bash-2.03$ srvctl start inst-d testrac-i testrac2

Make sure that the listener is in the startup state and, if not, use Lsnrctl start to start listening:

bash-2.03$ Lsnrctl Start

Lsnrctl for Solaris:version 10.2.0.3.0-production on January-February-2009 00:22:24

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Start/data/oracle/product/10.2/database/bin/tnslsnr: Please wait ...

Tnslsnr for Solaris:version 10.2.0.3.0-production

System parameter file is/data/oracle/product/10.2/database/network/admin/listener.ora

Write log information for/data/oracle/product/10.2/database/network/log/listener.log

Listening: (Description= (Address= (protocol=tcp) (host=172.25.198.225) (port=1521))

Listening: (Description= (Address= (PROTOCOL=IPC) (KEY=EXTPROC0))

Connecting to (Description= (address= (protocol=tcp) (host=172.25.198.225) (port=1521))

Status of the Listener

------------------------

Alias LISTENER

Version Tnslsnr for Solaris:version 10.2.0.3.0-production

Launch date January-February-2009 00:22:26

Uptime 0 days 0 hours 0 minutes 0 seconds

Trace level off

Security On:local OS Authentication

SNMP off

Listener parameter File/data/oracle/product/10.2/database/network/admin/listener.ora

Listener log File/data/oracle/product/10.2/database/network/log/listener.log

Monitor Endpoint Summary ...

(Description= (address= (protocol=tcp) (host=172.25.198.225) (port=1521))

(Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC0))

Service summary.

The service "Plsextproc" contains 1 routines.

Routine "Plsextproc", state Unknown, contains 1 handlers for this service ...

The service "Testrac" contains 1 routines.

Routine "Testrac2", state Unknown, contains 1 handlers for this service ...

Command execution succeeded

For new nodes, you can first configure the listener through NETCA:

$ netca

Oracle Net Services Configuration:

First select cluster Configuration, then select the entire table 3 nodes, select Listener Configuration, select Add, enter the listener name.

In the graphical interface environment to run DBCA Add instances error, because DBCA for ASM support problems, can only choose to add the instance manually:

First, the UNDOTBS3 table space is established and the corresponding REDO.LOG method is THREAD3:

Sql> Select group#, thread#, sequence#, bytes/1024/1024

2 from V$log;

group# thread# sequence# bytes/1024/1024

---------- ---------- ---------- ---------------

1 1 1716 512

2 1 1717 512

3 2 839 512

4 2 840 512

Sql> Select member from V$logfile;

Member

---------------------------------------------------

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/