Re: Multiple Oracle Homes

Oracle seems to have changed the sqlnet syntax starting with 8i. So my approach would be create a 8.1.6 listener for *all* databases and drop the 8.0.5 listener. Listeners *are* downwards compatible. You need to make sure however you follow the 8.0 syntax for the older databases. Remains the issue of whether your server can really cope with 3 instances. I have seen too many examples where people just don't think and go ahead, you get competing for resources between the instances and in the end neither of them performs.
In all cases you need of course to set the TNS_ADMIN (environment variable, Unix) (registry key, Windows) appropiately

Regards,

Sybrand Bakker, Oracle DBA

"Jon Blake" <jblake_at_swin.edu.au> wrote in message news:3977C273.B5D9C7C_at_swin.edu.au...
> We have a DEC Alpha/Unix system with Oracle 8.0.5 installed. Two 8.0.5
> databases exist, and listener.ora is configured for these two databases.
> PC users have Oracle client installed and appropriate tnsnames.ora
> entries to enable client access to the two 8.0.5 databases, via the
> 8.0.5 listener process running on the DEC Alpha. Everything runs fine
> for these two databases.
>
> We have also installed Oracle 8.1.6 under a different Oracle Home, and
> created a 8.1.6 database (with a unique SID). Server Manager and sqlplus
> successfully connect to this database via a telnet session. Rather than
> start another listener process for the new database, the 8.0.5
> listener.ora file was edited for the new 8.1.6 database, listener shut
> down and restarted. The new database appears as an available service.
> The ORACLE_HOME specification for the 8.1.6 database in 8.0.5's
> listener.ora identifies the correct home for the Oracle 8.1.6
> installation.
>
> At the client end, tnsnames.ora was edited to include a new service
> definition for the 8.1.6 database. However client connections to the
> 8.1.6 database actually connect to one of the 8.0.5 databases! Carefull
> review of listener.ora and tnsnames.ora files shows no obvious errors.
>
> Should this scenario work (using the 8.0.5 listener for all databases),
> or do I have to have another listener for my 8.1.6 database?
>
> Many thanks in advance...
> Jon
>
>
Received on Fri Jul 21 2000 - 00:00:00 CDT