1 2 Previous Next 22 Replies Latest reply on May 24, 2017 8:26 AM by Gianni Ceresa Go to original post
      • 15. Re: OBIEE 12C Post Installation Issue
        1018671

        Hi Syam,

         

        Thanks for your response.

         

        My Issue is not related to wat u had mentioned ,because my pdb's are already in OPEN status.

         

        Already issue got resolved due to some firewall.

         

        Regards,

        Suman.

        • 16. Re: OBIEE 12C Post Installation Issue
          Joaz Vieira

          I had the same error on startup of my obiee 12c, was operating normally after the server reboot the obiee failed to start with error mentioned in this topic:

           

           

          "Reading domain...

          /Servers/AdminServer/ListenPort=9500

          Accessing admin server using URL t3://SUMAN:9500

          Starting AdminServer ...

          Admin Server Start Exception: Error occurred while performing nmStart : Error St

          arting server AdminServer : Received error message from Node Manager Server: [Se

          rver start command for WebLogic server 'AdminServer' failed due to: [Server fail

          ed 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 c

          heck Node Manager log for details.

          Use dumpStack() to view the full stacktrace :

          Reading domain...

          /Servers/AdminServer/ListenPort=9500

          Accessing admin server using URL t3://SUMAN:9500

          Requesting credentials ...

          Enter Weblogic login details at prompt

          Weblogic Username: weblogic

          Weblogic Password:

          Starting AdminServer ...

          Unable to connect to AdminServer on host: SUMAN

           

           

          Failed to start one or more Servers

           

           

          /Servers/AdminServer/ListenPort=9500

          Accessing admin server using URL t3://SUMAN:9500

          Start Admin Server connect Exception caught Error occurred while performing conn

          ect : Error getting the initial context. There is no server running at t3://SUMA

          N:9500 : t3://SUMAN:9500: [RJVM:000575]Destination 10.10.10.10, 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 destinati

          on."

           

           

          The solution was:

           

           

          Change the owner of some files in the folder:

           

           

          /oracle/Middleware/Oracle_Home/user_projects/domains/bi/servers/AdminServer

           

           

          some files were with the root owner, moved to oracle. and my obiee returned to work.

          • 17. Re: OBIEE 12C Post Installation Issue
            3142472

            I had the same issue, and Fixed it after a lot of frustration. I did 2 things and not sure which one solved it for me.

            1. My OracleService was down hence it gave me connected to idle instance message on sqlplus, so i just started it (Services) and logged in sqlplus to ensure that my DB was working.

            2. Enabled Ports 9500 and 9502 on my Windows 2012 server box .

            thanks for the advice guyz.

            • 18. Re: OBIEE 12C Post Installation Issue
              3192491

              i have this problem!

               

              error.png

              • 19. Re: OBIEE 12C Post Installation Issue
                3223491

                Hi

                 

                Can you please provide the detailed steps you followed to resolve this error ? It will be a great help.

                 

                Thanks

                • 20. Re: OBIEE 12C Post Installation Issue
                  Ritesh S

                  Shyam , This helped me resolve my issue. which is posted here Error Starting OBIEE12c Services on Windows

                   

                  Thanks.

                  • 21. Re: OBIEE 12C Post Installation Issue
                    7272543d-b5c8-45b1-b6c3-23e9590bc752

                    I too got the same issue.

                     

                    Unable to connect to AdminServer on host: LAPTOP-EQV0VVQ1

                     

                    Please help me with this. What you exactly did?

                    • 22. Re: OBIEE 12C Post Installation Issue
                      3423029

                      Hi All,

                       

                      Please I need help. unable to start OBI 12c (start.cmd) after Importing the Primavera Data Warehouse Sample Schema.

                       

                      Please see below the log files results. Your help would be highly appreciated.

                       

                      Thanks

                       

                      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]

                       

                      ####<23-May-2017, 7:23:50,263 PM BST> <Info> <Security> <DESKTOP-8UK0TJK> <> <main> <> <> <> <1495563830263> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-090905> <Disabling the CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.>

                      ####<23-May-2017, 7:23:50,397 PM BST> <Info> <Security> <DESKTOP-8UK0TJK> <> <main> <> <> <> <1495563830397> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.>

                      ####<23-May-2017, 7:23:51,241 PM BST> <Info> <WebLogicServer> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563831241> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000377> <Starting WebLogic Server with Java HotSpot(TM) 64-Bit Server VM Version 25.131-b11 from Oracle Corporation.>

                      ####<23-May-2017, 7:23:52,7 PM BST> <Info> <RCM> <DESKTOP-8UK0TJK> <> <Thread-8> <> <> <> <1495563832007> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-2165021> <"ResourceManagement" is not enabled in this JVM. Enable "ResourceManagement" to use the WebLogic Server "Resource Consumption Management" feature. To enable "ResourceManagement", you must specify the following JVM options in the WebLogic Server instance in which the JVM runs: -XX:+UnlockCommercialFeatures -XX:+ResourceManagement.>

                      ####<23-May-2017, 7:23:52,100 PM BST> <Info> <Management> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563832100> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-141107> <Version: WebLogic Server 12.2.1.2.0 Mon Oct  3 04:35:36 PDT 2016 1827450>

                      ####<23-May-2017, 7:23:56,808 PM BST> <Notice> <WebLogicServer> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836808> <[severity-value: 32] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000365> <Server state changed to STARTING.>

                      ####<23-May-2017, 7:23:56,840 PM BST> <Info> <WorkManager> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836840> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002900> <Initializing self-tuning thread pool.>

                      ####<23-May-2017, 7:23:56,871 PM BST> <Info> <WorkManager> <DESKTOP-8UK0TJK> <> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563836871> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002942> <CMM memory level becomes 0. Setting standby thread pool size to 256.>

                      ####<23-May-2017, 7:23:56,902 PM BST> <Info> <WebLogicServer> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836902> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000214> <WebLogic Server "AdminServer" version:

                      WebLogic Server 12.2.1.2.0 Mon Oct  3 04:35:36 PDT 2016 1827450 Copyright (c) 1995,2016, Oracle and/or its affiliates. All rights reserved.>

                      ####<23-May-2017, 7:23:56,933 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836933> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "t3" is now configured.>

                      ####<23-May-2017, 7:23:56,933 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836933> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "t3s" is now configured.>

                      ####<23-May-2017, 7:23:56,933 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836933> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "http" is now configured.>

                      ####<23-May-2017, 7:23:56,933 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836933> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "https" is now configured.>

                      ####<23-May-2017, 7:23:56,949 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836949> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "iiop" is now configured.>

                      ####<23-May-2017, 7:23:56,949 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836949> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "iiops" is now configured.>

                      ####<23-May-2017, 7:23:56,949 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836949> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "ldap" is now configured.>

                      ####<23-May-2017, 7:23:56,949 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836949> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "ldaps" is now configured.>

                      ####<23-May-2017, 7:23:56,965 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836965> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "cluster" is now configured.>

                      ####<23-May-2017, 7:23:56,965 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836965> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "clusters" is now configured.>

                      ####<23-May-2017, 7:23:56,980 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836980> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "snmp" is now configured.>

                      ####<23-May-2017, 7:23:56,980 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836980> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002622> <The protocol "admin" is now configured.>

                      ####<23-May-2017, 7:23:56,980 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-5> <> <> <> <1495563836980> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002624> <The administration protocol is "t3s" and is now configured.>

                      ####<23-May-2017, 7:23:57,386 PM BST> <Info> <RJVM> <DESKTOP-8UK0TJK> <> <Thread-8> <> <> <> <1495563837386> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000570> <Network Configuration for Channel "AdminServer"

                      Listen Address                  :9500

                      Public Address                  N/A

                      Http Enabled                    true

                      Tunneling Enabled          false

                      Outbound Enabled         false

                      Admin Traffic Enabled   true ResolveDNSName Enabled false>

                      ####<23-May-2017, 7:23:57,386 PM BST> <Debug> <RJVM> <DESKTOP-8UK0TJK> <> <Thread-8> <> <> <> <1495563837386> <[severity-value: 128] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000571> <Network Configuration Detail for Channel "AdminServer"

                      Channel Weight                              50

                      Accept Backlog                300

                      Login Timeout                  5000ms

                      Max Message Size          10000000

                      Message Timeout           60s

                      Idle Timeout                     65s

                      Tunneling Timeout         40s

                      Tunneling Ping                 45s>

                      ####<23-May-2017, 7:23:57,418 PM BST> <Info> <Server> <DESKTOP-8UK0TJK> <> <Thread-8> <> <> <> <1495563837418> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002609> <Channel Service initialized.>

                      ####<23-May-2017, 7:23:57,835 PM BST> <Info> <Socket> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563837835> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000436> <Allocating 4 reader threads.>

                      ####<23-May-2017, 7:23:57,835 PM BST> <Info> <Socket> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563837835> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000446> <Native I/O enabled.>

                      ####<23-May-2017, 7:23:57,866 PM BST> <Info> <XML> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563837866> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-130036> <Initializing XMLRegistry>

                      ####<23-May-2017, 7:23:58,54 PM BST> <Info> <Management> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563838054> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-141278> <Java entropy configuration is: System property "java.security.egd= null"; JRE's java.security file property "securerandom.source= file:/dev/random"; Blocking Config= true; JDK version= 1.8.0_131; Operating System= Windows 10.>

                      ####<23-May-2017, 7:23:58,54 PM BST> <Info> <Management> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563838054> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-141280> <Detected NON-BLOCKING java entropy configuration. This setting will provide the best performance on machines with few sources of entropy, but is less secure than a blocking entropy configuration.>

                      ####<23-May-2017, 7:23:58,54 PM BST> <Info> <Management> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563838054> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-141187> <Java system properties are defined as follows:

                      CDS_DATASOURCE = BIPlatformDatasource

                      EPM_ORACLE_HOME = C:\Oracle\Middleware\Oracle_Home\bi

                      EPM_ORACLE_INSTANCE = novalue

                      EPM_REG_PROPERTIES_PATH = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig

                      ESSBASEPATH = C:\Oracle\Middleware\Oracle_Home\bi\products\Essbase\EssbaseServer

                      ESS_ES_HOME = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\servers\AdminServer\aps

                      HYPERION_HOME = C:\Oracle\Middleware\Oracle_Home\bi

                      INSTANCE_HOME = C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi

                      XDO_FONT_DIR = C:\Oracle\Middleware\Oracle_Home\bi\common\fonts

                      1. adf.version = 12.2.1.1.0
                      2. aps.property.file = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig\biconfig\aps\essbase.properties
                      3. awt.toolkit = sun.awt.windows.WToolkit
                      4. common.components.home = C:\Oracle\Middleware\Oracle_Home\oracle_common
                      5. domain.home = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi
                      6. em.oracle.home = C:\Oracle\Middleware\Oracle_Home\em
                      7. epm.useApplicationContextId = false
                      8. file.encoding = utf-8
                      9. file.encoding.pkg = sun.io
                      10. file.separator = \
                      11. hyperion.home = C:\Oracle\Middleware\Oracle_Home\bi
                      12. igf.arisidbeans.carmlloc = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig\carml
                      13. igf.arisidstack.home = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig\arisidprovider
                      14. java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment
                      15. java.awt.headless = true
                      16. java.awt.printerjob = sun.awt.windows.WPrinterJob
                      17. java.class.path = C:\Oracle\MIDDLE~1\ORACLE~1\bi\bifoundation\jdbc\jdk18\bijdbc.jar;C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\features\com.oracle.db.jdbc7-dms.jar;C:\PROGRA~1\Java\JDK18~1.0_1\lib\tools.jar;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server\lib\weblogic.jar;C:\Oracle\MIDDLE~1\ORACLE~1\oracle_common\modules\net.sf.antcontrib_1.1.0.0_1-0b3\lib\ant-contrib.jar;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\modules\features\oracle.wls.common.nodemanager.jar;C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.jps\jps-manifest.jar;C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\internal\features\jrf_wlsFmw_oracle.jrf.wls.classpath.jar;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\common\derby\lib\derbynet.jar;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\common\derby\lib\derbyclient.jar;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\common\derby\lib\derby.jar;C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi;C:\PROGRA~1\Java\JDK18~1.0_1\lib\tools.jar;C:\PROGRA~1\Java\JDK18~1.0_1\lib\tools.jar;C:\Oracle\MIDDLE~1\ORACLE~1\ORACLE~1\modules\oracle.jps\JPS-MA~1.JAR;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server\lib\debugpatch-agent.jar
                      18. java.class.version = 52.0
                      19. java.endorsed.dirs = C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\endorsed
                      20. java.ext.dirs = C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
                      21. java.home = C:\PROGRA~1\Java\JDK18~1.0_1\jre
                      22. java.io.tmpdir = C:\WINDOWS\TEMP\
                      23. java.library.path = C:\PROGRA~1\Java\JDK18~1.0_1\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\bin;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server\native\win\x64;C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server\bin;C:\Oracle\MIDDLE~1\ORACLE~1\ORACLE~1\modules\ORGAPA~1.2\bin;C:\PROGRA~1\Java\JDK18~1.0_1\jre\bin;C:\PROGRA~1\Java\JDK18~1.0_1\bin;c:\app\P6admin\product\121~1.0\client_2;c:\app\P6admin\product\121~1.0\client_1;c:\app\P6admin\product\121~1.0\dbhome_1\BIN;c:\PROGRA~3\Oracle\Java\javapath;c:\Windows\System32;c:\Windows;c:\Windows\System32\wbem;c:\Windows\System32\WINDOW~1\v1.0\;c:\app\P6admin\product\121~1.0\dbhome_1\NETWORK\ADMIN;C:\PROGRA~2\NVIDIA~1\PhysX\Common;C:\Oracle\MIDDLE~1\ORACLE~1\bin;.
                      24. java.naming.factory.initial = weblogic.jndi.WLInitialContextFactory
                      25. java.naming.factory.url.pkgs = weblogic.jndi.factories:weblogic.corba.j2ee.naming.url:weblogic.jndi.factories:weblogic.corba.j2ee.naming.url
                      26. java.protocol.handler.pkgs = oracle.mds.net.protocol
                      27. java.runtime.name = Java(TM) SE Runtime Environment
                      28. java.runtime.version = 1.8.0_131-b11
                      29. java.security.policy = C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server\lib\weblogic.policy
                      30. java.specification.name = Java Platform API Specification
                      31. java.specification.vendor = Oracle Corporation
                      32. java.specification.version = 1.8
                      33. java.system.class.loader = com.oracle.classloader.weblogic.LaunchClassLoader
                      34. java.util.logging.manager = oracle.core.ojdl.logging.ODLLogManager
                      35. java.vendor = Oracle Corporation
                      36. java.vendor.url = http://java.oracle.com/
                      37. java.vendor.url.bug = http://bugreport.sun.com/bugreport/
                      38. java.version = 1.8.0_131
                      39. java.vm.info = mixed mode
                      40. java.vm.name = Java HotSpot(TM) 64-Bit Server VM
                      41. java.vm.specification.name = Java Virtual Machine Specification
                      42. java.vm.specification.vendor = Oracle Corporation
                      43. java.vm.specification.version = 1.8
                      44. java.vm.vendor = Oracle Corporation
                      45. java.vm.version = 25.131-b11
                      46. javax.management.builder.initial = weblogic.management.jmx.mbeanserver.WLSMBeanServerBuilder
                      47. javax.rmi.CORBA.PortableRemoteObjectClass = weblogic.iiop.PortableRemoteObjectDelegateImpl
                      48. javax.rmi.CORBA.UtilClass = weblogic.iiop.UtilDelegateImpl
                      49. jrf.version = 12.2.1
                      • opss.version = 12.2.1.2
                      • oracle.bi.12c = true
                      • oracle.bi.config.dir = C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\config\fmwconfig\biconfig
                      • oracle.bi.environment.dir = C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\config\fmwconfig\bienv
                      • oracle.bi.home.dir = C:\Oracle\Middleware\Oracle_Home\bi
                      • oracle.deployed.app.dir = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\servers\AdminServer\tmp\_WL_user
                      • oracle.deployed.app.ext = \-
                      • oracle.domain.config.dir = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig
                      • oracle.maps.config = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig\mapviewer\conf\mapViewerConfig.xml
                      • oracle.security.jps.config = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig\jps-config.xml
                      • oracle.server.config.dir = C:\Oracle\MIDDLE~1\ORACLE~1\USER_P~1\domains\bi\config\fmwconfig\servers\AdminServer
                      • oracle.sysman.util.logging.mode = dual_mode
                      • org.apache.commons.logging.Log = org.apache.commons.logging.impl.Jdk14Logger
                      • org.omg.CORBA.ORBClass = weblogic.corba.orb.ORB
                      • org.omg.CORBA.ORBSingletonClass = weblogic.corba.orb.ORB
                      • os.arch = amd64
                      • os.name = Windows 10
                      • os.version = 10.0
                      1. path.separator = ;
                      2. sun.arch.data.model = 64
                      3. sun.boot.class.path = C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\resources.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\rt.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\sunrsasign.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\jsse.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\jce.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\charsets.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\lib\jfr.jar;C:\PROGRA~1\Java\JDK18~1.0_1\jre\classes
                      4. sun.boot.library.path = C:\PROGRA~1\Java\JDK18~1.0_1\jre\bin
                      5. sun.cpu.endian = little
                      6. sun.cpu.isalist = amd64
                      7. sun.desktop = windows
                      8. sun.io.unicode.encoding = UnicodeLittle
                      9. sun.java.command = weblogic.Server
                      10. sun.java.launcher = SUN_STANDARD
                      11. sun.jnu.encoding = Cp1252
                      12. sun.management.compiler = HotSpot 64-Bit Tiered Compilers
                      13. user.country = GB
                      14. user.dir = C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi
                      15. user.home = C:\WINDOWS\system32\config\systemprofile
                      16. user.language = en
                      17. user.name = DESKTOP-8UK0TJK$
                      18. user.timezone = Europe/London
                      • vde.home = C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\AdminServer\data\ldap
                      1. weblogic.Name = AdminServer
                      2. weblogic.ProductionModeEnabled = true
                      3. weblogic.alternateTypesDirectory = C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.ossoiap,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.oamprovider,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.jps
                      4. weblogic.home = C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server
                      5. weblogic.jdbc.remoteEnabled = true
                      6. weblogic.nmservice.RotationEnabled = true
                      7. weblogic.nodemanager.ServiceEnabled = true
                      8. weblogic.system.BootIdentityFile = C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\AdminServer\data\nodemanager\boot.properties
                      9. wls.home = C:\Oracle\MIDDLE~1\ORACLE~1\wlserver\server
                      10. xdo.server.config.dir = C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bidata\components\bipublisher

                      .>

                      ####<23-May-2017, 7:23:58,132 PM BST> <Notice> <Log Management> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563838132> <[severity-value: 32] [partition-id: 0] [partition-name: DOMAIN] > <BEA-170019> <The server log file weblogic.logging.FileStreamHandler instance=1361321763

                      Current log file=C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\AdminServer\logs\AdminServer.log

                      Rotation dir=C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\AdminServer\logs

                      is opened. All server side log events will be written to this file.>

                      ####<23-May-2017, 7:23:58,147 PM BST> <Info> <IIOP> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563838147> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-002014> <IIOP subsystem enabled.>

                      ####<23-May-2017, 7:23:58,147 PM BST> <Info> <Log Management> <DESKTOP-8UK0TJK> <> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1495563838147> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-170023> <The Server Logging is initialized with Java Logging API implementation.>

                      ####<23-May-2017, 7:23:58,163 PM BST> <Info> <Log Management> <DESKTOP-8UK0TJK> <AdminServer> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1495563838163> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-170025> <Initialized Domain Logging. Domain log events will be written to C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\AdminServer\logs/bi.log.>

                      ####<23-May-2017, 7:23:58,382 PM BST> <Info> <Diagnostics> <DESKTOP-8UK0TJK> <AdminServer> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1495563838382> <[severity-value: 64] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320001> <The ServerDebug service initialized successfully.>

                      ####<23-May-2017, 7:23:58,694 PM BST> <Info> <Store> <DESKTOP-8UK0TJK> <AdminServer> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0c1c453a-2b12-4357-ac94-abcc863c22fb-00000001> <1495563838694> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-280008> <Opening the persistent file store "WLS_DIAGNOSTICS" for recovery: directory=C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\AdminServer\data\store\diagnostics requestedWritePolicy="Disabled" fileLockingEnabled=true driver="wlfileio3".>

                      ####<23-May-2017, 7:23:58,726 PM BST> <Info> <Store> <DESKTOP-8UK0TJK> <AdminServer> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0c1c453a-2b12-4357-ac94-abcc863c22fb-00000001> <1495563838726> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-280103> <The persistent file store "WLS_DIAGNOSTICS" will cache in weblogic.store.io.file.direct.FileMapping[granularity=65536 io=mapped].>

                      ####<23-May-2017, 7:24:00,241 PM BST> <Info> <Store> <DESKTOP-8UK0TJK> <AdminServer> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0c1c453a-2b12-4357-ac94-abcc863c22fb-00000001> <1495563840241> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-280009> <The persistent file store "WLS_DIAGNOSTICS" (cdc2b8d9-f726-443a-8da5-b346f53dd102) has been opened: blockSize=512 actualWritePolicy="Disabled(single-handle-non-direct)" explicitIOEnforced=false records=8,557.>

                      ####<23-May-2017, 7:24:04,163 PM BST> <Critical> <WebLogicServer> <DESKTOP-8UK0TJK> <AdminServer> <main> <<WLS Kernel>> <> <0c1c453a-2b12-4357-ac94-abcc863c22fb-00000002> <1495563844163> <[severity-value: 4] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000362> <Server failed. Reason:

                       

                      There are 1 nested errors:

                       

                      • oracle.security.jps.JpsException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

                      ORA-01031: insufficient privileges

                      ORA-06512: at "SYS.DBMS_SESSION", line 122

                      ORA-06512: at "STARUSER.SECPAC", line 18

                      ORA-06512: at "STARUSER.SECPAC", line 36

                      ORA-06512: at "STARUSER.SECPAC", line 53

                      ORA-06512: at line 2

                       

                                     at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:215)

                                     at oracle.security.jps.wls.JpsWlsStartup.start(JpsWlsStartup.java:104)

                                     at oracle.security.jps.JpsStartup.start(JpsStartup.java:210)

                                     at oracle.security.jps.wls.JpsDefaultService.start(JpsDefaultService.java:74)

                                     at weblogic.server.AbstractServerService.postConstruct(AbstractServerService.java:76)

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

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

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

                                     at org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1262)

                                     at org.jvnet.hk2.internal.ClazzCreator.postConstructMe(ClazzCreator.java:332)

                                     at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:374)

                                     at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:471)

                                     at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:232)

                                     at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

                                     at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2020)

                                     at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:114)

                                     at org.jvnet.hk2.internal.ServiceLocatorImpl.getService(ServiceLocatorImpl.java:693)

                                     at org.jvnet.hk2.internal.ThreeThirtyResolver.resolve(ThreeThirtyResolver.java:78)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolve(ClazzCreator.java:211)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolveAllDependencies(ClazzCreator.java:234)

                                     at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:357)

                                     at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:471)

                                     at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:232)

                                     at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

                                     at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2020)

                                     at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:114)

                                     at org.jvnet.hk2.internal.ServiceLocatorImpl.getService(ServiceLocatorImpl.java:693)

                                     at org.jvnet.hk2.internal.ThreeThirtyResolver.resolve(ThreeThirtyResolver.java:78)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolve(ClazzCreator.java:211)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolveAllDependencies(ClazzCreator.java:234)

                                     at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:357)

                                     at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:471)

                                     at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:232)

                                     at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

                                     at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2020)

                                     at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:114)

                                     at org.jvnet.hk2.internal.ServiceLocatorImpl.getService(ServiceLocatorImpl.java:693)

                                     at org.jvnet.hk2.internal.ThreeThirtyResolver.resolve(ThreeThirtyResolver.java:78)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolve(ClazzCreator.java:211)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolveAllDependencies(ClazzCreator.java:234)

                                     at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:357)

                                     at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:471)

                                     at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:232)

                                     at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

                                     at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2020)

                                     at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:114)

                                     at org.jvnet.hk2.internal.ServiceLocatorImpl.getService(ServiceLocatorImpl.java:693)

                                     at org.jvnet.hk2.internal.ThreeThirtyResolver.resolve(ThreeThirtyResolver.java:78)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolve(ClazzCreator.java:211)

                                     at org.jvnet.hk2.internal.ClazzCreator.resolveAllDependencies(ClazzCreator.java:234)

                                     at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:357)

                                     at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:471)

                                     at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:232)

                                     at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

                                     at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2020)

                                     at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:114)

                                     at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:88)

                                     at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.oneJob(CurrentTaskFuture.java:1213)

                                     at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.run(CurrentTaskFuture.java:1144)

                                     at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$UpOneLevel.run(CurrentTaskFuture.java:762)

                                     at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:666)

                                     at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)

                                     at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)

                                     at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)

                                     at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

                                     at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)

                                     at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)

                                     at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)

                      Caused by: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

                      ORA-01031: insufficient privileges

                      ORA-06512: at "SYS.DBMS_SESSION", line 122

                      ORA-06512: at "STARUSER.SECPAC", line 18

                      ORA-06512: at "STARUSER.SECPAC", line 36

                      ORA-06512: at "STARUSER.SECPAC", line 53

                      ORA-06512: at line 2

                       

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.handleDatabaseException(JpsDBDataManager.java:2164)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2656)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.existsTable(JpsDBDataManager.java:1682)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.isPrincipalAssigneeSplit(JpsDBDataManager.java:1616)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.checkFunctionSupportedInDoAs(JpsDBDataManager.java:1548)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.checkFunctionSupported(JpsDBDataManager.java:1559)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createEMFAndSubject(JpsDBDataManager.java:1773)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getEMFAndSubject(JpsDBDataManager.java:1714)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.init(JpsDBDataManager.java:1384)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectListQuery(JpsDBDataManager.java:4096)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.jpsObjectListQuery(JpsDBDataManager.java:4089)

                                     at oracle.security.jps.internal.policystore.entitymanager.impl.ApplicationManagerImpl.getAllApplicationsInTransaction(ApplicationManagerImpl.java:364)

                                     at oracle.security.jps.internal.policystore.ldap.StoreManager.getApplicationJavaPolicyEntries(StoreManager.java:623)

                                     at oracle.security.jps.internal.policystore.ldap.StoreManager.getPolicyStoreEntry(StoreManager.java:502)

                                     at oracle.security.jps.internal.policystore.ldap.LdapPolicyStore.initial(LdapPolicyStore.java:617)

                                     at oracle.security.jps.internal.policystore.ldap.LdapPolicyStore.start(LdapPolicyStore.java:2349)

                                     at oracle.security.opss.internal.runtime.ServiceContextImpl.start(ServiceContextImpl.java:220)

                                     at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createDefaultContext(ServiceContextManagerImpl.java:325)

                                     at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.initialize(ServiceContextManagerImpl.java:242)

                                     at oracle.security.jps.internal.config.OpssCommonStartup$1.run(OpssCommonStartup.java:156)

                                     at java.security.AccessController.doPrivileged(Native Method)

                                     at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:140)

                                     ... 67 more

                      Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException

                      Internal Exception: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

                      ORA-01031: insufficient privileges

                      ORA-06512: at "SYS.DBMS_SESSION", line 122

                      ORA-06512: at "STARUSER.SECPAC", line 18

                      ORA-06512: at "STARUSER.SECPAC", line 36

                      ORA-06512: at "STARUSER.SECPAC", line 53

                      ORA-06512: at line 2

                       

                      Error Code: 604

                                     at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)

                                     at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)

                                     at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)

                                     at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

                                     at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)

                                     at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:760)

                                     at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:265)

                                     at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:731)

                                     at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)

                                     at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)

                                     at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)

                                     at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)

                                     at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.existsTable(JpsDBDataManager.java:1658)

                                     ... 86 more

                      Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

                      • 23. Re: OBIEE 12C Post Installation Issue
                        Gianni Ceresa

                        3423029 : you better start your own thread instead of posting in a 4 months old one which is marked as answered ...

                         

                        PS: have a look at How to Ask Questions in Developer Community Spaces , there are other important information you maybe want to post before tons of log files output.

                        1 2 Previous Next