ORA-28112: failed to execute policy function

On some client side, today a developer got the errorORA-28112: failed to execute policy function, while running the few Oracle forms.

Install Oracle Database 11gR2 on Solaris 10

Purpose: Installation of Oracle Database 11g Release 2 (11.2.0.2) on Solaris 10 (x86-64)

Environment: Solaris 10 on VMWare, 11gR2 Database

Step 1:  Install Solaris 10

Step2:  Oracle Database 11g Downloads

Step3:  Prepare Solaris for  Oracle Database 11gR2

Create/Work with an Oracle TimesTen 11.2.2 Database - Windows

In order to create and work with TimesTen database we will perform the below tasks.

1- Define Datasource (DSN)

2- Specify DSN, data source path & name, the size of database and the database character set.

3-Verify that database daemon is running
4-Use ttisql to connect and create/work the database

Oracle Database 12c: Are you ready?

What is 12c Database?

Oracle Database 12c is the next release of Oracle’s flagship database product, expected to be launched in calendar Q1, 2013. Because it is  not yet officially launched to general availability , information about it, is limited. following are the information I could manage to gather from various sources, 100% authenticity is not guaranteed until the product is released officially.

ORA 1775 looping chain of synonyms

There can be multiple reasons for this error.

1- Through a series of CREATE synonym statements, a synonym was defined that referred
to itself.

Recompiling Invalid Objects

Operations such as upgrades, patches and DDL changes can invalidate schema objects. 
These objects are re-validated by on-demand automatic recompilation if they don't have compilation errors. But it may take a significant time, so it is always better to make them compiled before they are called.

Import fails with IMP0098: Checking integrity of dump file

After the export is finished one should always check if the export dump file is corrupted on thesource machine using imp with "show=y". If getting the errors then the file is corrupted on the source machine.

RMAN: Incomplete Recovery from TAPE to Single Instance

Environment: Windows 2008R2 64bit, backup located at Netbackup (Tape media), DB is RAC one with two nodes on ASM.

Installing TimesTen 11gR2 - Windows

On UNIX, you can install multiple instances of TimesTen. On Windows, you can
install only one instance of any major TimesTen release where a major release is indicated by the first three parts of the release number, such as 11.2.2. For example, you can install both 11.2.1.9.0 and 11.2.2.3.0 on the same Windows computer, but you cannot install both 11.2.2.0.0 and 11.2.2.3.0.

Oracle TimesTen - Intro

TimesTen - What is it? 
 TimesTen is a memory-optimized, relational database management system with persistence and recover ability. Unlike traditional disk-optimized relational databases, all data within a TimesTen database is located in physical memory (RAM), which means no disk I/O is required for any data operation.

Subqueries: Nested & Corelated

Nested Subquery: A subquery is a query with in a query. It is nested in the where or having clause of another query. Subquery is executed first and then its results are provided to the main clause of the main query. 

Installing 11gR2 RAC on Linux

Environment: OS Oracle Linux 5.4 32bit, Oracle 11gR2 (11.2.0.1) 32bit
See the overview

All the installation process already explained in the overview as mentioned above. Here all JPGs are being provided for the Linux which are self explanatory. Wherever any additional information would be required , it will be provided.

11gR2 on Linux: Create Database

Main Post: Installing 11gR2 RAC on Linux

11gR2 on Linux: RDBMS Software Install

Main Post: Installing 11gR2 RAC on Linux

11gR2 on Linux: Oracle Grid Infrastructure Install

Main Post: Installing 11gR2 RAC on Linux

Start the RAC1 and RAC2 virtual machines, login to RAC1 as the oracle user and start the Oracle installer.

11gR2 on Linux: Preparing second VM

Main Post: Installing 11gR2 RAC on Linux 

After fulfilling all the pre-reqs now we will shutdown the node1 (RAC1) and make its clone for Node2 (RAC2)

11gR2 on Linux: Prepare the shared storage/Prereq

Main Post: Installing 11gR2 RAC on Linux 

After installing the basic installation of linux there are certain requirments which need to be fulfilled for successful installation of RAC 11g.

11gR2 on Linux: Installing/configuring vmware tools

Main Post: Installing 11gR2 RAC on Linux

11gR2 on Linux: Installing OS (Linux)

Main Post: Installing 11gR2 RAC on Linux

11gR2 on Linux: Prepare the Virtual Machines

Main Post: Installing 11gR2 RAC on Linux

Two virtual machines will be prepared, first VM "RAC1" will be prepared , OS will be installed on it and then its copy ("RAC2")will be made. After copy the first VM , necessary modification for parameters will be made.