Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
# append this to your tnsnames.ora file: (e.g. c:\oracle\network\admin\tnsnames.ora)

SDB1TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sdb1bas-db-13d.ntlis.nt.gov.au)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sdb1test)
    )
  )

SDB1PROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sdb1.ntlis.nt.gov.au)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sdb1prod)
    )
  )

NRDBPROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = nrdb1.ntlis.nt.gov.au)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = nrdbprod)
    )
  )

...