Solved

Oracle on VMware Workstation - Flaky

Posted on 2008-10-22
7
627 Views
Last Modified: 2013-12-18
Greetings - Our company writes software for the parking industry - our database is on Oracle10G. Next month is our usersgroup and we are setting up demo machines. We've used VirtualPC in the past which was very very slow to use and  bootup. We have since purchased a ViMWare Workstation License and are using VmWare Player for the demo's.

however - oracle is acting up on us. The DBConsole does not function correctly - we get error code 2 constantly.
We get the following error when we try to load our Application (Which is an .net App Pool on IIS):

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

Any thoughts on these errors? I've googled this and tried the obvious stuff....anyway if you have any ideas pleae let me know.


Thanks!
0
Comment
Question by:ncartwrightt2systems
  • 3
  • 2
7 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 22782883
That error means the database has not started.

$ sqlplus "/ as sysdba"

SQL> startup


or in windows you can go to the Services menu to start your database service.
0
 

Author Comment

by:ncartwrightt2systems
ID: 22782895
See thats the weird thing - the service in Windows is listed as Started. We restart the service and generally it works. But there have been a couple times that we've had to restart a couple of times. this is not ideal infront of customers :).
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22782912
check your alert logs and any trace files that may be generated.

also of note, is your setup (other than being virtual) mimicking a real install?  That is, will the database, IIS and client machine all be the same?

If not, it maybe be beneficial to bring one real machine acting as the server and use all the virtual machines to run the user's clients.


This might possibly sidestep the problem rather than solve it per se, but it also may (if I'm picturing your real setup correctly) give you and your
customers a better representation of how it will work in a real installation.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:ncartwrightt2systems
ID: 22785464
Typically you'd be correct - with having a seperate oracle server.

The problem is that currently our users go to demo our product on sales calls that may not be able to get to the Internet or what not. We do have an oracle setup in a datacenter that we COULD use but we really do not like being dependant on an Internet connection we can not control.

In addition - the reason we do not have a central server for this propose that i'm refering to is because we'll be in a hotel and do not have the capability for a network to do this - at least not this year.

0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22807243
ok, then back to the original diagnotic quetions.  what's in your alert log and trace files?
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23822912
PAQed with no points refunded (of 500)

Computer101
EE Admin
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle - Query link database loop 8 38
VSphere Alerting 1 40
Choosing a virtualization platform, Hyper-V or VMWare? 5 27
Oracle Insert not working 10 27
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question