MySQL an introduction and basic tutorial

MySQL is a Open source database management systems. It ‘s a powerful database management system with a lot of flexibility. This tutorial covers basic introduction to MySQL. In this tutorial I’m using Centos operating system for installing MySQL. Installing MySQL in centos MySQL can be installed using yum repository, and can be installed using the […]

Most commonly used opensource databases

Almost all developers has his/her own favorite databases, here I’m going have a small insights on the commonly used Opensource databases. Here’s the list of most commonly used Opensource databases MySQL PostgreSQl MongoDB SQLite There are a  lot more databases, here I’m planning have a short intro on the above mentioned databases. MySQL According to […]

Working with Oracle HTTP Server

In this blog i’m covering some basics on Oracle HTTP server(OHS) like Checking OHS status. Starting, stopping and restarting OHS. Creating an Oracle HTTP server component. Deleting an Oracle HTTP server component. Checking OHS Status We can determine the status of OHS by using the opmnctl command $ORACLE_INSTANCE/bin/opmnctl status Processes in Instance: instance1 ———————————+——————–+———+———+——- ias-component […]

ORA-00845: MEMORY_TARGET not supported on this system

Getting ORA-00845: MEMORY_TARGET not supported on this system, while trying to start a database. Error sql> startup ORA-00845: MEMORY_TARGET not supported on this system Reason: This is a very common error which you might face while starting up your oracle database. This happens when your system is out of temporary storage. While starting up the […]

PostgreSQL database fixes “persistent denial-of-service” bug

Maintainers of the PostgreSQL open-source database have patched a vulnerability that allowed attackers to corrupt files and in some cases, execute malicious code on underlying servers. The bug, categorized as CVE-2013-1899, opened users to “persistent denial-of-service” attacks, in which unauthenticated hackers could corrupt files in a way that caused the database server to crash and refuse […]

Parameter processes in oracle DB

How to update parameter processes value in oracle Database 1. Login to oracle $sqlplus SYS as SYSDBA 2. Check the current processes value $SQL> show parameter processes; 3. update it to the desired value, for eg: updating to 500 $SQL>alter system set processes=500 scope=spfile; $SQL> commit $SQL>shutdown immediate $SQL> startup 4. you are done, recheck […]

ORA-01034: ORACLE Not Available

What to do when we get  errors  like ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist. Solution: The ORA-01034 is  simple error, it means that your database is down!  Oracle oerr utility notes this about the ORA-01034 error: ORA-01034: ORACLE not available Cause:  Oracle was not started up. Possible causes include the […]