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 […]
Category: 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 […]
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 […]
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 […]
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 […]
Categories
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 […]
Here’s are the simple steps to create an OID instance. 1. Install and configure your database instance and make sure it is working with all listener and emctl ports up. 2. Install weblogic, no need to configure a domain right now. 3. Install idm or OID, during installation you are provided with an option of […]
Categories
Connecting to a remote Oracle Database.
Local database Connecting to a local database is easy, just use: $ sqlplus dbUser/dbPassword@dbSid Here’s the syntax for connecting to a remote database using its SID: $ sqlplus dbUser/dbPassword@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=remoteServer)(PORT=1521)))(CONNECT_DATA=(SID=dbSid)))’
This error mainly occurs due to incorrect ORACLE_SID value set. Make sure you have set the ORACLE_HOME & ORACLE_SID value set properly.
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 […]