Database Name (DB_NAME), database instance name (instance_name), operating system environment variable Oracle_sid, database service name (service_name), database domain name (db_domain), global database name (global_db_name) is a concept that is easily confused using Oracle database. -------------------------------------------------- -------------------------------- from: http://www.itpub.net/showthread.php? S = & threadid = 1691581, database name and instance name × Database name (DB_NAME): is the internal identifier of distinguishing data (ie, is used inside the Oracle database) because it saves more in the database and saving in the control file is binary. So it is difficult to change its name (it is not ok, I originally designed the database, it's also to change it), there is a db_name parameter in the PFILE is it. Database name: Internal tag, use database name when database installation, creation, creation control file, modify the database structure, use database backup and recovery (note these time nothing SID ...), such as Alter Database, is used This value looks: you can see the parameters (multiple methods, show parameter db_name, etc.) or check the V $ Database view to modify the database name:, × instance name instance name (instance_name): Contact between operating system (external Connection use), a database can have multiple instances (parallel service). To connect with a database server, you must know that it is unique, and the light knows that the database name is useless. There is instance_name parameters in the PFile, in fact, the general settings are the same as the database name (different is self-found, you can easily change this parameter) View: See parameter instance_name and Oralce_SID Difference: Both index, but oracle_sid is The environment variable setting of the operating system is used to interact with the operating system, and the value must be the same as instance_name, and instance_name can be found in the parameter file (explain white) (in 2000, you need to pay attention to the registry definition modification related parameters That is, oracle_sid) In the network service configuration (the old protocol is not said), there is an option in Net8i that is the SID configuration means the ORARCE_SID name! (9i's new service configuration is described later) 2, the database domain name and service name (8i version introduced by the name) × Database Domain Name: Similar network domain names, (so a database name DB_NAME can be the same in different fields) Determine when installation (filled in the global database name), the definition rule is similar to the network definition.
