procedure OracleCI.FindAliases does not correctly handle tnsnames.ora

[Andrey Maximenko. Ukraine]

procedure OracleCI.FindAliases does not correctly handle tnsnames.ora, if after the opening bracket there is a gap.
All of the following descriptions are lost.

DB14 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = DB14)(PORT = 1521)
(CONNECT_DATA = ( SID = DB14))
)

DB15 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = DB15)(PORT = 1521)
(CONNECT_DATA = (SID = DB15))
)

DB16 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = DB16)(PORT = 1521)
(CONNECT_DATA = (SID = DB16))
)

 

[Marco Kalter]

You are missing some parentheses:

(ADDRESS = (PROTOCOL = TCP) (HOST = DB14)(PORT = 1521)

Should be:

(ADDRESS = (PROTOCOL = TCP) (HOST = DB14)(PORT = 1521))

 

[Andrey Maximenko. Ukraine]

thanks, Marco