Forum Stats

  • 3,722,772 Users
  • 2,244,411 Discussions
  • 7,850,079 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Not able to launch Forms 12c application on client machine

SandyM
SandyM Member Posts: 24 Green Ribbon
edited March 26 in Forms

I have installed oracle forms and reports 12c on linux server. firewall and ports are open for the form server(9001) , report server (9002) but still not able to open the below from the client machine( windows).

All the services are up and running on the server. Is there any configuration to access from client machine ?https://192.xxx.xx.xx:9001/forms/frmservlet or http://192.xxx.xx.xxx:9002/reports/rwservlet/showenv

Able to login to Weblogic console and EM on windows without any issues . Can someone please advice?

 http://192.xxx.xx.xxx:7001/em

http://192.xxx.xx.xxx:7001/console


N

Best Answer

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee
    Accepted Answer

    If you can't access Forms and you can't access OHS, that suggests you have a networking issue and not a Fusion Middleware issue. Something of which to be aware is that generally most inbound ports are blocked by the operating system firewall. So you might want to check that. If you are using Oracle Linux, you can use the firewall-cmd command to check which inbound ports should be accessible.

    firewall-cmd --list-ports

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    Please be more specific:

    o Exactly which Forms/Reports version?

    o Which Linux version?

    o Exactly what do you mean by "does not open"? Blank screen, error, crash, etc??

    o For Forms, do you have Java 8u281 JRE (x86) installed? You need it. https://www.oracle.com/java/technologies/javase-jre8-downloads.html

    o For Reports, did you complete the required manual configuration steps outlined in the 12.2.1.3 Installation Guide? Specifically refer to the section titled "2.4.7.1 Creating Reports Tool Components"

    https://docs.oracle.com/middleware/12213/formsandreports/install-fnr/installing-and-configuring-oracle-forms-and-reports1.htm#FRINS-GUID-4BB984E2-52A6-4C62-A735-D160CAC1F653

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    Thanks Michael, below are the details. 

    Forms/Reports version - 12.2.1.4.0

    Linux version - RHEL 7

    Java JRE 8 has been installed both on linux server and windows as well.

    I'm able to open report server on the Linux server using xdg-open command (http://192.xxxxxxxx:9002/reports/rwservlet/showjobs?server=Rep_Server1 ) And also able to open http://192.xxxxxxxxx:9001/forms/html/runform.htm on the linux server but not able to test any form due to firefox browser.I'm trying to install chrome /IE on the server to test forms. Hence i think report configuration is correct.

    I'm not able to open the URL on the client machine, ports are open in linux server but Network / firewall team advise that these ports are not blocked and it should work. So I'm not sure whether its configuration issue or security issue. Below is the message I get when i try to access form URL in windows cleint machine but able to access weblogic console and enterprise manager from windows machine.

    192.XXXXXX  took too long to respondTry:

    ERR_CONNECTION_TIMED_OUT

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    First, to run a form on Linux or non-Windows machine, you will need to use either Java Web Start or Forms Standalone Launcher. To do this open a browser on your linux machine and enter a URL and include the JWS example configuration. For example:

    http://server:9001/forms/frmservlet?config=webstart

    If prompted to Save or Open the file. If you choose Save, a .jnlp file will be downloaded to your machine. To actually "run" the form you will need to use the javaws executable found in the Java 8 installation. If you do not have Java 8 installed, then you will not be able to use JWS (Java Web Start).

    In the case of your ERR_CONNECTION_TIMED_OUT error, that is fairly straight forward. There are only a few things that would cause that error:

    .1. The user machine is unable to communicate with the server. As mentioned, this could be a network configuration issue like proxy server.

    .2. Security software (e.g. virus scanner, etc) on the user machine is blocking the request.

    .3. The server is not running.

    .4. The URL you are entering is invalid.

    .5. The IP address you are using is on a different subnet as the one you are on and the routing is not configured to access it from where your user machine is located. One test that might help would be to see if you can "ping" the server from the user's machine.

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    Thanks Michael. Java 8 is already installed on the server . when I open the http://server:9001/forms/frmservlet?config=webstart it prompts me to save the .jnlp file but there is no other option is displayed to open the saved frmservlet via firefox. I raised SR for the same, they advised me to open in IE. Can you advise ?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    This is how web start works. A jnlp file is generated and it must be opened/executed in order to launch. When FF prompts you to Save, save it to the desktop (or location of choice) then run it (e.g. double click on it.). You can configure FF to launch it automatically by changing its settings. Do some Googling to find out how to configure Firefox.


    You will need to install Java 8 JRE (x86) on the user's machine. By doing this, you will be able to run Forms embedded in the browser (only works with IE 11). Alternatively you can run with Java Web Start on any platform where Java 8 JRE is supported. You can also use Forms Standalone Launcher which is also supported on any platform where Java is supported. Details about FSAL can be found in the Forms documentation in a variety of places.

    https://www.oracle.com/application-development/technologies/forms/forms.html#panel2

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    I will try to install IE 11 on the server and check. Can you please advise whether the localhost is creating conflict from the log below as I'm not able to launch 9001 port from client machine ?

    <30-Mar-2021 14:12:24,354 o'clock BST> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 127.0.0.1:9001 for protocols iiop, t3, CLUSTER-BROADCAST, ldap, snmp, http.>

    <30-Mar-2021 14:12:24,355 o'clock BST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 192.1.xxxxxxxx:9001 for protocols iiop, t3, CLUSTER-BROADCAST, ldap, snmp, http.>

    <30-Mar-2021 14:12:24,355 o'clock BST> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 127.0.0.1:9001 for protocols iiop, t3, CLUSTER-BROADCAST, ldap, snmp, http.>

    <30-Mar-2021 14:12:24,356 o'clock BST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on192.1.xxxxxxxx:9001 for protocols iiop, t3, CLUSTER-BROADCAST, ldap, snmp, http.>

    <30-Mar-2021 14:12:24,675 o'clock BST> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.>

    <30-Mar-2021 14:12:24,688 o'clock BST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    You said, "I have installed oracle forms and reports 12c on linux server". If the server is Linux, how do you plan to install Internet Explorer on it?

    I think you are not accurately sharing the details of your situation and the problem.

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    Its on linux server only as I'm not able to open the below URL http://192.XXXXXXX:9001/forms/frmservlet?config=webstart on the client machine, I thought to try atleast from server.

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    Michael , Below is the observation from network/firewall team. From client machine able to connect to port 7001 but not able to connect 9001 and 9002 ports ( forms and reports) even telnet fails for 9001 and 9002 from client machine.

    I could see the event occurs in WLS_FORMS.log when i try to access forms URL on the client machine but getting same time out issue.

    192.XXXXXX  took too long to respondTry:

    ERR_CONNECTION_TIMED_OUT

    WLS_FORMS.log

    ####<02-Apr-2021 12:41:58,888 o'clock BST> <Info> <WorkManager> <xxxxxxxx.xxxxxxx.com> <WLS_FORMS> <Timer-2> <<WLS Kernel>> <> <c1c2ba1b-5379-4943-850b-31c867f02197-00000003> <1617363718888> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002959> <Self-tuning thread pool contains 2 running threads, 2 idle threads, and 48 standby threads>

    Observation from network team.

    1. All connections were allowed by the firewall

    2.      A two-way conversation occurs between Client ( 10.xxxxxxxx) and server (192.xxxxxxxx) when using destination ports 22 and 7001 and the connection closes with a ‘normal’ end reason

    3.      Connections to 9001 and 9002 are shown as aged-out. This means that the firewall allowed the traffic but the connection attempts to the destination server on these ports timed out


    Can you please help me how to debug this issue ?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    If you have OHS installed, can you connect to it? By default, the listener port is 7777

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    Hi Michael, I'm able to connect to OHS in server http://192.xxx.xx.xxx:7777/ but not on the client.

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee
    Accepted Answer

    If you can't access Forms and you can't access OHS, that suggests you have a networking issue and not a Fusion Middleware issue. Something of which to be aware is that generally most inbound ports are blocked by the operating system firewall. So you might want to check that. If you are using Oracle Linux, you can use the firewall-cmd command to check which inbound ports should be accessible.

    firewall-cmd --list-ports

  • SandyM
    SandyM Member Posts: 24 Green Ribbon

    Thank you so much, 9001, 9002 were missing under inbound port list. Post adding I'm able to access forms URL from cleint.

Sign In or Register to comment.