<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1>I’m trying to migrate my Oracle database to PostgreSQL and have failed to do so after 2 tries. Our version of Oracle is ‘Oracle Database 10g Release 10.2.0.1.0 - 64bit Production’. Server version: CentOS 5.7<o:p></o:p><o:p> </o:p>I’ve been following the instructions from here: <a href="https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle">https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle</a><o:p></o:p><o:p> </o:p>The output of the ‘spacewalk-dump-schema’ command is:<o:p></o:p>[root@vacslp01spacewalk 11.2]# spacewalk-dump-schema --db=spacewal --user=spacewalk --password=<password> > /tmp/spacewalk-oracle.dump<o:p></o:p>DBD::Oracle::st fetchrow_arrayref failed: ERROR fetching field 2 of 4. LOB value truncated from 30412298 to 10000000. DBI attribute LongReadLen too small and/or LongTruncOk not set [for Statement "select * from rhnactionconfigrevisionresult"] at /usr/bin/spacewalk-dump-schema line 130.<o:p></o:p>DBD::Oracle::st fetchrow_arrayref failed: ERROR fetching field 2 of 4. LOB value truncated from 30412298 to 10000000. DBI attribute LongReadLen too small and/or LongTruncOk not set [for Statement "select * from rhnactionconfigrevisionresult"] at /usr/bin/spacewalk-dump-schema line 130.<o:p></o:p><o:p> </o:p>After capturing a dump of the oracle database, I continued despite the above errors. I install and configure the postgresql server as directed. <o:p></o:p>Here’s a list of the postgresql packages installed:<o:p></o:p><o:p> </o:p>[root@vacslp01spacewalk db_1]# rpm -qa|grep postgres<o:p></o:p>postgresql84-libs-8.4.9-1.el5_7.1<o:p></o:p>postgresql-jdbc-8.1.407-1jpp.4<o:p></o:p>postgresql84-server-8.4.9-1.el5_7.1<o:p></o:p>postgresql-libs-8.1.23-1.el5_7.2<o:p></o:p>postgresql84-8.4.9-1.el5_7.1<o:p></o:p><o:p> </o:p>Populating the postgreSQL db didn’t produce any errors. After completing all the steps in the above mentioned wiki page, I went on and followed the instructions in <a href="https://fedorahosted.org/spacewalk/wiki/HowToUpgrade#UpgradeofSpacewalkconfiguration">https://fedorahosted.org/spacewalk/wiki/HowToUpgrade#UpgradeofSpacewalkconfiguration</a><o:p></o:p><o:p> </o:p>The ‘spacewalk-setup --disconnected –upgrade’ command generated the following errors:<o:p></o:p><o:p> </o:p>[root@vacslp01spacewalk data]# spacewalk-setup --disconnected --upgrade<o:p></o:p>** Database: Setting up database connection for PostgreSQL backend.<o:p></o:p>Hostname (leave empty for local)? <o:p></o:p>Database? spacewalk<o:p></o:p>Username? spacewalk<o:p></o:p>Password? <o:p></o:p>** Database: Populating database.<o:p></o:p>** Database: Skipping database population.<o:p></o:p>* Setting up users and groups.<o:p></o:p>** GPG: Initializing GPG and importing key.<o:p></o:p>You must enter an email address.<o:p></o:p>Admin Email Address? unixadmins@central1.com<o:p></o:p>* Performing initial configuration.<o:p></o:p>* Activating Spacewalk.<o:p></o:p>** Certificate not activated.<o:p></o:p>** Upgrade process requires the certificate to be activated after the schema is upgraded.<o:p></o:p>* Enabling Monitoring.<o:p></o:p>* Configuring apache SSL virtual host.<o:p></o:p>Should setup configure apache's default ssl server for you (saves original ssl.conf) [Y]? <o:p></o:p>* Configuring tomcat.<o:p></o:p>Reversed (or previously applied) patch detected! Skipping patch.<o:p></o:p>1 out of 1 hunk ignored -- saving rejects to file web.xml.rej<o:p></o:p>* Configuring jabberd.<o:p></o:p>* Creating SSL certificates.<o:p></o:p>** Skipping SSL certificate generation.<o:p></o:p>* Deploying configuration files.<o:p></o:p>* Update configuration in database.<o:p></o:p>DBD::Pg::st execute failed: ERROR: null value in column "category_id" violates not-null constraint<o:p></o:p>Issuing rollback() for database handle being DESTROY'd without explicit disconnect().<o:p></o:p><o:p> </o:p>At this point, I’m stuck. Tomcat generates tonnes of exceptions. Nothing really works. That’s what I’d expect since the ‘spacewalk-setup’ command doesn’t finish.<o:p></o:p><o:p> </o:p>Any help would be greatly appreciated.<o:p></o:p></div></body></html>