Also one weird thing:

Code:
SQL> show parameter service_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      borg.ourdomain.com
How come the service name comes up as borg.ourdomain.com when in the tnsnames.ora it clearly lists the service name as just "BORG" ? The only place I can see where "borg.ourdomain.com" is defined is an environment variable called $ORACLE_HOSTNAME="borg.ourdomain.com". Is that anything to do with it?