Connectivity Issue for Oracle
972512Nov 20 2012 — edited Nov 20 2012Hi,
I am having Oracle 11g (Release 11.2.0.2.0) running on Windows Server 2007 SP2. I am trying to connect to this server from my system using SQL Plus command prompt. (Dedicated - redirect (client and server are on different computers)
I am getting an error: TNS-12518: TNS:listener could not hand off client connection.
When I checked the listener log in the server machine, these were the errors:
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 203: Unknown error
tnsname.ora entry in the client side(my system)
BAM = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = md1svcvwm01)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BAM637_SERVICE)
)
)
listenr.ora entry on the server side
(SID_DESC =
(GLOBAL_DBNAME=bamtest10)
(ORACLE_HOME = C:\app\j1013189\product\11.2.0\dbhome_1)
(SID_NAME = BAM637_SERVICE)
)
From the command prompt, I use sqlplus bamtest10/bamtest10@BAM to connect where in I am getting the errors. Could you please help me in resolving this?
Thanks,