Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between local and remote connections
In article <39962044.E3892028_at_anonymous.com>,
Jimmy <anonymous_at_anonymous.com> wrote:
> Hello all,
>
> What is the difference between local and remote connections to
> Oracle?
> Is local means connection and the database are in the same server?
> (i.e. type "sqlplus" or "svrmgrl" in server A to connect Oracle
database
> server in server A, without using the connect string)
> Is remote means connection and the database are on different
> servers? (i.e. type "sqlplus" or "svrmgrl" in server A and connect to
> Oracle database server B, or using connection string such as "sqlplus
> username/password_at_connect_string)
>
> Then if a user type the following commands: (on UNIX platform):
>
> 1. ORACLE_SID=orcl;export ORACLE_SID
> 2. sqlplus
>
> Is this a local or remote connection (assume he is in the same
> server as the database)? And does the connection using SQL*Net in this
> case?
>
> Finally, is the password file only works for remote connections?
>
> Thanks,
> Jimmy
>
>
A local connection is a connection to a database on the same system.
When you set the ORACLE_SID it doesn't use sqlnet, however when you
don't set the SID and use @<servicename> it *does* use sqlnet, although
it should automatically revert to the tcp/ip protocol, the same
protocol it is using without sqlnet.
Remote means the client is on a different system. He will be forced to
use sqlnet. You won't be able to set Oracle_sid, it's not going to work.
As to your question about the passwordfile:
The Oracle terminology is a bit misleading here. The passwordfile is
used for all users with SYSDBA and/or SYSOPER privilege. As you can
(but don't need to) use connect internal or connect / as sysdba, only
in that case it won't use the passwordfile. As usually users on the
server use sys and internal, and you don't really want users without
server access knowing the sys password, you grant them SYSDBA, which
means they will be using the passwordfile.
Hth,
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/ Before you buy.Received on Sat Aug 12 2000 - 00:00:00 CDT