I have the following situation:
- a windows 7, 64-bit OS;
- in which I have an Oracle 10g setup;
- on top of Win 7 - XP Mode;
- in which I have Oracle 11 client.
As I try to connect to the Oracle Server from XP mode I got the two situations:
sqlplus username/password@ host
-> I log in successfully!
sqlplusthen username, then password (i.e. 3 separate rows)
-> I get ORA - 12560
I believe this is due to the fact that the Oracle client 'forgets' or doesn't know which host to turn to in order to connect to server.
How do I set the host for the Oracle client? One more - I do not see any tnsnames.ora files in the installation directory of Oracle client.