Solved

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

Posted on 2008-10-20
15
1,437 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
Comment Utility
your vista firewall will block the oem website.

turn off the firewall, or open up the port
0
 

Author Comment

by:ChrisFarris
Comment Utility
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
Comment Utility
the website is a distinct service,  is it running?
0
 

Author Comment

by:ChrisFarris
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 

Author Comment

by:ChrisFarris
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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

763 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

6 Experts available now in Live!

Get 1:1 Help Now