blognow

In this blog, We will try to understand how to resolve the ORA-01722 error. Problem Statement ora-01722 invalid number in oracle Solution First describe the table and check for data types by using desc command Check the type of data you are inserting and type of column An ORA-01722 error occurs when an attempt is […]

This is common error which will occur on oracle database. ora-03113 end-of-file on communication channel Following are the reason to get the error Database goes down abruptly Server goes down and there is no communication with server Solutions Check the alert log file. reason can be anything and accordingly you need to act If you […]

Sometimes you will see the error message related to tns. Error message will be like this. ORA-12154: TNS could not resolve service name specified Solutions Check if your listener is up and running Check if listener is listening to database services. Look for tnsnames.ora file. database entry needs to be available there Syntax error in […]

In this blog post we will discuss about the oracle 19c installation on windows server. Here is the latest version of oracle 19c installation steps on the top of windows operating system. In the end of blog you will find the youtube video based on oracle 19c installation step by step. Oracle Database for Windows […]

In our previous blog ,We have seen how to resolve the dataguard ORA- error related to ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM. In this blog, I will explain you about the ORA-16047: DGID mismatch between destination setting and target database Let us see how to resolve this issue. Explanation: While working with […]

I have created complete oracle database administrator udemy courses for oracle dba and that will surely help you to grow up in oracle dba field. You can enjoy the video and surely get the depth knowledge. Courses are getting updated on weekly basis. Following is the list of course available on Udemy. Coupon Code for […]