on 09-16-2013 6:36 PM
Dear Expert,
I am using Sybase Database 15.0 with unix, as i new to Sybase please me how to take backup of Sybase Database.
i get the below error
1> dump database pubs2 to 'd:\dump'
2> go
Msg 7205, Level 17, State 2:
Server 'BHAVANIPC', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
boot directory.
Msg 7205, Level 18, State 3:
Server 'BHAVANIPC', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
boot directory.
Also we opened the backup server
Thanks & Regards,
Akhila
Hi Akhila,
can you please share interface file under $SYBASE directory??
I have some solution in this context.
---
Pankaj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Getting the same kind of error while running dump command.
1> dump transaction XXX using config = 'XXXLOG'
1> use master
2> go
1> dump transaction XXX using config = 'XXXLOG'
2> go
Msg 7205, Level 17, State 2:
Server 'PJ2', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.
Msg 7205, Level 18, State 3:
Server 'PJ2', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.
Msg 3220, Level 17, State 3:
Server 'PJ2', Line 1:
Could not establish communication with Backup Server 'SYB_BACKUP'. Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.
interface file entries
XXX
master tcp ether xxxxxx 4901
query tcp ether xxxxxx 4901
XXX_BS
master tcp ether xxxxxx 4902
query tcp ether xxxxxx 4902
XXX_JSAGENT
master tcp ether xxxxxx 4903
query tcp ether xxxxxx 4903
ASE SP122 on AIX 7.1
Let me know if you need further information
Let the steps provided in
find the attached backup server errorlog for your reference
Apprecate any help
Regards,
Rajesh
Your backupserver errorlog is showing the error
Feb 9 15:00:01 2015: Backup Server: 2.24.2.1: The host '10.3.5.61' is not authorized to connect to this Backup Server.
Feb 9 15:00:01 2015: Backup Server: 5.40.2.1: Login host authentication has failed.
This is a symptom of a bug with a security feature that was introduced in 15.7 SP100
Remote Dump Host Control. This feature was not supposed to interfere with local dumps, but in some cases such as hosts with multiple network interfaces, it did.
The error can usually be resolved by adding entries for the local server's network interfaces to the hosts.allow file.
There was a 'feature' introduced in sp110/sp50 to increase security.
Your backupserver logs contains the following lines :
Feb 9 18:08:41 2015: Backup Server: 1.88.1.1: The hosts authentication file used by the backup server is '/sybase/PJ2/hosts.allow'.
The host '10.3.5.61' is not authorized to connect to this Backup Server.
Feb 9 14:00:01 2015: Backup Server: 5.40.2.1: Login host authentication has failed.
What is the content of '/sybase/PJ2/hosts.allow' ?
Add a line :
10.3.5.61 +
if it doesn't contain it yet, or replace the ip address by the hostname.
HTH,
Luc.
Yes.
The details of the file format are in the documentation I referenced before: Remote Dump Host Control.
Extracting from the examples there, a simple entry would look like:
Example:
# Example of hosts.allow file
# Development machine imetsol1 allows access from everywhere
imetsol1 +
An ip address can be substituted for the logical host name.
-bret
Hi Bret,
Getting the following error when I issued dump database command
Msg 7205, Level 17, State 2:
Server 'PJ2', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.
Msg 7205, Level 18, State 3:
Server 'PJ2', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.
Msg 3220, Level 17, State 3:
Server 'PJ2', Line 1:
Could not establish communication with Backup Server 'SYB_BACKUP'. Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.
tried substituting IP adress and logical hostname and restarted the backup server. pls advice further.
Rajesh
Hi Luc,
Please find the output.
1> select srvnetname from sysservers where srvname = 'SYB_BACKUP'
2> go
srvnetname
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYB_BACKUP
Pls advice further
Rajesh
Hi Luc,
Please find the attachment for your reference.
Current status: backup server up and running
Error found only in backup server errorlog: The host '10.3.5.61 is notauthirized to connect to this backup server
I have tried adding 10.3.5.61 + and server's logical name in "hosts.allow" file
Pls advice
Rajesh
Remove all comments from hosts.allow, and also remove all empty lines.
The only 2 lines in the file should be :
pj2ci1 +
10.3.5.61 +
so wc -l hosts.allow should show 2 lines.
use vi or a unix editor to create the file.
If this still gives errors, then post the output of :
od -bc hosts.allow
(assuming the od (octal dump) commanda also exists on aix).
Dear Luc
Thank you for your valuable inputs
Now there is only one error when i run the dump command
Msg 7221, Level 14, State 2:
Server 'PJ2', Line 1:
Login to site 'SYB_BACKUP' failed.
FYI
% wc -l hosts.allow
2 hosts.allow
% od -bc hosts.allow
0000000 160 152 062 143 151 061 040 053 012 061 060 056 063 056 065 056
p j 2 c i 1 + \n 1 0 . 3 . 5 .
0000020 066 061 040 053 012
6 1 + \n
0000025
-- Backup server is up and running
--No errors in dataserver errorlog
--Error in the backup server log:
The host '10.3.5.61' is not authorized to connect to this Backup Server.
Login host authentication has failed.
Regards
Rajesh
Dear Luc,
Your idea at one of the SCN post worked
You said "
Ok, i solved my problem.
The IP Address (syslisteners) of my server is different from the host ip address.
I added the ASE server's IP Address to the hosts.allow file and then the dataserver can connect to the backupserver.
The backupserver error message is misleading. It shows the ip address of the host machine and not the ip address of the server while it's the last one that is necessary in the hosts.allow file.
Luc."
I've checked syslisteners and found the following
1> select * from master..syslisteners
2> go
net_type address_info spare nodeid
-----------------------------------------------------------------------------
tcp egapj2db 4901 0 NULL
Instead of using "%hostname" I thought, lets give a try with "egapj2db ".
Restarted the backup server and ran the dump command and is ........successful.
Thank you Luc.
I want to award you the points you deserve.
Regards,
Rajesh
Received following page verification errors in the backup server errorlog.
What are they actually indicating?
What is action need to be taken?
Feb 11 11:12:17 2015: D00: Attempting direct I/O for device '/sybase/PJ2/sybsystem/sybmgmtdb.dat'
Feb 11 11:12:17 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 6324 kilobytes (8%) DUMPED.
Feb 11 11:12:18 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 42310 kilobytes (30%) DUMPED.
Feb 11 11:12:18 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 62648 kilobytes (62%) DUMPED.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6972 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6973 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6974 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6975 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: SYBMULTBUF WARNING: One or more errors have been reported while performing consistency checks on the pages being dumped. The
affected pages will be reread in an attempt to discard spurious errors.
Feb 11 11:12:18 2015: D00: SYBMULTBUF WARNING: After rereading the pages, the consistency check has continued to report one or more errors.
Feb 11 11:12:18 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 81450 kilobytes (100%) DUMPED.
Feb 11 11:12:18 2015: Backup Server: 3.43.1.1: Dump phase number 1 completed.
Regards,
Rajesh
Take a look at thread :
http://scn.sap.com/thread/3555002
That's a similar story.
You can also dump the transaction log,
see if the error is persistant : redo the dump to see if the errors still occur,
run some dbcc check commands.
Luc.
You mentioned 'Sybase Database 15.0 with unix' on you post,
so you must make sure your backup server was started and working ok by following method:
$showserver |grep backupserver
Example:
/data/ase1570 > showserver |grep backupserver
0 S sybase 19210 19209 0 80 0 - 5788 - Aug01 ? 00:00:00 /data/ase1570/ASE- 15_0/bin/backupserver -SSYB_BACKUP -e/data/ase1570/ASE-15_0/install/SYB_BACKUP.log -N25 -C20 - M/data/ase1570/ASE-15_0/bin/sybmultbuf
$isql -Usa -Psa_pwd -SASE15
1> sp_helpserver SYB_BACKUP
2> go
Example:
1> sp_helpserver SYB_BACKUP
2> go
name network_name security_mechanism server_principal class
status
id cost
---------- -------------- -------------------- ------------------ ------------
-------------------------------------------------------------------------
-- ----
SYB_BACKUP SYB_BACKUP NULL NULL ASEnterprise
timeouts, no net password encryption, writable , enable login redirection
1 NULL
$isql -Usa -Psa_pwd -SASE15
1> SYB_BACKUP...sp_who
2> go
Example:
1> SYB_BACKUP...sp_who
2> go
spid status loginame hostname blk
cmd
----------- ---------- ------------------------------ ------------ -------------------
1 sleeping NULL NULL 0
CONNECT HANDLER
2 sleeping NULL NULL 0
DEFERRED HANDLER
3 runnable NULL NULL 0
SCHEDULER
11 runnable NULL ASE1570 0
SITE HANDLER
12 running sa sgsinvm0256 0
NULL
if the above checking is all ok, then you should be able to dump database without problem !!
BTW, you must notice you are using SAP Sybase ASE 15.0 with Unix , so the dump directory should be Unix filesystem format such as '/backdir/pubs2.dmp' rather than Windows filesystem format such as 'd:\pubs2.dmp' !!
HTH ! Thanks !!
Regards,
Robert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear ROBERT,
I am using SYBASE Database 15.0 with AIX 7.0. I am also getting the same error mentioned above in this thread while performing database backup at OS Level.
Please find the error below ...
1> sp_helpserver SYB_BACKUP
2> go
name
network_name
security_mechanism
server_principal
class
status
id cost
SYB_BACKUP
VES_BS
NULL
NULL
NULL
timeouts, no net password encryption, writable , enable login redirecti
on
1 NULL
(return status = 0)
1> SYB_BACKUP...sp_who
2> go
Msg 7205, Level 17, State 2:
Server 'VES', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
boot directory.
Msg 7205, Level 18, State 3:
Server 'VES', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
boot directory.
Looking forward for your reply...
Thanks & Regards,
Ram
Hello,
sp_helpserver shows that the fysical name of the backupserver is VES_BS.
Most likely the server is not running.
On unix systems the startup script can be found in $SYBASE/$SYBASE_ASE/install.
The default name is RUN_VER_BS.
It can be started with :
cd $SYBASE$SYBASE_ASE/install
startserver -f RUN_VER_BS
The environment variables used above should point to the directory in which your ASE software is installed. If they don't seem to have the right values, you can set them with :
cd <your sybase install directory>
. SYBASE.sh
if you are using sh/ksh/bash as your unix shell.
(source SYBASE.csh if you're using a c-shell.)
Best Regards,
Luc.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.