[Spacewalk-list] Change from Oracle XE to 11gR2

[Jan Pazdziora]

On Tue, Jun 22, 2010 at 04:57:15PM +1000, McLeod, Matt wrote:
> I just tried this process today -- your notes were quite helpful.
> 
> I've got things to the point where the web interface seems to be working OK, but the rhn clients aren't.  Any time a client connects (e.g., if I run "yum check-update" I get the following in rhn_server_xmlrpc.log:
> 
> 2010/06/22 16:42:46 +11:00 13611 10.144.0.17: rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'orcl')
> 2010/06/22 16:42:46 +11:00 13611 10.144.0.17: rhnSQL/driver_cx_Oracle.connect('ERROR', 'Connection attempt failed', 12154, 'ORA-12154: TNS:could not resolve the connect identifier specified\n')
> 
> /etc/tnsnames.ora and /opt/oracle/112/network/admin/tnsnames.ora are correct.  The database-related entries in rhn.conf are:
> 

Am I correct in assuming that the .do pages of the WebUI are working
fine but that if you go to

	https://FQDN/network/systems/ssm/index.pxt

it will fail as well?

What are the permissions on /etc/tnsnames.ora?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat