2014 Achievement as an Oracle ACE

2014 is almost finished , new year will starting soon usually i don’t list what i have done, but there is always start point for everything. it was very busy year on all level : Personal, Work and as oracle ACE.

One of the major achievement for me this year is created and lead Jordan Amman Oracle User group which is the first Oracle Group in Jordan and I am working now to organize next event for this group and this is taking most of time now.

The 2014 Summary :-

Let’s Start with Conference :-

  • Dublin Conference.
  • Dubai Conference.
  • OTN Mena Tour.
  • Dublin Again 🙂 
  • Oracle open World.
  • New Zealand.
Sure during most of these conferences i was organizing RAC ATTACK Event around the world and simply it successful year for this amazing event.
Don’t forget the webinar as well. 
I have to mention One of the most amazing event all the time which is oracle open world, This is was my first time in SF OOW I met most of the people in oracle community i will try to mention all of them but i am sorry if i forgot someone :-
  • Gurcan Orhan
  • Yury Velikanov
  • Kai Yu
  • Jeff Smith 
  • Kellyn PotVin-Gorman.
  • Danny Bryant
  • Don Seiler.
  • Steve karam
  • Sarah Craynon Zumbrum
  • Leighton Nelson
  • René Antúnez Berdejo ( i met twice this year ) .
  • Francisco Munoz ( i met him in NZ ).
And Sure other People , my first time in OOW was my first time to present in this Big Event I would like to thank Debra Lilley to give me this chance 🙂
I also enjoyed my time with best company Gurcan Orhan He is amazing person and would like to meet him again who knows next conference or maybe in Turkey.
i enjoyed my time hanging out with ACE and ACED, a lot of activity to do in OOW such as presentation, Concert .. etc.
don’t forgot this year i wrote three articles to different magazine and i still have a lot of different topics to share, My Blog  i wrote blog post related to fusion middleware and Timesten in memory database most of these article what i faced in my real life challenging but amazing at the same time.
i was the first one in the middle east ( Jordan ) who appeared in Oracle Magazine Peer to Peer Thanks for Oracle ACE program i am really proud to be member of this amazing community.
I created magazine on flip-board that collect all the good articles posted by oracle community and share under one place and i am contribute in another one  Thanks for my friend Leighton Nelson.
the both magazine are simply amazing both sharing different idea.
I also passed Fusion middleware exam and upgrade my OCP certification. 
Finally I am really proud of one of the most achievement for this year which is created JAOUG ( Jordan Amman Oracle user group) i am working too hard to make this group success, i would like to give special thanks to Heli Helskyaho who supported me and gave me an idea to launch the group when i was in OOW.
i am sure 2015 will bring new things to me, 2014 was amazing year and fun at the same time. “Enshalla” 2015 will be more interesting i welcome any new challenge.
Osama Mustafa

Fusion Middleware Attack

New Idea, New Concept It’s always nice to learn something new in next event, this time i create new attack called Oracle Fusion middleware attack or Short name “OFM ATTACK” that allow people to interact and learn more about oracle fusion middleware.

if you are interseted in this attack please contact me by leaving comment ” Your name and Email Address” and i will contact you back to volunteer in this attack,

Thank You

osama mustafa

Linux : Cannot Access …. Input/output error

/bin/ls: reading directory .: Input/output error
total 0

The above error indicate that i cannot access to the specific file on Linux, Delete not working. with root user as well.
so the error is not a problem to delete files, it’s a problem about the file system itself and/or an hardware problem, but before announce that it’s hardware issue 🙂 try the below solution :-

 Option #1:-

use command dmesg.

(display message or driver message) is a command on most Linux- and Unix-based operating systems that prints the message buffer of the kernel. Read about that command here

Option #2 ( worked for me)

Use Fsck command to detect filesystem error and fix it.

How !!!

  1.  First Umount File system ( that file located ). Using Umount command if it’s not able to un mount the file system use lsof command or fuser to check which user using this filesystem.
  2. run the fsck -y /dev/…………….. 
  3. mount file system again.
Fsck Command here
Osama …

