Date: Tue, 8 Jul 2008 03:59:02 -0700 (PDT)
Have a 10g database on Solaris.
Need to connect with an ordinary unix user ie not oracle. can connect with
with the ORACLE_SID set in environment
But if I append the SID like so:
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