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