Oracle Database Discussions

Hello,

My first thread here.
Product: Windows 2003R2 w/ Oracle (10.2.0.1), database created using "dbca".
Installed services, automatic and running at Windows services.msc:
==> OracleDBConsolecm2
==> OracleServiceCM2
==> OracleTNSListener
Very fresh install... everything running fine. Also via browser, I can connect to OEM Database Control.
==========================================
I reboot the Windows 2003 server... and after reboot... my database/service named CM2 does not connect anymore. At Windows services.msc I can see those 3 services above up and running. BUT at Windows task manager-> performance... I see that commited memory is low. What I mean is: When the service/database CM2 is running fine...(working)... the commited memory is about 1GB. But after windows reboot or service restart... (equal at logic point of view)... the amount of commited memory is near 300MB (mainly used by the Windows).

Then... I get a lot of ORA-xxxxxx error messages but I guess the root of problem is here: ORA-01034. Why? Response:

Below is what I did:
======================================================
C:\>set oracle_sid=cm2

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 22:08:38 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Informe a senha:
Conectado a uma instancia inativa.
SQL> select * from v$instance;
select * from v$instance
*
ERRO na linha 1:
ORA-01034: ORACLE not available

SQL> startup
Instancia ORACLE iniciada.

Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 184552300 bytes
Database Buffers 423624704 bytes
Redo Buffers 2940928 bytes
Banco de dados montado.
Banco de dados aberto.
SQL> select count(*) from v$instance;

COUNT(*)
----------
1

SQL>
============================================
So... I have to always startup manually my CM2 service, because when I restart service at Windows services.msc... it says that the service CM2 is restarted and running... but the cause is ORA-01034... and I have to startup manually as above.

Another information: When my instance runs fine... I have an "oracle.exe" in the process list of task manager using large amount of memory. And when the instance/service does not work... I see an oracle.exe using by 10MB of memory. BUT in both cases I see my services/instances running at Windows services.msc;

How to solve this problem?

Thanks,


mson77