Forum Stats

  • 3,814,159 Users
  • 2,258,828 Discussions
  • 7,892,596 Comments

Discussions

My listener is not starting, NL-00280

3821159
3821159 Member Posts: 11

Hello,

I'm trying to start my listener while i'm login with my oracle user, I searched but couldnt find the solution. Thanks for all comments.

----- My error starts.

[[email protected] ~]$ lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 28-NOV-2018 00:49:12

Copyright (c) 1991, 2018, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=okan.domain)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 111: Connection refused

[[email protected] ~]$ lsnrctl start

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 28-NOV-2018 00:49:30

Copyright (c) 1991, 2018, Oracle.  All rights reserved.

Starting /opt/oracle/product/18c/dbhomeXE/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 18.0.0.0.0 - Production

NL-00280: error creating log stream /opt/oracle/product/18c/dbhomeXE/network/log/listener.log

NL-00278: cannot open log file

  SNL-00016: snlfohd: error opening file

   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

--- My error ends.

Answers

  • Markus Flechtner
    Markus Flechtner Member Posts: 503 Bronze Trophy
    edited Nov 27, 2018 5:01PM

    1. the osuser for starting the listener should be "oracle", so you don't have to hide it.

    2. If you are trying to start the listener as "oracle", the error message tells you that oracle cannot access the file "/opt/oracle/product/18c/dbhomeXE/network/log/listener.log" ==> please check the permissions for this file and correct them so that oracle can write into this file.

    HTH

    Markus

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,795 Red Diamond
    edited Nov 28, 2018 12:59AM

    Seems like you are trying to start the Listener as o/s user ouser - where this user does not have privs to open and write to the oracle owned log file.

    Run XE s/w as the oracle o/s user.

    On a server distro like Oracle Linux or Redhat/Centos, as root enter command:

    su - oracle

    On a desktop distro like Ubuntu, as your user, enter command:

    sudo su - oracle

    Make sure the environment is valid for Oracle XE usage - suggest you add the following to the oracle user's .bash_profile file:

    export ORACLE_BASE=/opt/oracle

    export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE

    export ORACLE_SID=XE

    export PATH=$PATH:$ORACLE_HOME/bin

    export LD_LIBRARY_PATH=$ORACLE_HOME/lib

    Now as oracle, start and stop Oracle XE services like the Listener, and database instance.

  • User_CO3N7
    User_CO3N7 Member Posts: 1 Green Ribbon
    edited Jul 13, 2021 12:01PM

    Above sorted my issue. How do I connect to the em via my browser since the user I log in with is different from an oracle who has the rights?