Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

SEPM embedded database will not start

Updated: 07 Feb 2011 | 12 comments
jimmyjames's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

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

Comments

jimmyjames's picture
05
Nov
2010
0 Votes 0
Login to vote

Some other info: I am running

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?

jimmyjames's picture
05
Nov
2010
0 Votes 0
Login to vote

Not sure if this helps

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!
Rafeeq's picture
05
Nov
2010
0 Votes 0
Login to vote

hi

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.

Please don't forget to mark your thread solved with whatever answer helped you : ) Rafeeq

jimmyjames's picture
06
Nov
2010
0 Votes 0
Login to vote

Hi Rafeeq   After many

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

Vikram Kumar-SAV to SEP's picture
06
Nov
2010
1 Vote +1
Login to vote

  To adjust the Symantec

 

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
mon_raralio's picture
07
Nov
2010
0 Votes 0
Login to vote

Hi Vikram, I'd like to

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

“Your most unhappy customers are your greatest source of learning.”

jimmyjames's picture
06
Nov
2010
0 Votes 0
Login to vote

Thanks Vikram   Is this a

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

jimmyjames's picture
06
Nov
2010
0 Votes 0
Login to vote

changing that value didn't

changing that value didn't work.

Vikram Kumar-SAV to SEP's picture
06
Nov
2010
0 Votes 0
Login to vote

Install a fresh SEPM import

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

jimmyjames's picture
06
Nov
2010
0 Votes 0
Login to vote

Thanks Vikram. Will this work

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!

Vikram Kumar-SAV to SEP's picture
07
Nov
2010
0 Votes 0
Login to vote

Ditch everything just install

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

VeeKee's picture
06
Nov
2010
0 Votes 0
Login to vote

Have you tried running upgrade.bat.

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!"

---------------------------------
Vikas
--
Don't forget to mark your thread as 'solved' with the answer that best helped you!