Thanks for the help Jan, I increased the LongReadLen value. That fixed the initial problem. I am still left with another error:
[root@vacslp01spacewalk db_1]# spacewalk-dump-schema --db=spacewal --user=spacewalk --password=spacewalk > /tmp/oracle-dump.sql Malformed UTF-8 character (fatal) at /usr/bin/spacewalk-dump-schema line 121. Any suggestions on this one?? --james -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jan Pazdziora Sent: Monday, November 21, 2011 7:55 AM To: [email protected] Subject: Re: [Spacewalk-list] Please help with Oracle to PostgreSQL migration On Thu, Nov 17, 2011 at 03:18:28PM -0800, James Fillman wrote: > 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 > > I've been following the instructions from here: > https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle > > The output of the 'spacewalk-dump-schema' command is: > [root@vacslp01spacewalk 11.2]# spacewalk-dump-schema --db=spacewal > --user=spacewalk --password=<password> > /tmp/spacewalk-oracle.dump > 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. > 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. > > After capturing a dump of the oracle database, I continued despite the above > errors. I install and configure the postgresql server as directed. You should not proceed in spite of the errors. Your dump is incomplete. You might want to modify the spacewalk-dump-schema script and increase that LongReadLen => 10_000_000, value to something bigger, for the error to go away. Make sure there are no error upon the schema dump. -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ 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
