Step by step guide to build local Apache PHP MySQL development environment on windows

A php developer would offcourse like to test the php file before deploying on the webserver.A local Apache PHP MySQL development environment on windows allows you to test your code as you develop your web application before publishing it to the web. This article will guide you through setting up a local Apache PHP MySQL development environment … Continue reading Step by step guide to build local Apache PHP MySQL development environment on windows »

Step-by-Step guide for Installing MySQL on Windows

The MySQL database server is one of the most popular open-source database servers commonly used in web application development.This document provides Step-by-Step guide for Installing MySQL on Windows. It covers the configuration details also with screen shot Starting the Download 1.Go to http://dev.mysql.com/downloads/installer/. 2.Click the Download button. 3.  Scroll down to the MySQL database server & … Continue reading Step-by-Step guide for Installing MySQL on Windows »

ORA-03113: end-of-file on communication channel

ORA-03113 is a quite a common error.Let us take a deep dive into it Issue ORA-03113: end-of-file on communication channel Cause: The connection between Client and Server process was broken. It may also happen if the external agent extproc crashes for some reason. Action: There was a communication error that requires further investigation. First, check … Continue reading ORA-03113: end-of-file on communication channel »

Incremental Statistics Gathering in 11g

-11g database has introduced the Incremental statistics gathering new feature -Incremental stats will work only for partitioned tables where global statistics are updated incrementally by scanning only the partitions that have changed from the last run.Generally latest partitions are the ones where data is inserted and mostly the older partitions are remain untouched. With enabling … Continue reading Incremental Statistics Gathering in 11g »

Most commonly asked 25 Oracle PlSQL interview questions

Here  is the compilation of Most commonly asked Oracle Plsql interview questions Q1) What is Oracle plsql? Answer PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language Q2) What are the components of a PL/SQL Block? Answer Declarative part, Executable part … Continue reading Most commonly asked 25 Oracle PlSQL interview questions »

How to resolve the ORA-00257 error in Oracle database

ORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.Database almost got frozen because of it and all transaction get stopped .Let us see how to deal with ORA-00257 error Error Message   ORA-00257: archiver error. Connect internal only, until freed. As per The oerr ORA-00257 error … Continue reading How to resolve the ORA-00257 error in Oracle database »

How to resolve ORA-29913 with external tables

ORA-29913 is one of the common error when working with external tables in Oracle database. We would be looking at various ways the error can be produced and what can be done to resolve the error External File not found or permission incorrect SQL> select * from Scott.example_external_table; select * from example_external_table * ERROR at … Continue reading How to resolve ORA-29913 with external tables »

How to Enable the Logging in Oracle mobile apps

We are living in Mobile age and Oracle E-Business Suite has its mobile apps to provide the functionality on Andriod/IOS. Oracle has release many Mobile apps for the various module. We will be looking at the ways on How to Enable the Logging  in Oracle mobile apps  and troubleshoot them Troubleshooting Oracle E-Business Suite mobile apps involves … Continue reading How to Enable the Logging in Oracle mobile apps »

Every thing You must know about Profile options in Oracle Apps

Introduction to Profile options in Oracle Apps A set of changeable options that affects the way your application runs.The profile option acts like a Global Variable in Oracle, to provide the flexibility in Oracle Applications Two type of Profile options System Profile Options :It is set by the System administrator.User cannot access it and Any change … Continue reading Every thing You must know about Profile options in Oracle Apps »