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.