How to install Oracle Application Express(APEX) 20.1 in Linux

 

Oracle Application Express 20.1 Installation Steps 


Before installing Oracle Application Express, you must verify your configuration meets the minimum installation requirements.

Oracle Database Requirements

Oracle Application Express release 20.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE). Oracle Application Express can be installed in single-instance database and in Oracle Real Application Clusters (Oracle RAC) database.

MEMORY_TARGET of the Target Database

Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB.

Oracle XML DB Requirement

Oracle XML DB must be installed in the Oracle database that you want to use if you are installing a full development environment. Oracle XML DB is not required for runtime only installations. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.


Download Link: -

Oracle Application Express can be downloaded from HERE


Environment details:-

OS

RHEL 6.4

IP

192.168.0.106

Hostname

server3.soumya.com

Apex Version

20.1

DB Version

12.1.0.2





Once downloaded, unzip the software to begin the installation.

Create a directory where the apex software will be installed.

[oracle@server3 u01]$ mkdir -p /u01/apex

[oracle@server3 u01]$ unzip apex_20.1_en.zip

[oracle@server3 apex]$ unzip apex_20.1_en.zip -d /u01/apex


Create a new tablespace for APEX.

oracle@server3 apex]$ sqlplus / as sysdba

 SQL> create tablespace apexdemo datafile '/u01/app/oracle/oradata/ora12c/apexd01.dbf' size 2G autoextend on;

 

Installation

oracle@server3 apex]$ cd /u01/apex/apex

oracle@server3 apex]$ sqlplus / as sysdba

SQL> @apexins.sql

Enter value for 1: apexdemo

Enter value for 2: apexdemo

Enter value for 3: TEMP

Enter value for 4: /i/

 

P.S. For value 1 : Enter the tablespace name for apex application user

     For value 2 : Enter tablespace for apex file user

     For value 3 : Enter temporary tablespace for apex

     For value 4 : Enter virtual directory for apex images. Define the virtual   Directory as /i/

 

Once the installation is complete, confirm it by running following query

SYS> SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';

 

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
Oracle Application Express     20.1.0.00.13                   VALID

To change the admin password using “apxchpwd.sql” script as sys user.

 

oracle@server3 apex]$ sqlplus / as sysdba

 

SQL>@apxchpwd.sql
 
Note: The password should contain one lower and uppercase character, one punctuation character, 
one numeric character and must not contain the username.

 

 

Configure APEX

            Now there are two ways which we can use to access APEX.

1.    Oracle REST Data Services(ORDS)

2.    Embeded PL/SQL Gateway(EPG) Configuration

 

We will be using EPG configuration for this setup, however in release20.1 onwards the EPG configuration is deprecated. We will demonstrate ORDS configuration in another post.

 

Embedded PL/SQL Gateway (EPG) Configuration

So before moving ahead with the configuration make sure the following users are not locked.

SQL> ALTER USER anonymous ACCOUNT UNLOCK;

SQL> ALTER USER xdb ACCOUNT UNLOCK;

SQL> ALTER USER apex_public_user ACCOUNT UNLOCK;

SQL> ALTER USER flows_files ACCOUNT UNLOCK;

 

Change the following database parameters.

SQL>ALTER system SET shared_servers=5 scope=both;

 

 

Run the script “apex_epg_config.sql” from parent directory of apex installation directory.

SQL>@apex_epg_config.sql /u01/apex

 

Check the HTTP DB Port

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

 

GETHTTPPORT

-----------

          0

 

As the port is currently set to ‘0’ Change it to a non-zero port.

SQL> EXEC DBMS_XDB.sethttpport(8080);

 

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

 

GETHTTPPORT

-----------

       8080


Final Configuration Step

SQL>@/u01/apex/apex/apxconf.sql

 

      PORT

----------

      8080

 

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.

Default values are in brackets [ ].

Press Enter to accept the default value.

 

 

...set_appun.sql

================================================================================

This script can be used to change the password of an Application Express

instance administrator. If the user does not yet exist, a user record will be

created.

================================================================================

Enter the administrator's username [ADMIN] User "ADMIN" exists.

Enter ADMIN's email [admin]

 

Enter ADMIN's password []

Changed password of instance administrator ADMIN.

 

Enter a port for the XDB HTTP listener [      8080]

...changing HTTP Port

SQL>


 

Login Page to APEX

From browser open the APEX login page

http://server3.soumya.com:8080/apex/apex_admin



Provide username: admin and password to login.




So this concludes the installation process of APEX in Linux.



14 comments:

  1. Nice article thanks for given this information. I hope it useful to many People
    Mulesoft Online Course
    Online Mulesoft Training

    ReplyDelete
  2. I followed the same steps but unable to launch the application

    ReplyDelete
  3. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here .Same as your blog i found another one Oracle Project Portfolio Management Cloud . Actually I was looking for the same information on internet for Oracle PPM and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  4. Introducing ChatGPT: The Revolutionary Language Model Application

    ChatGPT is a cutting-edge language model application that utilizes the power of GPT (Generative Pre-training Transformer) technology to generate human-like text. Developed by OpenAI, this application has been trained on a massive dataset, making it capable of understanding and responding to a wide range of natural language inputs.

    One of the key features of ChatGPT is its ability to generate highly coherent and fluent text that is indistinguishable from text written by a human. This makes it ideal for a variety of use cases such as chatbots, automated content generation, and language translation.

    In addition to its impressive language generation capabilities, ChatGPT also offers a number of other features that make it a valuable tool for businesses and individuals alike. For example, it can be used to quickly generate product descriptions, summaries of articles, or even entire articles. It can also be used to answer questions, providing a level of customer service that is fast, accurate and efficient.

    Another important feature of ChatGPT is its ability to be fine-tuned for specific tasks or industries. This allows users to train the model on their own data, making it more accurate and effective for their specific needs.

    Overall, ChatGPT is a powerful and versatile application that is poised to revolutionize the way we interact with language technology. Whether you are a business looking to improve customer service, a researcher seeking to develop new AI models, or an individual looking to generate creative content, ChatGPT has the capabilities to help you achieve your goals.

    Tags:
    chatgpt,chat gpt
    PSU3

    ReplyDelete