oracle中的全局数据库名、环境变量和sid的区别(国外英文资料).docVIP

oracle中的全局数据库名、环境变量和sid的区别(国外英文资料) Database name (DB_NAME), instance name (Instance_name), and operating system environment variable (ORACLE_SID) In the ORACLE7 and 8 databases, there is only the database name (db_name) and the database instance name (instance_name). New parameters appear in ORACLE8i and 9i, that is, the database name (db_domain), the service name (service_name), and the operating system environment variable (ORACLE_SID). The identity that exists in the same database for distinguishing the parameters of different databases. What is the name of the database (db_name)? The database name is the internal identifier used to differentiate data, which is stored in binary in the database control file and will not be modified after the data is installed or created. When the database installation is complete, the parameter is written to the database parameter file pfile, as follows: [code:1:1aaf156970] ......... Db_name= orcl # (modifications) Db_domain= Instance_name=orcl Service_names= Control_file= (............... ......... [/code:1:1aaf156970] In each running ORACLE8i database, there is a database name (db_name). If two databases are created in a server program, there are two database names. The control parameter data belong to different pfile and control the related database. Two. What is the database instance name (instance_name)? The database instance name is used to communicate with the operating system for external connections. In the operating system, you must use the database instance name to obtain interaction with the database. For example, to connect with a server database, you must know the database instance, only know the name of the database is of no use, unlike the database name, after installing the data or create a database instance name can be modified. When the database installation is complete, the instance name is written to the database parameter file pfile. The format is as follows: [code:1:1aaf156970] Db_name= orcl # (modifications