Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
When I try to access http://myservername:9502/analytics I receive "This site can't be reached".

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
Answers
-
Is OBIEE running?
0 -
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
0 -
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?
0 -
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
0 -
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 ...
0 -
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>
0 -
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
0 -
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
0 -
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?
0 -
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.
0