SAP ERP升级数据库Sybase ASE

桃扇骨 2022-08-02 05:42 246阅读 0赞

# 一、 背景 #

SAP ERP 需要将数据库Sybase ASE 升级到版本16.0.    SAP现在的系统是Linux SUSE.

SAP    <SID>是WEN

# 二、步骤 #

## 1、Stop the SAP and ASE ##

su wenadm  
$>stopsap

## 2、Download the ase software ##

*  Download the software from the SAP Service Marketplace.**   **Open the SAP Software Download Center at [http://service.sap.com/swdc][http_service.sap.com_swdc]

我是用FTP从其他 服务器下载.

\-------------------------------------------------------------------------------------  
cd /remote/pbi\_archive10/archives/images/ase/160/asecorona\_beta\_3/c1/output/linuxamd64  
  
  
ftp> get ASE\_Suite.linuxamd64.tgz  
  
  
tar   zxvf  ASE\_Suite.linuxamd64.tgz

## 3、installation ##

/abaptest/soft/newase  是step 2 解压目录

mo:/sybase/WEN/ASE-16\_0/install \# su sybwen  
mo ASE-16\_0/install> cd /abaptest/soft/newase/ASE\_Suite  
mo newase/ASE\_Suite> ./setup.bin

然后根据情况, 在命令行下作选择。。直到安装到步骤Update SAP ASE 报错：

===============================================================================  
Update SAP ASE  
\--------------  
  
  
\----------------------------------------  
Updating SAP ASE 'WEN'  
\----------------------------------------  
Updating SAP Adaptive Server Enterprise 'WEN'...  
Start SAP Adaptive Server Enterprise ...  
SAP Adaptive Server Enterprise failed to start.  
Updating SAP Adaptive Server Enterprise failed.  
Exit status = 4  
The installer could not update SAP ASE 'WEN'.  Correct the errors described in  
output file '/sybase/WEN/log/updatease.out', then run  
'/sybase/WEN/ASE-16\_0/bin/updatease -D/sybase/WEN -SWEN'.  
Failed to Update SAP ASE

然后打开数据库日志（/sybase/WEN/log/updatease.out  里面没有什么信息，查看数据库日志如下），查看错误：

/sybase/WEN/ASE-16\_0/install \# vi WEN.log

00:0000:00000:00000:2015/07/09 08:58:37.65 kernel  SySAM: Using licenses from: /sybase/WEN/SYSAM-2\_0/licenses/ASE\_160SP02\_Beta.lic:/sybase/WEN/SYSAM-2\_0/licenses/Nightly.lic  
00:0000:00000:00000:2015/07/09 08:58:37.67 kernel  SySAM: Checked out license for 20 ASE\_CORE (2015.0930/30-sep-2015/0127 239B 9CAE 70DD) will expire Thu 01 Oct 2015 12:00:00 AM UTC.  
00:0000:00000:00000:2015/07/09 08:58:37.67 kernel  Error: 131274, Severity: 17, State: 1  
00:0000:00000:00000:2015/07/09 08:58:37.67 kernel  SySAM: WARNING: ASE will shutdown on Thu 01 Oct 2015 12:00:00 AM UTC, unless a suitable ASE\_CORE license is obtained before that date.  
00:0000:00000:00000:2015/07/09 08:58:37.67 kernel  This product is licensed to: Evaluation License. No Commercial or Production use permitted.  
00:0000:00000:00000:2015/07/09 08:58:37.67 kernel  Checked out license ASE\_CORE  
00:0000:00000:00000:2015/07/09 08:58:37.67 kernel  Adaptive Server Enterprise (Enterprise Edition)  
00:0000:00000:00000:2015/07/09 08:58:37.68 kernel  Using config area from primary master device.  
00:0000:00000:00000:2015/07/09 08:58:37.68 server  Configuration Error: Configuration file, '/sybase/WEN/ASE-16\_0/WEN.cfg', does not exist.

主要有两个错误：

一个 是关于license的

解决办法参见：[http://blog.csdn.net/wengyupeng/article/details/46804245][http_blog.csdn.net_wengyupeng_article_details_46804245]

一个Configuration file  WEN.cfg, does not exist.  是因为权限导致的,  当前用户是sybwen  WEN.cfg文件是root权限.

解决办法：用root 账号Login去执行命令，如下

mo: ASE-16\_0/install> exit

mo:/sybase/WEN/ASE-16\_0/install \#  /sybase/WEN/ASE-16\_0/bin/updatease -D/sybase/WEN -SWEN  
ASE Password:  
Updating SAP Adaptive Server Enterprise 'WEN'...  
Start SAP Adaptive Server Enterprise ...  
SAP Adaptive Server Enterprise has been started.  
Unable to login to server 'WEN'. Please check if the specified login password  
is correct.  
Updating SAP Adaptive Server Enterprise failed.

可以看到 ASE 已经启动，只是登录失败。

mo:/sybase/WEN/ASE-16\_0/install \# isql64 -Usapsso  -SWEN -X

输入正确的密码后，可以登录成功。

## 4、 Execute Sybase installation scripts. ##

The script must be executed with login "sa". As the "sa" login is usually locked, you may first need to unlock the "sa" login.

1> sp\_locklogin 'sa', 'unlock'  
2> go  
Account unlocked.

#### a、Run the scripts: ####

mo:/sybase/WEN/ASE-16\_0/install \# su sybwen  
mo:ASE-16\_0/install> cd ..  
mo:WEN/ASE-16\_0> cd scripts  
  
isql64 -Usa -SWEN -iinstallmaster -X -o/sybase/WEN/ASE-16\_0/install/runscript.log  
isql64 -Usa -SWEN -iinstallcommit -X -o/sybase/WEN/ASE-16\_0/install/runscript.log  
isql64 -Usa -SWEN -iinstmsgs.ebf -X -o/sybase/WEN/ASE-16\_0/install/runscript.log  
isql64 -Usa -SWEN -iinstalljsdb -X -o/sybase/WEN/ASE-16\_0/install/runscript.log

####    b 、Restart the job scheduler ####

mo:ASE-16\_0/scripts> isql64 -Usa -SWEN  -X  
1> sp\_configure "enable job scheduler", 1  
2> go  
  
1> exec sybmgmtdb..sp\_js\_wakeup "start\_js", 1  
2> go

#### C 、Run the syb\_update\_db.sql script.   ####

see [ SAP Note 1602547, ][SAP Note 1602547_]also you can copy the script in the followin link [ https://websmp206.sap-ag.de/~sapidb/012006153200000646122012E/syb\_update\_db.txt][https_websmp206.sap-ag.de_sapidb_012006153200000646122012E_syb_update_db.txt]              
  
  
  
1> exit  
mo-1333b8cb7 ASE-16\_0/scripts> vi syb\_update\_db.sql

copy [https://websmp206.sap-ag.de/~sapidb/012006153200000646122012E/syb\_update\_db.txt][https_websmp206.sap-ag.de_sapidb_012006153200000646122012E_syb_update_db.txt]    里面的脚本到syb\_update\_db.sql  
  
执行（因为ASE是64位，所以用isql64 ,用isql 去执行这个会报一个错）：

isql64 -Usa -SWEN -w999 -i syb\_update\_db.sql -X -o /sybase/WEN/ASE-16\_0/install/syb\_update\_db.log

## 5、Verify the database version and start Sap ##

`isql64 -Usa -SWEN -X`

` ``1``> select @``@version`

` ``2``> go`

` ``1``> select @``@sbssav`

` ``2``> go `

` 1> exit`

mo:/sybase/WEN/ASE-16\_0/install \# su wenadm  
mo:wenadm 52> startsap

#  三、参考 #

Update Sybase ASE 15.7 database server [https://wiki.wdf.sap.corp/wiki//pages/viewpage.action?pageId=1151038597][https_wiki.wdf.sap.corp_wiki_pages_viewpage.action_pageId_1151038597]

This document is based in the SAP Note 1599814 [https://service.sap.com/sap/support/notes/1599814][https_service.sap.com_sap_support_notes_1599814]

[http_service.sap.com_swdc]: http://service.sap.com/swdc
[http_blog.csdn.net_wengyupeng_article_details_46804245]: http://blog.csdn.net/wengyupeng/article/details/46804245
[SAP Note 1602547_]: https://websmp130.sap-ag.de/sap%28bD1lcyZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1602547
[https_websmp206.sap-ag.de_sapidb_012006153200000646122012E_syb_update_db.txt]: https://websmp206.sap-ag.de/~sapidb/012006153200000646122012E/syb_update_db.txt
[https_wiki.wdf.sap.corp_wiki_pages_viewpage.action_pageId_1151038597]: https://wiki.wdf.sap.corp/wiki//pages/viewpage.action?pageId=1151038597
[https_service.sap.com_sap_support_notes_1599814]: https://service.sap.com/sap/support/notes/1599814