Excellent
Avoiding the steps you described is exactly why we built the ‘cloud’ type of
connection in SQL Developer so you could just point to the Zip.
From: Ethan Post <post.ethan@xxxxxxxxx>
Sent: Monday, November 18, 2019 5:51 PM
To: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: SQLALCHEMY_DATABASE_URI with Oracle Cloud
Yep. So already had the Oracle client installed. Just needed to add
network/admin, drop the files in from the .zip wallet file, add instant client
to PATH, also set ORACLE_HOME to instant client, and I can just change
SQLALCHEMY_DATABASE_URI from 'oracle+cx_oracle://HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=http-3A__username-3Apassword-40172.20.10.5-3A1521_-3Fservice-5Fname-3Dservicename&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=ZVh_Jw7bUb0vTNBY-JkMm-aOASIMzBATc0HW618-rUY&s=7uJmeBqXbusjGgkkiUuH5cLuZWtntkXHGjiqzbUBx8Q&e="username:password@172.20.10.5:1521/?service_name=servicename'
to 'oracle+cx_oracle://username:password@tnsfilename'. Working great. Thanks!
On Mon, Nov 18, 2019 at 11:59 AM Jeff Smith <HYPERLINK
"mailto:jeff.d.smith@xxxxxxxxxx"jeff.d.smith@xxxxxxxxxx> wrote:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53
and
HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__cx-2Doracle.readthedocs.io_en_latest_user-5Fguide_installation.html&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=ZVh_Jw7bUb0vTNBY-JkMm-aOASIMzBATc0HW618-rUY&s=fOEbT3Hq7TEA6hHuGPPKlbRi5pUvZas0lw8crzGA7eU&e="https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html
Do either of these help?
From: Ethan Post <HYPERLINK "mailto:post.ethan@xxxxxxxxx"post.ethan@xxxxxxxxx>
Sent: Monday, November 18, 2019 12:53 PM
To: oracle-l <HYPERLINK "mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx>
Subject: SQLALCHEMY_DATABASE_URI with Oracle Cloud
Just set up an DB on Oracle cloud. Can connect from home using SQL*Developer
and Oracle Wallet type connection. References my downloaded wallet in .zip file
format.
Anyone have a reference to how to connect from Python. I am using SQL*Alchemy.
I have the application working with local DB using cx_oracle. Looking for
connection string examples.
Thanks for the help!
- Ethan
- HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__e-2Dt-2Dh-2Da-2Dn.com&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=o5fE2jVj7D7f7tJxo4eRanC2PzoNIgxaMm6ynWqFSvQ&s=_MV8RpmGXuiOK6BIsMtxEFANzjQqckL69K9dRmTP7Vo&e="https://e-t-h-a-n.com
