Scaling a Database Deployment – Oracle Cloud

If a database deployment on Oracle Database Cloud Service is performing poorly or is running out of storage, you can scale up the environment supporting the database deployment.

follow these steps to scale up/Down your Dbaas :-

  • Open the Oracle Database Cloud Service console.
  • Click the name of the deployment you want to scale.
  • Choose the scaling command:
  • The Scale Up/Down Service overlay is displayed. 
Choose which resource you want to Press Yes.
Thank you
Osama

2016 Another Year In this world

I don’t know if it is early to write something now, most of people will share this during the end of December but i choose to write mine earlier, i will not share anything technical this time but i will share what i did during this year maybe it will be useful for someone 🙂 so enjoy reading.

I did a lot of things during 2016 and most of them related to my work and what i love which is Oracle and contribution in Oracle community there was differenct conference during this year which took a lot of time and travel i don’t how much time i spent in the air but i am sure it’s more than 10 days since i am living in the other side of the world which is Jordan – Amman or Sometimes Dubai.

I start the year with one of the best conference and the well known one which is Rocky mountains and this is was my first time in this amazing conference during the conference i celebrate my birthday in Denver with my friends, alot of the conference and traveling so i will mention them as point ( i don’t want the reader to get bored  ).

  • RMOUG 
  • OUGN
  • IOUG
  • TROUG
  • OUGF
  • OTN TOUR – LA 
  • OOW 
  • DOAG
For the Other contribution i did the following :- 
  • Organize Local event for Jordan Amman Oracle User Group.
  • Technical Reviewer for two books.
  • Technical Reviewer for Videos about Oracle database series. 
  • working on my new book.
  • write different oracle articles.
  • Sure … Post blogs about Oracle.
I feel like i forgot something to mention but if i remember anything i will publish it for sure and update the blog post here. 
I would like to take this opportunity to thanks Oracle ACE Program to allow us & support us do what we are doing for the community. which is one of the best community in the world.
I am always thankful for meeting new friends around the world and for my family for their continues support.

Thank you Oracle

Wish Happy new year everyone and all of the best next year.
Merry Christmas everyone enjoy the holiday. 
My friends see you next year Inchallah 🙂 Finally Inchallh next year will be better for all of us.
Cheers
Osama 
Like Usual comments are always welcome. 

ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA

While trying to install Oracle Database 11gR2 on Windows 2012R2 I faced the following error :-

ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA

After checking the logs and investigate about the issue  :-

The password was containing “@” after removed it from the password everything works perfectly.

Thanks
Osama 

Apply Weblogic Patch Offline mode

  1. Shutdown all the services for weblogic.
  2. unzip the patch under $MW_HOME/utils/bsu/cache_dir
  3. run the following command :-

./bsu.sh -prod_dir=$weblogic_home  -patch_download_dir=Patch_location -patchlist=patch_id -verbose -install

The final Result 

Or you can apply the weblogic patch using smart update

Thanks
Osama Mustafa

Difference between OIM , OAM And OID ?

OAM :- Oracle Access manager 

Regarding to Oracle Documentation

Oracle Access Management is a Java, Enterprise Edition (Java EE)-based enterprise-level security application that provides a full range of Web-perimeter security functions and Web single sign-on services including identity context, authentication and authorization; policy administration; testing; logging; auditing; and more. It leverages shared platform services including session management, Identity Context, risk analytic, and auditing, and provides restricted access to confidential information.

From the above picture as you see OAM provides single point to control all resource grants in an enterprise where multiple applications exist on different platform.

You can refer to oracle Doc here.

OAM provides:

  • Single Sign On (SSO)
  • Authentication
  • Authorization
  • Access Auditing
  • Policy Administration
There is more but you can refer to the above documentation.
OIM : Oracle Identity manager 
enables enterprises to manage the entire user life cycle across all enterprise resources both within and beyond a firewall. An Oracle identity management solution provides a mechanism for implementing the user management aspects of a corporate policy. It can also be a means to audit users and their access privileges.
The best best example to understand OIM is employee.
if the new employee joining the company the HR handle everything for him emails, permission … etc, with OIM it’s different and all of this can be done automatically
Refer to Oracle Documentation here 
Finally OID : Oracle Internet Directory.
Simply it’s LDAP, 
An online directory is a specialized database that stores and retrieves collections of information about objects. The information can represent any resources that require management, for example:

Employee names, titles, and security credentials
Information about partners
Information about shared resources such as conference rooms and printers.
The information in the directory is available to different clients, such as single sign-on solutions, email clients, and database applications. Clients communicate with a directory server by means of the Lightweight Directory Access Protocol (LDAP). Oracle Internet Directory is an LDAP directory that uses an Oracle Database for storage.
OID Oracle Documentation here
Thanks
Osama

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

BGOUG Autumn Conference – Extraordinary trip

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