Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient Privileges / Oracle Not Available

Re: Insufficient Privileges / Oracle Not Available

From: Jon Fife <jon.fife_at_gmail.com>
Date: 18 Jul 2006 06:08:53 -0700
Message-ID: <1153228133.735779.103240@i42g2000cwa.googlegroups.com>

Adley wrote:
> SQL> conn sys as sysdba
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> IBM AIX RISC System/6000 Error: 2: No such file or directory

I've had similar error messages when my ORACLE_HOME environment variable had a trailing slash on it -- e.g. /opt/oracle/product/8.1.7/ instead of /opt/oracle/product/8.1.7

As for the other scenarios...is your OS user part of the dba group?

Jon Received on Tue Jul 18 2006 - 08:08:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US