You often need to know the size of an Oracle database to move it from one server to another. Or just to know if your export or whatever is going to take a lot of space and time.
In this article I show you a simple way to calculate the size of your Oracle database.
Size of Oracle datafiles in GB
Continue reading “How to Check Database Size in Oracle 19c”
select sum(bytes)/(1024*1024*1024) G
When connecting to an Oracle database, it’s essential to ensure that the necessary network ports are open and accessible.
To establish a connection, it’s important to verify whether Port 1521 is open, as this default port is used for communication with the Oracle database.
Checking the port can help identify any network issues that may prevent the connection, such as firewalls or blocked ports.Continue reading “Bash Script to Check if Port is Open”