Re: Q regarding sqlplus

when you're connecting with inter-process communication, not via Net8 (or whatever version you're running)

see Concepts, under Dedicated Server Configuration (8i manuals)

• mcs

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1069272506.916062_at_yasure...
| 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)
|
Received on Wed Nov 19 2003 - 16:13:16 CST