Re: Oracle 10g startup problem

Ana Ribeiro wrote:
> 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
> >
> > 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.
> >
> > Charles R. Whealton
> > Charles Whealton @ pleasedontspam.com

Ana:

I'm sorry to say I'm pretty much out of ideas at this point. I'd try what the other posters are suggesting.

But I wll ask, have you looked in the Windows event log? Just right click on "My Computer" and select "Manage", then go to the system tools/event viewer area.

Anything there?

It's probably something EXTREMELY simple, though I will say you've checked a bunch of the stuff that I'd look at first.

The only other time I've experienced what you're experiencing with 10g, is with 8i running under Windows 2000. The databases wouldn't start automatically, though you could login and start them with SVRMGRL without problem. It turned out to be an issue that Oracle addressed with a patch.

Undoubtedly NOT applicable here.

Charles R. Whealton
Charles Whealton @ pleasedontspam.com Received on Wed Sep 06 2006 - 20:43:44 CDT