Problem solve Get help with specific problems with your technologies, process and projects.

Host string vs. connect string

I am new to Oracle, and I'd like to know the difference between a host string and a connect string.
In Oracle, a "connect string" is the information a user passes through the network to connect to a database. For instance, in SQL*Plus, you can issue the following command:
CONNECT username/password@tns_entry
The italicized portion is a connect string. It contains the username, the password and the TNSNAMES.ORA entry to point to a remote database.

The term "host string" is not defined in the Oracle documentation of network terms. The closest in the glossary is "host naming," which is a method of defining database servers in your network.

The only other thing I could think of that "host string" could mean in Oracle terminology is that the TNSNAMES.ORA and LISTENER.ORA configuration files can contain an entry defining the host of the database.

Most Oracle people I know do not use the term "host string," so I am unfamiliar with how you are using it. If you have further information and need additional clarification, please let me know.

Dig Deeper on Oracle DBA jobs, training and certification

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.