OraEasy

Introduction: NETCA (Network Configuration Assistant) is an Oracle utility used to configure network components for Oracle databases. It simplifies the setup and management of network configurations, including creating and managing listener.ora, tnsnames.ora, and other related files. This guide will walk you through the listener configuration process using NETCA utility. Prerequisites: 1. Oracle Database Software should be installed. 2. Oracle Database Environments should be set. Run NETCA from OS prompt: [oracle@target ~]$ netca Then a GUI wizard will open: Select Listener Configuration and Click Next Select Add and Click Next Provide listener name "LISTENER" and Click Next Select Protocol and Click Next Provide Port and Click Next Select No and Click Next Click Next Click Finish Now start the Listener: [oracle@target ~]$ lsnrctl start LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 22-JAN-2025...

Prerequisites: 1. Please refer to APEX 23.2 installation and complete the installation. 2. Kindly stop the previous running Apex by killing ords pid. 3. Also take full DB backup for rollback purpose. Upgrading Apex from 23.2 to 24.1 1. Create directory and place the Apex 24.1 software: [oracle@apex oracle]$ mkdir apex24_1 [oracle@apex oracle]$ [oracle@apex oracle]$ cd apex24_1 [oracle@apex apex24_1]$ pwd /u02/app/oracle/apex24_1 [oracle@apex apex24_1]$ ls apex_24.1.zip [oracle@apex apex24_1]$ cd apex [oracle@apex apex]$ pwd /u02/app/oracle/apex24_1/apex 2. Create a tablespace: SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 APEXPDB READ WRITE NO SQL> alter session set container=APEXPDB; Session altered. SQL> create tablespace APEX241 datafile '/u02/app/oracle/oradata/APEXDB/ap...

Introduction: Oracle APEX is a low-code development platform that helps you build scalable, secure enterprise apps. This guide will walk you through the installation process step-by-step. Prerequisites: 1. Oracle Database 19c or later with any edition 2. ORDS 23.3 or later 3. Java 11 or later 4. Minimum 2GB free space for tablespace and software directory 5. Create appropriate and working TNS entry for DB services. Include PDB if using it. Software Download: 1. Apex 23.2 : Apex 23.2 2. ORDS Download: ORDS 3. Java Download: Java Environment: Hostname: apex IP: 192.168.101.7 ORACLE_SID : APEXDB PDB: APEXPDB ORACLE_HOME: /u02/app/oracle/product/19c/db_1 Apex Installation: 1. Create tablespace: SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 APEXPDB READ WRITE NO SQL> alter sessi...