system as sysdba
I have an external QMX product to monitor oracle database. This product needs to access to sys.v_$sgastat, sys.v_$sysstat, v$backup, etc. When I login to sqlplus and use connect system/password as sysdba, I can access to all the views described above. When I login externally, I can't. So I login to connect / as sysdba and try to grant sysdba to system and I got the following error: ORA-01994: GRANT failed: password file missing or disabled. Does that mean I have to have password file setup to be able to connect to system as sysdba externally? How to create the password
0