Skip to content
Home » Oracle Database » Networking » sqlplus Connecting Hang?

sqlplus Connecting Hang?

SQL*Plus Network Issues

At times, we see that some logins and connections are not responding and indefinitely hang in tools like SQL*Plus. In most cases, they're network problems, most specifically, they could be:

  • Domain Name Server (DNS)
  • Intrusion Detection System (IDS)
  • Intrusion Prevention System (IPS)
  • Network capacity (bandwidth)
  • Quality of Service (QoS)
  • Firewall, etc.

You may refer to the post: Why Tnsping Hang for more clues.

SQL*Plus in Silent Mode

Tried to test the connection to a database silently by SQL*Plus.

C:\Users\alex>sqlplus -s username/password@orcl
 

Since there's no response, the connection seems to be an infinite wait and hanging forever.

This is because that you connected to the database in silent mode by specifying the flag -s, which won't prompt you any information or feedback.

In fact, everything is fine, you have logged into the database, it just didn't display anything because of silent mode.

At this moment, you can type any SQL statement you want, or type EXIT to quit the interaction.

To properly use SQL*Plus to connect or disconnect a database, you may have a look.

Leave a Reply

Your email address will not be published. Required fields are marked *