LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   oracle 10g on fc5 TNS-00525: Insufficient privilege for operation (http://www.linuxquestions.org/questions/linux-software-2/oracle-10g-on-fc5-tns-00525-insufficient-privilege-for-operation-448405/)

debasish_5849 05-25-2006 08:06 AM

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

bosewicht 05-26-2006 04:25 AM

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.

debasish_5849 05-26-2006 04:23 PM

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

mesz 02-27-2008 05:58 AM

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

mesz 02-27-2008 05:59 AM

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


All times are GMT -5. The time now is 09:14 PM.