problem with listner port

[jimmy_39]

hy grrus
i have a problem with listner
i want know on this port listen the listner
of my instance..

[Sanjay Kumar Suri]

If you are talking about Oracle instance then generally it is 1521 as specified in listener.ora file.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = machine_name)(PORT = 1521))
)
)
)

sks

[Ian Lochray]

To find all the userfull listener information, use the command "lsnrctl status LISTENER_NAME" where LISTENER_NAME can be left blank if you Are using the default name (LISTENER).

[Steven E. Protter]

When checking this setup, here is a useful tool for checking syntax and tns network connectivity without having to bounce the database and listener.

tnsping

its an oracle network testing tool. Right after you save the file, you can test if oracle network connectivity is correct.

SEP
Jerusalem

[Sanjay Kumar Suri]

with

$lsnrctl help

you can get all the sub-commnads that it supports:

start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*


sks