Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 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?
