Re: configure listener.ora and tnsnames.ora

From: ddf <oratune_at_msn.com>
Date: Wed, 5 Aug 2009 07:18:44 -0700 (PDT)
Message-ID: <d27ae1a0-24cb-4dc6-89b5-cc7f5bc4c37a_at_c1g2000yqi.googlegroups.com>

On Aug 5, 8:55 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> oracle_at_linux-gle:/> lsnrctl services
>
> LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-AUG-2009
> 15:48:11
>
> Copyright (c) 1991, 2005, Oracle.  All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
> Services Summary...
> Service "AFTIDI" has 1 instance(s).
>   Instance "AFTIDI", status READY, has 1 handler(s) for this
> service...
>     Handler(s):
>       "DEDICATED" established:93 refused:0 state:ready
>          LOCAL SERVER
> Service "AFTIDIXDB" has 1 instance(s).
>   Instance "AFTIDI", status READY, has 1 handler(s) for this
> service...
>     Handler(s):
>       "D000" established:0 refused:0 current:0 max:1022 state:ready
>          DISPATCHER <machine: linux-gle, pid: 7725>
>          (ADDRESS=(PROTOCOL=tcp)(HOST=linux-gle.Id)(PORT=53184))
> Service "AFTIDI_XPT" has 1 instance(s).
>   Instance "AFTIDI", status READY, has 1 handler(s) for this
> service...
>     Handler(s):
>       "DEDICATED" established:93 refused:0 state:ready
>          LOCAL SERVER
> The command completed successfully
>
> this is the result of your comand....
>
> thanks for help

Good, then autoregistration is working. Now try this from a command prompt on the client:

tnsping aftidi

and report what is displayed.

David Fitzjarrell Received on Wed Aug 05 2009 - 09:18:44 CDT