Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
My listener is not starting, NL-00280
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
-
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
-
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.
-
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?
