Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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