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

Join and Union examples of related tables to show different SQL and esProc syntax

Join multiple tables with “join”

The SQL…

Continue

Posted by Jim King on October 15, 2014 at 12:02am

profiles in Oracle DBA

I've one question it is related to Oracle DBA, I've just read about password settings in profiles concept, i'm little bit confusing on PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME, and I understand something about these two topics. I updating here what i'm understand when I was reading about this, so tell me is it right or wrong.

1) PASSWORD_REUSE_MAX: This setting is used for reusing of old passwords. The functionality of this setting is restricts reusing of old password for…

Continue

Posted by Bhagya Raj Katta on October 10, 2014 at 7:21am

Dynamic Performance views-what are they?

A little bit about how exactly Oracle retrieves the information from Dynamic performance views. Read more here : http://suntrupth.blogspot.in/2014/10/dynamic-performance-views-what-are-they.html

Posted by Suntrupth Yadav on October 9, 2014 at 9:30am

Oracle Masters?

Where can I ask my Oracle / PlSQL related doubts from masters ?

Posted by Mohammed on September 24, 2014 at 6:07pm

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service