After using the set oracle_sid method I had a
few problems with connections in sqlplus. In that even though I would specify
one database I would get the one set in oracle_sid. For this reason I would
suggest it is good practice to run the following code after each connection
just to check your are connected to the right database.