Home / user-5751

Autobyte's questions

Martin Hope
Autobyte
Asked: 2012-02-17 05:26:34 +0800 CST
  • 0

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime much more than about 4-6 hours maybe a little more but not much.

Source: Linux SuSE 11 64 Bits - DB2 9.7 Target: Linux Redhat 64 Bits - Oracle 11G

Thanks for any help..

linux oracle oracle-11g db2
Martin Hope
Autobyte
Asked: 2010-05-20 02:50:25 +0800 CST
  • 1

I have two SLES 11 servers that are SAN attached to a Clarion CX-340. The SAN partition has been formatted with ocfs2 and I have both machines setup in a cluster and the cluster is running (all appears to be normal). I have a small java application as a locking test and when I run the application on both machines at the same time, I should get the lock on one server and the other should refuse the lock since the first already holds a lock on that file but in this case both servers get a lock on the same file.

Basically my cluster.conf looks like this:

      node:
              ip_port = 7777
              ip_address = 192.168.10.121
              number = 1
              name = osrsles10node1
              cluster = osrsles10
      node:
              ip_port = 7777
              ip_address = 192.168.10.122
              number = 2
              name = osrsles10node2
              cluster = osrsles10
      cluster:
              node_count = 2
              name = osrsles10

Please ask for any other info - I really need these locks to be exclusive to each server.

Thanks.

cluster ocfs2 sles11