Re: Can 8i and 9i db server co-exist on NT?

Usually one listener is all you need for a server, but you can run more if you wish. In your case, since you didn't say to do anything else, if you had multiple listeners they would all be named "LISTENER". There's a good book from Oracle Press in the "101" series on networking which will explain everything in plenty of detail.

Van

"Chris S" <cschofie_at_nospam.slip.net> wrote in message news:72f3utg71dn7dp3iuj20lkali93j6tutt6_at_4ax.com...
> I have to plead ignorance on the oracle_base issue - I've never come
> across it! Maybe I'm aware of it but not the name. Where does one
> 'see' the term oracle base? I didn't see anything during the install.
>
> I went ahead and installed 9i on the same server as 8i. Chose a new
> home. Basically, everything went well and I can access both 8i and 9i
> databases. But there is one mystery ...
>
> The 9i install did not create a separate listenter. If I stop the 8i
> listener, NO database can be accessed, and when I restart the 8i
> listener, ALL databases can be accessed. BUT- there is no entry in
> the 8i listener.ora file for the 9i databases!
>
> Also - if I stop/start the listener (8i), and try to connect to any 9i
> database, I get an error.
>
> ora-12505: TNS: listener could not resolve SID given in connect
> descriptor.
>
> But if I connect to an 8i database first, then try the above, I get an
> error once, twice, but connect the third time! I've reproduced this
> about 4 times now.
>
> I could manually edit listener.ora and add the 9i databases, (which
> will 'probably' fix this) but I was curious as to what is going on
> here - how is the listener 'listening' if it does not have an entry in
> listener.ora?
>
> Thanks! Chris
>
> On Tue, 30 Oct 2001 14:51:44 -0000, "Niall Litchfield"
> <n-litchfield_at_audit-commission.gov.uk> wrote:
>
> >"David Fitzjarrell" <oratune_at_msn.com> wrote in message
> >news:32d39fb1.0110291442.6af1e625_at_posting.google.com...
> >> I currently have both an 8i and a 9i server running on my Win2K box.
> >> However, more than just a new ORACLE_HOME is required. Th 9i install
> >> also requires a new ORACLE_BASE; you CANNOT install 9i into the
> >> ORACLE_BASE of the 8i database. I have the following structure:
> >>
> >> Oracle 8i
> >> c:\oracle\ora816 ORACLE_HOME
> >> c:\oracle ORACLE_BASE
> >>
> >> Oracle 9i
> >> c:\ora9i\ora9011 ORACLE_HOME
> >> c:\ora9i ORACLE_BASE
> >>
> >> Without a new ORACLE_BASE you'll never get a 9i database created.
> >> Trust me, I fought with this for over a week before I finally
> >> implemented a proper install of 9i.
> >
> >
> >I didn't have this problem. I have 8i,9i and jdeveloper all installed and
> >happily working in the same oracle base.
> >
> >Howard is right about order of installation.
>
Received on Thu Nov 01 2001 - 18:43:51 CST