[Spacewalk-list] Spacewalk Client Registration problem

[Pradeep Kilambi]

On 08/19/2009 01:08 AM, cheerla sreehari wrote:
> Hi ,
>
> I could see the following error messages in error_log .
> Exception reported from srm-srv-r3vm7.labs.blr.novell.com 
> <http://srm-srv-r3vm7.labs.blr.novell.com>
> Time: Wed Aug 19 05:50:27 2009
> Exception type server.rhnSQL.sql_base.SQLConnectError
> Request object information:
> URI: /XMLRPC
> Remote Host: 164.99.98.58
> Server Name: SRM-SRV-R3vm7.labs.blr.novell.com:0 
> <http://SRM-SRV-R3vm7.labs.blr.novell.com:0>
> Headers passed in:
>         Accept-Encoding: identity
>         Content-Length: 122
>         Host: srm-srv-r3vm7.labs.blr.novell.com 
> <http://srm-srv-r3vm7.labs.blr.novell.com>
>         content-type: text/xml
>         user-agent: rhn.rpclib.py/$Revision$ 
> <http://rhn.rpclib.py/$Revision$>
>         x-client-version: 1
>         x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
>         x-rhn-client-capability: 
> packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(1)=1,reboot.reboot(1)=1,packages.verif
> y(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
>         x-rhn-transport-capability: follow-redirects=3
>         x-transport-info: Extended Capabilities Transport (C) Red Hat, 
> Inc (version $Revision$)
>         x-up2date-version: 0.6.2-1.el5
>
> Exception Handler Information
> Traceback (most recent call last):
>   File "/usr/share/rhn/server/apacheHandler.py", line 72, in 
> headerParserHandler
>     rhnSQL.initDB()
>   File "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB
>     __init__DB(backend, host, port, username, password, database)
>   File "/usr/share/rhn/server/rhnSQL/__init__.py", line 59, in __init__DB
>     __DB.check_connection()
>   File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 490, 
> in check_connection
>     self.connect() # only allow one try
>   File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 386, 
> in connect
>     raise apply(sql_base.SQLConnectError, err_args)
> SQLConnectError: (12519, 'ORA-12519: TNS:no appropriate service 
> handler found\n', 'XE', 'Connection_Connect(): server attach')
>
> RHN 3468 2009/08/20 00:12:44 +05:30: ("DATABASE CONNECTION TO 'XE' 
> LOST", "Exception information: 'NoneType' object has no attribute 'curso
> r'")
> RHN 3468 2009/08/20 00:12:44 +05:30: ('Connection attempt failed', 
> 12519, 'ORA-12519: TNS:no appropriate service handler found\n')
> RHN 3460 2009/08/20 00:12:49 +05:30: ('Connection attempt failed', 
> 12519, 'ORA-12519: TNS:no appropriate service handler found\n')
>
>


hrm looks like apache is unable to acquire connection to your underlying 
database. You might wanna double check your db install setup again. Are 
you able to connect to your spacewalk db manually(through sqlplus i mean)?


>
> Thanks for the help .
>
> Regards,
> SreeHari Ch
>

-- 
--
Pradeep Kilambi
Senior Software Engineer
RHN Satellite Engineering
Phone: +1 919 754 4285
RHCE # 805008680430554


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090819/6f4b1b01/attachment.htm>