getting error while accessing d2k form builder [message #299662] |
Tue, 12 February 2008 22:13 |
hushab2001
Messages: 9 Registered: February 2008
|
Junior Member |
|
|
I first installed oracle 9i database.(d:\)
thenafter i installed d2k6i on a different home.(c:\)
also i copied the file tnsnames.ora from database home into forms home. but still i get error "tns could not resolve service name" when i try to connect to database through form builder.
oracle database works fine when i access it through sqlplus or OEM.
Please help me...
|
|
|
|
|
|
|
|
Re: getting error while accessing d2k form builder [message #300329 is a reply to message #300282] |
Fri, 15 February 2008 01:21 |
|
Littlefoot
Messages: 21821 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You don't have to do that; it is not "a must", but can simplify the process. Basically, you should run the "Net Configuration Assistant" (which is installed during Developer Suite installation process), follow the instructions and - as a result - you'd get the same TNSNAMES.ORA and SQLNET.ORA files (more or less) as you'd get if you took them from the database\network\admin directory.
As you've already created these files and they are OK (how do you know that? You can connect to the database using database's SQL*Plus!), why would you bother configuring the same thing once again? Use the copy-paste technique and that's it!
However: you'll have two copies of these files: one in the database\network\admin directory and another one in the developer_suite\network\admin directory. In order to make it even simpler, maintain only one of them. To do that, create the TNS_ADMIN environment variable which will point to one of these two. You don't have to keep them in there (in \network\admin) - create a brand new directory (for example, if on MS Windows, it could be c:\my_oracle) and set TNS_ADMIN=c:\my_oracle.
Simpler is better.
|
|
|