Important Scripts & Tips

[admin]

SELECT * FROM apex_release;

Upgrade
@apexins.sql sysaux sysaux temp /i

@apex_rest_config.sql

Patch


Starting ORDS service

ords --config D:\Oracle_19c\ords\config serve

There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is /i/ (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it.

begin
apex_instance_admin.set_parameter(
p_parameter => 'IMAGE_PREFIX',
p_value => '/i/' );

commit;
end;

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Sun Jul 14 12:10:42 UTC 2024</comment>
<entry key="database.api.enabled">true</entry>
<entry key="standalone.doc.root">D:\Oracle_19c\ords\config\global\doc_root</entry>
<entry key="standalone.http.port">8080</entry>
<entry key="standalone.static.context.path">/i/</entry>
<entry key="standalone.static.path">D:\Oracle_19c\db_home_19_3\apex\images</entry>
</properties>

@reset_image_prefix.sql


There is a problem with your environment because the Oracle APEX files are not up-to-date! The files for version 24.1.0 have been loaded, but 24.1.2 is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.

-- Copy & replace images folder contents from patch folder to apex folder where you have images folder or application server.
-- Restart ORDS and also delete browser cookies


PDB
alter session set container=PDB01;

Admin password change
@apxchpwd.sql

Uninstall ORDS
D:\ords --config D:\ords\config uninstall --interactive

https://www.oracle.com/database/sqldeve ... /download/