Hello, i have two instance on the same database server (hub and img). My database version in 19.8
For some reason i am getting these error when i execute the snapper.sql on my hub instance. When i execute the same script on my other instance(img) it executes perfect.
Details of the error.
sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 10 14:08:10 2020
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
SQL> @snapper.sql ash 5 1 all
Sampling SID all with interval 5 seconds, taking 1 snapshots...
-- Session Snapper v4.31 - by Tanel Poder ( http://blog.tanelpoder.com/snapper ) - Enjoy the Most Advanced Oracle Troubleshooting Script on the Planet! :)
declare
*
ERROR at line 1:
ORA-20000: Snapper: Probably bad syntax or no execute rights on SYS.DBMS_LOCK
Check http://blog.tanelpoder.com/snapper for instructions
ORA-00979: not a GROUP BY expression
Stack Trace:
ORA-06512: at line 1206
ORA-06512: at line 1206
ORA-06512: at line 1789
ORA-06512: at line 1814
I already give the sys.dbms_lock privileges and i check these privileges with my working instance.
Any idea what could be? Maybe another privileges? I execute these script with sys, system and i get the same error.
Hello, i have two instance on the same database server (hub and img). My database version in 19.8
For some reason i am getting these error when i execute the snapper.sql on my hub instance. When i execute the same script on my other instance(img) it executes perfect.
Details of the error.
sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 10 14:08:10 2020 Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0
SQL> @snapper.sql ash 5 1 all Sampling SID all with interval 5 seconds, taking 1 snapshots...
-- Session Snapper v4.31 - by Tanel Poder ( http://blog.tanelpoder.com/snapper ) - Enjoy the Most Advanced Oracle Troubleshooting Script on the Planet! :)
ActSes %Thread | INST | SQL_ID | SQL_CHILD | EVENT | WAIT_CLASS
declare * ERROR at line 1: ORA-20000: Snapper: Probably bad syntax or no execute rights on SYS.DBMS_LOCK Check http://blog.tanelpoder.com/snapper for instructions ORA-00979: not a GROUP BY expression Stack Trace: ORA-06512: at line 1206 ORA-06512: at line 1206 ORA-06512: at line 1789 ORA-06512: at line 1814
I already give the sys.dbms_lock privileges and i check these privileges with my working instance.
Any idea what could be? Maybe another privileges? I execute these script with sys, system and i get the same error.
Thanks,