Database Connection 2021.2 to 32-bit Oracle OCI
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Using input data tool I tried to connect to our 32-bit Oracle OCI database and I got an error message "OCILogon2 Error:ORA-12514:TNS:listerner does not know of service requested in connect descriptor" What does this error mean? How do I get connected to an oracle database?
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @stlkng
What kind of connection type are you using? How did you try to connect through Alteryx? ODBC? OCI, Quick Connect
There's this post that could help you do it -> https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Databas...
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My first question would be, is it necessary for you to use the 32bit connection? 64bit is significantly faster if that is an option and 32bit connections are legacy and being phased out.
Here is a helpful document that outlines Oracle connectivity within Alteryx: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Databas...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Thableaus you beat me to it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Options => Advanced Options => Manage Data Connections => Add
Connection => Other
Name: PRODP
Connection Type: User
Connection String: hit the drop down => 32-Bit Database Connections =>
Oracle OCI
TNS Server Name: PRODP
User Name and Pw I use to log into my 32 bit oracle OCI
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My main database is 32-bit Orace OCI - I'll read these 2 links and try - thanks
