Max. length of network_service_name in TNSNAMES.ORA?
Is it correct that the maximum number of characters for the network_service_name in
TNSNAMES.ORA is 64 characters, where the left part before a possible "." can be 8 chars. max. and the rest (domain part) then be 56?
(or 55 when taking a possible "." in account)?
Thus in
ORABSP10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm06ora10g)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
ORABSP11G would be ambiguous or overspecified (redundant)?
--
Christoph