Hi,
Is there any way i could find the listener port number in the Database.If yes what was the object name.I know i can find through listener.ora.
Printable View
Hi,
Is there any way i could find the listener port number in the Database.If yes what was the object name.I know i can find through listener.ora.
Getting from Database ,I don't think so.
But from 'lsnrctl status listenername' you can get it .
It tells you (Port=#)
Could be you know this already..
No Chithra,
I am writing a script in sql to gather all the information from the database.This is a requirement.
Hi, as you said you are gathering database information, But the listener is it's own subsystem, no info about in the db.Quote:
Originally posted by msuresh
No Chithra,
I am writing a script in sql to gather all the information from the database.This is a requirement.
Probably you can use the host/! sqlplus-command to execute a Shell-Script which gives you all informations you need.
Orca
As mentioned in earlier posts, listener works out of database so it no information about it is logger in database.
Just curious to know, what you are trying to achieve by getting the port no. of listener.