Toad World® Forums

Exclude listener from database list.


#1

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:

LISTENER_ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
)

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

Regards Piter.


#2

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,
Bruce


#3

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

Regards Piter


#4

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).

Jaime