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

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service