cd /u01/app/oracle/product/11.2.0/xe/bin
. ./oracle_env.sh
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
sqlplus /nolog
exit
sqlplus / as sysdba
ALTER SYSTEM SET MEMORY_TARGET = 800M SCOPE=spfile;
ALTER SYSTEM SET MEMORY_MAX_TARGET = 930M SCOPE=spfile;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
startup force
show parameter target
unzip apex_18.1.zip
sudo mv apex/ /opt/
cd /opt/apex
sqlplus / as sysdba
@/u01/app/oracle/product/11.2.0/xe/apex/apxremov.sql
exit
sqlplus / as sysdba
@apexins SYSAUX SYSAUX TEMP /i/
exit
sqlplus / as sysdba
@apex_epg_config.sql /opt
exit
sqlplus / as sysdba
@apxchpwd
ADMIN
myPassword
sqlplus / as sysdba
SELECT version FROM dba_registry where comp_id='APEX';
exit
# The structure of the link to the Application Express administration services is as follows:
# http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
# http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
# http://host:port/apex/apex_admin (Oracle REST Data Services)
#
# The structure of the link to the Application Express development interface is as follows:
# http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
# http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
# http://host:port/apex (Oracle REST Data Services)
sqlplus / as sysdba
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
exit