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
-
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