Re: Oracle 9i problem

Hi Fabrizio,

It means that Oracle is unable to access the shared (SGA) memory, which probably means you haven't started the instance/database.

You need to connect as a sysdba (connect / as sysdba or connect sys/password as sysdba) and issue the STARTUP command.

Then you should be cooking.

Good Luck

Richard
"Fabrizio" <rizla_at_freemail.it> wrote in message news:a0da3a6e.0207080053.b079d2d_at_posting.google.com...
> Hello,
>
> I'm trying Oracle 9i on my linux box, but I encounter some problem.
>
> I've created the 2 databases with dbca. It works fine. (I see in
> /etc/oratab the 2 entry related to the database)
>
> Here's the entry:
>
> *:/home/oracle/OraHome1:N
> ags:/home/oracle/OraHome1:Y
> mauro:/home/oracle/OraHome1:N
>
> The envoirment for oracle user are:
>
>
> [oracle_at_srv01 oracle]$ env |grep -i ORACLE
> PWD=/home/oracle
> ORACLE_SID=ags
> LD_LIBRARY_PATH=/home/oracle/OraHome1/lib:/lib:/usr/lib:/usr/local/lib
> USER=oracle
> MAIL=/var/spool/mail/oracle
> ORACLE_BASE=/opt/oracle
> ORACLE_HOME=/home/oracle/OraHome1
> ORACLE_TERM=xterm
> LOGNAME=oracle
> ORA_NLS33=/home/oracle/OraHome1/ocommon/nls/admin/data
> HOME=/home/oracle
>

PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/OraHome1/bin:/ home/oracle/bin
>
> So, to start with db I lunch:
>
> sqlplus system/<pass> @ags
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jul 8 10:50:20 2002
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
> What does it means ? May be it means that the oracle services are not
> started...
> In this case, how to start it ?
>
> Thanks a lot
Received on Mon Jul 08 2002 - 04:42:50 CDT