Re: RAC fail-over with an instance in MOUNT status

From: <vitalisman_at_gmail.com>
Date: Tue, 07 Aug 2007 01:06:11 -0700
Message-ID: <1186473971.953423.273560@r34g2000hsd.googlegroups.com>

On 6 août, 21:55, sybra..._at_hccnet.nl wrote:

> Daniel, he is probably using SID = in tnsnames.ora instead of
> SERVICE_NAME =
> as he is using SID= he will get in.
> If he would have used SERVICE_NAME= he would have got 12514.

No, the tnsnames makes use of a service name as follows:

DBNAME =
  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBNAME)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )

    )
  )

The listener configuration is as follows on each node:

LISTENER_nodeN =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = nodeN-vip)(PORT = 1521)(IP
= FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = nodeN)(PORT = 1521)(IP =
FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

Regards,
Jerome Received on Tue Aug 07 2007 - 03:06:11 CDT