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
No comments to display
No comments to display