Monday, February 1, 2016

[INS-21003] Installer has detected that an invalid inventory pointer location file was specifie



This error appear while trying to install oracle database 12c on Linux 64bit to solve it i forgot to add the group on oraInst.loc

vi /etc/oraInst.loc
and add the below line :-

inst_group=dba ( depend on your group).

Thanks
osama


Thursday, January 28, 2016

Check EBS Version

This post is very short just to describe how to Check EBS version in case of upgrade :-

Application Release :-

Using Apps User.


SQL> select release_name from apps.fnd_product_groups;


RELEASE_NAME
————————————————–
12.2.2 


Done
Thanks  

Saturday, January 23, 2016

JspCompile.pl Hangs after upgrading to EBS R12.2.4 Any idea ?

Let me tell you what is going on here , maybe you have some idea that can help, the scenario like the following :-

I installed Oracle E-business suite on Linux 64bit Operating system version 6.7 without any issue and the EBS version was R12.2.0 and the default database version which is 11.2.0.3.

But i choose to upgrade to EBS R12.2.4 and Oracle database 12c both done without any issues or even small error in the logs , auto config done successfully without any issue as well, the application started without any single error.

But when trying to access to the EBS application Link

I tried to compile the JSP but :-

[oracle@ammebs scripts]$ tail -f /u01/oracle/tbdlamm/fs_ne/EBSapps/log/adop/16/apply_20160114_142741/20518047/log/u20518047.log
enumerating jsps...7829
updating dependency...6473
parsing jsp...6473
writing deplist...7829
initializing compilation:
eliminating children...5954 (-1875)
searching uncompiled...5682 (2253 were stale)
translating and compiling:
searching untranslated...5622 (3369 were stale)
translating jsps... 85% complete: 4800/5622 ETA: 53s
translating jsps...5622/5622 in 7m31s
compiling jsps... 


The Logs shows only this error :-

[213441] !!SEVERE WARNING!! TIMEOUT[600 seconds] EXPIRED DURING COMPILATION  


I increased the apache timeout in the context file for nothing .

When access the EBS Application Link :-

From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found

The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.

If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address. 
I opened SR and now it's 45  days without any solution !!!!

Any idea

Thank you guys :)
Osama

Friday, January 15, 2016

IOUG it's Happening Again

One of the best Oracle Conference in the world , Best oracle speakers around the world in One place, meet them and join them learn from the best to do this you should join and attend IOUG COLLABORATE 16 Here.


I will speaking About Fusion middleware Join me, i hope to see you there inchallah :)

Thanks
Osama



Wednesday, January 13, 2016

OUGN16 : ORACLE USER GROUP NORWAY



I will be present at ORACLE USER GROUP NORWAY  This year Inchallah About Fusion middleware :)

See you there guys
Osama

Wednesday, December 30, 2015

ORA-12054 while trying to create materialized view with sysdate

while trying to configure materialized view with sysdate today , Fast Refresh on commit , i received the following error :-

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view.

Regarding to Oracle Documentation there is some restriction should be considered while trying to create materialized view Check Here  or here.


But there is always workaround,

1- i create dummy table contain 1 row with 1 column only contains sysdate.
2- create Job that this sysdata on daily basis.
3- call this column in where condition of materialized view.


Problem solved.

Thanks
Osama

Friday, December 25, 2015

2015 Brief, The last Post of the year

Merry Christmas and Happy Holiday everyone.

2015 is almost done and the doors will be closed soon, and start the new year 2016 within 5 days only, I would like to thank everyone here , Family , Friends and my blog readers who keep me motivated always to write new articles when i can, and special thanks to my mother.

i learnt a lot of things this years, sadness moment gives me experience and the happiness teach me and show me who is my real friends, i met new people around the worlds make new friends, discuss different topics with people, one of the biggest achievement for me this year to be Oracle ACE Director a dream come true, when i remember this moment i also remember my friends who nominate me because without them it will not be possible Gurcan OrhanHeli Helskyaho, Jeff Smith , Tim Hallkamran agayevIloon Ellen-Wolff, Kai Yu, and Tariq Farooq , and i would like to take this opportunity to thanks Oracle ACE program who make it real for me and for the biggest effort they provide it to us.


So let me summarize the 2015 :-


  • The first Oracle ACE Director in the Middle-east.
  • Director and CEO for Jordan Amman Oracle User Group.
  • Speaker in JAOUG.
  • Speaker in OTN MENA Tour.
  • Speaker in Bulgarian Group - Summer.
  • Speaker in Bulgarian Group - Winter.
  • Speaker in Oracle Open World 2015.
  • Organizing the first event Of  JAOUG. 
  • Working on my 2nd book.
  • Wrote more than 10 articles for different  International magazine.
  • attend my 2nd Oracle open world as speaker and first time as Oracle ACE Director.
  • Speaker in the last conference of the year in UK.
  • Implement one of the biggest oracle engineer system project : Exalytics, Exalogic and Exadata.
if i missed anything then i am sorry :) 


Thank you again.
Enjoy your holiday :) 
Osama