unknow:静态注册
ready或blocked:动态注册
a、如果先启动监听,后启动数据库
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
从显示信息可以看出这种情况下既有动态注册又有静态注册
(Service "PLSExtProc" 是在 listener.ora 文件中为数据库实例缺省配置的,允许PL/SQL包访问外部程序;
Service "orcl" 也是在 listener.ora 文件中配置,是每个数据库连接使用的标准模式;
Service "orclXDB" 是Oracle 9i以后版本创建数据库