Oracle Business Intelligence

Products Banner

OBIEE 12C ERR_CONNECTION_REFUSED

Received Response
212
Views
12
Comments

Hello I've a strange issue. I recently installed OBIEE 12C and it worked good for a while. After that when i try to access my answers page i.e. http://desktop-1q20p03:9502/analytics or EM page http://desktop-1q20p03:9500/em It's saying

This site can’t be reached

desktop-1q20p03 refused to connect.

Search Google for desktop 1q20p03 9500

ERR_CONNECTION_REFUSED

pastedImage_1.png

Can Anyone Help? Thanks in Advance

Answers

  • What OS is that?

    I bet on a Windows 7, 8, 10 or something along that line ... If it's the case have a look at https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

    More in general you are using a name which is the name of your PC apparently, but in a "home network" IP addresses can change, so if your PC changed IP address you maybe have a mismatch on that.

    Never forget to look into logs and start by identifying the component which failed first: nodemanager, weblogic admin server, weblogic managed server, bi services (in this order: if node manager failed for example no need to look for others as they have no chance to work without node manager etc.)

  • I'm Using Windows 10. I've Installed OBIEE 12c in a laptop i bought recently, I haven't changed IP Address.

    I tried to Start the BI tools C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin\start.cmd.It says

    Unable to connect to AdminServer on host: DESKTOP-1Q20P03. Below is the Output. Please Have a look.

    Microsoft Windows [Version 10.0.15063]

    (c) 2017 Microsoft Corporation. All rights reserved.

    C:\windows\system32>cd C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin

    C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin>start.cmd

    BI_PRODUCT_HOME set as C:\Oracle\Middleware\Oracle_Home\bi\

    ORACLE_HOME set as C:\Oracle\Middleware\Oracle_Home

    Domain status; Using domainHome: C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi ...

    Starting domain; Using domainHome: C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi ...

    Initializing WebLogic Scripting Tool (WLST) ...

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    <Oct 24, 2017 6:38:42 PM EDT> <Info> <Security> <BEA-090905> <Disabling the CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.>

    <Oct 24, 2017 6:38:42 PM EDT> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.>

    <Oct 24, 2017 6:38:42 PM EDT> <Info> <Security> <BEA-090909> <Using the configured custom SSL Hostname Verifier implementation: weblogic.security.utils.SSLWLSHostnameVerifier$NullHostnameVerifier.>

    NodeManager already running

    Reading domain...

    /Servers/AdminServer/ListenPort=9500

    Accessing admin server using URL t3://DESKTOP-1Q20P03:9500

    Starting AdminServer ...

    Admin Server Start Exception: Error occurred while performing nmStart : Error Starting server AdminServer : Received error message from Node Manager Server: [Server start command for WebLogic server 'AdminServer' failed due to: [Server failed to start up but Node Manager was not aware of the reason]. Please check Node Manager log and/or server 'AdminServer' log for detailed information.]. Please check Node Manager log for details.

    Use dumpStack() to view the full stacktrace :

    Reading domain...

    /Servers/AdminServer/ListenPort=9500

    Accessing admin server using URL t3://DESKTOP-1Q20P03:9500

    Requesting credentials ...

    Enter Weblogic login details at prompt

    Weblogic Username: weblogic

    Weblogic Password:

    Starting AdminServer ...

    Unable to connect to AdminServer on host: DESKTOP-1Q20P03

    Failed to start one or more Servers

    /Servers/AdminServer/ListenPort=9500

    Accessing admin server using URL t3://DESKTOP-1Q20P03:9500

    Start Admin Server connect Exception caught Error occurred while performing connect : Error getting the initial context. There is no server running at t3://DESKTOP-1Q20P03:9500 : t3://DESKTOP-1Q20P03:9500: [RJVM:000575]Destination 169.254.137.174, 9500 unreachable.; nested exception is:

            java.net.ConnectException: Connection refused: connect; [RJVM:000576]No available router to destination.; nested exception is:

            java.rmi.ConnectException: [RJVM:000576]No available router to destination.

    Use dumpStack() to view the full stacktrace :

    Reading domain...

    Oct 24, 2017 6:40:49 PM com.oracle.cie.domain.script.jython.CommandExceptionHandler handleException

    SEVERE: Error: runCmd() failed.

    com.oracle.cie.domain.script.jython.WLSTException: 60713: Command execution failed.

    60713: Attempt to execute command "readDomain" in invalid state: Configuration

    60713: Check the logs for more information.

    @com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:203)

            at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69)

            at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2360)

            at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:676)

            at sun.reflect.GeneratedMethodAccessor668.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at org.python.core.PyReflectedFunction.__call__(Unknown Source)

            at org.python.core.PyMethod.__call__(Unknown Source)

            at org.python.core.PyObject.__call__(Unknown Source)

            at org.python.core.PyInstance.invoke(Unknown Source)

            at org.python.pycode._pyx155.command$1(C:\Users\yerra\AppData\Local\Temp\WLSTOfflineIni3741437609598423104.py:19)

            at org.python.pycode._pyx155.call_function(C:\Users\yerra\AppData\Local\Temp\WLSTOfflineIni3741437609598423104.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx155.readDomain$28(C:\Users\yerra\AppData\Local\Temp\WLSTOfflineIni3741437609598423104.py:127)

            at org.python.pycode._pyx155.call_function(C:\Users\yerra\AppData\Local\Temp\WLSTOfflineIni3741437609598423104.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx140.getAdminServerUrl$24(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py:512)

            at org.python.pycode._pyx140.call_function(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx140.requestCredentialsAndConnectToAdminServer$8(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py:178)

            at org.python.pycode._pyx140.call_function(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx140.connectAdminServer$9(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py:242)

            at org.python.pycode._pyx140.call_function(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx140.outputComponentsStatus$22(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py:454)

            at org.python.pycode._pyx140.call_function(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx140.statusComponents$25(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py:580)

            at org.python.pycode._pyx140.call_function(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\process_control.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyFunction.__call__(Unknown Source)

            at org.python.pycode._pyx139.f$0(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\start_servers.py:193)

            at org.python.pycode._pyx139.call_function(C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\start_servers.py)

            at org.python.core.PyTableCode.call(Unknown Source)

            at org.python.core.PyCode.call(Unknown Source)

            at org.python.core.Py.runCode(Unknown Source)

            at org.python.util.PythonInterpreter.execfile(Unknown Source)

            at weblogic.management.scripting.WLST.main(WLST.java:181)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at weblogic.WLST.main(WLST.java:47)

    Caused by: java.lang.IllegalStateException: 60713: Command execution failed.

    60713: Attempt to execute command "readDomain" in invalid state: Configuration

    60713: Check the logs for more information.

            at com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:203)

            at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:670)

            ... 56 more

    Error: runCmd() failed. Do dumpStack() to see details.

    Failed to get Status of Servers and System Components

  • Windows 10 is not a certified OS for OBIEE. It isn't expected to work on that OS.

    It's not you changing IP but your router doing it by itself (the joys of dhcp).

    Install Virtualbox and an Oracle Linux 7 vm: it's a supported os for obiee, will take about 10-15 minutes and another advantage is that you can take snapshots or clone the vm. Simple and avoid many issues.

    Search here in the forum for the hundreds of people who ended up being in your situation and lost hours and hours trying to make work an enterprise tool on a desktop OS.

  • Just for the part about having a not adapted network configuration on a laptop vs a server or a vm: in your log at some point you have something like t3://DESKTOP-1Q20P03:9500: [RJVM:000575]Destination 169.254.137.174, 9500

    When you have a 169. address its when windows assign itself an ip address because no connection. While in general your laptop is supposed to have a connection and a "real" ip.

  • Thanks for the Update.

  • Hello Gianni,

    Thank you so much for your inputs. I installed Oracle virtual box manager and configured it according to the deployment guide. After that when i try to Start DB & BI it is unable to start some servers. I'm posting the command prompt output below. Can you take a look.

    SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 7 15:02:16 2017

    Copyright (c) 1982, 2014, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> ORA-00845: MEMORY_TARGET not supported on this system

    SQL> alter pluggable database all open

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

    SQL> Disconnected

    /app/oracle/scripts/startall12c.sh: line 9: wait: pid 5 is not a child of this shell

    Starting BI services.....

    Starting domain; Using domainHome: /app/oracle/biee/user_projects/domains/bi ...

    Initializing WebLogic Scripting Tool (WLST) ...

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    <Nov 7, 2017 3:03:45 PM EST> <Info> <Security> <BEA-090905> <Disabling the CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.>

    <Nov 7, 2017 3:03:45 PM EST> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.>

    <Nov 7, 2017 3:03:45 PM EST> <Info> <Security> <BEA-090909> <Using the configured custom SSL Hostname Verifier implementation: weblogic.security.utils.SSLWLSHostnameVerifier$NullHostnameVerifier.>

    Node manager not running. Starting it...

    NMProcess: NODEMGR_HOME is already set to /app/oracle/biee/user_projects/domains/bi/nodemanager

    NMProcess: CLASSPATH=/usr/java/jdk1.8.0_77/lib/tools.jar:/app/oracle/biee/wlserver/server/lib/weblogic.jar:/app/oracle/biee/wlserver/../oracle_common/modules/net.sf.antcontrib_1.1.0.0_1-0b3/lib/ant-contrib.jar:/app/oracle/biee/wlserver/modules/features/oracle.wls.common.nodemanager.jar::/usr/java/jdk1.8.0_77/lib/tools.jar:/app/oracle/biee/wlserver/modules/features/wlst.wls.classpath.jar:/app/oracle/biee/wlserver/..

    NMProcess: + /usr/java/jdk1.8.0_77/bin/java -server -Xms32m -Xmx200m -Dcoherence.home=/app/oracle/biee/wlserver/../coherence -Dbea.home=/app/oracle/biee/wlserver/.. -DNodeManagerHome=/app/oracle/biee/user_projects/domains/bi/nodemanager -DLogToStderr=false -DQuitEnabled=true -Dweblogic.RootDirectory=/app/oracle/biee/user_projects/domains/bi -Doracle.security.jps.config=/app/oracle/biee/user_projects/domains/bi/config/fmwconfig/jps-config-jse.xml -Dcommon.components.home=/app/oracle/biee/oracle_common -Dopss.version=12.2.1.1 -Dweblogic.RootDirectory=/app/oracle/biee/user_projects/domains/bi -Doracle.bi.home.dir=/app/oracle/biee/bi -Doracle.bi.config.dir=/app/oracle/biee/user_projects/domains/bi/config/fmwconfig/biconfig -Doracle.bi.environment.dir=/app/oracle/biee/user_projects/domains/bi/config/fmwconfig/bienv -Doracle.bi.12c=true -Ddomain.home=/app/oracle/biee/user_projects/domains/bi -Dfile.encoding=utf-8 -Djava.system.class.loader=com.oracle.classloader.weblogic.LaunchClassLoader -Djava.security.policy=/app/oracle/biee/wlserver/server/lib/weblogic.policy -Dweblogic.nodemanager.JavaHome=/usr/java/jdk1.8.0_77 weblogic.NodeManager -v

    NMProcess: Nov 07, 2017 3:04:18 PM oracle.security.opss.internal.runtime.ServiceContextManagerImpl getContext

    NMProcess: WARNING: Bootstrap services are used by OPSS internally and clients should never need to directly read/write bootstrap credentials. If required, use Wlst or configuration management interfaces.

    NodeManager started

    Reading domain...

    /Servers/AdminServer/ListenPort=7001

    Accessing admin server using URL t3://demo.us.oracle.com:7001

    Starting AdminServer ...

    Admin Server Start Exception: Error occurred while performing nmStart : Error Starting server AdminServer : Received error message from Node Manager Server: [Server start command for WebLogic server 'AdminServer' failed due to: [Server failed to start up but Node Manager was not aware of the reason]. Please check Node Manager log and/or server 'AdminServer' log for detailed information.]. Please check Node Manager log for details.

    Use dumpStack() to view the full stacktrace :

    Reading domain...

    /Servers/AdminServer/ListenPort=7001

    Accessing admin server using URL t3://demo.us.oracle.com:7001

    Requesting credentials ...

    Enter Weblogic login details at prompt

    Weblogic Username: weblogic

    Weblogic Password:

    Starting AdminServer ...

    Unable to connect to AdminServer on host: demo.us.oracle.com

    Failed to start one or more Servers

    /Servers/AdminServer/ListenPort=7001

    Accessing admin server using URL t3://demo.us.oracle.com:7001

    Start Admin Server connect Exception caught Error occurred while performing connect : Error getting the initial context. There is no server running at t3://demo.us.oracle.com:7001 : Failed to initialize JNDI context, tried 1 time or times totally, the interval of each time is 0ms.

    t3://demo.us.oracle.com:7001: Destination 127.0.0.1, 7001 unreachable.; nested exception is:

        java.net.ConnectException: Connection refused; No available router to destination.; nested exception is:

        java.rmi.ConnectException: No available router to destination.

    Use dumpStack() to view the full stacktrace :

    Reading domain...

    Error: runCmd() failed. Do dumpStack() to see details.

    Failed to get Status of Servers and System Components

    all demo services have been started- leave this window open.

  • What and how did you installed? (what OS, products, versions etc.)

    As your DB doesn't start fine because of "ORA-00845: MEMORY_TARGET not supported on this system" then nothing else will works (as depend on the DB).

    So looks like a lack of resources .... (if you installed it's weird it didn't tell you that during install, if you are using an existing VM would be helpful to know which one).

  • I'm using windows 10. I installed it with the help of instructions in deployment guide you've provided in the comments above. Oracle virtual box Version 5.2.0 r118431 (Qt5.6.2) is the VM i'm using.

  • So your laptop/desktop is Windows 10, on it you have Virtualbox, till here all ok.

    In VirtualBox you deployed OBIEE SampleApp 607 ?

    What resources did you assign to the VM? (cpu, ram)

  • 3 GB RAM and CPU 4

  • If you are using SA607 and look at the deployment guide you will see this:

    6.5 GB ramUsers with more physical host memory can allocate more memory to the virtual machine

    OBIEE is an enterprise tool, it's big and require resources. The DB same business, so with 3Gb RAM the DB doesn't even start (in a new install the DB can be installed with just 3Gb of RAM, but you have no chance to have OBIEE on top as OBIEE takes 3Gb and more by itself).

    Increase the RAM (if you have only 8Gb close all the not needed apps on Windows to get as much free RAM as you can).

  • It worked. Thank you.