OTRS update from 4 to 5. Database Update (Oracle)

[MArsMax]

When upgrading OTRS from version 4 to 5, there was a problem with the migration of the database.
Specifically - at the stage of updating the structure of the database.
In the OTRS update guide, this is 6.1 "Database Update Schema". There options for MySQL are described in detail

Code: Select all

cat scripts/DBUpdate-to-5.mysql.sql | mysql -p -f -u root otrs

and for PostGRE

Code: Select all

cat scripts/DBUpdate-to-5.postgresql.sql | psql --set ON_ERROR_STOP=on --single-transaction otrs otrs

But I did not find instructions on using the third script (for Oracle) - "DBUpdate-to-5.oracle.sql".
Now I have absolutely no idea how, with what parameters to run this script, to prepare the database structure for further migration.

[jojo]

your Oracle DBA should be able to run the script via sqlplus

[MArsMax]

your Oracle DBA should be able to run the script via sqlplus

Yes, this is the right idea.
But there is a small problem: now there is no DBA available, and I do not have enough experience for independent actions that are not described in the manual. Although in any case there is no fear of making a mistake, since I'm doing all this on a copy of the database and can always go back to the previously saved state.
In general, all I need is a command line to run this script for Oracle. So I thought that someone who has already done these actions will remember and give a hint.

[root]

https://www.techonthenet.com/oracle/que ... script.php

or

Code: Select all

sqlplus user/pass@connect @scriptname

[MArsMax]

Code: Select all

sqlplus user/pass@connect @scriptname

Thanks, it really works!!!

The DB structure updated successfully, so I got access to further steps