August 2011 Blog Posts (31)

View ALL workflows from ALL users

In most fresh instances you're not able to see all the workflows running on your system if you login with your own username with maybe System Administrator or the Workflow Administrator responsibility. Within the status monitor of Oracle Workflow you are only able to check active or completed workflows owned by yourself - in fact owned by the HR user which is attached to your username.This might be caused due to the fact that user SYSADMIN is the Workflow System Administrator of your…

Added by Cyriel van Schaik on August 31, 2011 at 2:34pm — No Comments

Interview with Kellyn Pot’vin – Rocky Mountain Oracle User Group Director of membership and vendors and Oracle Expert

Kellyn Pot’vin (pronounced Poet-Vaughn) has been a Database Administrator for 11years, specializing in large database performance tuning. In the last year she’s been working with large SSD databases and Exadata, taking advantage of the newest technology and performance tuning features. Kellyn is known for her technical blog, and is the director of membership and vendors for Rocky Mountain Oracle User Group, (RMOUG). She’s performed numerous presentations on… Continue

Added by Wissem EL KHLIFI on August 31, 2011 at 12:42pm — No Comments PSU Oracle Solaris on SPARC (64-bit)

This is how I applied the PSU Oracle Solaris on SPARC (64-bit).

1- Download the latest opatch:

You can follow the MOS ID: 6880880 to download the latest Opatch.

view plaincopy to clipboardprint?

-bash-3.00$ cd $ORACLE_HOME

-bash-3.00$ mv OPatch OPatch.OLD

-bash-3.00$ cp /u01/app/oracle/product/11.2.0/db_1/

-bash-3.00$ unzip

-bash-3.00$ opatch… Continue

Added by Wissem EL KHLIFI on August 31, 2011 at 3:33am — No Comments

Invisible Indexes

My blog post on invisible indexes -







Added by Siba Prasad on August 30, 2011 at 4:46am — No Comments

Creating Datapump files at ASM

2.1. Executing classic impdp&expdp commands when using ASM space would be get the following errors.…


Added by Bugra Canbakal on August 29, 2011 at 4:30pm — No Comments

How to get an overview of your organization hierarchy in EBS

Within Oracle E-Business Suite hierarchies are used a lot. Some examples are the position hierarchy, supervisor hierarchy, expenditure organization hierarchy and the organization hierarchy.

Common functionality which is using hierarchies are the approval workflows, to generate the approval list in the Approval Management Engine (AME) for example. Also data security can be handled by incorporating an organization hierarchy within normal or global security profiles in HR. User John…


Added by Cyriel van Schaik on August 26, 2011 at 8:02am — No Comments

Rollback a previous workplan version in Project Management

After a period of silence due to go lives of the client new articles will follow again. This one about how to rollback to a previous workplan version.When you enabled Workplan versioning on your project or project template you'll get Working versions and Published versions of your workplan. Structural changes and sc...

Read more on my blog at…


Added by Cyriel van Schaik on August 26, 2011 at 7:28am — No Comments

Oracle ASM Cluster File System (ACFS) Nedir?

ASM Cluster Dosya Sistemi ilk olarak Oracle sürümü ile Linux sistemler üzerinde desteklenecek şekilde hizmete girmiş, Oracle sürümü ile Solaris, AIX,HP-UX ve Windows platformlarınada bu destek hizmete girmektedir. Oracle sürümü ile ACFS yapısına replikasyon, etiketleme, şifreleme ve realm tabanlı güvenlik özellikleride ilave edilmiştir.

ACFS sadece ASM volumleri desteklemektedir, ancak ASMLib sürücüleri ile kullanılamaz ve fdisk gibi formatlama araçları ile…


Added by Ugur Inal on August 26, 2011 at 3:13am — No Comments

Simple!!! - Install Grid Infrastructure for standalone server + Database and Create database by SILENT mode

I interested to Install Grid Infrastructure for standalone server + Database and Create database by SILENT mode. So, I just tested it.

Added by Surachart Opun on August 24, 2011 at 5:32am — No Comments

Copy ASM files to file system

You can use the package DBMS_FILE_TRANSFER to copy files from ASM to file system.

In this post, I am going to show you how to do it;

1- Make your ASM datafile Offline:…


Added by Wissem EL KHLIFI on August 24, 2011 at 12:25am — No Comments

Longtime business relocates as industry booms

Interactive Study Systems/CareerSaver makes room for growth


