listener.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: listener.ora

  1. #1
    Join Date
    Jul 2001
    Location
    Milano
    Posts
    22
    Hi,
    i have a DB 8.1.7 on Linux. For resolution name i use local naming, and on my client I edit my tnsnames.ora standardly (sid = "sid", protocol = tcp, port= 1521).

    It's all ok, I connect and there isn't any problem. But when I go to edit llistener.ora on my server I don't try it. I search it with command find, ma it isn't. After that I stop listner and I start It, this is the output prompt me:

    Starting /home/oracle/OraHome1/product/8.1.7/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 8.1.7.0.0 - Production
    Log messages written to /home/oracle/OraHome1/product/8.1.7/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=data.sinapsi.net.com)(PORT=1521)))

    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
    Start Date 27-SEP-2001 15:41:40
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Log File /home/oracle/OraHome1/product/8.1.7/network/log/listener.log
    The listener supports no services
    The command completed successfully


    Ther isn't nothing about system parameter file.
    Why? If there is, where is my listener.ora?

    Thank you,
    MaX



  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    if there is no TNS_ADMIN variable defined, it should be in $ORACLE_HOME/network/admin
    alse do :
    find / -name listener.ora -exec grep -il 'data.sinapsi.net.com' {} \;

    and you'll get the file that is used ...

  3. #3
    Join Date
    Jul 2001
    Location
    Milano
    Posts
    22

    ...

    I have already verified, environemnt variable TNS_ADMIN ther isn't. On $ORACLE_HOME/network/admin there isn't listener.ora and nor with command find I find this file :-(

    Thank you for your help

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    in this case, try to take listener.ora file in $ORACLE_HOME/network/admin/samples, copy it in network/admin, and just change it to match your configuration. If 'lsnrctl start' still gives the same thing, then there is something strange

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