Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

When I try to access http://myservername:9502/analytics I receive "This site can't be reached".

Received Response
671
Views
17
Comments

Have this same issue with BI Publisher, Fusion Middleware, and Weblogic Console.  It worked after the install, but one day later it started doing this. I have made no changes in oracle or on the windows 2012 R2 server from the time it did and did not work. Very puzzling.

Thanks

«1

Answers

  • Is OBIEE running?

  • Stormbringer
    Stormbringer Rank 3 - Community Apprentice

    Hi Gianni,

    In windows services it has that the Oracle Business Intelligence service is Running. If there is another place I need to check let me know. I am just starting out with Oracle.

    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You're starting out and you're on Windows? Man...good luck, that's an awful combination.

    Anyways I never ever trust the Windows service...

    1.) Which EXACT OBIEE version are you running?

    2.) Have you tried accessing Enterprise Manager or Weblogic?

  • Stormbringer
    Stormbringer Rank 3 - Community Apprentice

    Hi Christian,

    I am starting to think you correct. I have been a windows admin for many years, but Oracle seems problematic with windows.

    12.2.1.3.0 is the OBIEE version. I can access the enterprise manager correctly, but the weblogic console gives me the same message as the analytics console does. That, This site can't be reached".

    Thanks

  • I assume, as a "old" windows admin, you make sure you don't have a Windows firewall annoying you and that the server clearly know what its name is? Do you try to access locally from the server or remotely from somewhere else in the network?

    You must have a status script next to the start & stop script, give it a run and see what it returns.

    Last but not least: check if these is still a process listening on the 9500 and 9502 ports or they are just gone ...

  • Stormbringer
    Stormbringer Rank 3 - Community Apprentice

    I had the firewall off. I can ping the server's computer name. I have not set it up with a DNS yet. I am accessing the server locally. From a netstat command the 9500 or 9502 port is not listening.  When I run a status command this what I

    get:

    C:\Users\Administrator>C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi

    \bitools\bin\status.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\..\..\u

    ser_projects\domains\bi ...

    Initializing WebLogic Scripting Tool (WLST) ...

    Welcome to WebLogic Server Administration Scripting Shell

    Type help() for help on available commands

    <Apr 20, 2018 9:58:44 AM EDT> <Info> <Security> <BEA-090905> <Disabling the Cryp

    toJ JCE Provider self-integrity check for better startup performance. To enable

    this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.

    >

    <Apr 20, 2018 9:58:44 AM EDT> <Info> <Security> <BEA-090906> <Changing the defau

    lt Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable

    this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.>

    <Apr 20, 2018 9:58:44 AM EDT> <Info> <Security> <BEA-090909> <Using the configur

    ed custom SSL Hostname Verifier implementation: weblogic.security.utils.SSLWLSHo

    stnameVerifier$NullHostnameVerifier.>

    /Servers/AdminServer/ListenPort=9500

    Accessing admin server using URL t3://ORACLEBI: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://ORAC

    LEBI:9500 : Failed to initialize JNDI context, tried 2 time or times totally, th

    e interval of each time is 0ms.

    t3://ORACLEBI:9500: Destination 10.130.14.16, 9500 unreachable.; nested exceptio

    n is:

            java.net.ConnectException: Connection refused: connect; No available rou

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

    Problem invoking WLST - Traceback (innermost last):

      File "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\sta

    tus_servers.py", line 29, in ?

      File "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\pro

    cess_control.py", line 581, in statusComponents

      File "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\pro

    cess_control.py", line 455, in outputComponentsStatus

      File "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\pro

    cess_control.py", line 243, in connectAdminServer

      File "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\pro

    cess_control.py", line 179, in requestCredentialsAndConnectToAdminServer

      File "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.sysman\scripts\pro

    cess_control.py", line 513, in getAdminServerUrl

      File "C:\Users\Administrator\AppData\Local\Temp\2\WLSTOfflineIni84585917555318

    15009.py", line 131, in readDomain

      File "C:\Users\Administrator\AppData\Local\Temp\2\WLSTOfflineIni84585917555318

    15009.py", line 19, in command

    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:21

    2)

            at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleExc

    eption(CommandExceptionHandler.java:69)

            at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(W

    LScriptContext.java:2983)

            at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptCo

    ntext.java:735)

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

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

    java:62)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.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: 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:21

    2)

    C:\Users\Administrator>

  • Ok, so because there is nothing listening on those ports and has status.cmd tell you ... Weblogic isn't running.

    Now you "just" need to find where it's gone and why

    Look at the logs of AdminServer to start to see if you see something (inside the domain you have a /servers/ folders containing a subfolder for the various servers/services, there inside you find log files).

    PS: if not too late move to linux and go directly with 12.2.1.4 , it's easier

  • Stormbringer
    Stormbringer Rank 3 - Community Apprentice

    If I continue having problems like this, I may jump to linux.  lol   Looked at the log and this is where it errors out at:  Do you know what could cause this connection issue.

    Thanks

    oracle.security.jps.JpsException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//localhost:1521/PDBORCL]

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

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

    at oracle.security.jps.JpsStartup.startWithRetry(JpsStartup.java:287)

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

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

    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:1287)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Caused by: oracle.security.jps.service.credstore.CredStoreException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//localhost:1521/PDBORCL]

    at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:191)

    at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.start(LdapCredentialStore.java:1030)

    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:166)

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

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

    ... 27 more

    Caused by: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//localhost:1521/PDBORCL]

    at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.isNewSchema(JpsDataManagerUtil.java:258)

    at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.isNewSchema(DataManagerFactoryImpl.java:252)

    at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDBDataManager(DataManagerFactoryImpl.java:319)

    at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDataManager(DataManagerFactoryImpl.java:161)

    at oracle.security.jps.internal.credstore.rdbms.CsfDbmsManager.getDataManager(CsfDbmsManager.java:95)

    at oracle.security.jps.internal.credstore.ldap.CsfStoreManager.existsStore(CsfStoreManager.java:298)

    at oracle.security.jps.internal.credstore.ldap.CsfStoreManager.completeInit(CsfStoreManager.java:177)

    at oracle.security.jps.internal.credstore.rdbms.CsfDbmsManager.<init>(CsfDbmsManager.java:91)

    at oracle.security.jps.internal.credstore.rdbms.CsfDbmsManager.createInstance(CsfDbmsManager.java:72)

    at oracle.security.jps.internal.credstore.ldap.CsfStoreManager.getInstance(CsfStoreManager.java:121)

    at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:188)

    ... 34 more

    Caused by: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//localhost:1521/PDBORCL]

    at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.getDBConnection(JpsDataManagerUtil.java:407)

    at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.isNewSchema(JpsDataManagerUtil.java:249)

    ... 44 more

    Caused by: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:442)

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:437)

    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:547)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)

    at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:520)

    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:616)

    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:833)

    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)

    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)

    at java.sql.DriverManager.getConnection(DriverManager.java:664)

    at java.sql.DriverManager.getConnection(DriverManager.java:247)

    at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.getDBConnection(JpsDataManagerUtil.java:400)

    ... 45 more

  • Nothing crossing my mind right now ....

    So you have a database installed on the same server? Is that a sandbox and so you installed everything together on the same box or something else?

    Any sign that the locally installed DB could have been unreachable at some point?

  • Stormbringer
    Stormbringer Rank 3 - Community Apprentice

    Yes, just trying to teach myself for now.  The database was unreachable at one time. But I did a uninstall of all oracle products and re-installed. Since then the database seems fine.