包含java12505的词条

本篇文章给大家谈谈java12505，以及对应的知识点，希望对各位有所帮助，不要忘了收藏本站喔。

本文目录一览：

• 1、Java连接Oracle11g的时候提示ORA-12505
• 2、新手求助！java初次连接oracle，ora12505错误，两天了没解决
• 3、java在使用DBCP数据库连接池时出现下列错误怎样解决，求大神解答
• 4、java连接数据库ORA-12505错误，百度的各种方法都试了，没有解决
• 5、java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:lis
• 6、Java连接oracle异常(error:ORA-12505)！

Java连接Oracle11g的时候提示ORA-12505

1.在oracle目录下查找listener.ora文件,修改成如下格式的：

# listener.ora Network Configuration File: D:\oracle10g\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle10g)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = D:\oracle10g)

(SID_NAME = orcl)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

)

新手求助！java初次连接oracle，ora12505错误，两天了没解决

进入 cmd

lsnrctl status

lsnrctl status LISTENER_ORCL

给出输出

java在使用DBCP数据库连接池时出现下列错误怎样解决，求大神解答

这里报错的可能性在于配置文件中的jdbc.url=jdbc:oracle:thin:@localhost:1521:oracl的oracl不是Oracle数据库的SID，数据库的SID是orcl，所以会报这个错，可以通过服务查看Oracle的SID进行核对

java连接数据库ORA-12505错误，百度的各种方法都试了，没有解决

[oracle@mlab2 ~]$ oerr ora 12505

12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"

// *Cause: The listener received a request to establish a connection to a

// database or other service. The connect descriptor received by the listener

// specified a SID for an instance (usually a database instance) that either

// has not yet dynamically registered with the listener or has not been

// statically configured for the listener. This may be a temporary condition

// such as after the listener has started, but before the database instance

// has registered with the listener.

// *Action:

// - Wait a moment and try to connect a second time.

// - Check which instances are currently known by the listener by executing:

// lsnrctl services listener name

// - Check that the SID parameter in the connect descriptor specifies

// an instance known by the listener.

// - Check for an event in the listener.log file.

进程 cmd 输入

sqlplus / as sysdba

select status from v$instance;

exit;

lsnrctl status

给出完整输出

java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:lis

这是计算机数据库问题，翻译成中文也没用，可以到计算机数据库分类里提问。java与数据库连接问题。jdbc提供了java与数据库的连接方法，具体问题还是找数据库专家提问吧

Java连接oracle异常(error:ORA-12505)！

打开你的服务，然后看看oracle的listener启动正常吗，刷新一下。

然后确认一下你的服务里的oracle的sid是叫这个名字？

从报错信息看，jbitdb写错了

关于java12505和的介绍到此就结束了，不知道你从中找到你需要的信息了吗 ？如果你还想了解更多这方面的信息，记得收藏关注本站。