Oracle Database Name, Instance name, database domain name, Database Service name, global database name details database name, Instance name, database domain name, Global Database Name, service name, this is a few confusing concepts for many
database name, instance name, database domain name, global database name , service name,This is a few concepts that make many beginners easily confused. I believe many beginners are as confused as I am in the title of these concepts. Let's get them
1. Database Name 1.1 The Concept Database Name (db_name) is the identifier of a database, just like the ID card number of a person. If multiple databases are installed on a machine, each database has a database name. After the database is installed
How to modify the Database Name (db_name) and Instance name (Instance_name or Service_name)
Nid is a tool provided by Oracle starting from 9iR2. It can be used to change the database name without the need to recreate the control file or other
How to modify the Database Name (db_name) and Instance name (Instance_name or Service_name)Nid is a tool provided by Oracle starting from 9iR2. It can be used to change the database name without the need to recreate the control file or other
In Linux: the default data file storage directory of MySQL is/var/lib/mysql. I want to do two things today: Change the Database Name (three methods are tested), and change the directory location of the MySQL database. Database rename: 1. rename
How to adjust instance settings after the computer is renamed
Author: Peng Fen Source: IT expert network
After the sqlserver database is deployed, it is suddenly found that the Host Name of the database server does not comply with the naming rules
1. method 1 (physical method ):
Change old database to new database
Open Enterprise Manager"
Right-click "Old Database" and choose "all tasks" to separate the database.
Find old_data.mdf and
Old_log.ldf
Replace old_data with the name you want, such
Information A
1, stop the database server, the database MDF files and LDF files copy backup a copy
2, start the database server, delete the suspect database
3, only with the backup of the database MDF file attached to the database,
1) database name DB_NAMEThe internal mark of the Oracle database. It also exists in the binary control file and parameter file pfile. Therefore, it cannot be modified after the database is installed.You can see it in pfile.DB_NAME = ora9i # ora9i
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.