驗證service_names、db_name、db_unique_name在註冊動態監聽服務名時的作用
監聽中動態註冊時的服務名:如果沒有設定service_names,將拼接db_unique_name和db_domain引數值來註冊監聽,(service_names優先順序高),驗證如下:。
----(很多文件裡寫的是db_name和db_domain這是不準確的)
本實驗的db_domain為空。Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
- db_unique_name為PRODA db_name 為PROD service_names 為空--reset引數值 監聽狀態中有一個服務PRODA
- db_unique_name為PRODA db_name 為PROD service_names 為PRO 監聽狀態中有兩個服務 PRODA PRO
- db_unique_name為PROD db_name 為PROD service_names 為PRO 監聽狀態中有兩個服務PROD PRO
1.db_unique_name為PRODA,db_name 為PROD,service_names 為空--reset引數值,監聽狀態中有一個服務:PRODA
SQL> show parameter service_nameNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string
SQL> show parameter db_unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string PRODA
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string PROD
SQL> show parameter db_doma
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
[oracle@ocm1 admin]$ lsnrctl status LSNR2
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-APR-2014 23:36:38
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.bys.com)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LSNR2
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 09-APR-2014 23:31:20
Uptime 0 days 0 hr. 5 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0.1/dbhome_1/network/log/lsnr2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.bys.com)(PORT=1526)))
Services Summary...
Service "PRODA" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service.
2.db_unique_name為PRODA,db_name 為PROD,service_names 為PRO,監聽狀態中有兩個服務:PRODA、PRO
SQL> show parameter db_uniNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string PRODA
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string PRO
SQL> show parameter db_n
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string PROD
SQL> show parameter db_do
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
[oracle@ocm1 admin]$ lsnrctl status LSNR2
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-APR-2014 23:51:30
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.bys.com)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LSNR2
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 09-APR-2014 23:48:39
Uptime 0 days 0 hr. 2 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0.1/dbhome_1/network/log/lsnr2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.bys.com)(PORT=1526)))
Services Summary...
Service "PRO" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PRODA" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PRODA_XPT" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully
3.db_unique_name為PROD,db_name 為PROD,service_names 為PRO,監聽狀態中有兩個服務:PROD、PRO
SQL> show parameter db_domaNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
SQL> show parameter db_uni
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string PROD
SQL> show parameter db_n
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string PROD
SQL> alter system set service_names='PRO';
System altered.
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string PRO
SQL> alter system register;
System altered.
[oracle@ocm1 admin]$ lsnrctl status LSNR2
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-APR-2014 23:48:52
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.bys.com)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LSNR2
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 09-APR-2014 23:48:39
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0.1/dbhome_1/network/log/lsnr2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.bys.com)(PORT=1526)))
Services Summary...
Service "PRO" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
Instance "PROD", status READY, has 4 handler(s) for this service...
The command completed successfully
相關文章
- oracle 監聽器動態與靜態註冊服務_listenerOracle
- 監聽動態註冊
- 動態註冊監聽
- 動態監聽註冊
- 【監聽】動態註冊和靜態註冊
- Oracle監聽的靜態註冊和動態註冊Oracle
- Oracle監聽的動態註冊與靜態註冊Oracle
- rac監聽動態註冊
- 動態註冊監聽Listener
- Oracle 動態監聽註冊Oracle
- oracle監聽靜態註冊和動態註冊Oracle
- oracle監聽動態註冊與靜態註冊Oracle
- rac監聽不能動態註冊
- oracle監聽動態註冊與靜態註冊[轉帖]Oracle
- 【原創】Oracle的動態監聽註冊Oracle
- oracle監聽器動態註冊於靜態註冊的區別Oracle
- Oracle動態監聽註冊測試Oracle
- HPUX 監聽無法動態註冊UX
- 【監聽】配置服務端靜態(動態)監聽/修改監聽埠及引數local_listener作用服務端
- ORACLE 動態註冊,靜態註冊,多個監聽,一個監聽多個埠配置Oracle
- oracle監聽器的靜態和動態註冊Oracle
- oracle監聽之動態和靜態註冊Oracle
- 動態和靜態監聽註冊-小魚的理解
- Oracle9i中的監聽動態註冊Oracle
- oracle監聽【非1521埠】動態註冊Oracle
- 轉載:oracle監聽器的靜態和動態註冊Oracle
- Oracle監聽器的靜態註冊與動態註冊,以及DB_DOMAIN問題OracleAI
- 理解Oracle9i中的監聽動態註冊Oracle
- Oracle 靜態監聽註冊詳解Oracle
- Oracle修改instance_name、db_name、db_unique_name、service_namesOracle
- 理解Oracle9i中的監聽動態註冊(zt)Oracle
- 聊聊跟蹤監聽器動態註冊(Dynamic Register)方法
- 【LISTENER】修改 LISTENER的監聽埠為1526(動態註冊)
- 同時配置動態監聽與靜態監聽
- Oracle 19C 監聽無法動態註冊例項Oracle
- oracle10.2.0.4 動態註冊監聽配置_摘自小荷Oracle
- 資料庫無法註冊至監聽服務解決辦法資料庫
- srvctl新增新的監聽和埠並靜態註冊