Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from version 5.1.4 to 18.1 . The new version of Apex has many exciting new features, you can read about them all here Setup : Apex Version : Oracle Apex 5.1.4 Webserver : ORDS Running on … Continue reading Upgrade Oracle Apex from 5.1.x to 18.1
Enable Transparent Data Encryption in Oracle 12c (12.1 12.2)
1. Add Encryption Wallet in sqlnet.ora Location $ORACLE_HOME/network/admin [oracle@localhost admin]$ vi sqlnet.ora ENCRYPTION_WALLET_LOCATION = (SOURCE =(METHOD = FILE)(METHOD_DATA = (DIRECTORY = /u01/wallet))) 2. Create encryption wallet location mkdir -p /u01/wallet 3. Create Keystore and Key. And Open the Wallet SQL*Plus: Release 12.2.0.1.0 Production on Thu May 24 14:36:10 2018 Copyright (c) 1982, 2016, Oracle. … Continue reading Enable Transparent Data Encryption in Oracle 12c (12.1 12.2)
Generate REST API from mysql database in less than 5 minutes
Representation State Transfer is the new industry standard of building technology neutral API's. REST API are essentially web services to read or transfer data. REST API's can be build on top of most relational databases. Mysql being the most popular database around. If you have nodejs and mysql already installed, you can build a REST … Continue reading Generate REST API from mysql database in less than 5 minutes
Install mysql database along with phpadmin on CENTOS 6 7
Mysql is the most popular open database and is the M in the LAMP stack (others being Linux-Apache-PHP) If your on CentOS and your linux server is connected to the internet installing mysql is just a few terminal commands 1. Install the LAMP stack via yum $ yum install httpd mysql-server php php-mysql 2. Configure … Continue reading Install mysql database along with phpadmin on CENTOS 6 7
Install Oracle Apex 5.1.x on ORDS 3,17.4, 18.1
Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex can be run directly from the database engine itself using a component called Mod PL/SQL. It is one of the easiest way to run Apex, but it is not a production ready setup. In a … Continue reading Install Oracle Apex 5.1.x on ORDS 3,17.4, 18.1
Install NodeJS on Mac OS
To install NodeJS on a Mac the first thing you have to do is download Brew package manager for mac. Though you can install NodeJS via other methods but doing it with Brew is the easiest and least error prone method 1. Install Brew on your mac if you dont have it already. Open the … Continue reading Install NodeJS on Mac OS
Install NodeJS on CentOS 6 – 7
Install Latest NodeJS on CentOS 6 or 7 -------------------------------------- 1. Add Repo and Install NodeJS For Stable Release:- $ yum install -y gcc-c++ make $ curl -sL https://rpm.nodesource.com/setup_8.x | sudo -E bash - $ yum install nodejs 2. Check the version for Node and NPM $ node -v v8.11.1 $ npm -v 5.6.0 … Continue reading Install NodeJS on CentOS 6 – 7
Quick and Easy Integration with Twitter with Apex 18.1
Quick Integration with Twitter in Oracle Apex 18.1 https://blogs.oracle.com/apex/quick-and-easy-twitter-api-with-apex-181
Add Background Image and Logo in CSS for Oracle Apex
So you have got your Oracle APEX instance up and running and you want to customize your first app. The easiest way to add logo and background image to your login page is by using CSS Go to Page Desginer > CSS > Inline and Add Below Code span.t-Login-logo { background-image: url(#WORKSPACE_IMAGES#whitehat.png); backgroung-size: cover; width: … Continue reading Add Background Image and Logo in CSS for Oracle Apex
ORA-01103: database name ‘MW’ in control file is not ‘MWTST’
This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the one in the control file. Sometimes it so happened that after duplicating the database name in SPFILE with which you started the instance with is not matching the one in the control file. Explanation: ===================== … Continue reading ORA-01103: database name ‘MW’ in control file is not ‘MWTST’