Re: Oracle 10g startup problem

Dan,
As soon as I logged in the VMware, I checked the service "OracleServiceMAXIMO". Its Status was "Started" and its Startup Type was "Automatic". I tried to connect to the MAXIMO database in SQLPlus and got the error message:

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

Then I followed your suggestion to open a command prompt and run "net start oracleserviceMAXIMO". The problem persisted, I got the same error in SQLPlus ... Only after manually doing a startup of the database I could successfully connect in SQLPlus.

My understanding is that the service was running, BUT somehow the database is not being automatically started... Any other suggestion?

PS: fyi, the service OracleDBConsoleMAXIMO had the same status (STARTED) and statup type (AUTOMATIC) when I logged in the VMware.

Many Thanks for the help!
Ana

Patrox wrote:

> > 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
Received on Wed Sep 06 2006 - 12:52:43 CDT