 |
|
|
|
Next: Find a better plan than that computed by the opti..
|
| Author |
Message |
External
Since: Feb 22, 2005
Posts: 2
|
(Msg. 1) Posted: Tue Feb 22, 2005 7:43 am
Post subject: Problem with ASE 12.5 Backup Server
Archived from groups: comp>databases>sybase (more info?)
|
|
|
Hello everyone !!!
My problem:
I have recently installed ASE 12.5 on winxp. When I try to make a dump
or load with isql or DBArtisan i get this message:
"Can't open a connection to site 'SYB_BACKUP'. See the error log file
in the SQL Server boot directory."
Both data and backup servers have been started via Services console.
I´ve tried also starting them with RUN_<server_name>.BAT and
RUN_<server_name>_BS.bat with the same results.
In log of the data server i have this output:
-----------------------------------------
00:00000:00017:2005/02/21 11:00:41.93 kernel nl__connect: Could not
connect to site 'INFO02_BS', socket 12.
00:00000:00017:2005/02/21 11:00:42.13 kernel nl__connect: net_connect
failed to connect to site 'INFO02_BS'.
: El sistema no puede hallar el archivo especificado.(*)
..
00:00000:00017:2005/02/21 11:00:42.18 server Failed to connect to
remote server INFO02_BS nlwnsck ether 10.0.0.53 5002 for site
SYB_BACKUP. Trying the next query entry of this server, if any.
00:00000:00017:2005/02/21 11:00:42.22 server Error: 7235, Severity: 17,
State: 0
00:00000:00017:2005/02/21 11:00:42.27 server No other query entry found
for the remote server INFO02_BS - site SYB_BACKUP. Aborting this site
handler, as no remote server responded. Please make sure the remote
server is accepting connections.
(*) means "system could not find the specified file" in spanish.
These are the contents of the backup server log:
----------------------------------------------
Logging Backup Server messages in file
'C:\sybase\ASE-12_5\install\INFO02_BS.log'
Feb 21 07:53:22 2005: Backup Server: 1.70.1.1: Configuring the maximum
shared memory usage to 48 MB.
Feb 21 07:53:22 2005: Backup Server: 1.69.1.2: Configuring the number
of service threads to 48.
Feb 21 07:53:22 2005: Backup Server: 1.70.1.3: Configuring the shared
memory per stripe to 1048576 bytes.
Looks a like a dump request never had been done. However when I ping
the backup server with DSedit, it connects succesfully.
The port of the bs is 5002, but strangely it does not appear when i
make a netstat -a:
-----------------------------------------------------------------------
Proto Direcci¢n local Direcci¢n remota Estado
TCP info-02:epmap 0.0.0.0:0 LISTENING
TCP info-02:microsoft-ds 0.0.0.0:0 LISTENING
TCP info-02:1025 0.0.0.0:0 LISTENING
TCP info-02:1032 0.0.0.0:0 LISTENING
TCP info-02:3107 0.0.0.0:0 LISTENING
TCP info-02:3236 0.0.0.0:0 LISTENING
TCP info-02:3805 0.0.0.0:0 LISTENING
TCP info-02:4958 0.0.0.0:0 LISTENING
TCP info-02:4961 0.0.0.0:0 LISTENING
TCP info-02:5000 0.0.0.0:0 LISTENING
TCP info-02:netbios-ssn 0.0.0.0:0 LISTENING
TCP info-02:1034 0.0.0.0:0 LISTENING
TCP info-02:1034 10.0.0.5:netbios-ssn ESTABLISHED
TCP info-02:3107 10.0.0.5:5000 ESTABLISHED
TCP info-02:3236 10.0.0.5:5000 ESTABLISHED
TCP info-02:3805 10.0.0.53:ttcp ESTABLISHED
TCP info-02:3841 10.0.0.73op3 TIME_WAIT
TCP info-02:3843 10.0.0.73op3 TIME_WAIT
TCP info-02:4283 0.0.0.0:0 LISTENING
TCP info-02:4283 10.0.0.6:netbios-ssn ESTABLISHED
TCP info-02:4961 10.0.0.5:5000 ESTABLISHED
TCP info-02:ttcp 0.0.0.0:0 LISTENING
TCP info-02:ttcp 10.0.0.53:3805 ESTABLISHED
TCP info-02:5002 0.0.0.0:0 LISTENING
TCP info-02:5002 0.0.0.0:0 LISTENING
TCP info-02:3005 0.0.0.0:0 LISTENING
TCP info-02:3006 0.0.0.0:0 LISTENING
TCP info-02:3007 0.0.0.0:0 LISTENING
TCP info-02:3025 0.0.0.0:0 LISTENING
TCP info-02:3025 localhost:3840 TIME_WAIT
TCP info-02:3025 localhost:3842 TIME_WAIT
TCP info-02:4957 0.0.0.0:0 LISTENING
TCP info-02:4957 localhost:4958 ESTABLISHED
TCP info-02:4958 localhost:4957 ESTABLISHED
UDP info-02:epmap *:*
UDP info-02:microsoft-ds *:*
UDP info-02:isakmp *:*
UDP info-02:1028 *:*
UDP info-02:ntp *:*
UDP info-02:netbios-ns *:*
UDP info-02:netbios-dgm *:*
UDP info-02:1900 *:*
UDP info-02:ntp *:*
UDP info-02:1900 *:*
UDP info-02:2234 *:*
UDP info-02:4992 *:*
The BS also can be seen if i run sp_helpserver:
-----------------------------------------------
name network_name class status id cost
INFO02_XP INFO02_XP ASEnterprise timeouts, no net password encryption,
writable , rpc security model A 3 1000
SYB_BACKUP INFO02_BS ASEnterprise timeouts, no net password encryption,
writable , rpc security model A 4 1000
SYB_EJB EJBServer ASEJB external engine auto start 2 [NULL]
INFO02_BS is the backup_server
I've tried this also wih no results:
sp_dropserver SYB_BACKUP
go
sp_addserver SYB_BACKUP, null, INFO02_BS
go
A lot of thanks for any help and sorry for my horrid english. |
|
| Back to top |
|
 | |
