Author Archives: Abhimanyu 'Jay' Jana

About Abhimanyu 'Jay' Jana

Rookie Oracle DBA

Oracle BI Discoverer session limits

Every now and then, Oracle Discoverer (10.1.2) throws a tantrum saying that the “Hard limit on the number of sessions” has been reached. It gets particularly annoying when this happens during the middle of the week and we are left … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

Creating Oracle – SQL Server database link

The idea is to create a Link between a ‘source’ database and a ‘target’ database so that, the client is able to query from the target, without having to configure the additional network connectivity. This is especially useful when there … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Oracle Enterprise Performance System 11 on Solaris – Installation and Configuration

INSTALLATION 1. Download the Installation packages from the Oracle Software Cloud and unzip into a single location. 2. Run installTool.sh 3. Specify the installation directories and proceed to select components to install. Foundation services is mandatory for any of the … Continue reading

Posted in Enterprise Performance Management System, Oracle | Tagged , , , | Leave a comment

Oracle Enterprise Performance System 11 on Solaris – Preparing the System

Detailed information can be obtained from the official Oracle EPM documentation or from the media pack. Installing the latest EPM 11.1.2.2 from Oracle is no biggie, be it Windows or a Unix based OS. The complexity lies in understanding the numerous … Continue reading

Posted in Enterprise Performance Management System, Oracle | Tagged , , , | Leave a comment

Virtualization with Oracle VM Manager

An excellent description of virtualization and the Oracle VM Manager is presented in the Oracle VM Manager User’s Guide: “Virtualization is the ability to run multiple virtual machines on a single piece of hardware. The hardware runs software that enables … Continue reading

Posted in Oracle, Virtualization, VM | Tagged , , | Leave a comment

Oracle Database Installation – Key points

A Summary of key points to be noted in subsequent installations, following a successful installation: Installation Part 1 Installation Part 2 Installation Part 3 For Database Installation on a Virtual Machine Disk, It is recommended to set the Virtual Disk type … Continue reading

Posted in Database, Oracle | Tagged , , , , , | 2 Comments

Oracle Database Installation (Part 3 of 3) – Like a BOSS

Continuing from Oracle Database Installation (Part 2 of 3) The Database Software and the ASM instance have been setup. The final stage post installation is to create and configure a database. CREATE A DATABASE Set the environment variables before invoking the … Continue reading

Posted in Database, Oracle | Tagged , , , | Leave a comment