Fwd: ORA-12560: TNS:protocol adapter error

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

------------------------------------------------------------------------------
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users