So now I have one other question:

I created a database link using the new SID using the following command:

create database link hstest connect to sa identified by XXXXXXX using 'HSTEST';



I then tried to query that database link, and I get the following error through SQL+Plus:

SQL> select * from employees@hstest;
select * from employees@hstest
*
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified


Any clues?


- E