tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
657 stars 312 forks source link

Error while running snapper #5

Closed deshpande-prasanna closed 5 years ago

deshpande-prasanna commented 5 years ago

Hi Tanel,

I am getting below error while running the snapper code snippet.

could you please help me out error: Sampling SID 2161 with interval 1 seconds, taking 1 snapshots...

Error starting at line : 456 File @ H:\awr\snapper.sql In command - declare -- Snapper start -- forward declarations procedure output(p_txt in varchar2); procedure fout; . . . .

tanelpoder commented 5 years ago

Hi Prasanna,

A few questions:

1) Can yu paste the exect command line how you ran snapper 2) Are you running this within sqlplus or SQL Developer? 3) Did you download the script with "save as..." or used copy & paste to a .sql file? Often such errors show up when copy & paste messes up the script contents.

If you used copy & paste, please try downloading or cloning the script with git and try again? If you still have a problem, please run snapper like this and paste the full output:

@snapper all 5 1 lgwr

Thanks, Tanel.

deshpande-prasanna commented 5 years ago

Hi Tanel,

Sorry to respond very late. I have not raised the error message. I think someone else has got that error message. Could you please cross check?

Thank you, Prasanna

On 01-Nov-2019, at 06:55, Tanel Poder notifications@github.com wrote:

Closed #5.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

tanelpoder commented 5 years ago

Sorry I don't understand what to cross-check, did you not create this issue above?

deshpande-prasanna commented 5 years ago

No Tanel. I did not create this issue.

Sent from my iPhone

On 04-Nov-2019, at 07:24, Tanel Poder notifications@github.com wrote:

Sorry I don't understand what to cross-check, did you not create this issue above?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.