October 2011 Blog Posts (18)

Which one is better;Getting a DB in an area or different DB in diff states

WHICH ONE IS BETTER ? To Get a DB in an area or different DB in diff states, as in 1 central DB for a big organisation or getting different DB for the different cities for that same company and in the same country. I really need a convincing advice/comment....

Added by Caesar Oladipo Komolafe on October 25, 2011 at 2:33pm — No Comments

Reconfigure Database Control in RAC environment using EMCA



We have a Real Application Cluster 11gR2 environment running in 7 nodes Oracle Clusterware. We need to reconfigure the database control to manage the whole cluster nodes. The idea is to reconfigure the DB Control to run on the node number 3 of the cluster and having the EM agents running on the remaining nodes of the cluster. In this post, I will share with you the correct procedure to do it.


1. Ensure…


Added by Wissem EL KHLIFI on October 25, 2011 at 5:10am — No Comments

Auto DOP: Differences of parallel_degree_policy=auto/limited

Recently, I delivered a Seminar about Parallel Processing in 11g where I came across some interesting findings, that I’d like to share with the Oracle Community:


Added by Uwe Hesse on October 19, 2011 at 4:57am — No Comments

Online Oracle CORE DBA Training - 22 Oct 2011.

Our online Core DBA Training is mostly hands-on based. It will help candidates to learn Oracle 10g Database Architecture and day-to-day activities of a DBA such as Database installation, backup & recovery, troubleshooting performance issues.

We give special care to every trainee to complete the hands-on lab exercises on each topic. Extra topics on Linux is also covered to help trainees get comfortable with Linux.

Live demo to every concept is provided as part of weekend…


Added by Focusthread Ltd on October 17, 2011 at 6:05am — No Comments

RAC 11gR2; How do I troubleshoot my clusterware startup issue?

We have found one of our Cluster 7 nodes environment down and we can’t bring it up again.


-bash-3.2$ crsctl status res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.



[root@srvdd01 ~]# cd /opt/11.2.0/grid/bin/

[root@srvdd01 bin]# ./crsctl start cluster

CRS-5702: Resource 'ora.evmd' is already running on 'srvdd01'



Added by Wissem EL KHLIFI on October 16, 2011 at 3:46am — No Comments

Oracle sql*plus

How to retrieve those names which has underscore character like Ali_khan in ename column

Added by Asadullah fazli on October 16, 2011 at 12:47am — 3 Comments

Online OBIEE Training--Instructor lead

Hi All,
Greetings from TutorsOnInternet.…

Added by Nisha on October 15, 2011 at 7:30am — No Comments

Oracle database and copy database server/WIN or UX


my oracle 9i database is running on a Windows server and I intend to duplicate these windows server.

my question: would the Oracle database on the new server (copy) also work?

Can I immediately start the database after the copy operation of windows?

I have the same questions: If I copy a unix server, can someone help me?



Added by Kazem Salmanian on October 14, 2011 at 3:56am — No Comments

Synchronize Email Address between User and HR Employee

Whenever you change the email address of a HR Employee record you will notice that this change in the email address is not reflected within the user account. For example for the below employee I changed the email address through a correction update in HR.…


Added by Cyriel van Schaik on October 12, 2011 at 12:43am — No Comments

Online Unix/Linux Training-Instructor lead

Greetings from TutorsOnInternet.

Our next batch on… Continue

Added by Nisha on October 10, 2011 at 11:04am — No Comments

11gR2 Clusterware de-installation procedure



Clusterware de-installation can be made in the case you want to rebuilt your entire cluster or simply convert your RAC database to a single instance database.

The procedure is straightforward and can be accomplished in a few minutes.

In the following example, we have 7 node cluster running. Each node has its own grid infrastructure home and oracle database home.


1- First Stop all databases and…


Added by Wissem EL KHLIFI on October 10, 2011 at 12:40am — No Comments

ask to connection oracle

saya ingin mencoba melakukan koneksi oracle di server dengan putty yg saya lakukan adalah sebagai berikut

1. saya masuk sebagai user oracle yaitu dengan su oracle

2.[oracle@dbo1 root]$ . oraenv

ORACLE_SID = [orcl] ? orcl

ORACLE_HOME = [/home/oracle] ?

pertanyaannya apa yg harus saya isi pada ORACLE_HOME,

mohon pencerahannya dunk para master oracle

saya cb dari website ini…


Added by didik prasetyo on October 9, 2011 at 8:32pm — No Comments

Extract Full HR Location Info Through SQL

It's time for a little bit of SQL again. In the past I needed a little dump of all the HR Locations which were defined in the system. This dump needed all the information that is recorded with such a location.

So information whether the location is local or global, the name, full address details including the used address style, shipping details and the ship-to location and the inventory and edi location from the Other Details tab. Finally the...

Read more at…


Added by Cyriel van Schaik on October 9, 2011 at 12:35pm — No Comments

Online OBIEE Training--Instructor lead

Hi All,
Greetings from TutorsOnInternet.…

Added by Nisha on October 8, 2011 at 7:40am — No Comments

Responsibility not visible in Administer Folders in Forms

Within the instances I'm working on at the moment we're implementing Oracle Project Management and a number of related applications from Oracle E-Business Suite like Oracle Project Resource Management and Oracle Time and Labour.

For a new requirement we wanted to use the Pre-Approved Batches option within Oracle Projects. As you might know Pre-Approved Batches are used to enter directly expenditures on a project. These expenditures can be timecard related but also miscellaneous…


Added by Cyriel van Schaik on October 6, 2011 at 7:12am — No Comments

11gR2; AWR Reports in RAC

1- AWR Concept:

In this post, I am going to show you how to generate AWR reports for Real Application Clusters (RAC) environment.

AWR was first introduced in 10g version of Oracle as a repository of all important statistics for an Oracle database. At a regular intervals, Oracle makes a snapshots of those vital statistics and stores them in SYSAUX tablespace. In 11g version, These snapshots are retained for 8 days. It is the MMON background process who is…


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

Finished a book on Oracle and MySQL

Looking forward to meeting old and new friends at OOW11. If you want to stop by, I'm in the bookstore at Moscone North on Monday and Wednesday at 9 a.m. for a book signing.

Added by Michael McLaughlin on October 1, 2011 at 7:42pm — No Comments

Monthly Archives











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



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