DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Listener Port Number

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    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.

  2. #2
    Join Date
    Feb 2003
    Posts
    40
    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

  3. #3
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    No Chithra,
    I am writing a script in sql to gather all the information from the database.This is a requirement.

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  5. #5
    Join Date
    Nov 2000
    Posts
    224
    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
  •  


Click Here to Expand Forum to Full Width