Posts

ORDS 503 and 404 Problem Fix

  Many Oracle APEX developers & users face ORDS  503   Service Unavailable  problems like:   ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|| had the following error(s): ORA-28000: The account is locked. ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|| had the following error(s): ORA-28001: the password has expired The username or password for the connection pool named: |apex||, are invalid, expired, or the account is locked. Many Oracle APEX developers & users encountered ORDS  404   Service Unavailable  problems like:  The request could not be mapped to any data

Database, Apex, ORDS and Tomcat Installation Process

  Database, Apex, ORDS and Tomcat  Installation Process Database Installation: Step-1: Download Database Step-2: Install only Software Step-3: Create Database - DBCA Step-4: Create & Configuration listener & TNS Apex Installation: Step-1: Download Apex Step-2: Connect Database with Sysdba Step-3: Check Version:                 SQL> SELECT version from dba_registry where comp_id='APEX'; IF Found UNINSTALL ORACLE APEX FROM DATABASE; @apxremov.sql Step-4: Run CMD with Administration and Apex Path Change cd path E:                 E:\APEX\apex19\apex sqlplus /nolog conn /as sysdba   Step-4: Install Apex ALTER SESSION   SET CONTAINER = ORCLPDB; @apexins.sql SYSAUX SYSAUX TEMP /i/ show pdbs @apxchpwd admin email oracledbsolutions.info@gmail.com password: example *Apex2022# ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Apex2022 ACCOUNT UNLOCK;     --for ORDS ALTER SESSION   SET CONTAINER = ORCLPDB; @apex_rest_con