IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Is running DB Configurator against Oracle DB using ASM possible?

  • 1.  Is running DB Configurator against Oracle DB using ASM possible?

    Posted Thu April 25, 2019 11:38 AM

    Hi,

    I am currently trying to prepare an Oracle 12c Database (which uses ASM for the Tablespaces) for our new wM 9.12 production.

    Which tablespace directory needs to be specified in this case in DB Configurator when using automatic Tablespace and User creation?

    Is this possible, or do I need to ask my DBA to reinstall the Database without using ASM?

    Regards,
    Holger


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Is running DB Configurator against Oracle DB using ASM possible?

    Posted Wed May 01, 2019 08:22 AM

    Do talk to your DBA. There shouldn’t be a need to ditch ASM, but helping the DBA understand what happens should help him understand what happens when new users/tablespaces are created.
    The big thing in ASM is the A for Automatic. So it should automatically assign and (re-)configure the data and optimise it for performance etc.


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 3.  RE: Is running DB Configurator against Oracle DB using ASM possible?

    Posted Thu May 02, 2019 09:08 AM

    Hi Mike,

    thanks for your reply.

    Meanwhile I have talked to my DBA and we got it working with ASM now.

    The only thing is that we now have to specify a different value for the tablespace directory in DB Configurator UI.

    Regards,
    Holger


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB