Solved

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

Posted on 2008-10-20
15
1,442 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 74

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 74

Expert Comment

by:sdstuber
ID: 22760270
the website is a distinct service,  is it running?
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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 74

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 74

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 74

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 74

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 74

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

695 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