当sa用户的密码忘记或sa用户被锁定时,可以使用如下方法进行解锁和重置sa用户的密码。
1. 关闭ASE数据库
isql
>shutdown
>go
2. 在RUN_servername文件中添加-T4044
-psa参数.
inspur5:/sybase/T66/ASE-16_0/install # pwd
/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 \
3. 启动ASE数据库,在启动的控制终端窗口中会显示新的密码
/sybase/T66/ASE-16_0/bin/startserver -f /sybase/T66/ASE-16_0/install/RUN_T66
00:0002:00000:00002:2022/06/15 07:04:30.13 server Started ANALYSIS pass for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.13 server Completed ANALYSIS pass for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.13 server Log contains all committed transactions until 2022/06/15 07:03:44.28 for database sybsystemprocs.
00:0002:00000:00002:2022/06/15 07:04:30.13 server Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:0002:00000:00002:2022/06/15 07:04:30.13 server Completed REDO pass for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.14 server Timestamp for database 'sybsystemprocs' is (0x0000, 0x0014f63c).
00:0002:00000:00002:2022/06/15 07:04:30.14 server Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:0002:00000:00002:2022/06/15 07:04:30.14 server Started recovery checkpoint for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.14 server Completed recovery checkpoint for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.14 server Started filling free space info for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.14 server Completed filling free space info for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.14 server Started cleaning up the default data cache for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.15 server Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:0002:00000:00002:2022/06/15 07:04:30.15 server Checking external objects.
00:0002:00000:00002:2022/06/15 07:04:30.15 server The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb.
00:0002:00000:00002:2022/06/15 07:04:30.15 server Database 'sybsystemprocs' is now online.
New password for user with manage security permissions sa:qedahlqmtcypg6
00:0002:00000:00015:2022/06/15 07:04:30.15 kernel network name inspur5, interface IPv4, address 10.59.7.56, type tcp, port 4901, filter NONE
00:0005:00000:00000:2022/06/15 07:04:30.15 kernel Thread 5 (LWP 48449) of Threadpool syb_default_pool online as engine 3
00:0016:00000:00000:2022/06/15 07:04:30.15 kernel Thread 16 (LWP 48462) of Threadpool syb_default_pool online as engine 14
4. 使用启动控制界面中的密码登录数据库,并解锁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)
5. 把RUN_servername文件中的-T4044
-psa参数移除后,重启ASE数据库即可正常使用sa登录.
inspur5:/sybase/T66/ASE-16_0/install # isql -Usa -PASE16_test -ST66 -X
1> sp_helpdb
2> go




