Hi,
I have searched the forum for entries for this problem, but haven't found the answer.
I try to logon to XE 11g
sqlplus remco@xe
SQL*Plus: Release 11.2.0.2.0 Beta on Thu Feb 9 17:20:47 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta
SQL>
Then when I try logging on in TOAD (same user, same password, same database) I can only connect as SYSDBA. When I set the "Connect as" dropdown to 'Normal', I get the message that username/password is incorrect: ORA-01017: invalid username/password; logon denied.
I thought I had found the problem, because Toad uses a different tnsnames.ora than the SQL*Plus session I use. But even after synchronizing the tnsnames entries in both files, the same error occurs when trying to connect with Toad.
Anyone? Could the explanation be that Toad use a 9i client and a 9i oracle_home, whereas with SQL*Plus I set the oracle_home to the XE 11g home?
Thanks in advance!
Remco