OraFAQ Forum: Forms » connectivity problem of personal oracle 8i with developer 6i

Home » Developer & Programmer » Forms » connectivity problem of personal oracle 8i with developer 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connectivity problem of personal oracle 8i with developer 6i [message #126246]

Fri, 01 July 2005 22:42

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.

Report message to a moderator

Re: connectivity problem of personal oracle 8i with developer 6i [message #126282 is a reply to message #126246]

Sat, 02 July 2005 17:02

Maaher
Messages: 7065
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

Report message to a moderator

Re: connectivity problem of personal oracle 8i with developer 6i [message #126690 is a reply to message #126246]

Wed, 06 July 2005 04:01

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.

Report message to a moderator

Re: connectivity problem of personal oracle 8i with developer 6i [message #126817 is a reply to message #126690]

Wed, 06 July 2005 15:42

Maaher
Messages: 7065
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

Report message to a moderator

Re: connectivity problem of personal oracle 8i with developer 6i [message #126849 is a reply to message #126817]

Wed, 06 July 2005 23:09

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.

Report message to a moderator

Re: connectivity problem of personal oracle 8i with developer 6i [message #247166 is a reply to message #126849]

Sun, 24 June 2007 22:37

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

@Shyam

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	excel downloading
Next Topic:	PDE-PLI018 Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:54:15 CST 2025