刚安装好的oracle11.2本地能登陆远程连接却报错12541,这种报错经常出现,有很多原因
我的报错原因是配置问题,以下是我的解决步骤:
1.首先确定防火墙是否拦截了1521端口,我就关闭了防火墙,之后再开吧
2.看监听是否开启,使用以下命令
lsnrctl status
如果未启动,可以使用以下命令启动监听程序:
lsnrctl start
3.找到~11.2.0\dbhome_1\network\admin\listener.ora文件
配置实例名,如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)
其中一般新安装的oracle没有以下配置需要加上
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
还要将localhost改为计算机名
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-9P01CDVFA1P)(PORT = 1521))
)
)
整个文件如下
4.然后重启相关oracle服务
OracleOraDb11g_home1ClrAgent、OracleOraDb11g_home1TNSListener
5.plsql就可以如下连接成功