Mysql – Database Link from Oracle 10g on Windows over to MySQL database

In Oracle Grid Control you can make a global view of your entire enterprise. This is an advantage above DB Control. It is slightly easier to authorize employees for certain targets in Grid Control. If your mail gateway changes, you have the advantage of only one location to change. When making clones, Grid Control has the advantage of not having repository parts in the target databases.

On the other hand, DB Control is closer to the database and most of the times better support for new features. Oracle Grid Control Requires quite some resources to run and in many cases at least one dedicated dba to keep it running. You have no single point of failure for management. Oracle DB Control is very easy to setup. With a little smart thinking you can build a central page with links to all DB Consoles that you want, complete with links to the documentation. Grid Control easily gets mixed up when making clones, even without a local repository in the target.

I think it is a personal choice. At the moment, after having wrestled with many GC installations, I think having an own repository for historic data and links to Oracle DB Consoles is not a bad idea.

You have to initiate the duplicate from the target database to be able to connect to the not mounted target database. I suggest you to downgrade the oracle version on the 64 bit machine. The easiest way to do this will be to install 11.1.0.6.0 version on the 64-bit server into a separate oracle home and perform the duplicate. You can upgrade the database after duplicate and switch it to the 11.1.0.7.0 home.

The error you are getting on the 32-bit database seems to be a connection problem to the database. The target instance is not mounted and you cannot connect to is via SQLnet.

When performing the duplicate form 64 bit system, please make sure that you are using username/password in the connection string to the target database and not the system authentication.

Best regards, Yuri