Re: Q regarding sqlplus

Praveen <nospam_at_nospam.com> wrote in message news:<bpggk9$7qg$1_at_news1brm.Central.Sun.COM>...
> 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).

do a lsnrctl status, edit the log file it displays, you should see what port it is listening on. If you don't have a tnsnames.ora, it uses defaults, see hostnaming method in the docs. If you don't have a sqlnet.ora file, it looks for names servers and tnsnames first, so if you are going to continue to use the hostnaming method, adjust names.directory_path in client sqlnet.ora.

jg

--
@home.com is bogus.
"If you ain't got Mojo Nixon
this store could use some fixin'" - Punk Rock Girl