Oracle Oracle7 Server 7.3, Руководство по началу работы

Страница: 144 / 202

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