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?

    Requires Free Membership to View

    Login

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 first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top