Oracle Error Creating Log Stream
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle TNS listener not starting on CentOS 7 up vote 0 down vote favorite I have installed Oracle 11g Release 2 Express edition on CentOS 7 machine. The installation process is completed successfully saying below. Starting Oracle Net Listener...Done Configuring database...Done Starting Oracle Database 11g Express Edition instance...Done Installation completed successfully. When I do tnsping to the service I am getting below error. Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = i2b2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) TNS-12541: TNS:no listener I then tried to start the listener and it's failing with below error. TNSLSNR for Linux: Version 11.2.0.2.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/11.2.0/xe/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Linux Error: 13: Permission denied I searched a lot on forums and tried the given solutions there but could not solve the issue. What can be the issue in this case ? Any help is really appreciated. Edit: Here is my tnsnames.ora file. XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = i2b2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) And listener.ora file. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = i2b2)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE) Environmental variables: ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe export ORACLE_HOME ORACLE_SID=XE export ORACLE_SID export TNS_ADMIN=/u01/app/oracle/product/11.2.0/xe/network/admin export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` JAVA_HOME=/usr/java/jdk1.7.0_65 export JAVA_HOME PATH=$PATH:$HOME/bin:$ORACL
friend NL-00280: error creating log stream [message #572286] Mon, 10 December 2012 01:47 devenz Messages: 8Registered: December 2012 Location: Philippines Junior Member Hi guys, we are doing a fresh install of oracle10g on a ubuntu 64bit os. Our previous installation on ubuntu 32bit os was successful. On our installation on the new server we came upon this: TNSLSNR for Linux: Version http://stackoverflow.com/questions/24961790/oracle-tns-listener-not-starting-on-centos-7 10.2.0.1.0 - Production NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/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... and this Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/sqlnet.ora http://www.orafaq.com/forum/t/185264/ Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=202.92.129.77)(PORT=1521))) TNS-12541: TNS:no listener since i'm new to server administration thingy, can you help me out here? Report message to a moderator Re: NL-00280: error creating log stream [message #572287 is a reply to message #572286] Mon, 10 December 2012 01:50 devenz Messages: 8Registered: December 2012 Location: Philippines Junior Member we also have this: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified and this ERROR: ORA-01033: ORACLE initialization or shutdown in progress it is driving me nuts Report message to a moderator Re: NL-00280: error creating log stream [message #572288 is a reply to message #572286] Mon, 10 December 2012 02:20 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Does the follown not give you some hint? Quot
2010 by mikesmithers You've followed the instructions, everythings working fine. You shutdown your machine and go for a celebratory pint / cup of tea / curry. Then, https://mikesmithers.wordpress.com/2010/04/05/troubleshooting-oracle-10g-xe-installation-on-ubuntu/ when you next start your machine, Oracle doesn't want to know. What's going on ? To be honest, I don't know. What I do know is that there are some steps you can take to at least attempt to diagnose your problem. Before I go any further, I'd like to dedicate this post to Wayne. He found himself in this position. After much oracle error head scratching between the two of us, he managed to find and resolve his problem. Whilst a hardened veteran in computing terms, Wayne was new to both Linux and Oracle. From the mails I've received regarding this post, there seem to be a number of people in a similar position to him. Therefore, this post is written with these interpid souls in mind and oracle error creating I've tried to take time out to explain why we're doing stuff at each step. Update It's now quite a while since I posted this and some people have contributed some really useful comments. These include solutions that they found to various problems, which are additional to the ones in this post. So, if you're still having problems, check out the comments as well. MestreLion's tip about sudo chmod -t /var/tmp/.oracle seems to be a particularly good example of this. One other point worth mentioning is that Oracle 11gXE is now available. Many of the issues in this post are still relevant. However, if you'd like to know how to install the latest XE on Ubuntu or Mint, here are the instructions So, what should be running ? There are two main components : The Oracle Database The TNS Listener Is it plugged in ? Let's start with the obvious stuff. Can we actually run the shell script that starts everything – the one that's behind the Start Database menu option ? The file that actually runs is : /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh At this point we need to go to t