From: Michael Jürgens (infohunnenburg.de)
Date: Tue Oct 12 2004 - 01:21:07 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,
thanks for your quick reply.
So far so good.
But now we have a problem with our "transport script" which is
responsible to transport the database from our production environment to
our test environment.
It is nearly the same as described in
http://dev.mysql.com/doc/maxdb/en/52/6942db89e5914496483a576b0b9749/content.htm
.
In the step
        dbmcli -d TST1 -u dbm,dbm util_execute INIT CONFIG
I get the response:
> [exec] ---
> [exec] >
> [exec] >
> [exec] >db_admin
> [exec] OK
>
> [exec] ---
> [exec] >util_connect
> [exec] OK
>
> [exec] ---
> [exec] >util_execute INIT CONFIG
> [exec] ERR
> [exec] -24988,ERR_SQL: sql error
> [exec] -3008,Invalid keyword or missing delimiter
>
> [exec] ---

My knldiag is:
> 2004-10-12 08:10:05 31894 11570 startup complete
> 2004-10-12 08:10:05 31895 11561 COMMUNIC Connecting T52 local 31831
> 2004-10-12 08:10:05 31903 11561 COMMUNIC Connected T52 local 31831
> 2004-10-12 08:10:05 31903 11560 COMMUNIC Releasing T52
> 2004-10-12 08:10:05 31903 12929 TASKING Task T52 started
> 2004-10-12 08:10:05 31903 11007 COMMUNIC wait for connection T52
> 2004-10-12 08:10:05 31895 11561 COMMUNIC Connecting T52 local 31831
> 2004-10-12 08:10:05 31903 11561 COMMUNIC Connected T52 local 31831
> 2004-10-12 08:10:05 31895 WNG 11835 COMMUNIC UTILITY is busy state 28 conn 1097561405
> 2004-10-12 08:10:05 31895 WNG 11832 COMMUNIC rejecting request
> 2004-10-12 08:10:05 31903 11560 COMMUNIC Releasing T52
> 2004-10-12 08:10:05 31903 12929 TASKING Task T52 started
> 2004-10-12 08:10:05 31903 11007 COMMUNIC wait for connection T52
> 2004-10-12 08:10:08 31895 11561 COMMUNIC Connecting T52 local 31831
> 2004-10-12 08:10:08 31903 11561 COMMUNIC Connected T52 local 31831
> 2004-10-12 08:10:08 31903 11560 COMMUNIC Releasing T52
> 2004-10-12 08:10:08 31903 12929 TASKING Task T52 started
> 2004-10-12 08:10:08 31903 11007 COMMUNIC wait for connection T52

Any ideas about the failure.

regards,

Michael

Schmoger, Daniel wrote:
> Hi Michael,
> sorry, there is no such way.
> you can update using the following steps:
>
> 1. create a backup of your database.
> 2. unregister database:
> dbmcli -d <db name> -u <dbm user>,<dbm passwd> db_offline
> dbmcli -d <db name> -u <dbm user>,<dbm passwd> db_drop WITHOUTFILES
> 3. stop communication server:
> x_server stop
> 4. become root user:
> su -
> 5. remove software:
> rpm -e `rpm -qa | grep sapdb`
> 6. remove old software configs:
> rm -rf /var/spool/sql
> 7. install new software:
> rpm -Uhv maxdb-*.rpm
> 8. add your os user to db admin group:
> usermod <os user> -G <your group list>,sdba
> 9. move parameter files and rundirectory:
> mv /var/opt/sapdb/indep_data/config/<db name>* /var/opt/sdb/data/config/
> mv /var/opt/sapdb/indep_data/wrk/<db name> /var/opt/sdb/data/wrk/
> chown -R sdb.sdba /var/opt/sdb/data/config/ /var/opt/sdb/data/wrk
> 10. chown sdb.sdba for all volumes and backups
> 11. become your os user:
> su - <os user>
> 12. set evironment:
> export PATH=/opt/sdb/programs/bin:$PATH
> export LD_ASSUME_KERNEL=2.2.20
> 13. start communication server:
> x_server start
> 14. register your database with new software:
> dbmcli -R /opt/sdb/7500 db_create <db name> <dbm user>,<dbm passwd>
> 15. change rundir paramater:
> dbmcli -d <db name> -u <dbm user>,<dbm passwd> param_directput RUNDIRECTORY /var/opt/sdb/data/wrk/<db name>
> 16. restart database:
> dbmcli -d <db name> -u <dbm user>,<dbm passwd> db_online
> 17. load system tables:
> dbmcli -d <db name> -u <dbm user>,<dbm passwd> load_systab
> 18. remove old files:
> rm -rf /var/opt/sapdb /opt/sapdb
>
>
> HTH,
> daniel
>
>
>
>>-----Original Message-----
>>From: Michael Jürgens [mailto:infohunnenburg.de]
>>Sent: Donnerstag, 7. Oktober 2004 08:10
>>To: maxdblists.mysql.com
>>Subject: rpm upgrade Question
>>
>>
>>Hi,
>>
>>does anybody know how to upgrade from rpm sapdb-srv74-7.4.3.32 to
>>maxdb-srv75-7.5.0.18 without first erase and then install ?
>>I´m a little bit afraid to loose some configuration.
>>
>>regards,
>>
>>Michael
>>
>>
>>--
>>MaxDB Discussion Mailing List
>>For list archives: http://lists.mysql.com/maxdb
>>To unsubscribe:
>>http://lists.mysql.com/maxdb?unsub=daniel.schmogersap.com
>>
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]