| 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 123.123.12.3), 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
