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

Source: Internet
Author: User
Tags thread

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/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.