Sybase 11 Backup server can't get restarted.

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

fchamanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ralf KlattEmployee in Civil ServiceCommented:
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
fchamanAuthor Commented:
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
fchamanAuthor Commented:
One other thing: It is Sybase 12 , not 11. Sorry about the mistake.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Ralf KlattEmployee in Civil ServiceCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fchamanAuthor Commented:
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
Ralf KlattEmployee in Civil ServiceCommented:
Hi,

I'm glad that I could help!

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


Best regards, Raisor
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.