DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: name of listener

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    name of listener

    Hi, i noticed in one of my databases that there is a name of the listener. so by doing a start in LSNRCTL>, i wont be able to do so. But if i do a start LISTENERNAME, then i am able. However, i am not able to identify the name, only when the personnel told me so.

    Is there a way to check?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look in the listener.ora if the listener is called listener then just start will do

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    Hi.

    You are right. Initially, i went to path /oracle/SID/817_64/network/admin and could not find the listener name in my listener.ora. However, i noticed from my status listener that it reads the configuration file from /etc/listener.ora instead. And from there, YES, the listener name is right there.

    1) where is this pointing of /etc/listener.ora set? i could not find it in my initsid.ora or neither any ifiles at all?

    2) so i can set the name of my listener in listener.ora?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look your TNS_ADMIN Env variable

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    Hi.

    I did a grep -i admin and nothing was returned.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    did a grep -i admin on what?

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can keep your listener.ora and tnsnames.ora either in $ORACLE_HOME/network/admin or /etc without explitly setting TNS_ADMIN.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by davey23uk
    did a grep -i admin on what?
    Hi, davey23uk!

    Pando advised me to check my TNS_ADMIN variable. Therefore, i did a "env | grep -i admin" and nothing was returned.

    You can keep your listener.ora and tnsnames.ora either in $ORACLE_HOME/network/admin or /etc without explitly setting TNS_ADMIN.
    Hi sanjay, my query is with the setting and priority of listener in either /oracle/SID/817_64/network/admin or /etc/listener.ora?

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use truss on lsncrtl to see what is being read first.

    If you dont want to use /etc, remove the file from it

  10. #10
    Join Date
    Oct 2002
    Posts
    391
    Hi.

    Are u referring to trace?

    I search for truss, tusc but no hits even after a full file system search. Please advise

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