Two of the reasons are
1)check ORACLE_HOME is pointing to correct location
2)check user who is going to connect database permessions etc
Jon Fife wrote:
> 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 - 12:33:43 CDT
