Re: tnsnames
- From: Jay Hostetter <hostetter.jay@xxxxxxxxx>
- To: "oracle-l (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>, "Brian.Zelli@xxxxxxxxxxxxxxx" <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2014 15:58:42 -0400
Brian,
The tnsnames entry should have port 1521 since you are pointing to a
server "that uses 1521". I believe you are updating the tnsnames file on
the server with two listeners. These listeners only come into play if you
are trying to reference databases on that same server. If you are pointing
to the database on another server, you need to worry about which ports
*that* server is using.
Jay
On Tue, Mar 11, 2014 at 3:09 PM, David Fitzjarrell <oratune@xxxxxxxxx>wrote:
> Is the link to a 10g database or 11g? That would be my criteria for the
> choice.
>
>
> David Fitzjarrell
> Primary author, "Oracle Exadata Survival Guide"
>
>
> On Tuesday, March 11, 2014 12:35 PM, "Zelli, Brian"
> <Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
> I am running 2 versions of oracle on a server, one 10g(port 1521) and
> another 11g(port 1522). I added an entry to the tnsnames for a db link.
> That server uses 1521.
> Do I keep that entry at 1521 or change that one to 1522?
>
>
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
>
Other related posts:
