Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sybase 11 Backup server can't get restarted.

Posted on 2003-12-06
8
Medium Priority
?
731 Views
Last Modified: 2012-06-21
I have installed Sybase 11.9.2 on Solaris 8. The installation completed successfully, but keep getting the error message in the log "Can't restart SQL BACKUP Server."

0
Comment
Question by:fchaman
  • 3
  • 3
6 Comments
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 9888989
Hi,

Make sure the Sybase backup server name matches the format EVENTSRVR_BS, where EVENTSRVR is the EVENTSERVER
NAME of Autosys database. If it matches, make sure the entry does exist in the sql.ini file!


Best regards, Raisor
0
 

Author Comment

by:fchaman
ID: 9905690
Hi,

I still have the problem, and below is the error message from the Sybase error log:

=======================================================
Logging Backup Server messages in file '/var/opt/3pp/sybase/log/SAOMC1_BACKUP.ERRORLOG'

Dec  9 14:15:01 2003: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Dec  9 14:15:01 2003: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Dec  9 14:15:01 2003: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Dec  9 14:15:01 2003: Open Server Error: 16240.10.0: Net-Library routine net_listen() failed in srv__start_net
Network error: status = 23 - Net-Lib protocol driver call to register a listener failed
.
Dec  9 14:15:01 2003: Open Server Server Fatal Error: 16029.20.0: Failed to start any network listeners
.
========================================================

Any idea as to what could casue the problem?

Thanks.
0
 

Author Comment

by:fchaman
ID: 9905742
One other thing: It is Sybase 12 , not 11. Sorry about the mistake.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 15

Accepted Solution

by:
Ralf Klatt earned 500 total points
ID: 9906377
Hi,

From the log it seems that your backup server wasn't started at all, because backup server couldn't start a network listener. Could it be that your backup server has the same port number as your ASE? Or the port number of backup server is used by another progamm? If that's the case you should check which program is using this port ---> "netstat -a" <--- will determine the program that is using the port number!


Best regards, Raisor
0
 

Author Comment

by:fchaman
ID: 9906526
Hi Raisor,

You were right. The backup server had the same port number as the ASE in the interfaces file. After changing the port number to 5026, I was able to start the backup server.

Many thanks for your help. The case is closed.

P.S. Do you (or anyone else) know any freeware available on Windows where I can access the Sybase tables running on a Unix server?
0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 9906624
Hi,

I'm glad that I could help!

Have you tried this link? ---> http://www.edbarlow.com/document/


Best regards, Raisor
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question