运行 cmd 按如下输入命令 sqlplus / as sysdba ---------以sys登陆 alter user 用户名 account unlock; --------- 解除锁定 alter user 用户名 identified by 密码 -------------修改密码
[oracle@ora10g ~]$ orapwd help=y Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> where file - name of password file (mand), password - password for SYS (mand), entries - maximum number of distinct DBA and force - whether to overwrite existing file (opt), OPERs (opt), There are no spaces around the equal-to (=) character. 这里的password就是sys的密码,sys可以在这边改,system就用sys来改
SQLNET.AUTHENTICATION_SERVICES
passwordos认证方式,需要到服务器所在的机器上操作。
sqlplus / as sysdba ---------以sys登陆
alter user 用户名 account unlock; --------- 解除锁定
alter user 用户名 identified by 密码 -------------修改密码
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and force - whether to overwrite existing file (opt),
OPERs (opt),
There are no spaces around the equal-to (=) character.
这里的password就是sys的密码,sys可以在这边改,system就用sys来改
我操作了下,显示一个控制台的框,一闪而过,根本不能修改
conn /as sysdba
alter user sys identified by sys
一直这么改的,没见过报错
alter user your_name identified by your_pwd
远程就要操心了
sqlplus sys/sys as sysdba
可以用sys用户以dba的身份连进去,然后就可以改了。用工具和语句都可以。