Oracle Developer and Windows XP
I am a student at the University of Phoenix, currently enrolled
in an Oracle class. My book came with Personal Oracle 8i and
Developer 6 for Windows 98. Unfortunatelly, my a new system runs
WinXP Home and not Windows 98.
I first installed the provided Developer and used the default
home (ORANT), then I downloaded Personal Oracle 8i 1.7 for
Win2000, but the install told me I could not use ORANT as the
home. I installed to a new directory called ORAXP.
My problem is that although Personal Oracle works great (I can
connect to my database through SQLPlus), my Developer products
won't (i.e. Procedure Builder) connect to my database. I get the
following error while attempting to connect:
PDE-POC011 ORA-12154: TNS:could not resolve service name
(Additional error: depoc 4)
What is my problem? Do I need to modify the TNSNAMES.ora on
ORANT so that it knows about the database created on ORAXP? Will
I have more issues because I have two Oracle homes?
Thanks in advance.
Alex Traxler
University of Phoenix
BS Information Technology, Database Management Student