Oracle database methods for removing aliases

I have used personal oracle+developer2000 to develop some programs, when porting to Oracle for NT, I found some features appear error prompts. The study found that the original user was not able to connect normally. Because alias (alias) is not required when developer2000 is connected to personal Oracle, write the username/password directly.

In Oraclefor NT, you must set an alias in the connection user, and use User/password@alias to connect the user in the program. So the form of User/password previously written cannot connect users properly. Due to the workload of the program is too large, so decided to modify some parameter files to achieve without aliases can be directly connected to the form of User/password. The following steps are implemented:

For the Oracle7 for NT

1. Use Oracle's own net Easy config to set an alias first.

The specific steps are as follows:

I. Start net Easy config in the Oracle for Win95 group.

Ii. in the new service name, fill in the alias you need to create (the name can start at your own discretion).

III. Selection Protocol (TCP/IP, SPX, etc.)

Iv. fill in the name of the DB server where Oracle for NT resides.

V. Fill in Oracle's SID (but it is ORCL).

Vi. completion.

2. The installation path of the operating system path (if the WIN98 is installed by the C:\Windows) is found under Oracle.ini

3. Editing Oracle.ini files with the editor

4. Add one of the following: Local=aliasname (AliasName is the name of the alias you just set)

5. Back into the program run, everything OK.

Note: Enter a name in Sql*plus that you can use without knocking the alias.

The following steps are specific to Oracle for NT:

1. Oracle's own net Easy config to set an alias.

The specific steps are as follows:

I. Start net Easy config in the Oracle for Win95 group.

Ii. in the new service name, fill in the alias you need to create (the name can start at your own discretion).

III. Selection Protocol (TCP/IP, SPX, etc.)

Iv. fill in the name of the DB server where Oracle for NT resides.

V. Fill in Oracle's SID (but it is ORCL).

Vi. completion.

2. Enter the registry (run Regedit)

3. In hkey_local_machine-$#@62; Software-$#@62;oracle a new string value under. The values are as follows:

Local=aliasname (where AliasName is the name of the alias you just set)

4. New entry program run, everything OK.

Note: Enter a name in Sql*plus that you can use without knocking the alias.

> Above operations in DEVELOPER2.1 ORACLE 7.3.4 for NT

> ORACLE 8.0.5 for NT pass.