Home » RDBMS Server » Server Administration » Re: Database Aliases
Re: Database Aliases [message #369146] Tue, 28 March 2000 10:28
Manny I.
Messages: 7
Registered: March 2000
Junior Member
If what you mean by database alias is the "connect string" or "service name" that you can use to connect from any client application (say sqlplus) to the database, then you need to modify your tnsnames.ora file (if using local naming).

The tnsnames.ora file is located on your clt machine. It should be in the $oracle_home\network\admin directory along with the sqlnet.ora file.

For example, you have a 7.3.4 database (SID=orcl)on an NT server (ip address, protocol=TCP, and port=1521 (look at your listener.ora file on the server), then you need to put an entry in your tnsnames.ora file with all the above information. There should be a sample of the tnsnames.ora file in your $oracle_home\network\admin\sample directory. You can call these alias "orcl.world" for example. In this case "world" is the default domain. To specify your default domain, go to your sqlnet.ora file and modify the entry for names.default_domain.

Hope this helps.
Previous Topic: Problem in Database link
Next Topic: Please help me about array fetch!
Goto Forum:

Current Time: Wed Oct 28 07:23:11 CDT 2020