VMware Global Community
Alethay
Enthusiast
Enthusiast
‎04-07-2016 06:39 AM

Horizon View e Oracle RAC

Buonasera signori,

qualcuno di voi sà dirmi se Oracle RAC è compatibile con Horizon View 6.x? La matrice di compatibilità indica le versioni da rispettare ma non le modalità in cui si può configurare il database.

La richiesta nasce dal fatto che, provando a configurare l' event DB ricevo questo errore:

2016-04-07T12:51:15.274+02:00 ERROR (0CD4-1614) <ajp-nio-8009-exec-5> [ConfigurationManagerBean] ADAM Error code: 2.128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:181)

com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: database initialization failed, SQL exception when connecting to database: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

  at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1730)

  at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration(SourceFile:1605)

  at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:177)

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

  at com.vmware.vdi.admin.ui.common.ViewFlexFactory$ViewProxy.invoke(SourceFile:113)

  at com.sun.proxy.$Proxy63.updateDatabaseConfiguration(Unknown Source)

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

  at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:386)

  at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:178)

  at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1468)

  at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1044)

  at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:101)

  at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:154)

  at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:42)

  at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:63)

  at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:190)

  at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:328)

  at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:373)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:721)

  at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:466)

  at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:391)

  at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:318)

  at com.vmware.vdi.admin.ui.servlet.AMFProxyServlet.a(SourceFile:90)

  at com.vmware.vdi.admin.ui.servlet.AMFProxyServlet.doPost(SourceFile:57)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at org.apache.catalina.filters.FailedRequestFilter.doFilter(FailedRequestFilter.java:63)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at com.vmware.vdi.support.ViewAdminFilter.doFilter(SourceFile:103)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at com.vmware.vdi.admin.be.filters.CertificateAuthFilter.doFilter(SourceFile:140)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at com.vmware.vdi.admin.be.filters.DisableUrlSessionFilter.doFilter(SourceFile:73)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)

  at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844)

  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)

  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521)

  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

  at java.lang.Thread.run(Thread.java:745)

Caused by: com.vmware.vdi.dbwrapper.exceptions.DBConnectionException: SQL exception when connecting to database: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

  at com.vmware.vdi.dbwrapper.connector.AbstractJDBCConnectionFactory.getConnection(SourceFile:80)

  at com.vmware.vdi.dbwrapper.connector.JDBCConnector.getConnection(SourceFile:30)

  at com.vmware.vdi.dbwrapper.DBConnection.doConnect(SourceFile:305)

  at com.vmware.vdi.dbwrapper.DBConnection.connect(SourceFile:196)

  at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1717)

I dba mi hanno spiegato che l'errore ORA-12505 è causato dalla connessione jdbc che nel caso specifico cerca di contattare il SID del database mentre la modalità RAC usa il service name. Componenti come vcenter e view composer, che si connettono alla medesima istanza Oracle RAC ma tramite connettore odbc, funzionano correttamente.

0 Kudos
0 Replies