Database Administration (MOSC)

MOSC Banner

sqlplus not working

edited Aug 28, 2012 9:41PM in Database Administration (MOSC) 4 commentsAnswered ✓
This is a 10.2.0.4 installation on linux. I login to the db server box as unix user tstusr
uid=505(tstusr) gid=505(tstusr) groups=505(tstusr) context=user_u:system_r:unconfined_t

I set the ORACLE_SID, ORACLE_HOME, PATH & LB_LIBRARY_PATH to the appropriate values and invoke sqlplus to connect to the database as a non-privileged user called oracle who has been given connect, create session and resource and the following error is reported..

sqlplus oracle/oracle

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 29 14:03:00 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center