What does the host string in Oracle mean?

Source: Internet
Author: User
Keywords: if the host string in oracle is connected to the local database using the local SQL * Plus, ldquo; host string rdquo; can be empty. For remote connection

Keywords: if the host string in oracle is connected to the local database using the local SQL * Plus, ldquo; host string rdquo; can be empty. For remote connection

Keywords: host string in Oracle

If the local SQL * Plus is used to connect to the local database, the "host string" can be blank.

To remotely connect to the xp oracle database, use the following method:
1. Start oracle-related servers in windows;
2. log on to the xp command line using "sqlplus/nolog" and use sysdba to connect to the database ("conn/as sysdba ");
3. Use the "select name from v $ database;" name as the host string;
Use "select * from global_name;" to view the global domain name.

What is the format of the string used to connect oracle sqlplus to the Database Host?

Is your database name,
Search for the tnsnames. ora file name in the oracle installation path and open it in text.

ORA9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = xx. xx) (PORT = XXXX ))
)
(CONNECT_DATA = (SID = ORA9I) (SERVER = DEDICATED ))
)

ORA9I is the host string you mentioned, that is, ORA9I = this location.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.