Control-M Server 7 Using Oracle 10g

[kylo_h]

Hi Guys,

Does anyone know if Control-M Server 7 is Oracle ASM compatible?

I don't know much about databases, so my question may even be worded incorrectly.

Thanks,
Kyle

[Zimbo]

The short answer is yes. But you can't install into a database that is ASM. You have to do the install with a physical file location, then after the install, convert to ASM.


SLN000015070826
There is no way to give a full remote path with ASM so it is not possible install to an existing Oracle 10g database that uses ASM. The same would be true for RAW mounted Oracle storage.

While BMC Software didn't QA the CONTROL-M software on Oracle with ASM, an option you can use is by first creating the tablespace on a filesystem and then having your Oracle DBA move that tablespace into ASM.

Note: Any issues related to the database will need to be supported by your Oracle DBA's when using an Existing Database.

These are the steps needed to work around the issue...

To work around this you will need to complete the install to an physical file location and then use these steps to convert CTMUSER tablespace to ASM:

1. Put the tablespace in read only mode
SQL> alter tablespace CTMUSER read only;

2. connected to the rman as 'rman target /'

3. Convert tablespace to ASM format
rman> convert tablespace CTMUSER format '+DATA';

4. update control file
rman>switch tablespace CTMUSER to copy

5. Switch tablespace back to read/write
SQL > alter tablespace DATA read write;

In this example the name of the tablespace is "CTMUSER" and the name of the ASM file group is "+DATA"

THIS PROCESS SHOLUD ONLY BE USED BY A COMPETENT ORACLE DBA THAT IS FAMILURE WITH THE STEPS INVOLVED.

[kylo_h]

Thanks very much for the response, Zimbo, much appreciated!!!!

[kylo_h]

Hi Guys,

Does anyone know what this Control-M Server process does?
p_ctmcs

This process seems to respawn itself and maxes out the connections on the DB, which causes the Control-M to disconnect from the DB.