-
Listener Port Number
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..
K.Chithra
Oracle DBA
-
No Chithra,
I am writing a script in sql to gather all the information from the database.This is a requirement.
-
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.
Hi, as you said you are gathering database information, But the listener is it's own subsystem, no info about in the db.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|