Home » Developer & Programmer » Forms » TNS could not resolve service name  () 1 Vote
TNS could not resolve service name [message #274447] Tue, 16 October 2007 01:56 Go to next message
axiom
Messages: 26
Registered: August 2007
Junior Member
Hi all
i have installed forms6i on XP & oracle 9i on same machine.
i connected to oracle but while connecting with forms it gives the error as TNS could not resolve the service name.
i have set the tns in tnsname.ora file then also it shows error.
can any one give me the solution for this.

my datbase name is axiom
thanks
Re: TNS could not resolve service name [message #274462 is a reply to message #274447] Tue, 16 October 2007 02:39 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Have you set the TNSNAMES in both Oracle homes? The easiest is to use the IFILE notation to point to the other TNSNAMES.ORA file.

MHE
Re: TNS could not resolve service name [message #274464 is a reply to message #274462] Tue, 16 October 2007 02:44 Go to previous messageGo to next message
axiom
Messages: 26
Registered: August 2007
Junior Member
yes i hane set in both oracle homes
but still it is not working
i m not getting where is the problem
Re: TNS could not resolve service name [message #274502 is a reply to message #274447] Tue, 16 October 2007 04:35 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Check that host name is correct and also check that is the Sid is correct.

If both is correct then check that is it connecting through SQL with connect string.

Regards,
Azam Khan
Re: TNS could not resolve service name [message #274687 is a reply to message #274502] Tue, 16 October 2007 18:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Also, search this forum for 'tns_admin' and consider whether using it would be easier.

David
Re: TNS could not resolve service name [message #275436 is a reply to message #274687] Sat, 20 October 2007 01:24 Go to previous messageGo to next message
alijeyan
Messages: 180
Registered: January 2007
Location: IRAN
Senior Member
Hi

I Have this problem . I install Form6i and Oracle 9i On WINXP
with these step :

1- Uninstall OLD Oracle . delete all keys in registry and delete All Folders .

2- install DEVELOPER on DRIVE:\orant

3- install ORACLE DATABASE 9 on DRIVE:\oracle\ora90 with HOME :orahome90 .

4 - do not modify TNSNAMES .

5 - USE FORMS6i and ORACLE 9i

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Re: TNS could not resolve service name [message #275558 is a reply to message #275436] Sun, 21 October 2007 19:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I would have suggested installing and testing the database before installing the Forms Developer.

So what is the problem that you are currently facing?

David
Previous Topic: Problem NLS_lang=ARABIC_ALGERIA.AR8MSWIN1256
Next Topic: TNS in FORM10g
Goto Forum:
  


Current Time: Mon Dec 05 07:06:22 CST 2016

Total time taken to generate the page: 0.27804 seconds