SQL> alter database open resetlogs;
Database altered.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
DOMINIC READ WRITE
SQL> select comp_name, version, status from sys.dba_registry;
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
OWB
11.2.0.4.0 VALID
Oracle Application Express
3.2.1.00.12 VALID
Oracle Enterprise Manager
11.2.0.4.0 VALID
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
OLAP Catalog
11.2.0.4.0 VALID
Spatial
11.2.0.4.0 VALID
Oracle Multimedia
11.2.0.4.0 VALID
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle XML Database
11.2.0.4.0 VALID
Oracle Text
11.2.0.4.0 VALID
Oracle Expression Filter
11.2.0.4.0 VALID
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle Rules Manager
11.2.0.4.0 VALID
Oracle Workspace Manager
11.2.0.4.0 VALID
Oracle Database Catalog Views
11.2.0.4.0 VALID
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle Database Packages and Types
11.2.0.4.0 VALID
JServer JAVA Virtual Machine
11.2.0.4.0 VALID
Oracle XDK
11.2.0.4.0 VALID
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle Database Java Packages
11.2.0.4.0 VALID
OLAP Analytic Workspace
11.2.0.4.0 VALID
Oracle OLAP API
11.2.0.4.0 VALID
18 rows selected.
SQL> select * from v$option where parameter = 'Real Application Clusters';
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Real Application Clusters
TRUE
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
SQL> show parameter thread;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_threads_per_cpu integer 2
thread integer 1
SQL> show parameter instance_number
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_number integer 1
SQL> show parameter cluster_database;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
SQL> show parameter cluster_database_instances
NAME TYPE VALUE
------------------------