search

langchain-ai / langchain

🦜🔗 Build context-aware reasoning applications
https://python.langchain.com
MIT License
92.86k stars 14.88k forks source link

DOC: Oracle AI Vector Search DB Connection Error #21587

Closed barjinders closed 1 month ago

barjinders commented 4 months ago

Checklist

Issue with current documentation:

The instructions given at https://python.langchain.com/v0.1/docs/integrations/document_loaders/oracleai/ Section: Connect to Oracle Database conn = oracledb.connect(user=username, password=password, dsn=dsn) doesn't work with DBCS 23ai. The default installation is deployed with Native Network Encryption (NNE) enabled. NNE is only supported in python-oracledb Thick mode. For this to work the instructions need to be updated to use the thick mode, with a link to download the thick mode driver. oracledb.init_oracle_client(lib_dir="//instantclient_19_16")

Idea or request for content:

No response

luigisaetta commented 4 months ago

@barjinders one quick solution, good for a test environment, is to disable NNE. Go to $ORACLE_HOME/network/admin and in sqlnet.ora remove all the lines related to encryption. Then restart the DB node. This way DB won't require Native Encryption. It is ok in a test environment, I would say.

barjinders commented 4 months ago

I understand we can do some workarounds to disable NNE and force TCPS but are we expecting all the users to do that? If yes, we should have this process documented before they start connecting. If not, we need to list the supported process i.e. use a thick client. The document in its current form doesn't help users connect to the DB.