Things like that, I got off the oracle12c, but is not login in,

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - the following is the order -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SQL> GRANT DBA, CONNECT, the RESOURCE TO HHXYY;

Authorization is successful,

SQL> Conn hhxyy/hhxy
ERROR:
ORA - 01017: the username/password is invalid; Login denied


Warning: you are no longer connected to ORACLE,
SQL> Conn hhxyy/hhxy @ former
ERROR:
ORA - 01017: the username/password is invalid; Login denied


SQL> Conn hhxyy/hhxy @ orclpdb
ERROR:
ORA - 01017: the username/password is invalid; Login denied

CodePudding user response:

The password is wrong,

SQL> The alter user hhxyy identified by hhxyy;

CodePudding user response:

No password is hhxy

CodePudding user response:

SQL> GRANT DBA, CONNECT, the RESOURCE TO HHXYY;


Where is the execution of this command, you are? CDB, or under the PDB?

CodePudding user response:

On the PDB! CDB can't perform,

CodePudding user response:

Is not



SQL> The alter user hhxyy identified by hhxyy;

The user has changed,

SQL> Conn hhxyy/hhxyy
ERROR:
ORA - 01017: the username/password is invalid; Login denied






Warning: you are no longer connected to ORACLE,
SQL> Conn hhxyy/hhxyy @ former
ERROR:
ORA - 01017: the username/password is invalid; Login denied


SQL> Conn hhxyy/hhxyy @ orclpdb
ERROR:
ORA - 01017: the username/password is invalid; Login denied

CodePudding user response:

So get! Various methods were tried