Server on <serverhostname>has entered an unstable state, please contact your site administrator. ORA-12514 Connection refused, the specified service name <tnsname> was not recognized by the Oracle server.

Document ID:KM00768045
Creation Date:21-Feb-2014
Modified Date:21-Feb-2014
- Micro Focus Products:
  quality center 11.00

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Server on has entered an unstable state, please contact your site administrator. The issue is caused due to any of the ALM configuration parameters being modified on the database server by the DBA. To resolve this issue, one needs to restart the Oracle Service first and then restart the ALM service.

Error

One may encounter the following error while accessing ALM in the server machine using Internet Explorer:

Server on <serverhostname> has entered an unstable state, please contact your site administrator.

status=MUTED, label=QC server is muted due to unrecoverable error,
StackTrace=
java.sql.SQLNonTransientConnectionException: [Mercury][Oracle JDBC Driver][Oracle]ORA-12514 Connection refused, the specified service name <tnsname> was not recognized by the Oracle server.
at com.mercury.jdbc.oraclebase.dda4.b(Unknown Source)
at com.mercury.jdbc.oraclebase.dda4.a(Unknown Source)
at com.mercury.jdbc.oraclebase.dda3.b(Unknown Source)
at com.mercury.jdbc.oraclebase.dda3.a(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.a(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.ab(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.a(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.t(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.i(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
wrapped in com.mercury.optane.core.CTdException:
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:88)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:822)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:612)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:379)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:239)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:212)
at com.mercury.optane.core.db.CAbsStatement.<init>(CAbsStatement.java:91)
at com.mercury.optane.core.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:98)
at com.mercury.optane.core.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:94)
at com.mercury.optane.core.db.spring.JDBCTemplate$AbstractPreparedStatementCreator.create(JDBCTemplate.java:1220)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:1040)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:897)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:882)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:790)
at com.mercury.optane.core.directory.CAbsDirectory.setCacheOverrides(CAbsDirectory.java:223)
at com.mercury.optane.core.directory.CAbsDirectory.init(CAbsDirectory.java:175)
at com.mercury.td.init.InitServlet.init(InitServlet.java:118)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1048)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:950)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4122)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4421)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)

ENvIRONMENT : Application Lifecycle Management Performance Center Edition 11.00

Cause

The issue is caused due to any of the ALM configuration parameters being modified on the database server by the DBA.

Fix

To resolve this issue, one needs to restart the Oracle Service first and then restart the ALM service.