摘要:
SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB202) (SID_NAME = DB202) ))LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.202)(PORT = 1521)) ) )ADR_BASE_LISTENER = /u01 阅读全文
摘要:
安装环境:CentOS 6.3 64位Oracle 11gR2 x86_x64问题描述:Oracle启动监听报错:The listener supports no services解决办法:在listener.ora文件中添加SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB202) (SID_NAME = DB202) ))注意:DB202是数据库的SID,需要根据自己环境,来修改;附言:查看数据库Service Name 的方法$sqlplus / as sysdbaSQL>show ... 阅读全文