Home » Developer & Programmer » Forms » connectivity problem of personal oracle 8i with developer 6i
connectivity problem of personal oracle 8i with developer 6i [message #126246] Fri, 01 July 2005 22:42 Go to next message
anupamkharkwal
Messages: 2
Registered: July 2005
Location: NOIDA
Junior Member
Dear sir,
My name is anupam. i have started my oracle developer track.
i have installed the personal oracle 8i on window2000 personnel edition.
next i installed developer 6i .........

when i start oracle it works but when i open forms
and try to connect with oracle it give tns error.

plz help me out in this matter. Your earlier response
will be appreciated.

thanks
Anupam Kharkwal.
Re: connectivity problem of personal oracle 8i with developer 6i [message #126282 is a reply to message #126246] Sat, 02 July 2005 17:02 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Search for the TNSNAMES.ORA file in the developer installation directory. Let it point to the other TNSNAMES.ORA file ( of your Oracle PE installation ). You can do this by putting

IFILE=_the_other_tnsnames_ora_file_location_

instead of whatever is in there.

MHE
icon14.gif  Re: connectivity problem of personal oracle 8i with developer 6i [message #126690 is a reply to message #126246] Wed, 06 July 2005 04:01 Go to previous messageGo to next message
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
Senior Member
Hi,
U can connect by following steps.
1. First go to directory of installation of
oracle8i/ora81/network/admin/tnsnames.ora
open tnsnames.ora as text file.
copy only that loop which contains database/service name
2. Then go to directory of installation of
d2k6i/net81../admin/tnsnames.ora
open tnsnames.ora as text file.
Then Paste it down.

Then check connection.


Re: connectivity problem of personal oracle 8i with developer 6i [message #126817 is a reply to message #126690] Wed, 06 July 2005 15:42 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I'd suggest not to. I'd still go for the IFILE solution I suggested earlier. It's easier to maintain, but hey: it's your environment.

MHE
Re: connectivity problem of personal oracle 8i with developer 6i [message #126849 is a reply to message #126817] Wed, 06 July 2005 23:09 Go to previous messageGo to next message
anupamkharkwal
Messages: 2
Registered: July 2005
Location: NOIDA
Junior Member
Hi,now i have solve my problem..........Global Database name must be ORCL in Oracle.tns listner problem is solved.
icon11.gif  Re: connectivity problem of personal oracle 8i with developer 6i [message #247166 is a reply to message #126849] Sun, 24 June 2007 22:37 Go to previous messageGo to next message
shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI
Junior Member
Pls help me
how did u solve this problem because I have same problem
I am also unable to connect form6i with oracle.

What is Ifile ??


Thx in advance.. Laughing

[Updated on: Sun, 24 June 2007 22:37]

Report message to a moderator

Re: connectivity problem of personal oracle 8i with developer 6i [message #252496 is a reply to message #247166] Thu, 19 July 2007 00:59 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@Shyam

Have you solved your problem?

David
Previous Topic: excel downloading
Next Topic: PDE-PLI018 Error
Goto Forum:
  


Current Time: Wed Dec 07 22:31:57 CST 2016

Total time taken to generate the page: 0.11710 seconds