Oracle Portal, Discoverer, Reports and Forms 11g installation Concepts

If you are planning to install oracle Forms, Reports, Portal and Discoverer 11g, few core components including Oracle Internet Directory (OID), Oracle Single Sign-On (OSSO) Continue reading “Oracle Portal, Discoverer, Reports and Forms 11g installation Concepts”

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)”

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”

Oracle External Table

Suppose we have a text file named “emp.data”. This text files contains employees data in following format,

1, Michle , clerk
2, king , manager
3, joe , clerk

What if we want to use this data in SQL query? Remember we do not want to import this data in oracle database but we want to reference this data from its physical location. To achieve this oracle database has provided a feature called External Tables. Using this feature, we can register “emp.dat” file in oracle database as external table. Continue reading “Oracle External Table”

Archivelog mode concepts | Oracle Hot backup and cold backup

We take complete physical backup of database by copying physical database files including datafiles, control files, password file and parameter file. Backup can be online backup or offline backup. In online backup, our database is in open stage and datafiles have different SCN. Continue reading “Archivelog mode concepts | Oracle Hot backup and cold backup”