Category Archives: APEX

APEX APEX$_ Tables

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.

Hostname Information

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 ~]#

APEX Install EC2

  1. Set up ec2 instance using OL7.2-x86_64-HVM-2015-12-10 Amazon Machine Image (AMI), now using 7.3 for OL
  2. Setup a elastic IP against the server
  3. Login via MobaXterm as ec2-user and change password, I use putty
    • sudo passwd ec2-user
  4. 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
  5. Create apex user and make it so user can connect
  6. Make directories for apexlistener, oracle client, and ORDS
    • mkdir /home/apexuser/apexlistener
    • mkdir /home/apexuser/orclclient
    • mkdir /home/apexuser/ORDS
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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;
  12. 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;
  13. 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]
  14. At this point your APEX UI should be available at http://HOSTNAME:8080/ords