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

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 - 15:32:21 CST