是立即生效,不需要重起数据库你的可能是未修改成功,语句应该如下:
sql>alter user user_name identified by password;
eg:
sql>alter user system identified by manager123;
sql>alter user user_name identified by password;
eg:
sql>alter user system identified by manager123;
看看行不行