I created a new user with
SQL> create user "reac" identified by "reac";
but when I tried to login with it gave me
ERROR: ORA-01017: invalid username/password; logon denied
This was on a windows 7 64 bit with Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 – 64bit Production.
It turns out Oracle didn’t like the lower case names. go figure.
some other things you might want to do
SQL> alter user "REAC" account unlock; User altered. SQL> grant connect to "REAC"; Grant succeeded. SQL> grant DBA to "REAC"; Grant succeeded. SQL> grant RESOURCE to "REAC"; Grant succeeded.