Hi,

I have recently installed ORACLE 9.2 Database on a UNIX server (2.8)
which already has ORACLE 8.1.7. They have both a different SID and
ORACLE_BASE. However I am having to use the ORACLE 8 listener for both
ORACLE databases.

Is it possible to run separate ORACLE 8 and ORACLE 9 listeners?

Hello,

There are no difficulty to use 2 listeners on the same machine.

The point is that default listener used to listen on port 1521 (or
1526).

You will have to change your listener configuration( netasst or by
hand) in order to use a different port number, a different listener
name and communicate it to your users for their tnsnames.ora.

LSNR8I =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= machine)(Port= 1110))
)

Generally what I do is to create 1 listener per Oracle Version.

After that, for starting listeners you'll have to launch

lsnrctl start LSNR8I ou lsnrctl start LSNR9I

I am used to name listeners with different names since 8i because you
have the autoregistration stuff and with 2 listeners with the same
name, you are not sure on which the database will register (or using
le local_listener init parm).

Regs,

Olivier


jonathan.johnston (AT) bt (DOT) com (Jonathan Johnston) wrote in message news:<5e07fa5.0406080037.67d595a9 (AT) posting (DOT) google.com>...