[Spacewalk-list] Please help with Oracle to PostgreSQL migration

[James Fillman]

Thanks for the help Jan,

I increased the LongReadLen value. That fixed the initial problem. I am still left with another error:

[root at 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: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Monday, November 21, 2011 7:55 AM
To: spacewalk-list at redhat.com
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 at 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
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list