BLOG

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

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

ORA-12054 while trying to create materialized view with sysdate

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

2015 Brief, The last Post of the year

Posted on by Osama Mustafa in News
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 Orhan, Heli Helskyaho, Jeff Smith , Tim Hall, kamran agayev, Iloon 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

Import hangs On index level.

Posted on by Osama Mustafa in Database
Today some customer contact me complaining that they are trying to sync the development with UAT, when i check the issue everything was normal for the first time, but the alert logs indicate that database could complete the checkpoint.

so this what i did to make the import faster ( which i completed it as well ) :-

  • Change database to no archive mode.
  • increase sga_target temporary.
  • use parallel command depend on cpu core.
  • Use commit=N with import parameters.
  • you can exclude indexes by exclude=indexes but i don’t prefer this at all.
  • increase db_cache_size.
This simple steps that could help someone to make import little faster or solve hang issue.
let me know if you need anything 🙂
Cheers
Merry Christmas guys 
Osama

BGOUG Autumn Conference – Extraordinary trip

Posted on by Osama Mustafa in News
it’s 19-Nov-2015 and this day means that i should start packing and prepare myself for traveling to Bulgaria, at first everything was normal and i thought it will be like any other trip i did before.

since there is no direct flight to Bulgaria then i should landed in Frankfurt first then to Sofia as most of you know i don’t like early flight despite i am waking all the night working or replying some emails but it’s something i don’t like to do 🙂 anyway my flight was at 3:00 am from Jordan i did boarding thing and visa & security Check after 6 hours i landed in Germany,drink coffee in the airport and ran to my next flight Sofia.

When i landed in Sofia it was 1:30 pm exactly, so like any other airport i should pass by immigration officer & this is what happened :-

Me :- Hi, Good afternoon.
officer : Hi, your passport please.
Me ; Sure.
Officer “Scan the visa” and the System start rining.
Me: is there something wrong.
Officer: mmmm come with me please.
Me “in my mind” did i do anything bad before i came here.
Officer : Your visa valid from tomorrow.
Me: Kidding right ? So what ?
Officer : you have to wait till 12:00 am then you access to Sofia.
Me : it’s almost 12 hours man.
Officer : it’s Ok you can go upstairs and have some drink and food if you want.
Me : Sure, i am gonna have more than this.

So i wait in the airport and during this i sent an email to Milena to inform her that i will not be available till 12:00 am and told her what is happened to me.

I would like to thanks all of them actually Milena, Heli and Gurcan  these guys was checking on me :).

Wait my story not end here, When i went out of security check now i have to start search of my luggage which i found it in Lost & found Department for more information about this part contact me 🙂

anyway the conference was really good i had two presentation about middleware with live demo, i don’t know why the live demo before the presentation working fine but during the presentation it stop working for stupid reasons but live demo is always challenge

everything was well organized  and conference was really amazing.

Safe Trip my friends 🙂 and meet you soon Inchallah.

Cheers
Osama 

Oracle Open World 2015 review

Posted on by Osama Mustafa in News
As all of you know Oracle open world 2015 finished before 2 days ago, and simply it’s was amazing, my trip started on OCT-21-2015 Wenseday and it’s was totally morning flight which mean i supposed to be in airport at 4:00 am because of to avoid miss my flight i didn’t sleep, the flight was from Jordan – Amman to Turkey – IST and then to SF, when i landed in IST i met my old friend Gurcan Orhan this man is awesome, he managed everything from our seats to waiting in the lounge but i have to say he spent 11 hours sleeping from IST- SF. meanwhile i was watching San Andres movie which i discovered later it was bad idea , in case you didn’t watch it’s movie talking about earthquake happened in San Francisco, actually i watched all the entertainment movie and i was thinking what i will go when i will be back home ? simply i watch San Andres again.

anyway we landed after 13 hours of flying and we met the great Tim Hall the great oracle guy i am sure this man is helping a lot of DBA with his amazing blog. so we took the shuttle “tim, Gurcan, Arup,cary , simon and me”.

Don’t forget this is was my first OOW15 as ACED :), so i attended ACED Breifing and meet my old friends there, during the two days i learnt alot of new things about Oracle that i can’t mention it here because the NDA, and i want to thanks Oracle ACE program to organizing all this and make it true so let’s skip this part.
OOW15 started on sunday with an amazing weather, attending session about RAC, Database just like arup said ” there is database and everything else” and sure the middleware sessions.
I had so much fun & learning, the funny thing that i met Deiby and nassyam for the first time and these guys are simply funny and crazy 🙂 i think we can be called the four musketeers “Me, Alex Zaballa, Deiby and Nassyam”
Let’s not forget the amazing friend all over the world such as : Bobby, Danny Bryant, Kellyn, Heli,  Steve , Kevin ,Mahir, kamran, sai ram, Joel and a lot of amazing people and friends but i can’t feel my fingers 🙂 
Also The ACE dinner on Sunday night was awesome,almost all the ACE’s in one place and we had so much there, in OOW I lost twice with F1 Simulation but i want one of these machine anyway.

and i noticed that i am not good at all when i am eating spicy food i spent my time like the following  one hand drink water the other one wiping my tears. thanks for Sai , Nassyam and Hariharaputhran.

there is so much to say about OOW15 but this is as quick review for it and if you have any more question about it you can ask me 🙂
Thanks 
Osama