[DB-SIG] ORA-12560: TNS:protocol adapter error
kirannk007 at gmail.com
Tue Mar 7 11:55:51 EST 2017
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,
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 220.127.116.11.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
Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options
Your help would be greatly appreciated here, hope i can get a solution.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DB-SIG