由global_name引发的问题:
着重理解一下他的结论:
数据库域名与数据库全局名称相关,可以通过修改数据库全局名达到修改数据库域名的目的;
如果在sqlnet.ora中设置了默认域名则需要在tns中设置与DEFAULT_DOMAIN一致或不一致的域名。为避免不必要的麻烦,最好DEFAULT_DOMAIN要么在sqlnet.ora和tnsnames.ora中同时出现,要么同时不出现。
itpub论坛上的回复:
1.用来唯一确定一个数据库的,因为同一个网络中的多个数据库SID可能相同,通过全局数据库名就可以区分开这些数据库 确定数据库
2.通常是不用的,但在高级复制,stream复制等环境中是需要的,
也就是说如果你的参数global_names=true时,并创建了db link,
这时global_name就必须与db_name一致,否则,db_link将会报错. db_linke问题
3.
The global database name is the unique name of the database. In a distributed database system (a set of databases stored on multiple computers that typically appears to applications as a single database) the global database name ensures that each database is distinct from all other databases in the system.
Oracle forms a database's global database name by prefixing the database's network domain with the individual database's name. For example: sales.us.oracle.com and sales.uk.oracle.com.
The global database name defaults to DB_NAME.DB_DOMAIN and this value is marked at database creation time. If you change the DB_NAME or DB_DOMAIN after the database has been created, the value for the global database name (GLOBAL_NAME) will not change.
阅读(446) | 评论(0) | 转发(0) |