Recently, I undertook the task of upgrading an Oracle database from version 19.10 to 19.18. As the process progressed, I began to encounter a series of errors that were consistently appearing in the alert log. After diving deep into the issue, it was discovered that running a series of scripts after the upgrade would effectively solve the problem. Furthermore, it was necessary to recompile the invalid packages. Without any delay, I proceeded to execute the specified scripts and recompile the invalid objects. And voila, problem solved! I hope this post…
Month: May 2023
Enable online status for all Oracle database datafiles
I have executed a database migration by transitioning from a physical active data guard to a primary database. Subsequent to the migration, I observed that several data files were offline, as evidenced below: Modifying the status of each individual data file would require a substantial amount of time. To provide an illustrative example: In order to streamline the operation, I devised a PL/SQL procedure that effectively places all data files offline across all tablespaces within the database, subsequently modifying their statuses to online, as illustrated below: I hope this post…
Storing Information from ChatGPT in Oracle Database Container using Python and Jupyter Notebook
In this post, I will be creating Python code using Jupyter Notebook to store information from ChatGPT in an Oracle Database within a Docker container. The objective is to showcase how an application can retrieve various types of data from an AI-based tool. Additionally, the idea behind this is to illustrate how the implementation of supercomputers can further optimize this infrastructure. By utilizing the Python programming language and Jupyter Notebook, we can develop code that captures and stores information generated by ChatGPT. This code will serve as a demonstration of…
Installing Oracle Database on macOS using Oracle Docker Images
Technology is constantly evolving, and with it, the methods of installation have changed. For DBAs who once relied on CDs or diskettes to install Oracle databases, the ability to quickly and easily create and deploy a database using Docker images provided by Oracle is truly impressive. In this post, I will cover the deployment of Oracle database 18.4 using the free and simplified edition, Oracle Express, on MacOS Monterrey 12.6.5. To begin, I would like to share the necessary tools that one must download in order to achieve this goal.…
Oracle Linux Installation Media – ISO images
I needed to install Linux to deploy containers using Kubernetes and Docker. To save time on configuring the environment, I decided to install the latest version of Oracle Linux. Instead of going through a complex installation process, I downloaded an Oracle Linux image under the ‘Virtual Appliance Oracle Product’ category, which I was able to deploy easily. If you’re looking to save on installation and configuration costs, I am sharing the links below, as well as the image I downloaded (which was the Full ISO release 9.1 ‘OracleLinux-R9-U1-x86_64-dvd.iso’ – 9G…