?
Solved

Sybase 11 Backup server can't get restarted.

Posted on 2003-12-06
8
Medium Priority
?
723 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 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
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

741 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