建立 Adaptive server 时遇到麻烦了，头疼！！！

shiner

错误如下：


补充一下我的系统是 Red Hat Enterprise Linux 5，装的是 ASE-12_5
那位高人指条明路哈，谢谢了！

[ 本帖最后由 shiner 于 2008-3-31 17:22 编辑 ]

chuxu

那你就在启动server的sh里面多执行一下命令了

chuxu

sybase的log呢？

shiner

这是一些片段：

1. 
   
2. 00:00000:00001:2008/03/31 02:41:33.98 server  Checking external objects.
   
3. 00:00000:00001:2008/03/31 02:41:33.98 server  The transaction log in the database 'model' will use I/O size of 4 Kb.
   
4. 00:00000:00001:2008/03/31 02:41:33.98 server  Database 'model' is now online.
   
5. 00:00000:00001:2008/03/31 02:41:33.98 server  The logical pagesize of the server is 4 Kb.
   
6. 00:00000:00001:2008/03/31 02:41:33.98 server  0 dump conditions detected at boot time
   
7. 00:00000:00001:2008/03/31 02:41:33.98 server  Resident Node id: db8fe6fc0dc4
   
8. 00:00000:00001:2008/03/31 02:41:33.98 server  Transaction coordinator initialized.
   
9. 00:00000:00001:2008/03/31 02:41:33.98 server  Clearing temp db
   
10. 00:00000:00001:2008/03/31 02:41:34.02 server  The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
    
11. 00:00000:00001:2008/03/31 02:41:34.03 server  Database 'tempdb' is now online.
    
12. 00:00000:00009:2008/03/31 02:41:34.04 kernel  ninit: cannot find host 192.168.112.209
    
13. 00:00000:00009:2008/03/31 02:41:34.04 kernel  Cannot allocate resources for listener with protocol tcp, host 192.168.112.209, port 4100, engine 0.
    
14. 00:00000:00009:2008/03/31 02:41:34.04 kernel  Cannot start any network listeners.
    
15. 00:00000:00009:2008/03/31 02:41:34.04 kernel  ueshutdown: exiting
    
16. 00:00000:00000:2008/03/31 02:45:46.74 kernel  Checked out license ASE_DEV
    
17. 00:00000:00000:2008/03/31 02:45:46.74 kernel  Adaptive Server Enterprise Developer Edition.
    
18. 00:00000:00000:2008/03/31 02:45:46.74 kernel  Attempt to open device /home/sybase/data/master.dat failed.
    
19. 00:00000:00000:2008/03/31 02:45:46.74 kernel  dopen: open '/home/sybase/data/master.dat', No such file or directory
    

复制代码

echoaix

安装的log？

shiner

是建SERVER 是产生的 server log

shiner

安装时的  log

1. 
   
2. 00:00000:00000:2008/03/31 01:44:03.27 kernel  Logging ASE messages in file '/home/sybase/SYSAM-1_0/log/SYBASE.log'.
   
3. 00:00000:00000:2008/03/31 01:44:03.28 kernel  Platform TCP network is forced to IPv4-only.
   
4. 00:00000:00000:2008/03/31 01:44:03.28 kernel  SQL Server booted with TCP_NODELAY enabled.
   
5. 00:00000:00000:2008/03/31 01:44:03.29 kernel  SSL Plus v3.0.8 security modules loaded successfully.
   
6. 00:00000:00000:2008/03/31 01:44:03.29 kernel  Network and device connection limit is 1014.
   
7. 00:00000:00000:2008/03/31 01:44:03.96 server  Number of blocks left for proc headers: 3232.
   
8. 00:00000:00000:2008/03/31 01:44:03.96 server  Proc header memory allocated 1616 pages for each per engine cache
   
9. 00:00000:00000:2008/03/31 01:44:04.05 server  Size of the 2K memory pool: 8192 Kb
   
10. 00:00000:00000:2008/03/31 01:44:04.05 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
    
11. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Extended cache size '0' is invalid. Provide the appropriate size value.
    
12. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Enabling (RT) Posix asynchronous disk I/O strategy.
    
13. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Initializing virtual device 0, '/home/sybase/data/master.dat' with dsync 'off'.
    
14. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Virtual device 0 started using asynchronous i/o.
    
15. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Worker Thread Manager is not enabled for use in SQL Server.
    
16. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
    
17. 00:00000:00000:2008/03/31 01:44:04.05 kernel  Unix interval timer enabled for sysclk interrupts.
    
18. 00:00000:00000:2008/03/31 01:44:04.06 kernel  engine 0, os pid 5533  online
    

复制代码

这个是防火墙的问题，已经该过来了

shiner

上面的问题已解决，现在还有一个问题：我创建的 adaptive server 如下：

SHINER
        master tcp ether 192.168.112.209 4100
        query tcp ether 192.168.112.209 4100

由于我是在虚拟机的 Red Hat  下安装的，现在在Windows下可以 ping 通 192.168.112.209 ，但就是ping 不通带端口4100的192.168.112.209
就是说Windos下客户端连接不上数据库，这应该杂办呢？
高人再指点啊，谢谢了！

chuxu

Red Hat 是否开了防火墙iptables,，看看是否允许这个端口让外部访问？

shiner

原帖由 chuxu 于 2008-3-31 21:40 发表
Red Hat 是否开了防火墙iptables,，看看是否允许这个端口让外部访问？

恩，谢谢哈，就是这个原因
再问一个问题哈，解决了就给分啦

现在我在起数据库主服务的时候，XP Server 起不来，报如下错：

1. 
   
2. 00:00000:00012:2008/03/31 08:24:40.84 kernel  nspacket: send, Connection refused
   
3. 00:00000:00012:2008/03/31 08:24:40.84 server  Error: 7215, Severity: 18, State: 1
   
4. 00:00000:00012:2008/03/31 08:24:40.84 server  Can't send to site 'SHINER_XP'.
   
5. 00:00000:00014:2008/03/31 08:26:48.60 kernel  Cannot read, host process disconnected: SHINER 3148 spid: 14
   

复制代码

但是在 isql -Usa -P _SSHINER环境下执行exec SHINER_XP...sp_who后，这时XP Server 就会自动起来。
不知道这是怎么回事，正确的情况应该是在启动数据库主服务 SHINER 的时候就把XP Server 同时启动了的。