Data Loss Prevention

 View Only
  • 1.  Single Tier installation DLP 14 fails with "Error creating schema"

    Posted Nov 05, 2015 04:57 PM

    Good evening,

    Having a problem settings up new single tier DLP 14, went through all the steps up to the point of ininitialing Enforce database, where it fails on "Creating Database Schema".

    I've attached Schema.Creation logs to this post.

    Any help would be greatly appreachiated.

    Attachment(s)

    txt
    SchemaCreation.txt   572 KB 1 version


  • 2.  RE: Single Tier installation DLP 14 fails with "Error creating schema"

    Trusted Advisor
    Posted Nov 06, 2015 02:31 AM

    hello,

    I am not a DBA and if you have one in your company you may ask him more information about this oracle error but it seems that main error is

    ORA-24005: Inappropriate utilities used to perform DDL on AQ table

    all the other ones are just consequence of this one.

    Does your "protect" account on oracle DB as correct privileges as described in Symantec documentation ?

    It seems there is already lot of object in tablespace you want to use for DLP DB (may be due to previous failed installation) and script is not able to drop them.

    If you cannot solve it, you could try to drop this tablespace and create a new one for your DB protect user.

    regards.



  • 3.  RE: Single Tier installation DLP 14 fails with "Error creating schema"

    Posted Nov 11, 2015 05:23 PM
      |   view attached

    Thank you for a reply, but I provided a wrong log file.

    Same problem, but it doesn't seem like "ORA-24005: Inappropriate utilities used to perform DDL on AQ table" error applies.

     

     

     

     

    Attachment(s)

    txt
    SchemaCreation_0.txt   566 KB 1 version


  • 4.  RE: Single Tier installation DLP 14 fails with "Error creating schema"

    Posted Nov 24, 2015 10:34 AM

    Hi ,

    It seems Oracle DB issue that not able to perform the queries to create schema and tables, You need to work with DB Expert, You can follow beloe for ref

     

    http://stackoverflow.com/questions/14597250/sql-error-ora-24005-inappropriate-utilities-used-to-perform-ddl-on-aq-table-vp



  • 5.  RE: Single Tier installation DLP 14 fails with "Error creating schema"

    Posted Nov 26, 2015 03:02 AM

    Hi,

    Before upgrading to DLP 14.0 did you execute the upgrade script?

    This is more related to database issue and if you have an inhouse DBA then you will have to take his help.

    The only other option is to open a ticket with DLP support and hopefully they will help you. I have not seen this error before.