Question

error in connection between oracle8i&developer2000

Database, Oracle, DB2, SQL, Microsoft Windows, OS, Servers, SQL Server, Security, Desktops, Management, Windows, Oracle administration, Architecture/Design, Availability, Backup & recovery, Installation, Migration, Performance/Tuning, Oracle 8i, Tech support, Hardware, Interoperability, Software

I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 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?

You can definitely install Oracle8i Enterprise and Developer 2000 on the same machine. However, your tnsnames.ora file must contain the information necessary for Developer 2000 to connect with your database.

With Oracle Developer 2000 on a PC there is usually a "SQL NET" program you can use to set this up automatically. Have you found or configured your SQL*NET? (aka Net 80 or Net Configuration Assitant).

Being on different partitions could present a problem for the standard connection, but the proper configuration of SQL NET, or, if necessary, your tnsnames.ora file should provide connectivity.

Your SQL NET should be under All Programs, Oracle, under some subfolder, I don't recall off-hand. It should be called SQL NET, NET 80 or Net Configuration Assistant.

Your tnsnames.ora will probably be in C:Oracle"yourOracleVersion"networkadmintnsnames.ora
HOWEVER, if you don't know how to manipulate tnsnames.ora files, you shouldn't edit this file. Your Network Configuration (SQL NET , NET 80, Net Configuration Assitant) will modify this file for you.

FOR EXAMPLE (your tnsnames.ora file should look something like this):

# C:ORAWIN95NET80ADMINTNSNAMES.ORA Configuration File:C:orawin95net80admintnsnames.ora
# Generated by Oracle Net8 Assistant

"MY_SID.MY_HOST.COM" =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = "your_host***")(PORT = 1521))
(CONNECT_DATA = (SID = "SID_name_of_your_database"))
)

Names in quotes:"" should be substituted by the actual names on your system, for example:

# C:ORAWIN95NET80ADMINTNSNAMES.ORA Configuration File:C:orawin95net80admintnsnames.ora
# Generated by Oracle Net8 Assistant

WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1521))
(CONNECT_DATA = (SID = ORA1))
)

***A critical part of this configuration is knowing the "Host" name of the filesystem where the oracle database instance resides (I.P. address may be used but is discouraged because a host name, which is basically a virtual I.P. address, is more portable). With the partition, this may be different than the partition that Developer 2000 is on. Contact your network administrator to find out what "host" name refers to the partition where the oracle database instance resides.