Oracle Business Intelligence

Products Banner

unable to install OBIEE 12c

Received Response
252
Views
11
Comments

Hi ,

   We are trying to install OBIEE 12c on Linux Machine.

   We are facing issue when we try to do configuration.

  )  run ./config.sh

    given connection detail ,

     its got failed at OBIEE config

    obiee.log file :

[oracle@houbiap1 config2016-06-01_08-03-55AM]$ cat biee.log

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

dbargs.py /app/OBIEE12c/bi/modules/oracle.bi.configassistant/biee.py /app/OBIEE12c /app/OBIEE12c/user_projects/domains/bi weblogic Expanded houbiap1.oii.oceaneering.com 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//houbidb2:1521/bi12cdev DEV12C jdbc:oracle:thin:@//houbidb2:1521/bi12cdev

Reading passwords from stdin...

Enter admin password

Enter DBSchema password

Extending domain with BIEE Suite template

Configuring datasources ...

Setting JDBC url to jdbc:oracle:thin:@//houbidb2:1521/bi12cdev

Deleting old user of type Property

Creating user of type Property at /JDBCSystemResource/LocalSvcTblDataSource/JdbcResource/LocalSvcTblDataSource/JDBCDriverParams/NO_NAME_0/Properties/NO_NAME_0

Master STB data source defined

Jun 01, 2016 8:39:25 AM com.oracle.cie.domain.script.jython.CommandExceptionHandler handleException

SEVERE: Error: getDatabaseDefaults() failed.

com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

        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.getDatabaseDefaults(WLScriptContext.java:3303)

        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 com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:216)

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

        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 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._pyx38.command$1(/tmp/WLSTOfflineIni7831063701935827796.py:19)

        at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni7831063701935827796.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni7831063701935827796.py:251)

        at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni7831063701935827796.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.core.PyObject.invoke(Unknown Source)

        at dbargs$py.configureSimpleDefaultDataSources$3(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py:137)

        at dbargs$py.call_function(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/dbargs.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.core.PyObject.invoke(Unknown Source)

        at bieeimpl$py.configureBIEE$2(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py:40)

        at bieeimpl$py.call_function(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.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.core.PyObject.invoke(Unknown Source)

        at org.python.pycode._pyx139.f$0(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/biee.py:20)

        at org.python.pycode._pyx139.call_function(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/biee.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: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

        at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)

        at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

        ... 51 more

Caused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object:

Root Cause: java.sql.SQLRecoverableException: IO Error: Connection reset

        at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:639)

        at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)

        ... 52 more

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

Jun 01, 2016 8:39:25 AM com.oracle.cie.domain.script.jython.CommandExceptionHandler handleException

SEVERE: Error: runCmd() failed.

com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

        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.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 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._pyx38.command$1(/tmp/WLSTOfflineIni7831063701935827796.py:19)

        at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni7831063701935827796.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni7831063701935827796.py:251)

        at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni7831063701935827796.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.core.PyObject.invoke(Unknown Source)

        at dbargs$py.configureSimpleDefaultDataSources$3(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py:137)

        at dbargs$py.call_function(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/dbargs.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.core.PyObject.invoke(Unknown Source)

        at bieeimpl$py.configureBIEE$2(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py:40)

        at bieeimpl$py.call_function(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.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.core.PyObject.invoke(Unknown Source)

        at org.python.pycode._pyx139.f$0(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/biee.py:20)

        at org.python.pycode._pyx139.call_function(/app/OBIEE12c/bi/modules/oracle.bi.configassistant/biee.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: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

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

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

        ... 45 more

Caused by: com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

        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.getDatabaseDefaults(WLScriptContext.java:3303)

        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 com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:216)

        ... 46 more

Caused by: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

        at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)

        at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

        ... 51 more

Caused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object:

Root Cause: java.sql.SQLRecoverableException: IO Error: Connection reset

        at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:639)

        at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)

        ... 52 more

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

Problem invoking WLST - Traceback (innermost last):

  File "/app/OBIEE12c/bi/modules/oracle.bi.configassistant/biee.py", line 20, in ?

  File "/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py", line 40, in configureBIEE

  File "/app/OBIEE12c/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py", line 137, in configureSimpleDefaultDataSources

  File "/tmp/WLSTOfflineIni7831063701935827796.py", line 251, in getDatabaseDefaults

  File "/tmp/WLSTOfflineIni7831063701935827796.py", line 19, in command

