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: Oracle Database Software should be installed. Oracle Database Environments should be set. Let's start the Listener Configuration using NETCA. 1. 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 2. Now start the Listener: [oracle@target ~]$ lsnrctl start LIST...

Introduction: In this article, we will see the upgradation of Oracle APEX from 23.2 to 24.1 step-by-step. Prerequisites: Please refer to APEX 23.2 installation and complete the installation. Kindly stop the previous running APEX by killing ORDS PID. Also take full DB backup for rollback purpose. Let's start the 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...

Introduction: Oracle APEX is a low-code development platform that helps you to build scalable, secure enterprise apps. In this article, we will see the installation of Oracle APEX step-by-step. Prerequisites: Oracle Database 19c or later with any edition. ORDS 23.3 or later. Java 11 or later. Minimum 2GB free space for tablespace and software directory. Create appropriate and working TNS entry for DB services. Include PDB if using it. Software Download: APEX 23.2 : APEX 23.2 ORDS Download: ORDS 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 Let's start the 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 ...