Thursday, July 29, 2021

Forum is back online ! -- Erman Arslan's Oracle Forum --

We're back online! Thanks Nabble for the support. We are on a different Nabble server now. But nothing is changed in your perspective :) 
You can access the forum directly from the blog as before.. 
Just by clicking the "Erman Arslan's Oracle Forum is available now. Click here to ask a question. " link in the homepage of this blog or by using the direct url : http://ermanarslan.blogspot.com/p/forum.html

We will continue where we left off. Actually it was a few hours break but just saying :)

Planned Outgage ! -- Erman Arslan's Oracle Forum --

We have an outgage due to a planned operation that is currently being performed by our forum host (Nabble).

Our forum is being migrated to its new host at the moment.

Erman Arslan's Oracle Forum will be available soon. Thanks for your understanding and patience...

Note that, due to the short vacation, the questions piled up a bit. I will answer them all, once our forum will be reachable again.

    

Friday, July 9, 2021

Erman Arslan's Oracle Forum / Jun 1 2021 - July 7 2021 - "Questions and Answers Series"

Question: How much time do you spend/lose?

Answer: Well, how much time I gain? :) 

Remember, you can ask questions and get remote support using my forum.
Just click on the link named "Erman Arslan's Oracle Forum is available now.
Click here to ask a question", which is available on the main page of Erman Arslan's Oracle Blog 
-- or just use the direct link:


Come on, let's see what we've been up to in Jun + in the beginning of July 2021.
Do not forget to read the blog posts too :)

Backup testing failed using data protector tool by satish

ERROR in ADOP PREPARE PHASE by neldyan14

Oracle OAS 5.5 integration with Oracle OAM by Zaheer

Error opening oat page for specific user in r12 by satish

XML materialized view by Roshan

Dynamic footer on RTF template of word by Huy Nguyen

Oracle Apex 20.1 LDAP authentication with Windows Active Directory by Zaheer

Creating materialized view based on OEBS editionables by ANIETO

DB Cloning failing in EBS R12.1.3 after upgrading Database to 19c by soumya

Global database name cannot be left blank by big

oracle cloud 13c by Arsalan

Autoconfig delet profile option by big

How to Implement Signon Password Custom Profile Option R12.2 by satish

ODA- Database migration between 2 ODA Boxes and 19C upgrade for EBS by mmanavat

Changing domain name in r12.2 multinode by satish

forms-c4ws by big

How Can I Restrict Applications Users To Be Signed In Only Once At Any Time Doc ID 375403.1

Connection is long by big

Is Oracle Certification easy to pass? by Tasmina

Restrict user to a single session r12.2.5 by satish

Oracle RAC and PCP in R12.2 by mi_singh@hotmail.com

How do I set db_unique_name properly in CDB.env file? by SriCheb

Data access from one dB to other by satish

Security report r12.2 by satish

Test mail for workflowmailer by big

Concurrent manager for Alert Notification by big

golden gate index issue by Roshan

Dblink from oracle to PostgreSQL-compilation error by satish

pluggable database could not open by Arsalan

Switching EBS Application from primary to Secondary Database by Tabrez

Recoverability Roadmaps & Remediation Options - Oracle, Systems, Apps Technology, Virtualization and Engineered Systems

In this post, I want to share my thoughtson Recoverability, actually my approach that I use in Recoverability Assessments.. Actually, these types of assessments are comprehensive, they even include DR solutions, trainings, recovery processes and the continuous availability.

I start with the readiness.. Readiness in 3 different areas : People, Process and Technology. I review and rank the readiness for key areas that are enablers for availability, resiliency and recoverability by assessing current IT capabilities of the customer.

Once I generate the readiness documents, I do my analysis, determine the gaps and then present my recommendations. I support the customer in execution as well.. ( if they need me there..)

So it is pretty straight forward, but still requires lots of efforts :)

The assesments starts with the information gathering. I just gather the detailed information and do my analysis for a number of attributes in the following areas;  

Operational Staff, Response Plans, Recovery Testing, Program Maintenance, Business Expectations, Production & DR Facilities, Application Infrastructure, Data Restoration and Recovery Network.

During this first phase, we usually meet with the customers. I write down the people, process, and techonology findings. Then, we popuplate tool based discovery reports ( DB , Server, SAN healtchecks, Server grabs & logs etc..)

In the second phase, I create a recommendation list.  Next, I do the remediation roadmap, finalize the recoverability assessment document and lasty I give the final recoverability assessment repsentation (an executive presentation actually)

