Disable archive log mode in Oracle RAC: Easy Guide
In this post, we'll cover everything you need to know about how to disable archive log mode in Oracle RAC. Let's open our 2-node Oracle RAC(node1 and node2) VirtualBox and…
Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
How to find master node in Oracle RAC: 3 Easy Method
This post will cover everything you need to know about how to find master node in Oracle RAC. Let's open VirtualBox and get started! The node where Cluster Processes gets…
Troubleshooting ORA-19504 : failed to create file: Easy Guide
Today in this article, we will learn about how to resolve ORA-19504 : failed to create file. Lets go through this: Error : DEST_ID DEST_NAME STATUS DB_UNIQUE_NAME ERROR---------- ------------------------------ ---------…
4 different Oracle database shutdown modes: Easy Guide
In this article, we will discuss different Oracle database shutdown modes. Please note that to startup or shutdown the database, you need to logon as “sys as sysdba” or with…
3 different Oracle database Startup modes: Easy Guide
In this article, we will discuss the 3 different Oracle database startup modes. Please note that to startup or shutdown the database, you need to logon as "sys as sysdba"…
Troubleshoot ORA-02236: invalid file name: Easy Guide
The error ORA-02236: invalid file name we may get in either of the below cases. Let's go through the cases one by one : Error : ORA-02236: invalid file nameCause:…
How to resolve ORA-01507: database not mounted
Error : ORA-01507: database not mounted This error means the database is in no mount state. You can also check the status by issuing the below command : select instance_name,status…
ORA-01090: shutdown in progress – connection is not permitted
Sometimes you can get the error 'ORA-01090: shutdown in progress - connection is not permitted'. ORA Error DetailsCause of the ORA ErrorResolve ORA-01090 Error Details of the error: ERROR:ORA-01090: shutdown…
How to find alert log file location in Oracle: 2 Easy way
In this article, I will provide a detailed guide on How to find alert log file location in Oracle database. We'll walk you through each step of the process in…
Basic SQL plus commands with examples: Easy Guide
Welcome to our guide on Basic SQL plus commands with examples. You'll find valuable insights here whether you're a beginner or an expert. In this post, we'll cover everything you…