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_config.sql

                Password : Apex2022#

Installation Oracle REST Data Services (ORDS):

Run CMD

C:\WINDOWS\system32>cd\

C:\>cd ords-21

C:\ords-21>java -jar ords.war install advanced

after complete then

http://localhost:2122/ords

 

TOMCAT Installation:

     Install Tomcat in Normal Process

Deploying Apex and ORDS in TOMCAT:

Step 1: Copy ords.war file from ords folder then past Tomcat webapps folder

[C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps]

Step 2: Copy image file from apex folder then past Tomcat webapps folder

[C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps]

 

Step 3: Rename image file name i in tomcat

Restart Tomcat

                                                    ======Thanks=======