NetBackup IT Analytics - Unable to start Oracle Listener - error returned TNS-12546: TNS: permission denied

Problem

NetBackup IT Analytics - Unable to start Oracle Listener - error returned TNS-12546: TNS: permission denied.
 

Error message

# /opt/aptare/bin/aptare status
Oracle Database is running..
Oracle Listener is NOT running..
Zookeeper Server (org.apache.zookeeper.server.quorum.QuorumPeerMain) (PID 2526) is running...
Kafka Server (kafka.Kafka) (PID 6321) is running...
Portal Service is running...
Agent Service is running...
Anomaly Service is running...
Apache Web Service (/bin/httpd) (PID 9153 9163 9164 9165 10034) is running...

Cause

Missing proper permissions to start the service.

# su - aptare

$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-JAN-2024 19:30:26
Copyright (c) 1991, 2023, Oracle.  All rights reserved.
Starting /opt/aptare/oracle/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/aptare/oracle/network/admin/listener.ora
Log messages written to /opt/aptare/diag/tnslsnr/APTAREPORTAL/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=extproc))
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied
Listener failed to start. See the error message(s) above...
 

Solution

1. Verify that the Oracle install path /opt/aptare/oracle has the proper permissions set for owner and group to: aptare:dba

# chown -R aptare:dba /opt/aptare/oracle

2. Verify that the path /var/tmp/.oracle has the proper permissions set for owner and group to: aptare:aptare

# chown -R aptare:aptare /var/tmp/.oracle

After fixing the permissions, stop and start all Portal Server services as root:

# /opt/aptare/bin/aptare stop

# /opt/aptare/bin/aptare start