Installing node-oracledb on Centos 7 for Meteor

  1. Download Oracle Instant Client basic, devel, and sqlplus package RPM from Oracle’s website in RPM format
  2. Install all files for Oracle Instant Client using :
    rpm -ivh oracle-instantclient*
  3. Set required environment variables :
    export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/
    export OCI_LIB_DIR=/usr/lib/oracle/12.1/client64/lib/
    export OCI_INC_DIR=/usr/include/oracle/12.1/client64/
  4. Install node-oracledb
    meteor npm install oracledb --save
  5. That’s it. Enjoy! 🙂

Installing Oracle 11 XE on Centos 7

  1. Download Oracle 11 XE from Oracle website here
  2. Install required tools
    yum install libaio bc flex unzip
  3. Unzip the downloaded Oracle archive
    unzip oracle-*
  4. Install Oracle
    cd Disk1
    rpm -ivh oracle-*
  5. Configure the newly installed Oracle database
    /etc/init.d/oracle-xe configure
  6. Set ORACLE_HOME
    export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
  7. Add ORACLE_HOME to PATH
    export PATH=$PATH:$ORACLE_HOME/bin
  8. Add ORACLE_SID to PATH
  9. export ORACLE_SID=XE
  10. Log in to SQLPlus
    sqlplus sys/sys as sysdba
  11. If you are Connected, add new user if you want. If not start the database first
    startup
  12. Add test user
    create user test identified by password;
    grant connect,resource,dba to test; //be careful for dba
  13. That’s all. Enjoy!

Installing PostgreSQL 5.6 on Centos 7

Step-by step walkthrough :

  1. Download repository RPM from :
    http://yum.postgresql.org/repopackages.php
  2. After choosing which RPM to download, at terminal :
    yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-1.noarch.rpm
  3. Install the database
    yum install postgresql96-server postgresql96-contrib
  4. Initialize database
    /usr/pgsql-9.6/bin/postgresql96-setup initdb
  5. Create database user
    su - postgres
    createuser --interactive
  6. Create new database
    su - newuser
    createdb newdb
  7. Connect to newly created database
    psql -d newdb
    \conninfo //for connection information
  8. Change database user password
    \password
    \q to quit
  9. To start PostgreSQL service
    systemctl start postgresql-9.6.service
  10. To add to system startup
    systemctl enable postgresql-9.6.service
  11. To allow remote connections, edit :
    vi /var/lib/pgsql/9.6/data/postgresql.conf 
    
    # Change line containing listen_addresses to this :
    listen_addresses='*'
  12. Edit pg_hba.conf file to allow all connections :
    vi /var/lib/pgsql/9.6/data/pg_hba.conf 
    
    # Add new line 
    host all all 0.0.0.0/0 md5
  13. Restart the service
    systemctl restart postgresql-9.6.service
  14. That’s it. Enjoy.