I am new to Oracle, and I'd like to know the difference between a host string and a connect string.

    Requires Free Membership to View

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.

This was first published in May 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: