Re: Oracle 10g startup problem

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Sep 2006 07:03:03 -0700
Message-ID: <1157551380.444510@bubbleator.drizzle.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

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

Received on Wed Sep 06 2006 - 09:03:03 CDT