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

I have one listener, and it's called 'OracleOraHome81TNSListener' (NT service name). I'm perfectly comfortable with this. On startup, it reads from the file listener.ora in the <81home>\network\admin folder. There are no other listeners. This file has entries in it for the various 8i databases, but has no entries in it for the various 9i databases that I created. Yet this listener is clearly 'listening' for the 9i databases, which puzzles me. And, as I pointed out below, it only 'listens' correctly after having made at least one 8i connection, which sounds bogus.

Any ideas what is going on? Chris.

On Thu, 1 Nov 2001 19:43:51 -0500, "Van Messner" <vmessner_at_bestweb.net> wrote:

>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:57:57 CST