oracle service_name参数,彻底理解初始化参数SERVICE_NAMES和客户端TNS中的SERVICE_NAME

彻底理解初始化参数SERVICE_NAMES和客户端TNS中SERVICE_NAME

Author：husthxd

msn：husthxd@hotmail.com

1.        SERVICE_NAMES与LISTENER

初始化参数SERVICE_NAMES默认为db_name.db_dimain，后台进程PMON自动在服务器监听器中注册该SERVICE_NAMES。实验如下：

sidb@GDSI-HYQL> show parameter service_

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

service_names                        string      simis

sidb@GDSI-HYQL> show parameter instance_name

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

instance_name                        string      simis

首先监听器配置文件手工配置了数据库服务，listener.ora的配置信息为：

# LISTENER.ORA Network Configuration File: D:\oracle\ora90\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = sb-hyk)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle\ora90)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = simis)

(ORACLE_HOME = D:\oracle\ora90)

(SID_NAME =