Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dblink problem on two verion of ORACLE DB

RE: dblink problem on two verion of ORACLE DB

From: Dunbar, Norman <>
Date: Tue, 14 Aug 2007 07:56:00 +0100
Message-ID: <919FC80F27E0C6428106496EDF92A7525BB43E@EXCCLUS05.PRODDS.NTNL>


>> I knew that is problem, but based on ORACLE say you
>> can Only turn on one listener which is highest version
>> of ORACLE.

Hopefully, you will have got your tnsnames problems sorted out by now. However, the advice to only use one listener and to use the highest version of Oracle software is pretty sound - if you intend to run all your databases (on that server) using the same listener.

I have a clustered server system to look after and each 'package' can failover between cluster nodes in the event of a problem. I have one listener per database and that one listener is running with the same version of Oracle as the database itself.

Obviously, I cannot have 'hundreds' of listeners all called LISTENER, so they each have individual names like Horace and Stella or Derek and Rachel.

Only kidding :o) The names are related to the package name - that makes it easy to identify them and also to auto start them in the package start-up scripts.

So, you *can* run many listeners at many different versions of Oracle.


Norman Dunbar
Contract Oracle DBA
Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at

Received on Tue Aug 14 2007 - 01:56:00 CDT

Original text of this message