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

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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

> 1) Oracle.exe was running
it is not enough on windows, you must also start the oracleMySID service
to have the db up and running + the listener if you plan remote
connections (usually ...)

> 2) No problems in the alert.log of the database
does it tells "instance started" at the end ?

Any ideas?
can you connect via a command line window with
sqlplus "sys as sysdba"
?

good luck,
Patrice Castet
Sr Oracle DBA

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

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

Chuck Whealton wrote:

> Dan, the poster is running the XP system as a virtual machine. This
> shouldn't have an impact.

I may well be wrong here but I disagree. XP is not one thing. And it
might have an impact. Either way verison info was not supplied for the
VMWare either.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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

DA Morgan wrote:
> Chuck Whealton wrote:
>
> > Dan, the poster is running the XP system as a virtual machine. This
> > shouldn't have an impact.
>
> I may well be wrong here but I disagree. XP is not one thing. And it
> might have an impact. Either way verison info was not supplied for the
> VMWare either.
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Actually, you're right. What I really meant to say is that using
VMware (at least any recent version that I've used) shouldn't stop Ana
from running Oracle within a virtual machine - as long as the operating
system is capable of running it.

Ana - what are you using for VMware?

Charles R. Whealton
Charles Whealton @ pleasedontspam.com

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

1. Please do not top post. Scroll to the bottom before replying.

2a. In Windows XP open a command prompt (Run window)
2b. Type: net start oracleservice<service_name>

What happens?
Does that fix the problem?

From first impressions it appears the Oracle service is not started.
You may need to run oradim and drop the existing service and create
a new one (using the oradim executable in $ORACLE_HOME\bin).
--
Puget Sound Oracle Users Group