Apex Installtion
Apex Installtion
com/technetwork/developer-tools/apex/learnmore/apex-example-
deployment-wp-2214343.pdf
===============
[oracle12c@fusionprod ~]$ id
uid=12347(oracle12c) gid=12345(oinstall)
groups=12345(oinstall),12346(dba),12347(oper)
=========
--> Java download & Installation.
https://support.oracle.com/epmos/faces/PatchResultsNDetails?
_afrLoop=452516581914346&patchId=16534054&_afrWindowMode=0&_adf.ctrl-
state=15o6r942a6_331
/u01/app/oracle/middleware/user_projects/domains/APEX
==============
SQL> create tablespace tablespace_apex datafile
'/u04/app/oracle/VIS/data/tablespace_apex01.dbf'size 1g;
Tablespace created.
Tablespace created.
Tablespace created.
===================
cd /u01/app/temp/apex
1 row selected.
...null1.sql
=========
select username,ACCOUNT_STATUS,CREATED from dba_users where username in
('APEX_050100','FLOWS_FILES','APEX_PUBLIC_USER');
select username,ACCOUNT_STATUS,CREATED from dba_users where username in
('ANONYMOUS');
============
http://host:port/apex/apex_admin
http://fusionprod.redshoretech.com:8085/apex/apex_admin
http://192.168.3.11:8085/apex/apex_admin
http://fusionprod.redshoretech:8085/pls/apex/apex_admin
=================
Environmental File:-
# WebLogic 12c 12.1.3 environment file
export JAVA_HOME=/usr/java/jdk1.8.0_144
export PATH=$JAVA_HOME/bin:$PATH
export MW_HOME=/u04/app/oracle/middleware
export WLS_HOME=$MW_HOME/wlserver
===
. ~/set_wls12.env
=======Start Weblogic Server==============
cd /u04/app/oracle/middleware/user_projects/domains/APEX/
============cd /u04/app/weblogic12c/=====================
/u04/app/weblogic12c/deploy/apexdev
/u04/app/weblogic12c/wkdir/apexdev
========================
[weblogic12c@fusionprod weblogic12c]$ cd deploy/apexdev/
[weblogic12c@fusionprod apexdev]$ ls -ltr
total 39624
drwxr-xr-x 3 weblogic12c oinstall 4096 Sep 20 2017 docs
drwxr-xr-x 2 weblogic12c oinstall 4096 Sep 20 2017 params
drwxr-xr-x 2 weblogic12c oinstall 4096 Sep 20 2017 logs
-rw-r--r-- 1 weblogic12c oinstall 40507835 Sep 20 2017 ords.war
-rw-r--r-- 1 weblogic12c oinstall 46094 Sep 20 2017 readme.html
drwxr-xr-x 6 weblogic12c oinstall 4096 Sep 20 2017 examples
[weblogic12c@fusionprod apexdev]$ cp ords.war ords.war.bkp
[weblogic12c@fusionprod apexdev]$ mv ords.war apex.war
[weblogic12c@fusionprod apexdev]$ ls -ltr
total 79184
drwxr-xr-x 3 weblogic12c oinstall 4096 Sep 20 2017 docs
drwxr-xr-x 2 weblogic12c oinstall 4096 Sep 20 2017 params
drwxr-xr-x 2 weblogic12c oinstall 4096 Sep 20 2017 logs
-rw-r--r-- 1 weblogic12c oinstall 40507835 Sep 20 2017 apex.war
-rw-r--r-- 1 weblogic12c oinstall 46094 Sep 20 2017 readme.html
drwxr-xr-x 6 weblogic12c oinstall 4096 Sep 20 2017 examples
-rw-r--r-- 1 weblogic12c oinstall 40507835 Apr 6 20:37 ords.war.bkp
[weblogic12c@fusionprod apexdev]$
[weblogic12c@fusionprod apexdev]$ java -jar apex.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the username with SYSDBA privileges to verify the installation [SYS]:sys
Enter the database password for sys:
Confirm password:
ORA-01017: invalid username/password; logon denied
Try again. Enter the database password for sys:
Confirm password:
Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:tablespace_apex
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter
1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database
users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:2
Apr 06, 2018 8:50:06 PM
INFO: Updated configurations: defaults, apex, apex_pu
Installing Oracle REST Data Services version 3.0.12.263.15.32
... Log file written to
/u04/app/weblogic12c/deploy/apexdev/logs/ords_install_core_2018-04-
06_205006_00129.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to
/u04/app/weblogic12c/deploy/apexdev/logs/ords_install_datamodel_2018-04-
06_205125_00014.log
Completed installation for Oracle REST Data Services version 3.0.12.263.15.32.
Elapsed time: 00:01:23.781
================
==========Creation of Webarchive===========
[weblogic12c@fusionprod apexdev]$ pwd
/u04/app/weblogic12c/deploy/apexdev
[weblogic12c@fusionprod apexdev]$
[weblogic12c@fusionprod apexdev]$ java -jar apex.war static
/u04/app/weblogic12c/wkdir/apexdev/images
WAR Generation complete
WAR location : /u04/app/weblogic12c/deploy/apexdev/i.war
Context path : /i
Static resources : /u04/app/weblogic12c/wkdir/apexdev/images
Ensure the static resources are available at path:
/u04/app/weblogic12c/wkdir/apexdev/images
on the server where the WAR is deployed[weblogic12c@fusionprod apexdev]$
=============================
/u04/app/oracle/middleware/user_projects/domains/APEX/bin