I have an error before I connect to the user Oracle 12c

All we need is an easy explanation of the problem, so here it is.

After that, I log in normally.

I tried it sqlplus as sysdba error is the same

Why this error occurs

I’m a beginner

[[email protected] ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 21 13:08:51 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: system
Enter password: 
Last Successful login time: Wed Nov 21 2018 13:07:42 -05:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Possible reasons:

  • You have SQLNET.AUTHENTICATION_SERVICES=(NONE) set in sqlnet.ora which disables operating system authentication based on group membership ($ORACLE_HOME/network/admin/sqlnet.ora, or $TNS_ADMIN/sqlnet.ora, it $TNS_ADMIN is set).

  • your user (oracle) is not the member of the group configured to be used for operating system authentication. Groups can be found in $ORACLE_HOME/rdbms/lib/config.c.

  • You have the environmental variable TWO_TASK set to something which is automatically added to sqlplus connection attemts as a TNS alias. For example if TWO_TASK is set to ORCL, sqlplus / as sysdba will become sqlplus /@ORCL as sysdba in the background, where operating system authentication does not work.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply