Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions
  • 7,911,754 Comments

Discussions

Oracle Reports 12c REP-51002: Bind to Reports Server repserver1 failed on Windows 10

User_3DXTV
User_3DXTV Member Posts: 8 Green Ribbon
edited Sep 30, 2022 12:06PM in Reports

Hello everybody

I have installed Oracle Forms and Reports 12.2.1.3.0 on Windows 10 using the document which I have already used before for installation http://shipingzhong.cn/sites/default/files/oracle_forms_12c_installation_for_windows.pdf

I have created standalone reports server

createReportsServerInstance(instanceName='repserver1',machine='AdminServerMachine')

 and ReportsToolsInstance

createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine') 

After starting Standalone Reports server and trying to connect with

http://laptop-cmtt9so4:9002/reports/rwservlet/showenv?server=repserver1

I am getting the error

REP-51002: Bind to Reports Server repserver1 failed

 I saw many posts and Oracle Notes and tried what was recommended in the following discussions

REP-51002 while running the reports in 12c (12.2.1.2.0) windows — oracle-tech

REP-51002: Bind to Reports Server rep failed — oracle-tech

Tried to change multicast to naming services as it was recommended here

https://community.oracle.com/tech/developers/discussion/4125494/rep-51002-while-running-the-reports-in-12c-12-2-1-2-0-windows

Edited $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/<standalone repserver>/rwnetwork.conf

  • Commented multicast and enabled namingservices
  • Started the naming services:

$DOMAIN_HOME\reports\bin\namingservice.bat 14021

Wheh I am running rwdiag -findAll

Naming service used to locate servers

-------------------------------------

Naming Server host = laptop-cmtt9so4

Naming Server port = 14021

(1) repserver1 : Type = server : Host = NA

 Looks the host name which I put in host file was not recognized

<ip address> <my laptop host name>

In rwEng-0_diagnostic log I always see this error:

[2022-09-26T09:59:18.899-04:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.engine] [tid: 1] [ecid: 4f801726-b52e-4087-8b88-fd9d3650bcd7-00000002,0] [EngineName: rwEng-0] REP-50125 : org.omg.CORBA.COMM_FAILURE:  vmcid: SUN minor code: 201 completed: No [[

...

Caused by: java.net.ConnectException: Connection refused: connect

I believe the problem can be in my Windows configuration.

When I am running netstat -aon I don't see my laptop name laptop-cmtt9so4

 TCP   0.0.0.0:14021         0.0.0.0:0             LISTENING      24172

 TCP   127.0.0.1:14021       127.0.0.1:52701       ESTABLISHED    24172

 TCP   127.0.0.1:52701       127.0.0.1:14021       ESTABLISHED    14820

 TCP   192.168.56.1:14021    192.168.56.1:52774    ESTABLISHED    24172

 TCP   192.168.56.1:52774    192.168.56.1:14021    ESTABLISHED    23836

 TCP   [::]:14021            [::]:0                LISTENING      24172

 UDP   0.0.0.0:14021         *:*                                   23184

 UDP   [::]:14021            *:*                                   23184

 

When I am running ping laptop-cmtt9so4

Reply from fe80::644b:c80:869c:33e3%12: time<1ms

Reply from fe80::644b:c80:869c:33e3%12: time<1ms

 

Ipconfig /all

Link-local IPv6 Address . . . . . : fe80::5455:8991:3555:3332%19(Preferred)

IPv4 Address. . . . . . . . . . . : 172.16.94.1(Preferred)

 

Firewall and Windows Defender are completely disabled on my machine

 

Any help will be appreciated

 

Tagged:

Answers

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 341 Employee

    Hi,

    I have a few suggestions. "java.net.ConnectException: Connection refused: connect" most likely due to a network issue.

    1. Since you are using NamingService configure your firewall to use 14021 as TCP channel only.
    2. Configure your network NIC to use IPv4 as primary and IPv6 as optional. Oracle Reports supports only IPv4.
    3. Test showenv using IPaddress
    http://<IPV4address>:9002/reports/rwservlet/showenv?server=repserver1
    

    Thanks, Suresh

  • User_3DXTV
    User_3DXTV Member Posts: 8 Green Ribbon

    Thank you for your reply Suresh

    1. My firewall is already completely disabled. Do I still need to configure to use 14021 as TCP channel?
    2. I have configured network NIC to prefer IPV4 over IPV6 as explained here https://theitbros.com/ping-returns-ipv6-address-ping-ipv4/
    3. Test result is the same REP-51002: Bind to Reports Server repserver1 failed.


  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 341 Employee

    Now you have NamingService running, 14021 should be exposed only over TCP channel.

  • User_3DXTV
    User_3DXTV Member Posts: 8 Green Ribbon
    edited Oct 2, 2022 2:40PM

    Hi Suresh

    I have opened the TCP port 14021 but still have the same issue

    rwEng-0_diagnostic log :

    [2022-09-26T09:59:18.899-04:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.engine] [tid: 1] [ecid: 4f801726-b52e-4087-8b88-fd9d3650bcd7-00000002,0] [EngineName: rwEng-0] REP-50125 : org.omg.CORBA.COMM_FAILURE:  vmcid: SUN minor code: 201 completed: No [[

    ...

    Caused by: java.net.ConnectException: Connection refused: connect

    rwdiag:

    Naming service used to locate servers

    -------------------------------------

    Naming Server host = laptop-cmtt9so4

    Naming Server port = 14021

    (1) repserver1 : Type = server : Host = NA

    This is really worries me why the host is NA ????

    The order of starting the Reports services is following:

    NamingService

    Managed Servers(WLS_REPORTS)

    StandAlone Reports Service.


    Tried the links using the hostname and IP address:

    http://<ip address>:9002/reports/rwservlet/showenv?server=repserver1

    http://<hostname>:9002/reports/rwservlet/showenv?server=repserver1


    REP-51002: Bind to Reports Server repserver1 failed.

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 341 Employee

    Define Inbound and outbound with 14021 port over TCP channel.

    Once you restart OS and FMW Forms/Reports, test the report and run netstat -aon | find "14021", paste the output here.

  • User_3DXTV
    User_3DXTV Member Posts: 8 Green Ribbon
    edited Oct 5, 2022 4:11PM

    I have created the Outbound rule with 14021 port (inbound was already opened)

    After restart and testing the report:

    C:\Oracle\ORACLE_HOME\FMW_HOME\user_projects\domains\test_domain\bin>netstat -aon | find "14021"

     TCP  0.0.0.0:14021     0.0.0.0:0       LISTENING    13548

     TCP  127.0.0.1:14021    127.0.0.1:50038    ESTABLISHED   13548

     TCP  127.0.0.1:50038    127.0.0.1:14021    ESTABLISHED   13332

     TCP  192.168.56.1:14021   192.168.56.1:50485   ESTABLISHED   13548

     TCP  192.168.56.1:50485   192.168.56.1:14021   ESTABLISHED   14212

     TCP  [::]:14021       [::]:0         LISTENING    13548

     UDP  0.0.0.0:14021     *:*                  14812

     UDP  [::]:14021       *:*                  14812

    192.168.56.1 is my laptop IP address however when I am running http://192.168.56.1:9002/reports/rwservlet/showjobs?server=repserver1 I am getting the same error REP-51002

    Thanks for your support.

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 341 Employee

    Run the URL using http://<hostname>:9002/reports/rwservlet/showjobs?=server=repserver1

    Thanks, Suresh

  • User_3DXTV
    User_3DXTV Member Posts: 8 Green Ribbon

    I got the same error after running the URL you suggested

    in repserver1.out file I see this error:

    Oct 16, 2022 12:10:53 PM oracle.ods.virtualization.engine.util.VDELogger error

    SEVERE: ContextServiceConfig.getConfigPath - failed : JRF is unable to determine the current application server platform.

    oracle.jrf.UnknownPlatformException: JRF is unable to determine the current application server platform.

    Thanks

    Alex