[DB-SIG] ORA-12560: TNS:protocol adapter error

[Kirankumar N]

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 at 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 at 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






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20170307/94cf4d50/attachment.html>