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)
)
)