How to change database from MYSQL to Oracle11g in Eventsubsystems?

Hi,

We have installed Teamsite 7.2 version on Linux box.
At the time of installation we had selected mysql as our database but now client wants to use Oracle as the database and he wants to log every event in the database itself.

We have changed the file /iw-home/ApplicationContainer/server/default/deploy/activemq-ear-5.3.0.ear/activemqra.
rar/broker-config.xml where we have given the details of oracle database as given below:

url => jdbc Smiley Surprised

racle:thin:@xx.****.x.****:1521:TESTSERV
username => test
password => test

The above entries are made under bean ess-ds. Rest everything left unchanged.

Then ran iwreset -a

I have few queries regarding the same:

1) I am not able to see any tables in my database, do I need to create manually?
2) What else do I need to do to log the events in DB?
3) The same broker-config.xml is also present under /usr/iw-home/TeamSite/eventsubsystem/conf/ , do I need to make the changes here too?

Please provide some pointers.

Thanks.

Find more posts tagged with

Comments

Migrateduser

During TeamSite installation, the installer will automatically create the required tables and stores the configuration information in DB.

I'm not sure if there are any post-installation DB scripts shipped with TeamSite, for recreating tables and other DB structure. My suggestion is to go for re-installation with new DB.

Did you check with Autonomy support?

tech17

During TeamSite installation, the installer will automatically create the required tables and stores the configuration information in DB.

I'm not sure if there are any post-installation DB scripts shipped with TeamSite, for recreating tables and other DB structure. My suggestion is to go for re-installation with new DB.

Did you check with Autonomy support?

One DB script is available to create tables but that too is compatible with MYSQL i.e. mssql_2008_activemq_msgs.sql.

Also I doubt, to change the DB we need to reinstall the Teamsite, there must be some way to make the changes post installation.

Also, I didn't find ojdbc.jar there, do we need to place this jar explicitly and where?

Thanks.

Migrateduser

ojdbc.jar is the driver file for Oracle, you should use mysql-connector-java-5.x.x-bin.jar for MySQL.

Pie Chart HTML5.rptdesign

tech17

ojdbc.jar is the driver file for Oracle, you should use mysql-connector-java-5.x.x-bin.jar for MySQL.

Yes, I know that this is for Oracle.
But, this is what I want to achieve, I want to change DB from MYSQL to Oracle.

Thanks.

santosh013

Yes, I know that this is for Oracle.
But, this is what I want to achieve, I want to change DB from MYSQL to Oracle.

Thanks.

Hi,
When you say that We have just installed TS then I can assume that no work has been started as of now.
Go for a uninstall/fresh Install as it is always wise.
I hope it will hardly take 2 hours and you will be sure of everything.

Thanks.

Migrateduser

During TeamSite installation, the installer will automatically create the required tables and stores the configuration information in DB.

I'm not sure if there are any post-installation DB scripts shipped with TeamSite, for recreating tables and other DB structure. My suggestion is to go for re-installation with new DB.

Did you check with Autonomy support?

My suggestion is similar to manz, except that you setup another new TeamSite system (not re-installation) and install 7.2 from scratch. When it asks you about your database, select Oracle and enter in the correct info. After your install is complete, shut down the new instance and start up your original server with it pointing to the oracle database. (Note: I have never tried this, so this may or may not work, but then again it might.) You might also have to look into some of the tables and copy over the data.

A fresh install from scratch, as previously mentioned by others, really is the best (and supported) way to go.

tech17

Thanks everyone.. but I am done with lots of other activities after installation which includes the migration of content stores, user/groups/roles creation etc.
So it is not possible for me to reinstall the product from scratch.

Moreover, I have managed to build the connectivity between the Teamsite and Oracle 11g post Teamsite installation. The encrypted password for database was the root cause of the problem.

But, now I want to confirm few more things:

1) I can see 3 tables ACTIVEMQ_ACKS, ACTIVEMQ_LOCK, ACTIVEMQ_MSGS which were created automatically after iwreset CLT. Do I need to create any other table manually?

2) I want to log all the events/messages which are currently logging under iwevents.log which is not happening. Can someone tell me the resolution?

FYI, I am not using RC and search. We just want to log the events in DB.

Thanks.