sybase sa密码重置

		

	 

	sa 密码忘记解决之道

	 

	1、编辑/opt/sybase/ASE-*/install下的RUN_servernamee在最后加上-psa

	 

	2、然后重启sybase<记得先kil lsybase进程>：

	# cd /opt/sybase/ASE-*/install/

	#. /opt/sybase/SYBASE.sh

	# ./startserver -f ./RUN_DBSVR

	 

	在输出控制台搜索password 关键字即可找到新密码。

	===========================================================================

	00:00000:00001:2006/10/31 08:04:02.52 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.

	00:00000:00001:2006/10/31 08:04:02.52 server  Checking external objects.

	00:00000:00001:2006/10/31 08:04:02.53 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb.

	00:00000:00001:2006/10/31 08:04:02.60 server  Database 'sybsystemprocs' is now online.

	 

	New SSO password for sa:hactgvzwzgfbv3

	 

	00:00000:00011:2006/10/31 08:04:02.62 kernel  network name 10.71.214.209, interface IPv4, address 10.71.214.209, type tcp, port 4100, filter NONE

	00:00000:00011:2006/10/31 08:04:02.62 kernel  A listener with protocol tcp, host 10.71.214.209, port 4100, engine 0 already exists.

	00:00000:00011:2006/10/31 08:04:02.62 kernel  network name 127.0.0.1, interface IPv4, address 127.0.0.1, type tcp, port 4100, filter NONE

	01:00000:00000:2006/10/31 08:04:02.91 kernel  Network and device connection limit is 19970.

	01:00000:00000:2006/10/31 08:04:02.91 kernel  ASE - Dynamic Pluggable Component Interface is disabled

	....................................

	===============================================================================

	 

	3、然后使用如下命令改回来你需要的密码即可：

	exec   sp_password   'hactgvzwzgfbv3', '111111', 'sa'

	go

	 

	 

	4、最后

	编辑/opt/sybase/ASE-*/install下的RUN_servername 删除-psa 行

	摘自 velex的专栏
						
		
	

上一个：看Sybase官方手册学索引工作原理
下一个：SybaseIQ语句之BEGIN ATOMIC子句