A script-enabled browser is required for this page to function properly.

REMOTE environment variable

This 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.

Syntax

REMOTE netPrefix:databaseName

Parameters

Description

netPrefix

Any valid SQL*Net driver prefix.

databaseName

The name of the local database.

Example

REMOTE=P:PIPER

where P is the network prefix for Named Pipes, and PIPER is the database name.

See also

Environment variables