November 2011 Blog Posts (10)

Manually Clear Alerts in Oracle Enterprise Manager 11g

In our 11gR2 RAC databse, we got some ORA-00600 errors in the alert log file. These errors have been fixed by applying the oracle patches. But, in the Oracle Enterprise Manager these old alerts are not cleared. To manually clear the alerts, I did the following steps;

1. Go to Enterprise Manager Home Page > select Instance Name > Metrics and policy settings > changed the view to all metrics > Choose the “Generic Internal Error” metric to disable it.

Follow the links…


Added by Wissem EL KHLIFI on November 25, 2011 at 11:30am — No Comments

Apex Interactive Report

Dear Team,

Problem statement :  I created a interactive Sql Report with Filter option.  The issue is when a data is filtered and returned back to the main application and again when visiting the same page, the filtered value is being retained.  i want the filter to be removed when i go back to the previous page.  I tried Apex Util.clear Page etc....Kindly help

Added by Rajesh Venkataramani on November 22, 2011 at 4:16am — 1 Comment

Need Oracle WMS Consultant -- Plainsboro, NJ - 4 Months

Hello Friends,

Please check the below requirement and send your resume. Thank You.


Title: Oracle WMS Consultant

Duration: 4 months

Location: Plainsboro, NJ

Start date: ASAP



Added by Prasad Varma on November 21, 2011 at 12:25pm — No Comments

Oracle ERP development training

I am a mechanical Engineer. I have worked as a Maintenance Engineer and have used Oracle ERP. Now I am working as a sales Manager in an Non IT MNC in India. I want to get a training in ERP, to get a job in IT sector in which I can utilize my previous expereience too.
So, can any one give me any suggestions in this regard. What could be the typical salary structure for such a role in India.

Added by Ricky on November 19, 2011 at 11:34pm — No Comments

See & modify the attributes of Oracle Restart resources with crsctl

I am presently teaching 11gR2 New Features for DBAs on a Private Event, where one attendee asked how we could retrieve and possibly modify the restart attempts, ohasd is trying for a resource, governed by Oracle Restart:

Added by Uwe Hesse on November 10, 2011 at 7:14am — No Comments

11gR2; Silent Installation for Oracle Grid Infrastructure for a Cluster


These last months, I have installed many Oracle RAC environments. This is good thing, but using the OUI installer prevents me to do other tasks in parallel since I have to enter values, go manually from one installer screen to another. To make the installation process easier, fast and avoid mistakes I adopted the silent installation solution. I have searched on the net and unfortunately I didn’t found any detailed available and free article to…


Added by Wissem EL KHLIFI on November 9, 2011 at 10:22am — No Comments

5000 pageviews - Oracle E-Business Suite Blog

5000 views of the Oracle E-Business Suite Blog have been recorded from a very big number of countries around the world.

The top countries are:

1) United States
2) The Netherlands

Read more at Oracle EBS APPS Blog

Added by Cyriel van Schaik on November 7, 2011 at 8:10am — No Comments

SQL to Check for Locked User Accounts

In our instance we're not using the seeded delivered password policies which can be activated by setting some profiles but we have a Java class in place describing a custom password policy. I blogged this in a earlier post: Signon Password Policies.

With a more secured password policy it might also happen that users forget their password and when using profile option Signon Password Failure Limit…


Added by Cyriel van Schaik on November 4, 2011 at 1:29am — No Comments

Need some project ideas

Hi ther,

At the moemnt i am looking for some ideas with respect to TSPITR and Orcale total recall.Is ther any way these two features of oracle  are related.can some one suggest me with good idea to carry out the research in which i can make use of both these concepts of 11g.


any other ideas for dissertations are wellcome.

Added by aleem on November 3, 2011 at 10:37am — No Comments

SQL to Monitor Application Logins

When an implementation of Oracle E-Business Suite goes live you might want to monitor the use of the system to see if, for example, users logged in. We had this requirement.

Find the below SQL I created for your...

Read more at Oracle EBS APPS Blog

Added by Cyriel van Schaik on November 2, 2011 at 6:02am — No Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on 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



Blog Posts

Suntec’s Data Mining Services Help You Get Efficient Data

It is a well- established fact that the availability of accurate and updated data is the base of undertaking successful business operations. Data is required at all point of business operations ranging from buying of goods and services from suppliers to marketing your final product. Often, business organizations fail to utilize their data to its full potential.

At SunTec, our…


Posted by Alvaro Dee on May 26, 2017 at 3:46am

Convert Prospects into Repeat Customers with Amazon Data Entry Services

eCommerce store owners get a better exposure for their products by selling on a platform like Amazon. If you are thinking about selling on Amazon or you are already a seller who needs help in managing product listings on this popular online marketplace, stop worrying. Professionals with sound technical knowledge of Amazon product listings, categorization, content, etc. are there to make things easier for you.

You can outsource …


Posted by Alvaro Dee on April 12, 2017 at 10:05pm

Increase Sales with Unique and Compelling Product Descriptions

Are you thinking about opening an online store? Or, do you already have one? Whether you have a small online business or a big store, the manner in which you list your products leads to a dramatic impact on your sales.

Don’t just sell a product, you need to sell an experience.
You yourself get excited about the features and specifications of your products. But the problem is that your…


Posted by Alvaro Dee on April 10, 2017 at 11:18pm

Business Research Helps You Understand Critical Traits of Your Business

Business organization needs strong customer and actionable industry insights to develop better understanding of its market and other important aspects. It can meet business objectives and make tactical, strategic and operational decisions with the help of business research services. The growth of a company largely depends on effective business research. You can conduct a successful market research with…


Posted by Alvaro Dee on April 3, 2017 at 3:23am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service