Upgrade Non-CDB to Oracle Database 21c (Manual) - Replay Upgrade

This article provides an overview of a manual upgrade of an existing non-CDB database to Oracle 21c using Replay Upgrade. Upgrades can be very complicated, so you must always read the upgrade manual, and test thoroughly before considering an upgrade of a production environment.◉ AssumptionsThis article is focused...

Continue reading

Oracle Database 21c Installation On Fedora 34 (F34)

This article describes the installation of Oracle Database 21c 64-bit on Fedora 34 (F34) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive.◉ Download SoftwareDownload the Oracle software from OTN or MOS depending on your support...

Continue reading

Session settings and timeouts in OCI

• 
• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

The following question in the Oracle Groundbreakers Developer Community forum made me investigate on how to change the session timeout in the Oracle Cloud console. Have a look, it is still for some reason unanswered:For those who use Oracle Cloud Infrastructure on daily basis, they know that the...

Continue reading

Advice On How to Prepare for the Oracle 1Z0-1094-21 Certification Exam

• 
• 

PrevNext

An Oracle Cloud Database Migration and Integration 2021 Specialist (1Z0-1094-21) has the skills to migrate database instances to the Oracle Cloud, including Autonomous DB and Cloud Database Services, and implement data integration. Depending on the source and target database options, they understand the requirements and architecture. They can...

Continue reading

SQL Trace and X-ADG in the Oracle Autonomous Database

• 
• 
• 
• 
• 

PrevNext

Two very different in nature but equality useful features are now available in the Oracle Autonomous Database:1. SQL Tracing in Autonomous Database2. Cross-Region Autonomous Data Guard in ADB-SHere is how to enable and use them:SQL Trace in ADB:You need first a standard bucket as SQL tracing files are...

Continue reading

Simple Oracle Document Access (SODA) in the Autonomous JSON Database

• 
• 
• 
• 
• 
• 
• 

PrevNext

“I ordered a soda – caffeine-free, low sodium, no artificial flavors. They brought me a glass of water.” – Robert E. MurraySODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to...

Continue reading

Operating System access from within the Autonomous Database

• 
• 
• 
• 
• 
• 

PrevNext

Oracle Autonomous Database does not let us access the operating system. Not even DBA access is allowed.So, how can we view the content of ADB log or trace files from the OS? How about the alert.log file? “Not needed as all is autonomous” is the common answer. But...

Continue reading