On Wed, 19 Nov 2003 11:34:32 -0800, Praveen <nospam_at_nospam.com> wrote:
>Hi..All,
>
> I have a database installed on a server X listening to port 1653.
>
>I login to the same machine & at the prompt I execute the command
>sqlplus userid/passwd & it automatically connects me to the database &
>I get the SQL prompt.
>
>I did set the variables $ORACLE_SID, $ORACLE_HOME. But there is no
>tnsnames.ora.
>
>So, how does SQLPLUS know that it has to connect to the same machine &
>that too on port 1653 (AFAIK default is 1521).
>
>Regards,
>
>P
If you have sqlplus running on that server and you have ORACLE_SID and
ORACLE_HOME set, tnsnames.ora is completely ignored. You have a
BEQueath connection, you don't have a TCP/IP connection.
--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Nov 19 2003 - 16:11:44 CST
