My listener is not starting, NL-00280

3821159

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.

Markus Flechtner

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

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

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?