Run Oracle Script

[Former Member]

Hello,

As per note: Note 1171650 - Automated Oracle DB parameter check , I need to run this on SQL.

How is it possible to run it as it is a txt file ?

Is there any way I can schedule this script to run on monthly basis ?

My OS level is AIX.

Thanks in advance,

J.

[Former Member · Accepted solution]

Hi,

You don't need to execute this SQL script on monthly basis, if somebody alter the db parameters, without your information. You can execute this script on SAP under ST04 tcode or by executing RSORADJV report.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Thank Orkun and DatabaseSAP.

Have a good day !

[Former Member]

> As per note: Note 1171650 - Automated Oracle DB parameter check , I need to run this on SQL.

sql > @filename.sql

For e.g. if you are on 10g, then I think you have to download and rename parameter_check_102.txt to parameter_check_102.sql

Place this sql file in a directory/folder, navigate to that folder and log on into sqlplus from there. Then execute the file using '@'.

Or, log on to sqlplus and give full absolute path to the file, sql> @/pathtofile/filename.sql

But in any case, in ABAP stack, the transcations ST04 or report execution is enough.

Thanks