Oracle Database Discussions

OS:HPUX
Oracle version: 11.1.0.7

why TNS service name gives priority to connect instance which is in a mount mode?
I have four node rac cluster and four instance, one instance on each node and status of instances are as shown below

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME STATUS
---------------- ------------
dtrac1 OPEN
dtrac4 STARTED
dtrac3 OPEN
dtrac2 MOUNTED

I have tried to connect using "dtrac" service name ( details of tnsnames gives below) from any node it gives priority to instance which is mount and shows following error messages

SQL> conn system/vcs@dtrac
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 834 Serial number: 139


Warning: You are no longer connected to ORACLE.
SQL> conn system/vcs@dtrac
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 834 Serial number: 139


SQL> conn system/vcs@dtrac
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 834 Serial number: 139
SQL>


when I changes dtrac2 instance to either NOMOUNT or OPEN state then connection properly goes to instances which are OPEN state.

tnsname.ora file:
==================


# tnsnames.ora Network Configuration File: /oracle/db11g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DTRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal05-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal06-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal07-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal08-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtrac)
)
)

DTRAC4 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal08-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtrac)
(INSTANCE_NAME = dtrac4)
)
)

DTRAC3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal07-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtrac)
(INSTANCE_NAME = dtrac3)
)
)

DTRAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal06-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtrac)
(INSTANCE_NAME = dtrac2)
)
)

DTRAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal05-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtrac)
(INSTANCE_NAME = dtrac1)
)
)

LISTENERS_DTRAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal05-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal06-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal07-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal08-vip)(PORT = 1521))
)

LISTENER_DTRAC4 =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal08-vip)(PORT = 1521))


LISTENER_DTRAC3 =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal07-vip)(PORT = 1521))


LISTENER_DTRAC2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal06-vip)(PORT = 1521))


LISTENER_DTRAC1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = slpal05-vip)(PORT = 1521))