Migrating Connections DB from Oracle to DB2 part 3
In part 3 of the series we will actually attempt to migrate the data. Migrating Connections DB from Oracle to DB2 In my experience the database migration is always most time consuming, so I always do the database first Use the text file of Commands that we created in part 2. Back up the […]
Migrating Connections DB from Oracle to DB2 part 2
In part 2 of this series we will cover preparing the system and the commands and files required. There is a fair bit of file creation to do and configuring of the Database Transfer Tool (DBT) Migrating Connections DB from Oracle to DB2 Step 3 – Prepare a system to recieve the data As […]
Migrating Connections DB from Oracle to DB2 part 1
For those of you that follow me on twitter, you will have noticed that I have posted a number of tweets relating to a fun project I am working on. I have been working with a customer to move them from Connections 5 to Connections 5.5 – Not a massive issue – EXCEPT they are […]
Issues with Oracle with Connections 2.5 RESOLUTION
as posted by me on the Connections Blog earlier today : IBM have now released new trigger code to resolve this issue. The steps are simple * Stop the application * Backup the DB * Run through the code to remove the Trigger * Recreate the Trigger * Start the primary server and test * […]
Issues with Oracle on Solaris with Connections 2.5 UPDATE
As I posted on the Connections Blog earlier today … At last it appears there may be a *real* fix for this .. IBM have changed the trigger code which should hopefully fix the mutating trigger issue we see when deleting files .. I will be testing this today and if it works rolling it […]
Issues with Oracle on Solaris with Connections 2.5 – UPDATE
After some testing with the SPARC version of this fix – which actually did work we were pleased to find out that Oracle had released a version for x86. We applied this – this morning, and I am sorry to say it doesn’t work. If you try to delete a file from the DB directly […]
Issues with Oracle on Solaris with Connections 2.5
There is an issue when running Connections with Oracle on Solaris Symptoms of the problem are you can not delete certain files and / or the files widget from communities The error in the logs is – table FILES.MEDIA is mutating 08/02/10 00:01:00:569 GMT] 0000005d Library E EJPVJ9166E: Unable to delete the library with id […]
Futher to the Portal 6.1.5 set up
Futher to the Portal 6.1.5 set up – these steps were required from an ORACLE DB point of view to get the DB configured : Grant create session to community Create likeminds user Grant create table to community Grant create view to jcr Grant unlimited tablespace to community and also these grant select on sys.dba_pending_transactions […]