Oracle local user login verification failed ORA-01031 insufficient privileges

Environment: linux x86 64 10.2.0.1

Error: sqlplus/as sysdba ORA-01031 insufficient privileges while sqlplus sys/password as sysdba can login

Check:

Once you rename the orapwd file, sqlplus sys/password Logon also fails, proving that the password file is in effect at login, and sqlplus/as sysdba indicates that the operating system verification failed

2. Check the user and the group cat/etc/passwd cat/etc/shadow/etc/group/etc/gshadow and call system-config-user to report an error. The group does not match, it is found that/etc/gshadow has an Oracle group, but/etc/group does not. Delete the oracle group.

3. Create another test account.

4. oracle software management users are not specified during oracle software installation

Check whether the connected operating system user is "osdba" and has been defined in:

"$ ORACLE_HOME/rdbms/lib/config. s"

Or

"$ ORACLE_HOME/rdbms/lib/config. c ".

DBAs are found to create a dba group and modify user attributes usermod oracle-g onistall-G dba

Of course, you can also change the config. c file and relink all

Oracle ORA-01555 snapshot old description

Troubleshooting for ORA-01078 and LRM-00109

ORA-01555 ultra-long Query Duration time

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store