Determining the Global Database Name (86)
The global database name consists of the user-specified local database name and the
location of the database within a network structure. The DB_NAME initialization
parameter determines the local name component of the database name, and the
DB_DOMAIN parameter indicates the domain (logical location) within a network
structure. The combination of the settings for these two parameters must form a
database name that is unique within a network.
For example, to create a database with a global database name of
test.us.acme.com, edit the parameters of the new parameter file as follows:
DB_NAME = test
DB_DOMAIN = us.acme.com
You can rename the GLOBAL_NAME of your database using the ALTER DATABASE
RENAME GLOBAL_NAME statement. However, you must also shut down and restart the
database after first changing the DB_NAME and DB_DOMAIN initialization parameters
and re-creating the control file.
全域性資料庫名稱
1. 由使用者指定的本地資料庫名稱(DB_NAME)和資料庫在網路中的位置(DB_DOMAIN)組成
這兩個引數的組合在網路中必須唯一
2. 可使用 ALTER DATABASE RENAME GLOBAL_NAME 語句來改變 GLOBAL_NAME .
但是需要關閉並重啟資料庫 , 並重建空間檔案
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995838/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle identifiers :Global database nameOracleIDEDatabase
- Determining Whether Global Naming Is Enforced 未解決?
- 更改Global_name, domain_name, db_name 的方法AI
- DB_NAME&TANCE_NAME&DB_UNIQUE_NAME&ORACLE_SID&GLOBAL_NAME&DB_DOMAIN&SERVICE_NAMEOracleAI
- db_name,db_domain, global_name, service_name的區別AI
- 11gR2 DBCA建立資料庫global database name長度及db_name長度限制8位問題資料庫Database
- Oracle identifiers :Database NameOracleIDEDatabase
- oracle 檢視和修改global_name 的方法Oracle
- [轉]ORACLE中的DB_NAME,SERVICE_NAME,INSTANCE_NAME,ORACLE_SID,GLOBAL_DBNAMEOracle
- ORACL中的DB_NAME,SERVICE_NAME,INSTANCE_NAME,ORACLE_SID,GLOBAL_DBNAME介紹Oracle
- ORACLE中的DB_NAME,SERVICE_NAME,INSTANCE_NAME,ORACLE_SID,GLOBAL_DBNAME介紹Oracle
- oracle中instance name 和database name的一點體會OracleDatabase
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- Fiori Elements List Report table 裡的普通按鈕,Global 按鈕 和 Determining 按鈕
- RMAN 6217 not connected to auxiliary database with a net service nameUXDatabase
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- SID、ORACLE_SID、INSTANCE_NAME、DB_NAME、SERVER_NAMES、GLOBAL_DBNAME等區別OracleServer
- [20170526]GLOBAL_NAME為NULL的修復2.txtNull
- How to Rename Database/Change DB_NAME or ORACLE_SID/Instance Name-15390.1DatabaseOracle
- RMAN-20005: target database name is ambiguousDatabase
- To use Rman to duplicate database be careful of db_file_name_convertDatabase
- 建立資料庫連結dblink 與 global_name 設定的關係資料庫
- Certification Information for Oracle Database on Linux x86-64 [ID 1304727.1]ORMOracleDatabaseLinux
- 【ORA-02011】duplicate database link nameDatabase
- ORA-01103: database name 'ORCLDG' in control file is not 'ORCL'Database
- [20121010]global_name為空的恢復-bbed學習.txt
- VMWare虛擬機器啟動報錯:“無法開啟核心裝置:\\Global\\vmx86”虛擬機
- Win 10 啟動VM中Ubuntu時報錯:無法開啟核心裝置“\\.\Global\vmx86”Ubuntu
- vmware無法開啟核心裝置“\\.\Global\vmx86”: 系統找不到指定的檔案
- 【DBLINK】DBLINK域名問題及與global_name和db_domian的關係
- [20121011]global_name為空的恢復(new)-bbed學習.txt
- ora-02085的解決:Database Link與GLOBAL_NAMES引數Database
- 關於db_name,oracle_sid,service_names,global_names等的總結說明Oracle
- SCSS !globalCSS
- Installing Oracle Database 10g Release 2 on Linux x86OracleDatabaseLinux
- error: '[class name]' does not name a typeError
- JavaScript Global 物件JavaScript物件
- Global Nonpartitioned IndexesIndex