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

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…


Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…


Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…


Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…


Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service