Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connectivity Issue for Oracle

972512Nov 20 2012 — edited Nov 20 2012
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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2012
Added on Nov 20 2012
4 comments
743 views