操作系统:windows7X64
安装软件:oracle 11g
开始->程序->Net Manager
查看本地IP
修改主机为IP地址(否则局域网其他电脑不能访问)
打开services.msc启动监听服务
增加配置tnsnames.ora文件
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =172.27.35.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
常见错误:ORA-12514: TNS:listener does not currently know of service requested in connect
解决方案:
修改listener.ora文件为
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.27.35.8)(PORT = 1521))
)
)
至此,同一局域网的其他电脑就可以访问本地oracle服务器了