I've installed and created non-CDB database (single tenant) database. Created a user account using the SYS user, granted it the CONNECT and CREATE SESSION roles. When I attempt to login using the newly created account I get the "ORA-010170: invalid username/password; login denied" error.

I'm I missing something with respect to the Oracle 12c Standard database?? Since I've created a "normal" database I should be able to login with a non SYS account.


  • ALTER USER account IDENTIFIED BY password ACCOUNT UNLOCK; – Ross Aug 16 '19 at 17:15

Check the netca config. There needs to be an entry in tnsnames.ora.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.