Re: tns errors

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 19 Aug 2005 20:05:40 +0200
Message-ID: <ml7cg1le3hpa8micfqhuve88g8arvr7m5c@4ax.com>

On Fri, 19 Aug 2005 14:55:28 GMT, Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net> wrote:

>And I Can use SQLPlus OK.
>
>When I try to use SQLPlus Worksheet I get:
>
>ERROR:
>ORA-12560: TNS:protocol adapter error
>
>Also, I heard that the worksheet was going away and iSQLPlus was going
>to be web based.... true? If so, where do I find out info about it?

Sqlplus worksheet doesn't use a local tnsnames.ora, sqlplus does. Conclusion: Your Oracle Enterprise Manager tns settings differ from your tnsnames.ora

I*sqlplus is web based in 9i and beyond, and the *gui* version of *sqlplus* is going away.
Obviously, information about this is in new features documents and release notes, that no one ever cares to read.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 19 2005 - 13:05:40 CDT