Contents
Is there a problem with Oracle 12c database?
I met a problem from Oracle 12C Database, when I try to login to the user account with command conn test/test, I got prompt of “invalid username/password, logon denied”. when I use conn test/test@PDBORCL, I got “Could not resolve the connect identifier specified” Can anyone please help me out? I really appreciate!!
Can a client connect to a DB using Oracle 11.2?
And found that we could not connect to our DB unless using client which version is above 11.2.0.3 (included)! First, we tried to connect to DB using 11.2.0.1 client, but got an error ORA-28040: No matching authentication protocol.
How to ask a question in Oracle 12c?
Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To learn more, see our tips on writing great answers. Not the answer you’re looking for? Browse other questions tagged oracle oracle-12c or ask your own question.
Is there a way to connect to 12C DB?
User was facing same issue ORA-28040: No matching authentication protocol and later invalid username/password after setting the SQLNET.ALLOWED_LOGON_VERSION=8. Interesting thing was when passing the password in UPPERCASE, user was able to connect. I fired alter user username password “same_password” account unlock and things started working.
How to log in to Oracle system account?
When connected you can just call: alter user sys identified by YOUR_NEW_PASS; or for SYSTEM user alter user SYSTEM identified by YOUR_NEW_PASS account unlock; and login with new password. By the way why do you need to log as SYSTEM?
Why is my Oracle account password not 10g?
In Windows one set environmental variables like shown here from oracle version 12.2.x users cannot login using case insensitive passwords, even though SEC_CASE_SENSITIVE_LOGON = FALSE if PASSWORD_VERSIONS of user is not 10g. following sql should show the PASSWORD_VERSIONS for a user.
Why do I not have access to my Oracle account?
If these environment variables are not set automatically, do it manually (export ORACLE_HOME=/opt/oracle/VIS/db/tech_st/10.2.0 Please first try without setting variables. Please run SQLPlus as administrator and connect as sysdba without giving password.