Tag: Oracle ACE

How to add storage to ESXI 5.5

Posted on by Osama Mustafa in Others
in this post i will show you how to add New Storage to ESXI 5.5 using vsphere client follow the screenshot :-

  1. Login to Vsphere client
  2. Select the host and then choose the Configuration tab –> Storage. like below


  • Storage Type :-

  • Which Storage you want add :-
  • VMFS-3 For our case

  • Storage Name

  • maximum file size and capacity of the database.

  • Press Finish
  • Summary 

Cheers
osama mustafa

Unable to Ping ESXI 5.5 Host

Posted on by Osama Mustafa in Others
while i am continue working on my  Lab and configure ESXI i faced another problem and took 2 days to solve it maybe someone faced this issue but this will help other people as well.

The problem description like this :- after assigned IP to the server i want like normal people connect to this server using my laptop but simply when trying to ping :-

“Detestation unreachable” 

I thought at first it was my network card issue and maybe it’s not supported By ESXI, But this is not valid option because the weirdest part in this issue was when restart the server and ESXI loading the services i was able to ping without any problem then the message appeared again.

as you see from the above screenshoot ping then not ping !!!!!
The solution very simple i start missing with BIOS options and found new option there called “Network Stack” all you have to do is enable this option and link to IPV4.
Cheers
Osama Mustafa

2014 Achievement as an Oracle ACE

Posted on by Osama Mustafa in News
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.
Cheers
Osama Mustafa

TT6003: Lock request denied because of time-out

Posted on by Osama Mustafa in Database
Trying to create cache group lead to the below error :-

java.sql.SQLException: [TimesTen][TimesTen 11.2.1.4.0 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.

Cheers

Osama …

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

Posted on by Osama Mustafa in Database
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
AM
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

Cheers

Osama ….

Cannot Integrated JDeveloper with SOA Server

Posted on by Osama Mustafa in Application
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.

Cheers
Osama Mustafa

OWB GUI Is Slow

Posted on by Osama Mustafa in Application
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

Or

    • 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.

Cheers.

Osama Mustafa

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

Posted on by Osama Mustafa in Fusion Middleware

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

Posted on by Osama Mustafa in Fusion Middleware
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