[Spacewalk-list] Spacewalk in Oracle RAC

[Velayutham, Prakash]

On Oct 24, 2012, at 2:31 AM, Michael Mraka wrote:

> Velayutham, Prakash wrote:
> % Hi,
> % 
> % Recently, our Oracle RAC has had 2 unexpected downtimes in the past 2 weeks, affecting just one node in the cluster. How do I configure Spacewalk properly so such an outage does not affect its operation?
> % 
> % Here is what I have currently.
> % 
> % db_backend = oracle
> % db_user = xxxx
> % db_password = yyyy
> % db_name = //hostname/schema
> % db_host = hostname
> % db_port = 
> % 
> % My /etc/tnsnames.ora is what the Oracle DBA gave with the correct listener configuration.
> 
> Hi Prakash,
> 
> It's fairly easy, just
> - create /etc/tnsnames.ora - this has been already done by your DBA,
> - in /etc/rhn/rhn.conf set
>    db_name = <THAT_RAC_TNSNAMES_ENTRY_NAME>
>  and leave db_host and db_port empty.
> 
> 
> Regards,
> 
> --
> Michael Mráka
> Satellite Engineering, Red Hat
> 

Hi,

Thanks for the advice. Once I did that, Spacewalk itself restarted just fine.

[root at bmispacewalkp1 etc]# spacewalk-service restart
Shutting down spacewalk services...
Stopping RHN Taskomatic...
Stopped RHN Taskomatic.
Stopping cobbler daemon:                                   [  OK  ]
Stopping rhn-search...
Stopped rhn-search.
Stopping MonitoringScout ...  
[ OK ]
Stopping Monitoring ...  
[ OK ]
Stopping httpd:                                            [  OK  ]
Stopping tomcat6:                                          [  OK  ]
Shutting down osa-dispatcher:                              [  OK  ]
Terminating jabberd processes ...
Stopping router:                                           [  OK  ]
Stopping sm:                                               [  OK  ]
Stopping c2s:                                              [  OK  ]
Stopping s2s:                                              [  OK  ]
Done.
Starting spacewalk services...
Initializing jabberd processes ...
Starting router:                                           [  OK  ]
Starting sm:                                               [  OK  ]
Starting c2s:                                              [  OK  ]
Starting s2s:                                              [  OK  ]
Starting osa-dispatcher:                                   [  OK  ]
Starting tomcat6:                                          [  OK  ]
Waiting for tomcat to be ready ...
Starting httpd:                                            [  OK  ]
Starting Monitoring ...  
[ OK ]
Starting MonitoringScout ...  
[ OK ]
Starting rhn-search...
Starting cobbler daemon:                                   [  OK  ]
Starting RHN Taskomatic...
Done.
[root at bmispacewalkp1 etc]#

 However, clients are not communicating with the server and give the following error.

[root at bmiagraphp1 ~]# rhn_check -v -v
XMLRPC ProtocolError: <ProtocolError for bmispacewalkp1.chmcres.cchmc.org /XMLRPC: 500 Internal Server Error>
[root at bmiagraphp1 ~]# yum check-update
Loaded plugins: fastestmirror, rhnplugin
There was an error communicating with RHN.
RHN Satellite or RHN Classic support will be disabled.
Error communicating with server. The message was:
Internal Server Error
Loading mirror speeds from cached hostfile
[root at bmiagraphp1 ~]#

Any idea?

Thanks,
Prakash