Skip to main content

Installation Oracle Application Express 21.2 on Centos 8

ACHTUNG: PSS PRIVAT!!!!

# ### Installation APEX! ###

unzip /shared/data/apex/apex_21.2.zip -d /
\cp /apex/* -Rf /srv/app/apex/
chown oracle /srv/app/apex/ -R
rm -Rf /apex/

cd /opt/oracle/product/apex/
sqlplus / as sysdba

ALTER USER ANONYMOUS ACCOUNT UNLOCK;
startup open
select open_mode from v$database;
# READ / WRITE!!!

ALTER SESSION SET CONTAINER=PSSDB;

## DROP TABLESPACE apex INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE APEX DATAFILE '/srv/data/oracle/PSS/apex.dbf' SIZE 1G AUTOEXTEND ON NEXT 1500K MAXSIZE 4G;


# *** Installation ***

@apexins.sql APEX APEX TEMP /i/
## Uninstall: @apxremov.sql;
## Oder Install ohne Tablespace "Apex": @apexins.sql SYSAUX SYSAUX TEMP /i/

# *** Change Admin Password ***
# -----------------------------
ALTER SESSION SET CONTAINER=PSSDB;
@apxchpwd.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" does not yet exist and will be created.
Enter ADMIN's email [ADMIN] s.geberl@me.com
Enter ADMIN's password [] Fx#6593376
Created instance administrator ADMIN.

ALTER SESSION SET CONTAINER=PSSDB;

# *** Rest Api configuration ***
# ------------------------------
ALTER SESSION SET CONTAINER=PSSDB;
@apex_rest_config.sql
Enter a password for the APEX_LISTENER user [] Fx#6593376
Enter a password for the APEX_REST_PUBLIC_USER user [] Fx#6593376
...set_appun.sql
...setting session environment
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users
...grants for APEX_LISTENER and ORDS_METADATA user
[...]


ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Fx#6593376 account UNLOCK;

ALTER SESSION SET CONTAINER=PSSDB;

CREATE PROFILE apexpasswordunlimited LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER USER apex_public_user PROFILE apexpasswordunlimited;

exit;

sqlplus / as sysdba
ALTER USER SYS IDENTIFIED BY Fx#6593376 ACCOUNT UNLOCK;


# *** German Language Pack ***
su oracle
cd /srv/app/apex
export NLS_LANG=American_America.AL32UTF8
sqlplus / as sysdba

# ALTER SESSION SET CONTAINER=PSSDB;
# ALTER SESSION SET CURRENT_SCHEMA = APEX_210200;
# @load_trans.sql german