OraFAQ Forum: Forms » Forms 11g & Database Connection

Home » Developer & Programmer » Forms » Forms 11g & Database Connection (Oracle Forms 11g Version 11.1.1.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms 11g & Database Connection [message #455914]

Thu, 13 May 2010 08:05

Kevin58
Messages: 79
Registered: January 2009

Member

I have just installed Oracle Forms 11g with the Weblogic web server.

I have a local installed database, and access to our network databases also.

I can do a TNSPING and get valid results back from that.
I can connect with SQLPlus, and SQLDevloper.

However, I cannot connect with the Forms 11g Forms Builder.

Does anyone know where to copy the TNSNAMES.ORA file for use with
Forms 11g?

Report message to a moderator

Re: Forms 11g & Database Connection [message #455915 is a reply to message #455914]

Thu, 13 May 2010 08:27

Kevin58
Messages: 79
Registered: January 2009

Member

I have found a solution.

I had to copy the TNSNAMES.ORA file to this location:
C:\oracle\fmw11g\dev11ginst_2\config

I was looking for a "network/admin" folder.

I stumbled onto this folder location because I did a search
for the TNSNAMES.ORA file, and it found an example
of one at the location mentioned above.

I am now able to connect to the database.

Report message to a moderator

Re: Forms 11g & Database Connection [message #455916 is a reply to message #455915]

Thu, 13 May 2010 08:30

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I suggest you make use of the TNS_ADMIN registry setting so that you don't have to maintain multiple tnsnames files.

Report message to a moderator

Re: Forms 11g & Database Connection [message #455921 is a reply to message #455914]

Thu, 13 May 2010 09:38

Kevin58
Messages: 79
Registered: January 2009

Member

Hey CM, great suggestion.

Now I no longer have to synchronize multiple copies of the tnsnames.ora file!

Thanks alot for that suggestion!

Report message to a moderator

Re: Forms 11g & Database Connection [message #455922 is a reply to message #455921]

Thu, 13 May 2010 10:02

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

you're welcome

Report message to a moderator

Re: Forms 11g & Database Connection [message #541417 is a reply to message #455914]

Tue, 31 January 2012 02:55

Menna Rashed
Messages: 1
Registered: January 2012

Junior Member

I have the same problem too
when i connect using tnsping or sqlplus
using username: SYS/SYS@192.115.1.4:1521/orcl as sysdba it connected with no problems
but when i connect from forms builder 11g it
ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

where my database is in another server ana tnsnames are the same at my laptop and server and sqlnet also
and when i used lsnrctl services i found the service

so what is the problem that makes forms builder not connected to my database

Report message to a moderator

Previous Topic:	Oracle Forms on Cell phone
Next Topic:	Can migrating oracle 6i into oracle 11g?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 22:30:05 CST 2025