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

On Aug 7, 10:06 am, vitalis..._at_gmail.com wrote:
> 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

Really i can't understand why you should have an instance "mounted" and the other "opened"
Could you explain this. In my opinion is a situation to avoid but maybe there is something
that i dont' remember.

regards,

Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Tue Aug 07 2007 - 03:32:41 CDT