Endpoint Protection

 View Only

  • 1.  Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 02:12 AM

    Hi,

    I just installed SEP 12.1 for 200 users.I am receiving the following error continously.

    The Symantec Endpoint Protection Manager database has gone down and needs immediate attention.

     

     

    Please help me out



  • 2.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 03:04 AM

    To solve this problem, please to the steps bellow:

    1. Go to database directory(ex. C:\Program Files (x86)\Symantec\Symantec Endpoint Protection 
     
    Manager\db) and remove everything besides sem5.db file.
    2. Open command line and navigate to %ProgramFiles%\Symantec\Symantec Endpoint Protection 
     
    Manager\ASA\win32.
    3. Run command:
    dbsrv11 -f"C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db"
    3. Start Symantec Embedded Database.
    4. Run dbisqlc from "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection 
     
    Manager\ASA\win32". and log into Database like in the picture. 
    5. Run query DROP INDEX I_SEM_AGENT_COMPUTER_ID_PLUS
    Afer this procedure, you should be able to use SEPManager with no issue.
     

    Second option:-

    How to perform Disaster Recovery without Database backup/Restore

     

     



  • 3.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 04:12 AM

    Atfer performing the following task on database

     

    Go to database directory(ex. C:\Program Files (x86)\Symantec\Symantec Endpoint Protection 
     
    Manager\db) and remove everything besides sem5.db file.
    2. Open command line and navigate to %ProgramFiles%\Symantec\Symantec Endpoint Protection 
     
    Manager\ASA\win32.
    3. Run command:
    dbsrv11 -f"C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db"
     
     
    When i try to start the database service iot gives me the error  "the symantec emdedded database service on local computer start then stopped"


  • 4.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 04:19 AM

     

    Second option:-

     

    How to perform Disaster Recovery without Database backup/Restore

     


  • 5.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 05:43 AM

    HI,

    I tried the second option it work for me but my all setting of previous databse has been removed.



  • 6.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 07:50 AM

    Hello Junaid,

     

    The database only has policies and the group formation in the clients tab. we cannot restore the databse in ur case since the db may not be good and its possible that restoring the same again could have you land up in the same issue again.



  • 7.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 08:59 AM

    Hi Simpson,

    First of all thank you very much for ur support.Simpson due have any snap shot guide of policy configuration (SEP 12.1) for small organization.Actually i am new in symantec product.

    Symantec implementation guide is complex.



  • 8.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 09:23 AM

    Well, You could post your queries here on the forums and they would be answered, which would help you understand the product well.



  • 9.  RE: Symantec End point protection 12.1 database down error

    Posted Jul 04, 2012 09:35 AM

    If you have your latest Copy of Data backup you and if db is restored in SEPM .

    Please check policy configuration from option below.

    ftp://ftp.symantec.com/public/english_us_canada/products/symantec_endpoint_protection/11.0/manuals/symantec_endpoint_protection_getting_started_guide.pdf

    Alternatively i would highly suggest before making changes or Before performing Disaster Recovery Please backup the Policies so that you can revert back once the SEPM is up.



  • 10.  RE: Symantec End point protection 12.1 database down error