Postfix Install and Test
In order to have mail working properly on APEX, mail must be setup properly.
This note has a lot of information about how I modified linux systems to work with postfix properly.
Postfix Post #1
Oracle Cleanup a Schema
Talking about the APEX$_ tables: If you are not using any Websheets applications, it's safe to drop them. This won't interfere with any of your regular APEX database applications.
If that changes later on, upon creating your first Websheet application, the wizard will detect all missing tables (even corrupt tables if you happened to alter them). A dialog comes up telling you "The database objects required to create Websheet applications are either invalid or do not exist". Click on "Manage Websheets Database Objects" and easily recover them in another wizard within just a few seconds. And you're done.
I secured a domain that I manage through GoDaddy, if I go to the DNS management and add an "A" record for the hostname to IP address. This will put the server in your domain similar to
anyhost.fatcat.com
I used this to give my servers domain names
Changing hostname on OEL 7
Hostname change on RHEL
Additional Hostname Domain Stuff
In this post we will see how we can change the hostname on Linux 7 host. This article is demonstrated on Oracle Enterprise Linux 7.1 – 64 Bit.
Check the existing hostname:
We can use command “hostnamectl” to check the existing hostname.
[root@localhost ~]# hostnamectl status
Static hostname: localhost.localdomain
Icon name: computer
Chassis: n/a
Machine ID: fc456ff1ece743cfb79756356feaca35
Boot ID: c120fe1a556d4cf78f0cfe548800bb65
Virtualization: oracle
Operating System: Oracle Linux Server 7.1
CPE OS Name: cpe:/o:oracle:linux:7:1
Kernel: Linux 3.8.13-55.1.6.el7uek.x86_64
Architecture: x86_64
[root@localhost ~]#
It will read the value of static hostname from file “/etc/hostname”.
Update hostname in “/etc/hostname” file:
[root@localhost ~]# cat /etc/hostname
oraerp1
[root@localhost ~]# cat /etc/hostname.bkp
localhost.localdomain
[root@localhost ~]#
[root@localhost ~]# hostnamectl status
Static hostname: oraerp1
Icon name: computer
Chassis: n/a
Machine ID: fc456ff1ece743cfb79756356feaca35
Boot ID: c120fe1a556d4cf78f0cfe548800bb65
Virtualization: oracle
Operating System: Oracle Linux Server 7.1
CPE OS Name: cpe:/o:oracle:linux:7:1
Kernel: Linux 3.8.13-55.1.6.el7uek.x86_64
Architecture: x86_64
Verify the new hostname:
After connecting with the new session then new hostname will be reflected.
[root@localhost ~]# su -
Last login: Tue Nov 10 00:55:45 AST 2015 on pts/0
[root@oraerp1 ~]#
- 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
- 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
- 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 &
- if 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
APEX on EC2 against Oracle
Configure Oracle APEX 3.2.1 using Embedded PL/SQL Gateway (Unsupported Feature)
Martin Giffy D'Souza on Oracle APEX: How to Send/Upload a CLOB from the Browser to APEX via AJAX
http://www.talkapex.com/2017/10/how-to-setup-oracle-db-12-2-docker-container/
Oracle Docker
This is a link for Google maps pricing for usage in apps. To use the mapping function in a dev capacity, I don't think there would be a heavy usage in this use case.
Google Maps Pricing
Configuring mail properly on a linux server is critical for APEX to send mail properly.
Postfix log file location
Configuring Postfix as a Gmail Relay on CentOS
iptables
then mail works
ora_utlmail
ora_prvtmail
/u01/app/oracle/product/12.2.0/db_1/rdbms/admin
directory for rdbms admin stuff
There are several websites and tools that are available for APEX help
PL/SQL Doc Tool
SkillBuilder Aleto
APEX Apps