hi andre,OK on a SuSE Linux 7.3 machine I did:
i could not locate the error.
1)is it possible to load the catalog with the statement.
repmcli -d <database_name> -u dba,dba -b '/tmp/cat.dmp' ?
2)had you the same behaviour with version 7.3.0.20?
> rpm -Uvh sapdb-ind-7.3.0.20-1.i386.rpm sapdb-srv-7.3.0.20-1.i386.rpm
sapdb-testdb-7.3.0.20-1.i386.rpm
sapdb-ind
##################################################
sapdb-srv
##################################################
sapdb-testdb
##################################################
> cd /opt/sapdb/depend/pgm/
> tar zxvf /opt/download/sapdb/sapdb-lserversrv-linux-32bit-i386-7.3.1.1.tgz
> chown root:sapdb lserversrv
> repmcli -u dba,dba -d TST -b export_cat.cmd
Opened connection to REPLICATION SERVER at node local host.
REPLICATION SERVER Log File: '/var/opt/sapdb/indep_data/wrk/repserver.log'
User dba connected to database TST on local host.
CATALOGEXTRACT ALL OUTFILE '/tmp/cat.dmp'
Successfully executed
(It all seems ok, but see the logfile below, and where is the user TEST in cat.dmp)
file: export_cat.cmd
------------------------------------------------------------------------------------------------------------
CATALOGEXTRACT ALL OUTFILE '/tmp/cat.dmp'
------------------------------------------------------------------------------------------------------------
generated file: '/tmp/cat.dmp'
------------------------------------------------------------------------------------------------------------
SQLMODE INTERNAL
/ *
/ *
USE USER DBA initial
------------------------------------------------------------------------------------------------------------
logfile: /var/opt/sapdb/indep_data/wrk/repserver.log
------------------------------------------------------------------------------------------------------------
/ M ReplMan 7.3.1
Build 001-000-000-000
/ *
/ M Starting protocol at 2002021400115642
/ *
/ *
/ *
/ M START 20020214
00115642
/ *
set logowner root
/ *
/ M START 20020214
00115642
/ *
set
/ *
/ M START 20020214
00115642
/ *
USE USER dba * SERVERDB TST
/ *
/ M USER: 'DBA'
on DB: 'TST'
/ *
/ M START 20020214
00115642
/ *
CATALOGEXTRACT ALL OUTFILE '/tmp/cat.dmp'
/ *
/ M Releasing user connection (USER: 'DBA').
/ *
/ E -25331: This is a restricted statement,
user must be SYSDBA.
SELECT ROLE,PASSWORD_REQUIRED FROM DOMAIN.ROLES
/ *
/ E -25392: '[SAP AG][LIBSQLOD SO]Function
sequence error.'
SELECT OWNER,SEQUENCE_NAME,INCREMENT_BY,LAST_NUMBER,MAX_VALUE,MIN_VALUE,CYCLE_FLAG,CACHE_SIZE,ORDER_FLAG
FROM DOMAIN.SEQUENCES
/ *
/ E -25392: '[SAP AG][LIBSQLOD SO]Function
sequence error.'
SELECT DEFINITION, DBPROCNAME, OWNER, COMMENT FROM DOMAIN.DBPROCEDURES
WHERE definition IS NOT NULL
/ *
/ E -25392: '[SAP AG][LIBSQLOD SO]Function
sequence error.'
/ M Number of tables extracted: 0
/ *
/ M Number of views extracted: 0
/ *
/ M Number of synonyms extracted: 0
/ *
/ M Releasing user connection (USER: 'DBA').
/ *
------------------------------------------------------------------------------------------------------------
> repmcli -u dba,dba -d TST -b import_cat.cmd
will produce the following error: (because of the damaged export?)
-----------------------------------------------------------------
CATALOGLOAD ALL INFILE '/tmp/cat.dmp'
Error during execution
-->
Defined maximum number of errors (1) reached
1 error(s) during execution of command file 'import_cat.cmd'.
---> See log file(s) for more information.
Some error(s) occurred running command.
---> See log file(s) for more information.
-----------------------------------------------------------------
logfile:
-----------------------------------------------------------------
/ M ReplMan 7.3.1
Build 001-000-000-000
/ *
/ M Starting protocol at 2002021400120359
/ *
/ *
/ *
/ M START 20020214
00120359
/ *
set logowner root
/ *
/ M START 20020214
00120359
/ *
set
/ *
/ M START 20020214
00120359
/ *
USE USER dba * SERVERDB TST
/ *
/ M USER: 'DBA'
on DB: 'TST'
/ *
/ M START 20020214
00120359
/ *
CATALOGLOAD ALL INFILE '/tmp/cat.dmp'
/ *
/ M Releasing user connection (USER: 'DBA').
/ *
/ E -25331: This is a restricted statement,
user must be SYSDBA.
-----------------------------------------------------------------
--
_____________________________________________
inworks GmbH
Andre Reitz
Magirusstrasse 44 Tel. 0731/93 80 7-21
89077 Ulm
http://www.inworks.de
