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 12.1.0.2.0 - Production on 23-OCT-2019 13:48:57

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

Used parameter files:
d:\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SALMQURE-SG)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = salman12)))
OK (140 msec)

SQL> conn c##salman/salman@salman12
ERROR:
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