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
Database Name (db_name), Instance name (instance_name), and operating system environment variable (oracle_sid)
In oracle7 and 8 databases, only the Database Name (db_name) and database instance name (instance_name) are available ). A new parameter
Http://chinaunix.net/jh/19/348162.html
Recently, some people in the Forum asked about this issue and sorted out their understanding and relevant materials as follows. If not all or improperly, I hope to correct and complete it.
Database Name (db_
Database Name (db_name), Instance name (instance_name), oracle_sidRecently, some people in the Forum asked about this issue and sorted out their understanding and relevant materials as follows. If not all or improperly, I hope to correct and
I. Database Name1. Concept of Database Name
The Database Name (db_name) is the ID of a database, just like the ID card number of a person. If a machine is installed with multiple full databases, each database has a database name. After the database
Directory
Introduction to Directory Software Environment install Oracle Listener start stop listener CREATE database database name db_name database instance name instance_name database name and instance name the relational operating system
Database Name, Instance name, ORACLE_SID, database domain name, Global Database Name, service name database name, Instance name, database domain name, Global Database Name, service name,
This is a few confusing concepts for many beginners. I believe
Guidance:
Recently, some people in the Forum asked about this issue and sorted out their understanding and relevant materials as follows. If not all or improperly, I hope to correct and complete it.
Database Name (db_name), Instance name
Database name (db_name), instance name (instance_name), and operating system environment variables (ORACLE_SID)Only the database name (db_name) and the database instance name (instance_name) are in the ORACLE7, 8 database. A new parameter, the
Create an Oracle database
Create an Oracle database (taking Oracle10g as an example)
There are two ways to create a database: one is to create a database manually using a command line script; the other is to create a database using the Database
For beginners, 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_name ).
Oh, you
Oracle databases, instances, users, tablespaces, and tables
1. Database
A database is a collection of data. Oracle is a database management system and a relational database management system.
Generally, the "Database" refers to not only physical
I. Database Name
1. Concept of Database Name
The Database Name (db_name) is the ID of a database, just like the ID card number of a person. If a machine is installed with multiple full databases, each database has a database name. After the database
1. Create groups and users
In linux, open the terminal and log on as the root user. Enter the following command:
Groupadd dba // Add the dba group useradd-g dba-m oracle // Add the username as oracle and add the user to the dba group passwd oracle /
Show Parameter Service_names
Select instance_name from V$instance;
Db_name is a real physical name. Service_Name with a domain name, because if two databases no longer have the same name as the same domain. The SID is the instance name of the
Reprinted from:The difference between db_name,sid,db_domain,service_name and so on in OracleDb_name: A unique identifier for a database (Oracle db). This representation is sufficient for a single database, but with the popularization of a
The layer-3 instance indicates the login function of the charging system of the data center. After SQLServer2008 is installed, the instance cannot be connected. Neither sa account nor windows authentication can be used to log on to SQLServer2008.
Show parameter service_names
select instance_name from v$instance;
Db_name is a real physical name. SERVICE_NAME carries the domain name, because if the two databases do not have the same domain, they can have the same name. The SID is the
Create an Oracle database (taking Oracle10g as an example)There are two ways to create a database: one is to create a database manually using a command line script; the other is to create a database using the Database Configuration Wizard provided
Database name (db_name), instance name (instance_name), and operating system environment variables (ORACLE_SID) only database name (db_name) and DB instance name (Instance_) in ORACLE7, 8 database Name). A new parameter, the database domain name
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.