Solved

Installing Oracle 11g on VistaHomePremium in a non-domain environment

Posted on 2008-10-20
15
1,439 Views
Last Modified: 2013-11-11
I have a new Vista Home Premium Laptop and I'm trying to install Oracle Database (11g) on so I can learn to use it.  I've installed the Loopback adapter, so I can continue to use DHCP, but I'm in a home workgroup environment rather than a domain environment.  Oracle installed with no errors, but I can't access the Enterprise manager because it cannot find the "website".  There is obviously something still wrong with my network settings, but I'm not sure what to try first.
0
Comment
Question by:ChrisFarris
  • 8
  • 7
15 Comments
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 250 total points
ID: 22759797
your vista firewall will block the oem website.

turn off the firewall, or open up the port
0
 

Author Comment

by:ChrisFarris
ID: 22760207
Still having the same issue.  I first tried opening the port, then I turned the firewall off althogther, and I'm still unable to open he enterprise manager.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22760270
the website is a distinct service,  is it running?
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:ChrisFarris
ID: 22760649
Service is not running, and I could not get it to start (see attached error message)
IMG.jpeg
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22760725
you'll have to look at your System Event log and see if it tells you more info to find what happened.
Check your database alert logs and other logs under your diag directory to see if it's a windows problem or an oracle problem
0
 

Author Comment

by:ChrisFarris
ID: 22761190
It appears from looking at the WIndows Event logs, and Oracle logs that it is an Oracle issue though the descriptions and Oracle Knowledge Base were not very helpful.  Would it be best to uninstall and start over?  I still think this is related to the fact that I'm trying to run this on my home/personal laptop that is in a workgroup environment, and not a part of a domain.  I can't help but think the loopback adapter is not set right.  I'm just not sure what else to do to it.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22764317
You might need to reinstall,  I'm not sure what might be going wrong on your system.  I am not using a loopback adapter.   I didn't do anything special to get Oracle to run other than do the install with an admin account.  
0
 

Author Comment

by:ChrisFarris
ID: 22767731
Are you using a static IP?  I'm going to remove the loopback adapter and assign a static IP to my laptop and re-install.
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 250 total points
ID: 22767768
oh, yes, actually I am using a static ip.  sorry, forgot that.  Been static for a while, didn't even consider it.
0
 

Author Comment

by:ChrisFarris
ID: 22768635
I assigned a static IP, and re-installed.  All of the utilities work (I can see the databases, etc...) except the Database manager (web based utility).  It still won't open, and for some reason is still looking at an old IP (not the new static).  Is there a config file that I could manually go in and assign the IP to use.  It wouldn't let me change it by looking at it's propeties.  If you get this, you will certainly have earned your points.
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 250 total points
ID: 22768965
do you mean you're still connecting to an old ip?

look in your tnsnames.ora

$ORACLE_HOME\network\admin\tnsnames.ora
0
 

Author Comment

by:ChrisFarris
ID: 22770810
I checked the .ora files, and changed the IP address in those.  Still unable to start the console service or the db manager console.
0
 

Author Comment

by:ChrisFarris
ID: 22787800
I was finally able to get the console to come up, but there were numerous problems with getting the database and the listener started.  I've un-installed, and I'm going to set my IP address as static, set up a user password, and try re-installing again to see if I have any more success.  Thanks for your help so far.  I look forward to any advice you have to offer.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22787878
for my home db,  I didn't have any special requirements so I took the default database that is offered when you install.  Did you do that? or did you create your own?

In either case,  what did your alert logs/trace files say?
0
 

Accepted Solution

by:
ChrisFarris earned 0 total points
ID: 22790265
After setting my network card to a static IP, and turning off my wireless card, I did another install accepting the default settings, and everything worked as advertised.  Everything is up and running now (even after turning my wireless card back on).  Thanks for all your assistance.  Let me know what I need to do to make sure you get the assigned points.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle RAC 12c 8 70
join 2 views with 5 conditions 3 54
MULTIPLE DATE QUERY 15 76
Select and Insert Query running slow 4 32
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now