ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 4、反复测试Oracle服务端监听正常。 5、最后发现配置问题,改正为如下配置: ①spring.datasource.url = jdbc:oracle:thin:@//192.168.1.4:1521/orcl ②spring.datasource.url = jdbc:oracle:thin:@192.168.1.4:1521:orcl 以...
一、正确的链接字符串 "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.100)(PORT=1521))(CONNECT_DATA=(SID=ORACLE)));User Id=system;Password=sa;" --HOST=服务器IP地址, 如192.16.1.100 --SID= .Net Configuration Assistance-->本地Net服务器名配置-->添加-->服务名(即为该服务名...
) (CONNECT_DATA = (SID =orcl) (SERVER = DEDICATED) ) ) 2. 检查数据库服务器$ORACLEHOME/db_1/NETWORK/ADMIN目录中的listener.ora文件是否配置正确,如果这个文件配置错误是客户端是无论如何也无法连接到服务器的,如下是listener.ora的部分配置: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = ...
Error connecting to database: (using classracle.jdbc.driver.OracleDriver) Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 192.168.1.1:1521:bbcd ---解决...
遇到错误 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor 通常意味着Oracle数据库的网络监听器(Listener)无法识别客户端连接描述符中指定的服务标识符(SID)或服务名(Service Name)。以下是针对您提供的问题的一些具体解决步骤,我将分点回答并包含必要的说明和可能的代码片段(尽...
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=223.203.208.109)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=racstandby))) 来设置; 上面的是一种方法,但看起来很长,不美观啊. 解决: 获取数据库的sid:select INSTANCE_NAME from v$instance; ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.75)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))devdb= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.84)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(...
最近重新安装数据库后一直报一个错误,ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 现在终于解决了,现在把经验记录如下: 首先查看tnsnames.ora和listener.ora文件是否有问题。路径如下: (路径:D:\app\MYE\product\11.2.0\dbhome_1\NETWORK\ADMIN)每个人的路径可能不一样...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 4、反复测试Oracle服务端监听正常。5、最后发现配置问题，改正为如下配置：①spring.datasource.url = jdbc:oracle:thin:@//192.168.1.4:1521/orcl ②spring.datasource.url = jdbc:oracle:thin:@192.168.1.4:1521:orcl...
(CONNECT_DATA = (SID = orcl) (SERVER = DEDICATED) ) ) 2. 检查数据库服务器$ORACLEHOME/db_1/NETWORK/ADMIN目录中的listener.ora文件是否配置正确,如果这个文件配置错误是客户端是无论如何也无法连接到服务器的,如下是listener.ora的部分配置: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (...