Sybrand Bakker wrote:
>
> 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
> >
> >
Yup,
Sybrand is right; I did this (well, with 8.1.5/8.0.5 actually)
on NT and it works.
Received on Fri Jul 21 2000 - 00:00:00 CDT
