 | |
Re: I got the coredump error when I use mobilink 10 connect to the oracle
sybase.public.sqlanywhere.linux sybase.public.sqlanywhere.linux
 |
| | Thread Tools | Display Modes |
#21
 
| ||||||
| ||||||
|
Re: I got the coredump error when I use mobilink 10 connect to the oracle -
06-02-2008
, 08:36 PM
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#22
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#23
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#24
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#25
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#26
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#27
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#28
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#29
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
#30
| ||||||
| ||||||
|
|
Nan, 1. Could we possibly see the output of a 'setenv' before starting the MobiLink server? For now, try starting MobiLink from the shell command-line instead of your shell script. (Once we finish investigating the crash, you can go back to the script). my environment variables: |
SQLANY10=/disk2/sqlanywhere10
SHELL=/opt/freeware/bin/bash
TERM=xterm
NLS_LANG=american_america.zhs16cgb231280
SQLANYSH10=/disk2/sqlanywhere10
OLDPWD=/home/oracle
ORA_DB=/disk2/oracle9i/app/ora9.2/dbs
LOCPATH=/usr/lib/nls/loc
USER=oracle
ORACLE_SID=iasora9
ODMDIR=/etc/objrepos
ORACLE_BASE=/disk2/oracle9i/app
TNS_ADMIN=/disk2/oracle9i/app/ora9.2/network/admin
MAIL=/usr/spool/mail/oracle
PATH=/disk2/sqlanywhere10/bin64:/disk2/sqlanywhere10/bin32:/disk2/sqlanyw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/usr/b
in:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
LOGIN=oracle PWD=/home/oracle/sqlanywhere
LANG=en_US
TZ=BEIST-8
ORACLE_TERM=vt100
PS1=\[\e[36;1m\]\u@\[\e[32;1m\]\H:\w> \[\e[0m\]
SHLVL=1
HOME=/home/oracle
ODBCINI=/home/oracle/.odbc.ini
LC__FASTMSG=true
MAILMSG=[YOU HAVE NEW MAIL]
LOGNAME=oracle
CLASSPATH=/disk2/oracle9i/app/ora9.2/JRE/lib:/disk2/oracle9i/app/ora9.2/J
RE/lib/rt.jar:/disk2/oracle9i/app/ora9.2/jlib:/disk2/oracle9i/app/ora9.2/
rdbms/jlib VIMRUNTIME=/opt/freeware/share/vim/vim63
SADIAGDIR=/home/oracle/.sqlanywhere10/diagnostics
ORA_NLS33=/disk2/oracle9i/app/ora9.2/ocommon/nls/admin/data
ORACLE_HOME=/disk2/oracle9i/app/ora9.2
_=/opt/freeware/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/disk2/sqlanywhere10/lib32:/disk2/oracle9i/app/ora9.2/lib:/disk2/
oracle9i/app/ora9.2/ctx/lib
LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib
Quote:
|
2. Assume that the initial configuration is correct: - That /disk2/sqlanywhere10/MobiLink/setup/syncora.sql has been run against the Oracle server. - $ORACLE_HOME = /disk2/oracle9i/app/ora9.2 - $ODBCINI = /path/to/.odbc.ini - $ORACLE_HOME/network/admin/tnsnames.ora is a valid configuration |
oracle and I could syncronized the data by the mobilink on windows
platfrom between this oracle server and a ASA database successfully.
the $ORACLE_HOME, $ODBCINI are all correct. I checked it
.the content of tnsnames.ora is as following:
# TNSNAMES.ORA Network Configuration File:
/disk2/oracle9i/app/ora9.2/network/admin/tnsnames.ora # Generated by
Oracle configuration tools.
INST1_HTTP.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
IASORA9.SYBASE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bjp505)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = iasora9.sybase.com)
)
)
the content of .odbc.ini is :
[iasora9]
Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so
UserID=mobilink
Password=mobilink
SID=iasora9
ProcResults=No
ArraySize=60000
when I started the mobilink at yesterday, the Driver variable was
leading a forword-slash. but I lost it when i post the article
. but Iset the ProcResults yes yesterday, I changed it today.
Quote:
|
i.e. iasora9 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) - That the .odbc.ini reads: [iasora9] Driver=/disk2/sqlanywhere10/lib32/libdboraodbc10_r.so UserID=mobilink Password=mobilink SID=iasora9 ProcResults=No ArraySize=60000 ** NOTE: *** There should be a leading forward-slash to the DRIVER parameter. That wasn't present in the initial post information! ** NOTE: *** ProcResults=No, not "Yes". See: http://www.sybase.com/detail?id=1051962#_Oracle_8_and ================================================== ================ If all of that is correct, we probably need someone to investigate *what* is crashing exactly. Best way (in this scenario specifically, which is a MobiLink crash) is probably to gather a core dump. ================================================== ================ On AIX, to gather a core dump: ------------------------------- * Note: Users can set their ulimit maximums up to the hard limits defined in the /etc/security/limits file that is set by the sysadmin. If you need to exceed those limits, you must have root access to change that file. ------------------------------- 1. Check to see if full core dumps are enabled: % lsattr -El sys0 -a fullcore ** This should return: fullcore true Enable full CORE dump True *** If it doesn't, type (possibly as root): % chdev -l sys0 -a fullcore=true |
lsattr -El sys0 -a fullcore
fullcore true Enable full CORE dump True
Quote:
|
2. Check the output of "ulimit -a" % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 *** Check to ensure that "coredump(blocks)" is set to a value big enough to hold the MobiLink memory space. If it isn't, try setting it to "unlimited": % ulimit -c unlimited % ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 I changed the configuration of my AIX as above: |
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) unlimited
nofiles(descriptors) 2000
Quote:
|
3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" |
, the information on screen is:mlsrv10 -c "DSN=iasora9"
I. 2008-06-03 09:28:56. SQL Anywhere MobiLink Server Version 10.0.1.3609
I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. Copyright (c) 2001-2007, iAnywhere Solutions,
Inc.
Portions copyright (c) 1988-2007, Sybase, Inc.
I. 2008-06-03 09:28:56. All rights reserved. All unpublished rights
reserved. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This software contains confidential and trade
secret information of I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software
and documentation
I. 2008-06-03 09:28:56. by the U.S. Government is subject to
restrictions set forth in a license I. 2008-06-03 09:28:56. agreement
between the Government and iAnywhere Solutions, Inc. or I. 2008-06-03
09:28:56. other written agreement specifying the Government's rights to
use the I. 2008-06-03 09:28:56. software and any applicable FAR
provisions, for example, FAR 52.227-19. I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA I. 2008-06-03 09:28:56.
I. 2008-06-03 09:28:56. This server is licensed to:
I. 2008-06-03 09:28:56. Developer Edition
I. 2008-06-03 09:28:56. Restricted Use
I. 2008-06-03 09:28:56. <Main> Local file for remote synchronization
logs: 'mlsrv.mle' IOT/Abort trap (core dumped)
Quote:
|
*** It crashes in the current directory, then should produce a file named "core" or "core.pid" or similar). 4. Submit the core file to Technical Support. If this is a priority issue, please call 1-800-8SYBASE to open a technical support case (using an existing support plan or open a pay-per-incident case). If this isn't a priority issue, you can submit it to http://case-express.sybase.com (under "Create Bug Report Case" on the left-hand side). Please submit the *core* file, the EXACT *version* and *build* of MobiLink (10.0.1.3609) and your operating system (uname -a). Please keep the core file, as we may need you to generate the stack traces and memory map on your AIX box. Regards, David Fishburn wrote: |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.