My Oracle Fusion Middleware Experiments

Hello Guys!! Oracle REST Data Service (ords) is used as alternative to Oracle HTTP server (OHS) proxy web server that uses mod_plsql. In this post I would like ot share my experience on how to uninstall the ORDS from the Database. Before uninstalling you should aware of the following: Where is the ords.war exists JDK installed path (JAVA_HOME From which Database it need to uninstall Syntax: Navigate to the ORDS extracted directory which was previously used: java -jar ords.war uninstall ORDS Uninstallation Issue The challenge we faced during the ORDS uninstall $JAVA_HOME/bin/java -jar ords.war uninstall Enter the name of the database server [localhost]: Enter the database listen port [1521]: Enter the database service name [ORCL]: Please login with SYSDBA privileges to verify Oracle REST Data Services schema. Installation may be required. Enter the username with SYSDBA privileges to verify the installation [SYS]: Enter the database password for SYS: Confirm password: Jun 15...

Namaste!! Welcome to 'MyOFMWExperiments' blog! In this post, I would like to share about the Oracle APEX 18 Installation process. Oracle Database 19.3 includes this APEX installer inside the release installer bundle. When I started exploring the APEX thought that I've to download the Oracle APEX separately and do the installation on the Oracle Database. When I've gone thru many YouTube videos about Oracle APEX. But all those previous versions. After the Creation of the dedicated PDB connect to it with sys as SYSDBA role. Login to that PDB which has named as pdb1. The APEX installation will be simple sql script 'apexins.sql', usually, it is present in the 'apex' folder inside Oracle database or if you download Oracle APEX specific version and extracted. In your Oracle database 19c installed box, Change directory to the directory holding the unzipped APEX software. In that directory you need to connect to the PDB which was created: cd /opt/oracle/prod...