Differences between global database names and Sid

Source: Internet
Author: User

Global Database Name: The full name of a database that uniquely identifies a database with any other database. The format of the global database name is <database_name>. <database_domain>. For example, student. cs. hubu is a typical global database name. The database name section (such as student) is the simple name of the database. The database Domain Section (such as CS. hubu) specifies the region where the database is located. It is usually the same as the network domain in the enterprise. The database name part of the global database name cannot exceed 8 characters, and can only contain letters, numbers, and periods.
Sid (system identifier): identifies a specific routine of an Oracle database. For any database, there must be at least one routine that references the database. Sid can be any name not used by other routines on this computer. Sid is the unique identifier of an Oracle Data Warehouse routine. It can contain up to 8 letters and numbers. Each data warehouse routine corresponds to a Sid and a series of database files. For example, when a database with the SID of XXX is created, the data library routine and its database files (initialize parameter files, control files, redo log files, and data files) will be created at the same time ).

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.