I have created two database on a Win2000 machine. Oracle_sid = DB1 or DB2.
How can I access the different databases from Sqlplus on my machine without having to go into the environment variables on the database machine and change the Oracle_SID to the target database? The TNSnames.ora file on my machine list both databases on the target machine. The target machine has two entries for the listener.ora. One for each database.
Any help would be appreciated.