如果忘记sa用户的密码可以使用如下的方法来重置或解锁sa的密码

参考sap note:1945193

一、关闭ASE数据库

hana2:/sofware # cd /sybase/T66/

hana2:/sybase/T66 # source SYBASE.sh

hana2:/sybase/T66 # export LANG=C

hana2:/sybase/T66 #  isql -Usapsa -PASE16\_test -ST66 -X

hana2:/sybase/T66 # isql -Usapsa -PASE16\_test -ST66 -X

1> shutdown

2> go

Server SHUTDOWN by request.

ASE is terminating this process.

CT-LIBRARY error:

        ct\_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

二、在RUN_servername文件中添加-T4044 -psa参数.

inspur5:/sybase/T66/ASE-16_0/install # cd /sybase/T66/ASE-16_0/install

inspur5:/sybase/T66/ASE-16_0/install # cat RUN_T66

#!/bin/sh

# SAP Adaptive Server Enterprise page size (KB):        16k

# Master device path:   /sybase/T66/sybsystem/master.dat

# Error log path:       /sybase/T66/ASE-16_0/install/T66.log

# Configuration file path:      /sybase/T66/ASE-16_0/T66.cfg

# Directory for shared memory files:    /sybase/T66/ASE-16_0

# License properties file:      /sybase/T66/ASE-16_0/sysam/T66.properties

# Interfaces file directory:    /sybase/T66

# SAP Adaptive Server Enterprise name:  T66

/sybase/T66/ASE-16_0/bin/dataserver \

-d/sybase/T66/sybsystem/master.dat \

-e/sybase/T66/ASE-16_0/install/T66.log \

-c/sybase/T66/ASE-16_0/T66.cfg \

-M/sybase/T66/ASE-16_0 \

-N/sybase/T66/ASE-16_0/sysam/T66.properties \

-i/sybase/T66 \

-sT66  \

-T4044 -psa \

三、启动ASE数据库，在启动的控制终端窗口中会显示新的密码

/sybase/T66/ASE-16_0/bin/startserver -f /sybase/T66/ASE-16_0/install/RUN_T66

四、使用启动控制界面中的密码登录数据库，并解锁sa用户和重置sa的密码

inspur5:/sybase/T66/ASE-16\_0/install # isql -Usa -Pqedahlqmtcypg6 -ST66 -X

1> sp\_locklogin sa,'unlock'

2> go

Account unlocked.

(return status = 0)

1> sp\_password qedahlqmtcypg6,ASE16\_test,sa

2> go

Password correctly set.

(return status = 0)

五、把RUN_servername文件中的-T4044 -psa参数移除后，重启ASE数据库即可正常使用sa登录.

inspur5:/sybase/T66/ASE-16_0/install # isql -Usa -PASE16_test -ST66 -X

1> sp_helpdb

2> go