Win Oracle 监听文件配置参考代码实例
这篇文章主要介绍了WinOracle监听文件配置参考代码实例,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
Winlister.ora配置参考
#listener.oraNetworkConfigurationFile:C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora #GeneratedbyOracleconfigurationtools. SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=CLRExtProc) (ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM=extproc) (ENVS="EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.125.134)(PORT=1521)) ) (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)) ) ) ADR_BASE_LISTENER=C:\app\Administrator
Wintsnames.ora配置参考
#tnsnames.oraNetworkConfigurationFile:C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora #GeneratedbyOracleconfigurationtools. LISTENER_ORCL= (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) ORACLR_CONNECTION_DATA= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)) ) (CONNECT_DATA= (SID=CLRExtProc) (PRESENTATION=RO) ) ) ORCL= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.125.134)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=WIN-LOPIL4J1KK4)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=orcl) ) )
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。