About WordPress
WordPress.org
Documentation
Support
Feedback
Log In
Search
IT
Remote
Remote IT Services
MRC Consulting Services
Main
AI Master
APEX General Information
GoldenGate
Classes
Oracle Versions
Oracle 18c
Oracle 11gR2
Oracle 12c Reference Page
Oracle 12c
Exadata
Windows10 Issues
DBFS
ACFS
Dataguard
Oracle Tools
Scripts
Shell Code
ASH Info
MRC Systems
Oracle Cloud Login
Amazon Login Screen
Wine Database
Cirrus Rental Database
Admin Console 006
Hockey CRM
APEX Oracle Site
Admin Console
Sample Upload Download apex.oracle
Customer Tracker
Opportunity Tracker
AirCRM
VaporTrail
Samp Database App
DBAdmin
Sample Calendar
Expertise Tracker
SubTracker
DBAdmin01
Aviation Links
Aviation Training Co
Aviation Trading Co
American Aero Club
WildWingdom Aviation
Personal
MRC Intranet
MRC Consulting
All Posts
Set up ec2 instance using OL7.2-x86_64-HVM-2015-12-10 Amazon Machine Image (AMI), now using 7.3 for OL
Setup a elastic IP against the server
Login via MobaXterm as ec2-user and change password, I use putty
sudo passwd ec2-user
Install packages needed for instance
sudo yum install wget zip unzip -y
sudo yum install perl-libwww-perl.noarch -y
sudo yum install java-1.8.0-openjdk.x86_64 -y
sudo yum install updates
Create apex user and make it so user can connect
sudo useradd -d /home/apexuser apexuser
sudo passwd apexuser
cd ~
mkdir .ssh
chmod 700 .ssh
touch .ssh/authorized_keys
chmod 600 .ssh/authorized_keys
GET
http://169.254.169.254/latest/meta-data/public-keys/0/openssh-key>
;.ssh/authorized_keys
log out and login as apexuser
Make directories for apexlistener, oracle client, and ORDS
mkdir /home/apexuser/apexlistener
mkdir /home/apexuser/orclclient
mkdir /home/apexuser/ORDS
Upload files and unzip in respective directories
unzip apex_5.0.3_en.zip -d /home/apexuser/apexlistener
upload oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm into /home/apexuser/orclclient
upload oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm into /home/apexuser/orclclient
unzip ords.3.0.3.351.13.24.zip -d /home/apexuser/ORDS
Install oracle client
su ec2-user
cd /home/apexuser/orclclient
rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
Update bash profile of apex user for client
su apexuser
cd ~
vi ~/.bash_profile
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib:$LD_LIBRARY_PATH
export PATH=/usr/lib/oracle/12.1/client64/bin:$PATH
source ~/.bash_profile
sqlplus SYS/PASSWORD@HOSTNAME:1521/orcl as sysdba
Go to your database server & uninstall apex from container database
!!!!!!!Make sure you uninstall or unplug any pluggable databases before you do this!!!!!!
/u01/app/oracle/product/12.1.0/dbhome_1/apex
sqlplus / sys as sysdba
@
apxremov_con.sql
Create pluggable database & add USERS tablespace
Go to SQL Developer for these tasks
Create pluggable database and open read / write
Connect to pluggable database
Create Users tablespace on pluggable database
CREATE TABLESPACE “USERS” DATAFILE
‘/u01/app/oracle/oradata/orcl/pdbseed/users01.dbf’ SIZE 5242880
AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
Install apex on your container database, change apex admin user and create rest data services user
ALTER SESSION SET CONTAINER =PDBORCL (your pluggable database name)
@
apexins.sql
SYSAUX SYSAUX TEMP /i/
@
apxchpwd.sql
@
apex_rest_config.sql
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Password1 ACCOUNT UNLOCK;
Go to your Apex server and Run ORDS set up
cd /home/apexuser/ORDS
java -jar
ords.war
/home/apexuser/ORDS/config/ (configuration directory)
/home/apexuser/apex/images (static resources directory)
add tcp rule for 8080 (or port you used if you haven’t already when you created server)
stop server using ctrl c and start with nohup
nohup java -jar
ords.war
&
i
f you need to stop
server issue top command and find java process running under apexuser and kill process number
top -u apexuser
kill [process]
At this point your APEX UI should be available at
http://HOSTNAME:8080/ords
Ready for Action?
LET'S GO!
(864) 248-6284
info@it-remote.com
Visit our Facebook
Visit our Instagram
Visit our Twitter
Visit our LinkedIn
Copyright 2024 IT Remote dot com
database
linkedin
facebook
pinterest
youtube
rss
twitter
instagram
facebook-blank
rss-blank
linkedin-blank
pinterest
youtube
twitter
instagram