Skip to content

snapper.sql issue with my database 19.8 version #26

@Ricx24

Description

@Ricx24

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,

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions