Category Archives: Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

All Useful 11g Dynamic Performance Views

What is Oracle Dynamic Performance Views Oracle Dynamic Performance Views is a set of views(V_$) which are defined over very low level Oracle views called the X$ views View. We have views for complete set of operations. V$ names are synonyms which point to the V_$ views What is X$view :The X$ views are very low level representations of Oracle internal database structures. They are … Continue reading All Useful 11g Dynamic Performance Views »

Top 46 Oracle ASM Interview Questions

Oracle ASM is widely used in IT industry. Here I have compiled Top 46 Oracle ASM Interview Questions to enhance the knowledge about Oracle ASM instance Question 1 What is ASM in Oracle? Answer Oracle ASM is Oracle’s volume manager specially designed for Oracle database data. It is available since Oracle database version 10g and many improvements have been made in versions 11g release 1 and … Continue reading Top 46 Oracle ASM Interview Questions »

Pre-Built Oracle database for learning and testing using Oracle Developer VM

Oracle developer day pre-installed virtual machine is very useful to perform lab testing on Oracle database. It is very helpful for practicing about Oracle database on Linux machine on your laptop. You can also export your application database and import into this pre-installed oracle VM, It is very quick and easy to setup. Here is the steps to setup Oracle developer day VM  Please note that … Continue reading Pre-Built Oracle database for learning and testing using Oracle Developer VM »

Virtual IP Addresses(VIP) in Oracle RAC

What is VIP in Oracle RAC? High Availability (HA) databases are less than satisfactory if database clients are unable to connect or reconnect quickly when planned or unplanned downtime causes one or more instances to become unavailable. Database clients use TNS descriptors to contact a TNS listener on one of the cluster nodes from a list of listeners on all cluster nodes. TNS descriptors for … Continue reading Virtual IP Addresses(VIP) in Oracle RAC »

What is voting disks in RAC

Last updated on April 1st, 2017 at 08:09 amVoting Disks in RAC Description Voting disk is a file that manages information about node membership.It is located on the shared cluster system or a shared raw device file or ASM(11gr2 onwards) .Its primary purpose is to help in a situation where the private network communication fails.CSS (Cluster Synchronization Service) is the service that determines which nodes … Continue reading What is voting disks in RAC »

Demonstration/Viewlet/Videos for Many Oracle features

Oracle has provided lot  of Demonstration/Viewlet/Videos on Oracle features like RMAN,Flashback,standby etc Each demonstration has a description and links to the demo.  Some demos have a ‘demo’ link that will play in your browser on any platform.  Others have a ‘download’ link which will download an executable file to your computer that will only play on a Windows system. Some demos offer both options. Here … Continue reading Demonstration/Viewlet/Videos for Many Oracle features »

How to resolve ORA-00904: invalid identifier

ORA-00904: invalid identifier is one of the common error seen. Reference: Oracle documentation One of the most common cause of this error Invalid identifier means the column name entered is either missing or invalid. It also Some time comes  when you used reserved word in Oracle database. Check List to resolve the ORA error  It comes when you put extra comma in the create table … Continue reading How to resolve ORA-00904: invalid identifier »

How to work with date in Oracle sql

Last updated on April 1st, 2017 at 10:02 amThis post I am trying to explain many things  about oracle date datatype like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in  years,oracle date difference in  days, oracle date difference in  months Oracle has provided date and timestamp type for storing the date and time information in the database. Date Type DATE is … Continue reading How to work with date in Oracle sql »

How to resolve ORA-00900

ORA-00900 is one of the common error Here what oracle documentation says about it Reference: Oracle documentation Checklist to solve the ORA-00900 error This error commonly occurs when you are trying to create an Oracle procedure and the Procedural Option is not installed.To determine if the Procedural Option has been installed, open an Oracle session using SQL*Plus. If the PL/SQL banner does not display, then … Continue reading How to resolve ORA-00900 »

How to resolve the ORA-01017: invalid username/password; logon denied

ORA-01017  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Here are the checklist to run to resolve the error The main issue with an ORA-01017 error is an invalid user ID and passwords combination.  You have to make sure ,you are entering the right password Incase the target system is 11g, the password can be … Continue reading How to resolve the ORA-01017: invalid username/password; logon denied »

How to resolve ORA-06512 at line num

ORA-06512  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Reference :Oracle documentation Explanation of the error: Error Ora-06512 means the backtrace message as the stack is being unwound by unhandled exceptions in your PLSQL code. This is a catch-all error for PLSQL exceptions and is commonly seen. Ora-06512 does not indicate the actual error, but … Continue reading How to resolve ORA-06512 at line num »

Top 40 oracle dba interview questions and answers

Last updated on April 1st, 2017 at 10:36 amThis article contains the most commonly asked top 40 oracle dba interview questions and answers 1) What is oracle database ? Answer: Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated … Continue reading Top 40 oracle dba interview questions and answers »