You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
Thanks,
The text was updated successfully, but these errors were encountered:
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,
The text was updated successfully, but these errors were encountered: