Connecting to a Oracle 11g database using Windows authentication
Posted on 2011-02-18
I am new to Oracle 11g and I have been trying to connect to my test Oracle 11g database using Windows authentication.
I have been successful in connecting to my test Oracle database using Windows authentication locally on the server. But when I try to connect to the database remotely from a client I get an error.
Here is the syntax that I am using.
To connect locally I open a command prompt on the server and I type the following.
SQL*Plus: Release 184.108.40.206.0 Production on Fri Feb 18 10:11:36 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Release 220.127.116.11.0 - 64bit Production
But, when I try to connect to the database remotely from my workstation I get the following error.
ORA-12560: TNS:Protocol adapter error
I am not sure if it has to do with the syntax that I am using or if it has to do with the tnsnames.ora file. I would appreciate some Expert Exchange knowledge transfer with this problem.
Oh, I almost forgot to mention that I am able to connect to my test Oracle box remotely using an Oracle account (via SQL*Plus) such as SYS.