Failed to build JDBC Connection object:

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

com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

Failed to build JDBC Connection object:

Please suggest ASP.

Thanks ,

Sam

Answers

  • Hi Sam,

    Just to make sure, what kind of tutorial / blog / document are you following for the install?

    In case you don't have any have a look at https://realtrigeek.com/2016/04/15/installing-obiee-on-linux/ or also Installing OBIEE 12c.  Part 1: Prerequisites - Red Stack Tech  .

    Your log complains about some JDBC ... but not super explicit...

  • Same problem for me on my Linux installation.

    It stops with the following error at 42% of installation, during "Complete domain" step.

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

    -bash-4.2$ pwd

    /home/oracle/oraInventory/logs/config2016-06-06_12-00-54PM

    -bash-4.2$ cat completeDomain.log

    Initializing WebLogic Scripting Tool (WLST) ...

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    dbargs.py /home/oracle/mw_homeA/bi/modules/oracle.bi.configassistant/complete_domain.py /home/oracle/mw_homeA /home/oracle/mw_homeA/user_projects/domains/bi weblogic Expanded svil18.dev.csebo.it 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//svil01.dev.csebo.it:1523/sbirepo DEV12CA jdbc:oracle:thin:@//svil01.dev.csebo.it:1523/sbirepo

    Reading passwords from stdin...

    Enter admin password

    Enter DBSchema password

    Jun 06, 2016 12:36:53 PM com.oracle.cie.domain.script.jython.CommandExceptionHandler handleException

    SEVERE: Error: getDatabaseDefaults() failed.

    com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

            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.getDatabaseDefaults(WLScriptContext.java:3303)

            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 com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:216)

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

            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 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._pyx38.command$1(/tmp/WLSTOfflineIni8571712042061287013.py:19)

            at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni8571712042061287013.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni8571712042061287013.py:251)

            at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni8571712042061287013.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.core.PyObject.invoke(Unknown Source)

            at completedomainimpl$py.completeDomain$1(/home/oracle/mw_homeA/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.py:25)

            at completedomainimpl$py.call_function(/home/oracle/mw_homeA/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.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.core.PyObject.invoke(Unknown Source)

            at org.python.pycode._pyx139.f$0(/home/oracle/mw_homeA/bi/modules/oracle.bi.configassistant/complete_domain.py:36)

            at org.python.pycode._pyx139.call_function(/home/oracle/mw_homeA/bi/modules/oracle.bi.configassistant/complete_domain.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: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

            at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)

            at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

            ... 45 more

    Caused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object:

    Root Cause: java.sql.SQLRecoverableException: IO Error: Connection reset

            at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:639)

            at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)

            ... 46 more

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

  • vai
    vai ✭✭✭

    @Gianni Ceresa

    even i am facing same error during "Complete domain" step.

    below are the log details for completedoamin.log-

    Initializing WebLogic Scripting Tool (WLST) ...

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    dbargs.py /home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/complete_domain.py /home/oracle/Oracle/Middleware/Oracle_Home /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic Expanded localhost 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//localhost:1521/orcl TEST jdbc:oracle:thin:@//localhost:1521/orcl

    Reading passwords from stdin...

    Enter admin password

    Enter DBSchema password

    Jun 07, 2016 5:53:01 PM com.oracle.cie.domain.script.jython.CommandExceptionHandler handleException

    SEVERE: Error: getDatabaseDefaults() failed.

    com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

      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.getDatabaseDefaults(WLScriptContext.java:3303)

      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 com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:216)

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

      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 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._pyx38.command$1(/tmp/WLSTOfflineIni2519205166182829026.py:19)

      at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni2519205166182829026.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni2519205166182829026.py:251)

      at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni2519205166182829026.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.core.PyObject.invoke(Unknown Source)

      at completedomainimpl$py.completeDomain$1(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.py:25)

      at completedomainimpl$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.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.core.PyObject.invoke(Unknown Source)

      at org.python.pycode._pyx139.f$0(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/complete_domain.py:36)

      at org.python.pycode._pyx139.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/complete_domain.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: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

      at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)

      at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

      ... 45 more

    Caused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object:

    Root Cause: java.sql.SQLRecoverableException: IO Error: Connection reset

      at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:639)

      at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)

      ... 46 more

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

    Jun 07, 2016 5:53:01 PM com.oracle.cie.domain.script.jython.CommandExceptionHandler handleException

    SEVERE: Error: runCmd() failed.

    com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

      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.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 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._pyx38.command$1(/tmp/WLSTOfflineIni2519205166182829026.py:19)

      at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni2519205166182829026.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni2519205166182829026.py:251)

      at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni2519205166182829026.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.core.PyObject.invoke(Unknown Source)

      at completedomainimpl$py.completeDomain$1(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.py:25)

      at completedomainimpl$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.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.core.PyObject.invoke(Unknown Source)

      at org.python.pycode._pyx139.f$0(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/complete_domain.py:36)

      at org.python.pycode._pyx139.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/complete_domain.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: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

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

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

      ... 39 more

    Caused by: com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

      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.getDatabaseDefaults(WLScriptContext.java:3303)

      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 com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:216)

      ... 40 more

    Caused by: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

      at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)

      at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

      ... 45 more

    Caused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object:

    Root Cause: java.sql.SQLRecoverableException: IO Error: Connection reset

      at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:639)

      at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)

      ... 46 more

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

    Problem invoking WLST - Traceback (innermost last):

      File "/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/complete_domain.py", line 36, in ?

      File "/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/completedomainimpl.py", line 25, in completeDomain

      File "/tmp/WLSTOfflineIni2519205166182829026.py", line 251, in getDatabaseDefaults

      File "/tmp/WLSTOfflineIni2519205166182829026.py", line 19, in command

    Failed to build JDBC Connection object:

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

    com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:

    Failed to build JDBC Connection object:

  • Issue is resolved for me .

    Fix: Changed the Schema password from "Admin123" to "admin123"

    After fixing this, installation went smooth

  • vkm
    vkm ✭✭✭✭

    How did you change the schema password? Did change it for each schema by running a SQL on the database or did you drop the repository using RCU and recreated new?

  • I've had the same issue.  Our Weblogic/OSB bnary install is installed as a different Unix user than the ones used for creating domains.  There are files in the install that are by default permissions set to 600 such as below:

    ${FMW_HOME}/oracle_common/modules/oracle.jps/domain_config/wls/system-jazn-data.xml

    This therefore prevents the domain creation when a different user is being used as the files are not readable.

    The OSB domain user should be in the same unix group as the FMW install, so then the solution is to change the permissions to allow group read (and possibly write?).

    As as rule of thumb, on installation for our shared FMW binaries, we set the permissions as follows:

    These 2 lines prevent the first user locking "shared" folders / file

    mkdir -p ${FMW_HOME}/user_projects/applications

    touch ${FMW_HOME/domain-registry.xml

    Permissions

    chmod 770 ${FMW_HOME}

    find ${FMW_HOME} -type d | xargs chmod 770

    find ${FMW_HOME} -type f | xargs chmod g+rw

  • I had similar problem on my Linux box and I was able to solve following this link:

    https://community.oracle.com/thread/943911?tstart=0

    I guess there are known problem in Oracle on "java.sql.SQLRecoverableException:  during products install on Linux/Unix.

    In the previous link I read "I opened a ticket with Oracle and this is what they told me".

    The problem is related to this JDK class: "java.security.SecureRandom"

    Looking at the source in the latest JDK you can find:

    " * Note: Depending on the implementation, the {@code generateSeed} and

    * {@code nextBytes} methods may block as entropy is being gathered,

    * for example, if they need to read from /dev/random on various Unix-like

    * operating systems.

    "

    So I followed the work-around from the forum and added -Djava.security.egd=file:///dev/../dev/urandom to WLST shell command

    [MW_HOME]/oracle_common/common/bin/wlst.sh

    " .....

    JVM_ARGS="-Djava.security.egd=file:///dev/../dev/urandom ${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}"

    if [ -d "${JAVA_HOME}" ]; then

    eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} weblogic.WLST '"$@"'

    else

    exit 1

    fi

    ...."

    And this fix it.

    Before this I tried several times having always the same "IO Error: Connection reset" problem in different steps of installation process.

    Hope this help.

    Ciao

    Dario

  • This did indeed solve the installation problem, thank you ever so much!

  • Thanks for this workaround.

    I encountered the same problem and this workaround fixed my problem.

  • Hey. I've got the same issue.

    -Djava.security.egd=file:///dev/../dev/urandom didn't help, but -Djava.security.egd=file:///dev/urandom did solve the error.