[GitHub] [superset] cdmikechen opened a new issue #17678: Superset can not connect to Multiple Oracle Autonomous Data Warehouse

[GitBox <gi...@apache.org>]

cdmikechen opened a new issue #17678:
URL: https://github.com/apache/superset/issues/17678


   Superset use `cx_Oracle` to connect oracle. If two or more different Oracle autonomous databases are connected, the default Oracle configuration will conflict, resulting in failure.
   
   #### How to reproduce the bug
   
   1. I created two Oracle Autonomous Database in Oracle Cloud and download two Wallet.zip. 
   2. I unzip one Wallet.zip to `${ORACLE_CLIENT_HOME}/network/admin` and set `TNS_ADMIN`, superset can connect to oracle with sqlalchemy url like `oracle+cx_oracle://xxxx:xxxx@tns_name`
   3. But if I unzip the new Wallet.zip, the first Oracle connection will fail.
   
   ### Expected results
   
   Superset can connect to multiple Oracle autonomous database at same time.
   
   ### Actual results
   
   I must to upload and unzip wallet files to superset server by my self, superset does not have a function to upload database dependent files.
   
   
   ### Environment
   
   (please complete the following information):
   
   - browser type and version: Edge 93.0.961.44
   - superset version: 1.0.1
   - python version: 3.8.9
   - node.js version: v17.0.1
   - any feature flags active: no
   
   ### Checklist
   
   Make sure to follow these steps before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [x] I have reproduced the issue with at least the latest released version of superset.
   - [x] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   ### Additional context
   
   no
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org