修改本地配置远程连接oracle数据库
时间:2021-07-01 10:21:17
帮助过:15人阅读
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.41.1.21)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = matedb) ) )
2、监听本地ip有两种方法
(1)在\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora 文件中监听本地ip
# listener.ora Network Configuration File: E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.88.220)(PORT = 1521)) ) )
ADR_BASE_LISTENER = E:\oracle
|
|
(2)在菜单栏找到Net Manager 点击进入
如下图添加新的监听器监听本地ip
修改本地配置远程连接oracle数据库
标签:个人 sid com back 换行 pre add file dbn