Oracle服务器配置监听问题记录
配置listener.ora
启动监听后报错:指定监听器名称的地址不正确
从新尝试更改host
依然是同样错误
尝试括号跨行,依然同样错误
然后直接网上找了个模板,一模一样复制了进去,修改了下host,感觉跟我第一次的区别不大。
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ************)(PORT = 1521))
)
)
然后提示no services
尝试添加静态监听
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =172.20.44.50)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /oracle/product/11.2.0.4/db)
(SID_NAME = orcl)
)
)
最后配置成功
总结:
- 配置listener.ora,格式会影响到配置结果,实在不行拷贝网上模板尝试吧(我的是检查过各种格式问题,最后复制了一个网络上的模板竟然行了。。。模板文中已给出)
- 动态监听出现no services加静态监听
- host地址就是oracle服务器地址
- ORACLE_HOME 静态地址配置文件路径一般在/oracle/product/版本号/db/
- SID_NAME 服务器实例名,可以dba权限登陆oracle进去查看
SQL> select INSTANCE_NAME from v$instance;