您好,登錄后才能下訂單哦!
同一個主機的同一個數(shù)據(jù)庫,只能有一個監(jiān)聽器,我們所配置多個監(jiān)聽器時,它會監(jiān)聽另外一臺主機上的數(shù)據(jù)庫,但這樣性能不好。
listener.ora配置文件講解:
監(jiān)聽器部分:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL = IPC) (KEY=EXTPRO1))
(ADDRESS=(PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
)
數(shù)據(jù)庫配置部分:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.localdomain)
(ORACLE_HOME = /opt/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl )
)
)
tnsname.ora配置文件
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl.localdomain)
)
service_name 默認就是global_name.
查詢global_name
select * from global_name;
修改global_name
alter database rename global_name to orcl;
update global_name set global_name = 'orcl';
commit;
但是修改了、global_name并不會默認改掉server_name,也不會默認修改db_domain;
因此修改db_domain
alter system set db_domain='' scope=spfile;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。