Home » RDBMS Server » Networking and Gateways » NL-00280: error creating log stream (Oracle 10g, Ubuntu 64 bit)
NL-00280: error creating log stream [message #572286] Mon, 10 December 2012 01:47 Go to next message
devenz
Messages: 8
Registered: 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 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

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?
Re: NL-00280: error creating log stream [message #572287 is a reply to message #572286] Mon, 10 December 2012 01:50 Go to previous messageGo to next message
devenz
Messages: 8
Registered: 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
Re: NL-00280: error creating log stream [message #572288 is a reply to message #572286] Mon, 10 December 2012 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does the follown not give you some hint?

Quote:
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


Regards
Michel
Re: NL-00280: error creating log stream [message #572289 is a reply to message #572288] Mon, 10 December 2012 02:24 Go to previous messageGo to next message
devenz
Messages: 8
Registered: December 2012
Location: Philippines
Junior Member
Yeah, I tried changing the permission.

And the message is now this:

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-12531: TNS:cannot allocate memory
 TNS-12560: TNS:protocol adapter error
  TNS-00501: Cannot allocate memory

Listener failed to start. See the error message(s) above...
Re: NL-00280: error creating log stream [message #572290 is a reply to message #572289] Mon, 10 December 2012 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-00501: Cannot allocate memory
 *Cause:  Sufficient memory could not be allocated to perform the desired
 activity.
 *Action:  Either free some resource for TNS or add more memory to the
 machine. For further details, turn on tracing and reexecute the operation.

Regards
Michel
Re: NL-00280: error creating log stream [message #572332 is a reply to message #572290] Mon, 10 December 2012 20:20 Go to previous messageGo to next message
devenz
Messages: 8
Registered: December 2012
Location: Philippines
Junior Member
Any help you can get me here?

ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Re: NL-00280: error creating log stream [message #572333 is a reply to message #572332] Mon, 10 December 2012 20:32 Go to previous messageGo to next message
devenz
Messages: 8
Registered: December 2012
Location: Philippines
Junior Member
forget about that.

im having this one now:

ORA-27140: attach to post/wait facility failed
Re: NL-00280: error creating log stream [message #572334 is a reply to message #572332] Mon, 10 December 2012 20:32 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
do EXACTLY as below (line for line with nothing added & nothing left out)

sqlplus
/ as sysdba
shutdown abort
startup

COPY the results from above & then PASTE all back here
Re: NL-00280: error creating log stream [message #572335 is a reply to message #572334] Mon, 10 December 2012 20:52 Go to previous messageGo to next message
devenz
Messages: 8
Registered: December 2012
Location: Philippines
Junior Member
done as instructed
got this during startup

ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size		    1260292 bytes
Variable Size		  163579132 bytes
Database Buffers	  436207616 bytes
Redo Buffers		    2932736 bytes
Database mounted.
Database opened.
Re: NL-00280: error creating log stream [message #572336 is a reply to message #572335] Mon, 10 December 2012 21:03 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
OK, now the database is up, online & available for users.
Re: NL-00280: error creating log stream [message #572337 is a reply to message #572336] Mon, 10 December 2012 21:05 Go to previous messageGo to next message
devenz
Messages: 8
Registered: December 2012
Location: Philippines
Junior Member
Yeah but i'm now having this problem:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-DEC-2012 11:03:21

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracletest)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Re: NL-00280: error creating log stream [message #572338 is a reply to message #572337] Mon, 10 December 2012 21:16 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
UBUNTU is NOT a supported OS

>Linux Error: 2: No such file or directory
> Linux Error: 111: Connection refused

both indicate OS/Networking mis-configuration
I won't waste more time when I have no assurance that it will ever work.

You could try to move, remove, delete, rename the listener.ora file since it is NOT required before doing as below

lsnrctl start
Re: NL-00280: error creating log stream [message #572339 is a reply to message #572338] Mon, 10 December 2012 21:25 Go to previous messageGo to next message
devenz
Messages: 8
Registered: December 2012
Location: Philippines
Junior Member
I see.

But do you think that it will work for a 32bit UBUNTU installation instead?
Re: NL-00280: error creating log stream [message #572342 is a reply to message #572339] Mon, 10 December 2012 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
devenz wrote on Mon, 10 December 2012 19:25
I see.

But do you think that it will work for a 32bit UBUNTU installation instead?


>Our previous installation on ubuntu 32bit os was successful.
If you say so.
Re: NL-00280: error creating log stream [message #572346 is a reply to message #572337] Tue, 11 December 2012 01:34 Go to previous message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
TNS-00511: No listener


Start the listener.

Regards
Michel
Previous Topic: ORA-12154: TNS: could not resolve the connect identifier specified
Next Topic: Networking issue over WAN
Goto Forum:
  


Current Time: Fri Oct 31 10:04:10 CDT 2014

Total time taken to generate the page: 0.29409 seconds