Help! My  Oracle Form builder 11g can't conect Oracle database(11g/10g)

Advertisement

I have installed
1.Oracle Database 11g Release 2 Standard edtion
2.WebLogic Server (10.3.3)
3.Portal, Forms, Reports and Discoverer (11.1.1.3.0)
after install I try run the test.fmx is ok!
But I want used form builder 11g connect my database 11g(installed at same host),
It connect appeared ORA-12154: TNS: could not resolve service name.
I search all about middleware folder in my PC , then find two tnsnames files and two sqlnet.ora
the sqlnet.ora content is
#==============================================================
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
#==============================================================
the tnsnames.ora content is(copy same content from oracle database 11g's tnsnames.ora)
#==============================================================
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test1.XXX.com.tw)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.XXX.com.tw)
#==============================================================
The I update all of my PC's tnsnames.ora like above string,but it always not work
somebody help me,thanks!!

Advertisement

Ronald,
I was able to connect to a database with Forms 11g by adding an Environment variable TNS_ADMIN and pointing this to the directory where the sqlnet.ora and tnsnames.ora files are located. I was unable to find a Net Configuration Assistant in Forms 11g and placing a copy of .ora files in the /%11G HOME/NETWORK/ADMIN didn't work either. Only after I added the environment variable was I able to connect.
There might be a "More Appropriate" solution, but this is what worked for me. We are just now testing 11g, but are still developing with 10g R2.
Hope this helps,
Craig B-)
If someone's response is helpful or correct, please mark it accordingly.
Edited by: CraigB on Sep 16, 2010 8:43 AM

November 30, -0001

Help! My  Oracle Form builder 11g can't conect Oracle database(11g/10g)

I have installed 1.Oracle Database 11g Release 2 Standard edtion 2.WebLogic Server (10.3.3) 3.Portal, Forms, Reports and Discoverer (11.1.1.3.0) after install I try run the test.fmx is ok! But I want used form builder 11g connect my database 11g(inst

Can't open the forms using Oracle Forms Builder 6i

Dear All, I at first download the file .fmb from linux server to local pc.and I setup oracle Forms builder 6i and want to edit the file .fmb on the local form builder ,but can't open it with forms builder raising FRM-10043. I download the source file

Oracle Forms: Build Internet Applications correct configuration

I want to study for the Oracle Forms: Build Internet application exam (IZ0-141) is this exam specified by oracle versions? Forms for 9i looks a little different that forms for 10g. If it is for 9i the download for Oracle9i Application Server is no lo

How to connect Oracle Form Builder - Oracle Developer Suite 10g - Windows 7

Hi brothers and sisters, Hope all you are fine. I have installed Oracle Developer Suite 10g on Windows 7 successfully and it is working properly. But when I connect to Oracle Form Builder using Connect window asking: a. User Name b. Password c. Datab

Oracle Forms Builder 10g Questions

Good day everyone, I want to start off by saying that I'm very new to Oracle Forms Builder (it was dumped on my table about a month ago) and I'm having some issues I need resolved in order to complete a project for a client. I'm looking mainly for do

Calling Sql*Loader from oracle Form builder

How do i call sql* loader from my forms to import the external data in different formats into my existing database? Specify the flexibility of sql* loader to import external data from .txt files or .xls files. Would be thankful if certain examples ar

Is Oracle Forms builder version 10.1.2.0.2 certified with Windows 7 ?

Hello I need to change my old PC that is running 32 bit XP. On this PC , I have installed Oracle Forms builder 10.1.2.0.2 I need to keep this version of forms as my customer is running the same version on linux. I wish to upgrade my PC and install Wi

Oracle Forms 6i client/server against an Oracle 10gR2 database

Hello We have the following situation: Oracle Forms6i/Reports6i client server application against an Oracle 8i cost-based database. we want to migrate this application step 1: Migrate the database to 10gr2, but do not touch the client application Go

Can Oracle Form Builder 10g open forms created with Developer 11g?

Hi, Two different groups of developers developed forms in both Forms versions 10g and 11g. There will be call_forms between both versions and both will run under the same portal. Production is 10g. Is it possible to open 11g forms in 10g Form Builder

Running oracle form builder 10g in windows 7 64 bit

i am working in windows 7 64 bit oracle db 11g enterprise edition 11.2.0.10 64 bit form builder 10.12.0.2  32 bit my default browser is Google Chrome i have java 6 standard edition  1.6.0_34 when i am trying to run any form this message appear " java

Create user from oracle form builder 10g

dear all, anyone to help me? I want to try, to create a new user from form builder oracle 10g in windows, I use a default script like 'create user user_name identified 123' in toad 9.0 for oracle and the result is success but when I try to combine wi

Oracle Forms Builder - Errors

Hi to all! I'm beginner in Oracle Forms and Reports. The OS is Windows and the software is Oracle Forms and Reports Developer 10g with Database Server 10g. I have started with customers.fmb and orders.fmb. When I try start customers.fmb, I get the er

Form builder is not opening in oracle linux

Hi, I have installed Oracle EBS in enterprise linux 5.8 . when i am trying to open form builder with frmbld.sh following error occurs FRM-91113: Internal Error: cannot get default resource file name. FRM-10039: Unable to start up the Form Builder can

Oracle forms builder - windows or unix?

Until recently we've been developing on Forms Builder 6i on our Sun/Solaris box. Now however, we want to move to developing using Forms 10g. We've already recompiled all our forms on the unix box, which has Application Server 10g and an 11g database.

How to install the Oracle form builder if i dy hv ORA6i software?

Currently, i have the db and application of oracle which is dy installed in my computer. Since i need FORM and REPORT builder to make the changes. How to reinstall because system prompt an alert c:/ORA6i is exist. How to install? -TQVM-Hi, Install it

[Oracle Form Builder] - How to?

Question to you as experts: ====================== How to get this following form builders for Red hat/Centos 5.4 /Fedora 12/13 linux? As a learning. ex: http://www.oracle.com/technology/sample_code/products/forms/viewlets/10g/webservices/webservices

Oracle Forms & Reports 11.1.2 with WebLogic 10.3.5 - Creating Domain 0%

I would be grateful if someone could point out where I'm going wrong here...... I am attempting to install Forms and Reports 11g (11.1.2.0.0) 64-bit edition on a Windows 2008 Server (R2 x64). Step 1: download and install jdk-7u3-windows-x64.exe Step

Design a Oracle Form

Hi Experts, I am Atul Ramteke working on oracle apps Technical. We all know when we want to develop a customize form in oracle apps we use Oracle Forms builder and upload this form to Oracle EBS. This is one way of doing the customization, But what i

Oracle Forms and Portal. & Portal Security

I need the following questions answered for a client who is trying to move from IIS to Oracle Portal. any pointers would be extremely helpful 1. How to configure Oracle Forms to run with Portal. 2. Is it possible to display forms inside a Portlet. If

Want in implement Java oracle Forms.

Hi, I want to learn how to implement java in oracle form, and that to I want it using oracle forms builder and not using Jbuilder. E.g. implementing Java Beans in oracle forms. As I am a begineer in this field, please guilde me from where I should st