由于Oracle安装好后一直没有修改缺省密码,后来发现密码竟然被修改掉了,没办法只有重设
$>sqlplus /nolog
SQL>conn / as sysdba
SQL>alter user system identified by [password]
SQL>quit不过走到
SQL>alter user system identified by [password]
这里时,我用命令
alter user system identified by
或alter user system identified by 1
或alter user system identified by '1'
或alter user system identified by "1"都会出现SQL> alter user sys identified by "1"
2 _
然则光标就停在2后面啦,大家说说我哪里做错啦,谢谢
$>sqlplus /nolog
SQL>conn / as sysdba
SQL>alter user system identified by [password]
SQL>quit不过走到
SQL>alter user system identified by [password]
这里时,我用命令
alter user system identified by
或alter user system identified by 1
或alter user system identified by '1'
或alter user system identified by "1"都会出现SQL> alter user sys identified by "1"
2 _
然则光标就停在2后面啦,大家说说我哪里做错啦,谢谢
解决方案 »
- Pl/sql小题目 明白的指点一下
- [求教]双表多值select问题
- 请教PB + ORALCE 查询条件的写法
- 查询条件in
- 怎样提高删除的效率,请各位高手看看?
- 如何直接将select出来的多条记录放入RECORD多维数组里?
- 解释一段代码的意思???????高手帮忙?????
- Oracle9i为什么我就不能安装
- 如何让系统自动解锁啊!---顺便散分
- 在linux地下,安装oracle时,执行 rpm -ivh compat-egcs-c++-6.2-1.1.2.16.i386.rpm时出错!
- 3张表,结构完全一样,A,B,C表,我能从A表同时INSERT记录到B表和C表马?
- 分组求一列当中第N大的记录,有点难度哦
你用set lines 100试试
SQL> alter user sys identified by "1"
2 _
时按回车键就回到
SQL>
user system
password system
还是提示密码不对,是什么时候原因呢?
ERROR
ORA-01017: invalid username/password; logon denied
Warning: You are on longer connected to ORACLEthe sysdba trick is generally used to allow other NON-SYS users to connect btw,
best to use your OWN account that has been granted sysdba!$ orapwd file=orapw password=foobar entries=40I just recreated my password file with a password foobar. My sys password is
NOT foobar
SVRMGR> alter user sys identified by change_on_install;
Statement processed.
SVRMGR> connect sys/change_on_install@ora816dev as sysdba;
Connected.
SVRMGR>
http://www.dbonline.cn/source/oracle/20040211/STR_database%20password%20file%20use%20and%20maintain(1).htmlhttp://www.dbonline.cn/source/oracle/20040211/STR_database%20password%20file%20use%20and%20maintain(2).html
你找一个知道密码实例的orapwxxx.init文件,覆盖该文件或许可以