connection issue between oracle db11g and oracle forms builder 10g [message #604780] |
Sat, 04 January 2014 00:21 |
|
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 #604815 is a reply to message #604780] |
Sat, 04 January 2014 05:29 |
|
Littlefoot
Messages: 21823 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
|
|
|
|