用orapwd 重建password 文件.
1. set up the environment to use Password Authentication A. remove any existing users in the NT/2000 user group ORA_DBA or ORA_<sid>_DBA
( I think this step is very important but easy to be ignored )
B. set the REMOTE_LOGIN_PASSWORDFILE parameter in init.ora to
EXCLUSIVE or SHARED
C. set SQLNET.AUTHENTICATION_SERVICES parameter in sqlnet.ora to NONE
2. now set the password for internal and sys
shutdown database
orapwd file=pwd<sid>.ora password=black_snail entries=10
be sure to place the file in the same location of initsid.ora ( as the default location )
startup
3. now you can connect as sysdba by using password file authentication
try this to see the difference between internal Vs sys and sysdba Vs sysoper
1. set up the environment to use Password Authentication A. remove any existing users in the NT/2000 user group ORA_DBA or ORA_<sid>_DBA
( I think this step is very important but easy to be ignored )
B. set the REMOTE_LOGIN_PASSWORDFILE parameter in init.ora to
EXCLUSIVE or SHARED
C. set SQLNET.AUTHENTICATION_SERVICES parameter in sqlnet.ora to NONE
2. now set the password for internal and sys
shutdown database
orapwd file=pwd<sid>.ora password=black_snail entries=10
be sure to place the file in the same location of initsid.ora ( as the default location )
startup
3. now you can connect as sysdba by using password file authentication
try this to see the difference between internal Vs sys and sysdba Vs sysoper
解决方案 »
- 请教数据库大牛
- 怎么样用户SYS,查非SYS模式下extents?
- 安装Oracle11GR2:用VMware装的CentOS,想在其上安装Oracle11GR2,到了最后的检测出现如下错误
- 紧急求救,数据库执行like语句效率问题
- 看看这个oracle语句有什么错误?
- oracle分区表的分区列需要另外建索引吗?
- 求一语句,在线等。。。立即结! ̄
- 请问安装ORACLE8.16客户端时不成功?
- 能在存储过程中新建或删除一个表吗?
- ORACLE中如何调用存储过程
- 高分求解:win2000 SERVER不能装oracle 8.0?
- 我创建了stu表,但为什么用describe命令它总说对象stu不存在?
oracle\ora90\rdbms\utlpwdmg.sql
中将
SQLNET.AUTHENTICATION_SERVICES= (NONE)
中的NONE改为NTS,即:
SQLNET.AUTHENTICATION_SERVICES= (NTS)修改密码后将此参数改回为none不过碰到过有的机器没有sqlnet文件,那就试试楼上的哈.
alter user SYSTEM identified by password;
HQ.Wang 海清