ORA-02248 error while connecting Developer 6i to Database 11g

If you have an older version of Developer 6i and try to connect to Database server 11g, connection fails with following error message

ORA-02248: invalid option for ALTER SESSION

To resolve this problem simply upgrade your Developer 6i release by Continue reading ORA-02248 error while connecting Developer 6i to Database 11g

RMAN Recovery | Restore Controlfile

In this post, you will learn how to recover a database using RMAN. To recover database, an RMAN backup is required. In last article, it was explained that how we can take backup using RMAN. Continue reading RMAN Recovery | Restore Controlfile

RMAN script to take full database backup

Following section explains how we can take full database backup using RMAN command line interface on windows.

Before tacking backup, decide which type of backup you want to take. You can take online or offline backup using RMAN. Continue reading RMAN script to take full database backup

Create Virtual Mapping for Forms 11g | Deploy Images and Icons in Forms 11g

This article explains virtual Directory Mapping for Forms 11g version 11.1.1.1.0.  This mapped virtual directory can be used to deploy icons, images, HTML and other files. Continue reading Create Virtual Mapping for Forms 11g | Deploy Images and Icons in Forms 11g

Forms, Reports, Discoverer, Portal 11g installation with OID 10g (10.1.4.3) and SSO (10.1.4.3)

I want to share my experience of installing Oracle Forms, Reports, Discoverer, Portal 11g with Oracle internet Directory 10g (10.1.4.3) and Oracle Single Sign-On 10g (10.1.4.3). I did it on windows server 2003 sp2. Under each step I have provided the names of installer packages which can be downloaded from oracle website. Continue reading Forms, Reports, Discoverer, Portal 11g installation with OID 10g (10.1.4.3) and SSO (10.1.4.3)

Oracle PGA

Oracle instance consists of SGA and oracle processes. Oracle processes can be divided into server processes and background processes. Oracle database uses background processes to perform overall database operations, for example, database writer process writes dirty buffer from database buffer cache to datafiles. Continue reading Oracle PGA