Home » RDBMS Server » Server Administration » Connectivity with form6 and oracle 8i problem
Connectivity with form6 and oracle 8i problem [message #51219] Tue, 07 May 2002 21:40 Go to next message
Zahid Rahim
Messages: 31
Registered: April 2002
Member
I installed oracle 8i on my win2000 system.after stopping services i installed Forms6 and now every thing has installed perfectly.sql prompt works perfectly. and form 6 executes perfectly. but they did not connect with oracle server with the error message TNS:could not resolve service name.
any in time help will really be appreciated.
Re: Connectivity with form6 and oracle 8i problem [message #51235 is a reply to message #51219] Wed, 08 May 2002 08:22 Go to previous messageGo to next message
krb
Messages: 25
Registered: March 2002
Junior Member
tns should be added in two places in your case . One in Oracelnetworkadmin and the other in ora81net80admin for default installation.
so check the tnsnames.ora in both places. Most probably it is missing in ora81net80 (ie. wher forms is installed)
Re: Connectivity with form6 and oracle 8i problem [message #51237 is a reply to message #51219] Wed, 08 May 2002 08:27 Go to previous messageGo to next message
krb
Messages: 25
Registered: March 2002
Junior Member
tns should be added in two places in your case . One in Oracelnetworkadmin and the other in ora81net80admin for default installation.
so check the tnsnames.ora in both places. Most probably it is missing in ora81net80 (ie. wher forms is installed)
Connectivity with form6 and oracle 8i problem did not solve yet [message #51258 is a reply to message #51219] Thu, 09 May 2002 23:17 Go to previous messageGo to next message
Zahid Rahim
Messages: 31
Registered: April 2002
Member
Hello,
you send a reply to this problem but unfortunately problem did not solve i did every thing according to ur advice but in vain.

I installed oracle 8i on my win2000 system.after stopping services i installed Forms6 and now every thing has installed perfectly.sql prompt works perfectly. and form 6 executes perfectly. but they did not connect with oracle server with the error message TNS:could not resolve service name.
any in time help will really be appreciated.

Anyother advice plz mail me.
waiting for ur reply: Zahid Rahim
Re: Connectivity with form6 and oracle 8i problem did not solve yet [message #51284 is a reply to message #51258] Sun, 12 May 2002 19:15 Go to previous message
Anil
Messages: 80
Registered: September 2001
Member
Hi,

You need to modify the tnsnames.ora file which is on your system. The file should contain the server information, like port, SID etc...! Then try connecting to the server. Make a fresh start after modifying.

Take care,
Regards,
Anil
Previous Topic: I cann't open my database!
Next Topic: very very very urgent .......
Goto Forum:
  


Current Time: Mon Sep 09 18:48:24 CDT 2024