Re: Oracle 10g startup problem


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@xxxxxxxxxxxxxxxx
(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

.

Relevant Pages

  • Re: Oracle 10g startup problem
    ... system as a virtual machine. ... my SGA has 164 MB of memory. ... I decreased my SGA size to 100MB, ... VMware Server, and on ESX Server. ...
    (comp.databases.oracle.server)
  • Re: Memory Sizing Advice
    ... box and setting the SGA size at 20G? ... memory to keep the box out of swap)? ... creating a scenario of constant paging/swapping to/from disk. ... course even a successful allocation of that much memory to the SGA ...
    (comp.databases.oracle.server)
  • Re: ORACLE ON AIX PERFORMANCE PROBLEMS
    ... causes the page stealer to kick in and free a few frames. ... paging activity to/from paging space, ... SGA to be pinned in memory so that it can never be swapped out. ...
    (comp.unix.aix)
  • Re: I/O performance troubleshooting
    ... You are running out of memory a lot, but not paging as a result. ... The comments on the SGA look dead on to me. ... I should alocate more of it to Oracle. ... It seems pretty obvious to me my performance problem is with the disks I have. ...
    (AIX-L)
  • Re: Memory Sizing Advice
    ... box and setting the SGA size at 20G? ... memory to keep the box out of swap)? ... course even a successful allocation of that much memory to the SGA ... saying that 12G for the OS would be starving it? ...
    (comp.databases.oracle.server)