Re: Q regarding sqlplus

Praveen 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

Presumably there is a listener.ora. How about a sqlnet.ora? Look inside.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)