Oracle
Software Categorical 23.2 Set up Steps
Earlier than putting in
Oracle Software Categorical, it’s essential to confirm your configuration meets the
minimal set up necessities.
•
Oracle Database Necessities
Oracle
Software Categorical launch 23.2 requires an Oracle Database launch 19c or
later, together with Enterprise Version and Customary Version (SE) and Database 23c Free.
Oracle Software Categorical might be put in in single-instance database and in
Oracle Actual Software Clusters (Oracle RAC) database.
· Browser
Necessities
Oracle APEX requires a JavaScript-enabled browser and helps the present
and prior main launch of Google Chrome, Mozilla Firefox, Apple Safari, and
Microsoft Edge.
· Internet
Server Necessities
Oracle APEX requires Oracle REST Knowledge Companies (ORDS) 20.x or
later. The usage of Fast SQL requires Oracle REST Knowledge Companies (ORDS)
23.3 or later.
• MEMORY_TARGET of the Goal Database
Oracle
Software Categorical requires the system world space (SGA) and program world
space (PGA) to be not less than 300 MB.
•
Checking the WORKAREA_SIZE_POLICY of the
Goal Database
For the Oracle APEX set up or improve course of, the WORKAREA_SIZE_POLICY session parameter have to be set to AUTO.
SQL> alter system set WORKAREA_SIZE_POLICY=auto
scope=each;
• Oracle XML DB Requirement
Oracle XML DB
have to be put in within the Oracle database that you just wish to use if you’re
putting in a full improvement surroundings. Oracle XML DB will not be required for
runtime solely installations. In case you are utilizing a preconfigured database created
both throughout an set up or by Database Configuration Assistant (DBCA),
Oracle XML DB is already put in and configured.
Obtain Hyperlink: –
Oracle Software Categorical might be downloaded from HERE
Atmosphere particulars: –
|
OS |
RHEL 7.9 |
|
IP |
192.168.0.106 |
|
HOSTNAME |
Server3.soumya.com |
|
APEX VERSION |
23.2 |
|
DB VERSION |
19.3.0 |
As soon as downloaded, unzip the software program to start the
set up.
Create a listing the place the apex software program can be
put in.
[oracle@server3 u01]$ mkdir -p /u01/apex
[oracle@server3 apex]$ unzip apex_23.2.zip -d /u01/apex
Create a brand new tablespace
for APEX.
|
[oracle@server3 apex]$ sqlplus / as SQL> create tablespace APEX |
Apex
Set up: –
|
[oracle@server3 [oracle@ocisoumya SQL>@apexins.sql APEX APEX TEMP /i/ — i refers picture location in software.
|
As soon as the set up is full, affirm it by operating
following question
|
SYS> SELECT comp_name, model,
COMP_NAME —————————— Oracle APEX 23.2.0
|
To alter the admin password utilizing “apxchpwd.sql” script as
sys person.
|
SQL> …set_appun.sql ================================================================================ This occasion created. ================================================================================ Enter Person Enter Enter Created |
For configuring static information, we should run apex_rest_config.sql after a
new set up of Oracle APEX.
|
SQL> @apex_rest_config.sql
Enter a password for the APEX_LISTENER person [] Enter a password for the APEX_REST_PUBLIC_USER person [] …set_appun.sql …setting session surroundings …create APEX_LISTENER and APEX_REST_PUBLIC_USER customers …grants for APEX_LISTENER and ORDS_METADATA person |
Configure APEX
Now
there are two methods which we are able to use to entry APEX.
1. Oracle REST Knowledge Companies(ORDS)
2. Embeded PL/SQL Gateway(EPG) Configuration
Nevertheless Oracle suggestion is
ORDS.
create a customized
profile and assign the profile to
customary customers to keep away from person lock points.
|
CREATE PROFILE app_user1 LIMIT |
Alter all apex associated customers to assign customized profile.
|
choose
ALTER ALTER ALTER ALTER |
Unlock the customers:-
|
ALTER ALTER ALTER |
Execute following to grant join privileges to any host for the APEX_230200 database person. This
instance assumes you linked to the database the place Oracle Software Categorical
is put in as SYS specifying the SYSDBA function.
|
BEGIN host => ‘*’, ace => xs$ace_type(privilege_list principal_name principal_type END; /
|
