ORA-03113: When Creating or Testing DBLink

[Running Bear]

Originally posted by OracleDoc
I would never mess with the tnsnames.ora manually, that thing is just too fragile, one wrong syntax and the whole thing is messed up.

Humble apologies gents I see where I've gone wrong I had an extra bracket. Now connects.

# -- FastContinuity BackUp -- #
FastCont_BackUp.Nat.BT.com = 
  )# Extra bracket here!!
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 147.147.240.167)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = fcont)(SERVER = DEDICATED))
  )