REMOTE
environment variableThis environment variable specifies the default and remote SQL*Net driver to use when connecting through a local database. The parameter can include the default SQL*Net parameters (complete database string).
If a user logs on and specifies a connection with an explicit driver prefix
matching the one specified in REMOTE
, but specifies
no SQL*Net parameters, the parameters specified in REMOTE
are used. This parameter enables the DBA to define a "normal" network
connection for which the SQL*Net user need not specify connection parameters.
You can reset this parameter on the command line at any time.
Note: If you use a DOS SQL*Net driver
for Windows, check to see whether REMOTE
is set in your CONFIG.ORA
file located in the
DOS Oracle home directory. If REMOTE
is set
in CONFIG.ORA
, you must set it to the same value
in the registry.
REMOTE netPrefix:databaseName
Parameters |
Description |
|
Any valid SQL*Net driver prefix. |
|
The name of the local database. |
REMOTE=P:PIPER
where P
is the network prefix for Named Pipes, and PIPER
is the database name.
Copyright © 1984, 2005, Oracle. All rights reserved.