-
Title
Error: "ORA-01031 insufficient privileges" when trying to connect in SQLPLUS. -
Description
Trying to use the Oracle User Wizard to set up a Spotlight user in Oracle database.
When entering credentials for user/password with DBA privileges I get the error "ORA-01017: Invalid Username / Password" in the Oracle User Wizard .
When trying to connect with the same DBA privileges in SQL*PLUS to database A I get :
command: sqlplus sys/<sys_password> as sysdba => WORKED
command: sqlplus sys/<sys_password>@A as sysdba => FAILED
The failed connection returns error: "ORA-01031: insufficient privileges"
However both login commands worked fine when trying to connect to database B.
N:B: Error: "ORA-01031: insufficient privileges" was responsible for the Oracle User Wizard setup returning error "ORA-01017: Invalid Username / Password". -
Cause
There is a missing parameter setting in init.ora of database A which happens to be present in the database B.
-
Resolution
WORKAROUND:
To implement the solution, please execute the following steps:
1. Back up the init<SID>.ora file.
2. Edit the init<SID>.ora file.
3. Add the parameter:
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
4. Restart the database.
STATUS: NONE.