java.sql.SQLException

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Samebug tips1

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web526

  • via Unknown by Farouk.y,
  • Stack trace

    • java.sql.SQLException: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52) at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189) at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111) at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864) at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024) at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108) at java.lang.Thread.run(Thread.java:745)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    osvzsosvzs
    8 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    tomthomastomthomas
    Once,
    47 more bugmates