Re: Cluster Interconnects configured in single-instance DB

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 5 Apr 2008 10:04:32 -0700 (PDT)
Message-ID: <325965.6244.qm@web80602.mail.mud.yahoo.com>

I just did a quick test. Not sure if it meets the requirement.

$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db
$ echo db_name=test > /u01/app/oracle/product/10.2.0/db/dbs/inittest.ora
$ export ORACLE_SID=test
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Apr 5 11:55:51 2008

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes

Fixed Size                  2180800 bytes
Variable Size             115128640 bytes
Database Buffers           50331648 bytes
Redo Buffers                4325376 bytes

ORA-00205: error in identifying control file, check alert log for more info

SQL> select * from v$cluster_interconnects;

NAME IP_ADDRESS IS_ SOURCE

--------------- ---------------- --- -------------------------------
bond1           192.168.2.18     NO  Oracle Cluster Repository

SQL> sho parameter cluster

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     FALSE
cluster_database_instances           integer     1
cluster_interconnects                string

SQL> sho parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      test

We already have a RAC database running using this ORACLE_HOME. (ASM is on these nodes too using a different ORACLE_HOME.) This test database, or rather instance, is obviously RAC enabled, even though the cluster_database parameter is false (default).

$ ps -ef | grep test | head -5

oracle   12174     1  0 11:55 ?        00:00:00 ora_pmon_test
oracle   12176     1  0 11:55 ?        00:00:00 ora_diag_test
oracle   12178     1  0 11:55 ?        00:00:00 ora_psp0_test
oracle   12180     1  0 11:55 ?        00:00:00 ora_lmon_test
oracle   12182     1  0 11:55 ?        00:00:00 ora_lmd0_test

Yong Huang

---

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 05 2008 - 12:04:32 CDT