Re: Transparent Application failover on 9i rac
From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Thu, 2 Jul 2009 11:53:51 -0400
Message-ID: <7d81ec570907020853s69165f45x1d525b8addcd3980_at_mail.gmail.com>
Hi Gurus,
It is very surprising that noone had replied me on this issue. I'm stuck on this issue. Please help.
FROM v$instance
UNION
SELECT NULL, NULL, failover_type, failover_method, failed_over FROM v$session
WHERE username = 'HR';
Date: Thu, 2 Jul 2009 11:53:51 -0400
Message-ID: <7d81ec570907020853s69165f45x1d525b8addcd3980_at_mail.gmail.com>
Hi Gurus,
It is very surprising that noone had replied me on this issue. I'm stuck on this issue. Please help.
I'm trying to setup transparent application failover on my 2 node test 9i RAC.
The tnsnames.ora on node1 and node2 are pretty simple excepting for
the ipaddress.
ORCL.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
To test TAF, i'm connecting from my laptop sqlplus client which has the following tnsnames.ora
LISTENERS_ORCL.EZHOME.COM =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521))
)
ORCL.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = YES)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.3)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL.EZHOME.COM)
(SERVER = DEDICATED)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
ORCL1.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL.EZHOME.COM)
(SERVER = DEDICATED)
(INSTANCE_NAME = ORCL1)
(FAILOVER_MODE =
(BACKUP = ORCL2.EZHOME.COM)
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
ORCL2.EZHOME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL.EZHOME.COM)
(SERVER = DEDICATED)
(INSTANCE_NAME = ORCL2)
(FAILOVER_MODE =
(BACKUP = ORCL1.EZHOME.COM)
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
select instance_name, host_name,
NULL AS failover_type,
NULL AS failover_method,
NULL AS failed_over
FROM v$instance
UNION
SELECT NULL, NULL, failover_type, failover_method, failed_over FROM v$session
WHERE username = 'HR';
RESULT:
INSTANCE_NAME HOST_NAME
FAILOVER_TYPE FAILOVER_M FAI
- ---------- --- orcl1 sunny1pub.ezhome.com
NONE NONE NO 2 rows selected.
- As you can see, the failover_type, failover_method, failed_over are None and no respectively. I have been searching the internet for the past couple days but i dont find any sample files. Appreciate if someone could send me a sample tnsnames.ora sample file.
- Also do i need to have the LISTENERS_ORCL.EZHOME.COM ? What is the use/purpose of it?
Please help. Thanks.
On Tue, Jun 30, 2009 at 3:09 PM, sundar
mahadevan<sundarmahadevan82_at_gmail.com> wrote:
> Hi Gurus, > I'm trying to setup transparent application failover on my 2 node test 9i RAC. > > The tnsnames.ora on node1 and node2 are pretty simple excepting for > the ipaddress. > ORCL.EZHOME.COM = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = ORCL) > ) > ) > > To test TAF, i'm connecting from my laptop sqlplus client which has > the following tnsnames.ora > > LISTENERS_ORCL.EZHOME.COM = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521)) > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521)) > ) > > ORCL.EZHOME.COM = > (DESCRIPTION = > (ADDRESS_LIST = > (LOAD_BALANCE = YES) > (FAILOVER = ON) > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521)) > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = ORCL.EZHOME.COM) > (SERVER = DEDICATED) > (FAILOVER_MODE = > (TYPE = SELECT) > (METHOD = BASIC) > ) > ) > ) > ORCL1.EZHOME.COM = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = ORCL.EZHOME.COM) > (SERVER = DEDICATED) > (INSTANCE_NAME = ORCL1) > (FAILOVER_MODE = > (BACKUP = ORCL2.EZHOME.COM) > (TYPE = SELECT) > (METHOD = BASIC) > ) > ) > ) > ORCL2.EZHOME.COM = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = ORCL.EZHOME.COM) > (SERVER = DEDICATED) > (INSTANCE_NAME = ORCL2) > (FAILOVER_MODE = > (BACKUP = ORCL1.EZHOME.COM) > (TYPE = SELECT) > (METHOD = BASIC) > ) > ) > ) > > select instance_name, host_name, > NULL AS failover_type, > NULL AS failover_method, > NULL AS failed_over > FROM v$instance > UNION > SELECT NULL, NULL, failover_type, failover_method, failed_over > FROM v$session > WHERE username = 'HR'; > > RESULT: > > INSTANCE_NAME HOST_NAME > FAILOVER_TYPE FAILOVER_M FAI > ---------------- > ---------------------------------------------------------------- > ------------- ---------- --- > orcl1 sunny1pub.ezhome.com > > NONE NONE NO > > 2 rows selected. > > 1) As you can see, the failover_type, failover_method, failed_over are > None and no respectively. I have been searching the internet for the > past couple days but i dont find any sample files. Appreciate if > someone could send me a sample tnsnames.ora sample file. > > 2) Also do i need to have the LISTENERS_ORCL.EZHOME.COM ? What is the > use/purpose of it? > > Please help. Thanks. >
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 02 2009 - 10:53:51 CDT