4 Replies Latest reply: Nov 20, 2012 1:59 AM by Osama_Mustafa RSS

    Connectivity Issue for Oracle

      I am having Oracle 11g (Release 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)
      (ADDRESS = (PROTOCOL = TCP)(HOST = md1svcvwm01)(PORT = 1521))
      (SID = BAM637_SERVICE)

      listenr.ora entry on the server side
      (SID_DESC =
      (ORACLE_HOME = C:\app\j1013189\product\11.2.0\dbhome_1)

      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?