1,首先配置监听
[oracle@weidb admin]$ cat listener.ora
(SID_DESC =
(SID_NAME = weidb)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
否则报ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务
删除 (PROGRAM = extproc) 否则报错
ORA-28547: 连接服务器失败,可能是NET8管理错误
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.128)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
2,开启动虚拟机的监听
lsnrctl start
3,本机安装oracle .并配置监听 ner manager
4,进行测试连接,调试
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15187685/viewspace-755697/ ,如需转载,请注明出处,否则将追究法律责任。