From: <martin_ian_lewis_at_yahoo.com>
Date: Tue, 8 Jul 2008 03:59:02 -0700 (PDT)
Message-ID: <58b0bab5-bfa8-40b2-8eb3-12eb1ac29ccb@s50g2000hsb.googlegroups.com>

Have a 10g database on Solaris.
Need to connect with an ordinary unix user ie not oracle. can connect with
sqlplus username/password
with the ORACLE_SID set in environment
But if I append the SID like so:
sqlplus username/password_at_REPORT
I get "ORA-12514: TNS:listener does not currently know of service requested in connect
Why the difference?
BTW I have an application which builds a connect string like "username/password_at_REPORT".
Also not quite sure if it good practice to define TNS_ADMIN or just rely on putting tnsnames.ora in $ORACLE_HOME/network/admin.

TIA Martin Received on Tue Jul 08 2008 - 05:59:02 CDT

Original text of this message