tnsnames.ora example

Because I tend to forget…this is what a tnsnames.ora looks like:

DB01_broccoli=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.122.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CDB01_broccoli)
    )
  )
CDB01_bloemkool=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.122.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CDB01_bloemkool)
    )
  )

Leave a Reply

Your email address will not be published. Required fields are marked *