1748252 Members
3923 Online
108760 Solutions
New Discussion

Seamless connection

 
NS_2
Occasional Contributor

Seamless connection

Hi Masters,
We are having two ES-40 servers (tru-64 5.1a ) in cluster
running oracle 8.1.7.4 database (single instance on HOST A).
User are accessing the database from PC connected in network.

How can users have a seamless connection to database in case of HOST A
Crash and database will get transfered on HOST B.

Thanks in adv
Take It Easy, Be Happy !
1 REPLY 1
Brian Crabtree
Honored Contributor

Re: Seamless connection

You are looking for the "FAILOVER" command as part of the tns connection. Your tns entry should look something like the following:
-------------
CLUSTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = systemA)
(PORT = 1521)
)
ADDRESS =
(PROTOCOL = TCP)
(HOST = systemB)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CLUSTDB)
(FAILOVER_MODE=
(TYPE=SELECT)(METHOD=basic)
)
)
)
-------------

There are a few different options for the "FAILOVER_MODE" (notably, BACKUP). There are alot of documents, but one that explains different options is below. This is for 8.0, but the options have not changed much between versions.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=69906.1

Hope this helps,

Brian