Oracle Database Discussions

Problem Exists Between Keyboard And Chair

SQL Developer use JDBC Thin & does not require or expect SQL*Net support
All other mention clients utilize SQL*Net

As you provide no connect strings, no error messages, no four digit Oracle version number, and apparently didn't consult the net administrators manual of your unknown version of Oracle, and this is not a chat room, no guidance or help is possible nor required.

This forum is searchable, the online documentation is searchable, and there are no signs search engines are not available in your locale, so there is no reason at all to ask this question.

----------
Sybrand Bakker
Senior Oracle DBA

If you want some light Java/sql developer reading :

http://java2go.blogspot.com/2007/09/sqldeveloper-trick.html

What is the error that you are getting while trying to connect ?
What is the database version ?

Sorry folks, for not providing complete info ... apologize for this inconvenience, here is error + version too:

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 11 16:30:05 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:

Error for tnsping too, where as, able to ping the server, but not to db.

As told earlier too, able to work via sql developer.

we still do not know what exactly you did that throws the error!

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

a simple tnsping <db name>

I am sorry to see that COPY & PASTE are broken for you

post content of tnsnames.ora file & sqlnet.ora file if it exists

http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

Thanks all for your help and assistance, but if I placed everything on ONE line, it worked, means there must be some kind of special character/s or some thing was coming in b/w, which was not even visible, but not letting me tnsping or connect, but when I place everything on one line.

It worked.

I solved it myself, but still thanks to all, it might be my fault that I couldn't explain my problem, correctly.

Yes! Putting it all on a single line is the trick :)
Thanks!