External
Since: Jan 28, 2005
Posts: 7
|
(Msg. 2) Posted: Tue Feb 22, 2005 8:20 am
Post subject: Re: Problem with ASE 12.5 Backup Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 22, 2005
Posts: 2
|
(Msg. 3) Posted: Tue Feb 22, 2005 9:16 am
Post subject: Re: Problem with ASE 12.5 Backup Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
yep, these are the contents of sql.ini
----------------------------------------------------
[INFO02_XP]
master=NLWNSCK,info-02,5004
query=NLWNSCK,info-02,5004
[INFO02]
master=NLWNSCK,10.0.0.53,5001
query=NLWNSCK,10.0.0.53,5001
[INFO02_MS]
master=NLWNSCK,info-02,5003
query=NLWNSCK,info-02,5003
[THOR]
master=TCP,10.0.0.5,5000
query=TCP,10.0.0.5,5000
[INFO02_BS]
master=NLWNSCK,10.0.0.53,5002
query=NLWNSCK,10.0.0.53,5002
I made the test replacing the name of the machine for the actual IP,
but it didn't work
BTW, after reviewing my own post, i can see port 5002 is actually
listening ("TCP info-02:5002 0.0.0.0:0 LISTENING "), what makes even
more strange that the connection could not be done.
Regards and thaks for any help >> Stay informed about: Problem with ASE 12.5 Backup Server |
|
| Back to top |
|
| |
External
Since: Feb 22, 2005
Posts: 2
|
(Msg. 4) Posted: Tue Feb 22, 2005 4:20 pm
Post subject: Re: Problem with ASE 12.5 Backup Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Jubei" wrote in message ...
> yep, these are the contents of sql.ini
> ----------------------------------------------------
> [INFO02_XP]
> master=NLWNSCK,info-02,5004
> query=NLWNSCK,info-02,5004
>
> [INFO02]
> master=NLWNSCK,10.0.0.53,5001
> query=NLWNSCK,10.0.0.53,5001
>
> [INFO02_MS]
> master=NLWNSCK,info-02,5003
> query=NLWNSCK,info-02,5003
>
> [THOR]
> master=TCP,10.0.0.5,5000
> query=TCP,10.0.0.5,5000
>
> [INFO02_BS]
> master=NLWNSCK,10.0.0.53,5002
> query=NLWNSCK,10.0.0.53,5002
>
> I made the test replacing the name of the machine for the actual IP,
> but it didn't work
>
> BTW, after reviewing my own post, i can see port 5002 is actually
> listening ("TCP info-02:5002 0.0.0.0:0 LISTENING "), what makes even
> more strange that the connection could not be done.
>
> Regards and thaks for any help
perhaps you can also review the registry settings for the backupserver
to see if there are any obvious discrepancies between these entries
and what you think you have set through RUN file and interfaces entry
.... place to check is
....HKEY_LOCAL\SOFTWARE\Sybase\Server\<backupserver_name>\Parameters
.... I have just been through my own private battle with windows
(backup server not starting at all) which ended up being resolved
through editing these values .... >> Stay informed about: Problem with ASE 12.5 Backup Server |
|
| Back to top |
|
| |
External
Since: Jan 28, 2005
Posts: 7
|
(Msg. 5) Posted: Wed Feb 23, 2005 12:23 am
Post subject: Re: Problem with ASE 12.5 Backup Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
| Related Topics: | Get last dumped/applied log filenames from data or backup .. - Hi, Can I get the following by querying the sybase data or (more likely) backup server: 1. An online database's last dumped transaction log file name and timestamp 2. A standby database's last applied transaction log file name and timestamp. I know the....
Software Problem - Please iqnore this if it not in its place. How software problem can cause db/log file corruption ? I did read Breck Carter book chapter 10 tuning and I had search sybase documantation but did not find it, my server has no virus,worm,spyware or anything...
Select into problem - Hi, I have a problem concerning the select into statement. I have created a procedure that contains dynamic sql, which creates a variable number of columns. The sql looks like : @sql = 'select columnA, columnB, columnC,.... into #t from.....'..
ct_connect problem - Hello, Every 10 minutes (whith Task scheduler) I'm running from a windows-xp pro/Sybase 12.5 client, 8 executables which do just some SELECT/ INSERT/UPDATE to a Sybase ASE 12.5 (SUN Solaris server) which is on a remote/lan. All these executables are..
Need solution for the following problem - Hi all, We need to avoid the adaptiva server's automatic expansion of selected elements using 'select * ' inside a store proc.. Can anyone help on this? |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
