Re: Oracle 10g startup problem

Hi Charles,
If I connect in the VMware, open a command prompt window and connect via SQLPlus, I get the message:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I need to MANUALLY startup the database to be able to connect successfully to SQLPlus. The manual connection gives me no errors...

This is the version I am using:
VMware Workstation version 5.5.1 build-19175 XP service pack 2

Many thanks!
Ana

Ana, I have extremely little experience with 10g compared to many of
> the others in the group, but I'd also ask if you can open a command
> prompt window, connect via SQLPlus, and startup the database and if
> not, what type of message(s) it gives you.

Chuck Whealton wrote:

> Ana Ribeiro wrote:
> > Yes Chuck, you understood correctly my problem: I am running my XP
> > system as a virtual machine. My virtual machine has 512MB of memory and
> > my SGA has 164 MB of memory. I decreased my SGA size to 100MB,
> > restarted the VM, but the problem persisted... Do you think that a VM
> > with 512 MB is enough to have an Oracle 10g database (test environment
> > only)? In case it is, what maximum SGA size should I use?
> >
> > Thanks a lot!
> > Regards, Ana
> >
> > Chuck Whealton wrote:
> >
> > > DA Morgan wrote:
> > > > Ana Ribeiro wrote:
> > > > > Hi,
> > > > > I installed Oracle 10g in my computer (windows XP). After restarting
> > > > > the machine, the database did not start automatically.
> > > > >
> > > > > I checked the following issues and everything was correct:
> > > > > 1) Oracle.exe was running
> > > > > 2) No problems in the alert.log of the database
> > > > > 3) No errors in the oradim.log in th $ORACLE_HOME/database directory
> > > > > 4) The windows services were correctly created
> > > > > 5) Th KEYS ORACLE_SID_STARTUP and ORACLE_SID_SHUTDOWN were set to true
> > > > >
> > > > > I even tried to delete and create the service again, but the problem
> > > > > persisted. Any ideas?
> > > > >
> > > > > Note: The environment was created in a VMWARE virtual machine
> > > > >
> > > > > Many Thanks,
> > > > > Ana
> > > >
> > > > XP Home or Professional?
> > > > What does VMWARE have to do with it?
> > > > --
> > > > Daniel A. Morgan
> > > > University of Washington
> > > > damorgan_at_x.washington.edu
> > > > (replace x with u to respond)
> > > > Puget Sound Oracle Users Group
> > > > www.psoug.org
> > >
> > > Dan, the poster is running the XP system as a virtual machine. This
> > > shouldn't have an impact. I've run Oracle under VMware workstation,
> > > VMware Server, and on ESX Server. I also setup shared storage and had
> > > 9i RAC for Windows <shiver...> working under ESX Server.
> > >
> > > This one's a bit strange because Ana has checked everything I know I'd
> > > be checking.
> > >
> > > Ana: How much memory is allocated to the virtual machine and how much
> > > is allocated to your SGA? Is there enough? What I'm getting at is I
> > > did have an experience once under ESX Server where I was using RMAN to
> > > restore a database and because I didn't have enough memory allocated to
> > > the VM, but had an SGA that was way too big for the size of the VM (due
> > > to bringing over the original system's init/spfile), it just seemed to
> > > hang there.
> > >
> > > I allocated more memory to the VM and my problems went away.
> > >
> > > Charles R. Whealton
> > > Charles Whealton @ pleasedontspam.com

>