While analyzing the people and process findings, I check to see if there any any gaps in the following areas; business expectations, production & DR facilities, Application Infra, Data Restoration, Recovery network , Operational Staff, Reponse plan, Recovery Testing, Program maintanence and etc..

Following is an example of the GAPs that may be found in the Recovery network ;

No formal DR program
DR requirements unknown
Lack of formal documented policies or processes

Following is another example of the GAPs that may be found in Data Restoration area;

Lack of service levels with the business
No formal tiering structure
Recovery RTOs / RPOs have not been defined
Lack of recovery expectations

These are big gaps :) and they are here just to give you some examples, but I guess you understand  the scope of the work already..

In the technology analysis phase, I analyze the following layers through the following critieria;

Presenation layer, Login/application, Database, Compute, Storage, Network  --> Production HA, DR, Backup, Archiving.

Some examples for the technology findings in this phase;

A single point of failure (SPOF) exists which would cause a complete outage for the application.
Server configuration is not aligned with the intended high-availability design (cluster is misconfigured).

Well, after the findings, I create a recommendation matrix, and summarize these recommendations..
I analyze the recommendation from the implementation effort and business impact perspectives and then create a matrix to show the risk level / business impact and implementation effort  of each recommendations.


Business Impact goes low to high when you go upwards in the y axis, effort goes high to low when you go right in the x axis.. So,  action items/recommendations in the top right quadrant are given high implementation priority, due to low effort & high impact. So you get the idea..

As for the redmediation options, I give the as-is Architecture, then propose target solutions by considering/analayzing the gaps. There may be more than one solution proposed as part of the Gap Analysis against Recoverability Business Requirements .

Finally I create thre recoverabiliy roadmap and that's it :)

In the recoverability roadmap, I start with the areas of opportunities and build a 18 Months plan. (maybe further) . I list the actions that should be done in near term, in 6-12 Months and in 12-18 Months to reach the target state where we usually have the following;

Increased ROI
Standardized Environment
Ensured Recoverability 
Recoverability and continuous availability services aligned with the business needs
Operational Excellence
Organizational stability
Culture of Ensured availability & DR Services.

That's end of this post. I hope you find it useful.
If you need any advice or consultancy, feel free to contact me.

Thursday, July 8, 2021

OVM Manager / Weblogic -- CVE-2019-2725 / deserialization - remote code execution vulnerability

Here is a filtered information for OVM customers, who are complaining about CVE-2019-2725, which is a deserialization vulnerability, a remote code execution vulnerability that is remotely exploitable without authentication.

I guess everyone already knows that OVM uses Weblogic in the backend. Actually this post is for all the ones who use certain versions of Weblogic..  Weblogic 10.3.6 and 12.1.3. 

The solution is simple for the ones who have extended support contract because these Weblogic releases are currently in extended support. This is the reality for both OVM Manager and Weblogic customers.

So, you just apply the latest PSU, or a PSU which fixes the issue and the overlay patch if there is any 
and that's it.. You are done .. (for instanc :e Apr 2019 PSU 12.1.3.0.190416 Patch 29204657 + Overlay Patch 29694149 on 12.1.3.0.190416 for CVE-2019-2725)

OVM Manager customer can also apply the PSU and overlays.. Although Weblogic is bundled with OVM Manager, it is supported to get latest security updates, to the latest minor updates. I mean you can apply PSUs to the Weblogic of OVM Manager..

The questions arises for the ones who don't have extended support for Weblogic. That is if they don't have extended support contract, they won't be able to download any WLS patches for those specific releases.. 

This means  no PSU, no CPU, no overlay...

In this case, they have 2 options.. 

1) They may upgrade their OVM manager to version 3.4.7, which is bundled with Weblogic 12.1.3.0.210119 -- January 2021 Patch Set Update (PSU) for WebLogic Server 12.1.3.0.

2) They may implement the following workaround (but this must be tested, I mean it must be ensured that OVM Manager will not lose any functionalities after these actions);

Delete the wls9_async_response.war & wls-wsat.war packages from Weblogic and restart the OVM Manager+ Weblogic
Disable access to“/_async/*” and “/wls-wsat/” URLs on weblogic.
Test well..
-- you may even implement this access restriction on the firewall level.

MOS References:

Upgrading products bundled with Oracle VM Manager (Doc ID 2195205.1)
Security Alert CVE-2019-2725 Patch Availability Document for Oracle WebLogic Server (Doc ID 2535708.1)