OBIEE 12C ERR_CONNECTION_REFUSED

User_IP06I

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

Can Anyone Help? Thanks in Advance

Gianni Ceresa

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.)

User_IP06I

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

Gianni Ceresa

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.

Gianni Ceresa

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.

User_IP06I

Thanks for the Update.

User_IP06I

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.

Gianni Ceresa

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).

User_IP06I

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.

Gianni Ceresa

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)

User_IP06I

3 GB RAM and CPU 4

Gianni Ceresa

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).

User_IP06I

It worked. Thank you.