[Building Sakai] Need suggesstion while upgrading sakai database from oracle 9i 32bit to 11g 64bit

[Joshua Swink]

We ran into a problem that could possibly concern you; if you are using the
Oracle data pump to transfer the DB content, you might be at risk for data
corruption in tables using data type XML LONG. On the other hand, if you
are upgrading without using any kind of data pump, this risk doesn't apply.
(I am not a DBA, and I'm just repeating some terms that our DBA used when
we discussed our problem.)

What the data pump did was to convert UTF-8 character data to Oracle's
proprietary CESU-8 encoding. Efforts to reverse this conversion were not
successful and we had to restore the values from a backup.

The affected tables were ASSIGNMENT_SUBMISSION, CALENDAR_EVENT, and
CONTENT_RESOURCE_DELETE.

For us, the problem presented itself as old student assignment submissions
no longer appearing in a Spanish course. This is because the accented
characters were encoded differently in these two encodings, which had two
possible effects: 1) The XML document could be invalid, or 2) The filenames
of attachments would no longer match what was recorded in the resources
table. When attempting to view these assignments in the Assignments tool,
the log had entries like:

2011-07-25 09:12:11,032 WARN TP-Processor9
org.sakaiproject.assignment.tool.AssignmentAction -
org.sakaiproject.assignment.tool.AssignmentAction at 41ede8c1:sizeResources
null userId = df90b1ef-fd22-462a-9bfb-705c1618aa4c

Our fix involved writing a Python script to transfer the values from our
backup database into the new database - in essence, a data pump written
specifically to get around this problem. In the unlikely event that you
encounter the same problem I'd be glad to supply this script to you.

Josh


On Sat, Feb 23, 2013 at 2:41 AM, Jehan Badshah <jehan.badshah at nu.edu.pk>wrote:

> Dear All
>
> We are using  sakai 2.8.2 with oracle 9i 32bit version.
>
> Is it safe to upgrade oracle database to 11G 64 bit ?,
> is there is any risk involved while upgrading it?
>
> did any one faced issue in any tool after upgradation, we are extensively
> using semigo tool for online exams.
>
>
>
> Regards
> ----------------------------------------------------
> Jehan Badshah | Team Lead
> Sakai Learning and Teaching Environment (SLATE)
> URL: http://slate.nu.edu.pk,
> National University of Computer and Emerging Sciences
> UAN: +92 (0) 51 - 111 128 128 ext 344
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130226/35e46d76/attachment.html