Difference between local and remote connections

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 Received on Sat Aug 12 2000 - 00:00:00 CDT