Oracle11g: TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation Linux Error: 1: Operation not permitted

TNS-12555: TNS:permission denied 

 TNS-12560: 

  TNS:protocol adapter error

   TNS-00525: Insufficient privilege for operation

    Linux Error: 1: Operation not permitted 

   

В целом где-то не хватает прав, но блин, я ставлю приложение за несколько $1 000 000, а не какой-то open-source и хочу чтоб все работало само по себе.

[oracle@lutz ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-MAY-2015 18:19:43

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

Starting /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /opt/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/app/oracle/diag/tnslsnr/lutz/listener/alert/log.xml
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




Логи естественно ничего нового не дают.

[oracle@lutz ~]$ tail /opt/oracle/app/oracle/diag/tnslsnr/lutz/listener/alert/log.xml
</msg>
<msg time='2015-05-21T18:19:45.218+06:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='lutz'
 host_addr='10.18.1.139'>
 <txt>TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
   Linux Error: 1: Operation not permitted
 </txt>
</msg>
[oracle@lutz ~]$ tail -20 /opt/oracle/app/oracle/diag/tnslsnr/lutz/listener/alert/log.xml
 type='UNKNOWN' level='16' host_id='lutz'
 host_addr='10.18.1.139'>
 <txt>Started with pid=31619
 </txt>
</msg>
<msg time='2015-05-21T18:19:45.217+06:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='lutz'
 host_addr='10.18.1.139'>
 <txt>Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
 </txt>
</msg>
<msg time='2015-05-21T18:19:45.218+06:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='lutz'
 host_addr='10.18.1.139'>
 <txt>TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
   Linux Error: 1: Operation not permitted
 </txt>
</msg>








[oracle@lutz ~]$  cd $ORACLE_HOME
[oracle@lutz dbhome_1]$  cat listener.ora
cat: listener.ora: No such file or directory
[oracle@lutz dbhome_1]$  cat network/admin/listener.ora
# listener.ora Network Configuration File: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = lutz)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /opt/oracle/app/oracle

Решение!
Проблема в том, что ранее на сервере стоял Oracle под другим пользователем.

[oracle@lutz dbhome_1]$ ls -la /var/tmp/.oracle/
total 8
drwxrwxrwt  2 root     geoleader 4096 Jul 15  2014 .
drwxrwxrwt. 5 root     root      4096 May 21 18:18 ..
srwxrwxrwx  1 ogolovin geoleader    0 May 14  2014 s#11575.1
srwxrwxrwx  1 ogolovin geoleader    0 May 14  2014 s#11575.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun 20  2014 s#3113.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun 20  2014 s#3113.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun 16  2014 s#3647.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun 16  2014 s#3647.2
srwxrwxrwx  1 ogolovin geoleader    0 Jul  7  2014 s#3715.1
srwxrwxrwx  1 ogolovin geoleader    0 Jul  7  2014 s#3715.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun  5  2014 s#3744.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun  5  2014 s#3744.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun  2  2014 s#4053.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun  2  2014 s#4053.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun 23  2014 s#4473.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun 23  2014 s#4473.2
srwxrwxrwx  1 ogolovin geoleader    0 May 15  2014 s#4992.1
srwxrwxrwx  1 ogolovin geoleader    0 May 15  2014 s#4992.2
srwxrwxrwx  1 ogolovin geoleader    0 May  5  2014 s#6502.1
srwxrwxrwx  1 ogolovin geoleader    0 May  5  2014 s#6502.2
srwxrwxrwx  1 ogolovin geoleader    0 Jul 15  2014 s#7458.1
srwxrwxrwx  1 ogolovin geoleader    0 Jul 15  2014 s#7458.2
srwxrwxrwx  1 ogolovin geoleader    0 May 28  2014 s#7677.1
srwxrwxrwx  1 ogolovin geoleader    0 May 28  2014 s#7677.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun  9  2014 s#9578.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun  9  2014 s#9578.2
srwxrwxrwx  1 ogolovin geoleader    0 Jun 30  2014 s#9588.1
srwxrwxrwx  1 ogolovin geoleader    0 Jun 30  2014 s#9588.2
srwxrwxrwx  1 ogolovin geoleader    0 Jul 15  2014 sEXTPROC1521

Назначем нового влдельца (владельца oracle) на файл sEXTPROC1521


[root@lutz dbhome_1]#  ll /var/tmp/.oracle/sEXTPROC1521
srwxrwxrwx 1 ogolovin geoleader 0 Jul 15  2014 /var/tmp/.oracle/sEXTPROC1521
[root@lutz dbhome_1]# chown oracle /var/tmp/.oracle/sEXTPROC1521
[root@lutz dbhome_1]#  ll /var/tmp/.oracle/sEXTPROC1521
srwxrwxrwx 1 oracle geoleader 0 Jul 15  2014 /var/tmp/.oracle/sEXTPROC1521



[oracle@lutz dbhome_1]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-MAY-2015 18:33:29

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

Starting /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                21-MAY-2015 18:33:31
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/app/oracle/diag/tnslsnr/lutz/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lutz.cpt)(PORT=1521)))
The listener supports no services
The command completed successfully