LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 05-25-2006, 08:06 AM   #1
debasish_5849
Member
 
Registered: Jan 2006
Location: India
Distribution: fedora core 5
Posts: 42

Rep: Reputation: 15
Unhappy oracle 10g on fc5 TNS-00525: Insufficient privilege for operation


Hi,
I have recently installed oracle 10g express edition on my fc5 os and the server is up and running, thus i can connect with oracles connect.

However the http server is not working and the log file listener.log contains the following.



TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 25-MAY-2006 18:01:56

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

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
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=3625
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12555: TNS: permission denied
TNS-12560: TNS: protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

what can i do to get rid of this?
thank you in advance

Last edited by debasish_5849; 05-25-2006 at 08:12 AM.
 
Old 05-26-2006, 04:25 AM   #2
bosewicht
Senior Member
 
Registered: Aug 2003
Location: Honolulu, HI
Distribution: Arch
Posts: 1,380

Rep: Reputation: 47
did you edit listener.ora? Check to see if you have a duplicate SID_NAME entry, if so, put the original
SID_NAME=PLSExtProc back (from 10gR1 server) or you can try to login as user oracle, and run netca to create/delete/test listeners.
 
Old 05-26-2006, 04:23 PM   #3
debasish_5849
Member
 
Registered: Jan 2006
Location: India
Distribution: fedora core 5
Posts: 42

Original Poster
Rep: Reputation: 15
I did not actually edit anything (Not that I know what to edit!)

This is my listener.ora

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)
____________________________________________________________________________________
And just in case its necessary

the following is my tnsnames.ora

# tnsnames.ora Network Configuration File:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(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)
)
)

_____________________________________________________________________________________
What is netca? I did not find that command


Thank you once again

Last edited by debasish_5849; 05-26-2006 at 04:27 PM.
 
Old 02-27-2008, 05:58 AM   #4
mesz
LQ Newbie
 
Registered: Feb 2008
Distribution: Ubuntu 7.10 (Gutsy)
Posts: 3

Rep: Reputation: 0
Hi debasish_5849,

I've been deal with the same problem like yours,..!

Then I changed the listener config (listener.ora) like this:

mesz@zorg-base:~$ more /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = zorg-base)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

The change is to remark (put #) in the begining of line:
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

Seem's like trouble with IPC protocol or mechanism,..?
But still don't know why this can be hapenned.

FYI, I'm using Ubuntu Gutsy, hopefully this will help!

BR,

Mesz
 
Old 02-27-2008, 05:59 AM   #5
mesz
LQ Newbie
 
Registered: Feb 2008
Distribution: Ubuntu 7.10 (Gutsy)
Posts: 3

Rep: Reputation: 0
Hi debasish_5849,

I've been deal with the same problem like yours,..!

Then I changed the listener config (listener.ora) like this:

mesz@zorg-base:~$ more /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = zorg-base)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

The change is to remark (put #) in the begining of line:
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

And then the listener suddenly works fine!

Seem's like trouble with IPC protocol or mechanism,..?
But still don't know why this can be hapenned.

FYI, I'm using Ubuntu Gutsy, hopefully this will help!

BR,

Mesz
 
  


Reply

Tags
oracle


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
"ORA-12547: TNS:lost contact" when creating database in Oracle 10g Dtsazza Linux - Software 4 04-25-2009 09:54 AM
Help with Oracle 10g brazilian_user Linux - Networking 2 02-09-2006 02:47 PM
Insufficient Privilege instead of Root Password Request buckberger Linux - Security 3 12-25-2004 08:00 PM
Oracle 10G vs 9i sashie Linux - Software 0 06-07-2004 02:37 PM
tnsping : TNS-12541: TNS: no listener hpmface Linux - Networking 4 05-31-2004 12:38 PM


All times are GMT -5. The time now is 11:29 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration