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
  #71  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM






Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =



Reply With Quote
  #72  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM






Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #73  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #74  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #75  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #76  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #77  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #78  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #79  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM



Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

Reply With Quote
  #80  
Old   
Phil Mitchell
 
Posts: n/a

Default Re: I got the coredump error when I use mobilink 10 connect to theoracle - 06-04-2008 , 11:55 AM






Yes, we know about this issue with AIX 5.3 TL06. TL07 will work a
little better. The workaround for TL06 is exactly what you did.

Thanks,
Phil

NAN WANG wrote:
Quote:
hi Phil:

I don't know why also. The engineer of the Sybase told me to do
that. The original permission is 555 and my AIX os is :

oslevel -s
5300-06-01-0000

uname -a
AIX bjp505 3 5 0002931AD300 powerpc unknown AIX

If know something, tell me pls

Thanks!

Nan Wang


Phil Mitchell <firstname.lastname (AT) sybase (DOT) com> wrote in
news:48455abd$1@forums-1-dub:

I am a little curious about what led you to changing the permissions
of the libraries. What were they before? I believe that removing
world-execute permission prevents the system from loading the
libraries into its global library cache.

If that's the solution to your problem, it may indicate an either an
OS bug or some sort of conflict that you are running into (perhaps one
that we know about, but likely one that we *need* to know about).
What exact version (including patch level) of AIX are you using?

Thanks,
Phil

NAN WANG wrote:
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/sql
an yw
here10/jre150/bin:/disk2/oracle9i/app/ora9.2/bin:/opt/freeware/bin:/u
sr /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/ora
9. 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:/di
sk 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 =

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.