Re: Listener with multiple databases

Steven Egberghs wrote:
>
> Hello,
>
> My configuration is :
> AIX 4.1
> Oracle WG 7.3
> Tcp/IP-clients
>
> I have two database, and I need to configure the listener so that I can
> access both from clients.
>
> Do I need 2 listener.ora files ( I guess not ) ?
>
> When I duplicate the contents of listener.ora and add this to the same
> file, but different listener-aliases (eg list1 and list2 ), I can't
> start the second one with lsnrctl.
>
> What is the corerct way of doing this ???
> Thanks
> Steven

For every Oracle _Server_ you should have al least a listener. You may have more than on listener. Also, You shoul configure sqlnet(v2).ora and tnsnames.ora files in order to access the databases. It is basically a configuration file on a server. (It is server. Not a client). It handles all requests coming from clients.

However, for clients, you should configure sqlnet.ora and tnsnames.ora.

Regards

InfoPower International Inc.
ERP/MRPII/DBMS Consulting and Software

Phone:905-507-2100
Fax:905-507-2108
E-mail:hakan_at_infopwr.com

       prabir_at_infopwr.com Received on Mon Jul 14 1997 - 00:00:00 CDT