Good morning,
I am having some trouble setting up an 11G server to failover to a redundant NIC. After disabling the first NIC I am able to tnsping* the DB however I am unable to connect through an application or successfully test through Net Manager (Standard ORA-12514 error).
I have tried a number of combinations, adding FAILOVER entries, single address hostname on the client, changing the order of the entries, changing the port used.
Any assistance is welcome.
My current setup is as follows:
DBHome1
TNS
DEV01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <NIC1-IP>)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = <NIC2-IP>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev01.rms.nsw.gov.au)
)
)
Client
TNS
DEV01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <NIC1-IP>)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = <NIC2-IP>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev01.rms.nsw.gov.au)
)
)
Thankyou,
Dmitry
*TNSPing tries the first address for the TCP.CONNECT_TIMEOUT specified in sqlnet, times out and then OKs the second