SQL*Net - tnsnames.ora

Sample dedicated connection

Listener entry

Sample dedicated connection

SCR9 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bloo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = scr9)
    )
  )

Listener entry

LISTENER_+ASM =
  (ADDRESS = (PROTOCOL = TCP)(HOST = bloo)(PORT = 1522))