I have just installed a newOracle 9i database and have set up a new user with DBA role using Enterprise Manager.

When I start SQL*PLUS, I can initially log in as the new user. If I use the command "CONNECT " and enter the password, it denies me access, saying "invalid username/password". Yet I initially logged in as that user.

If I enter the CONNECT command to log in as system/manager, it connects fine.


What could be going on here?