Windows配置监听
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= 10
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=(SID_NAME = PLSExtProc)(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)(PROGRAM = extproc)
)
(SID_DESC =(GLOBAL_DBNAME =orcl)(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)(SID_NAME=ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator\product\11.2.0\dbhome_1