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

Oracle Community | 2670946 | 2 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 1 year 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

  1. osvzs 4 times, last 1 week ago
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