TT6003: Lock request denied because of time-out

Trying to create cache group lead to the below error :-

java.sql.SQLException: [TimesTen][TimesTen ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out
Details: Tran 143.23106 (pid 19946) wants Sn lock on rowid BMUFVUAAAAxogAALDp, table SUBSCRIBER. But tran 144.67398 (pid 19946) has it in Xn (request was Xn). Holder SQL (select ID,identifierType,identifiervalue,subscriberId,groupName,siid from subscriptionidentifie…) — file “tindex.c”, lineno 4277, procedure “sbTixNext()”

After check the Timesten parameter found the issue was with LockWait

Lockwait :- Allows an application to configure the lock wait interval for the connection.

LockWait may be set to any value between 0 and 1,000,000 inclusive to a precision of
tenths of a second. The default is 10 seconds.

Actual lock wait response time is imprecise and may be exceeded by up to one tenth of
a second, due to the scheduling of the agent that detects timeouts. This imprecision
does not apply to zero second timeouts, which are always reported immediately.


Osama …

Attempt to connect to a data store that has been manually unloaded from R AM

Timesten in-memory Database :-

ttisql DSN_NAME

ttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.
Type ? or “help” for help, type “exit” to quit ttIsql.
All commands must end with a semicolon character.
connect “DSN=DSN_NAME”;
707: Attempt to connect to a data store that has been manually unloaded from R

The command failed.

This should be easy to resolve. A TimesTen datastore (physical database), which is what a DSN points at, has a property called its ‘ramPolicy’ The default value for this is inUse which means that TimesTen will load the datastore into memory whenever it is being used.

Solution :

ttAdmin -ramload DSN_NAME

Reference :-
1- Oracle OTN Forum here


Osama ….

Cannot Integrated JDeveloper with SOA Server

When trying to integrated JDeveloper with SOA server the below error Appeared :-

Testing JSR-160 Runtime … failed.
Cannot establish connection.
Testing JSR-160 DomainRuntime … skipped.
Testing JSR-88 … skipped.
Testing JSR-88-LOCAL … skipped.
Testing JNDI … skipped.
Testing JSR-160 Edit … skipped.
Testing HTTP … success.
Testing Server MBeans Model … skipped.

all my searching on internet not working most of the blogs indicate it’s proxy setting which is already disables in my case.

After invesgtation and check logs on the both side adminserver and Jdeveloper i found it’s DNS server issue therefore i edited hosts in windows like the below

Adminserver-IP   Hostname

After do this and put hostname instead of IP it’s worked Successfully.

Osama Mustafa


Sometimes the default setting is not enough , therefore you need to apply some changes depend on your requirement and the work load. Today while working on OWB I faced huge slowness while open , mapping or even press any button.

to solve this issue all you have to do increasing JVM, to do this follow the below steps :-

  • Depend on OS, Open the following File :- 
    • Windows :- C:\oracle\product\owb11_1\owb\bin\win32\owbclient.bat


    • Linux : $ORACLE_HOME/owb11_1\owb\bin\win32\owbclient.bat.

This file will indicate to setownenv.sh or setowbenv.bat usually in the same path. Open it with any editor.

be careful while adding this file  If you notice or read this file there is more than one line looking the same, these lines only depend on OS for example in my case i am working on LINUX then i have to add Line that indicate for Linux only.

Next to the line -d64 add new parameter -Xmx=1024M or depend on your work.

Restart OWB now.


Osama Mustafa

Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

This Error Appeared on Weblogic Depend on Managed Server, Tuning Connection Pool By Increasing Maximum Capacity parameter in Datasource.

My Case Datasource EDNLOCALTXDatasource as the above error.

Solution :-

Increase depend on your application.
Thank you 
Osama Mustafa

Oracle SOA Tablespace Is full

When Creating Domain for Oracle SOA it’s Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.

But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it’s strange case and not acceptable.

after investigation Table Called “REFERENCE_INSTANCE” include information about Running Composite in SOA ans instances. the size for this table 18GB.

Select * from Reference_instance; 

Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.

Thank you
Osama Mustafa