Forms :: Running Forms 11g - No Backend Server Available For Connection

Feb 20, 2012

I have a problem running forms 11g OS is windows 7 (tried on both 32bit and 64 bit same error)..Forms and Reports were both working fine, i was able to run test form, and a form that i created, and both were running properly. suddenly, while testing a new form module, it didn't work, and its showing :

Failure of server APACHE bridge:
------------------------------------------------------------------------------
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.

View 2 Replies


ADVERTISEMENT

Forms :: How To Create Trigger On Backend

Oct 14, 2010

I Created a form just for testing purpose [Which is i attached]

My Table is TEST0

Structure of table :
---------------------------
NOVARCHAR2(5)
NAME VARCHAR2(10)
FLG VARCHAR2(1)

My Task is When i added a record, e.g if on form, i add name - AAD But its must save on TEST0 Table like this way EMPAAD...means always concate with 'EMP'||:Block.name while saving on database..

I know how to do with front end application, but i want to achieve this task by using trigger on backend databse...how to create a Trigger on backend....i try a one trigger but it give me error- Unable to insert Record...

View 12 Replies View Related

Forms :: Display Image On Oracle Form Through Backend

Dec 17, 2011

I am successfully insert image in DB now...now my task is i want to retrieve this image on my oracle form.

my structure on table like this..

CREATE TABLE temp_image
(
ID NUMBER,
image_filename VARCHAR2(50),
image BLOB
);

i inserted 2 images on that... now i want to retrieve it , how to achieve this.

View 6 Replies View Related

Forms :: FRM-92100 Your Connection To Server Was Reset

Jun 23, 2013

I have developed an application Customer Call Handling where the main form of the Application has about 42(Data & Control) Blocks, many canvases and windows.This main form Calls many other forms which all work fine. But whenever this Main form is Cleared,Queried it calls the Code gems_ proc_ clear which has CLEAR_FORM(NO_VALIDATE).Immediately after the Clear_form(no_validate) is fired it throws this error FRM-92100.

On Save too, the form needs to be cleared once data is saved. The save works fine. but when the call to gems_proc_clear is made after save it throws the error again.

Since its the main form of the application, The Call Center users are having difficulty Clearing or Querying the form.

The forms have been developed in Forms 6i Version and work absolutely fine in 6i Test-Server Environment. But the moment we run the Forms in the Live Server(Oracle 11G) Environment when the form is Cleared,Queried this error throws.

View 1 Replies View Related

Forms :: Connection To Server Interrupted When Navigating Records

Jul 8, 2011

when i navigate to different records in my form, suddenly the connection get interrupted.

View 12 Replies View Related

Forms :: 11g And Database Connection

May 13, 2010

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 SQL Plus, and SQL Devloper. However, I cannot connect with the Forms 11g Forms Builder. where to copy the TNSNAMES.ORA file for use with Forms 11g?

View 5 Replies View Related

Forms :: Get Live Connection To Database?

Jun 19, 2012

Our database is on one site . There is a form which is used by users on another site. The internet connection is lost sometimes and the form that they use looses connection to the database. What I would like to do on the form is whenever the connection is lost to the database i,eORA-03114,I want to reestablish the connection so that the form can be used by users all the time.

View 1 Replies View Related

Forms :: Connection Between 6i And Oracle Database 11g

Jun 8, 2011

I´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.

TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.

So whenever i want to login to the application i must to change the schema password, i need to use it directly.

View 2 Replies View Related

Forms :: ORA - 12537 / TNS Connection Closed

Mar 5, 2010

I Installed Oracle forms 10g after which I Installed Oracle Database Express Edition.

I have added the following entry in tnsnames

XEXDB=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))
(CONNECT_DATA=
(SERVICE_NAME=XEXDB)
)
)

When I am trying to connect Forms with the Database am getting the below error:ORA - 12537: TNS connection closed

I need to make any changes to sqlnet.ora

