Re: CAN'T GET TO SQLPLUS

From: Lando <MarkL_at_quebim.com>
Date: 1998/01/09
Message-ID: <34B69475.508BCAB@quebim.com>#1/1

What happened after Dec 30th? Can the oracle owner use sqlplus? One thing you can check is to see if the setuid bit on the oracle binary
is set: .
ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x

If you don't see the last 's' do:

chmod 6751 $ORACLE_HOME/bin/oracle

stop/restart the db.

M.Landa

gschwenk wrote:

> I have users trying to go to 'sqlplus' that get the following error
> message:
>
> ORA_1034:ORACLE NOT AVAILABLE
> ORA_7230:smsget: shmat error when trying to attach to SGA
> IBM AIX RISC/T6000 ERROR 13: PERMISSION DENIED
>
> The database is running and is available.
> User .profiles seem to be fine.
> The file size for memory seems to be okay.
> These users were able to access sqlplus prior to December 30,1997
> with no problem.
>
> Any ideas????
Received on Fri Jan 09 1998 - 00:00:00 CST