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

Tue Jun 22 06:57:15 UTC 2010

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:

default_db = spacewalk/spacewalk at orcl

db_backend = oracle
db_user = spacewalk
db_password = XXXXXX
db_name = orcl
db_host = localhost
db_port = 1521

server.nls_lang = english.AL32UTF8

hibernate.dialect=org.hibernate.dialect.Oracle9iDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.username=spacewalk
hibernate.connection.password=XXXXXX
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:orcl

and in cluster.conf they're:

LocalConfig.0.dbd=Oracle
LocalConfig.0.dbname=orcl
LocalConfig.0.orahome=/opt/oracle
LocalConfig.0.username=spacewalk
LocalConfig.0.password=XXXXXX

I'm not sure why the XMLRPC stuff is failing but the main web interface is fine.  Presumably they're each using something different to resolve the SID?

Anyone got any suggestions?

Thanks.

Matt

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Mike Hanby
Sent: Thursday, 29 April 2010 2:40 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Change from Oracle XE to 11gR2

I finally got around to migrating from Oracle XE to Oracle 11gR2. The operation was a success. Along the way I got to familiarize myself with Oracle again, I hadn't done much with Oracle since 2000.

Here are my notes in case they help others on the list:
http://flakrat.blogspot.com/2010/04/migrate-red-hat-spacewalk-server-from.html

Mike

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Santi Saez
Sent: Thursday, March 25, 2010 11:19 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Change from Oracle XE to 11gR2

El 23/03/10 9:42, Michael Mraka escribió:

> % I have a Spacewalk 0.7 server that has just hit the 4GB Oracle XE barrier. We have a license for Oracle 11gR2 that I can use for this server.
> %
> % Is it possible to do a migration? Something like stop Spacewalk, dump the database in XE, Uninstall XE, Install 11gR2 and import, start Spacewalk?

> http://www.mail-archive.com/spacewalk-list@redhat.com/msg03837.html

Hi! I started this thread a month ago to migrate XE to Oracle SE1.

I have changed /etc/tnsnames.ora to point to the new Oracle server IP 
and we get this traceback:

	http://pastebin.com/vxswfvsL

Also I tried changing "db_host" in /etc/rhn/rhn.conf, but I get same error.

Using sqlplus I connect without problems to the new Oracle server.

When we try to logging into Spacewalk web interface (rhn/Login.do) we 
get this traceback error:

	http://pastebin.com/U0ZpkzQR

What can I do to solve this? thanks!

Regards,

-- 
Santi Saez
http://woop.es

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
++++++++++++++++++++++++++++++++++++++++++++++++ 
The information contained in this communication is strictly confidential and intended solely for the use of the intended recipient(s). The copyright in this communication belongs to ITG Australia Ltd, ITG Hong Kong Limited, ITG Singapore Pte Ltd and/or their related entities, including Investment Technology Group, Inc., (collectively referred to as ?ITG") and may contain information that is private, confidential or subject to legal professional or other privilege. No confidentiality or privilege is waived or lost by any mis-transmission of this email. 

Access to this email by anyone other than the intended recipient is unauthorized and further distribution of this email is strictly prohibited without the permission of ITG. If you are not the intended recipient of this email, any review, disclosure, copying, distribution, retention or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient of this email, you should not disseminate, distribute or copy this e-mail and you should delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. ITG and/or its affiliates reserve the right to monitor and archive all electronic communications through its/their network. 

The information contained in this email is believed to be accurate at the time of publication. However, ITG disclaims all responsibility for any loss or damage howsoever arising as a result of any person or entity acting upon the information contained in this email and no liability will be accepted by ITG for any such loss or damage. Any views expressed in this email are those of the individual sender, except where the email states otherwise and the sender is authorized to state them to be the views of ITG. 
++++++++++++++++++++++++++++++++++++++++++++++++