View 10 Replies View Related

Forms :: Oracle 10g And Database Connection

Aug 8, 2011

Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it

"ora-12154 tns could not resolve the connect identifier specified"

View the image below:

Here are the values in forms 10g tns

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......

and here the values of forms 10g SQLnet

# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)

What changes should i make to overcome this problem.

View 1 Replies View Related

Forms :: Running 10g In Firefox

Jul 24, 2011

i am trying to use Firefox to run 10g forms application. Firefox not detecting the initiator. Firefox each time says plugin missing and searching for it. giving option to download manually. each time i run the form in Firefox same thing. no plugin found and its downloading another copy from d10g folder.

View 2 Replies View Related

Forms :: 9i Not Running At IE 8 Or Later Version?

Jan 9, 2013

I have developed my PAYROLL application in forms 9i, which is successfully runnig at internet explorer version 6 but it is not running at internet explorer version 8 or later.

View 1 Replies View Related

Forms :: Java Timeout Connection Error?

Mar 30, 2012

This error keeps on comming in my welogic forms server window many often....can any one tell me why it is so ?

<Error> <oracle.forms.servlet> <FRM-91230> <fatal
error in runtime process: timeout on connection to Java client>

View 2 Replies View Related

Forms :: Error 404 On Webpage When Running In 11g

Oct 27, 2011

I am using oracle forms 11g

when i am running a forms the web page is giving error 404-not found.

View 2 Replies View Related

Forms :: After Deploying New 11g Fmx / Old Version Is Still Running

Apr 12, 2011

We are running forms 11g ( 11.1.1.3) in our production environment and we are having strange issue when we are deploying the new version of fmx on fusion middleware server ( Windows 2008). After copying/replacing the new fmx we are still running the OLDER version of form. It's happening randomly on different servers.

View 3 Replies View Related

Forms :: Running Graphs - Changes In Settings?

May 3, 2012

I want to run graphs through forms. Just wanted to ask you that, what changes in settings do I have to make in forms or install any new software so that I am able to run graphs through it?

View 2 Replies View Related

Forms :: Running Reports 6i On Windows 7?

Nov 2, 2009

would like to check if anybody running Form/Report 6i on Windows 7 ? I meant not XP mode.

View 3 Replies View Related

Forms :: 10g Is Not Running - Asking Jinitiator Installation?

Oct 29, 2010

I newly installed the Forms 10.1.2.0.2 and my database version is 10.1.0.2.0.

I hope it successful installed. I done the following workings

1. Edit preferences done perfectly.
2. OC4J also started.

When i run my 1st sample form. On my 1st run it should ask for Jinititor installation. But my run is not asking the Jinitiator installation and form is not running.

Even tried with run a form on web option it is also not running

View 6 Replies View Related

Forms :: Not Running On Internet Explorer

Apr 6, 2009

I am getting error while running oracle forms (oracle 10g) in internet explorer.

an unhandled win32 exception occurred in iexplorer.exe [7572]

View 6 Replies View Related

Forms :: Report Engine Is Not Running

Jul 22, 2010

I am facing a problem while calling a report from FORM.the system gets hang and RWRBE60.EXE is not started.I am using client/server environment and Form 6i.

View 2 Replies View Related

Forms :: Connection String In Form Builder 6i To SYS User

Jun 9, 2013

i want to create a form like a console with form builder 6i for databases monitoring. I have to connect to more than 10 databases and monitoring them at same time.

My question is, how can i create connection string for each one in form builder? after connect to per database i want to select some quires, for example

:
"select STATUS from v$instance;"

Attention: i don't want use db-link

View 2 Replies View Related

Forms :: Frm-40514 - Operation Requires A Database Connection

Sep 7, 2010

Am running forms 10g on windows vista service pack 1 and am having problems with the FRM-40514 error. (Operation requires a database connection).

I can connect quite alright from form builder, but when i run a form it request for login credentials again. I dont understand why this is so, when am already logged on in form builder.I tried to tacke this by creating the following

DECLARE
Uname VARCHAR2(80);
Pword VARCHAR2(80);
cn VARCHAR2(80);
BEGIN
--pause;
--logout;
--message ('Logging out');
--synchronize;
[code]....

This code suppreses the logon screen and runs the form without logging on to the database. I know this because when I try to enter and execute query it brings up the message: FRM-40514: Operation requires a database connection.

View 15 Replies View Related

Forms :: Running Oracle Database 10g On Windows 7

Nov 12, 2009

I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs

View 9 Replies View Related

Forms :: Running Concurrent Report From FORM

Oct 26, 2010

My requirement is:

I want to run multiple Reports Concurrently, being called from my Form.

Suppose I have 10 Reports Say Report1, Report2, ....Report10.

I am using "RUN_PRODUCT" to call these Reports from my Form. But it's taking too long time to run all the Reports one after another. Can I run all these Reports Concurrently at the Same time.

View 4 Replies View Related

Forms :: Running Multiple Instances Parallel In 11g R2

Feb 13, 2013

My requirement is to Run 2 instances of forms 11g R2 parallel at a time(means running 2 urls of 2 instances same time). I have tried with installing 2 instances but when i install and configure my 2nd instance then my 1st instance services are shutting down.At a time it is running only one instance services.

And also i have tried with installing 2 Cluster instances of 11g R2 Forms but same thing happening as above.

how to run 2 instances of Forms 11g R2 parallel and also suggest me to install instances in same domain or different domain because with same domain 2 instances it is creating only one config file..so i tried with different domains. Different Config files created but only one instance service is running.

View 1 Replies View Related

Reports & Discoverer :: Running Report From FORMS 10g?

Jun 11, 2010

I have installed Oracle 10g DB and Developer Suite 10g and have made a simple report in it. This report runs perfectly fine when run from Reports Developer even in Browser. But when I called this report from FORM I get error.

The Trigger behind WHEN-BUTTON-PRESSED is

DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
v_parameter_string varchar2(4000);

[code]....

I also set my Report Server as rep_fsprod using CMD

rwserver server=rep_fsprod

I have made changes in .env files adding the REPORTS_PATH in it of the location where my reports are placed.Also have made changes in REGISTRY adding in REPORTS_PATH the same location. But when I press button the Browser window opened shows the error REP-51002 - Bind to Reports Server rep_fsprod failed. I need to run reports from FORMS including ones with Parameters.

View 1 Replies View Related

Forms :: FRM-10142 - HTTP Listener Is Not Running

Mar 12, 2007

Currently I am using Oracle 9i Database and 10g Developer when I connect via login/password successful login but not execute and shows the error

FRM: 10142 The HTTP listener is not running on <computer Name> at port 8889. start the listener and check your runtime preference.

View 11 Replies View Related

Forms :: 10g Report Not Running If Called Through Paramform On Other Domain

Apr 30, 2010

I'm using Dev10g Rel.2....If I call a report with paramform=no and pass it a value from forms then report runs well. but if I call report thru parameter form and pass value from parameter form the report doesn't run with error:

The webpage cannot be displayed.

Interesting fact is that If I call the report from a client on same domain as that of Application Server then it runs even thru paramform. I've also entered the application server I.P and name on other domain's client but no way.

View 1 Replies View Related

Forms :: Running Oracle Report Through 6i And Validating Between Two Dates

Feb 16, 2010

I want to call a report through forms 6i and i want to send a parameter from forms6i to report 6i. in which i want to take records between two dates.

View 26 Replies View Related

Forms :: Running Form On Oracle Developer Suite 10g

Jul 2, 2011

i am new and developing my first oracle form.but when i am running this form.it's not running,i have installed already jinit.exe setup.Is this necessary internet connection for running forms.port no. is 8890.

View 20 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved