Database Administration (MOSC)

MOSC Banner

unix user is not recognizing ORACLE_SID environment variable

edited Mar 15, 2011 5:28AM in Database Administration (MOSC) 9 commentsAnswered ✓
Hi Everyone
We seems to have got a new issue.

When we login to the Oracle server as a "unixid" who is not a member of the DBA and issue the command: "sqlplus userid/passwd", we got this error: (ORACLE_SID is set with the login script)
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
HPUX-ia64 Error: 13: Permission denied

However this command still works: "sqlplus userid/passwd@ORACLE_SID".

Previously, both commands were able to login.

Do you know whar might have happened that cause this new behavior? how can I fix this?

Thanks.

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