Solved

Sybase 11 Backup server can't get restarted.

Posted on 2003-12-06
8
719 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:Raisor
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 15

Accepted Solution

by:
Raisor earned 125 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:Raisor
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

717 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