(address = (protocol = ipc)(key = extproc1))
)
(connect_data =
(sid = plsextproc)
(presentation = ro)
)
)
sqlnet.ora文件为:
sqlnet.authentication_services= (nts)
names.directory_path= (hostname,tnsnames, onames)
在备用数据库配置listener.ora,tnsnames.ora和sqlnet.ora.配置后的文件内容分别如下:
其中配置sqlnet.ora文件中的参数sqlnet.expire_time是enable死连接侦测
listener =
(description_list =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc))
)
(address_list =
(address = (protocol = tcp)(host = 10.100.0.222)(port = 1521))
)
)
)
