Home » Developer & Programmer » Forms » connection issue between oracle db11g and oracle forms builder 10g (windows 7 )
connection issue between oracle db11g and oracle forms builder 10g [message #604780] Sat, 04 January 2014 00:21 Go to next message
mdjahangirpasha
Messages: 30
Registered: December 2013
Location: India
Member

Hi
everyone
I have installed oracle database 11g on my pc and recently installed oracle developer suite 10g
I am unable to connect to my database using oracle developer suite(oracle form builder) It's giving an error that

"ORA-12154:TNS could not resolve the connect identifier specified"

How to solve this problem or can not we connect to database using older version of suite
Kindly answer me this question as soon as possible


Thanks,


[MERGED by LF]

[Updated on: Sat, 04 January 2014 05:32] by Moderator

Report message to a moderator

Re: connection issue between oracle db11g and oracle forms builder 10g [message #604795 is a reply to message #604780] Sat, 04 January 2014 03:15 Go to previous messageGo to next message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
copy these 2 file from database11g--NETWORK--ADMIN to develope10g----DevSuiteHome_1---network-admin

1.sqlnet.ora
2.tnsnames.ora



Regard
Mughal

[Updated on: Sat, 04 January 2014 03:16]

Report message to a moderator

Re: connection issue between oracle db11g and oracle forms builder 10g [message #604815 is a reply to message #604780] Sat, 04 January 2014 05:29 Go to previous messageGo to next message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TNSNAMES.ORA located in Developer Suite's \network\admin directory doesn't contain entry for your database. I'd suggest you to use TNS_ADMIN environment variable (some more info here).

P.S. The OP opened two topics which have now been merged.

Therefore, let me comment Mughal's suggestion: although this solution solves the problem, in my opinion it is better to use TNS_ADMIN environment variable which enables you to maintain only one copy of TNSNAMES.ORA. Currently, I have dozens of database entries in my TNSNAMES.ORA. It would be a nightmare if I had to maintain all TNSNAMES.ORA files throughout all my Oracle Homes. With TNS_ADMIN, I take care about only one copy.

[Updated on: Sat, 04 January 2014 05:36]

Report message to a moderator

Re: connection issue between oracle db11g and oracle forms builder 10g [message #604846 is a reply to message #604815] Sat, 04 January 2014 11:47 Go to previous message
mdjahangirpasha
Messages: 30
Registered: December 2013
Location: India
Member

Thanks a lot!
Now I able to connect to my database.....


[EDITED by LF: removed unrelated info which is being discussed in another topic]

[Updated on: Sun, 05 January 2014 03:55] by Moderator

Report message to a moderator

Previous Topic: Issue with Find button in Custom built Query Find form
Next Topic: query statistic from multi tables
Goto Forum:
  


Current Time: Thu May 16 20:52:50 CDT 2024