Jump to content
We've recently updated our Privacy Statement, available here ×

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


bhuvaneshwari.m

Recommended Posts

From Ireporter If i try to add the data source, I am getting  the following error:


Exception
 

Message:
    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
 
Level:
    SEVERE
Stack Trace:
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
    oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
    oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
    oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:449)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:688)
    java.awt.EventQueue$3.run(EventQueue.java:686)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:702)
    java.awt.EventQueue$4.run(EventQueue.java:700)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
    java.awt.Dialog.show(Dialog.java:1082)
    java.awt.Component.show(Component.java:1651)
    java.awt.Component.setVisible(Component.java:1603)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonNewParameterActionPerformed(ConnectionsDialog.java:578)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$400(ConnectionsDialog.java:47)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$7.actionPerformed(ConnectionsDialog.java:221)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:688)
    java.awt.EventQueue$3.run(EventQueue.java:686)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:702)
    java.awt.EventQueue$4.run(EventQueue.java:700)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
    java.awt.Dialog.show(Dialog.java:1082)
    java.awt.Component.show(Component.java:1651)
    java.awt.Component.setVisible(Component.java:1603)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651)
    com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46)
    org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118)
    org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77)
    org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:688)
    java.awt.EventQueue$3.run(EventQueue.java:686)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:702)
    java.awt.EventQueue$4.run(EventQueue.java:700)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
    java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    oracle.net.ns.NSProtocol.connect(NSProtocol.java:386)
    oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
    oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
    oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
    oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
    oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:449)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:688)
    java.awt.EventQueue$3.run(EventQueue.java:686)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:702)
    java.awt.EventQueue$4.run(EventQueue.java:700)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
    java.awt.Dialog.show(Dialog.java:1082)
    java.awt.Component.show(Component.java:1651)
    java.awt.Component.setVisible(Component.java:1603)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonNewParameterActionPerformed(ConnectionsDialog.java:578)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$400(ConnectionsDialog.java:47)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$7.actionPerformed(ConnectionsDialog.java:221)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:688)
    java.awt.EventQueue$3.run(EventQueue.java:686)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:702)
    java.awt.EventQueue$4.run(EventQueue.java:700)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
    java.awt.Dialog.show(Dialog.java:1082)
    java.awt.Component.show(Component.java:1651)
    java.awt.Component.setVisible(Component.java:1603)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651)
    com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46)
    org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118)
    org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77)
    org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:688)
    java.awt.EventQueue$3.run(EventQueue.java:686)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:702)
    java.awt.EventQueue$4.run(EventQueue.java:700)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
    java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

 

 

I checked all the connection parameters, and connected to my db from jasperreports server, sql developer, and tnsping also .

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...