Database Networking (MOSC)

MOSC Banner

Max. length of network_service_name in TNSNAMES.ORA?

edited Oct 22, 2015 5:39AM in Database Networking (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center