java.sql.SQLException: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Oracle Community | 2670946 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ODI :java.sql.SQLException: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

    Oracle Community | 2 years ago | 2670946
    java.sql.SQLException: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  2. 0

    ODI Session failling with error SQLException: ORA-12154 in ODI 12c

    Oracle Community | 3 years ago | user1175240
    java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified
  3. 0

    HELP WITH ODI 12c

    Oracle Community | 12 months ago | Farouk.y
    java.sql.SQLException: ORA-12801: erreur signalée dans le serveur de requête parallèle P000 ORA-01722: Nombre non valide
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Getting started 12c VM fails to load TRG_CUSTOMER

    Oracle Community | 2 years ago | Liturgist
    java.sql.SQLException: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error error opening file ../../demo/file/SRC_AGE_GROUP.txt_000.log
  6. 0

    Upgrade to 2.3.2 to 2.5.6 fails in Oracle

    GitHub | 3 years ago | joseorsini
    com.dotmarketing.exception.DotRuntimeException: ORA-02289: sequence does not exist

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

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

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
      8. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
      9. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
      10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
      11. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
      12. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
      13. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363)
      13 frames
    3. oracle.odi.runtime
      TaskExecutorAgentRequestProcessor$1.doAction
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
      2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
      3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
      4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
      5. oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
      6. oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
      7. oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
      8. oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
      9. oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
      10. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
      11. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
      11 frames
    4. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
      1 frame
    5. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
      5 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame