Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

oracle cloud connect problem, how find then ORACLE_HOME in local machine? #3282

Open
redgreat opened this issue Apr 24, 2024 · 0 comments
Open

Comments

@redgreat
Copy link

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):

instancelcient 21.14 connect to oracle cloud at 19c

  1. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):

build551

  1. The steps to reproduce this issue:

set up ORACLE_HOME and fill in tnsnames.ora
when i press test button
图片

and the logfiles:

Fatal NI connect error 12537, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1111))(CONNECT_DATA=(SERVICE_NAME=xxx_high)(CID=(PROGRAM=TablePlus)(HOST=macwong)(USER=wangcw))))

VERSION INFORMATION:
TNS for MacOS X Server: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for MacOS X Server: Version 19.0.0.0.0 - Production
Version 19.3.0.0.0
Time: 24-APR-2024 09:15:26
Tracing not turned on.
Tns error struct:
ns main err code: 12537

TNS-12537: Message 12537 not found; No message file for product=network, facility=TNS
ns secondary err code: 12560
nt main err code: 507

TNS-00507: Message 507 not found; No message file for product=network, facility=TNS
nt secondary err code: 0
nt OS err code: 0
2024-04-24T09:22:58.567954+08:00

the Version of TNS is not my ORACLE_HOME‘s version, and where can i set it to?

Noted: If the bug is related to data, please attach an example SQL data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant