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
Reference: http://www.zhetao.com/content240In real-world development applications, about Oracle databases, it is often heard that a database is created, a instance is created, and a instance is started.Actually ask them what is the database, what is
In real-world development applications, about Oracle databases, it is often heard that a database is created, a instance is created, and a instance is started.Actually ask them what is the database, what is instance, most likely they give the answer
First, the database nameWhat is a database name?The database name is the identity of a database, just like a person's ID number. He uses parameter db_name to indicate that if a machine is loaded with multiple databases, then each database has a
1. The database name is the internal identifier of the Oracle database. It should not be changed after installation. Many physical storage directories of the database use the database name.
2. instance_name, oracle_sid, and database instance name
Method 1: Use the script that comes with oracle to start and close... 1
1. oracle user modify the/etc/oratab file:... 1
2. oracle users modify the $ ORACLE_HOME/bin/dbstart file:... 1
3. Test and run dbshut and dbstart 1.
3.1. Execute the
Yesterday, a colleague reported that when Oracle9i was used, the service name was successfully configured in the net assistant, but it was always unable to connect when SQL * Plus and other client tools were used.
· First, check whether the service
Turn https://oracle-base.com/articles/vm/oracle-cloud-database-as-a-service-dbaas-create-service?utm_source= Tuicool&utm_medium=referralOracle Cloud:database as a service (DBaaS)-Create ServiceThis article provides a run through of creating a new
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC
The following operating environment is in CentOS6.4 + Oracle11gR2 (Oracle is installed in ORACLE_BASEoptoracle, and ORACLE_HOMEoptoracle11g ).
The following operating environment is in CentOS 6.4 + Oracle 11gR2 (Oracle is installed in ORACLE_BASE
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.