Oracle Fusion Middleware 11gR1 Deployment

Steps for installation of Oracle Fusion Middleware 11gR1 on Vista machines

In this screencast we will walk you through the steps on installtion of Oracle Fusion Middleware 11g on a Vista Machine. Go to the following link
http://www.oracle.com/technology/software/products/middleware/index.html and Download the Net Installer.

Watch the screencast and get an instance of Fusion Middleware running on your machine for our upcoming screencasts on Fusion Middleware.

PLSQL Tuning - Fundamentals I

PLSQL Tuning Fundamentals

To understand PLSQL Tuning we need to get a nice hold of the Oracle database architecture. Fundamentally Oracle database comprises of a database and instance. The database can be further trimmed down to the physical structures and the memory structures of the database. Since this section is more on PL/SQL tuning lets have a quick run through the  components of the database phycical structures and the memory structures.

Physical structure compirses of the following components

Data files that hold the data

Control files that store configuration related information

Redo log files that stores information pertaining to Database recovery

Instance Parameter files that are used to control the various parameters of the memory  structures

Password files that hold critical users password

Memory structure comprises of the following components

SGA - Shared Global Area - A collection of pools shared by all server and background process

PGA - Program Global Area  used mainly for each server and background process. There is one PGA for each server process.

Service Oriented Architeture - Basics

In plain English SOA is an interaction mechanism for services to talk to each other using a standards based approach. In the recent years SOA has become the mantra for major companies. Lets have a fundamental look at what is SOA and how it can shape the future of web enabled services.  

To understand SOA lets go a little bit more in detail. Lets define the terms that make up SOA

• Service : A service is noting but a well defined process that performs a business function 
• Web Service: A reusable software component that communicates using standards based protocol for information exchange. The following are couple of the standards based protocols  - SOAP(Simple Object Access protocol), WSDL(Web Services Definitional Language), UDDI (Universal Description, discovery and integration)
• Composite Application: Any application that combines services and systems are termed composite applications.
• BPEL4WS: XML language that defines the business processes and its executed by a BPEL processing engine. 
• JMS: Java Message service is used for asynchronous message communications between clients

Managing Oracle on Linux - Part I for DBA's

Oracle Enterprise Linux is a Linux distribution provided by Oracle to streamline the deployment of Oracle products on a Linux environment.  Any Linux distribution will contain the following 2 mandatory core - The Kernel and the packages.

How to Install Linux?

Please refer to the following screencast on how to have a quick up and running Linux environment. This screencast is mainly focused on Ubuntu version of Linux. The Enterprise Linux version screencast will be uploaded very soon.

Linux Kernel

The Kernel is the core of any Linux operations system. The Kernel loads during boot time and is in memory until the system is restarted.The Linux Kernel handles most of the system calls related to memory,process handling etc. Oracle Enterpirse Linux uname -r tells us the kernel release number. Kernel's are classified furthur as Tanited and UnTainted kernels. A kernel thats not modifed from its source form is called a Untainted kernel and any modifications done to the kernel from its original source is called a Tainted kernel