August 2011 Blog Posts (31)

Continue

1- Introduction:

In this step by step document, I am going to show you how to install Oracle 11gR2 (11.2.0.1) using the silent technique.

This document makes easier the installation; you should only change the directories to reflect your environment setup.

 

2- Prepare the environment;

In this section, we are going to prepare the system users and groups as well as the system parameters.

Create the dba group:…

Continue

We are  using the following materialized view on trans@dev

 

***********************************************************

 

CREATE MATERIALIZED VIEW int_recon_mat_view( COUNTRY,

BRANCH, ACCOUNT_CCY, ACCOUNT_ID, ACCOUNT_NAME,

CATEGORY, APA_CODE, BATCH_NUMBER, DR_CR_IND,

HOST_SYSTEM_ID, HOST_TXN_CODE, LEDGER_DATE, LOCAL_CCY_LEDGER_AMOUNT,

ORIG_CCY_LEDGER_AMOUNT, TICKET_NUMBER, VALUE_DATE, CONTRACT_TYPE,

RECON_REFERENCE,…

Continue

Post written in 3 languages: English, French and Spanish.

 

Introduction:

RACcheck is a tool developed by Oracle to audit your RAC and clusterware configurations.

It gives suggestions and advices to modify your RAC Configuration to fit the Oracle best practices.

This tool checks the settings of the following configurations;

– OS kernel parameters, OS packages and OS settings

– CRS/Grid Infrastructure

– RDBMS ; memory and…

Continue

Debra Lilley is Oracle Alliance Director for Fujitsu, she has worked with Oracle applications since 1996 (EBS 9.4.1) as Support Manager, Functional Consultant, Discoverer and then BI lead. Her role is now about strategy and education of both Fujitsu people and customers. She is President of UKOUG and Chairman of the Product Development Committee at the IOUC. She was User Group Evangelist of the Year in 2008.…

Continue

The Enterprise Manager offers several system monitoring plug-ins for third-party products. One of them is Microsoft SQL Server Plug-in. This plug-in supports Standard, Enterprise, and Workgroup editions of Microsoft SQL Server 2000, Microsoft SQL Server 2005, and Microsoft SQL Server 2008 (both 32 and 64bits).

 

I've wrote about how to monitor SQL Server using EM Grid Control. Read more: http://bit.ly/rnuYWK

 

 

When there is no other option to recover database, there is a great oracle internal program which naame is Oracle DUL (…

Continue

http://www.oracleracexpert.com/2010/08/how-to-find-master-node-in-oracle-rac.html

Eddie was introduced to Oracle in 1994. Since then, he has been developing software applications using Oracle databases and tools. In addition to his blog (http://awads.net/wp/) in which he shares his Oracle related experiences, news, views, tips and tricks, Eddie created the Oracle News Aggregator (http://orana.info/), a site that allows readers to monitor Oracle related blogs and news sources,… Continue

I have written this article, in 3 different languages: English, Spanish and French.

 

Extract en English;

 

Introduction:

 

Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources.

Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts.

These components can be…

Continue

Kyle Hailey has worked in the IT industry for 15 years and has been with Oracle for over 13 years. At Oracle he has worked in support, porting, benchmarking, and kernel development and has created tools to improve high-end performance monitoring such as direct SGA attach and interactive graphic displays of performance data. He has made major contributions to the redesign of the Oracle Enterprise Manager 10g by designing performance pages to be graphically oriented and wait-interface centric.… Continue