ORA-12505 TNS:listener does not currently know of SID given in connect descriptor

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
        at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
        at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:466)
        at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:154)
        at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:99)
        at bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(PoolingDataSource.java:255)
        at bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:264)
        at bitronix.tm.resource.common.XAPool.init(XAPool.java:51)
        at bitronix.tm.resource.common.XAPool.<init>(XAPool.java:46)
        at bitronix.tm.resource.jdbc.PoolingDataSource.buildXAPool(PoolingDataSource.java:66)
        at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:53)

        ... 32 more

解决方法:

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus/nolog

SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 9月 27 22:45:54 2011

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

SQL> conn bpm/bpm
已连接。

1、分析Oracle的启动过程，没有发现问题,以上启动过后，连接bpm用户的信息，说明数据库是没有问题。

2.打开Oracle的 listener.ora 文件。

原：

# listener.ora Network Configuration File: D:\DB\orcl\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\DB\orcl)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = HP-201105061049)(PORT = 1521))
      )
    )
  )

修改后:

# listener.ora Network Configuration File: D:\DB\orcl\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\DB\orcl)
      (PROGRAM = extproc)
    )

  )

(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\DB\orcl)
(SID_NAME = ORCL)
)
)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = HP-201105061049)(PORT = 1521))
      )
    )
  )

问题解决哈OK！