(CONNECT_DATA = (SID =orcl) (SERVER = DEDICATED) ) ) 2. 检查数据库服务器$ORACLEHOME/db_1/NETWORK/ADMIN目录中的listener.ora文件是否配置正确,如果这个文件配置错误是客户端是无论如何也无法连接到服务器的,如下是listener.ora的部分配置: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (P...
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 = (ADDRESS = ...
(CONNECT_DATA = (SID = orcl) (SERVER = DEDICATED) ) ) 2. 检查数据库服务器$ORACLEHOME/db_1/NETWORK/ADMIN目录中的listener.ora文件是否配置正确,如果这个文件配置错误是客户端是无论如何也无法连接到服务器的,如下是listener.ora的部分配置: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (A...
(CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) 2:打开运行 输入netca 回车 重新进行数据库的配置 具体的操作已截图 见相册里面图片; 3:配置完成后 把listener.ora文件里面的LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ...
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 giveninconnect descriptor 1. 2. 解决: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =10.1.1.1)(PORT =1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)(FAILOVER_MODE = (TY...
最近重新安装数据库后一直报一个错误,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)每个人的路径可能不一样...
今天突然想用另一台macbook中的sql developer 连接Oracle,于是就将虚拟机的联网方式改为了Bridge(桥接),并且重新配置了静态IP,启动Oracle监听后,sql develoer 连接时出现了Oracle Listener refused the connection with the following error:ORA-12505,TNS:listener does not currently know of SID given in connect ...