ORA-06550 running snapper.sql against 19c database

cs2018ncsa commented 5 years ago

happy to do anything i can to help troubleshoot this. the following runs without an issue on 12.2.0.2:

SQL> @snapper ash,stats 5 1 all Sampling SID all with interval 5 seconds, taking 1 snapshots... and s.why0+s.why1+s.why2 > 0 * ERROR at line 930: ORA-06550: line 930, column 25: PL/SQL: ORA-00904: "S"."WHY2": invalid identifier ORA-06550: line 859, column 9: PL/SQL: SQL Statement ignored

SQL> select * from v$version;

BANNER BANNER_FULL BANNER_LEGACY CON_ID

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 0 Version 19.3.0.0.0

tanelpoder commented 5 years ago

Did you test with the latest snapper version? An older version didn’t recognize the 19c version string.

cs2018ncsa commented 5 years ago

doh. latest version worked. i thought I'd cloned your repo in the last week or so but maybe not. sorry for trouble!

tanelpoder commented 5 years ago

No problem!

tanelpoder commented 5 years ago

Pull the latest snapper.sql from TPT repo, it works with 19c

On Fri, Nov 8, 2019 at 6:25 AM dom-design-BDD notifications@github.com wrote:

Hello Tanel, I've got the same issue as cs2018ncsa on 19c What's the latest version of snapper.sql available compatible with 19c ? I'm using snapper v.4 Please advise Best regards,

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/tanelpoder/tpt-oracle/issues/6?email_source=notifications&email_token=AA3X4HLEY2KK6AY6UMNFRODQSVEEDA5CNFSM4H7QAKM2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEDQQ4LI#issuecomment-551620141, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA3X4HKSUPXGD7QN6DGLZ6TQSVEEDANCNFSM4H7QAKMQ .

tanelpoder / tpt-oracle

ORA-06550 running snapper.sql against 19c database #6