Main » 2011 » August » 23 » Oracle Check Connected database in sqlplus.
2:44 PM
Oracle Check Connected database in sqlplus.
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.