Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Installing Oracle Express 10.2.0 on Vista PC's / Laptop

Posted on 2008-07-23
3
Medium Priority
?
2,167 Views
Last Modified: 2013-12-18
I've done some testing, so hopefully the next few lines will asssit in the solution.

I'm trying to install Oracle Express Edition 1og onto a vista laptop.  I have attemted to install this onto my lapot and the installtion seems to run through fine, but looking more deeply it has not created the 6 test databases (found under c:\Oraclexe\oracledata\XE\) and it's failed on most of the .sql scripts.
At first I thought it was vista, so I installed on an XP machine (As per usual this works fine)

SO.....it must be security issue, so... I have two spare laptop sitting around, one which has been connected to my domain, the user has admin rights, and is a menber of the Administrators group in Active Directory.
The other laptop is again a clean install but is sitting on his own workgroup, (not connected to my domain)

I ran the install as administrator, watch the process go through, and the laptop which has been connected to my domain failed to run the scripts and create the database, the other laptop which runs from it's own workgroup works fine, created the db's and I can access the web based home page on http://127.0.0.1/apex.

Where am I going wrong on the first domain added laptop ?
XP machines run fine.......How can I get around this problem ?
0
Comment
Question by:thegiantsmurf
[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
  • 2
3 Comments
 

Author Comment

by:thegiantsmurf
ID: 22068099
OK....quick update.
Looking around the web, most people mention that you need to run the install from a Administrator command prompt.  This allows higher admin rights than just running from windows explorer (right click, run as admin).
Still no joy
0
 

Accepted Solution

by:
thegiantsmurf earned 0 total points
ID: 22121409
Case solved,

the solution is the hidden Aministrator in Vista
Run a command prompt as administrator, click continue, type in "net user administrator /active:yes"
it should reply back with command accepted
Logoff the current user, the hidden administrator logon will now appear (complete with no password) logon, install software, give the previous user complete access to the directory, log off, re-logon as the end user, command prompt, "net user administrator /active:no".
Problem solved, even if the end user has admin rights, you need super user access to create databases via scripts.

This never happens on XP / windows 2000 machine only Vista.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 22121440
You have to check if Oracle Express is certified to run under Vista.
All installations should be done under Administrator account.
Also you should start the http server somehow.
I have experience to work with 11g where Express is
part of the DB.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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 …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

618 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