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

    Connectivity Issue for Oracle

    972512
      Hi,
      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,