OraFAQ Forum: Networking and Gateways » TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB

Home » RDBMS Server » Networking and Gateways » TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8.1.7

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

TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8.1.7 [message #157043]

Tue, 31 January 2006 00:12

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi,

I'm not able to start my Oracle listner.
Let me explain you the environment in which I'm working
We have one oracle user and one apps role.

The listner.ora lies in
/usr/app/oracle/product/XHRSDB_8.1.7/network/admin

-rw-r--r-- 1 oracle dba 2192356 Jan 11 16:00 xhrsdb.log
-rw-r--r-- 1 apps11i dba 726 Jan 30 11:35 tnsnames.ora
-rw-r--r-- 1 apps11i dba 910 Jan 31 06:00 listener.ora

I'm geting following error when I try to run
LSNRCTL> start XHRSDB
Starting /usr/app/oracle/product/XHRSDB_8.1.7/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.7.4.0 - Production
.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8.1.7/network/admin
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Solaris Error: 2: No such file or directory

FYI

$ echo $ORACLE_HOME
/usr/app/oracle/product/XHRSDB_8.1.7
$ echo $TNS_ADMIN
/usr/app/oracle/product/XHRSDB_8.1.7/network/admin

Please help me..
I'm very much new to Unix so, it might be a case I'm missing out something in this.

Puneet

Report message to a moderator

Re: TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8 [message #157067 is a reply to message #157043]

Tue, 31 January 2006 03:29

orausern
Messages: 826
Registered: December 2005

Senior Member

can u post your listener.ora? also you trying to start the listener with login of 'oracle' right? (post the output of
'who am i' command.

Report message to a moderator

Re: TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8 [message #157071 is a reply to message #157067]

Tue, 31 January 2006 04:03

orausern
Messages: 826
Registered: December 2005

Senior Member

and also post the output of
ls -ltr /usr/app/oracle/product/XHRSDB_8.1.7/network/admin

you need to check whether you have the permission to write the file...the error is in creating the log file so , the point to check is whether you(ie. the account with which you login) have the rights to create the log file or not..

Report message to a moderator

Re: TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8 [message #157081 is a reply to message #157043]

Tue, 31 January 2006 04:43

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

hi,

thanks for the help n support.
I have sorted out the error, it was ^M symbol at enf of file.

i used dos2unix command and it sorted out.

Regards,
Puneet

Report message to a moderator

Re: TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8 [message #157084 is a reply to message #157081]

Tue, 31 January 2006 04:47

orausern
Messages: 826
Registered: December 2005

Senior Member

great..just curious ^M at the end of which file?

Report message to a moderator

Re: TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8 [message #157192 is a reply to message #157084]

Tue, 31 January 2006 22:12

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi,

I'm very much new to Unix and Vi editor.
To avoid confusion and issues , I copied the file from Unix machine to my window based machine and made few changed and copied back on unix machine.

due to this ^M is added after every line.

I use dos2unix command to remove these characters.

dos2unix <oldfilename> <newfilename>

thanks!

Report message to a moderator

Re: TNSLSNR Error on Unix box, (.logsdb0: error creating log stream /usr/app/oracle/product/XHRSDB_8 [message #157199 is a reply to message #157192]

Wed, 01 February 2006 00:18

orausern
Messages: 826
Registered: December 2005

Senior Member

Thank you!..
If you are new to vi and unix,you can go through some free online resources on vi editor if needed.also check if shell scripting is required to be done, and again there are many free resources available for that too..

Report message to a moderator

Previous Topic:	using dbms_ldap to unlock user accounts in Oracle Internet Directory
Next Topic:	TNS Packet Writer Failure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:54:31 CDT 2024