OraFAQ Forum: Networking and Gateways » NL-00280: error creating log stream

Home » RDBMS Server » Networking and Gateways » NL-00280: error creating log stream (Oracle 10g, Ubuntu 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NL-00280: error creating log stream [message #572286]

Mon, 10 December 2012 01:47

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?

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

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: NL-00280: error creating log stream [message #572289 is a reply to message #572288]

Mon, 10 December 2012 02:24

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...

Report message to a moderator

Re: NL-00280: error creating log stream [message #572290 is a reply to message #572289]

Mon, 10 December 2012 02:36

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: NL-00280: error creating log stream [message #572332 is a reply to message #572290]

Mon, 10 December 2012 20:20

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

Report message to a moderator

Re: NL-00280: error creating log stream [message #572333 is a reply to message #572332]

Mon, 10 December 2012 20:32

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

Report message to a moderator

Re: NL-00280: error creating log stream [message #572334 is a reply to message #572332]

Mon, 10 December 2012 20:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: NL-00280: error creating log stream [message #572335 is a reply to message #572334]

Mon, 10 December 2012 20:52

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.

Report message to a moderator

Re: NL-00280: error creating log stream [message #572336 is a reply to message #572335]

Mon, 10 December 2012 21:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

OK, now the database is up, online & available for users.

Report message to a moderator

Re: NL-00280: error creating log stream [message #572337 is a reply to message #572336]

Mon, 10 December 2012 21:05

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

Report message to a moderator

Re: NL-00280: error creating log stream [message #572338 is a reply to message #572337]

Mon, 10 December 2012 21:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator