Create Smart Dashboards Automate your Monitoring Using Oracle Apex
I have created a dashboard to automate the monitoring process of our Oracle database customers. The above dashboard data population…
Oracle 19c 2 node RAC to single instance
Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup…
Oracle Application Express (APEX 20+) Admin Password Reset
if you forget admin password for Oracle Apex, can reset it by doing the below steps Check the schema name…
Switch your CentOS workloads to Oracle Linux as Red Hat says Stream is “not a replacement for CentOS”
CentOS Stream isn’t a replacement for CentOS Linux; rather, it’s a natural, inevitable next step intended to fulfill the project’s…
How to Backup Oracle database to OCI Object storage
From on premise or from any OCI instance we can directly backup Oracle database using RMAN to Object Storage. Create…
Change Database Character Set in Oracle 12c
Take a full backup of your database before applying the change. change the NLS_CHARACTERSET from WE8MSWIN1252 to AL32UTF8; select * from NLS_DATABASE_PARAMETERS where…
How to connect Schema if dont remember password
Option 1 One way is to alter the current session and do transaction. alter session set current_schema=SYN_BI; But show user…
How to make a read only Column on Oracle Apex FORM to save data on database
Column Type Column Type