Positive Impact of the COVID-19 Crisis on Project Management

Overview

During the COVID 19 Pandemic period, we can have noticed a lot of positive things reinforcing the project management:

People increased their knowledge and skills on project management as many training sessions have been attended, many certifications have been delivered.

The contribution of PMI and different chapters such as PMI Luxembourg Chapter is important for transferring and increasing skills with their multiple programs as well as their free shared content and training

For more details:

https://www.pmi.org/chapters/luxembourg/stay-current/newsletter/positive-impact-of-the-covid-19-crisis–on-project-management

https://www.linkedin.com/posts/abdelhalim-hafed-62b8595a_positive-impact-of-the-covid-19-crisis-on-activity-6818458537409216512-HkCK

The default retention period for both Automatic and Manual Autonomous Database Backups

Autonomous Database automatically backs up your database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period.

Ref:

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/backup-intro.html#GUID-3BF27FDE-F847-4A86-9C8B-4ED9B0C1D1B2

Autonomous Database with Data Warehouse ignores hints

Autonomous Database with Data Warehouse ignores optimizer hints and PARALLEL hints in SQL statements by default. If your application relies on hints you can enable optimizer hints by setting the parameter OPTIMIZER_IGNORE_HINTS to FALSE at the session or system level using ALTER SESSION or ALTER SYSTEM.

Ref:

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-optimizer-stats-data-warehouse.html#GUID-0C542F13-F856-4A98-8E87-2042B2326CF6

A password is needed for downloading old Oracle patches

Here we’ll show you a demonstration on how to download an old Oracle patch if needed.

Please go to the Doc ID 2118136.2 for selecting what we like to download, for exemple select Oracle Database base releases choice.

When selected, it chows us the links for available patches.

For older version, we need to open a non-technical SR to receive a physical media or a link for downloading.

To do it, please follow the Doc ID 1071023.1

When we’re trying to download an old patch, for exemple the 30557433

Make a search for this  patch, after that please click on Download bouton.

It will ask you to put a password received for when a non-technical SR was been created.

References :

Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

How to Request Software Media when it is Unavailable on the Oracle Software Delivery Cloud Site (Doc ID 1071023.1)

Oracle Critical Patch Update – April 20, 2021

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. This Critical Patch Update addresses 384 new security patches. Some of the vulnerabilities addressed in this Critical Patch Update affect multiple products. Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply Critical Patch Update patches as soon as possible.

For more details:

https://www.oracle.com/security-alerts/cpuapr2021.html

Putting Data Security and Protection First

Putting Data Security and Protection First

Three foundational principles of Oracle Security

To help every organization move forward with confidence, there are three strategic security pillars to be taken in consideration :

  • architected-in,
  • automated,
  • and always-on.

Here’s how it works in practice, with these articles :

https://www.oracle.com/webfolder/s/assets/ebook/security-first/index.html

Security Articles:

Predefined Database Service Names for Autonomous Transaction Processing

The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low.

The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.

tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.

tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.

high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.

medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).

low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.

For more détails, you can reach the below link:

Ref:

https://docs.oracle.com/en/cloud/paas/atp-cloud/atpgs/autonomous-connect-database-service-names.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

How to protect your data

Oracle event : April 1, 2021

Cyber ​​attacks and ransomware (ransomware) are on the rise and require us to protect our data ever more effectively.

In a digitalized environment, the loss of access to your data is detrimental for your company, its reputation, its productivity and its sustainability.

IT teams have been able to deploy effective solutions to counter traditional data and database risks, but are they ready to face these new threats?