TNS:listener does not currently know of service requested in connect descripto

简介

Oracle安装完成后,plsqldev连接报错；

检查

listener和tnsnames文件是否修改其监听IP端口号(服务器内网IP)，检查完毕后，并无发现问题；

修改

• 修改listener文件

修改前

复制SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\software\oracle\oracle19)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\software\oracle\oracle19\bin\oraclr19.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

修改后

复制SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\software\oracle\oracle19)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\software\oracle\oracle19\bin\oraclr19.dll")
    )
   (SID_DESC = 
        (GLOBAL_DBNAME = orcl)
        (ORACLE_HOME = C:\software\oracle\oracle19)
        (SID_NAME = orcl)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

• 停止监听服务
  lsnrctl stop
• 启动监听服务
  lsnrctl start