Wednesday, October 30, 2019

ORA-12546: TNS:permission denied

I recently faced this error message while trying to connect with the database (running on my local Windows host) using a TNS service. Although connecting without TNS service was working fine, however, connection was failing with ORA-12546 when I tried to connect using TNS service. Following is what I faced.
SQL> host tnsping salman12

TNS Ping Utility for 64-bit Windows: Version - Production on 23-OCT-2019 13:48:57

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
OK (140 msec)

SQL> conn c##salman/salman@salman12
ORA-12546: TNS:permission denied

There could be several different reasons of this error as I found after searching on google. I am sharing one of the causes of this error. For my case, I was actually connected to a VPN using Cisco AnyConnect and this was causing the whole issue. After I disconnected from the VPN, I was able to connect with the database using TNS service. For your case, an antivirus, a firewall or permissions on oracle software files may also cause this error message.   

No comments:

Post a Comment

Popular Posts - All Times