error in connection between oracle8i&developer2000

pts.
Tags:
Architecture/Design
Availability
Backup & recovery
Database
DB2
Desktops
Interoperability
Management
Microsoft Windows
Oracle
Oracle 8i
Oracle administration
OS
Performance/Tuning
Servers
Software
SQL
SQL Server
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • POWERINIT
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/error-in-connection-between-oracle8ideveloper200... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following