Ran into this issue where multiple Oracle Homes resides with listeners running from under different OS users or we are/have been running the same listener under different OS user(s).
Trying to start the listener it is failing with permissions errors:
— OR —
Some of the changes associated with such errors are:
- Some IPC keys have been reused from older listener(s)
- Same listener has previously been started under different OS users
- Listeners running under different OS users are using the same IPC keys
- Permissions in /var/tmp have been previously reset.
Older IPC socket file(s) were left in /var/tmp/.oracle and they cannot be deleted by the listener upon startup.
Please be aware that this step should ONLY be taken as a last resort and ONLY when there are no Net connections to the database(s). This procedure could cause active sessions to be terminated. It is NOT recommended to take this action in a RAC environment.
· Stop all listeners
· Remove the /var/tmp/.oracle directory, e.g. run the following from the root account:
rm -rf /var/tmp/.oracle
Clearing the /var/tmp/.oracle directory will force the listeners to recreate the socket files from fresh, each with its own correct ownership.