Oracle Network Products Getting Started for Windows Platforms

Modifying Oracle Configurations for Windows NT and Windows 95

Modifying a Registry Entry
Adding a Parameter

Modifying a Registry Entry

The Registry stores information about a computer's configuration, including Oracle-related parameter settings, such as:

language, territory, and character set
Oracle home
database location

Caution When editing in the Registry, proceed carefully to avoid deleting or altering correct information that can affect how your system functions.

The instructions below explain how to modify the registry for Windows NT 4.0. The instructions are very similar on Windows NT 3.51 and Windows 95. Please see your operating system documentation for specific registry information.

To edit the Oracle-related settings:

Start the Registry in either one of two ways:
- From the command line, enter:
```
C:\>REGEDIT
```
- Select Run from the Start icon in the Taskbar, enter REGEDIT in the Open field, and choose OK.
The Registry Editor window appears:
Double-click the HKEY_LOCAL_MACHINE tree.
Double-click the SOFTWARE key.
Double-click the ORACLE key.
ORACLE displays three keys
All of the value entries appear on the right-hand side of the window:
Double-click the value to edit.
The Edit String dialog box appears:
Make any edits in the Value Data field.
Choose OK.
From the Registry menu, choose Exit.
Log out and log back in again for the changes to take effect.

Adding a Parameter

You can also add the following parameters to a Windows NT server:

LOCAL
REMOTE

You can add these configuration parameters in three ways:

the Registry
See "Using the Registry" in this appendix for more information.
the Control Panel
See "Using the Control Panel" in this appendix for more information.
the command line with the SET command:
```
 SET LOCAL=service_name
```
This method only lasts for the current login session.

LOCAL

You can add the LOCAL parameter to make a connection without specifying a connect string. The value for LOCAL is the service name in the TNSNAMES.ORA file located in the ORANT\NETWORK\ADMIN directory.

For example, if the LOCAL parameter is specified, you connect to a database from Server Manager with the following:

SVRMGR>CONNECT SCOTT/TIGER

SQL*Net checks for LOCAL in the Registry. If it exists, SQL*Net connects.

REMOTE

You can add the REMOTE parameter to make a remote connection without specifying a connect string. The value for REMOTE is the connect descriptor parameters in the TNSNAMES.ORA file located at \ORANT\NETWORK\ADMIN directory. For example, if the REMOTE parameter is specified, you connect to a remote database from Server Manager with the following:

SVRMGR>CONNECT SCOTT/TIGER@REMOTE

SQL*Net checks for REMOTE in the Registry. If it exists, SQL*Net connects.

Using the Registry

The instructions below explain how to add a parameter entry to the Registry for Windows NT 4.0. The instructions are very similar on Windows NT 3.51. Please see your operating system documentation for specific registry information.

To add a parameter:

Start the Registry:
- From the command line, enter:
```
REGEDIT
```
- Select Run from the Start icon in the Taskbar, enter REGEDIT in the Open field, and choose OK.
The Registry Editor window appears.
Double-click the HKEY_LOCAL_MACHINE tree.
Double-click the SOFTWARE key.
Double-click the ORACLE key.
The list of value entries appears in the right-hand side of the window.
From the Edit menu, choose New, and choose String Value.
The new entry appears with a temporary name.
Type a name for the new entry, and then press ENTER.
Double-click on the value to edit.
The Edit String dialog box appears.
Enter a value in the Value Data field.
Choose OK.
From the Registry menu, choose Exit.
Log out and log back in again for the changes to take effect.

Using the Control Panel

The instructions below explain how to add a parameter entry to the System Properties window for Windows NT 4.0. The instructions are very similar on Windows NT 3.51 and Windows 95. Please see your operating system documentation for specific registry information.

To add a parameter:

In the Control Panel window, choose the System icon.
The System Properties window appears.
Choose the Environment tab.
The Environment view appears:
Enter the parameter name in the Variable field and its value in the Value field.
Choose Set.
The parameter is added to the System Variables list box.
Choose OK.
From the Registry menu, choose Exit.
Reboot your system for changes to take effect.
Log out and log back in again for the changes to take effect.

Copyright © 1996 Oracle Corporation.
All Rights Reserved.