用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
解决方案 »
- 如何批量将csv文件,批量导入数据库表?
- 10g exp问题ORACLE error 4021
- ORACLE9i中PGA和hash/sort_area_size的困惑?
- 求一个plsql的写法
- 怀旧,散分。
- PROC预编译成功后,CC 时报的错,请高手看一下是什么问题?sunos5.9
- 急助:朋友的一份Oracle DBA的Take Home Exam,全英文,谁能帮忙回答?
- 请问我如何把表中所有记录,用一个列的值去更改另外一个列的值
- 透明网关怎么安装?
- 在PL/SQL中,如何对文件进行删除操作!!!!
- 高分求解: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 海清