| Neeraj |
Posted: Oct 05, 2007 06:17:31 AM |
Total Post: 189
Joined: Jan, 2007
|
HI,
IF I START AN EXISTING DATABASE SO HOW CAN I KNOW THIS DATABASE IS RUNING WITH RAC OR WITHOUT RAC.
|
|
|
 ora11g |
| Posted: Oct 09, 2007 01:19:32 AM |  |
|
Total Post: 5
Joined: Oct, 2007
|
A database is clustered if it is defined to open in shared mode. you can check if the database is clustered or not by looking at the init.ora parameter CLUSTERED_DATABASE which needs to be set to TRUE for the RAC.
It can be single instance RAC or multi-Instance RAC.
-Bhavin
http://www.oracledba.org
--------
|
|
|
|
|
| ora11g |
| Posted: Oct 09, 2007 10:50:51 AM | |
|
Total Post: 5
Joined: Oct, 2007
|
The below information confirms that the database that you connect to is cluster database.
----------------
SQL> select name from v$database;
NAME
---------
RATESP
SQL> set linesize 200
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 7
cluster_interconnects string
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
dclndratdb01:>crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
dclndratdb01:>
dclndratdb01:>srvctl config database
tstp
ratesp
dclndratdb01:>
------------------------------
|
|
|
|
|
| Neeraj |
| Posted: Oct 10, 2007 04:37:11 AM | |
|
Total Post: 189
Joined: Jan, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
