 | |
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 |
#51
 
| |||
| |||
|
Re: I got the coredump error when I use mobilink 10 connect to theoracle -
06-03-2008
, 09:52 AM
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still  .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#52
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#53
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#54
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#55
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#56
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#57
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#58
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#59
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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: |
#60
| |||
| |||
|
|
hi all : Congratulations!this problem was resolved. There is two steps to do for resolve this problem. 1. change the permission of the library. chmod 640 INSTALLDIR/lib32/* 2. create the libclntsh.so of oracle. copy orainsdir/lib32/libclntsh.a orainsdir/lib/libclntsh.so then you can start the mobilink correctly. Nan Wang NAN WANG <neil.wangnan (AT) gmail (DOT) com> wrote in news:Xns9AB261AB27037.....Neil (AT) 10 (DOT) 22.241.106: Thanks very much for your help. I did all these steps on my AIX, but I got the core dump still .I started the mobilink from the command-line and the information as following: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname (AT) ianywhere (DOT) com wrote in news:48444e6f@forums-1-dub: 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: AUTHSTATE=compat 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/sqlan yw 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:/disk 2/ oracle9i/app/ora9.2/ctx/lib LD_LIBRARY_PATH=/disk2/oracle9i/app/ora9.2/lib:/usr/lib 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 I used the tools on a windwos system to deploy the system table in the 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 . butI set the ProcResults yes yesterday, I changed it today. 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 how i changed the configure of my system: lsattr -El sys0 -a fullcore fullcore true Enable full CORE dump True 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: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) unlimited nofiles(descriptors) 2000 3. Have MobiLink produce a core file: % mlsrv10 -c "DSN=iasora9" I got a core dump still , 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) *** 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.