Upgrade Oracle Apex from 5.1.x to 18.1

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

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  

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’