暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

解锁ASE数据库中sa用户账户

原创 七七 2022-06-16
1939

当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

 

 

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论