Home » Developer & Programmer » Forms » getting error while accessing d2k form builder (Oracle 9i,d2k6i, windows XP)
getting error while accessing d2k form builder [message #299662] Tue, 12 February 2008 22:13 Go to next message
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 #299695 is a reply to message #299662] Tue, 12 February 2008 23:54 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'tnsnames.ora'. It is a common question.

David
Re: getting error while accessing d2k form builder [message #299814 is a reply to message #299695] Wed, 13 February 2008 05:14 Go to previous messageGo to next message
hushab2001
Messages: 9
Registered: February 2008
Junior Member
hello david,
i successfully installed d2k 6i. i also performed tnsping80 and it responded well. but while connecting through form builder its gives the error "invalid or unknown NLS parameter value specified"
can u help please?
Re: getting error while accessing d2k form builder [message #299953 is a reply to message #299814] Wed, 13 February 2008 18:52 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'invalid or unknown NLS parameter value specified'. Then if that does not solve your problem search all forums for 'invalid or unknown NLS parameter value specified'.

David
Re: getting error while accessing d2k form builder [message #299969 is a reply to message #299953] Wed, 13 February 2008 21:42 Go to previous messageGo to next message
hushab2001
Messages: 9
Registered: February 2008
Junior Member
Thank u very much David. i checked the registry and made the necessary changes and i have set form builder and sqlplus 8.0 working. thank u very much for your help. Smile
Re: getting error while accessing d2k form builder [message #300282 is a reply to message #299953] Thu, 14 February 2008 21:35 Go to previous messageGo to next message
hushab2001
Messages: 9
Registered: February 2008
Junior Member
can u please tell me why do v need to copy the tnsnames.ora and sqlnet.ora files to the forms home. i want to know it just for information sake..
Re: getting error while accessing d2k form builder [message #300329 is a reply to message #300282] Fri, 15 February 2008 01:21 Go to previous message
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.
Previous Topic: Bad bind variable error
Next Topic: How to Open File in Developer 10g using GET_FILE_NAME
Goto Forum:
  


Current Time: Tue Nov 05 12:15:52 CST 2024