Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newspeer1.nwr.nac.net!newsfeed.freenet.de!amsnews01.chello.com!newshub1.home.nl!home.nl!not-for-mail From: Frank Newsgroups: comp.databases.oracle.server Subject: Re: Can I point a 9.0 listener to a 9.2 database? Date: Mon, 03 Mar 2003 20:50:43 +0100 Organization: @Home Benelux Lines: 46 Message-ID: <3E63B213.6020108@netscape.net> References: <3E5F006F.7050703@yahoo.com> NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news1.tilbu1.nb.home.nl 1046721003 3983 217.121.193.81 (3 Mar 2003 19:50:03 GMT) X-Complaints-To: abuse@home.nl NNTP-Posting-Date: Mon, 3 Mar 2003 19:50:03 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 X-Accept-Language: en-us, en Xref: newsfeed1.easynews.com comp.databases.oracle.server:178297 X-Received-Date: Mon, 03 Mar 2003 12:49:58 MST (news.easynews.com) Stan wrote: > Absolutely you can have 9.0 listener to point to 9.2 database. All you > need to do is change 9.0 listener.ora file to point 9.2 ORACLE_HOME and > reload the listener. > > for. eg. > .... > SID_LIST_LISTENER > (SID_LIST = > (SID_DESC= > (GLOBAL_DBNAME = oracle) > (ORACLE_HOME = 9.2_oracle_home) > (SERVICE_NAME = ORCL) > ) > ) > > But, it better to configure 9.2 listener and have 9.0 database point > from here. > > David Trusty wrote: > >> Hi, >> >> I have a database that I have exported from 9.0 and imported to 9.2. >> >> I want a set of Java clients (using the jdbc thin driver) to be unaware >> of this change. >> >> There are several 9.0 databases still on the machine that I want to stay >> in version 9.0 for a while yet. >> >> Is there some way that I can use my 9.0 listener to point to the 9.2 >> database? >> >> Thanks in advance!! >> >> David > > > ... and hope they do not use jdbc (machine:port:sid) connects? -- Regards, Frank van Bortel