Re: Oracle 10g startup problem

Ana Ribeiro wrote:
> 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.

Do you have more than one Oracle environment? The Shared memory realm error is typical when you have two SIDs and one is not running (so sqlplus can find the error message file of the one not running, at least on unix - instead of a TNS error if you had a stopped service on Windows). So while I don't know much about vmware, I suspect you have more than one environment and the one under vmware doesn't know about the other one, oracleserviceMAXIMO. Since you have virtual environments, I expect it would be easy to have things named the same under different virtual or real operating systems, and get very confused. In fact, at this point I'm pretty confused about which operating systems you are using.

Check what ORACLE_HOME and ORACLE_SID are everywhere, including global windows environment variables and the registry. Also check PATH and other oracle environmental variables like TWO_TASK to be sure the sqlplus it is running is the same as the one under ORACLE_HOME\bin.

Maybe you just have a typo in the registry ORACLE_SID... do you have any extra alert logs in your bdump directory(ies) besides alert_MAXIMO.log?

jg

--
@home.com is bogus.
IRIX?  I thought you was dead.
http://www.sgi.com/support/mips_irix.html