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.(PhysicalConnection.java:531)

 

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)

 

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

 

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

 

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:298)

 

at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

 

at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

 

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:81)

 

at org.eclipse.datatools.enablement.internal.oracle.JDBCOracleConnectionFactory.createConnection(JDBCOracleConnectionFactory.java:27)

 

at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

 

at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

 

at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

 

at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

 

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

 

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:

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

 

 

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)

 

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)

 

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)

 

... 14 more

 

 

핑 테스트시 뜨는 에러 입니다. 오라클은 11g 쓰고있고요. 

 

tnsnames.ora 설정은 이렇습니다.

 

 

# Generated by Oracle configuration tools.

 

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = orcl)

      (PRESENTATION = RO)

    )

  )

 

ORCL =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

 

 

학원에서 수업중인데 잘되다가 갑자기 안되네요.. ㅠㅠ