Q
Problem solve Get help with specific problems with your technologies, process and projects.

Installing Oracle8i and Developer 2000 on same machine

I'm installing Oracle8i on Windows XP and on the same machine I'm installing Developer 2000 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i Enterprise and Developer 2000 on the same machine?

I'm installing Oracle8i on Windows XP and on the same machine I'm installing Developer 2000 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i Enterprise and Developer 2000 on the same machine?
Neither Oracle8i nor Developer2000 are supported on the Windows XP platform according to Oracle's certification matrix.

I would recommend that you install products that are supported for Windows XP. The specific error that you are...

receiving indicates that the database listener must be started and properly configured to allow connections to the database. You must have configured a listener.ora, as well as a tnsnames.ora file on your machine. Test connectivity using the tnsping command as follows:

[oracle@RHEL3 oracle]$ tnsping tst1
 
TNS Ping Utility for Linux: Version 10.1.0.3.0 - 
Production on 21-JUL-2006 11:25:14
 
Copyright (c) 1997, 2003, Oracle.  All rights reserved.
 
Used parameter files:
 
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) 
(CONNECT_DATA = (SERVICE_NAME = tst1.world)))
OK (0 msec)
If the tnsping command is successful (as above with an "OK" result), then you should be able to establish a connection to your Oracle database.
This was last published in July 2006

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close