Q

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.

This was first published in May 2005

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close