A Very Cool Oracle Bash Profile

[code language="css"] # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH # Oracle Settings export TMP=/tmp export ORACLE_HOSTNAME=easyoradba.com export ORACLE_UNQNAME=ora12c export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1 export ORACLE_SID=ora12c export CATALINA_HOME=/home/oracle/apache-tomcat PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$CATALINA_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; alias ob='cd $ORACLE_BASE' alias … Continue reading A Very Cool Oracle Bash Profile

Install Oracle Database 12cR2 Silent Mode on CENT OS 7 & Oracle Linux 7

If you are going to work on Oracle Database in cloud or in environments where X11 client or server is not available. It is always good to learn how to do a silent installation of Oracle. Specially in todays CI/CD devops model where dba's have to provision DB servers using Ansible or other such tools. … Continue reading Install Oracle Database 12cR2 Silent Mode on CENT OS 7 & Oracle Linux 7

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

Install Oracle Apex 5.1.x, 18.1 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, 18.1 on ORDS 3,17.4, 18.1

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’

Compare 2 Servers RPM and Install RPM from Text File List

1. Generate RPM list on Old Server rpm -qa --queryformat='%{NAME}\n' | sort > serverold.txt 2. Generate RPM list on New Server rpm -qa --queryformat='%{NAME}\n' | sort > servernew.txt 3. Copy File to New Server and use diff comand to get differences diff serverold.txt servernew.txt > diff.txt 4. Get list of packages missing in new Server … Continue reading Compare 2 Servers RPM and Install RPM from Text File List