Oracle A423961 User Manual

Page 144

Advertising
background image

D – 10

Oracle7 Server Getting Started for Windows NT

SVRMGR>CONNECT username/password@p:

The connect string includes only the network prefix (p:), which matches
the network prefix specified in the above REMOTE parameter.
Therefore, Server Manager automatically uses the REMOTE parameter
to complete the connection to the HOUSTON database.

This configuration parameter enables the DBA to define a network
connection for which the SQL*Net user need not specify connection
parameters.

Note:

You can reset this parameter on the command line at any

time.

SQLNET

Operating System: Windows NT

Default:

None

Legal Values:

The word “DBNAME” followed by an alias and any
valid connect string

This parameter allows you to set a unique alias for each server on your
network or distributed network. By setting multiple aliases, you can
refer to connect strings by simple names or mnemonic conventions
when using any of the Oracle utilities. You do not have to remember the
complete connect string for each one.

The syntax for the SQLNET parameter is:

alias=connect_string

For example, if you create a Registry key value SQLNET DBNAME
FINANCE for the connect string P:MKTG_SRV2_NY:FIN1, you can
access the database from within SQL*Plus by typing:

SQL>CONNECT username/password@FINANCE

Advertising