Using Google Translate API with Oracle UTL_HTTP and Wallets on Oracle Database
When using Oracle’s UTL_HTTP or HTTPURITYPE to access external HTTPS services like Google Translate, you may encounter certificate validation errors…
impdp failed with error ORA-39002 , ORA-39405 due to Time Zone issue – 19c
Issue impdp giving error ORA-39002: invalid operation , ORA-39405: Oracle Data Pump does not support importing from a source database…
Oracle Database – Release Schedule of Current Database Releases
New Oracle Database 23ai, earlier launched as Oracle Database 23c, because of the importance of the breakthrough AI technology in…
DBCA : Unable to check for available memory on windows
while creating new database using DBCA getting below error on windows PC DBCA fails with errors: [FATAL] [DBT-50000] Unable to…
Why DELETE Cannot Be NOLOGGING in Oracle – Best Practices for Large Data Deletion
Introduction In Oracle databases, NOLOGGING is often used to minimize redo log generation for certain operations. However, many users wonder…
How to resync DR database after a long Gap
Check the scn on Standby database select min(fhscn) from x$kcvfh; Take incremental database backup on production Take incremental backup on…
Auto Start Oracle Database on Linux
After successful installation of oracle database on Linux follow below procedure to autostart the oracle database after server reboot Auto…
Database Character set change on Oracle 18c Express Edition [Incl Installation steps on Oracle Free Cloud Linux instance]
Free Oracle Database for Everyone, Whether you are a developer, a DBA, a data scientist, an educator, or just curious…
Send Mail from Oracle database
Environment Details Oracle Linux Server release 7.4 Oracle Database 12.1.0.2.0 Putty -> For accessing the Linux Server Database Credentials SYS…