Solved

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

Posted on 2008-10-20
15
1,440 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 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
form builder not starting 3 72
Need SQL Query to Find Foreign-keys Without Indexed Columns 4 33
how to tune the query 17 59
MS SQL Server Management Studio R2 4 32
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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…

730 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