Welcome to this tutorial on how to install Oracle Apex, step-by-step.In this video, we’ll be walking you through the process of installing Oracle Apex version 23.1 , with ORDS version 23.1.4, on one Oracle pluggable Database version 21c. Whether you’re a beginner or an experienced developer, this tutorial will help you get started with Oracle … Continue reading How to Install Oracle Apex 23.1?
Getting ORA-29003 Connecting to Oracle Autonomous Database Cloud Service
Couple of days back, I started to get the following error, whenever I tried to connect to any Oracle Autonomous Database Cloud Service from SQL*Plus on my laptop (which was usually working fine for years):ORA-29003: SSL transport detected mismatched server certificate So, I reviewed the sqlnet.ora file under the working Oracle Home, and I found … Continue reading Getting ORA-29003 Connecting to Oracle Autonomous Database Cloud Service
How to find Top Hard Parsing SQL Statements?
Background:A hard parse occurs when a SQL statement has to be loaded into the shared pool. In this case, the Oracle Server has to allocate memory in the shared pool and parse the statement.A hard parse is a heavy process in terms of resources (CPU & Memory), and we should avoid whenever possible.Excessive hard parsing … Continue reading How to find Top Hard Parsing SQL Statements?
How to Install PostgreSQL 14 on Redhat Linux step by step
PostgreSQL Installation on Windows
Following is a live demo for PostgreSQL version 15.2.2 installation on windows. You can download the software (304MB) from:https://www.postgresql.org/download https://youtu.be/gsel3HhPYT8
Simple Way to display Tabular data in Python
Here below is a simple program to display data (list or list of dictionaries) in a tabular format using the "tabulate" package. This is the required output: Prerequisites: If you don't have the "tabulate" package installed, you can install it using: pip install tabulate The Program: Following is the program code: Sample Run: Following is … Continue reading Simple Way to display Tabular data in Python
ORA-01017: invalid username/password; logon denied
I have a virtual machine with Oracle Database 19c installed. I downloaded this machine from Oracle. {If you are interested, you can download it from the following url: https://www.oracle.com/downloads/developer-vm/community-downloads.html } I started the virtual machine, login as oracle user, and ensured that the environment is set correctly: Then, I tried to login to the database … Continue reading ORA-01017: invalid username/password; logon denied
Introduction to Unix/Linux Administration
Oracle Database Cloud Service Provisioning is very slow
While creating an oracle Database cloud service (or the new name “Oracle Base Database”): and after passing all the required information, and then clicking “Create DB System”, it started to provision the database system: The problem here is that it takes very long time to provision, I waited for 1 hours, 2,3,4 hours without luck. I … Continue reading Oracle Database Cloud Service Provisioning is very slow
How to Download Oracle software to VM in a private OCI subnet?
I have a virtual machine located in an OCI private subnet. I need to install an Oracle software (e.g. Oracle ODI) in this VM.How I can download the software to this VM?We have a couple of options: 1- Download the software to your laptop, then sftp it to the VM (connecting through VPN and your … Continue reading How to Download Oracle software to VM in a private OCI subnet?