Toad World® Forums

Oracle Connection


#1

Hi,

I do not know how I can create a connection like this :

95 =
(DESCRIPTION =
(CONNECT_TIMEOUT= 120)(RETRY_COUNT=20) (RETRY_DELAY=3) (TRANSPORT_CONNECT_TIMEOUT=3)
(ADDRESS_LIST = (LOAD_BALANCE=on)
( ADDRESS = (PROTOCOL = TCP)(HOST=953)(PORT=1521)))
(ADDRESS_LIST = (LOAD_BALANCE=on)
( ADDRESS = (PROTOCOL = TCP)(HOST=956)(PORT=1521)))
(ADDRESS_LIST = (LOAD_BALANCE=on)
( ADDRESS = (PROTOCOL = TCP)(HOST=951)(PORT=1521)))
(ADDRESS_LIST = (LOAD_BALANCE=on)
( ADDRESS = (PROTOCOL = TCP)(HOST=952)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME = 95_READONLY)))

I need help


#2

This looks like tns definition for a connection, although I don’t recognize some of those attributes. There is a sample tnsnames.ora in the Oracle client file under …network\admin\sample Look at that file or Oracle documentation.