Oracle连接失败，ORA-12514, TNS:listener does not currently know of service requested in connect descripto

问题描述

在Window上搭建Oracle数据库，安装后启动，使用Dbeaver连接时无法连接，报错：Listenerrefusedtheconnectionwiththefollowingerror:
ORA-12514,TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

Listenerrefusedtheconnectionwiththefollowingerror:
ORA-12514,TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

Listenerrefusedtheconnectionwiththefollowingerror:
ORA-12514,TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

问题分析

Oracle数据库配置文件问题

解决办法

1.找到Oracle安装的路径，找到NETWORK >> ADMIN下的listener.ora文件