Author Shadab Mohammad
Automatic Indexing (AI) is probably the most important new feature of Oracle Database 19c and AI is arguably one of…
Oracle Database 19c (19.3.0) for Linux is available for download as of now from OTN and eDelivery. For those of…
Moving from an Architect’s role to an Engineers role is a bit of a misconstruct when it comes to IT.…
If you want to exclude certain filetypes from the directory when creating a tar archive use the –exclude parameter for…
Restore a bootable USB flash drive to normal on MacOS If you are trying to format a USB disk on…
Installing Mechanize gives error on MacOS Mojave For Python and Pip 2.7 This error is due to a version of…
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…
Slack has quickly become one of the standard messaging apps in the Enterprise. Many a companies use slack for communication…
In one of the largest software M&A ever, IBM has paid US$34 billion in cash to acquire the Enterprise opensource…
— Replace duplicate values only in consecutive records with NULL [duplicate]– SELECT CASE WHEN lag(tran_id) over(order by NULL) = tran_id…
ORDS Basic Authentication 1. To protect the web service, we need to create a role with an associated privilege, then…
ORDS Version : 18.2 Oracle Version : 12cR2 Error : The database user for the connection pool named apex_pu, is…
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…
#!/bin/bash read -p ‘Enter the Files to be Send to Remote Host: ‘ files destination_directory=’/home/oracle’ scp -i /Users/shadab/wha.pem $files oracle@192.168.1.200:$destination_directory…
# .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.…