Shulou(Shulou.com)06/01 Report--

The meaning of several name of oracle

Db_name:

Database name: show parameter db_name,db_name also plays a very important role in dynamic registration listening, regardless of whether service_name is specified, or what the value of service_name is, pmon will use db_name dynamic registration listening.

Instance_name: instance name, show parameter instance_name, used for dynamic monitoring

Global_name: global database name show parameter global_name

Global_names: is a property to see if show parameter global_names is open

Server_names: dynamic monitoring related to show parameter server_name

Db_domain: database domain name show parameter db_domain

Example:

Orcl.localdomain

Dn_name = orcl

Db_domain = localdomain

Server_name = orcl.localdomain

Global_name = orcl.localdomain

Service_name defaults to global_name.

Query global_name

Select * from global_name

Modify global_name

Alter database rename global_name to orcl

Update global_name set global_name = 'orcl'

Commit

But modified, global_name will not change server_name by default, nor will it modify db_domain by default

So modify the db_domain

Alter system set db_domain='' scope=spfile

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.