OraFAQ Forum: Forms » Unable to connect to database via Forms builder

Home » Developer & Programmer » Forms » Unable to connect to database via Forms builder (Windows 8.1)

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

Unable to connect to database via Forms builder [message #649815]

Thu, 07 April 2016 01:05

Purvasha
Messages: 4
Registered: April 2016

Junior Member

Hello,

I installed Oracle Database 11g and Oracle Developer Suite 10g in Windows 8.1.
Then, I created a user in sqlplus, and database part is working fine but I am not able to connect to the same database in forms builder.
The same login credentials don't work in Forms builder. When I enter username and password for user made in sqlplus I get ora:12560 TNS protocol adapter error whereas when I enter the same specifying Database name as well, I get error ora:12154.
I am a newbie when it comes to using oracle, so any kind of suggestions would be of great help.

Thanking in advance.

[Updated on: Thu, 07 April 2016 01:07]

Report message to a moderator

Re: Unable to connect to database via Forms builder [message #649816 is a reply to message #649815]

Thu, 07 April 2016 01:42

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

ORA-12154 means that you have not provided appropriate connection details. THe name of the database is not enough: Forms Builder needs to know the address (in terms of host name and port) and the name of the service. The service name may be the same as the name of the database, but it may not be. THere are various ways of supplying this information.
What are you actually doing? A screen shot might help.

Report message to a moderator

Re: Unable to connect to database via Forms builder [message #649818 is a reply to message #649816]

Thu, 07 April 2016 03:18

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

Senior Member

You'll probably find sqlplus and form builder are using different tnsnames.ora files.
Set up a TNS_ADMIN environment variable that points to the directory containing the one you want to use.

Report message to a moderator

Re: Unable to connect to database via Forms builder [message #649828 is a reply to message #649818]

Fri, 08 April 2016 00:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here's an example of how to set the TNS_ADMIN environment variable.

Report message to a moderator

Re: Unable to connect to database via Forms builder [message #649835 is a reply to message #649815]

Fri, 08 April 2016 13:14

Purvasha
Messages: 4
Registered: April 2016

Junior Member

I created a user ocms with same password as its name. It works fine with the sqlplus, but I need to connect the database to the forms builder, so for that when I login with same user its gives me this error.
Screenshots are attached.
Any kind of help please.

Attachment: Untitled.png
(Size: 1.04MB, Downloaded 1393 times)

Report message to a moderator

Re: Unable to connect to database via Forms builder [message #649836 is a reply to message #649835]

Fri, 08 April 2016 13:26

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Your screen shot shows that you are logging on with SQL*Plus from the database home. It says nothing about your Forms logon. Perhaps you might want to show the problem: something that does not work, rather than something that does.

Report message to a moderator