Added by Crescent IT Solutions on August 11, 2011 at 8:53pm — No Comments
In this step by step document, I am going to show you how to install Oracle 11gR2 (126.96.36.199) 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
Added by Wissem EL KHLIFI on August 11, 2011 at 1:58pm — No Comments
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,
Post written in 3 languages: English, French and Spanish.
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…
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
Added by Gökhan Atıl on August 7, 2011 at 2:35pm — No Comments
When there is no other option to recover database, there is a great oracle internal program which naame is Oracle DUL (…Continue
Added by Bugra Canbakal on August 7, 2011 at 2:30pm — No Comments
Added by Satishbabu Gunukula on August 3, 2011 at 12:32pm — No Comments
Added by Wissem EL KHLIFI on August 3, 2011 at 10:00am — No Comments
I have written this article, in 3 different languages: English, Spanish and French.
Extract en English;
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…
Added by Wissem EL KHLIFI on August 2, 2011 at 4:19am — No Comments
Added by Wissem EL KHLIFI on August 1, 2011 at 12:18am — No Comments