Oracle 19c is now available to use on Oracle Live SQL
Category Database
One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
In my previous article we had fun with Shell Scripts by automating birthday alerts via email. Using the same logic…
Shell scripting is one of the most entertaining ways to learn programming. Shell scripting is infact a programming language in…
In my previous article I showed you how to use Letsencrypt to secure a production Apex instance. This is specially…
Download the client credentials from your Oracle Cloud account for your Autonomous Data Warehouse Instance. Make sure you note down…
Oracle has been an incumbent to the cloud space having lost a lot of ground to Amazon and Microsoft.But that…
— Replace duplicate values only in consecutive records with NULL [duplicate]– SELECT CASE WHEN lag(tran_id) over(order by NULL) = tran_id…
Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create…
While creating a on-premise 18c (18.3) database with DBCA in the silent mode I got the below error dbca -createDatabase…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
On my test server I have got 2 ORACLE_HOMES 12cR1 (12.1.0.2) and 12cR2 (12.2.0.1) My listener.ora file on my server…
Create a new interactive report based on SQL Query. Make sure the column where image is store is populated in…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
It is always good practice to lock down password based logins and SSH using keys. We can use pem files…
If you have a public facing APEX instance it would be mandatory to secure it with TLS 1.2 or SSL.…
If you are going to work on Oracle Database in cloud or in environments where X11 client or server is…
This error occurred in my environment when i tried to create a user in MySQL, most likely you have upgraded…
This error you would usually see when you login to phpMyAdmin after an upgrade. This is related to your MySQL…
Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from…
1. Add Encryption Wallet in sqlnet.ora Location $ORACLE_HOME/network/admin [oracle@localhost admin]$ vi sqlnet.ora ENCRYPTION_WALLET_LOCATION = (SOURCE =(METHOD = FILE)(METHOD_DATA = (DIRECTORY…