Oracle のリスナーの動的サービス登録の動作イメージを妄想 - ablog の補足。
- LOCAL_LISTENERのデフォルト値
(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(hostnameはローカル・ホストのネットワーク名)
- 手動で動的サービス登録する方法
alter system register;
- lsnrctl services で確認すると、静的登録の場合は UNKNOWN、動的登録の場合、READY になる。
- 静的登録の場合
$ lsnrctl services (中略) Service "orcl" has 1 instance(s). Instance "matrix", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER The command completed successfully
-
- 動的登録の場合
$ lsnrctl services (中略) Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Service "orcl_XPT" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER The command completed successfully
[参考]
http://otndnld.oracle.co.jp/document/products/oracle11g/111/doc_dvd/server.111/E05771-03/initparams.htm#87426
プロとしてのOracleアーキテクチャ入門 Oracle現場主義