How to Create an Alias Name for an Oracle Database

Save

Giving an Oracle database an alias is necessary for ODBC links from applications to the server. The connection is given an alias that is used by the client computer. An alias is also used by programmers when they create customized applications for network desktops. Creating an Oracle database is established using the client software application.

  • Click the Windows "Start" button and select "Programs." In the "Oracle" menu, select "SQL Net Easy Configuration." This opens a configuration window where the alias is set.

  • Select "Add Database Alias" from the opening screen and click the "Next" button.

  • Enter an alias name in the textbox labeled "Alias." This can be any friendly name used by a customized application or by the local user. Click the "Ok" button.

  • Select "TCP/IP" for the network protocol. Most networks use "TCP/IP," but if your network uses a different protocol, select it. Click the "Ok" button.

  • Enter the Oracle database host name. Enter the name of the database on the server. Click the "Ok" button. At this point, the alias is created on the client computer.

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!