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.
To access the Oracle database without interruptions or security breaches, make sure the network connection is secure, and the port is open.
Here is a short script that checks if port 1521 is open or not.
#!/bin/bash # Check if at least one IP address is provided if [ $# -eq 0 ]; then echo "Usage: $0 <ip1> [ip2] [ip3] ..." exit 1 fi # Port to check port="1521" # Timeout value in seconds timeout_duration=1 # Loop through IPs provided as command-line arguments for ip in "$@"; do echo "Checking port $port for IP: $ip" # Check if port is open using /dev/tcp and the timeout variable timeout "$timeout_duration" bash -c "echo >/dev/tcp/$ip/$port" 2>/dev/null # Check the exit status of the last command if [ $? -eq 0 ]; then echo "Port $port is open on $ip" else echo "Port $port is closed on $ip" fi done
You give it execution permission.
chmod +x check_ports.sh
And you then execute the script by giving the IPs as parameters.
./check_ports.sh 192.168.1.1 192.168.1.2 192.168.1.3