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/spacew...@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: [email protected]
[mailto:[email protected]] On Behalf Of Mike Hanby
Sent: Thursday, 29 April 2010 2:40 AM
To: [email protected]
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: [email protected]
[mailto:[email protected]] On Behalf Of Santi Saez
Sent: Thursday, March 25, 2010 11:19 AM
To: [email protected]
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/[email protected]/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
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
++++++++++++++++++++++++++++++++++++++++++++++++
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.
++++++++++++++++++++++++++++++++++++++++++++++++
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
