Hi there! I'm Himanshu, a Oracle DBA with almost decade of experience in IT. I am OCA/OCP along with Cloud certifications for multiple vendors such as IBM, Oracle, Amazon and Microsoft. I'm passionate about sharing my knowledge and helping others learn Database.

communication, error, no connection-2138980.jpg

Oracle Database Networking

Networking in Oracle Databases helps to establish communication between Oracle Database Server and Database Clients. This can include end users, applications, databases etc. Let’s check out some of the key components and management of these. Oracle Net Services It is the foundation of Oracle Database networking which enables communication between client and database. It includes …

Oracle Database Networking Read More »

Flashback

Imagine this: a user accidentally deletes crucial data from a table or updates rows with the wrong values. Panic might set in, but Oracle’s Flashback technology swoops in to save the day. This powerful feature lets you travel back in time to view or/and recover data as it was before the error occurred. In this …

Flashback Read More »

ai generated, robot, data-8587591.jpg

SQL Macros (SQLM)

SQL Macros was initially introduced in 19C and have been continuing its way to new releases of Oracle and gaining some attention. They are coming for great usage for analysis and easy data transformation especially for Data Analyst/Developers.Macros are way for encapsulation of complicated logic within the SQL. The “macro” can then be used within …

SQL Macros (SQLM) Read More »

ORA-09925: Unable to create audit trail file

Issue: When trying to login via SQLPLUS, getting ORA-09925 ERROR:ORA-09925: Unable to create audit trail fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 9925ORA-01075: you are currently logged on Cause of Error: Error message indicates that either Oracle is not able to find audit directory or it is not able to write/create file there.It …

ORA-09925: Unable to create audit trail file Read More »