Toad World® Forums

Exclude listener from database list.


When you have local database installed, with non default listener (port<>1521) you should specify local_listener parameter for database, and add listener cpecifications into tnsnames file.
For example this sentence looks like this:


Continuing , sqlnav lists this listener in database list.
I think this shouldn’t be listed.

Regards Piter.


Hi Piter,

Will have Sekhar to look into this for you with our domain expert. Sekhar will get back to you on this later today.

Thanks and regards,


Just for note: Its about sqlnav installed on machine with local database .

Regards Piter


Hi Piter,

Sekhar and I have been looking into this…
SQL Nav is not smart enough to handle this situation… but we will make it smarter!!
I’ve logged an enhancement CR for a post 5.5 release.
Damn you’re giving us some work to do!! Which is a good thing (of course).