Hello, <br>I recently tried to
update a managed config file on my
spacewalk server. Immediately after updating the config file the web
gui became a blank page. I tried restart the httpd service but no
luck. I tried looking through the log files. In
/var/log/httpd/error_log I found: <br>
<br>Exception Handler Information<br>Traceback (most recent call last):<br>
File "/usr/share/rhn/server/<div>apacheHandler.py", line 72, in
headerParserHandler<br> rhnSQL.initDB()<br> File
"/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB<br>
__init__DB(backend, host, port, username, password, database)<br>
File "/usr/share/rhn/server/rhnSQL/__init__.py", line 59, in
__init__DB<br> __DB.check_connection()<br> File
"/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 490, in
check_connection<br>
self.connect() # only allow one try<br> File
"/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 386, in
connect<br> raise apply(sql_base.SQLConnectError, err_args)<br>SQLConnectError:
(12505, 'ORA-12505: TNS:listener does not currently know of SID given
in connect descriptor\n', 'XE', 'Connection_Connect(): server attach')<br>
<br>Then I ran lsnrctl services:<br><br>LSNRCTL for Linux: Version
10.2.0.1.0 - Production on 23-APR-2010 14:50:34<br><br>Copyright (c)
1991, 2005, Oracle. All rights reserved.<br><br>Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))<br>
Services Summary...<br>Service "PLSExtProc" has 1 instance(s).<br>
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...<br> Handler(s):<br> "DEDICATED" established:0
refused:0<br>
LOCAL SERVER<br>Service "XE" has 1 instance(s).<br> Instance
"XE", status READY, has 1 handler(s) for this service...<br>
Handler(s):<br> "DEDICATED" established:109 refused:0 state:ready<br>
LOCAL SERVER<br>Service "XEXDB" has 1 instance(s).<br>
Instance "XE", status READY, has 1 handler(s) for this service...<br>
Handler(s):<br> "D000" established:0 refused:0 current:0 max:972
state:ready<br>
DISPATCHER <machine: <a href="http://spacewalk.chapman.edu/" target="_blank">spacewalk.chapman.edu</a>, pid: 17815><br>
(ADDRESS=(PROTOCOL=tcp)(HOST=<a href="http://spacewalk.chapman.edu/" target="_blank">spacewalk.chapman.edu</a>)(PORT=37104))<br>
Service "XE_XPT" has 1 instance(s).<br> Instance "XE", status READY,
has 1 handler(s) for this service...<br> Handler(s):<br>
"DEDICATED" established:109 refused:0 state:ready<br> LOCAL
SERVER<br>
The command completed successfully<br><br>PLSExtProc status is UNKNOWN
but I looked at listener.ora and tnsnames.ora it seems to be configured
properly. Does the status UNKNOWN really matter if it doesnt have any
refused connections? <br><br>In /var/log/tomcat5/catalina.out had this
error in:<br><br>SEVERE: Exception Processing ErrorPage[errorCode=500,
location=/WEB-INF/pages/co
mmon/errors/500.jsp]<br>
javax.servlet.ServletException: javax.servlet.ServletException:
javax.servlet.js
p.JspException: Error writing to JSP file:<br> at
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageC
ontextImpl.java:846)<br>
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageCon
textImpl.java:779)<br> at org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(U
nknown Source)<br>
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)<br> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:691)<br>
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:471)<br> at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:403)<br>
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:301)<br> at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.j
ava:364)<br>
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.j
ava:285)<br> at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValv
e.java:229)<br>
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:135)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)<br>
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)<br>
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<br>
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<br>
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<br>
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.ja
va:704)<br> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSock
et.java:897)<br>
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)<br> at java.lang.Thread.run(Thread.java:636)<br>
<br><br><br>I am not sure whats exactly making my spacewalk
web gui to only show up as a blank page. Spacewalk just goes to
rhn/login.do but its a blank page. The log files also show Apache
configured -- resuming normal operation. Has anyone ever seen this? <br>
<br>Thanks for your time,<br><font color="#888888">Robert </font></div>