Multiple aliases in tnsnames.ora
Posted: Mon 23 Jan 2006 01:23
It is possible for a user to configure a tnsnames entry to have multiple aliases. EG :
alias1, alias2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.x.y.z)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledb)
)
)
Currently ODAC does not handle this well. To fix this ODAC needs to make the following change :
In OdacGui.inc, line 227 (version 5.55);
Replace this line:
if (St = '=') and (Bracket = 0) then begin
With this:
if ((St = '=') or (St = ',')) and (Bracket = 0) then begin
alias1, alias2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.x.y.z)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledb)
)
)
Currently ODAC does not handle this well. To fix this ODAC needs to make the following change :
In OdacGui.inc, line 227 (version 5.55);
Replace this line:
if (St = '=') and (Bracket = 0) then begin
With this:
if ((St = '=') or (St = ',')) and (Bracket = 0) then begin