| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ORA 2019 - Listener/TNS
Hi all.
I have 3 listeners running on the server, which hosts many databases. (Many on 8.0.5.2 on HpUX 11.0) I started all the listeners. I checked that status of listener A and found that, it is up. I gave the following command at os prompt.
connect system_at_hostname. I got connected. I tried to access a remote table(table on another instance) through the public link, on the same server, which is serviced by the same listener. I got OERR 2019 : "connection description for remote database not found".
I cross checked listener.ora. It is in right place. The remote database sid is in the sid-list of listener.ora. I cross checked in tnsnames.ora. The alias is fine. what could be the problem? Could any body please help me?
Also my understanding of listner/tns is to be improved. Any white papers/pointers will be highly appreciated. I am bit confused between SID and ALIAS. Which is used when. Especially if db-link name is same as alias.
TIA,
Swamy.
 |
 |