When trying to connect Spotlight on Oracle to ASM instance, the following error is received:
Oracle (ASM) connection error: ORA-01031: insufficient privileges
Wrong ASM instance password.
Enter the password for the SYS user on the ASM instance.
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.