0

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.

Thanks!!

Improve this question
1
  • ALTER USER account IDENTIFIED BY password ACCOUNT UNLOCK;
    – Ross
    Aug 16, 2019 at 17:15

1 Answer 1

Reset to default
-1

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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