-
Title
Oracle (ASM) connection error: ORA-01031: insufficient privileges -
Description
When trying to connect Spotlight on Oracle to ASM instance, the following error is received:
Oracle (ASM) connection error: ORA-01031: insufficient privileges -
Cause
Wrong ASM instance password.
-
Resolution
Enter the password for the SYS user on the ASM instance.
-
Additional Information
There is NO ASM Username box for the ASM connection, as the ASM instance contains only one user SYS that can provide access to ASM-specific information.
SYS access to an ASM instance does NOT create a security issue for the Oracle database but still you should limit access to the SYS account to trusted individuals.
Because the SYS password is stored in encrypted format, non-privileged users can still access Spotlight on Oracle. To do so:
Use a preconfigured or shared Spotlight on Oracle connection.
Use a Spotlight connection without ASM access. Spotlight will display Oracle-related data, but the ASM drilldown will contain no data.