100% found this document useful (1 vote)
143 views

Apex Installtion

The document outlines the steps to install Oracle Application Express (APEX), Oracle WebLogic Server, and Oracle REST Data Services on an Oracle database. It describes creating the necessary database objects, downloading and installing Java, and configuring the APEX application. Key directories and URLs are provided for the installed applications.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
100% found this document useful (1 vote)
143 views

Apex Installtion

The document outlines the steps to install Oracle Application Express (APEX), Oracle WebLogic Server, and Oracle REST Data Services on an Oracle database. It describes creating the necessary database objects, downloading and installing Java, and configuring the APEX application. Key directories and URLs are provided for the installed applications.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 5

http://www.oracle.

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)

--> Create User:

useradd -u 54321 -g oinstall -G dba,oper -c "Oracle Weblogic Software Owner"


weblogic

[root@fusionprod ~]# useradd -u 54321 -g oinstall -G dba,oper -c "Oracle Weblogic


Software Owner" weblogic

=========
--> 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.

SQL> create tablespace tablespace_files datafile


'/u04/app/oracle/VIS/data/tablespace_files01.dbf'size 1g autoextend on next 10m;

Tablespace created.

SQL> create temporary tablespace tablespace_temp tempfile


'/u04/app/oracle/VIS/data/tablespace_temp01.dbf'size 500m autoextend on next 10m;

Tablespace created.

===================

cd /u01/app/temp/apex

conn /as sysdba

@apexins.sql tablespace_apex tablespace_files tablespace_temp /i/


--------->
Thank you for installing Oracle Application Express 5.1.4.00.08

Oracle Application Express is installed in the APEX_050100 schema.

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)

timing for: Phase 3 (Switch)


Elapsed: 00:05:01.13
timing for: Complete Installation
Elapsed: 00:39:44.86

PL/SQL procedure successfully completed.

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

=================

useradd -u 54324 -g oinstall -G dba,oper -c "Oracle Weblogic Software Owner"


weblogic12c

[root@fusionprod oracle]# chown -R weblogic12c:oinstall


/u04/app/oracle/middleware
[root@fusionprod oracle]#
[root@fusionprod oracle]#
[root@fusionprod oracle]# chmod 755 /u04/app/oracle/middleware
[root@fusionprod oracle]#
===============Software Location============
/u04/app/weblogic12c/fmw_12.1.3.0.0_wls.jar
======================
export JAVA_HOME=/usr/java/jdk1.8.0_144
export PATH=$JAVA_HOME/bin:$PATH
java -version
==============start WLS install============
cd /u04/app/weblogic12c
export USER_MEM_ARGS="-Xms32m -Xmx200m -XX:MaxPermSize=350m"
$JAVA_HOME/bin/java -d64 -Xmx1024m -jar wls1211_generic.jar
Extracting 0%.............
============

Domian Home Location:- /u04/app/oracle/middleware/user_projects/domains/APEX


weblogic/Welcome1
Prduction Mode
AdminServer/192.168.3.11/7015
NodeManager/Welcome1
ManagedServer_1/192.168.3.11/7025
ManagedServer_2/192.168.3.11/7026
Machine-Fusionprod/192.168.3.11/5566
==========

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 location to store configuration data:/u04/app/weblogic12c/wkdir/apexdev


Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID
[1]:2
Enter the database SID [xe]:VIS
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Please login with SYSDBA privileges to verify Oracle REST Data Services schema.

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

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2


[weblogic12c@fusionprod apexdev]$
===========================
[weblogic12c@fusionprod ~]$ cd /u04/app/weblogic12c/wkdir/apexdev
[weblogic12c@fusionprod apexdev]$ ls -ltr
total 48
drwxr-xr-x 3 weblogic12c oinstall 4096 Apr 6 20:38 apex
drwxr-xr-x 34 weblogic12c oinstall 40960 Apr 6 20:56 images

================

==========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

You might also like