Oracle 配置远程访问教程
服务端配置
如果不想自己写,可以通过NetManager来配置.
以下配置文件中的localhost改为ip地址,否则,远程不能访问.
1.网络监听配置
#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=IPC)(KEY=EXTPROC1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) ) ) ADR_BASE_LISTENER=C:\app\Administrator
多个IP时,如下:
LISTENER= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)) ) (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=172.24.226.2)(PORT=1521)) ) (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=172.24.226.3)(PORT=1521)) ) )
2.TNS配置
#tnsnames.oraNetworkConfigurationFile:C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora #GeneratedbyOracleconfigurationtools. ORCL= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=orcl) ) ) ORACLR_CONNECTION_DATA= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)) ) (CONNECT_DATA= (SID=CLRExtProc) (PRESENTATION=RO) ) ) LISTENER_ORCL= (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
多个IP时,如下:
ORCL= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=172.24.226.2)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=172.24.226.3)(PORT=1521)) ) (SOURCE_ROUTE=yes) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=orcl) ) )
3.停止和启动服务
先停止以下服务,然后再启动.
OracleOraDb11g_homeTNSListener OracleService*
客户端配置
1.下载ODAC压缩包.
2.解压下载的ODAC压缩包.
3.执行安装命令
示例:
install.batallD:\Program\ODAC\12040x64OracleHometrue
4.添加环境变量
ORACLE_HOME:是ODAC安装的目录.
TNS_ADMIN:是文件tnsnames.ora所在的目录,一般为ODAC安装目录下的network\admin中.
注:TNS_ADMIN可以不用添加,直接将tnsnames.ora文件复制到ODAC安装目录下即可
将%ORACLE_HOME%添加到PATH环境变量中.
5.配置TNS
在配置文件tnsnames.ora中加入
DBORCL= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME= ) ) )
说明:
总结
以上所述是小编给大家介绍的Oracle配置远程访问教程,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!