Hi Folks, I’m working with cx_Oracle 5.2.1 and Python 2.7, it was all fine till my firm decided to change the DB connections from TCP to TCPS. so, i was forced to change the way we connect to DB using TNSORA file.
This is how my code goes for the connection, import cx_Oracle cx_Oracle.connect(‘user/pass@dbconnect’) on execution of above code snippet it throws below error. cx_Oracle.DatabaseError: ORA-12560: TNS:protocol adapter error Even my DB team are clueless as there is no issue connecting with SQLPLUS and only issue with python module I don’t see any issue connection to database using the same handler using sqlplus, which confirms all my TNS_ADMIN and ORACLE_HOME are all set right ! system123:~ Mymac$ sqlplus user/pass@dbconnect SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 7 22:21:04 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Last Successful login time: Tue Mar 07 2017 22:15:01 +05:30 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics, Real Application Testing and Unified Auditing options SQL> Your help would be greatly appreciated here, hope i can get a solution. Thanks., Kiran
_______________________________________________ DB-SIG maillist - DB-SIG@python.org https://mail.python.org/mailman/listinfo/db-sig
