Oracle sys user Telnet failed ORA-01031

Today, when managing Oracle, a very strange problem is found, which can be landed via Sqlplus Sys/password as SYDBA or Sqlplus/as sysdba.

But by Sqlplus Sys/[email protected] as SYSDBA login error, display

Ora-01031:insufficient Privileges

Obviously the SYS user, why will not log on it?

This is due to a password file error or failure. Oracle manages SYSDBA permissions through a password file. If it is given

SYSDBA permissions, under normal circumstances in the password file there is a user and password records.

Check: Oracle has two types of authentication methods:

1. Integration with the operating system authentication method

   ?

2. Using password file authentication

There are several suspects in the process:

1. What is an Oracle password file for?

The primary is the authentication of DBA authority.

1. Where are the Oracle password files stored?

$ORACLE _home/dbs/orapw$oracle_sid

1. Based on what is the decision to use operating system integration certification or password file authentication?

   Sql> Show Parameter Remote_login

   ?

   NAME TYPE VALUE

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

   Remote_login_passwordfile string EXCLUSIVE

   ?

   Where Remote_login_passworldfile has the following values:

• shared

  One or more databases can use the password file. The password file can contain? sys? As well asnon-SYS? users.

  One or more DB instances can use this password file. Content contains SYS and non-SYS users

• exclusive

  The password file can be used by only one database. The password file can contain? sys? As well asnon-SYS? users.

  A password file can only be used by one instance. Content contains SYS and non-SYS users

• None

  Oracle ignores any password file. Therefore, privileged users must is authenticated by the operating system.

  Ignore any password files. So all users must be certified by the operating system

Check the database using password file authentication. Then you need to rebuild the password file.

Orapwd file= $ORACLE _HOME/DBS/ORAPWORCL Password=password

Hint that you already have a file with the same name

Delete Orapwdorcl.ora and ORAPWDORCL first

RM Orapwdorcl.ora

RM ORAPWDORCL

Re-execute

Orapwd file= $ORACLE _HOME/DBS/ORAPWORCL Password=password

Sign in or prompt via Sqlplus sys/[email protected] as Sysdba

Ora-01031:insufficient Privileges

Why?

ORAPWD command missing entries and force parameters

Orapwd file= $ORACLE _home/dbs/orapw$oracle_sid password=password entries=5 force=y

Log in again, success.

?

?

?

REF:

https://aprakash.wordpress.com/2010/06/01/sys-as-sysdba-insufficient-privileges/

http://blog.csdn.net/leshami/article/details/5611672

Oracle sys user Telnet failed ORA-01031