[cx-oracle-users] Fwd: ORA-12560: TNS:protocol adapter error

[Kirankumar N <kir...@gm...>]

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