In a move hallmarked by phenomenal growth, Interactive Study Systems / CareerSaver, has relocated to the Gateway Centre in Pinellas Park, Florida. With thousands of clients and training programs covering all of the major vendors and certifications and nine years in the industry; ISS is expanding their business.


The business quickly outgrew the Largo, Florida location as…


Added by Frederick F Dietz on August 23, 2011 at 6:29am — No Comments

Oracle network konfigürasyonun optimizasyonu

Oracle veritabanları büyük ölçekli firmalarda genellikle coğrafik olarak farklı bölgelere dağıtılmıştır, böylece Oracle veritabanları uzmanları için veritabanının network bağlantılarından nasıl etkilendiğinin anlaşılması önemli bir görev olmaktadır. Oracle tarafından sağlanan Transparent Network Substrate(TNS), veritabanları arasında dağıtık bağlantılara izin vermektedir.

Dağıtık işlemlerin performansı bu yazıda yer alan bazı değişiklikler ile arttırılabilecektir. Bu değişiklikler… Continue

Added by Ugur Inal on August 23, 2011 at 3:47am — No Comments

Installing Oracle 10g 32 bit Database on Windows 7/Vista

This video will take you through the steps to install Oracle 10g Release 2 on Windows 7 (Same steps work for Windows Vista). Usually if you install Oracle database on window 7/Vista you would get an error,

Abnormal Program Termination. An internal error has occurred. Please provide the following files to Oracle Support.




Follow the steps shown in this video to successfully install Oracle Database on Windows…


Added by Mithun Ashok on August 21, 2011 at 7:00pm — 1 Comment

Dataloader Library -


I added a Dataloader library to my blog where you're able to download a big selection of dataloader scripts. I'll continue updating the library with new ones as my archive built up during my implementations is quite extensive.

Visit my blog at


Cyriel van Schaik

Added by Cyriel van Schaik on August 20, 2011 at 3:39pm — No Comments

Interview with Fahd Mirza – Oracle ACE and Oracle Expert

Fahd Mirza is an Oracle Certified Professional (OCP) in 11g DBA and 10g DBA He has been working with Oracle products since 2001 including Database Administrator, Application Server Administrator and Oracle RAC Administrator, with proven skills in managing Oracle databases (OLTP and Data warehouse) and Application Servers on Solaris, Linux, HP-UX and Windows Servers. Fahd is an avid blogger and active member on OTN. He is currently working at… Continue

Added by Wissem EL KHLIFI on August 17, 2011 at 4:22am — 2 Comments

Interview with Kai Yu – Oracle ACE Director and Oracle Expert

Kai Yu is a senior engineer and solution architect in Dell Oracle Solutions Engineering Lab .He is working with Oracle Technology as an Oracle DBA, Oracle Apps DBA since 1995. Kai specializes in Oracle RAC, Oracle E-Business Suite and Oracle VM. He has published 15 technical whitepapers and given more than… Continue

Added by Wissem EL KHLIFI on August 17, 2011 at 4:20am — No Comments

Online RAC DBA Training - Instructor lead

Our next batch on Oracle RAC DBA Training is going to commence on 17 September 2011

Why you need to attend this training:-Any one , who wants to start their career as RAC DBA, need to know the basic concept as well as hand-on experience.Otherwise its difficult to get entry and survival in DBA filed.Working professionals RAC DBA have less time apart from busy scheduled. There are still many field, which are untouched in their daily task.

We are providing step by step guidance to… Continue

Added by Nisha on August 16, 2011 at 4:26am — No Comments

Auto-managing an Oracle database: Fix database alerts automatically


With database systems growing, database administrators increasingly have to deal with routine tasks. Small tasks may consume time, resources and increase the cost. Oracle 11g version provides solutions allowing to automatically fix some of those routine tasks.

Oracle 11g provides tools like Data Recovery Advisor DRA (check my article about this tool here:…


Added by Wissem EL KHLIFI on August 15, 2011 at 1:37pm — No Comments

Oracle E-Business Suite Blog -

This blog is featuring information, tips, tricks and everything you want to know of the Oracle E-Business Suite. I'll post experiences I have and things I come across - and also the way to solve possible issues when needed (believe me this will happen :-p)
Visit to read articles on a wide number of aspects and functionality of the Oracle E-Business Suite.

Added by Cyriel van Schaik on August 13, 2011 at 10:30am — No Comments

Oracle AMDU

Oracle AMDU

Added by Bugra Canbakal on August 12, 2011 at 1:29pm — 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