Oracle-Connection: Problem with SID in dbt-package #35543
Closed
slanz101010
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
We would like to use Airbyte to synchronize data on MS-SQL Server to Oracle. We have successfully created source and target connections, which have been tested and saved without any problems.
Then we created a test data transfer with Normalization: Raw data (json) - this also worked without problems and the data was transferred to the Oracle DB.
After that, we changed the normalization to "tabular data" and got the following error: (apparently the SID is not taken over in the dbt package)
024-02-20 12:42:22 normalization > Diagnosing dbt debug to check if destination is available for dbt and well configured (1):
2024-02-20 12:42:22 platform >
2024-02-20 12:42:24 normalization > Running with dbt=0.19.1
2024-02-20 12:42:24 normalization > dbt version: 0.19.1
2024-02-20 12:42:24 normalization > python version: 3.8.8
2024-02-20 12:42:24 normalization > python path: /usr/local/bin/python
2024-02-20 12:42:24 normalization > os info: Linux-5.15.0-53-generic-x86_64-with-glibc2.2.5
2024-02-20 12:42:24 normalization > Using profiles.yml file at /data/13/4/normalize/profiles.yml
2024-02-20 12:42:24 normalization > Using dbt_project.yml file at /data/13/4/normalize/dbt_project.yml
2024-02-20 12:42:24 platform >
2024-02-20 12:42:24 normalization > Configuration:
2024-02-20 12:42:24 normalization > profiles.yml file [OK found and valid]
2024-02-20 12:42:24 normalization > dbt_project.yml file [OK found and valid]
2024-02-20 12:42:24 platform >
2024-02-20 12:42:24 normalization > Required dependencies:
2024-02-20 12:42:24 normalization > - git [OK found]
2024-02-20 12:42:24 platform >
2024-02-20 12:42:24 normalization > Connection:
2024-02-20 12:42:24 normalization > user: airbyte
2024-02-20 12:42:24 normalization > database: test
2024-02-20 12:42:24 normalization > schema: airbyte
2024-02-20 12:42:24 normalization > host: xxxhostnamexxx
2024-02-20 12:42:24 normalization > port: 1521
2024-02-20 12:42:24 normalization > service: None
2024-02-20 12:42:24 normalization > connection_string: None
2024-02-20 12:42:24 normalization > Got an error when attempting to open an Oracle connection: 'ORA-12514: TNS:listener does not currently know of service requested in connect descriptor'
2024-02-20 12:42:24 normalization > Rolling back transaction.
2024-02-20 12:42:24 normalization > Connection test: ERROR
2024-02-20 12:42:24 platform >
2024-02-20 12:42:24 normalization > dbt was unable to connect to the specified database.
2024-02-20 12:42:24 normalization > The database returned the following error:
2024-02-20 12:42:24 platform >
2024-02-20 12:42:24 normalization > >Database Error
2024-02-20 12:42:24 normalization > ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
2024-02-20 12:42:24 platform >
Thank you
Beta Was this translation helpful? Give feedback.
All reactions