Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

snapper.sql issue with my database 19.8 version #26

Open
Ricx24 opened this issue Sep 10, 2020 · 0 comments
Open

snapper.sql issue with my database 19.8 version #26

Ricx24 opened this issue Sep 10, 2020 · 0 comments

Comments

@Ricx24
Copy link

Ricx24 commented Sep 10, 2020

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,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant