August 2011 Blog Posts (31)

Online IT Training / e - Learning Courses of SAP, BA, Java, Oracle, QA, Data Warehousing, .net, QTP, SAS etc @ Crescent IT Solutions

Crescent IT Solutions which is a high profiled Training Institute offers you SAP(All Modules),…
Continue

Added by Crescent IT Solutions on August 11, 2011 at 8:53pm — No Comments

11gR2; Silent installation in Oracle Solaris 10

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

Added by Wissem EL KHLIFI on August 11, 2011 at 1:58pm — No Comments

commit for update statements of base table a materialized view taking more time : help required asap

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

Added by Murali Mohan on August 10, 2011 at 6:05am — 3 Comments

Testing RAC Check audit tool

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

Added by Wissem EL KHLIFI on August 8, 2011 at 5:30am — 1 Comment

Interview with Debra Lilley – Oracle ACE Director and UKOUG President

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

Added by Wissem EL KHLIFI on August 8, 2011 at 4:19am — 1 Comment

Monitoring Microsoft SQL Server using Enterprise Manager Grid Control

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

Oracle DUL (Data UnLoader) //Life is DUL without it

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

Interview with Eddie Awad – Oracle ACE Director and Oracle Expert

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

Added by Wissem EL KHLIFI on August 3, 2011 at 10:00am — No Comments

11gR2; Automatic restart of DB Console

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

Added by Wissem EL KHLIFI on August 2, 2011 at 4:19am — No Comments

Interview with Kyle Hailey – Oracle ACE and Oracle Expert

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

Added by Wissem EL KHLIFI on August 1, 2011 at 12:18am — No Comments

Blog Topics by Tags

Monthly Archives

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Notional Pool Setups

Hi All,

I have a requirement to setup a Notional Cash pool setups between pool leader and subaccount,

Please let me know what are the setups required to complete this.

Thanks,

Kishore

Posted by Kishore on September 14, 2014 at 11:00pm

Join cases between related tables in data computing and analytics

Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds ofrelated computing can be easily implemented. In the discussion below, we will introduce the join operations with some examples using the table emp and table sOrder.

Table structure:

The table emp stores the employee data table, in which the…

Continue

Posted by Jim King on August 25, 2014 at 1:35am

Oracle RAC Classes

Contact me for Oracle High Availability Training / Online Classes - Dubai shans.dba@gmail.com

Posted by Shanmugam on August 18, 2014 at 1:00am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service