| Unable to connect [message #294831] |
Sat, 19 January 2008 21:13  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Guys,
I have this problem which confuses me.
I am able to connect to the 10g database with TOAD but when I try to connect to the database through command prompt or from forms or reports it says 'unable to connect'.
I assume this has something to do with sqlnet.ora and tnsnames.ora file but not very sure
Thanks in advance
- Das
|
|
|
|
|
|
| Re: Unable to connect [message #294870 is a reply to message #294831] |
Sun, 20 January 2008 05:43  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
It seems that you have (and use) more than one copy of TNSNAMES.ORA and SQLNET.ORA files.
A problem you have can (usually) be resolved by copying these files from \network\admin directory of a product that enables you to connect to the database (it is usually directory into which you have installed Oracle database) into \network\admin directory of the Developer Suite (which contains Forms and Reports Builders).
However, as such an approach requires you to maintain multiple copies of these files, I'd suggest you to use only one copy. You might point to this directory by setting the TNS_ADMIN environment variable.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
