Database Administration (MOSC)

MOSC Banner

cannot connect the database user

edited Sep 3, 2020 2:59AM in Database Administration (MOSC) 2 commentsAnswered

Hi there ,

I am using Oracle Database 12.2.0.1 in Oracle Linix 7.8 platform. I am surprised that i am creating user with password but not able to connect the user next time. workaround as under:

SQL> CREATE USER TEST2 IDENTIFIED BY TEST2;

User created.

SQL> GRANT CONNECT,RESOURCE TO TEST2;

Grant succeeded.

SQL> CONN TEST2/TEST2

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL> conn /as sysdba

Connected.

SQL> show parameter case

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon             boolean     FALSE

SQL> select USERNAME,ACCOUNT_STATUS,PASSWORD_VERSIONS from dba_users

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center