Re: Help with 9i install problem on E450 running Solaris 2.8

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 10 Sep 2003 08:59:51 +1000
Message-ID: <3f5e5bde$0$14560$afc38c87@news.optusnet.com.au>

"SteveW" <swensel_at_mahinetworks.com> wrote in message news:251366e0.0309091344.490cf538_at_posting.google.com...
> I've downloaded Oracle and have installed 9i on my machine. There was
> no previous instance of Oracle running. I get through the install, and
> it appears that the server is running in that the processes are up,
> including the listener. When I try to connect with sqlplus I get this
> message:
> bash-2.03$ sqlplus
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 9 14:41:59 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter user-name: system
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SVR4 Error: 2: No such file or directory
>

Try loggin on as SYS instead of system, and then starting the instance. Once that's running, *then* you can connect as SYSTEM. Password for SYS should be 'change_on_install' (there's a message there, somewhere!), and you'll need the 'AS SYSDBA' switch, too. IE:

connect sys/c_o_I as sysdba

Should say 'connected to an idle instance'.

Regards
HJR Received on Tue Sep 09 2003 - 17:59:51 CDT