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!

Not able to connect db remotely using oracle client.

876265Aug 20 2013 — edited Aug 21 2013

Hi,

I am trying to connect to database remotely. I have installed Oracle client on my local machine(Windows 7) and trying to connect to db.

I am able to do tnsping. Below is the log.

But when i try to connect i am getting ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA error.

Below is the complete log.

C:\Windows\System32>tnsping DEVDB

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-AUG-2

013 14:18:42

Used parameter files:

D:\app\swanand_kulkarni\product\11.2.0\client_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO

COL=TCP)(HOST=10.111.0.121)(PORT=1521)))

OK (560 msec)

C:\Windows\System32>sqlplus test1/********@devdb

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 20 14:18:47 2013

ERROR:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

This post has been answered by JohnWatson on Aug 20 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2013

Added on Aug 20 2013

#general-database-discussions

8 comments

309 views