Use SQL*Plus 10g to connect to 9i databases
Use SQL*Plus 10g to connect to 9i databases -- Stephen Andert 2006-09-13
is installed on my laptop and I want to use it to connect to as many databases as I can. (mainly 9i variants) I have updated the tnsnames.ora in the 10g home to contain all the entries, and when I use the command-line tnsping, it resolves the names, but when I use 10G SQL*Plus for Windows, it tells me
ORA-12514: TNS:listener does not currently know of service requested in connect
SP2-0640: Not connected
What am I missing?
Bonus points if you can tell me how to connect 10g EM Database Control to other databases (i.e. especially 9i)