Print Thread
procedure OracleCI.FindAliases does not correctly handle tnsnames.ora
#49907 12/18/14 07:25 AM
Joined: Aug 2004
Posts: 83
Ukraine
A
Member
OP Offline
Member
A
Joined: Aug 2004
Posts: 83
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))
)


Re: procedure OracleCI.FindAliases does not correctly handle tnsnames.ora
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You are missing some parentheses:

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

Should be:

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


Marco Kalter
Allround Automations
Re: procedure OracleCI.FindAliases does not correctly handle tnsnames.ora
Marco Kalter #49910 12/18/14 10:06 AM
Joined: Aug 2004
Posts: 83
Ukraine
A
Member
OP Offline
Member
A
Joined: Aug 2004
Posts: 83
Ukraine
thanks, Marco


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 14 (0.010s) Memory: 2.5055 MB (Peak: 3.0431 MB) Data Comp: Off Server Time: 2024-05-18 16:19:38 UTC
Valid HTML 5 and Valid CSS