Endpoint Protection

 View Only
Back to discussions
Expand all | Collapse all

SEPM embedded database will not start

Migration User

Migration UserNov 06, 2010 04:34 PM

changing that value didn't work.

  • 1.  SEPM embedded database will not start

    Posted Nov 05, 2010 06:56 PM

    Hi

    I had some serious problems with SEPM so I followed advice from Symantec and backed up my database as well as copying my db folder and private key directory.  I removed SEPM and after reinstalling 6a and then MP1 I am now unable to started the embedded database.  Can someone please help as I now have no AV server and all my clients (200+) no longer have a management server to talk to. 

    I have tried so many things and none of them work.  The embedded database just won't start!  Please help.

    Thanks

     

    James



  • 2.  RE: SEPM embedded database will not start

    Posted Nov 05, 2010 07:05 PM

    Some other info:

    I am running Server 2003, and SEPM 11.06 MP1.  This is what I was running before I ran into the issues and had to re-install so this is the backup I have.  

    I first installed 11.06a and then I ran 11.06 MP1.  

    When I start the server configuration wizard it just leaves the embedded database service state as "starting" and it never actually starts.  

    I have tried running backup and restore and I also get an error.  I guess it's because it can't connect to the new empty database as it can't start it.

    I have tried overwriting the new db folder with my backup db folder and this still doesn't work as I am still unable to start the service.

    Any ideas?



  • 3.  RE: SEPM embedded database will not start

    Posted Nov 05, 2010 07:13 PM

    Not sure if this helps either.   This is the content of the upgrade.log file in the tomcat folder: 

     

    Server HomeC:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat
    java.sql.SQLException: Network error IOException: Connection refused: connect
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
    at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:277)
    at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:132)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:276)
    at com.sygate.scm.server.upgrade.UpgradeDBUtil.initDataSource(UpgradeDBUtil.java:207)
    at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:94)
    at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:222)
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:519)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
    ... 9 more
    Result: Can't connect to database at this moment. You may need to upgrade manually.
    Missing property: scm.agent.root.
    Server is not configured correctly, please run Server Configuration Assistant!


  • 4.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 02:44 AM

    Check if u have any process using port 2968

    While restoring the DB; the sepm version from which it was backed up should be  of same version.



  • 5.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 05:00 AM

    Hi Rafeeq

     

    After many re-installs, reboots and all sorts of other things I am now back online.  My problem now is that I am back to square one....

    The whole reason I uninstalled and re-installed was because as soon as I start the SEPM service my page file slowly starts to increase and then after around 3 hours I get either virtual memory warnings or the server just crashes.  It is definitely something to do with SEPM.

    Do you have any ideas?  Also, when I look in task manager I see LOTS of java.exe processes, some of which are using A LOT of memory.  Somehow these are created when starting the SEPM service and these cause the paging.  How can I stop this happening?

    Can I run some tools or diags and get an idea of what is happening and prevent it? 

    Thanks

    James



  • 6.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 01:05 PM

     

    To adjust the Symantec Endpoint Protection Manager heap size:
    Click Start> Run.
    Type regedit
    Press Enter.
    Locate the following registry key:
    HKLMSYSTEMCurrentControlSetServicessemsrvParameters
    Locate the following keys:
    JVM Option Number 0
    JVM Option Number 1
    Adjust the key values upward, and match the key values.
    For example, to create a 1 GB static heap, set the JVM Option Number 0 to -Xms512m, and set
    the JVM Option Number 1 to -Xmx512m.
    Exit Regedit.
    Click Start> Settings> Control Panel> Administrative Tools.
    In the Services
     
    set it to 512 or 1024


  • 7.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 01:51 PM

    Thanks Vikram

     

    Is this a known issue?  Will this solve my problem?

    What I am now thinking of doing is creating a Windows 2008 Server VM on VSphere ESXi and installing SEPM on this.  Do you know if this will work?  Do you know how I can migrate all of my policies across and get my clients talking to this new server? I want to ditch this server and its database as I believe the problem lies within a corrupt db.

    I have backed up all of my policies and I have my private key too.

     

    James



  • 8.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 04:34 PM

    changing that value didn't work.



  • 9.  RE: SEPM embedded database will not start
    Best Answer

    Posted Nov 06, 2010 05:34 PM

    Install a fresh SEPM import all the policies you have backed up.

    Connect back the clients using Sylink Replacer Utility.

    https://www-secure.symantec.com/connect/downloads/sylinkreplacer-tool-connecting-sep-clients-sepm



  • 10.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 06:25 PM

    Thanks Vikram. Will this work fine on an VSphere ESXi 4.0 Windows Server 2008 R2?

    Do I need to use my private key or shall I just ditch it?

    I am getting a little bored of having to babysit this thing.  I used to love Symantec but their software appears to have become rather flaky and the support on the 0870 606 6000 is appalling!  It's like the advisors are learning themselves!



  • 11.  RE: SEPM embedded database will not start

    Posted Nov 06, 2010 07:26 PM

    Try running upgrade.bat from  ..\SEPM\bin\upgrade.bat once the database is restored.

     

    The reason why i am saying is because of the log snippet

     

    "Result: Can't connect to database at this moment. You may need to upgrade manually.

    Missing property: scm.agent.root.

    Server is not configured correctly, please run Server Configuration Assistant!"



  • 12.  RE: SEPM embedded database will not start

    Posted Nov 07, 2010 10:41 AM

    Ditch everything just install a fresh SEPM..and use Sylink Replacer and it should work



  • 13.  RE: SEPM embedded database will not start

    Posted Nov 07, 2010 08:47 PM

    Hi Vikram,

    I'd like to request for a link on a detailed documentation of this procedure. I want to study it in depth.

    Thanks. :D