Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Installation and Configure of Replication Server 12.5 on ASE 12.5 and more..

357 views
Skip to first unread message

True_Colors

unread,
Nov 2, 2006, 12:32:09 PM11/2/06
to
Hello:

I am a student of Chile and i'm learning about ASE 12.5 y RS 12.5 . I
am reading the products manual for them, and all the information i
found about them on internet.

First question:

i want to start to configure ONE replication server, to use with 6
servers ASE than conforms a distributed database system. ¿ It is
posible? I have understood than is posible, could you confirm it and
give me some advice..?


Second Question:

I want to know if is posible to install RS 12.5 on ASE 12.5 ? i have
read than it is posible could you confirm it to me please?


Last Questions....

A person comment to me than on installation RS 12.5 dont ask him for
license. It could be posible? or that person make done a definitively
bad installation of RS 12.5 ? I think than he has mistakes.
Exist some tests or commandos who to enter to verify the operation of
the system. ?

=> other question: RS must be connected to LAN of servers ASE when he
will be installed? .. i have read than all ASE machines of the
distributed database system must be shut down when i should need to
install RS exception the machine where a want to install all components
of RS 12.5, it is true?

Thank a lot !! pleasee help me... !!

True_Colors

unread,
Nov 7, 2006, 12:52:52 PM11/7/06
to
Help me please!!

True_Colors ha escrito:

Qamar

unread,
Nov 14, 2006, 1:15:01 PM11/14/06
to
1. Yes you can configure one replications server to
replicate data from 6 ASE servers. Remember installing Rep
server is one thing and configuring replication server
system (consist of rep server, primary database, replicate
database and .. ) in some thoing else.

2. You can install your Rep server on any machine. System
does not require it to be installed on a machine where ASE
is already installed. BUT you should have an ASE server
running on LAN where you will tell (during installation) to
creatre RSSD. You should know sa password of that ASE
server.

3. Loading binaries will require licence information. After
that if you use rs_init utility to install / configure
replication will not require any key.
There is no need to shut down any server on LAN when you do
installation.

True_Colors

unread,
Nov 15, 2006, 10:30:45 AM11/15/06
to
Qamar. I have understood the answers than you tell me.I needed its
answers to feel me sure about what i think it to do...

At this time i am writing all the information necessary to configure
replication server system.

>>>>>>>>>> Thank you !! <<<<<<<<<<

Ada Carrasco Quezada.


Qamar ha escrito:

True_Colors

unread,
Nov 15, 2006, 2:32:26 PM11/15/06
to
Still I have some doubts. If I desire to install RS 12,5 and ASE 12,5
in a machine with RED HAT Enterprise Edition 3.0 I must install ASE
12,5 first or RS 12.5 first?

On the $SYBASE_OCS environment variable I must assign the directory
of ASE 12,5 (OCS) or the one of RS 12.5 (OCS-12_5) ? Or the best thing
is to install only Replication server on the machine and create RSSD
table in other ASE server than belongs to the same LAN to avoid any
rear problem?

What is your opinion?


True_Colors ha escrito:

Jason L. Froebe [TeamSybase]

unread,
Nov 15, 2006, 4:29:31 PM11/15/06
to
True_Colors wrote:
> Still I have some doubts. If I desire to install RS 12,5 and ASE 12,5
> in a machine with RED HAT Enterprise Edition 3.0 I must install ASE
> 12,5 first or RS 12.5 first?

I would recommend:

1) install ASE 12.5.4
2) apply 12.5.4 esd 2 patch

1) RepServer 12.5
2) apply last RS 12.5 patch

1) apply 12.5.1 esd 15 patch

> On the $SYBASE_OCS environment variable I must assign the directory
> of ASE 12,5 (OCS) or the one of RS 12.5 (OCS-12_5) ? Or the best thing
> is to install only Replication server on the machine and create RSSD
> table in other ASE server than belongs to the same LAN to avoid any
> rear problem?

The $SYBASE_OCS will point to the same directory: $SYBASE/$SYBASE_OCS.
It is always better to have the RSSD and the RepServer on the same
machine.

--
Jason L. Froebe
http://www.froebe.net/blog
http://jfroebe.livejournal.com
Team Sybase

Jason L. Froebe [TeamSybase]

unread,
Nov 15, 2006, 5:14:38 PM11/15/06
to
Jason L. Froebe [TeamSybase] wrote:
> True_Colors wrote:
>> Still I have some doubts. If I desire to install RS 12,5 and ASE 12,5
>> in a machine with RED HAT Enterprise Edition 3.0 I must install ASE
>> 12,5 first or RS 12.5 first?
>
> I would recommend:
>
> 1) install ASE 12.5.4
> 2) apply 12.5.4 esd 2 patch
>
> 1) RepServer 12.5
> 2) apply last RS 12.5 patch
>
> 1) apply 12.5.1 esd 15 patch

oops! that should read apply Software Developer Kit 12.5.1 esd 15
(Openclient)

True_Colors

unread,
Nov 16, 2006, 12:46:33 PM11/16/06
to
Jason. If my team allows me it, i will use the versions and the patchs
of the servers than you recommend to me. If them does not allow to me,
i will follow at least the steps that you recommend to me for the
servers installation and i will leave $SYBASE_OCS environment variable
assigned to OCS directory of ASE. I will create too RSSD in the same
machine of Replication Server.

>>>>>>>>>>Thanks for your advice!!<<<<<<<<<<

Ada Carrasco Quezada.


Jason L. Froebe [TeamSybase] ha escrito:

True_Colors

unread,
Dec 14, 2006, 2:05:52 PM12/14/06
to
I dont know what to do.

I create the environment variables login as sybase user, them i did
logout and login again and check them, but any of those variables
appears as defined.

I use the prefix , and the normal way using the export command.
Anyone could help me?

I want to establish the environment variables of replication servers,v
12.5 and i have a ASE v 12.5.2 working and installed on the same
directory.

True_Colors

unread,
Dec 14, 2006, 9:37:20 PM12/14/06
to
I resolve the previous problem with variables altering the sybase.sh
utilizando vi command of linux.

I use rs_init to configure but now i had other new problem, when i try
to start the server


------------------------------------------
Enter the number of your choice and press return:
Execute the Replication Server tasks now? y
Running task: check the RSSD SQL Server.
Task succeeded: check the RSSD SQL Server.
Running task: configure the Replication Server System Database.
Creating logical device 'trafkinrs_rssd_dat1' for the RSSD database.
Created logical device 'trafkinrs_rssd_dat1' for the RSSD database.
Creating logical device 'trafkinrs_rssd_log1' for the RSSD log.
Created logical device 'trafkinrs_rssd_log1' for the RSSD log.
Creating the Replication Server System Database 'TRAFKINRS_RSSD'.
SQL Server message: msg 1805, level 10, state 2
"CREATE DATABASE: allocating 256000 logical pages (500.0 megabytes) on
disk
'trafkinrs_rssd_dat1'.
"
SQL Server message: msg 1805, level 10, state 2
"CREATE DATABASE: allocating 256000 logical pages (500.0 megabytes) on
disk
'trafkinrs_rssd_log1'.
"
Created database 'TRAFKINRS_RSSD'.
SQL Server message: msg 0, level 10, state 1
"Password correctly set."
SQL Server message: msg 0, level 10, state 1
"Account unlocked."
SQL Server message: msg 0, level 10, state 1
"New login created."
SQL Server message: msg 0, level 10, state 1
"New user added."
Added primary login 'TRAFKINRS_RSSD_prim' to database 'TRAFKINRS_RSSD'
as a
user.
SQL Server message: msg 0, level 10, state 1
"Password correctly set."
SQL Server message: msg 0, level 10, state 1
"Account unlocked."
SQL Server message: msg 0, level 10, state 1
"New login created."
SQL Server message: msg 0, level 10, state 1
"New user added."
Added maintenance user login 'TRAFKINRS_RSSD_maint' to database
'TRAFKINRS_RSSD'.
Loading Replication Server System Database in 'TRAFKIN'. This will take
a few
minutes.
...Done
...Done
......SQL Server message: msg 0, level 10, state 1
"Type added."
..SQL Server message: msg 0, level 10, state 1
"Default bound to column."
SQL Server message: msg 0, level 10, state 1
"Default bound to column."
SQL Server message: msg 0, level 10, state 1
"Default bound to column."
.SQL Server message: msg 0, level 10, state 1
"Default bound to column."
SQL Server message: msg 0, level 10, state 1
"Default bound to column."
.SQL Server message: msg 0, level 10, state 1
"Default bound to column."
SQL Server message: msg 0, level 10, state 1
"Default bound to column."
SQL Server message: msg 0, level 10, state 1
"Default bound to column."
.SQL Server message: msg 0, level 10, state 1
"Default bound to column."
SQL Server message: msg 0, level 10, state 1
"Default bound to column."
.SQL Server message: msg 0, level 10, state 1
"Default bound to column."
.......SQL Server message: msg 0, level 10, state 1
"Default bound to column."
...SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_marker' is set to true."
SQL Server message: msg 0, level 10, state 1
"New group added."
.................................SQL Server message: msg 0, level 10,
state 1
"The replication status for 'rs_classes' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_columns' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_databases' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_erroractions' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_functions' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_objects' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_routes' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_funcstrings' is set to true."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_systext' is set to true."
.SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_cmd_marker' is set to function."
SQL Server message: msg 0, level 10, state 1
"The log mode is set to log_sproc."
SQL Server message: msg 0, level 10, state 1
"The replication status for 'rs_section_marker' is set to function."
SQL Server message: msg 0, level 10, state 1
"The log mode is set to log_sproc."
.SQL Server message: msg 0, level 10, state 1
"Installing rs_get_sitename"
SQL Server message: msg 0, level 10, state 1
"Installing rs_get_classname"
.SQL Server message: msg 0, level 10, state 1
"Installing rs_helpdb"
SQL Server message: msg 0, level 10, state 1
"Installing rs_helprepdb"
SQL Server message: msg 0, level 10, state 1
"Installing rs_helproute"
.Done
Loading Replication Server stored procedures in RSSD 'TRAFKIN'.
Loading script 'rsprocs.sql' into database 'TRAFKINRS_RSSD'.
.....Done
Loaded script 'rsprocs.sql' successfully.
Replication Server System Database loaded successfully in 'TRAFKIN'.
Successfully truncated the log of database 'TRAFKINRS_RSSD'.
Successfully set the truncation point to IGNORE because the Replication
Server
will not hold primary data.
Adding maintenance and primary users to group rs_systabgroup.
SQL Server message: msg 0, level 10, state 1
"Group changed."
SQL Server message: msg 0, level 10, state 1
"Group changed."
Successfully added maintenance and primary users to group
rs_systabgroup.
Task succeeded: configure the Replication Server System Database.
Running task: create the Replication Server configuration file.
Task succeeded: create the Replication Server configuration file.
Running task: create the Replication Server runserver file.
Task succeeded: create the Replication Server runserver file.
Running task: start the Replication Server.
waiting for server 'TRAFKINRS' to boot...

SERVER ERROR: Failed to boot server 'TRAFKINRS'.
Press <return> to continue.


------------------------------------------------------------------------------------------------

-bash-2.05b$ $SYBASE/$SYBASE_REP/RUN_TRAFKINRS
T. 2006/12/14 21:26:31. (-1): ***************STACK TRACE***************
T. 2006/12/14 21:26:31. (-1): *****thread GLOBAL RS(GLOBAL RS)*******
T. 2006/12/14 21:26:32. (-1): pc: 0x846f865, dbg_dump_stack ()
T. 2006/12/14 21:26:32. (-1): pc: 0x80c8dc1, exc__appDumpStack ()
T. 2006/12/14 21:26:32. (-1): pc: 0x80c9dab, exc_terminate ()
T. 2006/12/14 21:26:32. (-1): pc: 0x80c9579, exc_reraise_exception ()
T. 2006/12/14 21:26:32. (-1): pc: 0x80c986e, exc_raise_exception ()
T. 2006/12/14 21:26:32. (-1): pc: 0x80c8051, err_raise_syb_lib_my_maps
()
T. 2006/12/14 21:26:32. (-1): pc: 0x80c7a44, err_raise_syb_lib ()
T. 2006/12/14 21:26:32. (-1): pc: 0x8080ae9, _cfg_set_locale ()
T. 2006/12/14 21:26:32. (-1): pc: 0x807f449, rs_main ()
T. 2006/12/14 21:26:32. (-1): pc: 0x807ee6c, gcc2_compiled. ()
T. 2006/12/14 21:26:32. (-1): pc: 0xb7484748, gcc2_compiled. ()
T. 2006/12/14 21:26:32. (-1): pc: 0x807eda1, _start ()
T. 2006/12/14 21:26:32. (-1): Thread GLOBAL RS(GLOBAL RS) infected with
signal 11
T. 2006/12/14 21:26:32. (-1): Internal error. Attempting to produce a
core file
/opt/sybase-12.5/REP-12_5/RUN_TRAFKINRS: line 6: 17264 Abortado
/opt/sybase-12.5/REP-12_5/bin/repserver -STRAFKINRS
-C/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg
-E/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.log
-I/opt/sybase-12.5/interfaces


-----------------------------------
and the content of my run file

#
# Runserver file for Replication Server 'TRAFKINRS'. Created by
rs_init.
#
/opt/sybase-12.5/REP-12_5/bin/repserver -STRAFKINRS \
-C/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg \
-E/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.log
-I/opt/sybase-12.5/interfaces


---------------------------

Can anyone help me please?

True_Colors

unread,
Dec 14, 2006, 11:01:26 PM12/14/06
to
Here is the log file

'
I. 2006/12/14 20:55:06. Logging messages in file
'/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.log'.
I. 2006/12/14 20:55:06. Using interfaces file
'/opt/sybase-12.5/interfaces'.
I. 2006/12/14 20:55:06. Server name is 'TRAFKINRS'.
W. 2006/12/14 20:55:06. WARNING #18065 GLOBAL RS(GLOBAL RS) -
/servapp.c(131)
SYSAM: returned error code '-2'.
W. 2006/12/14 20:55:06. WARNING #18066 GLOBAL RS(GLOBAL RS) -
/servapp.c(137)
SYSAM: There is no valid license for the Replication Server Product.
Replication Server will continue to run, but please install a valid
license by contacting Sybase Inc.
I. 2006/12/14 20:55:06. Reading
'/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg' for configuration
information.
N. 2006/12/14 20:55:06. INTERNAL ERROR #52 GLOBAL RS(GLOBAL RS) -
servmain.c(1533)
CS-Lib routine 'cs_locale' failed.
N. 2006/12/14 20:55:06. INTERNAL ERROR #1029 GLOBAL RS(GLOBAL RS) -
servmain.c(1533)
CS-Library error: Error: 33818168, Severity 6 -- 'cs_locale: cslib
user api layer: common library error: Failed to map a local name to an
object id!'.
T. 2006/12/14 20:55:06. (-1): ***************STACK TRACE***************
T. 2006/12/14 20:55:06. (-1): *****thread GLOBAL RS(GLOBAL RS)*******
T. 2006/12/14 20:55:06. (-1): pc: 0x846f865, dbg_dump_stack ()
T. 2006/12/14 20:55:06. (-1): pc: 0x80c8dc1, exc__appDumpStack ()
T. 2006/12/14 20:55:06. (-1): pc: 0x80c9dab, exc_terminate ()
T. 2006/12/14 20:55:06. (-1): pc: 0x80c9579, exc_reraise_exception ()
T. 2006/12/14 20:55:06. (-1): pc: 0x80c986e, exc_raise_exception ()
T. 2006/12/14 20:55:06. (-1): pc: 0x80c8051, err_raise_syb_lib_my_maps
()
T. 2006/12/14 20:55:06. (-1): pc: 0x80c7a44, err_raise_syb_lib ()
T. 2006/12/14 20:55:06. (-1): pc: 0x8080ae9, _cfg_set_locale ()
T. 2006/12/14 20:55:06. (-1): pc: 0x807f449, rs_main ()
T. 2006/12/14 20:55:06. (-1): pc: 0x807ee6c, gcc2_compiled. ()
T. 2006/12/14 20:55:06. (-1): pc: 0xb7484748, gcc2_compiled. ()
T. 2006/12/14 20:55:06. (-1): pc: 0x807eda1, _start ()
T. 2006/12/14 20:55:06. (-1): Thread GLOBAL RS(GLOBAL RS) infected with
signal 11
T. 2006/12/14 20:55:06. (-1): Internal error. Attempting to produce a
core file
I. 2006/12/14 21:09:52. 'Replication Server/12.5/P/Linux Intel/Linux
2.4.7-10enterprise i686/1/OPT/Thu Jun 20 23:12:25 2002'
I. 2006/12/14 21:09:52. 'Confidential property of Sybase, Inc.
Copyright 1992, 2002
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.


True_Colors ha escrito:

Mark A. Parsons

unread,
Dec 15, 2006, 12:47:53 AM12/15/06
to
I found a couple solved cases at sybase.com that mention making some changes to various configuration files ... objectid.dat, *.srt, syscharsets.sortfile, etc. ... it all centers around the use of different character sets and/or sort orders between your ASE and RS servers.

You're quickest resolution will probably come from opening a case with Sybase TS.

True_Colors

unread,
Dec 15, 2006, 11:55:31 AM12/15/06
to
Hello Mark

To make the configuration of the servers, i confirmed first, than all
of them had the same language, characters and sort order. Then in it
conditions i start the configuration of Replication Server.

I am still trying to make Replication Server start but the error still
the same.

I've read too the complete answers you give it to other persons
with the same problem, some years ago
<url>http://groups.google.com/group/sybase.public.rep-server/browse_thread/thread/6f12c268b3f7a5d/70156934a09cd03c?lnk=gst&q=objectid.dat&rnum=1#70156934a09cd03c</url>
, i saw the file objectid.dat. I will read again it answer, and i will
search too on sybase.com

If anything helps me, i will install again ASE 12.5.2 y RS 12.5
with the diference than i create his own directory to Replication
Server.

In my country the support service is not so good. T

his pages are the best help i have

------Thank you
.------------------------------------------------------------

i let you here my objectid.dat in case you could see something i dont!

***************************************
; comment character is a semicolon
;
; OBJECTID.DAT
;
; Flat-file database for mapping global object identifiers to local
names.
;
[file format]
version=11.1
list_seperator=,
escape=\

[copyright]
copyright = "Copyright Sybase Inc., 1996, 2001. All rights reserved.\
Use, duplication, or disclosure by the United States
Government\
is subject to restrictions as set forth in FAR subparagraphs\
52.227-19(a)-(d) for civilian agency contracts and DFARS\
252.227-7013(c)(1)(ii) for Department of Defense contracts.\
Sybase reserves all unpublished rights under the copyright\
laws of the United States.\
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608 USA."

;
; Objectid.dat File Format:
;
; object_id = local_name1[, local_name2[,
local_name3[....[,local_namen]...]]]
;
; The object_id is a sequence of non-negative integer values that are
separated
; by a dot(.).
;
; 1.3.6.1.4.1.897 represents enterprises.sybase
;

[charset]
1.3.6.1.4.1.897.4.9.1.1 = iso_1
1.3.6.1.4.1.897.4.9.1.2 = cp850
1.3.6.1.4.1.897.4.9.1.3 = cp437
1.3.6.1.4.1.897.4.9.1.4 = roman8
1.3.6.1.4.1.897.4.9.1.218 = roman9
1.3.6.1.4.1.897.4.9.1.5 = mac
1.3.6.1.4.1.897.4.9.1.140 = eucjis
1.3.6.1.4.1.897.4.9.1.141 = sjis
1.3.6.1.4.1.897.4.9.1.142 = deckanji
1.3.6.1.4.1.897.4.9.1.190 = utf8
1.3.6.1.4.1.897.4.9.1.191 = ucs2
1.3.6.1.4.1.897.4.9.1.9 = cp860
1.3.6.1.4.1.897.4.9.1.13 = cp1252
1.3.6.1.4.1.897.4.9.1.20 = iso88592
1.3.6.1.4.1.897.4.9.1.21 = cp852
1.3.6.1.4.1.897.4.9.1.22 = cp1250
1.3.6.1.4.1.897.4.9.1.23 = mac_ee
1.3.6.1.4.1.897.4.9.1.50 = iso88595
1.3.6.1.4.1.897.4.9.1.51 = cp855
1.3.6.1.4.1.897.4.9.1.52 = cp866
1.3.6.1.4.1.897.4.9.1.53 = cp1251
1.3.6.1.4.1.897.4.9.1.55 = koi8
1.3.6.1.4.1.897.4.9.1.56 = mac_cyr
1.3.6.1.4.1.897.4.9.1.60 = iso88596
1.3.6.1.4.1.897.4.9.1.62 = cp1256
1.3.6.1.4.1.897.4.9.1.66 = cp864
1.3.6.1.4.1.897.4.9.1.70 = iso88597
1.3.6.1.4.1.897.4.9.1.71 = greek8
1.3.6.1.4.1.897.4.9.1.72 = cp869
1.3.6.1.4.1.897.4.9.1.73 = cp1253
1.3.6.1.4.1.897.4.9.1.74 = macgrk2
1.3.6.1.4.1.897.4.9.1.80 = iso88598
1.3.6.1.4.1.897.4.9.1.81 = cp1255
1.3.6.1.4.1.897.4.9.1.90 = iso88599
1.3.6.1.4.1.897.4.9.1.91 = turkish8
1.3.6.1.4.1.897.4.9.1.92 = cp1254
1.3.6.1.4.1.897.4.9.1.93 = cp857
1.3.6.1.4.1.897.4.9.1.94 = macturk
1.3.6.1.4.1.897.4.9.1.100 = tis620
1.3.6.1.4.1.897.4.9.1.101 = cp874
1.3.6.1.4.1.897.4.9.1.144 = cp932
1.3.6.1.4.1.897.4.9.1.150 = eucksc
1.3.6.1.4.1.897.4.9.1.160 = euccns
1.3.6.1.4.1.897.4.9.1.161 = big5
1.3.6.1.4.1.897.4.9.1.165 = cp950
1.3.6.1.4.1.897.4.9.1.170 = eucgb
1.3.6.1.4.1.897.4.9.1.171 = cp936
1.3.6.1.4.1.897.4.9.1.166 = hpbig5
1.3.6.1.4.1.897.4.9.1.168 = big5hk
1.3.6.1.4.1.897.4.9.1.14 = iso15
1.3.6.1.4.1.897.4.9.1.30 = cp1257
1.3.6.1.4.1.897.4.9.1.120 = cp1258
1.3.6.1.4.1.897.4.9.1.200 = iso14

[natlang]
;The language are coded based on language codes defined in the ISO 639.

;ISO 639 assign three characters to each language. We use the
sequential
;number of the each letter to form a six digits code to use as the
;language codes.
; eng
1.3.6.1.4.1.897.4.9.2.051407 = us_english, english
; fra
1.3.6.1.4.1.897.4.9.2.061801 = french
; ger
1.3.6.1.4.1.897.4.9.2.070518 = german
; jpn
1.3.6.1.4.1.897.4.9.2.101614 = japanese
; esl
1.3.6.1.4.1.897.4.9.2.051912 = spanish
; zho
1.3.6.1.4.1.897.4.9.2.260815 = chinese
; kor
1.3.6.1.4.1.897.4.9.2.111518 = korean
; por
1.3.6.1.4.1.897.4.9.2.161518 = portuguese, portugue
; pol
1.3.6.1.4.1.897.4.9.2.161512 = polish
; tha
1.3.6.1.4.1.897.4.9.2.200801 = thai

[collate]
;Sort orders whose names are greater than eight characters in length
are
;abbreviated to support 8.3 file naming conventions on MS-DOS related
;platforms. Note that multiple sort order names associated with a
single
;object id do *not* represent aliases for each other; when setting an
;application's sort order, you *must* specify the appropriate sort
order name
;for the given platform. For example, 'dictiona' must be used for only
those
;platforms with an 8.3 file naming convention restriction; 'dictionary'
must
;be used for all other platforms.
1.3.6.1.4.1.897.4.9.3.50 = binary
1.3.6.1.4.1.897.4.9.3.51 = dictionary, dictiona
1.3.6.1.4.1.897.4.9.3.52 = nocase
1.3.6.1.4.1.897.4.9.3.53 = nocasepref, nocasepr
1.3.6.1.4.1.897.4.9.3.54 = noaccents, noaccent

[secmech]
1.3.6.1.4.1.897.4.6.1 = dce
1.3.6.1.4.1.897.4.6.2 = nds
1.3.6.1.4.1.897.4.6.3 = NTLM
1.3.6.1.4.1.897.4.6.6 = csfkrb5
*********************************************************************************


Mark A. Parsons ha escrito:

Mark A. Parsons

unread,
Dec 15, 2006, 7:43:14 PM12/15/06
to
I can't promise anything so FWIW ...

- post the contents of 'sp_helpsort' from your ASE
- post your RS *.cfg file

Message has been deleted

True_Colors

unread,
Dec 15, 2006, 11:07:30 PM12/15/06
to
Hello Mark:

This is the information you ask me for:

The name of my ASE is TRAFKIN and this is the result of sp_helpsort at
isql

1> sp_helpsort
2> go

Collation Name Collation ID
------------------------------ ------------
defaultml 20
thaidict 21
iso14651 22
utf8bin 24
binary 25
altnoacc 39
altdict 45
altnocsp 46
scandict 47
scannocp 48
dict 51
nocase 52
nocasep 53
noaccent 54
espdict 55
espnocs 56
espnoac 57
rusnocs 59
cyrnocs 64
elldict 65
hundict 69
hunnoac 70
hunnocs 71
turknoac 73
turknocs 74

Loadable Sort Table Name Collation ID
------------------------------ ------------
cp932bin 129
dynix 130
gb2312bn 137
cyrdict 140
turdict 155
euckscbn 161
gbpinyin 163
rusdict 165
sjisbin 179
eucjisbn 192
big5bin 194

Sort Order Description

------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 57, espnoaccents_iso_1
Spanish case-insensitive dictionary sort order for use with Sp
anish and most Latin American locales. Uses the ISO 8859-1 ch
aracter set. Diacritical marks are ignored.
Characters, in Order

------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | }
~ ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ
¶ · ¸ ¹ º » ¼ ½ ¾
¿ × ÷ 0 1 2 3 4 5 6 7 8 9 A=a=À=Á=Â=Ã=Ä=Å=à=á=â=ã=ä=å
Æ=æ B=b C
=c=Ç=ç D=d E=e=È=É=Ê=Ë=è=é=ê=ë F=f G=g H=h
I=i=Ì=Í=Î=Ï=ì=í=î=ï J
=j K=k L=l M=m N=n Ñ=ñ O=o=Ò=Ó=Ô=Õ=Ö=Ø=ò=ó=ô=õ=ö=ø P=p
Q=q R=r S
=s ß T=t U=u=Ù=Ú=Û=Ü=ù=ú=û=ü V=v W=w X=x Y=y=Ý=ý=ÿ Z=z
Ð=ð Þ=þ

(return status = 0)

1>

--------------------------------------------------------------------------------------------------------------------

The configuration file of my RS is...
--------------------------------------------------------------------------------------------------------------------
#
# Configuration file for Replication Server 'TRAFKINRS'. Created by
rs_init.
#
RSSD_server=TRAFKIN
RSSD_database=TRAFKINRS_RSSD
RSSD_primary_user=TRAFKINRS_RSSD_prim
RSSD_primary_pw=password
RSSD_maint_user=TRAFKINRS_RSSD_maint
RSSD_maint_pw=password
RSSD_ha_failover=no
ID_server=TRAFKINRS
ID_user=TRAFKINRS_id_user
ID_pw=password
RS_charset=iso_1
RS_language=us_english
RS_sortorder=espnoac

----------------------------------------------------------------------------------------------------------------------------

Thank you again!! :) :) :)

:) :)

Mark A. Parsons

unread,
Dec 16, 2006, 6:26:27 PM12/16/06
to
sp_helpsort is showing that you're using the espnoaccents sort order ... which has a sort order id = 57.

'sort order' is also referred to as a collation order or sequence; point being that if we take the '57' and look in the top most table (Collation Name, Collation ID) we see that 57 matches with:

Collation Name Collation ID
============== ============
espnoac 57

We'll need this name/ID (espnoac/57) going forward.

-----------------------------

Doublechecking the RS config file we see that you're also using the 'espnoac' sort order here, too ... that's good ... ASE and RS are using the same/compatible sort orders.

Though the ASE and RS do *NOT* have to use the same exact sort order it does tend to make things easeier when they *DO* have the same (or compatible) sort orders (and character sets).

-----------------------------

This leaves us with the objectid.dat file ...

If we look in the '[collate]' section we see that there are entries for collation ID's ranging from 50 to 54:

1.3.6.1.4.1.897.4.9.3.50 = binary
1.3.6.1.4.1.897.4.9.3.51 = dictionary, dictiona
1.3.6.1.4.1.897.4.9.3.52 = nocase
1.3.6.1.4.1.897.4.9.3.53 = nocasepref, nocasepr
1.3.6.1.4.1.897.4.9.3.54 = noaccents, noaccent

Notice there's no entry for collation ID = 57.

So our first attempt at addressing your RS startup problem will be to add an entry to the '[collate]' section for your espnoac/57 sort order:
(see the last line)

1.3.6.1.4.1.897.4.9.3.50 = binary
1.3.6.1.4.1.897.4.9.3.51 = dictionary, dictiona
1.3.6.1.4.1.897.4.9.3.52 = nocase
1.3.6.1.4.1.897.4.9.3.53 = nocasepref, nocasepr
1.3.6.1.4.1.897.4.9.3.54 = noaccents, noaccent

1.3.6.1.4.1.897.4.9.3.57 = espnoac

Add the last line to your objectid.dat file, save the changes, and try to start up your RS.

----------------------------

If your RS still won't startup then post back here with the following:

1 - complete set of error messages/stack traces related to the latest failed startup

2 - verify that the following line is in your $SYBASE/charsets/iso_1/espnoac.srt file:

(should be near the top of the file)

id = 0x39 ; Unique ID # (57) for the sort order

3 - post the results of the following query (run in your ASE):

================
use master
go
select name, sortfile
from syscharsets
where name like '%espnoac%'
go
================

4 - make sure you have at least one blank line at the end of your RS.cfg file (basically want to make sure there's a carriage return after the 'RS_sortorder' entry to make sure the RS has no problems reading the file)


... snip ...


>>>
>>>i let you here my objectid.dat in case you could see something i dont!
>>>
>>>***************************************

... snip ...

... snip ...

>>> 1.3.6.1.4.1.897.4.9.3.50 = binary
>>> 1.3.6.1.4.1.897.4.9.3.51 = dictionary, dictiona
>>> 1.3.6.1.4.1.897.4.9.3.52 = nocase
>>> 1.3.6.1.4.1.897.4.9.3.53 = nocasepref, nocasepr
>>> 1.3.6.1.4.1.897.4.9.3.54 = noaccents, noaccent
>>>
>>>[secmech]
>>> 1.3.6.1.4.1.897.4.6.1 = dce
>>> 1.3.6.1.4.1.897.4.6.2 = nds
>>> 1.3.6.1.4.1.897.4.6.3 = NTLM
>>> 1.3.6.1.4.1.897.4.6.6 = csfkrb5
>>>*********************************************************************************


... snip ...

True_Colors

unread,
Dec 18, 2006, 1:10:19 PM12/18/06
to
Mark!!

I did the changes you tell me, and rs_init works perfectly. But when
i do try to start Replication Server , i receive errors!!

_______________________________________________________________
Here the messages of rs_init
----------------------------------------------------------------------------------------------------------------


Enter the number of your choice and press return:
Execute the Replication Server tasks now? y
Running task: check the RSSD SQL Server.
Task succeeded: check the RSSD SQL Server.
Running task: configure the Replication Server System Database.

Verified that the primary user 'TRAFKINRS_RSSD_prim' is defined in
database
'TRAFKINRS_RSSD'.
Verified that the maintenance user 'TRAFKINRS_RSSD_maint' is defined in


database
'TRAFKINRS_RSSD'.
Loading Replication Server System Database in 'TRAFKIN'. This will take
a few
minutes.
...Done
...Done
......SQL Server message: msg 0, level 10, state 1

"Type has been dropped."


SQL Server message: msg 0, level 10, state 1

Existing Configuration file
'/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.bak' renamed
to '/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.005'.
Existing Configuration file
'/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg' renamed
to '/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.bak'.


Task succeeded: create the Replication Server configuration file.
Running task: create the Replication Server runserver file.
Task succeeded: create the Replication Server runserver file.
Running task: start the Replication Server.
waiting for server 'TRAFKINRS' to boot...

Task succeeded: start the Replication Server.
Running task: configure the Replication Server.
Adding partition 'part1'.
Successfully added partition 'part1'.
Connecting to Replication Server and defining users for LTM/Replication
Agent
and other Replication Servers.
Successfully defined users in Replication Server.
Task succeeded: configure the Replication Server.

Configuration completed successfully.
Press <return> to continue.
-----------------------------------------------------------------------------------------------------------------------------

Here is the information that you ask me, in case my RS still won't
startup!!

*********************************************
1
Here is the complete log error !!

**********************************************
This software contains confidential and trade secret information of
Sybase,
Inc. Use, duplication or disclosure of the software and
documentation by
the U.S. Government is subject to restrictions set forth in a
license
agreement between the Government and Sybase, Inc. or other
written
agreement specifying the Government's rights to use the software and
any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
'
I. 2006/12/18 13:18:16. Logging messages in file
'/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.log'.
I. 2006/12/18 13:18:17. Using interfaces file
'/opt/sybase-12.5/interfaces'.
I. 2006/12/18 13:18:17. Server name is 'TRAFKINRS'.
W. 2006/12/18 13:18:17. WARNING #18065 GLOBAL RS(GLOBAL RS) -


/servapp.c(131)
SYSAM: returned error code '-2'.

W. 2006/12/18 13:18:17. WARNING #18066 GLOBAL RS(GLOBAL RS) -


/servapp.c(137)
SYSAM: There is no valid license for the Replication Server Product.
Replication Server will continue to run, but please install a valid
license by contacting Sybase Inc.

I. 2006/12/18 13:18:17. Reading
'/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg' for configuration
information.
I. 2006/12/18 13:18:17. Using the 'iso_1' character set.
I. 2006/12/18 13:18:17. Using the 'us_english' language.
I. 2006/12/18 13:18:17. Using the 'espnoac' sort order.
I. 2006/12/18 13:18:17. Using the 'binary' unicode sort order.
I. 2006/12/18 13:18:17. Using server 'TRAFKINRS' for an ID Server.
I. 2006/12/18 13:18:17. Using config file password for the ID user.
I. 2006/12/18 13:18:17. Using user 'TRAFKINRS_id_user' for the ID
Server.
I. 2006/12/18 13:18:17. Using config file maintenance password for the
RSSD maint user.
I. 2006/12/18 13:18:17. RSSD maintenace user is 'TRAFKINRS_RSSD_maint'.
I. 2006/12/18 13:18:17. Using config file password for the RSSD primary
user.
I. 2006/12/18 13:18:17. RSSD primary user is 'TRAFKINRS_RSSD_prim'.
I. 2006/12/18 13:18:17. RSSD database is 'TRAFKINRS_RSSD'.
I. 2006/12/18 13:18:17. RSSD server is 'TRAFKIN'.
I. 2006/12/18 13:18:18. Reading 'TRAFKIN.TRAFKINRS_RSSD..rs_config' for
system configuration parameters.
I. 2006/12/18 13:18:18. Value of the 'memory_limit' config parameter
is: 20 megabytes.
I. 2006/12/18 13:18:18. Maximum outbound connections allowed: 64.
I. 2006/12/18 13:18:18. System outbound connection fadeout time: '30'.
I. 2006/12/18 13:18:18. System table cache size: 100 rows.
I. 2006/12/18 13:18:18. Maximum number of Open Server threads allowed:
50.
I. 2006/12/18 13:18:18. Maximum number of Open Server mutexes allowed:
128.
I. 2006/12/18 13:18:18. Maximum number of incoming client connections
allowed: 30.
I. 2006/12/18 13:18:18. Maximum number of Open Server message queues
allowed: 178.
I. 2006/12/18 13:18:18. Maximum number of Open Server messages allowed:
45568.
I. 2006/12/18 13:18:18. Maximum number of stable queues allowed: 32.
I. 2006/12/18 13:18:18. Password encryption option: 0.
I. 2006/12/18 13:18:18. Use SSL service is set to 'off'.
I. 2006/12/18 13:18:18. Default for connection ha_failover is set to
'off',
I. 2006/12/18 13:18:18. Default directory service provider is:
'InterfacesDriver'.
I. 2006/12/18 13:18:18. System configuration complete.
I. 2006/12/18 13:18:18. Server using Open Server version Sybase
Server-Library/12.5/P-EBF10090-10089/DRV.12.5.0.1/Linux Intel/Linux
2.2.14-5.0smp i686/BUILD125-012/OPT/Wed Feb 27 13:53:21 2002
I. 2006/12/18 13:18:18. Server using Open Client version Sybase
Client-Library/12.5/P-EBF10089/DRV.12.5.0.1/Linux Intel/Linux
2.2.14-5.0smp i686/BUILD125-012/OPT/Wed Feb 27 13:52:38 2002
T. 2006/12/18 13:18:18. (-1): Thread GLOBAL RS(GLOBAL RS) infected with
signal 11
T. 2006/12/18 13:18:19. (-1): ***************STACK TRACE***************
T. 2006/12/18 13:18:19. (-1): *****thread GLOBAL RS(GLOBAL RS)*******
T. 2006/12/18 13:18:19. (-1): pc: 0x846f9cd, dbg_dump_stack ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80c8dc1, exc__appDumpStack ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80c9dab, exc_terminate ()
T. 2006/12/18 13:18:19. (-1): pc: 0x808acd1, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0xb7496be8, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x81f864a, srv_thread_props ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80c1af5, err_handle_srverr ()
T. 2006/12/18 13:18:19. (-1): pc: 0x81e6a5e, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x820d058, srv__start_net ()
T. 2006/12/18 13:18:19. (-1): pc: 0x81fcdc1, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80802d4, rs_main ()
T. 2006/12/18 13:18:19. (-1): pc: 0x807ee6c, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0xb7484748, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x807eda1, _start ()
*******************************************************************************************

Here the messages of the shell ....

-bash-2.05b$ cd $SYBASE/$SYBASE_REP
-bash-2.05b$ $SYBASE/$SYBASE_REP/RUN_TRAFKINRS
T. 2006/12/18 13:18:18. (-1): Thread GLOBAL RS(GLOBAL RS) infected with
signal 11
T. 2006/12/18 13:18:19. (-1): ***************STACK TRACE***************
T. 2006/12/18 13:18:19. (-1): *****thread GLOBAL RS(GLOBAL RS)*******
T. 2006/12/18 13:18:19. (-1): pc: 0x846f9cd, dbg_dump_stack ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80c8dc1, exc__appDumpStack ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80c9dab, exc_terminate ()
T. 2006/12/18 13:18:19. (-1): pc: 0x808acd1, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0xb7496be8, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x81f864a, srv_thread_props ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80c1af5, err_handle_srverr ()
T. 2006/12/18 13:18:19. (-1): pc: 0x81e6a5e, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x820d058, srv__start_net ()
T. 2006/12/18 13:18:19. (-1): pc: 0x81fcdc1, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x80802d4, rs_main ()
T. 2006/12/18 13:18:19. (-1): pc: 0x807ee6c, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0xb7484748, gcc2_compiled. ()
T. 2006/12/18 13:18:19. (-1): pc: 0x807eda1, _start ()
/opt/sybase-12.5/REP-12_5/RUN_TRAFKINRS: line 6: 24230 Violación de
segmento /opt/sybase-12.5/REP-12_5/bin/repserver -STRAFKINRS
-C/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg
-E/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.log
-I/opt/sybase-12.5/interfaces
------------------------------------------------------------------------------------------------------------------------------

2
I checked the file espnoac.srt and he contains the lines you ask at the
top of the file, if you needed i can post this file complete..
*********************************************

class = 0x01 ; Class `1' sort order


id = 0x39 ; Unique ID # (57) for the sort order

name = espnoaccents_iso_1 ; Spanish case-insensitive, no diacriticals
menuname = "Spanish case and accent insensitive dictionary order."
charset = iso_1
preference = false ; Do NOT use preference with order by

description = "Spanish case-insensitive dictionary sort order for use
with\
Spanish and most Latin American locales. Uses the ISO 8859-1 character


set.\
Diacritical marks are ignored."


**************************************************

3

This are the results of the query you ask me.

******************************************

1> use master
2> go
1> select name, sortfile
2> from syscharsets
3> where name like '%espnoac%'
4> go
name sortfile
------------------------------ ------------------------------
espnoaccents_iso_1 NULL
espnoac NULL

(2 rows affected)
1>

***********************************

4

I created a empty line at the end of the configuration file, i tried
again to start the server but i receive the same stack trace messages

**********************************

Thank you by help me!!

:) :) :) :) :)

..............................................................................................................


Mark A. Parsons ha escrito:

> sp_helpsort is showing that you're using the espnoaccents sort order ... which has a sort order id = 57.

Mark A. Parsons

unread,
Dec 18, 2006, 6:30:08 PM12/18/06
to
One last step we can try before I'm out of ideas ...

Log into your ASE and issue the following:

==============================
sp_configure 'allow updates', 1
go

use master
go

begin tran
go

-- verify only one record is updated

update syscharsets
set sortfile = 'espnoac.srt'
where name = 'espnoaccents_iso_1'
go

-- verify following select reflects the
-- change made by the update

select name,sortfile
from syscharsets
where name = 'espnoaccents_iso_1'
go

-- if only 1 record updated and it was the correct
-- record that was updated then

commit tran

-- else

rollback tran
go

sp_configure 'allow updates', 0
go
==============================


If your repserver still won't start up properly at this point the only other options I can think of are:

a) contact Sybase TS

b) consider upgrading your RS to the latest EBF release for 12.5 (or 12.6); no guarantee the upgrade will fix your problem but there are a series of cases in solved cases (@ sybase.com) which refer to bugs (similar to yours) being fixed in newer RS versions.


True_Colors wrote:

>>Doublechecking the RS config file we see that you're also using the 'espnoac' sort order here, too ... that's good .... ASE and RS are using the same/compatible sort orders.

True_Colors

unread,
Dec 18, 2006, 9:48:44 PM12/18/06
to
Helllo Mark

I realized the update and confirmed the entries

1> select name,sortfile
2> from syscharsets
3> where name='espnoaccents_iso_1'


4> go
name sortfile
------------------------------ ------------------------------

espnoaccents_iso_1 espnoac.srt

(1 row affected)


later, i use sp_configure to establish allow updates in false

Then i try to start the server, but it does not start. Only shows this
messages...

-bash-2.05b$ $SYBASE/$SYBASE_REP/RUN_TRAFKINRS
T. 2006/12/18 21:42:16. (-1): Thread GLOBAL RS(GLOBAL RS) infected with
signal 11
T. 2006/12/18 21:42:16. (-1): ***************STACK TRACE***************
T. 2006/12/18 21:42:16. (-1): *****thread GLOBAL RS(GLOBAL RS)*******
T. 2006/12/18 21:42:16. (-1): pc: 0x846f9cd, dbg_dump_stack ()
T. 2006/12/18 21:42:16. (-1): pc: 0x80c8dc1, exc__appDumpStack ()
T. 2006/12/18 21:42:16. (-1): pc: 0x80c9dab, exc_terminate ()
T. 2006/12/18 21:42:16. (-1): pc: 0x808acd1, gcc2_compiled. ()
T. 2006/12/18 21:42:16. (-1): pc: 0xb7496be8, gcc2_compiled. ()
T. 2006/12/18 21:42:16. (-1): pc: 0x81f864a, srv_thread_props ()
T. 2006/12/18 21:42:16. (-1): pc: 0x80c1af5, err_handle_srverr ()
T. 2006/12/18 21:42:16. (-1): pc: 0x81e6a5e, gcc2_compiled. ()
T. 2006/12/18 21:42:16. (-1): pc: 0x820d058, srv__start_net ()
T. 2006/12/18 21:42:16. (-1): pc: 0x81fcdc1, gcc2_compiled. ()
T. 2006/12/18 21:42:16. (-1): pc: 0x80802d4, rs_main ()
T. 2006/12/18 21:42:16. (-1): pc: 0x807ee6c, gcc2_compiled. ()
T. 2006/12/18 21:42:16. (-1): pc: 0xb7484748, gcc2_compiled. ()
T. 2006/12/18 21:42:16. (-1): pc: 0x807eda1, _start ()
/opt/sybase-12.5/REP-12_5/RUN_TRAFKINRS: line 6: 24396 Violación de


segmento /opt/sybase-12.5/REP-12_5/bin/repserver -STRAFKINRS
-C/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.cfg
-E/bdatos/sybase-12.5/REP-12_5/TRAFKINRS.log
-I/opt/sybase-12.5/interfaces

.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.


Thank you by your help. At least we try.

I think the installation of my server was not well done, by the person
on charge. So i will do a reinstallation, if i dont find how to solve
this problems until tomorrow afternoon.

Thanks by your time too... :) :)


.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.

Senor

unread,
Dec 24, 2006, 5:12:38 PM12/24/06
to
Another thing you should look into:

Linux hosts by default have their LOCALE set to UTF-8; In the sybase rep
server distribution, you have a directory for utf8, which is lower case
and without the hyphen. That is probably where your problem is.

Verify by running the command: echo $LANG.

A quick fix is to set the LANG variable before starting the Rep Server.
For example, here in the U.S., we would set LANG=us_english.utf8.

A better fix is to create a symbolic link in the charset directory for
UTF-8 to point to utf8.

True_Colors

unread,
Dec 26, 2006, 10:01:35 AM12/26/06
to
Thank you by your message Senor. In this moment am waiting to
reinstall the servers, because the files of ASE and RepServer have
been deleted.

If i still have the same problems when i reinstall i will use your
idea.

Thank you!!

Ada.


Senor ha escrito:

True_Colors

unread,
Dec 27, 2006, 11:17:03 PM12/27/06
to
I reinstalled the servers ...

My ASE is on the directory /opt/sybase-12.5 and he is running
My RS is on the directory /opt/rep-12.5


But now i have a question before try to configure the RS.

¿How i must to define the enviroment?

If i define

SYBASE=/opt
SYBASE_ASE=sybase-12.5/ASE
SYBASE_FTS=sybase-12.5/FTS
SYBASE_OCS=sybase-12.5/OCS
SYBASE_SYSAM=sybase-12.5/SYSAM
SYBASE _REP=rep-12.5
SYBASE_RSM=RSM-12_5

I dont have access to my ASE using isql because it needs the object id
on /opt/sybase-12.5/config
-------------------------------------------------------------------------------------------------------------------
-bash-2.05b$ echo $PATH
/opt/rep-12.5/ASE/bin:/opt/rep-12.5/OCS/bin:/opt/rep-12.5/SYSAM/bin:/opt/rep-12.5/shared/jre/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.:/opt/sybase-12.5/bin:/opt/rep-12.5:/opt/rep-12.5/bin

-bash-2.05b$ isql -Usa -STRAFKIN

The context allocation routine failed when it tried to load
localization files!!
One or more following problems may caused the failure

Your sybase home directory is /opt. Check the environment variable
SYBASE if it is not the one you want!
Cannot access file /opt/config/objectid.dat
----------------------------------------------------------------------------------------------------------------------

Maybe i can do this....I think this may cause error messages...


SYBASE=/opt/sybase-12.5
SYBASE_ASE=ASE
SYBASE_FTS=FTS
SYBASE_OCS=OCS
SYBASE_SYSAM=SYSAM
SYBASE _REP= /opt/rep-12.5 (I think this line is bad)
SYBASE_RSM=RSM-12_5


Can anybody tell me how to do this ...?

------------------------------------------------------------------------------------------------------------------
How do i manage the interfaces file , now i have 2 , one with
information(on sybase-12.5 directory) and another empty. (on rep-12.5
directory) . I think them must be on the same conditions...and
sybase.sh?

¿?¿?¿?¿?¿?¿?¿?¿?¿¿??

---------------------------------------------------------------------------------------------------------------------------


True_Colors ha escrito:

Message has been deleted

True_Colors

unread,
Dec 28, 2006, 2:03:04 AM12/28/06
to
I edited interfaces file of rep-12.5 directory, adding the ASE
server using dscp, and now i can enter to ASE using isql on rep-12.5
directory.

But i still have the doubt about the environments variables, before use
rs_init for RS server.

If I use this:

SYBASE=/opt
SYBASE_ASE=sybase-12.5/ASE
SYBASE_FTS=sybase-12.5/FTS
SYBASE_OCS=sybase-12.5/OCS
SYBASE_SYSAM=sybase-12.5/SYSAM

SYBASE_REP=rep-12.5/REP-12_5
SYBASE_RSM=rep-12.5/RSM-12_5


should work?


True_Colors ha escrito:
True_Colors ha escrito:

Mark A. Parsons

unread,
Dec 28, 2006, 8:04:01 AM12/28/06
to
Each of the software installation directories (/opt/sybase-12.5, /opt/rep-12.5) should have their own resource and interfaces files; use them.

Mixing your environment variables (as you've done below) is usually not a good idea. (I'm not saying it can't be done ... but you really need to understand how and when all of the variables are used.)

Your best bet would be to do something like the following:

1 - put a master interfaces file in /opt, with links from /opt/sybase-12.5/interfaces and /opt/rep-12.5/interfaces pointing at /opt/interfaces (this allows you to utilize just one interfaces file; one drawback is that dscp may trash your links so you'll either have to a) edit /opt/interfaces by hand or b) re-link the files after using dscp)

2a - when you want to work with ASE (eg, startup the dataserver) then source the /opt/sybase-12.5/SYBASE.[sh|csh] environment file

2b - when you want to work with RS (eg, startup the repserver) then source the /opt/rep-12.5/SYBASE.[sh|csh] environment file

3 - don't mix-n-match environment settings between the 2 environments (ie, don't modify the environment files to reference directories in the other installation)

4 - for common command line utilities (eg, isql, bcp, defncopy) just use the ASE environment files; ASE's 'isql' will work just fine for accessing a repserver

------------------------

Alternatively, since you're running version 12.5 of both products you could probably get away with installing both in the same directory.

One caveat is that you'll need to make sure the common directories (eg, OCS, shared, SYSAM, etc) have the latest/greatest updates. For example, you wouldn't want to load RS 12.5 EBF #3 followed by ASE 12.5 IR ... chances are the ASE 12.5 IR installation will wipe out the newer OCS files installed by RS 12.5 EBF #3. If this is too confusing ... then don't mix the directories.

------------------------

At several of my clients we eliminate most of our issues by installing each version of Sybase software in it's own directory structure ... then just access the appropriate resource file when we want to work with the desired software package.

If we need to use 'isql' to log into different products from the same session (eg, batch/shell script) ... just source one of the newer resource files ... 'isql' should have no problems accessing any of the products.

Mark A. Parsons

unread,
Dec 28, 2006, 8:34:41 AM12/28/06
to
For rs_init ... source the resource file in the /opt/rep-12.5 directory. (I'm assuming at this point you haven't messed up said resource file.)

Everything (except the interfaces entries) rs_init needs to do it's job should already exist in the /opt/rep-12.5 directory ... so use the resource file from this directory structure.

Your only issue should be the interfaces entry(s) for your ASE(s), in which case you can:

a) copy your ASE entries from the sybase-12.5/interfaces file into the rep-12.5/interfaces file

or

b) setup a master interfaces file in /opt/interfaces and setup links to this file from each installation directory

True_Colors

unread,
Dec 28, 2006, 11:20:49 AM12/28/06
to
Mark:

You told me exactly what i need to know about the environments
variables (when those are needed) . Yesterday i copy all the entries of
/optsybase-12.5 to /opt/rep-12.5 using dscp.

Thank you a lot.!

True_Colors

unread,
Jan 5, 2007, 1:43:45 PM1/5/07
to

I installed EBF 10914 for my RS and now i get this message ...


F. 2007/01/05 14:35:04. FATAL ERROR #1030 GLOBAL RS(GLOBAL RS) -
/errhand.c(730)
Open Server error: Error: 16029, State: 0, Severity 20 -- 'Failed to
start any network listeners'.
T. 2007/01/05 14:35:04. (-1): Exiting due to a fatal error


what do you think about it?

True_Colors ha escrito:

True_Colors

unread,
Jan 5, 2007, 1:59:29 PM1/5/07
to
I check the port and maybe the message is because it is already listen

-bash-2.05b$ netstat -an | grep 5050
tcp 0 0 146.83.204.205:5050 0.0.0.0:*
LISTEN
-bash-2.05b$

how do i change it?


True_Colors ha escrito:

True_Colors

unread,
Jan 5, 2007, 2:03:56 PM1/5/07
to
My Run server file is ..

#
# Runserver file for Replication Server 'TRAFKINRS'. Created by
rs_init.
#
/opt/rep-12.5/REP-12_5/bin/repserver -STRAFKINRS \
-C/opt/rep-12.5/REP-12_5/TRAFKINRS.cfg
-E/opt/rep-12.5/REP-12_5/TRAFKINRS.log \
-I/opt/rep-12.5/interfaces

---------------------------------------------------------

My sybase variable is /opt/rep-12.5 and i have interfaces file on it.


TRAFKIN
master tcp ether trafkin 5000
query tcp ether trafkin 5000


TRAFKIN_BS
master tcp ether trafkin 5001
query tcp ether trafkin 5001

TRAFKIN_MS
master tcp ether trafkin 5002
query tcp ether trafkin 5002

TRAFKIN_XP
master tcp ether trafkin 5003
query tcp ether trafkin 5003

TRAFKIN_TEXT
master tcp ether trafkin 5004
query tcp ether trafkin 5004


TRAFKINRS
master tcp ether trafkin 5050
query tcp ether trafkin 5050


True_Colors ha escrito:

True_Colors

unread,
Jan 5, 2007, 2:29:37 PM1/5/07
to
SSH Secure Shell 3.2.2 (Build 269)
Copyright (c) 2000-2002 SSH Communications Security Corp -
http://www.ssh.com/

This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.


-bash-2.05b$ isql -Usa -STRAFKINRS
Password:
1> admin version
2> go
Version


-----------------------------------------------------------------------------------------------------------------

Replication Server/12.5/EBF 10914 ESD#1/Linux Intel/Linux
2.4.7-10enterprise i68
6/1/OPT/Thu Feb 13 11:01:38 2003

It woks!!!

Thank a lot to everybody !! :) :) :) am so happy !! :)


thanksss...


True_Colors ha escrito:

Mark A. Parsons

unread,
Jan 5, 2007, 6:49:34 PM1/5/07
to
Is the repserver already up and running (ie, the network port is already in use)?

What else shows up in the RS errorlog prior to this error message?

Did you install the EBF into a different directory structure (ie, a different $SYBASE) and if so, is the resource file (eg, SYBASE.sh) accurate?

True_Colors

unread,
Jan 6, 2007, 12:07:00 AM1/6/07
to
Mark.

At this moment my RS is running. Thank you by your help!!

Here i show you the first commands i used on my RS .

:) :) :) :) :) :) :) :) Thank you AGain!! :) :) :) :) :) :) :) :)


------------------------------------------------

1> admin disk_space
2> go
Partition

Logical Part.Id Total Segs Used
Segs
State

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------- ----------- -----------
-----------
-------------------------------
/opt/rep-12.5/stable_queues/part1

part1 101 1020
0
ON-LINE//
1> admin echo, hola
2> go
echo
----
hola
1> admin health
2> go
Mode Quiesce Status
---------------- -------- --------
NORMAL TRUE HEALTHY

Ivana Veselinovic

unread,
May 3, 2007, 6:46:27 AM5/3/07
to
Hello!
How to set up environment variable on LINUX, Sybase Replication Server?


Ivana Veselinovic

unread,
May 3, 2007, 7:00:18 AM5/3/07
to
Hello!
How to set environment variable on LINUX, for my Sybase replication server?


Ivana Veselinovic

unread,
May 3, 2007, 7:03:21 AM5/3/07
to
Hello!

How to set environment variable on LINUX for my Sybase replication server?


Luc Van der Veurst

unread,
May 3, 2007, 7:08:47 AM5/3/07
to

"Ivana Veselinovic" <iva...@gmail.com> wrote in message
news:4639c0c2$1@forums-1-dub...

> How to set environment variable on LINUX, for my Sybase replication
> server?

The installation directory contains some files named SYBASE.*. The extension
refers to
different unix shells: csh for c-shell, sh for sh/ksh.

You set these variables by 'sourcing' the script into the current shell,
i.e.
source SYBASE.csh (for cshell environment)
or
. SYBASE.sh (for bourne/kornshell environments)

Luc.


Ivana Veselinovic

unread,
May 4, 2007, 4:38:18 AM5/4/07
to
Hi!

Can you tell me how to do 'sourcing' the script into the current shell? I
have SYBASE.csh and SYBASE.sh on my computer,

But I still don't know how to set environment variables.

Thank you!

Ivana

Tommy Phillips

unread,
Jul 18, 2007, 4:42:27 PM7/18/07
to
Ivana Veselinovic wrote:
> Hello!
>
> How to set environment variable on LINUX for my Sybase replication server?
>
>
Ivana-

I hope you have been able to make progress with this, and I hope someone
was able to help you.

Just in case, here are some pointers:

If you are running ksh, ash, or bash, use ". SYBASE.env"

If you are running csh or tcsh (?), use "source SYBASE.csh"

I'm not sure what the correct command is for zsh.

However, if you are really that green about Unix/Linux commands, you are
likely to have a lot more problems with running a Sybase installation
than just how to set environment variables. Good luck.

-Tommy Phillips

0 new messages