I had to setup an Oracle environment. The stage is as follows: there are Oracle 11.2 client and 10g express server, the OS is Windows 7, 64-bit. I have the ORACLE_HOME, ORACLE_SID and PATH env. variables set correctly.
I have to connect to the server via the 11.2 client.
When I type in cmd:
- sqlplus, then
- username, then
- password
I get ORA-12560 and after 3 attempts I get disconnected.
but if I type the following:
sqplplus username/password@xe
I get connected without any further objection from Oracle.
Have you had similar experience? Do you have an idea why this behavior is exhibited?