Oracle 中极易混淆的几个 NAME 的分析和总结 - 数据库编程

，而对于单实例数据库而言，默认与SID和INSTANCE_NAME是一致的，当然，也可以不一致(有DB_DOMAIN的情况下)，DBCA的时候可以选择，通常这3个参数在DBCA的时候确认下来后，就基本不再去修改了，那么数据文件路径也就确定下来了，如我的环境中：

数据文件就放在/u01/app/oracle/oradata/zlm下面

而跟踪日志就放在/u01/app/oracle/admin/zlm/bdump下面

过了片刻以后，再查看监听状态，发现自动还是会去动态注册一个和INSTANCE_NAME(SID)一致的SERVICE_NAME

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.91)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "zlm" has 1 instance(s).
Instance "zlm", status READY, has 1 handler(s) for this service...
Service "zlmXDB" has 1 instance(s).
Instance "zlm", status READY, has 1 handler(s) for this service...
Service "zlm_SN" has 1 instance(s).
Instance "zlm", status UNKNOWN, has 1 handler(s) for this service...
Service "zlm_XPT" has 1 instance(s).
Instance "zlm", status READY, has 1 handler(s) for this service...
The command completed successfully

这样的话，我个人判断，如果不配置静态监听的话，pmon进程始终会去监听那里注册一个名字和INSTANCE_NAME(SID)一致的SERVICE_NAME，即便是已经在tnsnames.ora中修改了SERVICE_NAME=zlm_SN，而只有通过静态监听强制注册一个与INSTANCE_NAME(SID)不一致的SERVICE_NAME，才会被监听到

Oracle 中极易混淆的几个 NAME 的分析和总结(二)