Database Networking (MOSC)

MOSC Banner

Listener security question

edited Mar 4, 2009 12:49AM in Database Networking (MOSC) 3 commentsAnswered
It has been recommended/required by security that the listener process be run as a different userid than that which owns the oracle process or which installed oracle.  Can someone please explain how this should be done?

When I set up a user, which is also in the dba group, and start the listener as that user, no connection to the database can be made.  The following error is received:

ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied

It seems that what is being asked is not possible.  We've checked that the group permissions are set at the appropriate level (770 or 775) on ORACLE_HOME so a user in the DBA group should be able to run the listener.  This seems like it should be simple, is there some step we are overlooking?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center