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.
well is the repostory in the same server as your original database? is the repository in the same instance as your original database? you are connecting locally if you are not giving connect string
the error is telling you it is trying to connect with local databaase if your repository is not there then obviously you get invalid password