Q:linux系统下安装oracle数据库后,用命令启动监听,执行完成后有如下显示
提示“the listener supports no service”,监听无服务。
发生此种情况的原因是因为监听没有注册成功,可手动在监听配置文件中添加如下命令(监听配置文件位置:在oracle安装目录下/oracle/product/11.2.0/db_1/network/admin/下的listener.ora(见图中Listener Parameter File所在目录)):
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)