Total Pageviews

Monday 15 June 2015

TNS-00525: Insufficient privilege for operation

[oracle@DB11G2 .oracle]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-JUN-2015 09:45:41

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

Starting /data01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /data01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /data01/app/oracle/diag/tnslsnr/DB11G2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB11G2.localdomain)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
   Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...


Cause:

1) Ensure that /tmp/.oracle or /var/tmp/.oracle directory exists.

2) Confirm that the DBA user who is trying to start the listener has adequate read and write permissions on the directory specified above. The permissions should be 777.

3) If the /tmp directory has reached full capacity, this would cause the listener to fail to write the socket files.

Solution

To implement the solution, please use the following example:

1. cd /var/tmp

2. Check the whether the .oracle directory exists:

cd .oracle

3. If the directory does not exist, request the System Administrator create the directory and set the ownership as root:root with the permissions set to 01777

mkdir /var/tmp/.oracle
chmod 01777 /var/tmp/.oracle
chown root /var/tmp/.oracle
chgrp root /var/tmp/.oracle

[oracle@DB11G2 admin]$ ls -lrtha /var/tmp/
total 12K
drwxr-xr-x. 22 root root 4.0K May  2 04:40 ..
drwxrwxrwt.  3 root root 4.0K Jun  7 08:06 .
drwxrwxrwt.  2 root root 4.0K Jun 15 09:54 .oracle

4. start listener now .

[oracle@DB11G2 network]$ cd /tmp/.oracle/
[oracle@DB11G2 .oracle]$ ls -l
total 0

If my case there were few files under /var/tmp/.oracle with privilege different from oracle . It seems someone tried to start listener from root or non-previleged
user .So remove those files & start listener again .

[oracle@DB11G2 .oracle]$ cd /var/tmp/.oracle
[oracle@DB11G2 .oracle]$ ls -l
total 0
srwxrwxrwx. 1 oracle oinstall 0 Jun  9 08:39 s#7003.1
srwxrwxrwx. 1 oracle oinstall 0 Jun  9 08:39 s#7003.2
srwxrwxrwx. 1    200      200 0 May  2 07:55 s#9991.1
srwxrwxrwx. 1    200      200 0 May  2 07:55 s#9991.2
srwxrwxrwx. 1    200      200 0 May  2 07:55 sEXTPROC1521

rm -rf s#9991.1
rm -rf s#9991.2
rm -rf sEXTPROC1521



[oracle@DB11G2 admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-JUN-2015 09:54:20

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

Starting /data01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /data01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /data01/app/oracle/diag/tnslsnr/DB11G2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB11G2.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                15-JUN-2015 09:54:20
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /data01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /data01/app/oracle/diag/tnslsnr/DB11G2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB11G2.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
  Instance "racdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@DB11G2 admin]$



[oracle@DB11G2 .oracle]$ ls -lrth
total 0
srwxrwxrwx. 1 oracle oinstall 0 Jun 15 09:47 s#2986.1
srwxrwxrwx. 1 oracle oinstall 0 Jun 15 09:47 sEXTPROC1521
srwxrwxrwx. 1 oracle oinstall 0 Jun 15 09:47 s#2986.2
[oracle@DB11G2 .oracle]$

1 comment:

  1. Jadwal Sabung Ayam Online SV388 22 Februari 2019 di Situs Judi Sabung Ayam Online Melalui Agen Resmi Taruhan Sabung Ayam Live Asli Thailand.

    Jumat, Palangkaraya 22 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete