gpt4 book ai didi

database - 抖动 - "ORA-12504, TNS:listener was not given the SID in CONNECT_DATA"

转载 作者:搜寻专家 更新时间:2023-10-30 20:08:58 25 4
gpt4 key购买 nike

问题:

我们正在尝试使用 Jitterbit 从客户的 Lawson (Oracle) 数据库向 Salesforce 执行更新插入。我们在默认端口上使用 Oracle [JDBC] 驱动程序。我们在客户端网络内的一台机器上的 Windows Server 2008 上运行 Jitterbit Agent,客户端向我们保证(但不是 100% 确定)服务器可以连接到 Lawson 数据库。当我们尝试从 Jitterbit Studio 中启动与 Oracle 数据库的连接时(Studio 不是从 Windows Server 运行,我们是从本地计算机运行它)我们被拒绝了:

Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

我希望有人能帮助解决的问题是 - 缺少 SID 的监听器到底是做什么用的?我基本熟悉 listener.ora 以及需要如何为监听器提供 SID 信息以允许传入数据库连接。

报错中的SID是否指的是:

  • 劳森数据库? (这似乎不太可能,因为我的理解是这里提到的监听器是位于 Lawson 数据库服务器上的监听器)
  • 代理所在的机器(Windows Server 2008)?
  • 或者我们运行 Jitterbit Studio 的本地机器?

我正在等待从客户端获取 listener.ora 和 tnsnames.ora,我只是想看看是否有人根据自己的经验了解根 block 。

堆栈跟踪,以防有帮助:

Details: oracle.net.ns.NetException - Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

at org.jitterbit.integration.client.ui.interchange.locatable.actions.TestConnectionResultDisplayer.showResult(TestConnectionResultDisplayer.java:62)
at org.jitterbit.integration.client.ui.interchange.locatable.actions.TestConnectionJob.runImpl(TestConnectionJob.java:55)
at org.jitterbit.application.ui.job.UiJob$2.run(UiJob.java:509)
at org.jitterbit.application.worker.DefaultApplicationWorker$RunnableWrapper.run(DefaultApplicationWorker.java:105)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

提供连接参数的屏幕截图:

enter image description here

tnsnames.ora:

PSILSFD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.22.224)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PSILSFD1)
)
)

监听器.ora:

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = psidevdba01)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

最佳答案

Jitterbit support pages包括:

Configure a source or target with the Oracle JDBC driver
- Create a new source and give it a name.
- From the Type drop-down, select Database.
- Click Select... and locate the Oracle driver. Make sure the JDBC check-box is selected. You may have to refresh the driver list if you recently installed the driver.
- Depending on how the Oracle server is configured you may just have to enter the Server Name, Login and Password (and port if the server runs on a non-standard port). However, in most cases you will have to construct the connection string manually, see below.
...

添加了重点。您似乎已按照这些说明进行操作,但由于无法提供服务名称,因此您需要进行手动设置:

To use a manual connection string, expand the Options section and check "Construct connection string manually". Type in the connection string and test the transformation.

根据您的 tnsnames.ora 中的内容,连接字符串将是:

jdbc:oracle:thin:@//10.33.22.224:1521/PSILSFD1

关于database - 抖动 - "ORA-12504, TNS:listener was not given the SID in CONNECT_DATA",我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/31412545/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com