Infrastructure at your Service

Category

Oracle

Franck Pachot

Oracle write consistency bug and multi-thread de-queuing

By | Oracle | 3 Comments

By Franck Pachot . This was initially posted on CERN Database blog where it seems to be lost. Here is a copy thanks to web.archive.org Additional notes: – I’ve tested and got the same behaviour in Oracle 21c – you will probably enjoy reading Hatem Mahmoud going further on Write consistency and DML restart Posted by Franck Pachot on Thursday, 27 September 2018 Here is a quick test I did after encountering an abnormal behavior…

Read More
Mouhamadou Diaw

Oracle 21c Security : Mandatory Profile

By | Database Administration & Monitoring, Database management, Oracle, Security | No Comments

With Oracle 21c, it is now possible to enforce a password policy (length, number of digits…) for all pluggable databases or for specific pluggable databases via profiles. This is done by creating a mandatory profile in the root CDB and this profile will be attached to corresponding PDBs. The mandatory profile is a generic profile that can only have a single parameter, the PASSWORD_VERIFY_FUNCTION. The password complexity verification function of the mandatory profile is checked…

Read More
Mouhamadou Diaw

Oracle 21c Security : Gradual Database Password Rollover

By | Database Administration & Monitoring, Database management, Oracle, Security | 2 Comments

Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of time where the application can log in using either the old password or the new password. With this enhancement, an administrator does not need any more to take the application down when the application database password is being rotated….

Read More
Mouhamadou Diaw

Oracle 21c Security : ORA_STIG_PROFILE and ORA_CIS_PROFILE

By | Database Administration & Monitoring, Database management, Oracle, Security | No Comments

In my previous blog I was testing the creation of a new Oracle 21c database. In this blog I am talking about two changes about the security. In each new release Oracle strengthens security. That’s why since Oracle 12.2, to meet Security Technical Implementation Guides (STIG) compliance, Oracle Database provided the profile ORA_STIG_PROFILE With Oracle 21c the profile ORA_STIG_PROFILE was updated and Oracle has provided a new profile to meet CIS standard : the profile…

Read More
Mouhamadou Diaw

Oracle 21c : Create a New Database

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle 21c is now released on the cloud. And in this blog I am just testing my first database creation . As earlier release dbca is still present. Just launch it [[email protected] admin]$ dbca After The creation some query to verify SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS —————————————- ———- ———- Oracle Database Catalog Views 21.0.0.0.0 VALID Oracle Database Packages and Types 21.0.0.0.0 VALID Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF JServer JAVA Virtual…

Read More
Jérôme Dubar

A typical ODA project (and why I love Oracle Database Appliance)

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would like to tell you why I trust this solution. And for that, I will tell you the story of one of my latest ODA project. Before choosing ODAs A serious audit of the current infrastructure…

Read More
Franck Pachot

Recovery in the ☁ with Oracle Autonomous Database

By | Cloud, Oracle | No Comments

By Franck Pachot . I’ll start this series with the Oracle Autonomous database but my goal is to cover the Point In Time recovery for many managed databases in the major cloud providers. Because I’ve seen lot of confusion about database backups (see What is a database backup (back to the basics)). On one side, in a managed database, we should not have to care about backups, but only about recovery. The way it is…

Read More
Franck Pachot

AWS DynamoDB -> S3 -> OCI Autonomous Database

By | AWS, Cloud, Oracle | No Comments

By Franck Pachot . I contribute to multiple technologies communities. I’m an Oracle ACE Director for many years, and I also became an AWS Data Hero recently 🎉. I got asked if there’s no conflict with that, as Amazon and Oracle are two competitors. Actually, there’s no conflict at all. Those advocacy programs are not about sales, but technology. Many database developers and administrators have to interact with more than one cloud provider, and those…

Read More
Mouhamadou Diaw

Oracle Grid Infrastructure on Windows With 2 Nodes

By | Database Administration & Monitoring, Oracle | No Comments

Oracle Grid Infrastructure can be also installed on Windows server. In this blog I am explaining how this installation can be done. I am going to install an environment with to nodes. Oracle 19c is being used. We have two servers winrac1 : winrac2 : with the same characteristics I would like to note that it is just a test environment on virtual machines on VirtualBox. I did not have any dns server and I…

Read More