dbTalk Databases Forums  

Re: I got the coredump error when I use mobilink 10 connect to the oracle

sybase.public.sqlanywhere.linux sybase.public.sqlanywhere.linux


Discuss Re: I got the coredump error when I use mobilink 10 connect to the oracle in the sybase.public.sqlanywhere.linux forum.

Reply
 
Thread Tools Display Modes
  #31  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:






Reply With Quote
  #32  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #33  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #34  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #35  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #36  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #37  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #38  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #39  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
  #40  
Old   
NAN WANG
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to the oracle - 06-03-2008 , 01:16 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:

Quote:
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 . but
I 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:




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.